DW_CXS_ACCESS_GROUP_MEMBERS_D

Access Member Dimension

Details

Module:

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 This column is for Oracle Internal use only. 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