Warehouse Updated Date

CSUMB Data Glossary  |  [https://csumb.edu/academics/academic-outcomes/ Institutional Assessment & Research]
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.