AVUNITTBLVW2LNG

(SQL View)
 Index Back

Unit table view

AVUNITTBLVW2LNG is the related language recordfor the record AV_UNIT_TBL_VW2 Used for related display. When multiple relate displays are used and field must be changed dynamically based on the assignment type, related display must come from more than one table.

SELECT INSTITUTION , UNIT_CD ,LANGUAGE_CD , DESCR , DESCRSHORT FROM PS_AVUNITTBLLNG

  • Related Language Record for AV_UNIT_TBL_VW2

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

    Prompt Table: INSTITUTN_SCRTY

    2 UNIT_CD Character(11) VARCHAR2(11) NOT NULL Unit Code
    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description