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    

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