INSTR_WEEK_OEE

(SQL View)
 Index Back

Instreuctor Weekly Schedule


SELECT DISTINCT A.EMPLID , A.STRM , B.CLASS_NBR , B.DESCR , B.CRSE_ID , B.SUBJECT , B.CATALOG_NBR , B.SSR_COMPONENT , A.INSTR_ROLE , B.START_DT , B.END_DT , B.CRSE_OFFER_NBR , B.CLASS_SECTION , B.INSTITUTION , B.ENRL_TOT FROM PS_CLASS_TBL B , PS_CLASS_INSTR A WHERE A.CRSE_ID = B.CRSE_ID AND A.CRSE_OFFER_NBR = B.CRSE_OFFER_NBR AND A.STRM = B.STRM AND A.SESSION_CODE = B.SESSION_CODE AND A.CLASS_SECTION = B.CLASS_SECTION AND B.SESSION_CODE = 'OEE'

  • Related Language Record: INSTRWEEKOEELNG

    • # 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 STRM Character(4) VARCHAR2(4) NOT NULL Term
    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: CRSE_CATALOG.DESCR

    5 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    6 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Default Value: CRSE_OFFER.SUBJECT

    7 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr

    Default Value: CRSE_OFFER.CATALOG_NBR

    8 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
    9 INSTR_ROLE Character(4) VARCHAR2(4) NOT NULL Instructor Role
    PI=Primary Instructor
    SI=Secondary Instructor
    TA=Teaching Assistant
    10 START_DT Date(10) DATE NOT NULL Start Date

    Default Value: SESSION_TBL.SESS_BEGIN_DT

    11 END_DT Date(10) DATE NOT NULL end date

    Default Value: SESSION_TBL.SESS_END_DT

    12 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    13 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    14 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    15 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total