INSTITUTIONPrompt Table: INSTITUTN_SCRTY
UNIT_CDEFFDTDefault Value: %date
LANGUAGE_CDAVUNITTBLVWLNG(SQL View) |
Index Back |
|---|---|
Unit table viewAVUNITTBLVWLNG is the related language recordfor the record AV_UNIT_TBL_VW 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 ,EFFDT ,LANGUAGE_CD , DESCR , DESCRSHORT FROM PS_AVUNITTBLLNG |
| # | 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |