PERSON_ID_ASSIGNEESTART_DATESTART_TIMETASK_IDRBW_CALENDAR(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 , T.TIMEZONE 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_CAL_FLG = 'Y' AND T.TASK_STATUS NOT IN ('CNCL', 'CMPL') AND T.START_TIME IS NOT NULL AND T.START_DATE = %CurrentDateIn AND T.END_DATE IS NOT NULL AND T.END_TIME IS NOT NULL |
| # | 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 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |