DW_CXS_ACCESS_GROUP_MEMBERS_D

Access Member Dimension

Details

Module: Opportunity Management

Key Columns

ACCESS_GROUP_MEMBER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCESS_GROUP_MEMBER_ID NUMBER 38 0 True Access Group Member Id. System Generated Identifier and Primary Key    
SOURCE_RECORD_ID VARCHAR2 64     Unique identifier    
ACCESS_GROUP_ID NUMBER 38 0   Access Group Identifier    
PARTY_ID NUMBER 38 0   Resource party identifier    
MANUALLY_ASSIGNED_FLAG VARCHAR2 16     Indicates if the Group Member was manually added to the Access Group. Y indicates manual group membership    
ACTIVE_FLAG VARCHAR2 16     This column indicates if the access group is active or not. Y means Active.    
TYPE_CODE VARCHAR2 32     Identifier for the type of group    
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 128     Indicates the session login associated to the user who last updated the row    

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