AV_INTV_ACTN(SQL Table) |
Index Back |
|---|---|
Constituent actionConstituent action information. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: AV_OPR_DEF_TBL.INSTITUTION Prompt Table: INSTITUTN_SCRTY |
| 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 | RSP_ASGN_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Responsible person assignment type
S=Staff U=Unit V=Volunteer Default Value: S |
| 5 | RSPL_ID | Character(11) | VARCHAR2(11) NOT NULL |
Responsible Person
Prompt Table: %EDITTABLE2 |
| 6 | ACTN_RSLT_CD | Character(6) | VARCHAR2(6) NOT NULL |
Result Code
Prompt Table: AV_I_AC_RSLT_VW |
| 7 | ACTN_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Action Description |
| 8 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 9 | ACTN_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Action Type Code
Prompt Table: AV_I_ACTN_TP_VW |
| 10 | ACTN_STAT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Action Status
Default Value: SCH Prompt Table: AV_I_AC_STAT_VW |
| 11 | PLANNED_DT | Date(10) | DATE |
Planned Date
Default Value: %date |
| 12 | CMPL_DT | Date(10) | DATE | Complete Date |
| 13 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 14 | CNTC_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Contact Type Code
Prompt Table: AV_I_AC_CNT_VW |