BUSINESS_UNITSO_IDSO_LINEPrompt Table: FO_BRANCH_TBL
Prompt Table: FO_CUST_AL_SRCH
Prompt Table: FO_ORDER_TYPE
FO_ORDR_INFO(SQL View) |
Index Back |
|---|
| SELECT B.BUSINESS_UNIT , B.SO_ID , B.SO_LINE , A.OWNERSHIP_ID , B.CUST_ID , A.END_EST_DATE , B.SALARY_RANGE_MIN , B.SALARY_RANGE_MAX , A.USER_ORDER_TYPE , B.REG_BILL_RATE , B.REG_PAY_RATE , B.START_DT FROM %Table(RS_SO_HDR) A , %Table(RS_SO_LINE) B WHERE A.SYSTEM_SOURCE='STF' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.SO_ID = B.SO_ID AND B.SO_LINE_STATUS = 'U' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | SO_ID |
Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
| 3 | SO_LINE |
Number(3,0) | SMALLINT NOT NULL | Line Number |
| 4 | OWNERSHIP_ID | Character(30) | VARCHAR2(30) NOT NULL |
Owning Organization
Prompt Table: FO_BRANCH_TBL |
| 5 | 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.
Prompt Table: FO_CUST_AL_SRCH |
| 6 | END_EST_DATE | Date(10) | DATE | Estimated End Date |
| 7 | SALARY_RANGE_MIN | Number(11,2) | DECIMAL(10,2) NOT NULL | Salary Range |
| 8 | SALARY_RANGE_MAX | Number(11,2) | DECIMAL(10,2) NOT NULL | Maximum Salary Range |
| 9 | USER_ORDER_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
User Order Type
Prompt Table: FO_ORDER_TYPE |
| 10 | REG_BILL_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Bill Rate |
| 11 | REG_PAY_RATE | Number(19,6) | DECIMAL(18,6) NOT NULL | Pay Rate |
| 12 | START_DT | Date(10) | DATE | Start Date |