GL_ACCESS_SET_NORM_ASSIGN
GL_ACCESS_SET_NORM_ASSIGN contains the access privilege information for each data access set. Each row includes the data access set, ledger or ledger set, segment value, and the corresponding access privilege information. This table corresponds to the Access Details region in the Data Access Set page. There is a one-to-many relationship between the data access set information stored in the GL_ACCESS_SETS table and the access details information stored in this table.
Details
-
Schema: FUSION
-
Object owner: GL
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
GL_ACCESS_SET_NORM_ASSIGN_PK |
ACCESS_SET_ID, LEDGER_ID, ALL_SEGMENT_VALUE_FLAG, SEGMENT_VALUE_TYPE_CODE, ACCESS_PRIVILEGE_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| ACCESS_SET_ID | NUMBER | 18 | Yes | Unique identifier of the access set. | ||
| LEDGER_ID | NUMBER | 18 | Yes | Ledger assignment to access set. | ||
| ALL_SEGMENT_VALUE_FLAG | VARCHAR2 | 1 | Yes | Value that represents the balancing or management segment. | ||
| SEGMENT_VALUE_TYPE_CODE | VARCHAR2 | 1 | Yes | Indicates whether the selected segment value is a child or a parent. | ||
| ACCESS_PRIVILEGE_CODE | VARCHAR2 | 1 | Yes | Security privileges can be granted to a role or user and typically confers the ability to access particular functions or data, or both. | ||
| RECORD_ID | NUMBER | 18 | Yes | Oracle internal use only. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| FLEX_FILTER | XMLTYPE | Key flexfield filter identifier. | ||||
| SEGMENT_VALUE | VARCHAR2 | 25 | Balancing or management segment value used to secure a data access set. | |||
| TREE_CODE | VARCHAR2 | 30 | Tree code of the assigned parent segment value. | |||
| TREE_VERSION_ID | VARCHAR2 | 32 | Tree version of the assigned parent segment value. | |||
| START_DATE | DATE | Date from which this access set assignment is active. | ||||
| END_DATE | DATE | Date from which this acesss set assigment is inactive. | ||||
| STATUS_CODE | VARCHAR2 | 1 | Status of the access set assignment. | |||
| LINK_ID | NUMBER | 18 | Oracle internal use only. | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Access Set: Access Details (GL_ACCESS_SET_NORM_ASSIGN) | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| CHART_OF_ACCOUNTS_ID | NUMBER | 18 | Key flexfield structure identifier. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| GL_ACCESS_SET_NORM_ASSIGN | gl_access_sets | ACCESS_SET_ID |
| GL_ACCESS_SET_NORM_ASSIGN | gl_ledgers | LEDGER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| GL_ACCESS_SET_NORM_ASSIGN_N1 | Non Unique | FUSION_TS_TX_IDX | ACCESS_SET_ID, SEGMENT_VALUE |