AV_MTVTN_INTV(SQL Table) |
Index Back |
---|---|
Motivation InitiativesLinks appeals to the Initiatives they may be used in. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | SETID | Character(5) | VARCHAR2(5) NOT NULL |
SetID
Default Value: AV_OPR_DEF_TBL.SETID Prompt Table: SETID_TBL |
2 | MOTIVATION_CD | Character(9) | VARCHAR2(9) NOT NULL | Appeal Code |
3 | EFFDT | Date(10) | DATE | Effective Date |
4 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL |
Initiative Code
Prompt Table: AV_INTV_RLT2_VW |
5 | INTV_TYPE_RELATED | Character(10) | VARCHAR2(10) NOT NULL |
Related Initiative Type
Prompt Table: AV_INTV_TYP_TBL |
6 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTN_SCRTY |