RS_ED_ELGBLWKR

(SQL View)
 Index Back

ETL Eligible Worker

Eligible Worker view for Endeca ESA Project Discoverer ETL process.

SELECT A.EMPLID , B.NAME , A.JOBCODE_DESCR , A.SUPERVISOR_ID , B.PER_STATUS , B.CITY , S.DESCR AS STATE , B.COUNTRY , B.POSTAL , C.BILL_RATE_CV AS BILL_RATE , I.CURRENCY_CD , A.POOL_ID , A.POOL_NAME , R.SETID AS SETID_REGION , R.REGION_CD , R.DESCR AS REGION , %Coalesce(F.ATTACHSYSFILENAME, 'N/A') , A.STD_HOURS , CASE WHEN A.LAST_PROFILE_DTTM >= A.DTTM_IN_EFFECT THEN A.LAST_PROFILE_DTTM ELSE A.DTTM_IN_EFFECT END AS LAST_PROFILE_DTTM , A.LASTUPDDTTM FROM (%Sql(RS_ED_EFFDT_WKR_SEL)) A LEFT OUTER JOIN PS_RS_ATTACHMENTS F ON A.EMPLID = F.EMPLID , (%Sql(RS_ED_REGION_SEL)) R , PS_INSTALLATION_RS I , PS_EID_ETL_LASTRUN L , PS_RS_ELGBL_WRKR C , PS_PERSONAL_DATA B LEFT OUTER JOIN PS_STATE_TBL S ON (B.STATE = S.STATE AND B.COUNTRY = S.COUNTRY) WHERE A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND C.SYSTEM_SOURCE = 'RS' AND C.SETID_REGION = R.SETID AND C.REGION_CD = R.REGION_CD AND L.EID_DS_ID = 'Resources' AND (A.LASTUPDDTTM >= L.LAST_RUN_DTM OR A.DTTM_IN_EFFECT >= L.LAST_RUN_DTM)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 NAME Character(50) VARCHAR2(50) NOT NULL Name
3 JOBCODE_DESCR Character(30) VARCHAR2(30) NOT NULL Jobcode Description
4 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
5 PER_STATUS Character(1) VARCHAR2(1) NOT NULL Personnel Status
E=Employee
N=Non-Employee
6 CITY Character(30) VARCHAR2(30) NOT NULL City
7 STATE Character(6) VARCHAR2(6) NOT NULL State
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
9 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
10 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
11 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
12 POOL_ID Character(10) VARCHAR2(10) NOT NULL Pool ID field.
13 POOL_NAME Character(30) VARCHAR2(30) NOT NULL 11/15/2004- FS
14 SETID_REGION Character(5) VARCHAR2(5) NOT NULL Region SetID
15 REGION_CD Character(10) VARCHAR2(10) NOT NULL Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to.
16 REGION Character(30) VARCHAR2(30) NOT NULL Geographic Region
17 ATTACHSYSFILENAME Character(128) VARCHAR2(128) NOT NULL Unique Sys Filename
18 STD_HOURS Number(7,2) DECIMAL(6,2) NOT NULL Standard Hours
19 LAST_PROFILE_DTTM DateTime(26) TIMESTAMP Last Profile Change
20 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.