SAE_INSTR_VW

(SQL View)
 Index Back

Class Instructor Extension

The Class Instructor Extension View contains instructor information used by the integration to external system.

SELECT CS_VW.CRSE_ID , CS_VW.CRSE_OFFER_NBR , CS_VW.STRM , CS_VW.SESSION_CODE , CS_VW.CLASS_SECTION , INSTR.CLASS_MTG_NBR , INSTR.INSTR_ASSIGN_SEQ , CS_VW.INSTITUTION , CS_VW.ACAD_CAREER , CS_VW.CLASS_NBR , INSTR.EMPLID , INSTREXT.SAE_MODE , INSTREXT.SAE_EVENT_DT , INSTR.INSTR_ROLE , CS_VW.ACAD_ORG FROM PS_SAE_CS_VW CS_VW , PS_SAE_INSTR_EXT INSTREXT ,PS_CLASS_INSTR INSTR WHERE INSTR.CRSE_ID = INSTREXT.CRSE_ID AND INSTR.CRSE_OFFER_NBR = INSTREXT.CRSE_OFFER_NBR AND INSTR.STRM = INSTREXT.STRM AND INSTR.SESSION_CODE = INSTREXT.SESSION_CODE AND INSTR.CLASS_SECTION = INSTREXT.CLASS_SECTION AND INSTR.CLASS_MTG_NBR = INSTREXT.CLASS_MTG_NBR AND INSTR.INSTR_ASSIGN_SEQ = INSTREXT.INSTR_ASSIGN_SEQ AND INSTR.EMPLID = INSTREXT.EMPLID AND INSTREXT.SAE_MODE <> 'D' AND INSTREXT.EMPLID <> ' ' AND CS_VW.CRSE_ID = INSTREXT.CRSE_ID AND CS_VW.CRSE_OFFER_NBR = INSTREXT.CRSE_OFFER_NBR AND CS_VW.STRM = INSTREXT.STRM AND CS_VW.SESSION_CODE = INSTREXT.SESSION_CODE AND CS_VW.CLASS_SECTION = INSTREXT.CLASS_SECTION UNION ALL SELECT CS_VW.CRSE_ID , CS_VW.CRSE_OFFER_NBR , CS_VW.STRM , CS_VW.SESSION_CODE , CS_VW.CLASS_SECTION , INSTREXT.CLASS_MTG_NBR , INSTREXT.INSTR_ASSIGN_SEQ , CS_VW.INSTITUTION , CS_VW.ACAD_CAREER , CS_VW.CLASS_NBR , INSTREXT.EMPLID , INSTREXT.SAE_MODE , INSTREXT.SAE_EVENT_DT , INSTREXT.INSTR_ROLE , CS_VW.ACAD_ORG FROM PS_SAE_CS_VW CS_VW , PS_SAE_INSTR_EXT INSTREXT WHERE CS_VW.CRSE_ID = INSTREXT.CRSE_ID AND CS_VW.CRSE_OFFER_NBR = INSTREXT.CRSE_OFFER_NBR AND CS_VW.STRM = INSTREXT.STRM AND CS_VW.SESSION_CODE = INSTREXT.SESSION_CODE AND CS_VW.CLASS_SECTION = INSTREXT.CLASS_SECTION AND INSTREXT.EMPLID <> ' ' AND INSTREXT.SAE_MODE = 'D' AND NOT EXISTS ( SELECT 'x' FROM PS_CLASS_INSTR INSTR WHERE INSTR.CRSE_ID=INSTREXT.CRSE_ID AND INSTR.CRSE_OFFER_NBR=INSTREXT.CRSE_OFFER_NBR AND INSTR.STRM=INSTREXT.STRM AND INSTR.SESSION_CODE=INSTREXT.SESSION_CODE AND INSTR.CLASS_SECTION=INSTREXT.CLASS_SECTION AND INSTR.EMPLID=INSTREXT.EMPLID)

  • Parent record: CLASS_MTG_PAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    2 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    3 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_TBL

    4 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

    Prompt Table: SESSION_TBL

    5 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    6 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    7 INSTR_ASSIGN_SEQ Number(3,0) SMALLINT NOT NULL Class/Instructor Assign Seq #
    8 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    9 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
    10 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    11 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: %EDITTABLE10

    12 SAE_MODE Character(1) VARCHAR2(1) NOT NULL Operation Mode
    A=Add
    C=Change
    D=Delete
    13 SAE_EVENT_DT DateTime(26) TIMESTAMP Event Driven Timestamp
    14 INSTR_ROLE Character(4) VARCHAR2(4) NOT NULL Instructor Role
    PI=Primary Instructor
    SI=Secondary Instructor
    TA=Teaching Assistant

    Default Value: PI

    15 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization