INSTITUTIONPrompt Table: INSTITUTN_SCRTY
UNIT_CDEFFDTDefault Value: %date
A=Active
I=Inactive
AV_UNIT_TBL_VW(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 ,EFFDT ,EFF_STATUS , 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 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive |
| 5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 6 | DESCRSHORT | Character(10) | VARCHAR2(10) NOT NULL | Short Description |