Loading...
 

Student “Banner-Codes” Functions

Most Frequently Used Student Code Functions in Argos:

  • mv_Dorm_HousingCode ( PIDM, *TERM ) returns: SLBRMAP_HAPS_CODE for a Student in the given term (*optional if omitted then current term applied).
  • mv_CommentType_Code ( PIDM ) returns: latest by activity date SPRCMNT_CMTT_CODE for a Student.
  • mv_ProbationAdvisor_Initials ( PIDM, TERM ) returns: SERDTSR_SPRV_CODE where SERDTSR_SSER_CODE = 'APRB' for a Student
  • mv_Advisor_Initials ( PIDM, TERM ) returns: SERDTSR_SPRV_CODE for a Student
  • mv_HighSchoolCode ( PIDM ) returns: SORHSCH_SBGI_CODE for a Student
  • mv_Service_Code ( PIDM, TERM ) returns: SERDTSR_SSER_CODE for a Student for the given Term
  • mv_ServiceProvider_Code ( PIDM, TERM ) returns: SERDTSR_SPRV_CODE for a Student for the given Term
  • mv_ServiceGroup_Code ( PIDM, TERM ) returns: SERSSGP_SSGP_CODE for a Student for the given Term
  • mv_EducationalGoal_Code ( PIDM, TERM ) returns: SARADAP_EGOL_CODE for a Student for the given Term
  • mv_CampusWithMostClasses_Code ( PIDM, TERM ) returns: Campus Code (Utica > Rome = 'U'; Utica < Rome = 'R'; Utica = Rome (is Hybrid) = 'Y';) with highest number of registered classes of a Student for a given Term
  • mv_All_Holds ( PIDM ) returns: All active Holds (SPRHOLD_HLDD_CODE) for a student
  • mv_Athlete_SportCode ( PIDM, *TERM ) returns: Sport code (SGRSPRT_ACTC_CODE) for an Athlete in the given Term