CLSS_TBL_SE_VW2

(SQL View)
 Index Back

Class Table Student Enrl View

This Class Table view is used for prompting in the Enrollment Request Panelgroup. Only Class Sections in Student Enrollment are selected.

SELECT B.EMPLID ,B.ACAD_CAREER ,A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,A.ACAD_GROUP ,A.SUBJECT ,A.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.ACAD_CAREER ,A.SSR_COMPONENT ,A.ENRL_CAP ,A.ENRL_TOT ,A.DESCR ,B.GRADING_BASIS_ENRL ,B.MANDATORY_GRD_BAS ,B.UNT_TAKEN ,B.UNT_BILLING ,B.UNT_PRGRSS ,B.STDNT_ENRL_STATUS ,B.ASSOCIATED_CLASS ,A.CRSE_ID ,B.ENRL_STATUS_REASON ,B.RSRV_CAP_NBR ,B.SESSN_ENRL_CNTL ,B.CRSE_GRADE_INPUT ,B.CRSE_GRADE_OFF ,B.GRD_PTS_PER_UNIT ,B.AUDIT_GRADE_BASIS ,B.EARN_CREDIT ,B.INCLUDE_IN_GPA ,B.UNITS_ATTEMPTED ,B.GRADE_POINTS ,B.GRADE_POINTS_FA ,B.ENRL_ADD_DT ,A.CRSE_OFFER_NBR ,A.CRS_TOPIC_ID ,A.EQUIV_CRSE_ID ,A.OVRD_CRSE_EQUIV_ID ,A.START_DT ,A.END_DT ,A.CLASS_TYPE ,B.RQMNT_DESIGNTN ,B.RQMNT_DESIGNTN_OPT ,B.RQMNT_DESIGNTN_GRD ,B.INSTRUCTOR_ID ,B.CRSE_COUNT ,B.TSCRPT_NOTE_ID ,B.TSCRPT_NOTE_EXISTS ,B.CLASS_PRMSN_NBR ,B.REPEAT_CANDIDATE ,B.REPEAT_CODE ,B.ENRL_ACTN_RSN_LAST ,B.UNT_PRGRSS_FA ,B.NOTIFY_STDNT_CHNG ,B.DROP_CLASS_IF_ENRL ,A.STDNT_SPEC_PERM ,B.ENRL_ACTION_LAST ,B.STDNT_POSITIN ,B.DYN_CLASS_NBR ,A.LOCATION ,A.CAMPUS ,B.UNT_EARNED ,B.GRADING_BASIS_DT ,B.ENRL_DROP_DT ,B.GRADE_DT ,A.COMBINED_SECTION ,B.SEL_GROUP ,B.ASSOCIATION_99 ,B.ENRL_REQ_SOURCE ,B.LAST_ENRL_DT_STMP ,B.LAST_ENRL_TM_STMP ,D.ENRL_UN_LD_CLC_TYP ,B.ACAD_PROG ,B.RELATE_CLASS_NBR_1 ,B.RELATE_CLASS_NBR_2 ,B.OVRD_GRADING_BASIS ,B.GRADING_SCHEME_ENR FROM PS_CLASS_TBL A , PS_STDNT_ENRL B , PS_TERM_TBL C , PS_CRSE_CATALOG D WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND C.INSTITUTION = A.INSTITUTION AND C.ACAD_CAREER = A.ACAD_CAREER AND C.STRM = A.STRM AND D.CRSE_ID = A.CRSE_ID AND D.EFFDT = ( SELECT MAX(D1.EFFDT) FROM PS_CRSE_CATALOG D1 WHERE D1.CRSE_ID = D.CRSE_ID AND D1.EFFDT <= C.TERM_BEGIN_DT) AND D.EFF_STATUS = 'A'

  • Related Language Record: CLSS_TBSEVW2_LN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    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 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: TERM_TBL

    5 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    6 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    7 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    8 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    9 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
    10 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    11 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
    12 SSR_COMPONENT Character(3) VARCHAR2(3) NOT NULL Course Component.
    CLN=Clinical
    CON=Continuance
    DIS=Discussion
    FLD=Field Studies
    IND=Independent Study
    LAB=Laboratory
    LEC=Lecture
    PRA=Practicum
    RSC=Research
    SEM=Seminar
    SUP=Supervision
    THE=Thesis Research
    TUT=Tutorial
    13 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    14 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    15 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    16 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    17 MANDATORY_GRD_BAS Character(1) VARCHAR2(1) NOT NULL Mandatory Grading Basis
    18 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    19 UNT_BILLING Number(6,2) DECIMAL(5,2) NOT NULL Billing Units
    20 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
    21 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    22 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    23 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    24 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
    25 RSRV_CAP_NBR Number(3,0) SMALLINT NOT NULL Reserve Capacity Sequence
    26 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session
    27 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    28 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    29 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    30 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis
    31 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    32 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    33 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    34 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    35 GRADE_POINTS_FA Number(10,3) DECIMAL(9,3) NOT NULL Financial Aid Grade Points
    36 ENRL_ADD_DT Date(10) DATE Enrollment Add Date
    37 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    38 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    39 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
    40 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course
    41 START_DT Date(10) DATE Start Date
    42 END_DT Date(10) DATE end date
    43 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    44 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.
    45 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    46 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
    N=Not Satisfied
    S=Satisfied
    47 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
    48 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    49 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID
    50 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag
    51 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
    52 REPEAT_CANDIDATE Character(1) VARCHAR2(1) NOT NULL Repeat Candidate Flag
    53 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    54 ENRL_ACTN_RSN_LAST Character(4) VARCHAR2(4) NOT NULL Last Enrl Action Reason
    55 UNT_PRGRSS_FA Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Fin Aid Progress
    56 NOTIFY_STDNT_CHNG Character(2) VARCHAR2(2) NOT NULL Notify Student of Change
    DP=Dropped/Class Canceled
    WE=Enrolled From WaitList
    WL=WaitList Status Change
    57 DROP_CLASS_IF_ENRL Number(5,0) INTEGER NOT NULL Drop This Class if Enrolled
    58 STDNT_SPEC_PERM Character(1) VARCHAR2(1) NOT NULL Student Specific Permissions
    59 ENRL_ACTION_LAST Character(2) VARCHAR2(2) NOT NULL Last Enrollment Action
    60 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position
    61 DYN_CLASS_NBR Number(5,0) INTEGER NOT NULL Dynamic Class Nbr
    62 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code
    63 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    64 UNT_EARNED Number(6,2) DECIMAL(5,2) NOT NULL Units Earned
    65 GRADING_BASIS_DT Date(10) DATE Grading Basis Date
    66 ENRL_DROP_DT Date(10) DATE Enrollment Drop Date
    67 GRADE_DT Date(10) DATE Grade Date
    68 COMBINED_SECTION Character(1) VARCHAR2(1) NOT NULL Combined Section
    C=Combined Section
    S=Combined Section Skip Mtg Pat
    69 SEL_GROUP Character(10) VARCHAR2(10) NOT NULL Tuition Group
    70 ASSOCIATION_99 Character(1) VARCHAR2(1) NOT NULL Association 99
    71 ENRL_REQ_SOURCE Character(2) VARCHAR2(2) NOT NULL Enrollment Request Source
    CR=Class Roll
    E=Enrollment Request
    EN=Enrollment
    FE=Fluid Cls Srch Enrl non-SFF
    FF=Fluid Cls Srch Enrl SFF
    FS=Fluid Self Service SFF
    FX=Fluid Self Service non-SFF
    IL=Grade Lapse
    ME=Mass Enrollment
    PB=Post Enrl Req Chk Batch
    PD=Req Chk Drop Online
    PO=Post Enrl Req Chk Online
    PX=Req Chk Drop Batch
    QE=Quick Enroll
    SE=Self-Service Enrollment
    SF=Student Financials Batch
    SG=Self Service Grade Posting
    TA=Test Administration (NLD)
    WD=Term Withdrawal Engine
    WL=Wait List Engine
    72 LAST_ENRL_DT_STMP Date(10) DATE Last Enrollment Date Stamp
    73 LAST_ENRL_TM_STMP Time(15) TIMESTAMP Last Enrollment Time Stamp
    74 ENRL_UN_LD_CLC_TYP Character(1) VARCHAR2(1) NOT NULL Enrollment Unit Load Calc Type
    1=Actual Units
    2=Academic Progress Units
    75 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    76 RELATE_CLASS_NBR_1 Number(5,0) INTEGER NOT NULL Related Class Number 1
    77 RELATE_CLASS_NBR_2 Number(5,0) INTEGER NOT NULL Related Class Number 2
    78 OVRD_GRADING_BASIS Character(1) VARCHAR2(1) NOT NULL Override Grading Basis
    79 GRADING_SCHEME_ENR Character(3) VARCHAR2(3) NOT NULL Grading Scheme