RF_TSK_SOAGN_VW(SQL View) |
Index Back |
|---|---|
Service Order Task ViewService Order tasks for the assigned technicians. |
| SELECT A.TASK_ID , A.PERSON_ID_OWNER , A.TASK_STATUS , A.TASK_PRIORITY , A.START_DATE , A.START_TIME , A.END_DATE , A.END_TIME , A.DESCR60 , B.REL_TXN_SYNCID , A.DESCRLONG FROM PS_RB_TSK A , PS_RB_TSK_TXN B WHERE A.TASK_ID = B.TASK_ID AND A.TASK_TYPE ='SERVICE ORDER' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_ID | Number(15,0) | DECIMAL(15) NOT NULL | TaskIID field. Key for RB_TSK record. Used by Task Management. |
| 2 | PERSON_ID_OWNER | Character(15) | VARCHAR2(15) NOT NULL | Contact Identifier for Treasury Contacts |
| 3 | TASK_STATUS | Character(4) | VARCHAR2(4) NOT NULL |
Task Status
CMPL=Completed CNCL=Canceled INPR=In Progress OPEN=Open |
| 4 | TASK_PRIORITY | Character(4) | VARCHAR2(4) NOT NULL | Task Priority indicator for Task. Used in Task Management. |
| 5 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 6 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 7 | END_DATE | Date(10) | DATE | End date field to store an end date. |
| 8 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 9 | DESCR60 | Character(60) | VARCHAR2(60) NOT NULL | Description |
| 10 | REL_TXN_SYNCID | Number(10,0) | DECIMAL(10) NOT NULL | SYNCID of the related transaction. Used by Task Management. |
| 11 | DESCRLONG | Long Character | CLOB | Long Description |