Tables Without WHO Columns

All tables have two system date columns which can be used 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.
Objects that don't have the WHO columns are the views based on the data warehouse tables. Views based on the data warehouse tables won't have any WHO columns because they aren't tables; instead they are views joining two or more underlying data warehouse tables.
The following views based on the data warehouse tables don't have the WHO columns:
  • DW_INV_ORGANIZATION_D_TL
  • DW_FISCAL_DAY_D_NO_ADJUST
  • DW_INV_ORGANIZATION_D
  • DW_JOB_D_CURRENT_TL
  • DW_PERSON_LEGISLATION_ALL_CURRENT_D
  • DW_JOB_CURRENT_D
  • DW_PERSON_NAME_CURRENT_D
  • DW_GL_BALANCE_CA
  • DW_GL_BALANCE_CF
  • DW_GL_JOURNAL_CA