DW_DATA_ACCESS_SET_LEDGERS_D

This table contains the access set and associated ledgers.

Details

Module:

Key Columns

ACCESS_SET_ID, LEDGER_ID

Columns

Columns
Name Datatype Length Precision Not Null Comments Referred Table Referred Column
ACCESS_SET_ID NUMBER 38 0 True Unique identifier of the access set.
LEDGER_ID NUMBER 38 0 True Ledger or ledger set ID assigned to the data access set.
SOURCE_RECORD_ID VARCHAR2 128 This column is for Oracle Internal use only. Unique System Primary Key
ACCESS_SET_NAME VARCHAR2 32 User defined access set defining column.
SECURITY_SEGMENT_CODE VARCHAR2 16 Security segment (balancing segment, management segment, full).
ENABLED_FLAG VARCHAR2 16 Whether the access set is enabled.
CHART_OF_ACCOUNTS_ID NUMBER 38 0 Key flexfield structure identifier.
PERIOD_SET_NAME VARCHAR2 32 Accounting calendar name.
ACCOUNTED_PERIOD_TYPE VARCHAR2 32 Accounting period type.
AUTOMATICALLY_CREATED_FLAG VARCHAR2 16 Automatically created access set flag.
DEFAULT_LEDGER_ID NUMBER 38 0 Default ledger of the access set.
DESCRIPTION VARCHAR2 256 Access set definition description.
ACCESS_PRIVILEGE_CODE VARCHAR2 16 Access level for the ledger or ledger set assigned to the data access set. Possible values are F for Full Ledger, B for Both Read And Write, and R for Read Only.
LEDGER_ACCESS_SET_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the Ledger Access Set row.
LEDGER_ACCESS_SET_LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the Last updated of the Ledger Access Set row.
ACCESS_SET_CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the Access Set row.
ACCESS_SET_LAST_UPDATE_DATE TIMESTAMP Who column: indicates the date and time of the last updated of the Access Set row.