CLASS_NOTES_LVW

(SQL View)
 Index Back

Class Notes View Lang Rec

The Class Notes Table contains information that is printed in the Schedule of Classes either before or after the class. If a row exits for the class then there is a note to be printed on the schedule of classes for the class.

SELECT A.CRSE_ID , A.CRSE_OFFER_NBR , A.STRM , A.SESSION_CODE , A.CLASS_SECTION , A.CLASS_NOTES_SEQ , A.LANGUAGE_CD , A.DESCRLONG FROM PS_CLASS_NTES_LANG A

  • Related Language Record for CLASS_NOTES_VW

  • Parent record: CLASS_NOTES

    • # 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_NOTES_SEQ Number(2,0) SMALLINT NOT NULL Class Notes Sequence Nbr
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCRLONG Long Character CLOB Long Description