RS_ED_ORDERS

(SQL View)
 Index Back

ETL Service Order Requests

Service Order Requests view for Endeca ESA Project Discovery ETL process.

SELECT A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.DESCR60 , A.LINE_DESCR , A.DOCUMENT_SOURCE , A.SO_LINE_STATUS , A.SO_DATE , A.CUST_SETID , A.CUST_ID , A.CONTRACT_NUM , A.PROJECT_ID , A.PROJ_DESCR , A.CITY , A.STATE , A.COUNTRY , A.POSTAL , A.LASTUPDDTTM , B.COMPETENCY , B.DESCR , B.PRO , '' , B.YEARS_OF_EXP FROM (%Sql(RS_ED_SO_LINES_SEL)) A LEFT OUTER JOIN (%Sql(RS_ED_SO_COMP_SEL)) B ON B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.SO_ID = A.SO_ID AND B.SO_LINE = A.SO_LINE

# 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 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
5 LINE_DESCR Character(30) VARCHAR2(30) NOT NULL Describes the nature of a journal line. It is defaulted from the description of the Account ChartField or manually entered.
6 DOCUMENT_SOURCE Character(30) VARCHAR2(30) NOT NULL Document Source for AIA
7 SO_LINE_STATUS Character(1) VARCHAR2(1) NOT NULL Line Status
A=Closed
C=Cancel
O=Open
8 SO_DATE Date(10) DATE Service Order Date
9 CUST_SETID Character(5) VARCHAR2(5) NOT NULL Customer SetID
10 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.
11 CONTRACT_NUM Character(25) VARCHAR2(25) NOT NULL Contract
12 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
13 PROJ_DESCR Character(30) VARCHAR2(30) NOT NULL Project ID Description
14 CITY Character(30) VARCHAR2(30) NOT NULL City
15 STATE Character(6) VARCHAR2(6) NOT NULL State
16 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
17 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
18 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
19 COMPETENCY Character(8) VARCHAR2(8) NOT NULL Competency
20 RS_COMPETENCY_DESC Character(30) VARCHAR2(30) NOT NULL Competency
21 PRO Character(32) VARCHAR2(32) NOT NULL Proficiency
22 INTEREST_LEVEL Character(1) VARCHAR2(1) NOT NULL Interest Level
23 YEARS_OF_EXP Number(5,1) DECIMAL(4,1) NOT NULL Years of Work Experience