PERSON_ID_ASSIGNEESTART_DATESTART_TIMETASK_IDLANGUAGE_CDRBW_TSK_LST_LNG(SQL View) |
Index Back |
|---|---|
Task View CalendarMy Calendar Task Language View for assignees............ |
| SELECT TA.PERSON_ID_ASSIGNEE , T.START_DATE , T.START_TIME , T.TASK_ID ,TYP.LANGUAGE_CD , T.DESCR60 , TYP.DESCR FROM PS_RB_TSK_ASGN TA , PS_RB_TSK T , PS_RB_TSK_TYPE_LNG TYP WHERE TA.TASK_ID = T.TASK_ID AND TYP.TASK_TYPE = T.TASK_TYPE 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 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 6 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 7 | TASKDESCR | Character(30) | VARCHAR2(30) NOT NULL | Task Description |