SSR_CSTRMPRV_VW

(SQL View)
 Index Back

Class Search Term Values

View for valid class search terms for students and visitors trimming down for term with scheduled classes only

SELECT 'X' AS INSTITUTION , 'X' AS ACAD_CAREER , 'X' AS STRM , 'X' AS DESCR , 'X' AS DESCRSHORT , 'X' AS DESCRFORMAL , 'X' AS DESCR50 , %CurrentDateOut AS TERM_BEGIN_DT , %CurrentDateOut AS TERM_END_DT FROM %SelectDummyTable

  • Related Language Record: SSR_CSTRMST2VWL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    2 ACAD_CAREER Character(4) VARCHAR2(4) NOT NULL Academic Career
    BAC=Bachelor (NLD)
    BBL=Vocational Coaching (NLD)
    BOL=Vocational Training (NLD)
    BUSN=Graduate Business
    CNED=Continuing Education
    CRED=Semester Credit
    EDU=Education (NLD)
    EXED=Extended Education
    GRAD=Graduate
    LAW=Law
    MEDS=Medical School
    NONA=Non Award
    PGRD=Postgraduate
    RSCH=Research
    TECH=Technical
    UENG=Undergraduate Engineering
    UGRD=Undergraduate
    VAVO=Advanced General Educ. (NLD)
    VETM=Veterinary Medicine
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    6 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    7 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50
    8 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    9 TERM_END_DT Date(10) DATE Term Ending Date