In the data warehouse, certain fields appear in multiple views without primary affiliation to any one view. In this data dictionary, such fields are identified as belonging to "various" views.
Published in:- HRBAIRS .
Contains fields:
DW_FEFF_DT |
The first date for which a row in a Data Warehouse table is effective. This field only appears in the Data Warehouse. |
DW_LEFF_DT |
The last date for which this row in a Data Warehouse table is effective. For the last effective row, this field is populated with a high value (12/31/9999). See DW_FEFF_DT for a fuller explanation. This field only appears in the Data Warehouse. |
DW_LOAD_DT |
The date on which this row was loaded into the Data Warehouse. As of July 2002, the Data Warehouse views are rebuilt from HRMS data each time they are updated (generally, Monday through Friday nights). Because of this, it is normal for all DW_LOAD_DT values in a single view to be the same. |