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.    

Copyright © 2019, 2024, Oracle and/or its affiliates.