Loading...
 

Admissions “Is” Boolean Functions

Most Frequently Used Admissions “Is” Functions in Argos:

mv_IsDeceased( PIDM )
  • returns: Y if a person is deceased (SPBPERS_DEAD_IND Is Not Null).
  • returns: NULL otherwise.

mv_IsFirstGenerationStudent( PIDM, *TERM )
  • returns: Y if a person is Fist Generation Student (SGRSATT_ATTS_CODE = 'FGS') for given term.
  • returns: NULL otherwise.

mv_IsForeigner( PIDM )
  • returns: Y if a student is a foreigner (SGBSTDN_RATE_CODE = ' 71').
  • returns: NULL otherwise.

mv_Adm_IsForeigner( PIDM, TERM )
  • returns: Y if a student is a foreigner (SARADAP_SITE_CODE = 'INT').
  • returns: NULL otherwise.

mv_IsAcceptWithoutDeposit( PIDM, TERM )
  • returns: Y if a Freshman who has been accepted, but has not returned his Reservation forms (SARADAP_APST_CODE = 'D') for the given term.
  • returns: NULL otherwise.

mv_IsFreshman( PIDM, TERM )
  • returns: Y if a student is actively Accepted (SARADAP_APST_CODE = 'D' or 'P') for the given Term.
  • returns: NULL otherwise.

mv_IsFreshmanTransferred( PIDM, TERM )
  • returns: Y if a student is Freshman with Transfer / Returning / Continuing SARADAP_STYP_CODE In ('T','R','C') for the given Term.
  • returns: NULL otherwise.

mv_Adm_IsEnrolled( PIDM )
  • returns: Y if a student (SARAPPD_APDC_CODE = '80') enrolled to MVCC after 3rd week of classes and record transferred to Registrar.
  • returns: NULL otherwise.
mv_Adm_IsEnrolledInTerm( PIDM, TERM )
  • returns: Y if a student (SARAPPD_APDC_CODE = '80') enrolled (in specific term) to MVCC after 3rd week of classes and record transferred to Registrar.
  • returns: NULL otherwise.
mv_Adm_IsEnrolled_BeforeBanner( PIDM )
  • returns: Y if a student (SARAPPD_APDC_CODE has no record at all) enrolled to MVCC before Banner time.
  • returns: NULL otherwise.

mv_Admission_IsWaitListed( PIDM, TERM )
  • returns: Y if a student is actively Wait Listed (SARADAP_APST_CODE = 'Z' and SARAPPD_APDC_CODE = '30') for the given Term.
  • returns: NULL otherwise.

mv_Admission_IsDormEligible( PIDM, *TERM )
  • returns: Y if a student is Eligible for On-Campus-Housing (SLBRMAP_HAPS_CODE <> 'NE')
  • returns: NULL otherwise.

mv_Admission_IsDormApplicant( PIDM, TERM )
  • returns: Y if a student is a Potential Applicant for Dorm (SARADAP_INTV_CODE = 'H' or 'R') for the given Term.
  • returns: NULL otherwise.

mv_Admission_DormCode( PIDM, TERM )
  • returns: SARADAP_INTV_CODE for On-Campus-Housing for the given Term.
  • returns: NULL otherwise.

mv_Adm_DormCode( PIDM, TERM )
  • returns: SLBRMAP_FROM_TERM for On-Campus-Housing for the given Term.
  • returns: NULL otherwise.

mv_Adm_IsPrintDormLetter( PIDM, TERM )
  • returns: Y if a Denied or Accepted to Dorm letter will be printed (SLBRMAP_HAPS_CODE In ('NE','CA')) for the given Term.
  • returns: NULL otherwise.

mv_Adm_IsAttribute( PIDM, TERM, ATTS )
  • returns: Y if a student has the Attribute provided as a parameter (SARAATT_ATTS_CODE) for the given Term.
  • returns: NULL otherwise.

mv_Adm_IsNotHSGraduate( PIDM, TERM )
  • returns: Y if a student doesn't has High School Diploma or GED (Major: 34 (General Studies) + NHSG attribute) (SARAATT_ATTS_CODE = 'NHSG').
  • returns: NULL otherwise.

mv_Adm_IsActiveAccept( PIDM, TERM )
  • returns: Y if a student has SARADAP_APST_CODE In ('P','C','I','D','H') for the given Term.
  • returns: NULL otherwise.

mv_Adm_IsFromLocalCounty( PIDM, TERM )
  • returns: Y if a student's County Code In ('41','21','25','23','08','46','47').
  • returns: NULL otherwise.