Warehouse Insert Date

From CSUMB Data Glossary
Jump to navigation Jump to search

Warehouse Insert Date is when new data is added to a table with a new key. This happens one time on record creation.

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_INSERT_DT
Census Process:N
Logical Transformation / Calculation
N/A
OBIEE Folder and Column
Folder Heading:"CSU Snapshot"
Column Heading:"Warehouse Insert Date"

Business Rules

N/A

Examples

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

See Also

Definition Source

W_INSERT_DT - Stores the date on which the record was inserted 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#BIASA24590.