UNFILLD_RPT_VW2(SQL View) |
Index Back |
|---|
| SELECT A.BUSINESS_UNIT , A.SERVICE_OPRID , A.ORDER_ID ,A.OWNERSHIP_ID , A.ORDER_STATUS , A.MANAGER_CONTACT_ID , A.START_DATE , A.END_EST_DATE , A.QTY_INTEGER , A.JOBCODE , A.WEEKLY_HOURS , A.REG_BILL_RATE , A.CUST_ID , A.USER_ORDER_TYPE , A.DEPTID , A.SALARY_RANGE_MAX ,A.INITIAL_COMP , A.QTY_ACTIVE_CNT , B.FEE_SCHEDULE , B.FEE_PCT FROM PS_UNFILLED_RPT_VW A , PS_FO_ORDR_SUPP_VW B WHERE A.ORDER_ID = B.ORDER_ID(+) AND A.BUSINESS_UNIT = B.BUSINESS_UNIT(+) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SERVICE_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Service Operator |
| 3 | ORDER_ID | Character(25) | VARCHAR2(25) NOT NULL | Order ID |
| 4 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL | Owning Organization |
| 5 | ORDER_STATUS | Character(3) | VARCHAR2(3) NOT NULL |
Order Status
C=Closed O=Open P=Pending X=Canceled |
| 6 | MANAGER_CONTACT_ID | Character(15) | VARCHAR2(15) NOT NULL | Order Contact |
| 7 | START_DATE | Date(10) | DATE | Start Date for Gen Standing PO |
| 8 | END_EST_DATE | Date(10) | DATE | Estimated End Date |
| 9 | QTY_INTEGER | Number(11,0) | DECIMAL(11) NOT NULL | Quantity Rounded to 0 Decimals |
| 10 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 11 | WEEKLY_HOURS | Number(6,2) | DECIMAL(5,2) NOT NULL | Schedule Hours |
| 12 | REG_BILL_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Bill Rate |
| 13 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL | Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations. |
| 14 | USER_ORDER_TYPE | Character(5) | VARCHAR2(5) NOT NULL | User Order Type |
| 15 | DEPTID | Character(10) | VARCHAR2(10) NOT NULL | Department |
| 16 | SALARY_RANGE_MAX | Number(11,2) | DECIMAL(10,2) NOT NULL | Maximum Salary Range |
| 17 | INITIAL_COMP | Number(11,2) | DECIMAL(10,2) NOT NULL | Compensation |
| 18 | QTY_ACTIVE_CNT | Number(4,0) | SMALLINT NOT NULL | Active Count |
| 19 | FEE_SCHEDULE | Character(50) | VARCHAR2(50) NOT NULL | Fee Schedule |
| 20 | FEE_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Fee Percentage |