Tables Without WHO Columns
All tables have two system date columns which you can use to get the last refresh dates.
These system date columns are:
- W$_INSERT_DT - the timestamp when that particular record was inserted into that table.
- W$_UPDATE_DT - the timestamp when that particular row was updated in that table.
The following views based on the data warehouse tables don't have the WHO columns:
- DW_DISABILITY_ORG_D_TL
- DW_PAYROLL_STATUTORY_UNIT_D_TL
- DW_TAX_REPORTING_UNIT_D_TL
- DW_INV_ORGANIZATION_D_TL
- DW_FISCAL_DAY_D_NO_ADJUST
- DW_PAYROLL_STATUTORY_UNIT_D
- DW_DISABILITY_ORG_D
- DW_TAX_REPORTING_UNIT_D
- DW_INV_ORGANIZATION_D
- DW_PRFL_POSN_CMPTNCY_CRNT_F
- DW_PRFL_JOB_LIC_CERT_CRNT_F
- DW_PRFL_PRSN_RSK_LOSS_CRNT_F
- DW_PRFL_POSN_HNR_AWARD_CRNT_F
- DW_PRFL_POSN_MEMBRSHIP_CRNT_F
- DW_PRFL_PRSN_WRK_REQ_CRNT_F
- DW_PRFL_PRSN_EDU_LEVEL_CRNT_F
- DW_PRFL_PRSN_PERF_RTNG_CRNT_F
- DW_PRFL_PRSN_IMPC_LOSS_CRNT_F
- DW_PRFL_PRSN_PRV_EMPMT_CRNT_F
- DW_PRFL_POSN_LANGUAGES_CRNT_F
- DW_PRFL_PRSN_TLNT_SCOR_CRNT_F
- DW_PRFL_JOB_CMPTNCY_CRNT_F
- DW_PRFL_PRSN_DEGREES_CRNT_F
- DW_PRFL_PRSN_SPCL_PROJ_CRNT_F
- DW_PRFL_PRSN_CMPTNCY_CRNT_F
- DW_PRFL_JOB_DEGREES_CRNT_F
- DW_PRFL_JOB_LANGUAGES_CRNT_F
- DW_PRFL_JOB_WRK_REQ_CRNT_F
- DW_PRFL_PRSN_MEMBRSHIP_CRNT_F
- DW_PRFL_PRSN_LIC_CERT_CRNT_F
- DW_PRFL_PRSN_HNR_AWARD_CRNT_F
- DW_PRFL_POSN_WRK_REQ_CRNT_F
- DW_PRFL_PRSN_CAR_PREF_CRNT_F
- DW_PRFL_PRSN_SKILL_CRNT_F
- DW_PRFL_POSN_LIC_CERT_CRNT_F
- DW_PRFL_PRSN_POT_RTNG_CRNT_F
- DW_PRFL_PRSN_ADV_RDYNS_CRNT_F
- DW_PRFL_JOB_HNR_AWARD_CRNT_F
- DW_PRFL_POSN_DEGREES_CRNT_F
- DW_PRFL_PRSN_LANGUAGES_CRNT_F
- DW_PRFL_JOB_MEMBRSHIP_CRNT_F
- DW_LM_ELEARNING_TASK_ASSIGNMENT_CURRENT_EF
- DW_LM_ELEARNING_ASSIGNMENT_EVENT_CURRENT_EF
- DW_LM_TASK_ASSIGNMENT_CURRENT_EF
- DW_LM_SPECIALIZATION_ASSIGNMENT_EVENT_CURRENT_EF
- DW_LM_CLASS_ASSIGNMENT_EVENT_CURRENT_EF
- DW_LM_COURSE_ASSIGNMENT_EVENT_CURRENT_EF
- DW_PPL360_TERM_WORKFORCE
- DW_POSITION_D_CURRENT_TL
- DW_PAY_GRADE_D_CURRENT_TL
- DW_JOB_FAMILY_D_CURRENT_TL
- DW_JOB_D_CURRENT_TL
- DW_PPL360_WORKFORCE DW_PAY_GRADE_CURRENT_D
- DW_GRADE_RATE_VALUE_CURRENT_D
- DW_PERSON_LEGISLATION_ALL_CURRENT_D
- DW_JOB_CURRENT_D
- DW_MANAGER_DN_CURRENT_DH
- DW_POSITION_CURRENT_D
- DW_GRADE_RATE_CURRENT_D
- DW_PERSON_NAME_CURRENT_D
- DW_MANAGER_REPORTEES_CF_DN_CURRENT_DH
- DW_MANAGER_REPORTEES_CF_DN_NSR_DH
- DW_MANAGER_CF_TD_CURRENT_DH
- DW_JOB_FAMILY_CURRENT_D
- DW_BEN_PLAN_CURRENT_D
- DW_BEN_PROGRAM_CURRENT_D
- DW_BEN_PLAN_TYPE_CURRENT_D
- DW_BEN_RATE_CURRENT_D
- DW_BEN_LIFE_EVENT_CURRENT_D
- DW_BEN_PERSON_BENEFIT_GROUP_CURRENT_D
- DW_BEN_PLAN_OPTION_CURRENT_D
- DW_BEN_HABITS_CURRENT_D
- DW_BEN_PARTICIPANT_CONTACT_CURRENT_D