Warehouse Updated Date

From CSUMB Data Glossary
Jump to navigation Jump to search

Warehouse Updated Date is the most recent date when attributes and metrics for an existing record were updated in a table.

Metadata
Where Term Appears
CSUMB Data Warehouse Dashboards:N/A
Other Reports:N/A
Data Custodian
Data Warehouse
Data Source
Source System:N/A
Source Table Name:WC_CSU_SNAPSHOT_D
Source Field Name:W_UPDATE_DT
Census Process:N
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:"CSU Snapshot"
Column Heading:"Warehouse Updated Date"

Business Rules

N/A

Examples

  • Date (format to the day) MM/DD/YYYY (e.g. 03/19/2021)

See Also

Definition Source

W_UPDATE_DT - Stores the date on which the record was last updated in the data warehouse table.[1] - Data Warehouse Team

References

  1. Oracle. Business Intelligence Applications Administrator's Guide. Oracle Business Analytics Warehouse Naming Conventions. Retrieved from: https://docs.oracle.com/applications/biapps103/admin/GUID-D8757978-A614-4C0D-AB63-F74A7711511C.htm#BIASA24607.