DW_CXS_SNAPSHOTS_D

This table contains description for Snapshots

Details

Module:

Key Columns

SNAPSHOT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
SNAPSHOT_ID NUMBER 38 0 True System generated unique Identifier for Sales Stage
SOURCE_RECORD_ID VARCHAR2 64 This column is for Oracle Internal use only. System generated key
LAST_UPDATE_LOGIN VARCHAR2 64 Indicates the session login associated to the user who last updated the row
LAST_UPDATED_BY VARCHAR2 128 Indicates the user who last updated the row
PERIOD_END_FLAG VARCHAR2 16 Flag to indicate if the Period has ended
PURGE_DATE DATE Data Purge Date
QUARTER_END_FLAG VARCHAR2 16 Flag to indicate if the Quarter has ended
SNAPSHOT_DATE DATE Date when the snapshot was generated
USER_LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database i.e. a different mobile database or the server
YEAR_END_FLAG VARCHAR2 16 Flag to indicate if the Year has ended
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the row.