RS_ED_WKR_ACOMP

(SQL View)
Index Back

ETL Worker Accomplishments


SELECT A.EMPLID , A.ACCOMPLISHMENT , B.ACCOMP_CATEGORY , '' , B.DESCR , A.MAJOR_CODE , A.STATE , A.COUNTRY FROM PS_ACCOMPLISHMENTS A , PS_ACCOMP_TBL B , PS_RS_ED_ETL_LOG L , PS_EID_ETL_LASTRUN R WHERE A.ACCOMPLISHMENT = B.ACCOMPLISHMENT AND L.DOCUMENT = A.EMPLID AND R.EID_DS_ID = 'Resources' AND L.DTTM_MODIFIED >= R.LAST_RUN_DTM

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment
3 ACCOMP_CATEGORY Character(3) VARCHAR2(3) NOT NULL Accomplishment Category
DEG=Degree
HON=Honor or Award
LIC=License or Certification
LNG=Language
MEM=Membership
NVQ=NVQ
TST=Test
4 DESCR_CATEGORY Character(30) VARCHAR2(30) NOT NULL Category Description
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 MAJOR_CODE Character(10) VARCHAR2(10) NOT NULL Major Code
7 STATE Character(6) VARCHAR2(6) NOT NULL State
8 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country