Loading...
 

Student “Is” Boolean Functions

Most Frequently Used Student “Is” Functions in Argos:

mv_IsCIPPStudent ( PIDM, *TERM )
  • returns: Y if a Student is is in College In Prison Program (CIPP) (SFRSTCR_CAMP_CODE = 'Q').
  • returns: NULL otherwise.

mv_IsCommentTypeCode ( PIDM, TERM, CODE )
  • returns: Y if a Student has (SPRCMNT_CMTT_CODE = CODE) and (SPRCMNT_ORIG_CODE = TERM).
  • returns: NULL otherwise.

mv_IsStudentCongressMember ( PIDM, *TERM )
  • returns: Y if a Student is a Student Congress Member (SPRCMNT_CMTT_CODE = 'CO1').
  • returns: NULL otherwise.

mv_IsConfidential ( PIDM )
  • returns: Y if a Student has a Confidential Hold (SPBPERS_CONFID_IND = 'Y') to release personal info.
  • returns: NULL otherwise.

mv_IsDisabled ( PIDM )
  • returns: MEDI-CODE 2-letter code if Student has a Disability (SPRMEDI_DISB_IND = 'Y').
  • returns: NULL otherwise.

mv_IsSpecialDisabledVeteran ( PIDM )
  • returns: Y if a Student is in "Special Disabled Veteran" category (SPBPERS_SDVET_IND Is Not Null).
  • returns: NULL otherwise.

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

mv_IsForeigner ( PIDM )
  • returns: Y if a student is a foreigner (SGBSTDN_RATE_CODE = ' 71').
  • 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_IsRematriculated ( PIDM, *TERM )
  • returns: Rematriculated Date (SORZHLP_DATE_TIME) if student has SORZHLP_ZACT_CODE = 'ADRM' for given Term.
  • returns: NULL otherwise.

mv_IsMatriculated ( PIDM, *TERM )
  • returns: Y if a Student is Matriculated (STVZCEN_DEPT_CODE_CEN <> '0000') (including CERT-ificats) and not CCED Only for the given Term.
  • returns: NULL otherwise.

mv_IsNonMatriculated ( PIDM, *TERM )
  • returns: Y if a Student is Matriculated (STVZCEN_DEPT_CODE_CEN = '0000') (including CERT-ificats) for the given Term.
  • returns: NULL otherwise.

mv_Is1stMatriculated ( PIDM, TERM )
  • returns: Y if a Student is at his/her FIRST matriculated semester (STVZCEN_DEPT_CODE_CEN <> '0000') (including CERT-ificats) for the given Term.
  • returns: NULL otherwise.

mv_Is1stNonMatriculated ( PIDM, TERM )
  • returns: Y if a Student is at his/her FIRST NON-matriculated semester (STVZCEN_DEPT_CODE_CEN = '0000') (including CERT-ificats) for the given Term.
  • returns: NULL otherwise.

mv_IsFirstGeneration ( PIDM )
  • returns: Y if (SGRSATT_ATTS_CODE = 'FGS') is a First Generation Student.
  • returns: NULL otherwise.

mv_IsCCED_Only ( PIDM , *TERM )
  • returns: Y if (SSBSECT_SUBJ_CODE = 'CS') Student takes Only CCED classes for the given term.
  • returns: NULL otherwise.

mv_IsOnline_Only ( PIDM , *TERM )
  • returns: Y if (SFRSTCR_CAMP_CODE = 'I') Student takes Only Internet classes for the given term.
  • returns: NULL otherwise.

mv_IsScheduled ( PIDM, TERM )
  • returns: Y if a student has scheduled any class (SFRSTCR_RSTS_CODE LIKE 'R%') for the given Term, but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsScheduledForTerm ( PIDM )
  • returns: Scheduled Term for which a student has scheduled any class (SFRSTCR_RSTS_CODE LIKE 'R%'), but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsScheduled_GradableOnly ( PIDM, TERM )
  • returns: Y if a student has scheduled (SFRSTCR_RSTS_CODE LIKE 'R%') for the given Term and for at least one Credit (SSBSECT_GRADABLE_IND = 'Y') course, but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsScheduleWithWithdrawals ( PIDM, TERM )
  • returns: Y if a student Withdrew at least one class (SFRSTCR_RSTS_CODE NOT LIKE 'R%') for the given Term.
  • returns: NULL otherwise.

mv_IsReEnrolled_GradableOnly ( PIDM, TERM )
  • returns: Y if a student has Re-Enrolled for any Future Term or Semester (SFRSTCR_TERM_CODE > in_Term) for at least one Credit (SSBSECT_GRADABLE_IND = 'Y') course, but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsReEnrolled_PartTime ( PIDM, TERM )
  • returns: Credits if a student has Re-Enrolled for any Future Term or Semester (SFRSTCR_TERM_CODE > in_Term) for maximum of 11 credits (SUM(SFRSTCR_CREDIT_HR) < 12), but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsARAccept ( PIDM, TERM )
  • returns: Y if a student has paid his/her for scheduled classes (SFBETRM_AR_IND = 'Y') for the given Term.
  • returns: NULL otherwise.

mv_IsGraduate ( PIDM, TERM )
  • returns: Y if a student has graduated for the given term.
  • returns: NULL otherwise.

mv_IsCandidate ( PIDM, TERM )
  • returns: Y if a student is a candidate (SHRDGMR_DEGS_CODE = 'CA') for the given term.
  • returns: NULL otherwise.

mv_IsCandidateForTerm ( PIDM )
  • returns: Graduation Term for which a student is a candidate (SHRDGMR_DEGS_CODE = 'CA').
  • returns: NULL otherwise.

mv_IsNewStudent ( PIDM, TERM )
  • returns: Y if a student was accepted for the first time and had never been at MVCC prior the given term.
  • returns: NULL otherwise.

mv_IsDualCredit ( PIDM, TERM )
  • returns: Y if a student is a Dual Credit from High School (SFRSTCR_CAMP_CODE = 'D') for the given Term.
  • returns: NULL otherwise.

mv_IsDormStudent ( PIDM, *TERM )
  • returns: Y if a student is a Dorm Resident (sprcmnt_cmtt_code = ‘DM1’ code only) for the input term (*optional if omitted then current term applied).
  • returns: NULL otherwise.

mv_IsDormStudent_DM1DM2 ( PIDM, *TERM )
  • returns: DORM CODE (sprcmnt_cmtt_code = ‘DM1’ or ‘DM2’ codes) if a student is a Dorm Resident or Dorm Commuter for the input term (*optional if omitted then current term applied).
  • returns: NULL otherwise.

mv_IsDormStudent_DM2 ( PIDM, *TERM )
  • returns: DM2 (sprcmnt_cmtt_code = ‘DM2’) if a student is a Dorm Commuter for the input term (*optional if omitted then current term applied).
  • returns: NULL otherwise.

mv_IsAthlete ( PIDM, *TERM )
  • returns: Y if a student is an Athlete for the given Term (*optional if omitted then current term applied).
  • returns: NULL otherwise.

mv_IsVeteran ( PIDM )
  • returns: Y if a student is an Army Veteran (Substr(SPBPERS_VETC_FILE_NUMBER, -1) = 'V').
  • returns: NULL otherwise.

mv_IsHSGraduate ( PIDM )
  • returns: Y if a student has High School Diploma or H.S. Equivalency Diploma (GED).
  • returns: NULL otherwise.

mv_IsHS_MVConnection ( PIDM ) or mv_IsCommentType ( PIDM, 'CCN' ) where SPRCMNT_CMTT_CODE = 'CCN'
  • returns: Y if a student is a High School(er) in MVCC Connection program.
  • returns: NULL otherwise.

mv_IsHS_MagnetBridge ( PIDM )
  • returns: Y if a student is a High School(er) in Magnet Bridge program.
  • returns: NULL otherwise.

mv_IsCSTEP ( PIDM, TERM )
  • returns: Y if a student is a member of CSTEP (SPRCMNT_CMTT_CODE = 'CP1' and SPRCMNT_ORIG_CODE = Term last 4).
  • returns: NULL otherwise.

mv_IsPTKappaMember ( PIDM )
  • returns: Y if a student is a Phi Theta Kappa member (SPRCMNT_CMTT_CODE = 'PTK').
  • returns: NULL otherwise.

mv_IsWithdraw_MMR ( PIDM, *TERM )
  • returns: Y if a student (SFRSTCR_RSTS_CODE='WM') without MMR was withdrawn by Medical Center; Term (*optional if omitted then current term applied).
  • returns: NULL otherwise.

mv_IsMMR_ConditionsMet ( PIDM )
  • returns: Y if a student has met MMR requirements to take the hold off (SPBHCTR_IM_COMPLETE = 'Y' and SPBHCTR_MENINGITIS_RESPONSE = 'Y').
  • returns: NULL otherwise.

mv_IsMeningitis_NoResponse ( PIDM, *TERM )
  • returns: Y if (SPBHCTR_MENINGITIS_RESPONSE Is NULL).
  • returns: NULL otherwise.

mv_IsAnyHold ( PIDM )
  • returns: Y if a student has at least one Hold (SPRHOLD_HLDD_CODE).
  • returns: NULL otherwise.

mv_IsAnyHold_Code ( PIDM )
  • returns: Hold Code if a student has at least one Hold (SPRHOLD_HLDD_CODE).
  • returns: NULL otherwise.

mv_IsHold ( PIDM, HLDD_CODE )
  • returns: Y if a student has a given Hold (SPRHOLD_HLDD_CODE = HLDD_CODE).
  • returns: NULL otherwise.

mv_IsHold_Date ( PIDM, HLDD_CODE )
  • returns: Start Date of the given Hold (SPRHOLD_FROM_DATE).
  • returns: NULL otherwise.

mv_IsHold_HealthCenter ( PIDM )
  • returns: Y if a student has a Hold (SPRHOLD_HLDD_CODE='HC') from Health Center.
  • returns: NULL otherwise.

mv_IsHealthFormCompliant ( PIDM )
  • returns: Y if 1 of 3 criteria meet the Health Form Compliance requirements.
  • returns: 'N' otherwise.

mv_IsHold_AcademicProbation ( PIDM )
  • returns: Y if a student has a Hold (SPRHOLD_HLDD_CODE='AP') from Advisement Center.
  • returns: NULL otherwise.

mv_IsDeficient_MidGrade ( PIDM, TERM )
  • returns: Y if Student Mid-Term Grade is Deficient (SFRSTCR_GRDE_CODE_MID In ('D','F','N','U','Q') ) for the input Term.
  • returns: NULL otherwise.

mv_IsDeficient_3orMoreMidGrade ( PIDM, TERM )
  • returns: Y if Student Mid-Term Grades are Deficient (3 or more of: SFRSTCR_GRDE_CODE_MID In ('D','F','N','U','Q') ) for the input Term.
  • returns: NULL otherwise.

mv_IsEnrolledInCourseSubject ( PIDM, SUBJ, *TERM )
  • returns: Y if a student is Enrolled in a Course(s) with provided course subject for the give term (*optional: current term by default).
  • returns: NULL otherwise.

mv_IsEnrolledInCourse ( PIDM, SUBJ, CRSE, *TERM )
  • returns: Y if a student is Enrolled in the Course for the give term (*optional: current term by default).
  • returns: NULL otherwise.

mv_IsEnrolledInCourseCRN ( PIDM, SUBJ, CRSE, *TERM )
  • returns: CRN if a student is Enrolled in the Course for the give term (*optional: current term by default).
  • returns: NULL otherwise.

mv_IsCourseTaken ( PIDM, SUBJ, CRSE )
  • returns: the best Final Grade if a Student has already taken the Course, (excluding Transfers).
  • returns: NULL otherwise.

mv_IsCourseTaken_Term ( PIDM, SUBJ, CRSE )
  • returns: the best final grade Term Code if a Student has already taken the Course, (excluding Transfers).
  • returns: NULL otherwise.

mv_IsCourse_FailedPrereq ( PIDM, SUBJ, CRSE )
  • returns: Y if a Student had other than ('IP','T','A','B','C','D') final grades for a required Prereq, including Transfers and 'IP'- in progress.
  • returns: NULL otherwise.

mv_IsCourseInProgress ( PIDM, SUBJ, CRSE )
  • returns: IP if course is In Progress or Final grade for the given Student.
  • returns: NULL otherwise.

mv_IsCourseTransferred ( PIDM, SUBJ, CRSE )
  • returns: Y if a Student has transferred the given Course from a different institution.
  • returns: NULL otherwise.

mv_IsTaking_NonCreditCourse ( PIDM, *TERM )
  • returns: Y if Student is taking a Non-Credit Course for the given term.
  • returns: NULL otherwise.

mv_IsTaken_PAR ( PIDM, TERM )
  • returns: first Term after given one in which Pathways to Academic Recovery (PAR) program was taken.
  • returns: NULL otherwise.

mv_IsCommentType ( PIDM, CMTT_CODE )
  • returns: Y if Student has a given Comment Type (SPRCMNT_CMTT_CODE).
  • returns: NULL otherwise.

mv_IsAlumniMember ( PIDM )
  • returns: Y if a former Student is Alumni Member who has a valid (year >= current one) member card (APRACTY_ACTC_CODE = ‘ALU2011’).
  • returns: NULL otherwise.

mv_IsPlacementTested ( PIDM )
  • returns: Y if a Student is had a Placement Test score (SORTEST_TEST_SCORE) during last year.
  • returns: NULL otherwise.

mv_IsPlacementTest_Passed ( PIDM, SUBJ, CRSE )
  • returns: Y if a Student is has passed a Placement Test with a score of (SORTEST_TEST_SCORE >= SCRRTST_TEST_SCORE).
  • returns: NULL otherwise.

mv_IsTaken_StrengthsQuest ( PIDM )
  • returns: Y if a Student has ever taken Strengths-Quest (PPRSKIL_SKIL_CODE is not Null).
  • returns: NULL otherwise.

mv_IsPartTimeStudent ( PIDM , TERM )
  • returns: Credits if a student has Registered for maximum of 11 credits (SUM(SFRSTCR_CREDIT_HR) < 12), but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsPartTimeStudent_BillHrs ( PIDM , TERM )
  • returns: Billing Hours if a student has Registered for maximum of 11 bill hours (SUM(SFRSTCR_BILL_HR) < 12), but not necessarily paid for them yet.
  • returns: NULL otherwise.

mv_IsNewDirectionStudent ( PIDM , *TERM ) Not Used anymore, use mv_IsND1Student
  • returns: Y if (SARCHKL_ADMR_CODE In ('0022', '0028')) starting from current term.
  • returns: NULL otherwise.

mv_IsND1Student ( PIDM )
  • returns: Y if (SPRCMNT_CMTT_CODE = 'ND1') New Directions student.
  • returns: NULL otherwise.

mv_IsND1DrugCourt ( PIDM )
  • returns: Y if (SPRCMNT_CMTT_CODE = 'ND1' and SPRCMNT_ORIG_CODE = 'NDDR') New Directions Drug Court student.
  • returns: NULL otherwise

mv_IsNEEDCoded ( PIDM , NEED , *TERM )
  • returns: Y if (SERDTND_NEED_CODE = input CODE) for given term.
  • returns: NULL otherwise.


mv_FIT_IsTrustee ( PIDM )
  • returns: Y if (SPRCMNT_ORIG_CODE = 'TRST') MVCC Trustee.
  • returns: NULL otherwise.