BUSINESS_UNITPrompt Table: SP_BU_SP_NONVW
WORK_ORDER_IDD=Deliverable
M=Multi Resource
R=Resource
A=Approved
C=Closed
D=Denied
F=Finalize
L=Released
N=Canceled
O=Open
P=Pending Terminate
S=Submitted
T=Terminated
SP_WO_HCMERR_VW(SQL View) |
Index Back |
|---|---|
work order view |
| SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , B.WO_NAME , A.PERSON_ID , B.RECRUITER , B.SERVICE_METHOD , B.WO_STATUS , B.LOCATION , A.SEQNUM , C.NAME FROM PS_SP_HCMACK_ERR A , PS_SPF_WORDERREC B , PS_SPB_PERSON_TBL C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID AND C.PERSON_ID = B.RECRUITER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_SP_NONVW |
| 2 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 3 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
| 4 | WO_CONID | Character(15) | VARCHAR2(15) NOT NULL | Service Provider's ID assigned on work order |
| 5 | RECRUITER | Character(15) | VARCHAR2(15) NOT NULL | Service Coordinator |
| 6 | SERVICE_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Service Method
D=Deliverable M=Multi Resource R=Resource |
| 7 | 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 |
| 8 | LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Location Code |
| 9 | SEQNUM | Number(3,0) | SMALLINT NOT NULL | Sequence Number |
| 10 | NAME_DISPLAY | Character(50) | VARCHAR2(50) NOT NULL | Name Display |