STD_ENR_FL_SSVL

(SQL View)
 Index Back

Student Enrollment Table View

This Student Enrollment view is used to extract key enrollment information from the graded component into the enrollment section. This is done to facilitate maintenance transactions from the enrollment section only.

SELECT A.EMPLID , A.INSTITUTION , A.ACAD_CAREER , A.STRM , A.CLASS_NBR , B.LANGUAGE_CD , B.DESCR FROM PS_STDNT_ENRL_SSVW A , PS_STDNT_ENRL_SSLN B WHERE B.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.STRM = A.STRM AND B.CLASS_NBR = A.CLASS_NBR AND A.GRADING_BASIS_ENRL <> 'NON'

  • Related Language Record for STD_ENR_FL_SSV2 STD_ENR_FL_SSVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 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

    Prompt Table: STDNT_CAREER

    4 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: CLASS_TBL_VW

    6 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description