AV_TODO_VW(SQL View) |
Index Back |
|---|---|
Todo List ViewTodo List View 010901 JM - Added ACTN_TYP_CD and ACTN_RSLT_CD to this view so that these fields can be displayed on the initial AV_TODO_LIST panel. |
| SELECT INSTITUTION , EMPLID , EXT_ORG_ID , ' ' , CNST_ACTN_NO , ' ' , ACTN_DESCR , ACTN_STAT_CD , PLANNED_DT , CMPL_DT , ACTN_TYPE_CD , ACTN_RSLT_CD , CNTC_TYPE_CD FROM PS_AV_CNST_ACTN |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | EXT_ORG_ID | Character(11) | VARCHAR2(11) NOT NULL | External Org ID |
| 4 | INTV_CD | Character(10) | VARCHAR2(10) NOT NULL | Initiative Code |
| 5 | CNST_ACTN_NO | Character(10) | VARCHAR2(10) NOT NULL | Action Nbr |
| 6 | INTV_ACTN_NBR | Character(10) | VARCHAR2(10) NOT NULL | Intv Action Nbr |
| 7 | ACTN_DESCR | Character(100) | VARCHAR2(100) NOT NULL | Action Description |
| 8 | ACTN_STAT_CD | Character(3) | VARCHAR2(3) NOT NULL |
Action Status
Prompt Table: AV_ACTN_STA_TBL |
| 9 | PLANNED_DT | Date(10) | DATE | Planned Date |
| 10 | CMPL_DT | Date(10) | DATE | Complete Date |
| 11 | ACTN_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL |
Action Type Code
Prompt Table: AV_ACTN_TYP_TBL |
| 12 | ACTN_RSLT_CD | Character(6) | VARCHAR2(6) NOT NULL |
Result Code
Prompt Table: AV_ACTN_RLT_TBL |
| 13 | CNTC_TYPE_CD | Character(6) | VARCHAR2(6) NOT NULL | Contact Type Code |