**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 ,**Not Used anymore, use mv_IsND1Student

**TERM*)- 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.