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
|
ليست هناك تعليقات:
إرسال تعليق