USERIDBUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
EXPECTED_DATEWORK_ORDER_IDSP_TASKIDSPF_E_LGTASK_VW(SQL View) |
Index Back |
|---|
| SELECT C.ASSIGNED_TO ,C.BUSINESS_UNIT ,C.EXPECTED_DATE ,C.WORK_ORDER_ID ,C.SP_TASKID ,K.SP_TASK_DSCR_SHRT ,W.WO_CONID ,P.NAME FROM PS_SPB_TASK K ,PS_SPF_TASK_CHKLST C , PS_SPF_WORDERREC W , PS_SPB_PERSON_TBL P , PS_SET_CNTRL_GROUP S WHERE C.BUSINESS_UNIT = W.BUSINESS_UNIT AND C.BUSINESS_UNIT = S.SETCNTRLVALUE AND S.REC_GROUP_ID = 'SP_06' AND S.SETID = K.SETID AND C.SP_TASKID = K.SP_TASKID AND C.WORK_ORDER_ID = W.WORK_ORDER_ID AND W.WO_CONID = P.PERSON_ID AND W.WO_STATUS IN ('O','S','A','D') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 3 | EXPECTED_DATE |
Date(10) | DATE | Expected By |
| 4 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 5 | SP_TASKID |
Number(15,0) | DECIMAL(15) NOT NULL | Logistical Task ID |
| 6 | SP_TASK_DSCR_SHRT | Character(30) | VARCHAR2(30) NOT NULL | Task Short Description |
| 7 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 8 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |