GLOBAL_NOTE_LVW

(SQL View)
 Index Back

Global Notes View Lang Rec

.

SELECT A.INSTITUTION , A.ACAD_GROUP , A.STRM , A.SUBJECT , A.PRINT_AT , A1.LANGUAGE_CD , A1.DESCRLONG FROM PS_GLOBAL_NOTE_TBL A , PS_GLOBAL_NOTE_LNG A1 WHERE A.INSTITUTION = A1.INSTITUTION AND A.ACAD_GROUP = A1.ACAD_GROUP AND A.STRM = A1.STRM AND A.SUBJECT = A1.SUBJECT AND A.PRINT_AT = A1.PRINT_AT

  • Related Language Record for GLOBAL_NOTE_VW

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    7 DESCRLONG Long Character CLOB Long Description