INSTITUTIONPrompt Table: INSTITUTION_TBL
STAFF_IDUNIT_CD1INTV_CDINTV_ACTN_NBRPrompt Table: AV_ACTN_RLT_TBL
Prompt Table: AV_ACTN_TYP_TBL
Prompt Table: AV_ACTN_STA_TBL
Default Value: %date
AV_INTV_TODO_VW(SQL View) |
Index Back |
|---|---|
Action todo viewSelects all actions that a staff/volunteer are assigned to. |
| SELECT A.INSTITUTION , A.STAFF_ID , A.UNIT_CD , B.INTV_CD , B.INTV_ACTN_NBR , B.ACTN_RSLT_CD , B.ACTN_DESCR , B.ACTN_TYPE_CD , B.ACTN_STAT_CD , B.PLANNED_DT , B.CMPL_DT , B.EXPIRATION_DT , B.CNTC_TYPE_CD FROM PS_AV_INTV_AC_ASGN A , PS_AV_INTV_ACTN B WHERE A.INSTITUTION = B.INSTITUTION AND A.INTV_CD = B.INTV_CD AND A.INTV_ACTN_NBR = B.INTV_ACTN_NBR |
| # | 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 | STAFF_ID |
Character(11) | VARCHAR2(11) NOT NULL | Staff ID |
| 3 | UNIT_CD1 |
Character(11) | VARCHAR2(11) NOT NULL | Unit Code |
| 4 | INTV_CD |
Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
| 5 | INTV_ACTN_NBR |
Character(10) | VARCHAR2(10) NOT NULL | Intv Action Nbr |
| 6 | ACTN_RSLT_CD | Character(6) | VARCHAR2(6) NOT NULL |
Result Code
Prompt Table: AV_ACTN_RLT_TBL |
| 7 | ACTN_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Action Description |
| 8 | ACTN_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Action Type Code
Prompt Table: AV_ACTN_TYP_TBL |
| 9 | ACTN_STAT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Action Status
Prompt Table: AV_ACTN_STA_TBL |
| 10 | PLANNED_DT | Date(10) | DATE |
Planned Date
Default Value: %date |
| 11 | CMPL_DT | Date(10) | DATE | Complete Date |
| 12 | EXPIRATION_DT | Date(10) | DATE | Expiration Date |
| 13 | CNTC_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL | Contact Type Code |