INSTR_CLASS_VW

(SQL View)
 Index Back

Instructor Class View

The Instructor Class View contains by instructor ID and term all the sections that that instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,D.CLASS_NBR ,F.LAST_NAME_SRCH ,F.FIRST_NAME_SRCH ,F.NAME ,B.TERM_BEGIN_DT ,D.ACAD_CAREER ,D.ACAD_GROUP ,D.SUBJECT ,D.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CRSE_OFFER_NBR ,A.CONTACT_MINUTES ,A.CRSE_ID ,D.ASSOCIATED_CLASS ,A.CLASS_MTG_NBR ,B.TERM_BEGIN_DT ,B.TERM_END_DT ,D.INSTITUTION ,D.SSR_COMPONENT ,G.DESCR ,D.ENRL_TOT ,B.DESCR ,E.DESCR ,C.MEETING_TIME_START ,C.MEETING_TIME_END ,C.FACILITY_ID ,C.START_DT ,C.END_DT ,D.LMS_PROVIDER ,D.LMS_GROUP_ID ,D.LMS_URL ,A.GRADE_RSTR_ACCESS FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_MTG_PAT C , PS_CLASS_TBL D , PS_INSTITUTION_TBL E , PS_HCR_PERSON_NM_I F , PS_CRSE_CATALOG G WHERE A.CRSE_ID = C.CRSE_ID AND A.CRSE_OFFER_NBR = C.CRSE_OFFER_NBR AND A.STRM = C.STRM AND A.SESSION_CODE = C.SESSION_CODE AND A.CLASS_SECTION = C.CLASS_SECTION AND A.CLASS_MTG_NBR = C.CLASS_MTG_NBR AND A.CRSE_ID = D.CRSE_ID AND A.CRSE_OFFER_NBR = D.CRSE_OFFER_NBR AND A.STRM = D.STRM AND A.SESSION_CODE = D.SESSION_CODE AND A.CLASS_SECTION = D.CLASS_SECTION AND D.INSTITUTION = B.INSTITUTION AND D.STRM = B.STRM AND D.ACAD_CAREER = B.ACAD_CAREER AND E.INSTITUTION = D.INSTITUTION AND %EffdtCheck(INSTITUTION_TBL E1, E, B.TERM_BEGIN_DT) AND E.EFF_STATUS = 'A' AND A.EMPLID = F.EMPLID AND G.CRSE_ID = D.CRSE_ID AND G.EFFDT = ( SELECT MAX(G1.EFFDT) FROM PS_CRSE_CATALOG G1 WHERE G1.CRSE_ID = G.CRSE_ID AND G1.EFFDT <= B.TERM_BEGIN_DT)

  • Related Language Record: INSTRCLASSVWLNG

  • Parent record: PERSON

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 CLASS_NBR Number(5,0) INTEGER NOT NULL Class Nbr
    4 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    5 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    6 NAME Character(50) VARCHAR2(50) NOT NULL Name
    7 EFFDT Date(10) DATE Effective Date
    8 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
    9 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    10 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    11 CATALOG_NBR Character(10) VARCHAR2(10) NOT NULL Catalog Nbr
    12 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
    13 CLASS_SECTION Character(4) VARCHAR2(4) NOT NULL Class Section
    14 CRSE_OFFER_NBR Number(2,0) SMALLINT NOT NULL Course Offering Nbr
    15 CONTACT_MINUTES Number(4,0) SMALLINT NOT NULL Contact Minutes
    16 CRSE_ID Character(6) VARCHAR2(6) NOT NULL Course ID
    17 ASSOCIATED_CLASS Number(4,0) SMALLINT NOT NULL Associated Class
    18 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    19 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    20 TERM_END_DT Date(10) DATE Term Ending Date
    21 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    22 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
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    25 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
    26 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
    27 MEETING_TIME_START Time(15) TIMESTAMP Meeting Start Time
    28 MEETING_TIME_END Time(15) TIMESTAMP Meeting End Time
    29 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    30 START_DT Date(10) DATE Start Date
    31 END_DT Date(10) DATE end date
    32 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
    33 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
    34 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
    35 GRADE_RSTR_ACCESS Character(1) VARCHAR2(1) NOT NULL Grade Roster Access
    A=Approve
    G=Grade
    P=Post