GLOBAL_NOTE_VW

(SQL View)
 Index Back

Global Notes View

The Global Notes Table contains information about a subject within the Academic Unit which is printed in the Schedule of Classes either before or after each Subject if a row exits for the Subject in the table.

SELECT INSTITUTION , ACAD_GROUP , STRM , SUBJECT , PRINT_AT , DESCRLONG FROM PS_GLOBAL_NOTE_TBL

  • Related Language Record: GLOBAL_NOTE_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    2 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Default Value: OPR_DEF_TBL_CS.ACAD_GROUP

    Prompt Table: ACAD_GROUP_TBL

    3 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Default Value: OPR_DEF_TBL_CS.STRM

    Prompt Table: TERM_VAL_TBL

    4 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area

    Prompt Table: SUBJECT_TBL

    5 PRINT_AT Character(1) VARCHAR2(1) NOT NULL Print Location
    A=Print After
    B=Print Before
    6 DESCRLONG Long Character CLOB Long Description