DW_PO_AGENT_ACCESSES_D

This table store access actions for each prc bu and agent combination.

Details

Module:

Key Columns

ACCESS_ACTION_CODE, ASSIGNMENT_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ASSIGNMENT_ID NUMBER 38 0 True Assignment Identifier
ACCESS_ACTION_CODE VARCHAR2 32 True Access Action Code.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. System
ACCESS_OTHERS_LEVEL_CODE VARCHAR2 32 This column indicates the level of accessing others' document.
ACTIVE_FLAG VARCHAR2 16 Status of this combination. Dennomalized from Assignment table
AGENT_ID NUMBER 38 0 Agent Unique Identifier. Dennomalized from Assignment table
ALLOWED_FLAG VARCHAR2 16 This column indicates if this access action is granted to the combination. Possible values: 'Y' or 'N'
CREATED_BY VARCHAR2 128 Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
DEFAULT_REQ_BU_ID NUMBER 38 0 Default Requistioning Bu Unique Identifier. Dennomalized from Assignment table
PRC_BU_ID NUMBER 38 0 Procurement Bu Unique Identifier. Dennomalized from Assignment table.
VIEW_SCOPE VARCHAR2 64 Derived Attribute based on access_others_level_code.
USER_GUID VARCHAR2 128 User Guid of the user.
USERNAME VARCHAR2 128 The latest principal username of the user
USER_ID NUMBER 38 0 User Identifier
LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last update of the row.