FND Design Data [Home] [Help]

View: HR_ADP_WORKERS_COMP_V

Product: PER - Human Resources
Description: ADP payroll interface view
Implementation/DBA Data: ViewAPPS.HR_ADP_WORKERS_COMP_V
View Text

SELECT REF.COMPANY_CODE_EQUIVALENT
, HOU.NAME
, HS.SEGMENT1
, PASG.ORGANIZATION_ID
, PP.EMPLOYEE_NUMBER
, PP.PERSON_ID
, PP.BUSINESS_GROUP_ID
, DECODE(PTP.NUMBER_PER_FISCAL_YEAR
, 52
, 'W'
, 24
, 'S'
, 26
, 'B'
, 12
, 'M'
, PTP.NUMBER_PER_FISCAL_YEAR)
, PASG.ASSIGNMENT_ID
, PASG.ASSIGNMENT_NUMBER
, DECODE(PASG.PRIMARY_FLAG
, 'Y'
, 0
, PASG.ASSIGNMENT_SEQUENCE)
, PASG.PRIMARY_FLAG
, PJT.NAME
, NVL(HS.SEGMENT8
, PJW.WC_CODE)
, HL.REGION_2
, GREATEST( GREATEST(NVL(PP.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PP.EFFECTIVE_START_DATE)
, GREATEST(NVL(PASG.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PASG.EFFECTIVE_START_DATE)
, GREATEST(NVL(PJ.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))
, PJ.DATE_FROM)
, NVL(PJW.LAST_UPDATE_DATE
, TO_DATE('1900/01/01'
, 'YYYY/MM/DD'))) FROM HR_ADP_EMP_REF_V REF
, HR_ALL_ORGANIZATION_UNITS HOU
, HR_SOFT_CODING_KEYFLEX HS
, HR_LOCATIONS_ALL HL
, PAY_JOB_WC_CODE_USAGES PJW
, PER_JOBS_TL PJT
, PER_JOBS PJ
, PER_ALL_PEOPLE_F PP
, PER_ALL_ASSIGNMENTS_F PASG
, PER_TIME_PERIOD_TYPES PTP
, PAY_PAYROLLS_X PPR
WHERE PPR.PERIOD_TYPE = PTP.PERIOD_TYPE
AND PASG.ASSIGNMENT_TYPE = 'E'
AND PPR.PAYROLL_ID = PASG.PAYROLL_ID
AND HS.SOFT_CODING_KEYFLEX_ID = PASG.SOFT_CODING_KEYFLEX_ID
AND HS.SEGMENT1 = HOU.ORGANIZATION_ID
AND PASG.PERSON_ID = PP.PERSON_ID
AND PASG.ASSIGNMENT_ID = REF.ASSIGNMENT_ID
AND PASG.JOB_ID = PJ.JOB_ID
AND PJT.JOB_ID = PJ.JOB_ID
AND PJT.LANGUAGE = USERENV('LANG')
AND PASG.LOCATION_ID = HL.LOCATION_ID
AND PASG.JOB_ID = PJW.JOB_ID
AND PASG.EFFECTIVE_START_DATE = (SELECT MAX(A2.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F A2
WHERE (A2.EFFECTIVE_START_DATE <= TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE)
AND A2.ASSIGNMENT_ID=PASG.ASSIGNMENT_ID))
AND PP.EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(HR_ADP.GET_ADP_EXTRACT_DATE) BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE
AND HL.REGION_2 = PJW.STATE_CODE

Columns

Name
COMPANY_CODE_EQUIVALENT
GRE_NAME
GRE_ID
ORGANIZATION_ID
EMPLOYEE_NUMBER
PERSON_ID
BUSINESS_GROUP_ID
PAY_FREQUENCY
ASSIGNMENT_ID
ASSIGNMENT_NUMBER
ASSIGNMENT_SEQUENCE
PRIMARY_FLAG
JOB_NAME
WORKERS_COMP_CODE
WORK_STATE_CODE
GREATEST_LAST_UPDATE_DATE