Loading...
 

Personal Info Functions

Most Frequently Used Personal Info Functions in Argos:

  • mv_ID ( PIDM ) returns: M or FOR number of a student
  • mv_SSN_byID ( ID# ) returns: SSN number of a student for M#
  • mv_SSN_byPIDM ( PIDM ) returns: SSN number of a student pidm
  • mv_SSN_byPIDM_Formated ( PIDM ) returns: Formatted '###-##-####' SSN number
  • mv_PIDM_byID ( ID# ) returns: PIDM number of a student for M#
  • mv_PIDM_bySSN ( SSN# ) returns: PIDM number of a student for SSN
  • mv_PIDM_byIDorSSN ( ID# ) returns: PIDM number of a student for M# or SSN
  • mv_PIDM_byISO ( ISO# ) returns: PIDM number of a student for ISO (16-digit) number
  • mv_PIDM_byEmail ( EMAIL ) returns: PIDM number of a student for Email Address
  • mv_PIDM_byPOSN ( POSN_CODE ) returns: PIDM by Employee Position Code (NBRBJOB_POSN)
  • mv_SIRS_PIN ( PIDM ) returns: PIN number for SIRS online login
  • mv_PreferredName ( PIDM ) returns: person Preferred Name (SPBPERS_PREF_FIRST_NAME)
  • mv_Name_Pref ( PIDM, 'FML' ) works the same way as mv_Name below only Preferred name returned instead of First name if available otherwise First name is returned.
  • mv_Name ( PIDM, 'FML' )
    • returns: First Middle Last name of a student for ‘FML’ parameter.
    • returns: Last, First Middle name of a student for ‘LFM’ parameter.
    • returns: First Last name of a student for ‘FL’ parameter.
    • returns: Last name of a student for ‘L’ parameter.
    • returns: First name of a student for ‘F’ parameter.

  • mv_DOB ( PIDM ) returns: Date Of Birth of a person for the input PIDM
  • mv_Age ( PIDM ) returns: Age of a person for the input PIDM
  • mv_Gender ( PIDM ) returns: Gende/Sex of a person SPBPERS_SEX
  • mv_Gender_Identity ( PIDM ) returns: Gender identity code of a person SPBPERS_GNDR_CODE
  • mv_Personal_Pronoun ( PIDM ) returns: Personal pronoun code of a person SPBPERS_PPRN_CODE
  • mv_Ethnic_Code ( PIDM ) returns: Ethnic Code of a person SPBPERS_ETHN_CODE
  • mv_New_Ethnicity ( PIDM ) returns: New Ethnicity description of SPBPERS_ETHN_CDE
  • mv_Race_Code ( PIDM ) returns: Race Code of a person GORPRAC_RACE_CDE
  • mv_HispOriginCode_Desc ( PIDM ) returns: Hispanic Origin Code - Description of the SPRYSID_SUNY_ID (SPRYSID_TYPE = 'HISP-ORIG') for the input PIDM

Address Info:
  • mv_Street_line1 ( PIDM, 'PH' ) returns: Home Address Line1 of a student
  • mv_Street_line2 ( PIDM, 'PH' ) returns: Home Address Line2 of a student
  • mv_City ( PIDM, 'PH' ) returns: Home Address City of a student
  • mv_State ( PIDM, 'PH' ) returns: Home Address State of a student
  • mv_Zip ( PIDM, 'PH' ) returns: Home Address Zip-Code of a student
  • mv_County( PIDM, 'PH' ) returns: Home Address County of a student
  • mv_CountyCode( PIDM, 'PH' ) returns: Home Address County Code of a student
  • mv_Nation( PIDM, 'PH' ) returns: Home Address Country Name of a student
  • mv_PrimaryHomePhone ( PIDM ) returns: Primary Home Phone number ('PH') for the input PIDM, formatted as ###-###-####
  • mv_PrimaryMailPhone ( PIDM ) returns: Primary Mailing Address Phone number ('MA') for the input PIDM, formatted as ###-###-####
  • mv_Phone_ByTeleCode ( PIDM, CODE ) returns: a Phone number specified by SPRTELE_TELE_CODE for the input PIDM, formatted as ###-###-####
  • mv_AllPhones ( PIDM ) returns: All Phones (from sprtele table) regardless any indicators for the input PIDM, formatted as ###-###-####, ###-###-####, etc.
  • mv_PrimaryCellPhone ( PIDM, *’Y’ ) returns: Cell Phone number from NY Alert table (SCRYNYC_SHORT_TYPE = 'TXT-MSG'), formatted as (###)###-#### if ‘Y’
  • mv_Email_MVCC ( PIDM, *Preferred ) returns: student MVCC Email address (if omitted then Primary/Preferred indicator set to ‘Y’) for the input PIDM
  • mv_Email_PER ( PIDM ) returns: personal Email address for the input PIDM
  • mv_Email_ALUM ( PIDM ) returns: alumni Email address for the input PIDM
  • mv_Email_BUSS ( PIDM ) returns: business Email address for the input PIDM
  • mv_UserName_FromEmail( in_EMAIL ) returns: User Name part just before @ sign from Email Address

  • mv_Alumni_Street_line1 ( PIDM ) returns: ALUMNI Address Line1 of a graduate
  • mv_Alumni_Street_line2 ( PIDM ) returns: ALUMNI Address Line2 of a graduate
  • mv_Alumni_City ( PIDM ) returns: ALUMNI Address City of a graduate
  • mv_Alumni_State ( PIDM ) returns: ALUMNI Address State of a graduate
  • mv_Alumni_Zip ( PIDM ) returns: ALUMNI Address Zip-Code of a graduate
  • mv_Alumni_Phone ( PIDM ) returns: ALUMNI Address Phone of a graduate