HRW_CONFIGURATIONS
Defines the details of all the structures created within the Manage Enterprise Structures and Manage Job and Position Structures interview style setup tasks. The two interviews are used to define the high-level configuration of an enterprise. An enterprise configuration consists of a number of common objects that are used throughout the Oracle Fusion application, namely an enterprise, divisions, legal entities, business units, reference data sets, locations, legislative data groups, as well as job and position structures.
Details
-
Schema: FUSION
-
Object owner: HRW
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
HRW_CONFIGURATIONS_PK |
CONFIGURATION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CONFIGURATION_ID | NUMBER | 18 | Yes | CONFIGURATION_ID | |
| ENTERPRISE_ID | NUMBER | 18 | Yes | Identifier of Enterprise, used for multi-tenancy partitioning. Foreign key to HR_ORGANIZATION_UNITS. | |
| NAME | VARCHAR2 | 100 | Yes | NAME | |
| DESCRIPTION | VARCHAR2 | 1000 | DESCRIPTION | ||
| STATUS | VARCHAR2 | 30 | Status of the configuration: IN PROGRESS, LOADING, LOADED | ||
| 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. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| hrw_functions | hrw_configurations | CONFIGURATION_ID |
| hrw_legal_entities | hrw_configurations | CONFIGURATION_ID |
| hrw_job_position_global | hrw_configurations | CONFIGURATION_ID |
| hrw_country_division_matrix | hrw_configurations | CONFIGURATION_ID |
| hrw_enterprise_countries | hrw_configurations | CONFIGURATION_ID |
| hrw_business_units | hrw_configurations | CONFIGURATION_ID |
| hrw_enterprises | hrw_configurations | CONFIGURATION_ID |
| hrw_reference_data_sets | hrw_configurations | CONFIGURATION_ID |
| hrw_set_assign_override | hrw_configurations | CONFIGURATION_ID |
| hrw_job_pos_structures | hrw_configurations | CONFIGURATION_ID |
| hrw_job_position_details | hrw_configurations | CONFIGURATION_ID |
| hrw_locations | hrw_configurations | CONFIGURATION_ID |
| hrw_divisions | hrw_configurations | CONFIGURATION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HRW_CONFIGURATIONS_PK | Unique | Default | CONFIGURATION_ID |