AV_TODO2_VW(SQL View) |
Index Back |
---|---|
Todo List View |
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 |