INSTITUTIONPrompt Table: INSTITUTION_TBL
INTV_CDPrompt Table: AV_INTV_VW
INTV_ACTN_NBRINTV_CD_RELATEDPrompt Table: AV_INTV_RLT2_VW
Prompt Table: AV_INTV_TYP_TBL
AV_INTV_ACTN_IN(SQL Table) |
Index Back |
|---|---|
Constituent Action InitiativesIntersection table between av_cnst_actn and av_intv_tbl. Initiatives that are assigned to an action for a constituent. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL |
Initiative Code
Prompt Table: AV_INTV_VW |
| 3 | INTV_ACTN_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Intv Action Nbr |
| 4 | INTV_CD_RELATED |
Character(10) | VARCHAR2(10) NOT NULL |
Related 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 |