RBW_TASK_LIST(SQL View) |
Index Back |
---|---|
Task View CalendarMy Calendar Task View for assignees |
SELECT TA.PERSON_ID_ASSIGNEE , T.START_DATE , T.START_TIME , T.TASK_ID , T.END_DATE , T.END_TIME , T.DESCR60 , T.TASK_LOCATION , T.PERSON_ID_OWNER , T.PRIVATE_FLG , TYP.DESCR , T.TASK_STATUS , TYP.SHOW_IN_CAL_FLG FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE TYP WHERE TA.TASK_ID = T.TASK_ID AND TYP.TASK_TYPE = T.TASK_TYPE AND TYP.ACTIVE_FLG = 'Y' AND TYP.SHOW_IN_LIST_FLG = 'Y' AND T.TASK_STATUS NOT IN ('CNCL', 'CMPL') |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PERSON_ID_ASSIGNEE | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
2 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
3 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
4 | TASK_ID | Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
5 | END_DATE | Date(10) | DATE | End date field to store an end date. |
6 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
7 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
8 | TASK_LOCATION | Character(30) | VARCHAR2(30) NOT NULL | Task Location. Used by Task Management. |
9 | PERSON_ID_OWNER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
10 | PRIVATE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Flag to indicate the Task is Private. Used by Task Management. |
11 | TASKDESCR | Character(30) | VARCHAR2(30) NOT NULL | Task Description |
12 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open |
13 | SHOW_IN_CAL_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate if the Task should be shown in Calendar. Used by Task Management.
N=No Y=Yes |