GLOBAL_NOTE_TBL

(SQL Table)
Index Back

Global Notes Table

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.

  • Related Language Record: GLOBAL_NOTE_LNG
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRLONG Long Character CLOB Long Description