AV_UNIT_TBL_VW2(SQL View) |
Index Back |
---|---|
Unit table viewUsed 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 |
# | 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 |