SPF_WO_FSRV_VW(SQL View) |
Index Back |
|---|---|
WOFilled Services InformationWO Filled and corresponding Services work order created Information related view |
| SELECT BUSINESS_UNIT , WORK_ORDER_ID , ROLE_TYPE , PROJ_ROLE , WO_CONID , WO_CLIID , START_DATE , END_DATE , ACT_START_DT , DURATION , WO_RATE , SERVICE_METHOD , MRSC_PARENT_WOID , SEQNBR , CURRENCY_CD , LOCATION , WO_STATUS , COMPUNIT , SP_REP_ACT_START , WO_EXP_RATE , SPF_EXPENSE_AMT , POAMOUNT , SPF_EXP_AMT_BSE , LINKEDWORDER , VENDOR_ID , SP_REQ_ID , SP_WO_TYPE , LINE_NBR , SUB_LINE , ROW_CREATE_USER , BID_ID FROM PS_SPF_WORDERREC WHERE MRSC_PARENT_WOID <> ' ' AND SEQNBR > 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 4 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 5 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 6 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL | Requester |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_DATE | Date(10) | DATE | End Date |
| 9 | ACT_START_DT | Date(10) | DATE | Activity Start Date |
| 10 | DURATION | Number(5,0) | INTEGER NOT NULL | Recurrence Duration |
| 11 | WO_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | WorkOrder Rate |
| 12 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 13 | MRSC_PARENT_WOID | Character(15) | VARCHAR2(15) NOT NULL | Multi Resource Parent WOID |
| 14 | SEQNBR | Number(5,0) | INTEGER NOT NULL | Sequence Number |
| 15 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 16 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 17 | WO_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Status
A=Approved C=Closed D=Denied F=Finalize L=Released N=Canceled O=Open P=Pending Terminate S=Submitted T=Terminated |
| 18 | COMPUNIT | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 19 | SP_REP_ACT_START | Character(1) | VARCHAR2(1) NOT NULL |
Y/N field to indicate if the replacement action started or not
C=Assign button clicked E=Replacment Ended N=Replacement Not Started S=Replacement Started X=Replacement Cancelled |
| 20 | WO_EXP_RATE | Signed Number(16,4) | DECIMAL(14,4) NOT NULL | Expense Rate |
| 21 | SPF_EXPENSE_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount. |
| 22 | POAMOUNT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Purchase Order / Work Order Amount |
| 23 | SPF_EXP_AMT_BSE | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total expense amount for base currency |
| 24 | LINKEDWORDER | Character(15) | VARCHAR2(15) NOT NULL | Linked Work Order |
| 25 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |
| 26 | SP_REQ_ID | Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 27 | SP_WO_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
WorkOrder Type classified as original, extension, reassign wo
E=Extension O=Original P=Replacement R=Reassign Work Order |
| 28 | LINE_NBR | Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 29 | SUB_LINE | Character(1) | VARCHAR2(1) NOT NULL |
Sub Line
N=No Y=Yes |
| 30 | ROW_CREATE_USER | Character(30) | VARCHAR2(30) NOT NULL | Row Added By |
| 31 | BID_ID | Number(10,0) | DECIMAL(10) NOT NULL | Bid Id |