SPF_WO_PGC1_VW(SQL View) |
Index Back |
---|---|
sPro Fluid ApprovalsPro Fluid Approval |
SELECT A.BUSINESS_UNIT , A.WORK_ORDER_ID , ' ' , A.WO_NAME , A.SP_WO_TYPE , A.START_DATE , ' ' , A.END_DATE , ' ' , A.DEPTID , ' ' , A.WO_CLIID , ' ' , A.ENGAGEMENT_MNGR , ' ' , B.SPF_JOB_DESCRLONG FROM PS_SPF_WORDERREC A , PS_SPF_WORDERREC_2 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_ORDER_ID = B.WORK_ORDER_ID |
# | 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 | BU_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Business unit description. |
4 | WO_NAME | Character(30) | VARCHAR2(30) NOT NULL | Work Order Name |
5 | 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 |
6 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
7 | SP_START_DATE | Character(30) | VARCHAR2(30) NOT NULL | sPro Fluid Approval |
8 | END_DATE | Date(10) | DATE | End Date |
9 | SP_END_DATE | Character(30) | VARCHAR2(30) NOT NULL | sPro Fluid Approval |
10 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
11 | DEPT_DESCR | Character(30) | VARCHAR2(30) NOT NULL | Department ID Description |
12 | WO_CLIID | Character(30) | VARCHAR2(30) NOT NULL | Requester |
13 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
14 | ENGAGEMENT_MNGR | Character(30) | VARCHAR2(30) NOT NULL | Engagement Manager |
15 | SP_ENGAGEMENT_MGR | Character(30) | VARCHAR2(30) NOT NULL | Engagement Manager |
16 | SPF_JOB_DESCRLONG | Long Character | CLOB | stores the job description for a sp requisition. |