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

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