|
|
Fusion Key Flexfields
|
EBS Key FlexField
|
|
Types
|
- People Group - HR
- Cost Allocation - Payroll |
- Personal Analysis
- Grade - Job - Position - People Group - Cost Allocation |
|
Table
Information
|
information is stored in same table. Ex: Job
data is stored in per_jobs_f
|
Information is stored in different tables.
Ex: per_jobs_f and per_job_definitions
|
Commonly used database tables in Fusion HR
application
Most of the tables in Fusion Applications are inherited from
Oracle eBusiness Suite, but there are additions and modifications in the data
model. The tables are more normalized and represents the information it is
storing. Some of the commonly used tables are -
|
Table Name
|
Alias Name
|
Suggested Join
|
|
PER_ALL_PEOPLE_F
|
PAPF
|
|
|
PER_PERSON
|
PP
|
PAPF.PERSON_ID = PP.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN
PAPF.EFFECTIVE_START_DATE AND PAPF.EFFECTIVE_END_DATE
|
|
PER_NATIONAL_IDENTIFIERS
|
NID
|
PAPF.PERSON_ID = NID.PERSON_ID
AND NID.NATIONAL_IDENTIFIER_TYPE = 'SSN'
|
|
PER_ETHNICITIES
|
PE
|
PAPF.PERSON_ID=PE.PERSON_ID
|
|
PER_PERSON_NAMES_F
|
PPNF
|
PAPF.PERSON_ID = PPNF.PERSON_ID
AND UPPER(PPNF.NAME_TYPE)='GLOBAL'
AND TRUNC(SYSDATE) BETWEEN
PPNF.EFFECTIVE_START_DATE AND PPNF.EFFECTIVE_END_DATE
|
|
PER_PHONES
|
PPH
|
PAPF.PERSON_ID = PPH.PERSON_ID
PPH.PHONE_TYPE = 'H1'
|
|
PER_PEOPLE_LEGISLATIVE_F
|
PPLF
|
PAPF.PERSON_ID = PPLF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE
AND PPLF.EFFECTIVE_END_DATE
|
|
PER_EMAIL_ADDRESSES
|
PEA
|
PAPF.PERSON_ID = PEA.PERSON_ID
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_ID=ADRU.PERSON_ID
AND ADRU.ADDRESS_TYPE = 'HOME'
AND TRUNC(SYSDATE) BETWEEN
ADRU.EFFECTIVE_START_DATE AND ADRU.EFFECTIVE_END_DATE
|
|
PER_ADDRESSES_F
|
PA
|
ADRU.ADDRESS_ID = PA.ADDRESS_ID
AND TRUNC(SYSDATE) BETWEEN
PA.EFFECTIVE_START_DATE AND PA.EFFECTIVE_END_DATE
|
|
PER_PERSON_TYPE_USAGES_M
|
PPTU
|
PAPF.PERSON_ID = PPTU.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN PPTU.EFFECTIVE_START_DATE
ANDPPTU.EFFECTIVE_END_DATE
|
|
PER_PERSON_TYPES
|
PT
|
AND PUF.PERSON_TYPE_ID = PT.PERSON_TYPE_ID
AND PT.SYSTEM_PERSON_TYPE IN
('CON',’EMP’)
|
|
FND_LOOKUP_VALUES_TL
|
FLVT7
|
AND PE.ETHNICITY=FLVT7.LOOKUP_CODE
AND FLVT7.LOOKUP_TYPE='PER_ETHNICITY'
AND FLVT7.LANGUAGE='US'
|
|
FND_LOOKUP_VALUES_TL
|
FLVT8
|
AND PPLF.MARITAL_STATUS=FLVT8.LOOKUP_CODE
AND FLVT8.LOOKUP_TYPE='MAR_STATUS'
AND FLVT8.LANGUAGE='US'
|
|
PER_ALL_ASSIGNMENTS_M
|
PAAM
|
PAPF.PERSON_ID = PAAM.PERSON_ID
AND PAM.ASSIGNMENT_TYPE IN (‘E’,’C’)
AND TRUNC(SYSDATE) BETWEEN
PAAM.EFFECTIVE_START_DATE AND PAAM.EFFECTIVE_END_DATE
|
|
PER_ASSIGNMENT_STATUS_TYPES_TL
|
PASTT
|
PAAM.ASSIGNMENT_STATUS_TYPE_ID=PASTT.ASSIGNMENT_STATUS_TYPE_ID
|
|
PER_ASSIGN_WORK_MEASURES_F
|
PAWMF
|
PAAM.ASSIGNMENT_ID=PAWMF.ASSIGNMENT_ID
PAWMF.UNIT='FTE'
|
|
PER_ASSIGNMENT_SUPERVISORS_F
|
PASF
|
PASF.MANAGER_ID=PAPF.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN
PASF.EFFECTIVE_START_DATE AND PASF.EFFECTIVE_END_DATE
|
|
PER_PERIODS_OF_SERVICE
|
PPOS
|
PAAM.PERIOD_OF_SERVICE_ID=PPOS.PERIOD_OF_SERVICE_ID
|
|
CMP_SALARY
|
CS
|
PAAM.ASSIGNMENT_ID=CS.ASSIGNMENT_ID
|
|
CMP_SALARY_BASES
|
CSB
|
CS.SALARY_BASIS_ID=CSB.SALARY_BASIS_ID
|
|
HR_LOCATIONS_ALL_F_VL
|
HLAFV
|
PAAM.LOCATION_ID=HLAFV.LOCATION_ID
AND TRUNC(SYSDATE) BETWEEN
HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE
|
|
PER_DEPARTMENTS
|
PD
|
PAAMV.ORGANIZATION_ID=PD.ORGANIZATION_ID
AND TRUNC(SYSDATE) BETWEEN
PD.EFFECTIVE_START_DATE AND PD.EFFECTIVE_END_DATE
|
|
PER_JOBS_F_VL
|
HLAFV
|
PAAM.JOB_ID=PJFV.JOB_ID
AND TRUNC(SYSDATE) BETWEEN
HLAFV.EFFECTIVE_START_DATE AND HLAFV.EFFECTIVE_END_DATE
|
|
PER_GRADES_F_TL
|
PGFT
|
PAAMV.GRADE_ID=PGFT.GRADE_ID
AND TRUNC(SYSDATE) BETWEEN
PGFT.EFFECTIVE_START_DATE AND PGFT.EFFECTIVE_END_DATE
AND PGFT.LANGUAGE(+)='US'
|
|
HR_ORGANIZATION_UNITS_F_TL
|
HOU_TL
|
PAAMV.BUSINESS_UNIT_ID =
HOU_TL.ORGANIZATION_ID
AND HOU_TL.LANGUAGE='US'
AND TRUNC(SYSDATE) BETWEEN
HOU_TL_TL.EFFECTIVE_START_DATE AND HO.EFFECTIVE_END_DATE
|