XML_DLT_CNAE_VW

(SQL View)
 Index Back

CNAE Delta filter

Allow load CNAE for XML file Delta

SELECT A.EMPLID ,A.INCIDENT_DT ,ES.INDSTRY_CD_ESP ,I.DESCR50 FROM PS_ESTAB_SSEC_ESP ES , PS_XML_JOB_ESP_VW A ,PS_INDSTRY_ACT_ESP I WHERE A.ESTABID=ES.ESTABID AND A.SSN_EMPLOYER=ES.SSN_EMPLOYER AND ES.INDSTRY_CD_ESP=I.INDSTRY_CD_ESP AND ES.EFFDT<=A.INCIDENT_DT AND ES.EFFDT = ( SELECT MAX(A_ED.EFFDT) FROM PS_ESTAB_SSEC_ESP A_ED WHERE A.ESTABID=ES.ESTABID AND A.SSN_EMPLOYER=ES.SSN_EMPLOYER) AND I.EFFDT<=A.INCIDENT_DT AND I.EFFDT = ( SELECT MAX(A_E.EFFDT) FROM PS_INDSTRY_ACT_ESP A_E WHERE I.INDSTRY_CD_ESP=A_E.INDSTRY_CD_ESP)

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 INCIDENT_DT Date(10) DATE Incident Date
3 INDSTRY_CD_ESP Character(5) VARCHAR2(5) NOT NULL Industry Activity Code
4 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50