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
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
Dataset Folder and Field Name
Dataset Folder:"CSU Snapshot"
Field Name:"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.