1. Reference for Fusion HCM Analytics
  2. Relationship Diagram

3 Relationship Diagram

Overview

This chapter provides information on all the key transactional tables within Oracle Fusion HCM Analytics and their relationship with the other setup or transactional tables. The information is represented with the main table at the center of the diagram with all the other tables joined to it.

Relationship Diagram Details

Global Human Resources

DW_ABS_ACRL_ENTRY_DETAIL_EF

This data model represents the DW_ABS_ACRL_ENTRY_DETAIL_EF relationships with Dimensions.

DW_ABS_ACRL_ENTRY_DETAIL_F

This data model represents the DW_ABS_ACRL_ENTRY_DETAIL_F relationships with Dimensions.

DW_ABS_ACRL_ENTRY_EF

This data model represents the DW_ABS_ACRL_ENTRY_EF relationships with Dimensions.

DW_ABS_DAILY_DETAIL_EF

This data model represents the DW_ABS_DAILY_DETAIL_EF relationships with Dimensions.

DW_ABS_DAILY_DETAIL_F

This data model represents the DW_ABS_DAILY_DETAIL_F relationships with Dimensions.


Description of the illustration er_dw_abs_daily_detail_f.svg
DW_ABS_ENTRY_DETAIL_F

This data model represents the DW_ABS_ENTRY_DETAIL_F relationships with Dimensions.

DW_ABS_ENTRY_EVENT_EF

This data model represents the DW_ABS_ENTRY_EVENT_EF relationships with Dimensions.

DW_CMP_ASG_SALARY_F

This data model represents the DW_CMP_ASG_SALARY_F relationships with Dimensions.

DW_CMP_CWB_PERSON_INFO_EF

This data model represents the DW_CMP_CWB_PERSON_INFO_EF relationships with Dimensions.

DW_CMP_CWB_PERSON_RATE_EF

This data model represents the DW_CMP_CWB_PERSON_RATE_EF relationships with Dimensions.

DW_CMP_CWB_PERSON_RATE_F

This data model represents the DW_CMP_CWB_PERSON_RATE_F relationships with Dimensions.

DW_CMP_PERSON_BUDGET_EF

This data model represents the DW_CMP_PERSON_BUDGET_EF relationships with Dimensions.

DW_CMP_PERSON_BUDGET_F

This data model represents the DW_CMP_PERSON_BUDGET_F relationships with Dimensions.

DW_CMP_STOCK_DETAIL_EF

This data model represents the DW_CMP_STOCK_DETAIL_EF relationships with Dimensions.

DW_CMP_STOCK_DETAIL_F

This data model represents the DW_CMP_STOCK_DETAIL_F relationships with Dimensions.

DW_PERSON_LEGISLATION_DAILY_EVENT_F

This data model represents the DW_PERSON_LEGISLATION_DAILY_EVENT_F relationships with Dimensions.

DW_PERSON_PERFORMANCE_F

This data model represents the DW_PERSON_PERFORMANCE_F relationships with Dimensions.

DW_PERSON_POTENTIAL_F

This data model represents the DW_PERSON_POTENTIAL_F relationships with Dimensions.

DW_WRKFRC_ASG_DAILY_EVENT_F

This data model represents the DW_WRKFRC_ASG_DAILY_EVENT_F relationships with Dimensions.

DW_WRKFRC_ASG_F

This data model represents the DW_WRKFRC_ASG_F relationships with Dimensions.

DW_WRKFRC_ASG_FTE_F

This data model represents the DW_WRKFRC_ASG_FTE_F relationships with Dimensions.

DW_WRKFRC_ASG_HEADCOUNT_F

This data model represents the DW_WRKFRC_ASG_HEADCOUNT_F relationships with Dimensions.

DW_WRKFRC_ASG_SNAPSHOT_F

This data model represents the DW_WRKFRC_ASG_SNAPSHOT_F relationships with Dimensions.

DW_WRKFRC_ASG_SUPERVISOR_F

This data model represents the DW_WRKFRC_ASG_SUPERVISOR_F relationships with Dimensions.

DW_WRKFRC_GAIN_LOSS_ASG_F

This data model represents the DW_WRKFRC_GAIN_LOSS_ASG_F relationships with Dimensions.

DW_WRKFRC_GAIN_LOSS_ASG_MGRH_F

This data model represents the DW_WRKFRC_GAIN_LOSS_ASG_MGRH_F relationships with Dimensions.

DW_WRKFRC_GAIN_LOSS_MGRH_F

This data model represents the DW_WRKFRC_GAIN_LOSS_MGRH_F relationships with Dimensions.

Goal Management

DW_GOAL_ALIGNMENT_EF

This data model represents the DW_GOAL_ALIGNMENT_EF relationships with Dimensions.

DW_GOAL_DEVELOPMENT_EF

This data model represents the DW_GOAL_DEVELOPMENT_EF relationships with Dimensions.

DW_GOAL_F

This data model represents the DW_GOAL_F relationships with Dimensions.

DW_GOAL_ORGANIZATION_EF

This data model represents the DW_GOAL_ORGANIZATION_EF relationships with Dimensions.

DW_GOAL_PERFORMANCE_A

This data model represents the DW_GOAL_PERFORMANCE_A relationships with Dimensions.

DW_GOAL_PERFORMANCE_EF

This data model represents the DW_GOAL_PERFORMANCE_EF relationships with Dimensions.

Performance Management

DW_PERF_CHECKIN_MEETING_EF

This data model represents the DW_PERF_CHECKIN_MEETING_EF relationships with Dimensions.

DW_PERF_CHECKIN_MEETING_F

This data model represents the DW_PERF_CHECKIN_MEETING_F relationships with Dimensions.

DW_PERF_CONTENT_ITEM_RATING_EF

This data model represents the DW_PERF_CONTENT_ITEM_RATING_EF relationships with Dimensions.

DW_PERF_DOC_STATUS_EF

This data model represents the DW_PERF_DOC_STATUS_EF relationships with Dimensions.

DW_PERF_DOC_STATUS_F

This data model represents the DW_PERF_DOC_STATUS_F relationships with Dimensions.

DW_PERF_EVAL_RATING_F

This data model represents the DW_PERF_EVAL_RATING_F relationships with Dimensions.



DW_PERF_GOAL_ITEM_RATING_EF

This data model represents the DW_PERF_GOAL_ITEM_RATING_EF relationships with Dimensions.



DW_PERF_OTHER_SECT_RATING_EF

This data model represents the DW_PERF_OTHER_SECT_RATING_EF relationships with Dimensions.



DW_PERF_OVERALL_SECT_RATING_EF

This data model represents the DW_PERF_OVERALL_SECT_RATING_EF relationships with Dimensions.



DW_PERF_TASK_STATUS_EF

This data model represents the DW_PERF_TASK_STATUS_EF relationships with Dimensions.



DW_PERF_TASK_STATUS_F

This data model represents the DW_PERF_TASK_STATUS_F relationships with Dimensions.



Profile Management

DW_PRFL_ITEM_JOB_CRNT_EF

This data model represents the DW_PRFL_ITEM_JOB_CRNT_EF relationships with Dimensions.

DW_PRFL_ITEM_POSITION_CRNT_EF

This data model represents the DW_PRFL_ITEM_POSITION_CRNT_EF relationships with Dimensions.

DW_PRFL_ITEM_PRSN_ASG_CRNT_EF

This data model represents the DW_PRFL_ITEM_PRSN_ASG_CRNT_EF relationships with Dimensions.

DW_PRFL_JOB_CMPTNCY_CRNT_F

This data model represents the DW_PRFL_JOB_CMPTNCY_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_DEGREES_CRNT_F

This data model represents the DW_PRFL_JOB_DEGREES_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_HNR_AWARD_CRNT_F

This data model represents the DW_PRFL_JOB_HNR_AWARD_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_LANGUAGES_CRNT_F

This data model represents the DW_PRFL_JOB_LANGUAGES_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_LIC_CERT_CRNT_F

This data model represents the DW_PRFL_JOB_LIC_CERT_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_MEMBRSHIP_CRNT_F

This data model represents the DW_PRFL_JOB_MEMBRSHIP_CRNT_F relationships with Dimensions.

DW_PRFL_JOB_WRK_REQ_CRNT_F

This data model represents the DW_PRFL_JOB_WRK_REQ_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_CMPTNCY_CRNT_F

This data model represents the DW_PRFL_POSN_CMPTNCY_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_DEGREES_CRNT_F

This data model represents the DW_PRFL_POSN_DEGREES_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_HNR_AWARD_CRNT_F

This data model represents the DW_PRFL_POSN_HNR_AWARD_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_LANGUAGES_CRNT_F

This data model represents the DW_PRFL_POSN_LANGUAGES_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_LIC_CERT_CRNT_F

This data model represents the DW_PRFL_POSN_LIC_CERT_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_MEMBRSHIP_CRNT_F

This data model represents the DW_PRFL_POSN_MEMBRSHIP_CRNT_F relationships with Dimensions.

DW_PRFL_POSN_WRK_REQ_CRNT_F

This data model represents the DW_PRFL_POSN_WRK_REQ_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_ADV_RDYNS_CRNT_F

This data model represents the DW_PRFL_PRSN_ADV_RDYNS_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_CAR_PREF_CRNT_F

This data model represents the DW_PRFL_PRSN_CAR_PREF_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_CMPTNCY_CRNT_F

This data model represents the DW_PRFL_PRSN_CMPTNCY_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_DEGREES_CRNT_F

This data model represents the DW_PRFL_PRSN_DEGREES_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_EDU_LEVEL_CRNT_F

This data model represents the DW_PRFL_PRSN_EDU_LEVEL_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_HNR_AWARD_CRNT_F

This data model represents the DW_PRFL_PRSN_HNR_AWARD_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_IMPC_LOSS_CRNT_F

This data model represents the DW_PRFL_PRSN_IMPC_LOSS_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_LANGUAGES_CRNT_F

This data model represents the DW_PRFL_PRSN_LANGUAGES_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_LIC_CERT_CRNT_F

This data model represents the DW_PRFL_PRSN_LIC_CERT_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_MEMBRSHIP_CRNT_F

This data model represents the DW_PRFL_PRSN_MEMBRSHIP_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_PERF_RTNG_CRNT_F

This data model represents the DW_PRFL_PRSN_PERF_RTNG_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_POT_RTNG_CRNT_F

This data model represents the DW_PRFL_PRSN_POT_RTNG_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_PRV_EMPMT_CRNT_F

This data model represents the DW_PRFL_PRSN_PRV_EMPMT_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_RSK_LOSS_CRNT_F

This data model represents the DW_PRFL_PRSN_RSK_LOSS_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_SKILL_CRNT_F

This data model represents the DW_PRFL_PRSN_SKILL_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_SPCL_PROJ_CRNT_F

This data model represents the DW_PRFL_PRSN_SPCL_PROJ_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_TLNT_SCOR_CRNT_F

This data model represents the DW_PRFL_PRSN_TLNT_SCOR_CRNT_F relationships with Dimensions.

DW_PRFL_PRSN_WRK_REQ_CRNT_F

This data model represents the DW_PRFL_PRSN_WRK_REQ_CRNT_F relationships with Dimensions.

Recruiting

DW_TA_JOB_APP_EVENT_F

This data model represents the DW_TA_JOB_APP_EVENT_F relationships with Dimensions.

DW_TA_JOB_APP_HISTORY_EVENT_F

This data model represents the DW_TA_JOB_APP_HISTORY_EVENT_F relationships with Dimensions.

DW_TA_JOB_APP_SNAPSHOT_F

This data model represents the DW_TA_JOB_APP_SNAPSHOT_F relationships with Dimensions.

DW_TA_JOB_REQ_EVENT_F

This data model represents the DW_TA_JOB_REQ_EVENT_F relationships with Dimensions.

DW_TA_JOB_REQ_HISTORY_EVENT_F

This data model represents the DW_TA_JOB_REQ_HISTORY_EVENT_F relationships with Dimensions.

DW_TA_JOB_REQ_SNAPSHOT_F

This data model represents the DW_TA_JOB_REQ_SNAPSHOT_F relationships with Dimensions.

Performance Management

DW_SUCCSSN_PLAN_CANDIDATE_EF

This data model represents the DW_SUCCSSN_PLAN_CANDIDATE_EF relationships with Dimensions.

DW_SUCCSSN_PLAN_INCUMBENT_EF

This data model represents the DW_SUCCSSN_PLAN_INCUMBENT_EF relationships with Dimensions.

Performance Management

DW_TLNTRVW_MEETING_EF

This data model represents the DW_TLNTRVW_MEETING_EF relationships with Dimensions.

DW_TLNTRVW_MEETING_SUMMARY_EF

This data model represents the DW_TLNTRVW_MEETING_SUMMARY_EF relationships with Dimensions.