STD_ENR_FL_SSVW

(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 , CASE WHEN A.STDNT_ENRL_STATUS = 'E' AND A.ENRL_DROP_DT IS NULL THEN 1 WHEN A.STDNT_ENRL_STATUS = 'W' THEN 2 WHEN ((A.STDNT_ENRL_STATUS = 'E' AND (A.ENRL_STATUS_REASON = 'DROP' OR A.ENRL_STATUS_REASON = 'WDR')) OR A.STDNT_ENRL_STATUS = 'D' OR A.ENRL_DROP_DT IS NOT NULL) THEN 3 END AS stat_check_sort , A.SUBJECT , A.CATALOG_NBR , A.CLASS_NBR , A.DESCR , A.STDNT_ENRL_STATUS , A.ENRL_STATUS_REASON , A.ENRL_DROP_DT , A.CRSE_ID , A.CRSE_OFFER_NBR , A.ASSOCIATED_cLASS , A.UNT_TAKEN , A.GRADING_BASIS_ENRL , A.CRSE_GRADE_OFF , A.RQMNT_DESIGNTN_OPT , A.RQMNT_DESIGNTN , A.ACAD_PROG , A.SESSION_CODE , A.CLASS_TYPE FROM PS_STDNT_ENRL_SSVW A WHERE ((A.GRADING_BASIS_ENRL <> 'NON') OR (A.GRADING_BASIS_ENRL = 'NON' AND A.CLASS_TYPE = 'E' AND A.ASSOCIATED_CLASS <> 9999 AND A.EMPLID NOT IN ( SELECT X.EMPLID FROM PS_STDNT_ENRL_SSVW X WHERE X.EMPLID = A.EMPLID AND X.INSTITUTION = A.INSTITUTION AND X.ACAD_CAREER = A.ACAD_CAREER AND X.STRM = A.STRM AND X.CRSE_ID = A.CRSE_ID AND X.CRSE_OFFER_NBR = A.CRSE_OFFER_NBR AND X.ASSOCIATED_CLASS = A.ASSOCIATED_CLASS AND X.GRADING_BASIS_ENRL <> 'NON')))

  • Related Language Record: STD_ENR_FL_SSVL

    • # 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 SSR_STAT_CHK_SORT Number(1,0) SMALLINT NOT NULL Sort
    6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    8 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr

    Prompt Table: CLASS_TBL_VW

    9 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    10 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting

    Default Value: E

    11 ENRL_STATUS_REASON Character(4) VARCHAR2(4) NOT NULL Enrollment Status Reason
    ADRP=Administrative Drop
    ALIM=Appointment Limit Exceeded
    CANC=Dropped (class cancelled)
    CREQ=Co-Requisite Enrollment
    DROP=Dropped (was enrolled)
    DRWL=Dropped (was wait listed)
    ENRL=Enrolled
    EWAT=Enrolled from Wait List
    FULL=Section is Full
    RCAP=Reserve Slots Full
    RCMP=Related Component
    SLIM=Session Limit Exceeded
    TIME=Time Conflict Exsists
    TIMR=Time Conflict Resolved
    TLIM=Term Limit Exceeded
    WDRW=Withdrawn from Class

    Default Value: ENRL

    12 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
    13 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    14 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    15 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    16 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    17 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis

    Prompt Table: GRADE_BASIS_VW1

    18 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    19 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    20 RQMNT_DESIGNTN Character(4) VARCHAR2(4) NOT NULL This field is used to track the Requirement Designation attached to a course in Student Records. This field is also used for tracking information through Academic Advisement.
    21 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    22 SESSION_CODE Character(3) VARCHAR2(3) NOT NULL Session
    1=Regular Academic Session
    10W=10 Week
    12W=Twelve Week
    4W1=Four Week - First
    4W2=Four Week - Second
    4W3=Four Week - Third
    4W4=Four Week - Fourth
    6W1=Six Week - First
    6W2=Six Week - Second
    8W1=Eight Week - First
    8W2=Eight Week - Second
    A11=Medical Period 1, 4 Weeks
    A12=Medical Period 1, 8 Weeks
    A13=Medical Pd 1, 12 Weeks
    A21=Medical Period 2, 4 Weeks
    A22=Medical Period 2, 8 Weeks
    A23=Medical Period 2, 12 Week
    FYR=Full Year
    MIN=Mini Session
    OEE=Open Entry/Open Exit
    SM1=Semester 1
    SM2=Semester 2
    23 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section