DW_CXS_OBJECT_SHARE_D

Object Share Dimension

Details

Module:

Key Columns

OBJECT_SHARE_ID, OBJECT_TYPE

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
OBJECT_SHARE_ID NUMBER 38 0 True Primary Key of the Object Share
OBJECT_TYPE VARCHAR 32 True Object type will help identify the type of object. Eg. Opportunity, Account
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Source Record ID
OBJECT_ID NUMERIC 38 0 Foreign Key to the object's primary key. Eg., for Opportunity, this would be OPPORTUNITY_ID.
OBJECT_NUMBER VARCHAR 512 For Opportunity type, this column will contain OPPORTUNITY_NUMBER.
ACCESS_GROUP_ID NUMERIC 38 0 Indicates the Access Group that has access to this Object.
ACCESS_GROUP_NUMBER VARCHAR 999 Access Group Number
ACCESS_GROUP_TYPE_CODE VARCHAR 32 Access Group Type
ACCESS_LEVEL_CODE VARCHAR 32 Access level determines the type of access granted to the group. Can be 'FULL','VIEW','EDIT',etc.
CREATED_BY VARCHAR 128 Indicates the user who created the row.
CREATION_DATE TIMESTAMP Indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR 128 Indicates the user who last updated the row
LAST_UPDATE_DATE TIMESTAMP Indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR 64 Indicates the session login associated to the user who last updated the row