Toggle menu
Toggle preferences menu
Toggle personal menu
Not logged in
Your IP address will be publicly visible if you make any edits.

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

Metadata
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
Dataset Folder and Field Name
Dataset Folder:"CSU Snapshot"
Field Name:"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.
Cookies help us deliver our services. By using our services, you agree to our use of cookies.