DW_PO_AGENT_ACCESSES_D

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

Details

Module:

Key Columns

ASSIGNMENT_ID, ACCESS_ACTION_CODE

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     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.    

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