AV_UNIT_TBL_VW2

(SQL View)
Index Back

Unit table view

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 , DESCR , DESCRSHORT FROM PS_AV_UNIT_TBL

  • Related Language Record: AVUNITTBLVW2LNG
  • # 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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description