SSR_FC_INSTRENR

(SQL View)
 Index Back

Instructor Class/Enrollment

Instructor Class/Student Enrollment View

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 ,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) AND EXISTS ( SELECT 'X' FROM PS_STDNT_ENRL H WHERE H.ACAD_CAREER = D.ACAD_CAREER AND H.INSTITUTION = D.INSTITUTION AND H.STRM = D.STRM AND H.CLASS_NBR = D.CLASS_NBR)

  • 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 CLASS_MTG_NBR Number(2,0) SMALLINT NOT NULL Class Meeting Pattern Nbr
    18 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    19 TERM_END_DT Date(10) DATE Term Ending Date
    20 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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