SSR_FIN_EXAM_VW

(SQL View)
 Index Back

SS Final Exam View for Faculty

The Final Exam View contains by instructor ID and term all the exam information for the instructor teaches for the specified term.

SELECT DISTINCT A.STRM ,A.EMPLID ,C.CLASS_NBR ,F.LAST_NAME_SRCH ,F.FIRST_NAME_SRCH ,F.NAME ,B.TERM_BEGIN_DT ,C.ACAD_CAREER ,C.ACAD_GROUP ,C.SUBJECT ,C.CATALOG_NBR ,A.SESSION_CODE ,A.CLASS_SECTION ,A.CRSE_OFFER_NBR ,A.CONTACT_MINUTES ,A.CRSE_ID ,B.TERM_BEGIN_DT ,B.TERM_END_DT ,C.INSTITUTION ,C.SSR_COMPONENT ,C.DESCR ,C.ENRL_TOT ,B.DESCR ,D.DESCR ,C.LMS_PROVIDER ,C.LMS_GROUP_ID ,C.LMS_URL ,A.GRADE_RSTR_ACCESS ,G.CLASS_EXAM_SEQ ,G.EXAM_TIME_CODE ,G.EXAM_DT ,G.EXAM_START_TIME ,G.EXAM_END_TIME ,G.FACILITY_ID ,G.CLASS_EXAM_TYPE ,G.COMBINED_EXAM ,C.START_DT ,C.END_DT ,C.HOLIDAY_SCHEDULE FROM PS_CLASS_INSTR A , PS_TERM_TBL B , PS_CLASS_TBL C , PS_INSTITUTION_TBL D , PS_HCR_PERSON_NM_I F , PS_CLASS_EXAM 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 C.INSTITUTION = B.INSTITUTION AND C.STRM = B.STRM AND C.ACAD_CAREER = B.ACAD_CAREER AND D.INSTITUTION = C.INSTITUTION AND A.EMPLID = F.EMPLID AND A.CRSE_ID = G.CRSE_ID AND A.CRSE_OFFER_NBR = G.CRSE_OFFER_NBR AND A.STRM = G.STRM AND A.SESSION_CODE = G.SESSION_CODE AND A.CLASS_SECTION = G.CLASS_SECTION

  • Related Language Record: SSRFINEXAMLNG

  • 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 TERM_BEGIN_DT Date(10) DATE Term Begin Date
    18 TERM_END_DT Date(10) DATE Term Ending Date
    19 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    20 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
    21 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    22 ENRL_TOT Number(4,0) SMALLINT NOT NULL Enrollment Total
    23 TERM_DESCR30 Character(30) VARCHAR2(30) NOT NULL Term
    24 INSTITUTION_DESCR Character(30) VARCHAR2(30) NOT NULL Institution
    25 LMS_PROVIDER Character(30) VARCHAR2(30) NOT NULL Provider for Authentication
    26 LMS_GROUP_ID Character(50) VARCHAR2(50) NOT NULL LMS group object id
    27 LMS_URL Character(254) VARCHAR2(254) NOT NULL LMS class URL
    28 GRADE_RSTR_ACCESS Character(1) VARCHAR2(1) NOT NULL Grade Roster Access
    A=Approve
    G=Grade
    P=Post
    29 CLASS_EXAM_SEQ Number(2,0) SMALLINT NOT NULL Class Exam Sequence Nbr
    30 EXAM_TIME_CODE Character(8) VARCHAR2(8) NOT NULL Exam Time Code
    31 EXAM_DT Date(10) DATE Exam Date
    32 EXAM_START_TIME Time(15) TIMESTAMP Exam Starting Time
    33 EXAM_END_TIME Time(15) TIMESTAMP Exam Ending Time
    34 FACILITY_ID Character(10) VARCHAR2(10) NOT NULL Facility ID
    35 CLASS_EXAM_TYPE Character(4) VARCHAR2(4) NOT NULL Class Exam Type
    FIN=Final Exam
    MAK=Makeup of Final Exam
    36 COMBINED_EXAM Character(1) VARCHAR2(1) NOT NULL Combined Exam
    37 START_DT Date(10) DATE Start Date
    38 END_DT Date(10) DATE end date
    39 HOLIDAY_SCHEDULE Character(6) VARCHAR2(6) NOT NULL Holiday Schedule