OEE_CLS_RSTR_VW

(SQL View)
 Index Back

Class Roster On-Line View

This view is used to select all students who are enrolled in a specific class in a term. SELECT A.INSTITUTION ,A.STRM ,A.SUBJECT ,A.CATALOG_NBR ,A.CAMPUS ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CLASS_NBR ,C.LAST_NAME_SRCH ,C.FIRST_NAME_SRCH ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,B.ACAD_CAREER ,B.EMPLID ,A.ACAD_GROUP ,A.ACAD_CAREER ,A.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 ,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.ENRL_ADD_DT ,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_CODE ,B.ENRL_ACTN_RSN_LAST ,B.UNT_PRGRSS_FA ,A.CLASS_STAT ,B.STDNT_POSITIN FROM PS_CLASS_TBL A, PS_STDNT_ENRL B, PS_PERSONAL_DATA C WHERE A.STRM = B.STRM AND A.CLASS_NBR = B.CLASS_NBR AND B.EMPLID = C.EMPLID

SELECT A.INSTITUTION ,A.STRM ,A.CLASS_NBR ,B.EMPLID ,A.SUBJECT ,A.CATALOG_NBR ,A.CAMPUS ,A.SESSION_CODE ,A.CLASS_SECTION ,C.LAST_NAME_SRCH ,C.FIRST_NAME_SRCH ,C.NAME ,A.CRSE_ID ,A.CRSE_OFFER_NBR ,B.ACAD_CAREER ,A.ACAD_GROUP ,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.STDNT_ENRL_STATUS ,B.ASSOCIATED_CLASS ,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.ENRL_ADD_DT ,A.CRS_TOPIC_ID ,A.EQUIV_CRSE_ID ,A.OVRD_CRSE_EQUIV_ID ,O.START_DT ,O.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_CODE ,B.ENRL_ACTN_RSN_LAST ,B.UNT_PRGRSS_FA ,A.CLASS_STAT ,B.STDNT_POSITIN ,D.ACAD_PROG_PRIMARY ,D.ACAD_LEVEL_BOT ,F.DESCR FROM PS_CLASS_TBL A ,PS_STDNT_ENRL B ,PS_STDNT_ENRL_OEE O , PS_HCR_PERSON_NM_I C , PS_STDNT_CAR_TERM D , PS_TERM_TBL E , PS_ACAD_PROG_TBL F WHERE B.STRM = A.STRM AND B.CLASS_NBR = A.CLASS_NBR AND O.EMPLID = B.EMPLID AND O.ACAD_CAREER = B.ACAD_CAREER AND O.INSTITUTION = B.INSTITUTION AND O.STRM = B.STRM AND C.EMPLID = B.EMPLID AND D.EMPLID = B.EMPLID AND D.ACAD_CAREER = B.ACAD_CAREER AND D.INSTITUTION = B.INSTITUTION AND D.STRM = B.STRM AND E.INSTITUTION = D.INSTITUTION AND E.ACAD_CAREER = D.ACAD_CAREER AND E.STRM = D.STRM AND F.INSTITUTION = E.INSTITUTION AND F.ACAD_PROG = D.ACAD_PROG_PRIMARY AND F.EFFDT = ( SELECT MAX(F1.EFFDT) FROM PS_ACAD_PROG_TBL F1 WHERE F1.INSTITUTION = F.INSTITUTION AND F1.ACAD_PROG = F.ACAD_PROG AND F1.EFFDT <= E.TERM_BEGIN_DT) AND O.CLASS_NBR = B.DYN_CLASS_NBR

  • Related Language Record: OEECLSRSTRVWLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_TBL

    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    5 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: OPR_DEF_TBL_CS.SUBJECT

    Prompt Table: SUBJECT_TBL

    6 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    7 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    8 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
    9 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    10 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    11 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    12 NAME Character(50) VARCHAR2(50) NOT NULL Name
    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 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
    16 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    17 CRSE_CAREER Character(4) VARCHAR2(4) NOT NULL Course Career
    18 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
    19 ENRL_CAP Number(4,0) SMALLINT NOT NULL Enrollment Capacity
    20 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 GRADING_BASIS_ENRL Character(3) VARCHAR2(3) NOT NULL Grading Basis
    23 MANDATORY_GRD_BAS Character(1) VARCHAR2(1) NOT NULL Mandatory Grading Basis
    24 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    25 UNT_BILLING Number(6,2) DECIMAL(5,2) NOT NULL Billing Units
    26 UNT_PRGRSS Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Academic Progress
    27 STDNT_ENRL_STATUS Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    D=Dropped
    E=Enrolled
    W=Waiting
    28 SSR_ENRL_STATUS_WK Character(2) VARCHAR2(2) NOT NULL Student Enrollment Status
    A=All
    D=Dropped
    E=Enrolled
    W=Waiting
    29 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    30 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
    31 RSRV_CAP_NBR Number(3,0) SMALLINT NOT NULL Reserve Capacity Sequence
    32 SESSN_ENRL_CNTL Character(3) VARCHAR2(3) NOT NULL Enrollment Control Session
    33 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    34 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade
    35 GRD_PTS_PER_UNIT Number(10,3) DECIMAL(9,3) NOT NULL Grade Points Per Unit
    36 AUDIT_GRADE_BASIS Character(1) VARCHAR2(1) NOT NULL Audit Grading Basis
    37 EARN_CREDIT Character(1) VARCHAR2(1) NOT NULL Earn Credit
    38 INCLUDE_IN_GPA Character(1) VARCHAR2(1) NOT NULL Include in GPA
    39 UNITS_ATTEMPTED Character(1) VARCHAR2(1) NOT NULL Units Attempted
    I=In Progress
    N=No
    Y=Yes
    40 GRADE_POINTS Number(10,3) DECIMAL(9,3) NOT NULL Grade Points
    41 ENRL_ADD_DT Date(10) DATE Enrollment Add Date
    42 CRS_TOPIC_ID Number(3,0) SMALLINT NOT NULL Course Topic ID
    43 EQUIV_CRSE_ID Character(5) VARCHAR2(5) NOT NULL Equivalent Course Group
    44 OVRD_CRSE_EQUIV_ID Character(1) VARCHAR2(1) NOT NULL Override Equivalent Course
    45 START_DT Date(10) DATE Start Date
    46 END_DT Date(10) DATE end date
    47 CLASS_TYPE Character(1) VARCHAR2(1) NOT NULL Class Type
    E=Enrollment Section
    N=Non-Enrollment Section
    48 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.
    49 RQMNT_DESIGNTN_OPT Character(1) VARCHAR2(1) NOT NULL Requirement Designation Option
    N=No
    Y=Yes
    50 RQMNT_DESIGNTN_GRD Character(1) VARCHAR2(1) NOT NULL Requirement Designation Grade
    N=Not Satisfied
    S=Satisfied
    51 INSTRUCTOR_ID Character(11) VARCHAR2(11) NOT NULL Instructor ID
    52 CRSE_COUNT Number(5,2) DECIMAL(4,2) NOT NULL Course Count
    53 TSCRPT_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Transcript Note ID
    54 TSCRPT_NOTE_EXISTS Character(1) VARCHAR2(1) NOT NULL Transcript Note Exists Flag
    55 CLASS_PRMSN_NBR Number(6,0) INTEGER NOT NULL Class Permission Nbr
    56 REPEAT_CODE Character(4) VARCHAR2(4) NOT NULL Repeat Code
    NTEA=No Taking Exam/Assessment
    57 ENRL_ACTN_RSN_LAST Character(4) VARCHAR2(4) NOT NULL Last Enrl Action Reason
    58 UNT_PRGRSS_FA Number(6,2) DECIMAL(5,2) NOT NULL Units Taken-Fin Aid Progress
    59 CLASS_STAT Character(1) VARCHAR2(1) NOT NULL Class Status
    A=Active
    S=Stop Further Enrollment
    T=Tentative Section
    X=Cancelled Section
    60 STDNT_POSITIN Number(8,0) INTEGER NOT NULL Student Position
    61 ACAD_PROG_PRIMARY Character(5) VARCHAR2(5) NOT NULL Primary Academic Program
    62 ACADEMIC_LEVEL Character(3) VARCHAR2(3) NOT NULL Academic Level
    00=Not Set
    01=First Year
    02=Second Year
    03=Third Year
    04=Fourth Year
    05=Fifth Year
    06=Sixth Year
    10=Freshman
    20=Sophomore
    30=Junior
    40=Senior
    50=Post-Bacc Undergraduate
    GR=Graduate
    GRA=Graduate AUS
    HON=Honours
    IE=Industrial Experience
    MAS=Masters
    P1=Professional Year 1
    P2=Professional Year 2
    P3=Professional Year 3
    P4=Professional Year 4
    PHD=PhD
    63 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr