BUSINESS_UNITSP_REQ_IDLINE_NBRA=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
APR=Approver
MGR=Manager
OPR=Operator
E=Extension
O=Original
P=Replacement
R=Reassign Work Order
SPB_WO_REQ_VW(SQL View) |
Index Back |
|---|---|
Requisition Work Order ViewRequisition Work Order View |
| SELECT business_unit , sp_req_id , line_nbr , work_order_id , wo_status , role_type , proj_role , start_date , end_date ,SP_WO_TYPE FROM PS_SPF_WORDERREC WHERE SP_REQ_ID IS NOT NULL AND LINE_NBR <> 0 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SP_REQ_ID |
Character(10) | VARCHAR2(10) NOT NULL | Service Request ID |
| 3 | LINE_NBR |
Number(5,0) | INTEGER NOT NULL | Line Number: 11/24/08 - Added TARGET label [PC product] |
| 4 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 5 | 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 |
| 6 | ROLE_TYPE | Character(6) | VARCHAR2(6) NOT NULL |
Service Type
APR=Approver MGR=Manager OPR=Operator |
| 7 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL | Project Role |
| 8 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 9 | END_DATE | Date(10) | DATE | End Date |
| 10 | 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 |