DW_EWC_X_EWDI_CUST_A1_SNAPSHOT_PERIOD_D

Snapshot Period

Details

Module: Customer Analytics

Type: Dimension

Key Columns

A1_PERIOD_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
A1_PERIOD_ID VARCHAR2 6 True Snapshot Period
SOURCE_RECORD_ID VARCHAR2 6 Source Record Id
C1_SNAPSHOT_TYPE_FLG VARCHAR2 4 Snapshot Type
PERIOD_END_DT DATE 0 Period End Date
PERIOD_START_DT DATE 0 Period Start Date
W$_INSERT_DT TIMESTAMP 0 6
W$_UPDATE_DT TIMESTAMP 0 6