308921237 Tables in Fusion HCM PDF

Preview

Summary

Tables in Fusion HCM...

Description

Database tables in Fusion HR Table Name PER_ALL_PEOPLE_F PER_PERSON

Alias Name PAPF PP

Suggested Join

PAPF.PERSON_I D = PP.PERSON_I D AND TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE

PER_NATI ONAL_I DENTI FI ER S PER_ETHNI CI TI ES PER_PERSON_NAMES_F

NI D

PAPF.PERSON_I D = NI D.PERSON_I D AND NID.NATIONAL_IDENTIFIER_TYPE = 'SSN'

PE PPNF

PAPF.PERSON_I D= PE.PERSON_I D PAPF.PERSON_I D = PPNF.PERSON_I D AND UPPER(PPNF.NAME_TYPE)='GLOBAL' AND TRUNC(SYSDATE) BETWEEN PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE

PER_PHONES

PPH

PER_PEOPLE_LEGI SLATI VE_F

PPLF

PAPF.PERSON_I D = PPH.PERSON_I D PPH.PHONE_TYPE = 'H1'

PAPF.PERSON_I D = PPLF.PERSON_I D AND TRUNC(SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE AND PPLF.EFFECTIVE_END_DATE

PER_EMAI L_ADDRESSES

PEA

PAPF.PERSON_I D = PEA.PERSON_I D AND PEA.EMAIL_TYPE = 'W1' AND TRUNC(SYSDATE) BETWEEN PEA.EFFECTIVE_START_DATE AND PEA.EFFECTIVE_END_DATE

PER_PERSON_ADDR_USAGES _F

ADRU

PAPF.PERSON_I D= ADRU.PERSON_I D AND ADRU.ADDRESS_TYPE = 'HOME' AND TRUNC(SYSDATE) BETWEEN ADRU.EFFECTIVE_START_DATE AND ADRU.EFFECTIVE_END_DATE

PER_ADDRESSES_F

PA

ADRU.ADDRESS_I D = PA.ADDRESS_I D AND TRUNC(SYSDATE) BETWEEN PA.EFFECTIVE_START_DATE AND PA.EFFECTIVE_END_DATE

PER_PERSON_TYPE_USAGES _M

PPTU

PER_PERSON_TYPES

PT

PAPF.PERSON_I D = PPTU.PERSON_I D AND TRUNC(SYSDATE) BETWEEN PPTU.EFFECTIVE_START_DATE AND PPTU.EFFECTIVE_END_DATE AND PUF.PERSON_TYPE_I D = PT.PERSON_TYPE_I D AND PT.SYSTEM_PERSON_TYPE IN ('CON',’EMP’)

FND_LOOKUP_VALUES_TL

FLVT7

FND_LOOKUP_VALUES_TL

FLVT8

PER_ALL_ASSI GNMENTS_M

PAAM

AND AND AND AND AND AND

PE.ETHNI CI TY= FLVT7.LOOKUP_CODE FLVT7.LOOKUP_TYPE= 'PER_ETHNI CI TY' FLVT7.LANGUAGE= 'US' PPLF.MARI TAL_STATUS= FLVT8.LOOKUP_CODE FLVT8.LOOKUP_TYPE= 'MAR_STATUS' FLVT8.LANGUAGE= 'US'

PAPF.PERSON_I D = PAAM.PERSON_I D AND PAM.ASSIGNMENT_TYPE IN (‘E’,’C’) AND TRUNC(SYSDATE) BETWEEN PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE

PER_ASSI GNMENT_STATUS_ TYPES_TL PER_ASSI GN_WORK_MEASU RES_F PER_ASSI GNMENT_SUPERVI SORS_F

PASTT

PER_PERI ODS_OF_SERVI CE

PPOS

PAAM.PERI OD_OF_SERVI CE_I D= PPOS.PERI OD_OF_SERVI CE_I D

CMP_SALARY CMP_SALARY_BASES

CS CSB

PAAM.ASSI GNMENT_I D= CS.ASSI GNMENT_I D CS.SALARY_BASI S_I D= CSB.SALARY_BASI S_I D

HR_LOCATI ONS_ALL_F_VL

HLAFV

PAAM.LOCATI ON_I D= HLAFV.LOCATI ON_I D

PAWMF

PAAM.ASSI GNMENT_STATUS_TYPE_I D= PASTT.ASSI GNMENT_STA TUS_TYPE_I D PAAM.ASSI GNMENT_I D= PAWMF.ASSI GNMENT_I D PAWMF.UNIT='FTE'

PASF

PASF.MANAGER_I D= PAPF.PERSON_I D AND TRUNC(SYSDATE) BETWEEN PASF.EFFECTIVE_START_DATE AND PASF.EFFECTIVE_END_DATE

AND TRUNC(SYSDATE) BETWEEN HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE

PER_DEPARTMENTS

PD

PAAMV.ORGANI ZATI ON_I D= PD.ORGANI ZATI ON_I D AND TRUNC(SYSDATE) BETWEEN PD.EFFECTIVE_START_DATE AND PD.EFFECTIVE_END_DATE

PER_JOBS_F_VL

HLAFV

PAAM.JOB_I D= PJFV.JOB_I D AND TRUNC(SYSDATE) BETWEEN HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE

PER_GRADES_F_TL

PGFT

PAAMV.GRADE_I D= PGFT.GRADE_I D AND TRUNC(SYSDATE) BETWEEN PGFT.EFFECTIVE_START_DATE AND PGFT.EFFECTIVE_END_DATE AND PGFT.LANGUAGE(+)='US'...