26Workforce Management

Tables

HWM_ALLOCATIONS_HDR_F

Time Allocations header table is effective dated parent table to all other allocation tables. It contains allocation id, effective dates and allocation name.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATIONS_HDR_F_PK

ALLOCATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments Status
ALLOCATION_ID NUMBER 18 Yes Primary Key column contaning Resource Id/Person Id. This column is not updateable. Active
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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. Active
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support Active
ALLOCATION_NAME VARCHAR2 80 Yes Name of Time Allocation ID
DATA_LEVEL NUMBER 9 Yes DATA_LEVEL
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns Status
HWM_ALLOCATIONS_HDR_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE Active
HWM_ALLOCATIONS_HDR_F_U1 Unique Default ALLOCATION_NAME, EFFECTIVE_START_DATE

HWM_ALLOCATIONS_HDR_TL

Time Allocations Header translate table stores time allocation translatable description column.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_ALLOCATIONS_HDR_TL_PK

ALLOCATION_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
ALLOCATION_ID NUMBER 18 Yes ALLOCATION_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
DESCRIPTION VARCHAR2 1000 DESCRIPTION
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_ALLOCATIONS_HDR_TL_U1 Unique Default ALLOCATION_ID, LANGUAGE

HWM_ALLOCATION_ATTRIBUTE_F

Time Allocations attributes table contains list of all Attributes used by allocation UI , by Rule level.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATION_ATTRIBUTE_F_PK

ALLOCATION_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
ALLOCATION_ATTRIBUTE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
DATA_SOURCE_USAGE_ID NUMBER 18 DATA_SOURCE_USAGE_ID
ALLOCATION_RULE_ID NUMBER 18 Yes Foreign Key to the allocation Rule table
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
ALLOCATION_ID NUMBER 18 Yes Foreign Key to the allocation Rule table
UI_ATRB_SEQUENCE NUMBER 9 Yes UI_ATRB_SEQUENCE
TM_ATRB_FLD_ID NUMBER 18 Yes ATTR_ID
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_ALLOCATION_ATTRIBUTE_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_ATTRIBUTE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
HWM_ALLOCATION_ATTRIBUTE_F_U1 Unique Default ALLOCATION_ID, ALLOCATION_RULE_ID, TM_ATRB_FLD_ID, EFFECTIVE_START_DATE, DATA_SOURCE_USAGE_ID

HWM_ALLOCATION_LINES_F

Time Allocations lines table contains detail allocation values per each Allocation Rule row.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATION_LINES_F_PK

ALLOCATION_LINE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
ALLOCATION_LINE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
ALLOCATION_RULE_ID NUMBER 18 Yes Foreign Key to the allocation Rule table.
ALLOCATION_LINE_PRIORITY NUMBER Yes ALLOCATION_LINE_PRIORITY
ALLOCATION_VALUE NUMBER Yes ALLOCATION_VALUE
DATA_LEVEL NUMBER 9 Yes DATA_LEVEL
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_ALLOCATION_LINES_F_N1 Non Unique Default ALLOCATION_RULE_ID
HWM_ALLOCATION_LINES_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_LINE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

HWM_ALLOCATION_LN_ATRBS_F

Time Allocations Line Attributes table contains list of attributes and value for each Allocation Line row.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATION_LN_ATRBS_F_PK

ALLOCATION_LN_ATRB_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
ALLOCATION_LN_ATRB_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
UI_ATRB_SEQUENCE NUMBER 9 Yes UI_ATRB_SEQUENCE
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
ALLOCATION_RULE_ID NUMBER 18 Yes Foreign Key to the allocation Rule table
ALLOCATION_LINE_ID NUMBER 18 Yes Foreign Key to the allocation ALLOCATION_LINE
TM_ATRB_FLD_ID NUMBER 18 Yes ATTR_ID
ATRB_FLD_NAME VARCHAR2 240 Yes ATRB_FLD_NAME
ATRB_DATA_TYPE VARCHAR2 30 Yes ATRB_DATA_TYPE
ATRB_VALUE_TEXT VARCHAR2 250 ATTR_VALUE_TEXT
ATRB_VALUE_NUMBER NUMBER ATTR_VALUE_NUMBER
ATRB_VALUE_TIMESTAMP TIMESTAMP ATTR_VALUE_TIMESTAMP
DATA_LEVEL NUMBER 9 Yes DATA_LEVEL
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_ALLOCATION_LN_ATRBS_F_N1 Non Unique Default ALLOCATION_RULE_ID
HWM_ALLOCATION_LN_ATRBS_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_LN_ATRB_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
HWM_ALLOCATION_LN_ATRBS_F_U1 Unique Default ALLOCATION_LINE_ID, EFFECTIVE_START_DATE, TM_ATRB_FLD_ID

HWM_ALLOCATION_RESOURCES_F

Time Allocations Resource table is effective dated table that associates a resource to Time allocation definition in Time Allocations Header table

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATION_RESOURCES_F_PK

ALLOCATION_RESOURCES_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments Status
ALLOCATION_RESOURCES_ID NUMBER 18 Yes ALLOCATION_RESOURCES_ID
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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. Active
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support Active
RESOURCE_ID NUMBER 18 Yes Primary Key column contaning Resource Id/Person Id. This column is not updateable. Active
SUBRESOURCE_ID NUMBER 18 SUBRESOURCE_ID
ALLOCATION_ID NUMBER 18 Yes Name of Time Allocation ID
INACTIVE_FLAG NUMBER 1 Mark if the allocation assignment is inactive
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns Status
HWM_ALLOCATION_RESOURCES_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_RESOURCES_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE Active
HWM_ALLOCATION_RESOURCES_F_U1 Unique Default RESOURCE_ID, SUBRESOURCE_ID, ALLOCATION_ID, EFFECTIVE_START_DATE
HWM_ALLOCATION_RESOURCES_F_U2 Unique Default RESOURCE_ID, SUBRESOURCE_ID, EFFECTIVE_START_DATE

HWM_ALLOCATION_RULES_F

Time Allocations Rules table contains Rules based on Time Category and Allocation type. This table is parent to Time Allocation Lines and child of Time allocation header.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ALLOCATION_RULES_F_PK

ALLOCATION_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
ALLOCATION_RULE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
ALLOCATION_ID NUMBER 18 Yes Foreign Key to the Time allocation table
ALLOCATION_RULE_PRIORITY NUMBER 9 Yes ALLOCATION_RULE_PRIORITY
TCAT_ID NUMBER 18 Foreign Key to the Time category table
ALLOCATION_TYPE VARCHAR2 30 Yes ALLOCATION_TYPE
RUN_SUMMATION_LEVEL VARCHAR2 30 Yes RUN_SUMMATION_LEVEL
DATA_LEVEL NUMBER 9 Yes DATA_LEVEL
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_ALLOCATION_RULES_F_N1 Non Unique Default ALLOCATION_ID
HWM_ALLOCATION_RULES_F_PK Unique FUSION_TS_TX_DATA ALLOCATION_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

HWM_ANC_INTERFACE_DIAG

This table is used for logging decoupling details , for exceptions or for debugging purposes

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_ANC_INTERFACE_DIAG_PK

IFACE_DIAGNOSTIC_ID

Columns

Name Datatype Length Precision Not-null Comments
IFACE_DIAGNOSTIC_ID NUMBER 18 Yes IFACE_DIAGNOSTIC_ID
WFM_IFACE_HDR_ID NUMBER 18 Yes WFM_IFACE_HDR_ID
PROCESS_TYPE VARCHAR2 20 PROCESS_TYPE
PROCESS_ID VARCHAR2 80 PROCESS_ID
ERROR_LOG CLOB ERROR_LOG
PAYLOAD CLOB PAYLOAD
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.
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
HWM_ANC_INTERFACE_DIAG anc_wfm_interface_header WFM_IFACE_HDR_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_ANC_INTERFACE_DIAG_U1 Unique Default IFACE_DIAGNOSTIC_ID

HWM_BATCH_OBJECTS

Instances of a process execution to load time records into the workforce management repository

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_BATCH_OBJECTS_PK

BATCH_OBJECT_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_OBJECT_ID NUMBER 18 Yes TRANSACTION_ID
SYNC_OBJ_SEQ NUMBER 9 SYNC_OBJ_SEQ
SYNC_OBJ_ID NUMBER 18 SYNC_OBJ_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
BATCH_PROC_INSTANCE_ID NUMBER 18 BATCH_PROCESS_ID
OBJ_SEQ_NUM NUMBER 9 NUM_OF_THREADS
REF_OBJECT_ID NUMBER 18 REF_OBJECT_ID
START_REF_OBJECT_ID NUMBER 18 START_REF_OBJECT_ID
END_REF_OBJECT_ID NUMBER 18 END_REF_OBJECT_ID
OBJECT_TYPE VARCHAR2 30 OBJECT_TYPE
THREAD_PROC_INSTANCE_ID NUMBER 18 THREAD_PROC_INSTANCE_ID
STATUS VARCHAR2 30 STATUS
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
HWM_BATCH_OBJECTS hwm_batch_proc_instances BATCH_PROC_INSTANCE_ID
hwm_batch_obj_messages hwm_batch_objects BATCH_OBJ_MESSAGE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_OBJECTS_N1 Non Unique Default BATCH_PROC_INSTANCE_ID, REF_OBJECT_ID
HWM_BATCH_OBJECTS_N2 Non Unique Default THREAD_PROC_INSTANCE_ID
HWM_BATCH_OBJECTS_N3 Non Unique Default BATCH_PROC_INSTANCE_ID, OBJ_SEQ_NUM
HWM_BATCH_OBJECTS_N4 Non Unique Default BATCH_PROC_INSTANCE_ID, SYNC_OBJ_ID
HWM_BATCH_OBJECTS_PK Unique Default BATCH_OBJECT_ID

HWM_BATCH_OBJ_MESSAGES

Instances of a process execution to load time records into the workforce management repository

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_BATCH_OBJ_MESSAGES_PK

BATCH_OBJ_MESSAGE_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_OBJ_MESSAGE_ID NUMBER 18 Yes TRANSACTION_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
BATCH_OBJECT_ID NUMBER 18 BATCH_PROCESS_ID
SEQ_NUM NUMBER 9 NUM_OF_THREADS
REF_OBJECT_ID NUMBER 18 REF_OBJECT_ID
MESSAGE_NAME VARCHAR2 30 OBJECT_TYPE
MESSAGE_TEXT VARCHAR2 1000 THREAD_PROC_INSTANCE_ID
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
HWM_BATCH_OBJ_MESSAGES hwm_batch_objects BATCH_OBJ_MESSAGE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_OBJ_MESSAGES_FK1 Non Unique Default BATCH_OBJECT_ID
HWM_BATCH_OBJ_MESSAGES_PK Unique Default BATCH_OBJ_MESSAGE_ID

HWM_BATCH_PROCESSES

This table holds information about the various processes executed when loading time into the repository. For example, the 'Execute Time Entry Rules' process is defined in this table.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_BATCH_PROCESSES_PK

BATCH_PROCESS_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_PROCESS_ID NUMBER 18 Yes Primary Key
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
BATCH_PROCESS_CD VARCHAR2 30 PROCESS_CD
CHUNK_SIZE NUMBER 9 CHUNK_SIZE
NUM_OF_THREADS NUMBER 9 NUM_OF_THREADS
ERROR_THRESHOLD NUMBER 9 ERROR_THRESHOLD
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_BATCH_PROCESSES fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
hwm_batch_proc_instances hwm_batch_processes BATCH_PROCESS_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_PROCESSES_N20 Non Unique Default SGUID
HWM_BATCH_PROCESSES_PK Unique Default BATCH_PROCESS_ID

HWM_BATCH_PROC_INSTANCES

Instances of a process execution to load time records into the workforce management repository

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_BATCH_PROC_INSTANCES_PK

BATCH_PROC_INSTANCE_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_PROC_INSTANCE_ID NUMBER 18 Yes TRANSACTION_ID
PARENT_BATCH_PROC_INSTANCE_ID NUMBER 18 Store the parent proc instance id
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
BATCH_PROCESS_ID NUMBER 18 BATCH_PROCESS_ID
BATCH_PROCESS_CD VARCHAR2 30 BATCH_PROCESS_CD
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
PARENT_REQUEST_ID NUMBER 18 PARENT_REQUEST_ID
NUM_OF_THREADS NUMBER 9 NUM_OF_THREADS
NUM_OF_OBJ_TOTAL NUMBER 9 NUM_OF_OBJ_TOTAL
NUM_OF_OBJ_SUCCESS NUMBER 9 NUM_OF_OBJ_SUCCESS
NUM_OF_OBJ_ERRORED NUMBER 9 NUM_OF_OBJ_ERRORED
STATUS VARCHAR2 30 STATUS
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
HWM_BATCH_PROC_INSTANCES hwm_batch_processes BATCH_PROCESS_ID
hwm_batch_ranges hwm_batch_proc_instances BATCH_PROC_INSTANCE_ID
hwm_batch_objects hwm_batch_proc_instances BATCH_PROC_INSTANCE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_PROC_INST_FK1 Non Unique Default BATCH_PROCESS_ID
HWM_BATCH_PROC_INST_N1 Non Unique Default PARENT_BATCH_PROC_INSTANCE_ID
HWM_BATCH_PROC_INST_N2 Non Unique Default REQUEST_ID
HWM_BATCH_PROC_INST_PK Unique Default BATCH_PROC_INSTANCE_ID

HWM_BATCH_RANGES

Instances of a process execution to load time records into the workforce management repository

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_BATCH_RANGES_PK

BATCH_RANGE_ID

Columns

Name Datatype Length Precision Not-null Comments
BATCH_RANGE_ID NUMBER 18 Yes TRANSACTION_ID
STATUS VARCHAR2 30 STATUS
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
BATCH_PROC_INSTANCE_ID NUMBER 18 BATCH_PROCESS_ID
START_BATCH_SEQ_NUM NUMBER 9 NUM_OF_THREADS
END_BATCH_SEQ_NUM NUMBER 9 END_BATCH_SEQ_NUM
THREAD_INDEX_NUM NUMBER 9 OBJECT_TYPE
THREAD_PROC_INSTANCE_ID NUMBER 18 THREAD_PROC_INSTANCE_ID
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
HWM_BATCH_RANGES hwm_batch_proc_instances BATCH_PROC_INSTANCE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_RANGES_FK1 Non Unique Default BATCH_PROC_INSTANCE_ID
HWM_BATCH_RANGES_PK Unique Default BATCH_RANGE_ID

HWM_BATCH_THRD_LOGS

State of an object to be stored during process execution to load time records into the workforce management repository

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_BATCH_THRD_LOGS_PK

HWM_BATCH_THRD_LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
HWM_BATCH_THRD_LOG_ID NUMBER 18 Yes HWM_BATCH_THRD_LOG_ID
BATCH_PROC_INSTANCE_ID NUMBER 18 Yes BATCH_PROC_INSTANCE_ID
THREAD_PROC_INSTANCE_ID NUMBER 18 Yes THREAD_PROC_INSTANCE_ID
THREAD_INDEX_NUM NUMBER 9 THREAD_INDEX_NUM
THREAD_PARAMS BLOB THREAD_PARAMS
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.
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_BATCH_THRD_LOGS_N1 Non Unique Default BATCH_PROC_INSTANCE_ID
HWM_BATCH_THRD_LOGS_N2 Non Unique Default THREAD_PROC_INSTANCE_ID
HWM_BATCH_THRD_LOGS_U1 Unique Default HWM_BATCH_THRD_LOG_ID

HWM_CRITERIA_BINDS

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.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_CRITERIA_BINDS_PK

CRITERIA_BIND_ID

Columns

Name Datatype Length Precision Not-null Comments
CRITERIA_BIND_ID NUMBER 18 Yes CRITERIA_BIND_ID
DATA_SOURCE_CRITERIA_ID NUMBER 18 Yes DATA_SOURCE_ID
BIND_NAME VARCHAR2 80 Yes CRITERIA_NAME
DATA_TYPE VARCHAR2 30 Yes DATA_TYPE
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_CRITERIA_BINDS hwm_data_source_criterias DATA_SOURCE_CRITERIA_ID
HWM_CRITERIA_BINDS fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
hwm_dt_src_usg_bnd_vals hwm_criteria_binds CRITERIA_BIND_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_CRITERIA_BINDS_N20 Non Unique Default SGUID
HWM_CRITERIA_BINDS_FK1 Non Unique Default DATA_SOURCE_CRITERIA_ID
HWM_CRITERIA_BINDS_U1 Unique Default CRITERIA_BIND_ID

HWM_DATA_SOURCES_B

Base Table for the Data Sources. Each source of data from the time consumers is handled with in WFM as Data Sources. This provides a unified solution in terms of handling the data sources across the consuming features with in WFM & TL.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCES_B_PK

DATA_SOURCE_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_SOURCE_ID NUMBER 18 Yes DATA_SOURCE_ID
DATA_SOURCE_CODE VARCHAR2 80 Yes DATA_SOURCE_CODE
EXECUTABLE_CODE VARCHAR2 80 Yes EXECUTABLE_CODE
IMPLEMENTATION_TYPE VARCHAR2 30 Yes IMPLEMENTATION_TYPE
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DATA_SOURCES_B fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
hwm_data_sources_tl hwm_data_sources_b DATA_SOURCE_ID
hwm_data_source_usages hwm_data_sources_b DATA_SOURCE_ID
hwm_data_source_attributes hwm_data_sources_b DATA_SOURCE_ID
hwm_data_source_criterias hwm_data_sources_b DATA_SOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DATA_SOURCES_B_N20 Non Unique Default SGUID
HWM_DATA_SOURCES_B_U1 Unique Default DATA_SOURCE_ID
HWM_DATA_SOURCES_B_U2 Unique Default DATA_SOURCE_CODE, ENTERPRISE_ID

HWM_DATA_SOURCES_TL

This is a TL table & acts the data source for the information used in repository.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCES_TL_PK

DATA_SOURCE_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
DATA_SOURCE_ID NUMBER 18 Yes DATA_SOURCE_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
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.
DISPLAY_NAME VARCHAR2 240 Yes DATA_SOURCE_DISPLAY_NAME
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DATA_SOURCES_TL hwm_data_sources_b DATA_SOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DATA_SOURCES_TL_U1 Unique Default DATA_SOURCE_ID, LANGUAGE

HWM_DATA_SOURCE_ATTRIBUTES

This table stores the information about the attributes of Data Source.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCE_ATTRIBUTES_PK

DATA_SOURCE_ATTRIBUTE_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_SOURCE_ATTRIBUTE_ID NUMBER 18 Yes DATA_SOURCE_ATTRIBUTE_ID
DATA_SOURCE_ID NUMBER 18 Yes DATA_SOURCE_ID
ATTRIBUTE_NAME VARCHAR2 80 Yes ATTRIBUTE_NAME
ATTRIBUTE_TYPE VARCHAR2 30 Yes ATTRIBUTE_TYPE
DATA_TYPE VARCHAR2 30 Yes DATA_TYPE
CUSTOMIZED_FLAG VARCHAR2 1 Yes CUSTOMIZED_FLAG
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DATA_SOURCE_ATTRIBUTES fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
HWM_DATA_SOURCE_ATTRIBUTES hwm_data_sources_b DATA_SOURCE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DATA_SOURCE_ATTRIBUTES_N1 Non Unique Default DATA_SOURCE_ID
HWM_DATA_SOURCE_ATTRIBUTE_N20 Non Unique Default SGUID
HWM_DATA_SOURCE_ATTRIBUTES_U1 Unique Default DATA_SOURCE_ATTRIBUTE_ID

HWM_DATA_SOURCE_CRITERIAS

Stores the criteria for the data sources against the appropriate usage(i.e) ADMIN, USER (or) Both.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCE_CRITERIAS_PK

DATA_SOURCE_CRITERIA_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_SOURCE_CRITERIA_ID NUMBER 18 Yes DATA_SOURCE_ATTRIBUTE_ID
DATA_SOURCE_ID NUMBER 18 Yes DATA_SOURCE_ID
CRITERIA_NAME VARCHAR2 80 Yes CRITERIA_NAME
CRITERIA_USAGE_TYPE VARCHAR2 30 Yes CRITERIA_USAGE_TYPE
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DATA_SOURCE_CRITERIAS hwm_data_sources_b DATA_SOURCE_ID
HWM_DATA_SOURCE_CRITERIAS fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
hwm_criteria_binds hwm_data_source_criterias DATA_SOURCE_CRITERIA_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DATA_SOURCE_CRITERIAS_N20 Non Unique Default SGUID
HWM_DATA_SOURCE_CRITERIAS_FK1 Non Unique Default DATA_SOURCE_ID
HWM_DATA_SOURCE_CRITERIAS_U1 Unique Default DATA_SOURCE_CRITERIA_ID

HWM_DATA_SOURCE_USAGES

Table storing the mapping between the Data Source and the Time Attribute Field. It also contains the mapping for the default data source for a time attribute field.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCE_USAGES_PK

DATA_SOURCE_USAGE_ID

Columns

Name Datatype Length Precision Not-null Comments
DATA_SOURCE_USAGE_ID NUMBER 18 Yes DATA_SOURCE_ID
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.
DATA_SOURCE_USAGE_CODE VARCHAR2 120 Yes DATA_SOURCE_USAGE_CODE
TM_ATRB_FLD_ID NUMBER 18 Yes TM_ATRB_FLD_ID
DATA_SOURCE_ID NUMBER 18 Yes DATA_SOURCE_ID
USAGE_TYPE VARCHAR2 20 Yes USAGE_TYPE
LINKED_USAGE_ID NUMBER 18 LINKED_USAGE_ID
DEFAULT_FLAG VARCHAR2 1 Yes DEFAULT_FLAG
TM_ATRB_FLD_MSTR_REF_ID NUMBER 18 TM_ATRB_FLD_MSTR_REF_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DATA_SOURCE_USAGES hwm_tm_atrb_flds_b TM_ATRB_FLD_ID
HWM_DATA_SOURCE_USAGES hwm_data_source_usages LINKED_USAGE_ID
HWM_DATA_SOURCE_USAGES hwm_data_sources_b DATA_SOURCE_ID
HWM_DATA_SOURCE_USAGES fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
HWM_DATA_SOURCE_USAGES hwm_tm_atrb_fld_mstr_ref_b TM_ATRB_FLD_MSTR_REF_ID
hwm_dt_src_usg_bnd_vals hwm_data_source_usages DATA_SOURCE_USAGE_ID
hwm_data_source_usages hwm_data_source_usages LINKED_USAGE_ID
hwm_tm_atrb_fld_set_cmps hwm_data_source_usages DATA_SOURCE_USAGE_ID
hwm_tm_atrb_fld_set_cmps hwm_data_source_usages USER_DATA_SOURCE_USAGE_ID
hwm_tcat_expr_results_b hwm_data_source_usages DATA_SOURCE_USAGE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DATA_SOURCE_USAGES_N1 Non Unique Default TM_ATRB_FLD_ID, DATA_SOURCE_ID
HWM_DATA_SOURCE_USAGES_N20 Non Unique Default SGUID
HWM_DATA_SOURCE_USAGES_U1 Unique Default DATA_SOURCE_USAGE_ID
HWM_DATA_SOURCE_USAGES_U2 Unique Default DATA_SOURCE_USAGE_CODE, ENTERPRISE_ID

HWM_DS_API_CLASSES_B

Stores API Class for Dynamic Script

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DS_API_CLASSES_B_PK

DS_CLASS_ID

Columns

Name Datatype Length Precision Not-null Comments
DS_CLASS_ID NUMBER 18 Yes COLUMN1
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.
CLASS_NAME VARCHAR2 80 Yes PROCESS_INPUT
CLASS_PATH VARCHAR2 240 Yes CLASS_PATH
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_DS_API_CLASSES_B_U1 Unique FUSION_TS_TX_DATA DS_CLASS_ID
HWM_DS_API_CLASSES_B_U2 Unique FUSION_TS_TX_DATA CLASS_NAME

HWM_DS_API_CLASSES_TL

Stores translatable information on the API Class for Dynamic Script

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_DS_API_CLASSES_TL_PK

DS_CLASS_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
DS_CLASS_ID NUMBER 18 Yes DS_CLASS_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
DESCRIPTION VARCHAR2 1000 USER_DEFINED_NAME
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_DS_API_CLASSES_TL_PK Unique FUSION_TS_TX_DATA DS_CLASS_ID, LANGUAGE

HWM_DS_SCRIPTS_F

Contains the actual script for Dynamic Scripts.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWM_DS_SCRIPTS_F_PK

SCRIPT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
SCRIPT_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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.
DS_CLASS_ID NUMBER 18 Yes DS_CLASS_ID
SCRIPT_UNQ_ID NUMBER 18 Yes SCRIPT_UNQ_ID
SCRIPT_LANGUAGE VARCHAR2 30 Yes SCRIPT_LANGUAGE
SCRIPT_NAME VARCHAR2 80 Yes Name of the Script
SCRIPT_STATUS VARCHAR2 10 SCRIPT_STATUS
DESCRIPTION VARCHAR2 1000 DESCRIPTION
SCRIPT_TEXT CLOB SCRIPT_TEXT
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_DS_SCRIPTS_F_PK Unique FUSION_TS_TX_DATA SCRIPT_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
HWM_DS_SCRIPTS_F_U1 Unique FUSION_TS_TX_DATA SCRIPT_ID, EFFECTIVE_START_DATE
HWM_DS_SCRIPTS_F_U3 Unique FUSION_TS_TX_DATA SCRIPT_NAME, EFFECTIVE_START_DATE

HWM_DT_SRC_USG_BND_VALS

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.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_DATA_SOURCE_USG_BIND_PK

DT_SRC_USG_BND_VAL_ID

Columns

Name Datatype Length Precision Not-null Comments
DT_SRC_USG_BND_VAL_ID NUMBER 18 Yes DATA_SOURCE_USG_BIND_VAL_ID
DATA_SOURCE_USAGE_ID NUMBER 18 DATA_SOURCE_USAGE_ID
CRITERIA_BIND_ID NUMBER 18 Yes CRITERIA_BIND_ID
VARCHAR_VALUE VARCHAR2 240 VARCHAR_VALUE
LONG_VALUE NUMBER 18 LONG_VALUE
INTEGER_VALUE VARCHAR2 9 INTEGER_VALUE
BIGDECIMAL_VALUE NUMBER BIGDECIMAL_VALUE
DATE_VALUE DATE DATE_VALUE
TIMESTAMP_VALUE TIMESTAMP TIMESTAMP_VALUE
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_DT_SRC_USG_BND_VALS hwm_criteria_binds CRITERIA_BIND_ID
HWM_DT_SRC_USG_BND_VALS hwm_data_source_usages DATA_SOURCE_USAGE_ID
HWM_DT_SRC_USG_BND_VALS fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_DT_SRC_USG_BND_VALS_N20 Non Unique Default SGUID
HWM_DT_SRC_USG_BND_VALS_N1 Non Unique Default DATA_SOURCE_USAGE_ID, CRITERIA_BIND_ID
HWM_DT_SRC_USG_BND_VALS_U1 Unique Default DT_SRC_USG_BND_VAL_ID

HWM_GRPS_B

This table contains details for HCM groups

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_GRPS_B_PK

GRP_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_ID NUMBER 18 Yes GRP_ID
ONLINE_EVAL_FLAG VARCHAR2 30 ONLINE_EVAL_FLAG
MASS_EVAL_FLAG VARCHAR2 30 MASS_EVAL_FLAG
GRP_CODE VARCHAR2 255 GRP_CODE
APPL_USG_CD VARCHAR2 30 APPL_USG_CD
APPLIES_TO_CD VARCHAR2 30 APPLIES_TO_CD
FREEZE_FLAG VARCHAR2 30 FREEZE_FLAG
RUN_TYPE VARCHAR2 30 RUN_TYPE
EVAL_STATUS_CD VARCHAR2 30 EVAL_STATUS_CD
NUM_DAYS_PREV NUMBER 9 NUM_DAYS_PREV
NUM_DAYS_NEXT NUMBER 9 NUM_DAYS_NEXT
LAST_REFRESH_DT TIMESTAMP LAST_REFRESH_DT
NEXT_REFRESH_DT TIMESTAMP NEXT_REFRESH_DT
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_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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
ASSIGNMENT_TO_USE_CD VARCHAR2 20 ASSIGNMENT_TO_USE_CD
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.
MEM_TYPE_CD VARCHAR2 30 MEM_TYPE_CD

Foreign Keys

Table Foreign Table Foreign Key Column
hwm_te_alt_name_grps hwm_grps_b GRP_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_GRPS_B_N20 Non Unique Default SGUID
HWM_GRPS_B_U1 Unique FUSION_TS_TX_DATA GRP_ID

HWM_GRPS_TL

Contains Translated values for Group Defintion

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_GRPS_TL_PK

GRP_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
GRP_ID NUMBER 18 Yes GRP_ID
GROUP_NAME VARCHAR2 180 GROUP_NAME
DESCRIPTION VARCHAR2 1000 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRPS_TL_N1 Non Unique Default UPPER("GROUP_NAME")
HWM_GRPS_TL_U1 Unique FUSION_TS_TX_DATA GRP_ID, LANGUAGE

HWM_GRP_CRITERIA

Contains Criteria for Group Defintion

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWM_GRP_CRITERIA_PK

GRP_CRITERIA_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_CRITERIA_ID NUMBER 18 Yes GRP_CRITERIA_ID
ADDL_ATTR_CATEGORY VARCHAR2 30 ADDL_ATTR_CATEGORY
ADDL_ATTR_CHAR1 VARCHAR2 150 ADDL_ATTR_CHAR1
ADDL_ATTR_CHAR2 VARCHAR2 150 ADDL_ATTR_CHAR2
ADDL_ATTR_CHAR3 VARCHAR2 150 ADDL_ATTR_CHAR3
ADDL_ATTR_CHAR4 VARCHAR2 150 ADDL_ATTR_CHAR4
ADDL_ATTR_CHAR5 VARCHAR2 150 ADDL_ATTR_CHAR5
ADDL_ATTR_NUMBER1 NUMBER ADDL_ATTR_NUMBER1
ADDL_ATTR_NUMBER2 NUMBER ADDL_ATTR_NUMBER2
ADDL_ATTR_NUMBER3 NUMBER ADDL_ATTR_NUMBER3
ADDL_ATTR_NUMBER4 NUMBER ADDL_ATTR_NUMBER4
ADDL_ATTR_NUMBER5 NUMBER ADDL_ATTR_NUMBER5
GRP_ID NUMBER 18 GRP_ID
ORDR_NUM NUMBER 9 ORDR_NUM
LEFT_PARAM_NUM NUMBER 9 LEFT_PARAM_NUM
CRITERIA_ID NUMBER 18 CRITERIA_ID
CRITERIA_NAME VARCHAR2 100 CRITERIA_NAME
CRITERIA_DISPLAY_NAME VARCHAR2 100 CRITERIA_DISPLAY_NAME
OPERATOR_ID NUMBER 18 OPERATOR_ID
OPERATOR_NAME VARCHAR2 100 OPERATOR_NAME
RIGHT_PARAM_NUM NUMBER 9 RIGHT_PARAM_NUM
VALUE_CHAR VARCHAR2 30 VALUE_CHAR
VALUE_NUMBER NUMBER 18 VALUE_NUMBER
VALUE_DATE DATE VALUE_DATE
VALUE_TS TIMESTAMP VALUE_TS
BOOL_OPER_CD VARCHAR2 30 BOOL_OPER_CD
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
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.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_CRITERIA_N1 Non Unique Default GRP_ID
HWM_GRP_CRITERIA_U1 Unique FUSION_TS_TX_DATA GRP_CRITERIA_ID

HWM_GRP_EVAL_PROCESSES

Contains Group Evaluation Process Run Details

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWM_GRP_EVAL_PROCESSES_PK

GRP_EVAL_PROCESS_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_EVAL_PROCESS_ID NUMBER 18 Yes GRP_EVAL_PROCESS_ID
ERROR_TEXT VARCHAR2 4000 ERROR_TEXT
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
GRP_ID NUMBER 18 GRP_ID
PROCESS_DT TIMESTAMP PROCESS_DATE
RUN_TYPE VARCHAR2 30 RUN_TYPE
NUM_DAYS_PREV NUMBER 9 NUM_DAYS_PREV
NUM_DAYS_NEXT NUMBER 9 NUM_DAYS_NEXT
EVAL_STATUS_CD VARCHAR2 30 EVAL_STATUS_CD
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.
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_EVAL_PROCESSES_U1 Unique FUSION_TS_TX_DATA GRP_EVAL_PROCESS_ID

HWM_GRP_INCL_GRPS

Contains Included Groups for Group Defintion

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_GRP_INCL_GRPS_PK

GRP_INCL_GRP_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_INCL_GRP_ID NUMBER 18 Yes GRP_INCL_GRP_ID
GRP_OR_VALUESET_CD VARCHAR2 30 GRP_OR_VALUESET_CD
GRP_ID NUMBER 18 GRP_ID
INCL_GRP_ID NUMBER 18 INCL_GRP_ID
INCL_FLAG VARCHAR2 30 INCL_FLAG
ORDER_NUM NUMBER 9 ORDER_NUM
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_INCL_GRPS_N1 Non Unique FUSION_TS_TX_DATA GRP_ID, INCL_GRP_ID
HWM_GRP_INCL_GRPS_U1 Unique FUSION_TS_TX_DATA GRP_INCL_GRP_ID

HWM_GRP_INCL_MEMBERS

Contains Included Members for Group Defintion

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_GRP_INCL_MEMBERS_PK

GRP_INCL_MEMBER_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_INCL_MEMBER_ID NUMBER 18 Yes GRP_INCL_MEMBER_ID
GRP_ID NUMBER 18 GRP_ID
INCL_MEMBER_ID NUMBER 18 INCL_MEMBER_ID
INCL_FLAG VARCHAR2 30 INCL_FLAG
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_INCL_MEMBERS_N1 Non Unique FUSION_TS_TX_DATA GRP_ID, INCL_MEMBER_ID
HWM_GRP_INCL_MEMBERS_U1 Unique FUSION_TS_TX_DATA GRP_INCL_MEMBER_ID

HWM_GRP_MEMBERS_AUDIT

Contains group members table updation Information.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_GRP_MEMBERS_AUDIT_PK

GRP_MEMBERS_AUDIT_ID

Columns

Name Datatype Length Precision Not-null Comments
GRP_MEMBERS_AUDIT_ID NUMBER 18 Yes GRP_MEMBERS_AUDIT_ID
GRP_MEMBER_ID NUMBER 18 Yes GRP_MEMBER_ID
GRP_ID NUMBER 18 GRP_ID
MEMBER_ID NUMBER 18 MEMBER_ID
ORIG_EFF_START_DATE DATE ORIG_EFF_START_DATE
NEW_EFF_START_DATE DATE NEW_EFF_START_DATE
ORIG_EFF_END_DATE DATE ORIG_EFF_END_DATE
NEW_EFF_END_DATE DATE NEW_EFF_END_DATE
ACTION_TYPE VARCHAR2 30 ACTION_TYPE
REASON_CODE VARCHAR2 30 REASON_CODE
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.
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_MEMBERS_AUDIT_U1 Unique Default GRP_MEMBERS_AUDIT_ID

HWM_GRP_MEMBERS_F

Contains Group Membership Information

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWM_GRP_MEMBERS_F_PK

GRP_MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
GRP_MEMBER_ID NUMBER 18 Yes GRP_MEMBER_ID
GRP_ID NUMBER 18 GRP_ID
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
MEMBER_ID NUMBER 18 MEMBER_ID
GRP_EVAL_PROCESS_ID NUMBER 18 GRP_EVAL_PROCESS_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
REMARKS VARCHAR2 500 Remarks only for errored members

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_MEMBERS_F_N1 Non Unique FUSION_TS_TX_DATA GRP_ID, MEMBER_ID, GRP_EVAL_PROCESS_ID
HWM_GRP_MEMBERS_F_N2 Non Unique Default MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE
HWM_GRP_MEMBERS_F_U1 Unique FUSION_TS_TX_DATA GRP_MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

HWM_GRP_MEMBERS_F_

Contains Group Membership Information

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

HWM_GRP_MEMBERS_F_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, GRP_MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments
GRP_MEMBER_ID NUMBER 18 Yes GRP_MEMBER_ID
GRP_ID NUMBER 18 GRP_ID
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
MEMBER_ID NUMBER 18 MEMBER_ID
GRP_EVAL_PROCESS_ID NUMBER 18 GRP_EVAL_PROCESS_ID
ENTERPRISE_ID NUMBER 18 ENTERPRISE_ID
OBJECT_VERSION_NUMBER NUMBER 9 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 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.
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.
REMARKS VARCHAR2 500 Remarks only for errored members
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_MEMBERS_FN1_ Non Unique Default GRP_MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, LAST_UPDATE_DATE
HWM_GRP_MEMBERS_F_U1_ Unique FUSION_TS_TX_DATA LAST_UPDATE_DATE, LAST_UPDATED_BY, GRP_MEMBER_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

HWM_GRP_TYPE

A type of time record group. For example, an absence header, which contains a collection of absence entries. Or, a time card, containing a collection of days, or a day, which contains a collection of time records.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_TM_GRP_PK

GROUP_ROW_ID

Columns

Name Datatype Length Precision Not-null Comments
GROUP_ROW_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
GRP_TYPE_ID NUMBER 18 Yes Unique group type Id
PARENT_GRP_ID NUMBER 18 The building block id for the parent block in the time structure hierarchy.
GRP_LEVEL NUMBER Yes Group Level
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
LAYER_ID NUMBER 18 Yes TM_LAYER_ID
NAME VARCHAR2 255 Yes For Range type of building blocks, the stop time of the block.
DESCRIPTION VARCHAR2 1000 DESCRIPTION
GRP_TYPE VARCHAR2 30 Explicit or Implicit
IS_TM_REC VARCHAR2 30 Yes IS_TM_REC
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_GRP_TYPE hwm_grp_type PARENT_GRP_ID
HWM_GRP_TYPE fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
HWM_GRP_TYPE hwm_layer LAYER_ID
hwm_tm_rec_grp hwm_grp_type GRP_TYPE_ID
hwm_grp_type hwm_grp_type PARENT_GRP_ID
hwm_tm_rec hwm_grp_type GRP_TYPE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_GRP_TYPE_N20 Non Unique Default SGUID
HWM_GRP_TYPE_PK Unique FUSION_TS_TX_DATA GROUP_ROW_ID
HWM_GRP_TYPE_U1 Unique Default GRP_TYPE_ID

HWM_INTERACT_QSNR_USAGES

Stores cross refence ids between Time card repository, Attestation group set and Talent's questioner table

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_INTERACT_QSNR_USAGES_PK

ITR_QSR_USG_ID

Columns

Name Datatype Length Precision Not-null Comments
ITR_QSR_USG_ID NUMBER 18 Yes Primary Key
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
ITR_SET_ID NUMBER 18 Yes ITR_SET_ID
RESPONSE_STATUS VARCHAR2 30 Yes RESPONSE_STATUS
QUESTIONNAIRE_ID NUMBER 18 Yes QUESTIONNAIRE_ID
QSTNR_VERSION_NUM NUMBER 18 QSTNR_VERSION_NUM
QSTNR_PARTICIPANT_ID NUMBER 18 QSTNR_PARTICIPANT_ID
ATTN_TE_ID NUMBER 18 Time event or entry identifier associated to an attestation
TM_BLDG_BLK_ID NUMBER 18 TM_BLDG_BLK_ID
TM_BLDG_BLK_VERSION NUMBER 9 TM_BLDG_BLK_VERSION
TM_REC_GRP_ID NUMBER 18 TM_REC_GRP_ID
BLDG_BLK_TYPE VARCHAR2 32 BLDG_BLK_TYPE
DELETE_FLAG VARCHAR2 1 DELETE_FLAG
ORIGINAL_RESPONSE_SOURCE VARCHAR2 30 ORIGINAL_RESPONSE_SOURCE
RESOURCE_ID NUMBER 18 Yes RESOURCE_ID
SUBRESOURCE_ID NUMBER 18 SUBRESOURCE_ID
DISPLAY_LEVEL VARCHAR2 30 DISPLAY_LEVEL
ACTUAL_PUNCH_TIME VARCHAR2 30 COLUMN1
START_TIME TIMESTAMP START_TIME
STOP_TIME TIMESTAMP STOP_TIME
MEASURE NUMBER MEASURE
PART_DATE TIMESTAMP partition key
PART_GRP_TYPE_ID NUMBER 18 partition key
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_INTERACT_QSNR_USAGES_N1 Non Unique Default RESOURCE_ID, TRUNC("START_TIME"), TRUNC("STOP_TIME")
HWM_INTERACT_QSNR_USAGES_N2 Non Unique Default ITR_SET_ID
HWM_INTERACT_QSNR_USAGES_N3 Non Unique Default TM_BLDG_BLK_ID, NVL("DELETE_FLAG",'N')
HWM_INTERACT_QSNR_USAGES_PK Unique FUSION_TS_TX_DATA ITR_QSR_USG_ID

HWM_INTERACT_SETS

Contains group heade information for questioner Attestation group set

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_INTERACT_SETS_PK

ITR_SET_ID

Columns

Name Datatype Length Precision Not-null Comments
ITR_SET_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
ITR_SET_NAME VARCHAR2 120 Yes Name of the Group
ITR_SET_DESCRIPTION VARCHAR2 500 Optional description of the group
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_INTERACT_SETS_PK Unique FUSION_TS_TX_DATA ITR_SET_ID
HWM_INTERACT_SETS_U1 Unique Default ITR_SET_NAME

HWM_INTERACT_SET_LNS

Stores list of questioner IDs and conditions for Attestation group set

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_INTERACT_SET_LNS_PK

ITR_SET_LN_ID

Columns

Name Datatype Length Precision Not-null Comments
ITR_SET_LN_ID NUMBER 18 Yes ITR_SET_LN_ID
ITR_SET_ID NUMBER 18 Yes ITR_SET_ID
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.
PROCESSING_ORDER NUMBER Yes PROCESSING_ORDER
QUESTIONNAIRE_ID NUMBER 18 Yes QUESTIONNAIRE_ID
QSTNR_VERSION_NUM NUMBER 18 Yes QSTNR_VERSION_NUM
QUESTIONNAIRE_CODE VARCHAR2 240 Yes QUESTIONNAIRE_CODE
TIME_CATEGORY_ID NUMBER 18 Yes TIME_CATEGORY_ID
TRIGGER_EVENT_CS VARCHAR2 400 Yes TRIGGER_EVENT_CS
DISPLAY_LEVEL VARCHAR2 30 Yes DISPLAY_LEVEL
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_INTERACT_SET_LNS_PK Unique FUSION_TS_TX_DATA ITR_SET_LN_ID
HWM_INTERACT_SET_LNS_U1 Unique Default ITR_SET_ID, PROCESSING_ORDER

HWM_LAYER

A type of time collection in the repository. For example, reported time, which corresponds to the time card time record group, the day time record group and the time entry time record. Layers can be abstract, which typically include more than a single layer, e.g., reported time and absence time.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_TM_LAYER_PK

LAYER_ID

Columns

Name Datatype Length Precision Not-null Comments
LAYER_ID NUMBER 18 Yes TM_MSG_TKNS_ID
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
LAYER_CODE VARCHAR2 20 Yes LAYER_CODE
NAME VARCHAR2 255 Yes TOKEN_NAME
DESCRIPTION VARCHAR2 1000 DESCRIPTION
AUDITABLE VARCHAR2 30 Yes or No
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_LAYER fnd_appl_taxonomy ENTERPRISE_ID, MODULE_ID
hwm_grp_type hwm_layer LAYER_ID
hwm_tm_rec hwm_layer LAYER_CODE

Indexes

Index Uniqueness Tablespace Columns
HWM_LAYER_U1 Unique FUSION_TS_TX_DATA LAYER_CODE
HWM_TM_LAYER_PK Unique FUSION_TS_TX_DATA LAYER_ID

HWM_PER_TZ_OVERRIDES

This table is designed to store time zone overrides of a person against the primary assignment.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

hwm_per_tz_overrides_PK

PER_TZ_OVERRIDE_ID

Columns

Name Datatype Length Precision Not-null Comments
PER_TZ_OVERRIDE_ID NUMBER 18 Yes PER_TZ_OVERRIDE_ID
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.
ASSIGNMENT_ID NUMBER 18 Yes ASSIGNMENT_ID
PERSON_ID NUMBER 18 Yes PERSON_ID
LOCAL_START_DATE DATE Yes LOCAL_START_DATE
LOCAL_END_DATE DATE Yes LOCAL_END_DATE
TIMEZONE_ID VARCHAR2 50 Yes TIMEZONE_ID
UTC_START_TIME TIMESTAMP Yes UTC_START_TIME
UTC_END_TIME TIMESTAMP Yes UTC_END_TIME
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.
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.

Indexes

Index Uniqueness Tablespace Columns
hwm_per_tz_overrides_U1 Unique Default PER_TZ_OVERRIDE_ID
hwm_per_tz_overrides_U2 Unique Default ASSIGNMENT_ID, LOCAL_START_DATE, LOCAL_END_DATE
hwm_per_tz_overrides_U3 Unique Default ASSIGNMENT_ID, UTC_START_TIME, UTC_END_TIME

HWM_PER_TZ_OVERRIDES_

This table is designed to store time zone overrides of a person against the primary assignment.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

hwm_per_tz_overrides_PK_

LAST_UPDATE_DATE, LAST_UPDATED_BY, PER_TZ_OVERRIDE_ID

Columns

Name Datatype Length Precision Not-null Comments
PER_TZ_OVERRIDE_ID NUMBER 18 Yes PER_TZ_OVERRIDE_ID
OBJECT_VERSION_NUMBER NUMBER 9 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.
ASSIGNMENT_ID NUMBER 18 ASSIGNMENT_ID
PERSON_ID NUMBER 18 PERSON_ID
LOCAL_START_DATE DATE LOCAL_START_DATE
LOCAL_END_DATE DATE LOCAL_END_DATE
TIMEZONE_ID VARCHAR2 50 TIMEZONE_ID
UTC_START_TIME TIMESTAMP UTC_START_TIME
UTC_END_TIME TIMESTAMP UTC_END_TIME
CREATION_DATE TIMESTAMP Who column: indicates the date and time of the creation of the row.
CREATED_BY VARCHAR2 64 Who column: indicates the user who created the row.
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.
AUDIT_ACTION_TYPE_ VARCHAR2 10 Action Type - have values like INSERT, UPDATE and DELETE.
AUDIT_CHANGE_BIT_MAP_ VARCHAR2 1000 Used to store a bit map of 1s and 0s for each column in the table.
AUDIT_IMPERSONATOR_ VARCHAR2 64 Original Impersonator User.

Indexes

Index Uniqueness Tablespace Columns
HWM_PER_TZ_OVERRIDESN1_ Non Unique Default PER_TZ_OVERRIDE_ID, LAST_UPDATE_DATE
hwm_per_tz_overrides_U1_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, PER_TZ_OVERRIDE_ID
hwm_per_tz_overrides_U2_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, ASSIGNMENT_ID, LOCAL_START_DATE, LOCAL_END_DATE
hwm_per_tz_overrides_U3_ Unique Default LAST_UPDATE_DATE, LAST_UPDATED_BY, ASSIGNMENT_ID, UTC_START_TIME, UTC_END_TIME

HWM_PROCESSES_B

This table holds information about the various processes executed when loading time into the repository. For example, the 'Execute Time Entry Rules' process is defined in this table.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESSES_B_PK

PROCESS_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_ID NUMBER 18 Yes PROCESS_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
PROCESS_CD VARCHAR2 30 PROCESS_CD
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_PROCESSES_B fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
hwm_processes_tl hwm_processes_b PROCESS_ID
hwm_process_components hwm_processes_b PARENT_PROCESS_ID
hwm_process_components hwm_processes_b PROCESS_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESSES_B_N20 Non Unique Default SGUID
HWM_PROCESSES_B_U1 Unique Default PROCESS_ID
HWM_PROCESSES_B_U2 Unique Default PROCESS_CD, ENTERPRISE_ID

HWM_PROCESSES_TL

Indicates the code of the language into which the contents of the translatable columns are translated.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESSES_TL_PK

PROCESS_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_ID NUMBER 18 Yes PROCESS_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
NAME VARCHAR2 255 NAME
DESCRIPTION VARCHAR2 1000 DESCRIPTION
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_PROCESSES_TL hwm_processes_b PROCESS_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESSES_TL_PK Unique Default PROCESS_ID, LANGUAGE

HWM_PROCESS_COMPONENTS

Table can be used to add components to a process.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESS_COMPONENTS_PK

PROCESS_COMPONENT_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_COMPONENT_ID NUMBER 18 Yes PROCESS_COMPONENT_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
PARENT_PROCESS_ID NUMBER 18 PARENT_PROCESS_ID
PROCESS_ID NUMBER 18 PROCESS_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
OBJECT_VESION_NUMBER NUMBER 9 Yes OBJECT_VESION_NUMBER
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_PROCESS_COMPONENTS hwm_processes_b PARENT_PROCESS_ID
HWM_PROCESS_COMPONENTS hwm_processes_b PROCESS_ID
HWM_PROCESS_COMPONENTS fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
hwm_process_usages hwm_process_components PROCESS_COMPONENT_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESS_COMPONENTS_N20 Non Unique Default SGUID
HWM_PROCESS_COMPONENTS_N3 Non Unique Default PARENT_PROCESS_ID
HWM_PROCESS_COMPONENTS_U1 Unique Default PROCESS_COMPONENT_ID

HWM_PROCESS_CONDITIONS

This table indication which components needs to run in a process.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESS_CONDITIONS_PK

PROCESS_CONDITIONS_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_CONDITIONS_ID NUMBER 18 Yes PROCESS_CONDITIONS_ID
PROCESS_MODE_ID NUMBER 18 PROCESS_MODE_ID
PROCESS_ID NUMBER 18 PROCESS_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESS_CONDITIONS_N20 Non Unique Default SGUID
HWM_PROCESS_CONDITIONS_N3 Non Unique Default PROCESS_MODE_ID
HWM_PROCESS_CONDITIONS_U1 Unique Default PROCESS_CONDITIONS_ID

HWM_PROCESS_MODES

A process execution mode, for example, save time or absence submit.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESS_MODES_PK

PROCESS_MODE_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_MODE_ID NUMBER 18 Yes PROCESS_MODE_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
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.
NAME VARCHAR2 255 NAME
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_PROCESS_MODES fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
hwm_process_usages hwm_process_modes PROCESS_MODE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESS_MODES_N20 Non Unique Default SGUID
HWM_PROCESS_MODES_U1 Unique Default PROCESS_MODE_ID
HWM_PROCESS_MODES_U2 Unique Default NAME, ENTERPRISE_ID

HWM_PROCESS_USAGES

Identifies which process components are used in a particular process mode.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_PROCESS_USAGES_PK

PROCESS_USAGES_ID

Columns

Name Datatype Length Precision Not-null Comments
PROCESS_USAGES_ID NUMBER 18 Yes PROCESS_USAGES_ID
PROCESS_MODE_ID NUMBER 18 Yes PROCESS_MODE_ID
PROCESS_COMPONENT_ID NUMBER 18 Yes PROCESS_COMPONENT_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
ENABLED VARCHAR2 30 Column to identify whether a Process Component is allowed or not
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_PROCESS_USAGES hwm_process_components PROCESS_COMPONENT_ID
HWM_PROCESS_USAGES hwm_process_modes PROCESS_MODE_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_PROCESS_USAGES_N20 Non Unique Default SGUID
HWM_PROCESS_USAGES_N3 Non Unique Default PROCESS_MODE_ID
HWM_PROCESS_USAGES_U1 Unique Default PROCESS_USAGES_ID

HWM_RP_TM_PATTERNS

A table for specifying Patterns in terms of Range & Steps.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RP_TM_PATTERNS_PK

TM_PATTERN_ID

Columns

Name Datatype Length Precision Not-null Comments
TM_PATTERN_ID NUMBER 18 Yes TM_PATTERN_ID
TM_PATTERN_CD VARCHAR2 80 TM_PATTERN_CD
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
TM_RANGE_ID NUMBER 18 TM_RANGE_ID
TM_STEP_ID NUMBER 18 TM_STEP_ID
FIRST_STEP_TM TIMESTAMP FIRST_STEP_TM
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.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_RP_TM_PATTERNS fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
HWM_RP_TM_PATTERNS hwm_rp_tm_periods_b TM_RANGE_ID
HWM_RP_TM_PATTERNS hwm_rp_tm_periods_b TM_STEP_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_RP_TM_PATTERNS_N20 Non Unique Default SGUID
HWM_RP_TM_PATTERNS_U1 Unique FUSION_TS_SEED TM_PATTERN_ID

HWM_RP_TM_PERIODS_B

Repeating Time Periods Base table

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RP_TM_PERIODS_B_PK

REPEATING_TM_PERIOD_ID

Columns

Name Datatype Length Precision Not-null Comments
REPEATING_TM_PERIOD_ID NUMBER 18 Yes REPEATING_TM_PERIOD_ID
ACCRUAL_USAGE VARCHAR2 30 ACCRUAL_USAGE
OVERTIME_USAGE VARCHAR2 30 OVERTIME_USAGE
BALANCE_USAGE VARCHAR2 30 BALANCE_USAGE
PERIOD_CD VARCHAR2 80 PERIOD_CD
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
PERIOD_CLASS VARCHAR2 32 Yes PERIOD_CLASS
PERIOD_TYPE VARCHAR2 32 Yes PERIOD_TYPE
PERIOD_START_DATE DATE PERIOD_START_DATE
MULTIPLE NUMBER 3 MULTIPLE
MONTH_TYPE VARCHAR2 32 MONTH_TYPE
ONE_OR_MANY VARCHAR2 32 ONE_OR_MANY
WEEK_TYPE VARCHAR2 32 WEEK_TYPE
PERIOD_LENGTH NUMBER 2 PERIOD_LENGTH
REFERENCE_DATE DATE DAY_REFERENCE_DATE
RULE_USAGE VARCHAR2 30 RULE_USAGE
TIME_ENTRY_USAGE VARCHAR2 30 TIME_ENTRY_USAGE
APPROVAL_USAGE VARCHAR2 30 APPROVAL_USAGE
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.
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_RP_TM_PERIODS_B fnd_appl_taxonomy MODULE_ID, ENTERPRISE_ID
hwm_rp_tm_patterns hwm_rp_tm_periods_b TM_RANGE_ID
hwm_rp_tm_patterns hwm_rp_tm_periods_b TM_STEP_ID
hwm_rp_tm_resolved hwm_rp_tm_periods_b REPEATING_TM_PERIOD_ID
hwm_tcsmr_configs hwm_rp_tm_periods_b APPROVAL_PERIOD_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_RP_TM_PERIODS_B_N20 Non Unique Default SGUID
HWM_RP_TM_PERIODS_B_N1 Non Unique Default PERIOD_CLASS
HWM_RP_TM_PERIODS_B_U1 Unique Default REPEATING_TM_PERIOD_ID

HWM_RP_TM_PERIODS_TL

A period of time used to group time entries

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RP_TM_PERIODS_TL_PK

REPEATING_TM_PERIOD_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
REPEATING_TM_PERIOD_ID NUMBER 18 Yes REPEATING_TM_PERIOD_ID
NAME VARCHAR2 80 Yes NAME
DESCRIPTION VARCHAR2 1000 Description of the Period
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
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.
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.
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_RP_TM_PERIODS_TL_U1 Unique Default REPEATING_TM_PERIOD_ID, LANGUAGE

HWM_RP_TM_RESOLVED

This table holds the generated repeating period.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RP_TM_RESOLVED_PK

RESOLVED_TM_PERIOD_ID

Columns

Name Datatype Length Precision Not-null Comments
RESOLVED_TM_PERIOD_ID NUMBER 18 Yes RESOLVED_TM_PERIOD_ID
ENTERPRISE_ID NUMBER 18 Yes ENTERPRISE_ID
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.
REPEATING_TM_PERIOD_ID NUMBER 18 REPEATING_TM_PERIOD_ID
START_DATE TIMESTAMP START_DATE
END_DATE TIMESTAMP END_DATE
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Foreign Keys

Table Foreign Table Foreign Key Column
HWM_RP_TM_RESOLVED hwm_rp_tm_periods_b REPEATING_TM_PERIOD_ID

Indexes

Index Uniqueness Tablespace Columns
HWM_RP_TM_RESOLVED_N1 Non Unique FUSION_TS_TX_DATA REPEATING_TM_PERIOD_ID, START_DATE, END_DATE
HWM_RP_TM_RESOLVED_PK Unique Default RESOLVED_TM_PERIOD_ID

HWM_RULES

Contains the rules created for OTL Time Calculation, Time Entry and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULES_PK

RULE_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
RULE_NAME VARCHAR2 80 Yes Name of the Rule
DESCRIPTION VARCHAR2 240 Optional description of the Rule
RULE_TMPLTS_ID NUMBER 18 Yes Foreign Key to the template used to create the rule.
PRS_FORMULA_ID NUMBER 18 PRS_FORMULA_ID
PRS_SCRIPT_ID NUMBER 18 PRS_SCRIPT_ID
PROCESS_TYPE VARCHAR2 30 PROCESS_TYPE
RULE_TYPE VARCHAR2 30 Yes RULE_TYPE
CLASSIFICATION VARCHAR2 30 CLASSIFICATION
RUN_SUMMATION_LEVEL VARCHAR2 30 summation Level
RUN_TBB_LEVEL VARCHAR2 30 Report Level
RULE_EXEC_TYPE VARCHAR2 30 RULE_EXEC_TYPE
RUN_EVENT_SAVE VARCHAR2 1 RUN_EVENT_SAVE
RUN_EVENT_SUB VARCHAR2 1 RUN_EVENT_SUB
RUN_EVENT_RESUB VARCHAR2 1 RUN_EVENT_RESUB
RUN_EVENT_DELETE VARCHAR2 1 RUN_EVENT_DELETE
SUPPRESS_DUP_MSGS VARCHAR2 1 Suppress duplicate TER messages
INCLUDE_EMPTY_TC VARCHAR2 30 process NULL timecards
RULE_SUB_TYPE VARCHAR2 30 RULE_SUB_TYPE
FAST_FORMULA_EXEC_TYPE VARCHAR2 30 FAST_FORMULA_EXEC_TYPE
DFLT_ALLOCATION_ID NUMBER 18 DFLT_ALLOCATION_ID
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULES_PK Unique FUSION_TS_TX_DATA RULE_ID
HWM_RULES_U1 Unique FUSION_TS_TX_DATA RULE_NAME

HWM_RULES_CNDL

Conditional Rule Set table, which holds the members of conditional Rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULES_CNDL_PK

CNDL_RULE_ID

Columns

Name Datatype Length Precision Not-null Comments
CNDL_RULE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
CNDL_RULE_NAME VARCHAR2 80 Yes Name of the Conditional Rule
RULE_TYPE VARCHAR2 30 Yes RULE_TYPE
DESCRIPTION VARCHAR2 240 Optional description of the Conditional Rule
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULES_CNDL_PK Unique FUSION_TS_TX_DATA CNDL_RULE_ID
HWM_RULES_CNDL_U1 Unique FUSION_TS_TX_DATA CNDL_RULE_NAME

HWM_RULES_CNDL_MBRS

Conditional Rule Members of Time Calculation Rules are stored in this table.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULES_CNDL_MBRS_PK

CNDL_RULE_MBR_ID

Columns

Name Datatype Length Precision Not-null Comments
CNDL_RULE_MBR_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
CNDL_RULE_ID NUMBER 18 Foreign key to HWM_RULES_CNDL table.
RULE_ID NUMBER 18 RULE_ID
PROCESSING_ORDER NUMBER 9 Yes Order in which this conditional rule should be applied on the TBB.
TCAT_ID NUMBER 18 Yes Time Category Run Condition, which determines if the rule should be applied on a TBB
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULES_CNDL_MBRS_PK Unique FUSION_TS_TX_DATA CNDL_RULE_MBR_ID
HWM_RULES_CNDL_MBRS_U1 Unique FUSION_TS_TX_DATA CNDL_RULE_ID, PROCESSING_ORDER

HWM_RULE_FF_WORKAREA

Contains the rules created for OTL Time Calculation, Time Entry and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_FF_WORKAREA_PK

WORKAREA_ID

Columns

Name Datatype Length Precision Not-null Comments
WORKAREA_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
FFS_ID NUMBER 18 Yes Unique Fast Formula Session id used for one ruleset processing
PARM_TYPE VARCHAR2 10 Yes Values 'WRK', 'LOG', 'RULE'
PARM_NAME VARCHAR2 30 Yes PARM_NAME
PARM_SEQ NUMBER 9 Yes PARM_SEQ
RULE_ID NUMBER 18 RULE_ID
PARM_VALUE_ID NUMBER 18 PARM_VALUE_ID
PARM_VALUE_NUMBER NUMBER PARM_VALUE_NUMBER
PARM_VALUE_DATE DATE PARM_VALUE_DATE
PARM_VALUE_TEXT VARCHAR2 250 PARM_VALUE_TEXT
PARM_VALUE_LOG VARCHAR2 250 PARM_VALUE_LOG
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_FF_WORKAREA_N1 Non Unique Default WORKAREA_ID, LAST_UPDATE_DATE
HWM_RULE_FF_WORKAREA_N2 Non Unique Default TRUNC("CREATION_DATE")
HWM_RULE_FF_WORKAREA_PK Unique FUSION_TS_TX_DATA WORKAREA_ID
HWM_RULE_FF_WORKAREA_U1 Unique FUSION_TS_TX_DATA FFS_ID, PARM_TYPE, PARM_NAME, PARM_SEQ

HWM_RULE_FF_WORK_LOG

Contains the logs created for OTL Time Calculation, Time Entry and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_FF_WORK_LOG_PK

LOG_ID

Columns

Name Datatype Length Precision Not-null Comments
LOG_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
FFS_ID NUMBER 18 Yes Unique Fast Formula Session id used for one ruleset processing
RULE_ID NUMBER 18 RULE_ID
LOG_TYPE VARCHAR2 30 LOG_TYPE
LOG_GROUP_TYPE VARCHAR2 30 LOG_GROUP_TYPE
APP_NAME VARCHAR2 30 APP_NAME
LOG_SEVERITY VARCHAR2 30 LOG_SEVERITY
LOG_TEXT VARCHAR2 2000 LOG_TEXT
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_FF_WORK_LOG_N1 Non Unique Default FFS_ID
HWM_RULE_FF_WORK_LOG_N2 Non Unique Default RULE_ID
HWM_RULE_FF_WORK_LOG_N3 Non Unique Default TRUNC("CREATION_DATE")
HWM_RULE_FF_WORK_LOG_PK Unique FUSION_TS_TX_DATA LOG_ID

HWM_RULE_INPUTS

Stores Rule Templates Input PArameters for Formula/Script

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_INPUTS_PK

RULE_INPUT_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_INPUT_ID NUMBER 18 Yes COLUMN1
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.
RULE_ID NUMBER 18 Yes RULE_ID
RULE_TMPLT_INPUT_ID NUMBER 18 Yes RULE_TMPLT_INPUT_ID
DISPLAY_SEQUENCE NUMBER Yes DISPLAY_SEQUENCE
INPUT_NAME VARCHAR2 30 Yes PROCESS_INPUT
USER_DEFINED_NAME VARCHAR2 80 Deprecated/ Obsolete column. Column replaced with reference to HWM_RULE_TMPLT_INPUTS_VL .USER_DEFINED_IN_NAME
RULE_PARAMETER_TYPE VARCHAR2 30 RULE_PARAMETER_TYPE
VALUE_SET_ID NUMBER 18 Forgin key to to FND_VS_VALUE_SETS table
TCAT_ID NUMBER 18 Time category Run Condition, which determines if this member should be applied on TBB.
DISPLAY_TYPE VARCHAR2 20 DISPLAY_TYPE
DISPLAY_VALUE VARCHAR2 250 DISPLAY_VALUE
VALUE_TEXT VARCHAR2 240 VALUE_TEXT
VALUE_NUMBER NUMBER VALUE_NUMBER
VALUE_DATE DATE VALUE_DATE
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
PARM_VALUE_REQUIRED VARCHAR2 1 PARM_VALUE_REQUIRED
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_INPUTS_PK Unique FUSION_TS_TX_DATA RULE_INPUT_ID
HWM_RULE_INPUTS_U1 Unique FUSION_TS_TX_DATA RULE_ID, INPUT_NAME

HWM_RULE_OUTPUTS

An output from a rule used in further processing

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_OUTPUTS_PK

RULE_OUTPUT_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_OUTPUT_ID NUMBER 18 Yes RULE_OUTPUT_ID
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.
RULE_ID NUMBER 18 Yes RULE_ID
RULE_TMPLT_USAGES_ID NUMBER 18 Yes RULE_TMPLT_USAGES_ID
OUTPUT_NAME VARCHAR2 30 Yes PROCESS_INPUT
OUTPUT_SOURCE VARCHAR2 30 Yes OUTPUT_SOURCE
DISPLAY_SEQUENCE NUMBER Yes DISPLAY_SEQUENCE
TBB_GROUP_NUMBER NUMBER Yes TBB_GROUP_NUMBER
HIDE_FLAG VARCHAR2 1 HIDE_FLAG
RECURSIVE VARCHAR2 1 RECURSIVE
ATRB_FLD_SET_ID NUMBER 18 DISPLAY_SEQUENCE
TM_ATRB_FLD_ID NUMBER 18 TM_ATRB_FLD_ID
ATRB_FLD_NAME VARCHAR2 240 ATRB_FLD_NAME
RELATED_INPUT_NAME VARCHAR2 30 RELATED_INPUT_NAME
MSG_SEVERITY VARCHAR2 30 MSG_SEVERITY
OUTPUT_VALUE_TYPE VARCHAR2 30 OUTPUT_VALUE_TYPE
VALUE_SET_ID NUMBER 18 Forgin key to to FND_VS_VALUE_SETS table
DISPLAY_TYPE VARCHAR2 20 DISPLAY_TYPE
DISPLAY_VALUE VARCHAR2 250 DISPLAY_VALUE
VALUE_TEXT VARCHAR2 240 VALUE_TEXT
VALUE_NUMBER NUMBER VALUE_NUMBER
VALUE_DATE DATE VALUE_DATE
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_OUTPUTS_PK Unique FUSION_TS_TX_DATA RULE_OUTPUT_ID
HWM_RULE_OUTPUTS_U1 Unique FUSION_TS_TX_DATA RULE_ID, OUTPUT_NAME

HWM_RULE_RUN_INFO_HDR

Contains the rules created for OTL Time Calculation, Time Entry and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_RUN_INFO_HDR_PK

RUN_ID

Columns

Name Datatype Length Precision Not-null Comments
RUN_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
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.
RUN_DATE_START TIMESTAMP Yes RUN_DATE_START
RUN_DATE_STOP TIMESTAMP RUN_DATE_STOP
RUN_STATUS VARCHAR2 30 RUN_STATUS
PROCESS_TIME_SEC NUMBER PROCESS_TIME_SEC
REQUEST_SOURCE VARCHAR2 80 REQUEST_SOURCE
BUILDING_BLOCK_ID NUMBER 18 BUILDING_BLOCK_ID
BUILDING_BLOCK_VERSION NUMBER 9 BUILDING_BLOCK_VERSION
RESOURCE_ID NUMBER 18 RESOURCE_ID
SUBRESOURCE_ID NUMBER 18 SUBRESOURCE_ID
RUN_EVENT_TYPE VARCHAR2 30 RUN_EVENT_TYPE
RULE_TYPE VARCHAR2 30 RULE_TYPE
RULE_SET_ID NUMBER 18 RULE_SET_ID
RULE_SET_NAME VARCHAR2 80 RULE_SET_NAME
RS_EFFECTIVE_START_DATE DATE RS_EFFECTIVE_START_DATE
RS_EFFECTIVE_END_DATE DATE RS_EFFECTIVE_END_DATE
RULE_ID NUMBER 18 RULE_ID
RULE_NAME VARCHAR2 80 Name of the Rule
RUN_DETAIL_XML CLOB RUN_DETAIL_XML
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_RUN_INFO_HDR_N1 Non Unique Default TRUNC("RUN_DATE_START")
HWM_RULE_RUN_INFO_HDR_N2 Non Unique Default TRUNC("CREATION_DATE")
HWM_RULE_RUN_INFO_HDR_PK Unique FUSION_TS_TX_DATA RUN_ID

HWM_RULE_RUN_INFO_LINE

Contains the rules created for OTL Time Calculation, Time Entry and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_RUN_INFO_LINE_PK

RUN_LINE_ID

Columns

Name Datatype Length Precision Not-null Comments
RUN_LINE_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable.
RUN_SEQ NUMBER 9 RUN_SEQ
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.
RUN_ID NUMBER 18 Yes RUN_ID
RULE_ID NUMBER 18 RULE_ID
RULE_NAME VARCHAR2 80 Name of the Rule
RULE_TYPE VARCHAR2 30 RULE_TYPE
PROCESS_TYPE VARCHAR2 30 PROCESS_TYPE
PROCESS_ID NUMBER 18 PROCESS_ID
PRS_EFFECTIVE_START_DATE DATE PRS_EFFECTIVE_START_DATE
PRS_EFFECTIVE_END_DATE DATE PRS_EFFECTIVE_END_DATE
TCAT_ID_RULE_SET NUMBER 18 TCAT_ID_RULE_SET
TCAT_ID_CONDITION NUMBER 18 TCAT_ID_CONDITION
RULE_EXCLUDED VARCHAR2 1 RULE_EXCLUDED
EXCLUDE_REASON VARCHAR2 80 EXCLUDE_REASON
EXCLUDE_COMMENT VARCHAR2 240 EXCLUDE_COMMENT
FF_LOG_DATA CLOB FF_LOG_DATA
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
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.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_RUN_INFO_LINE_N1 Non Unique Default LOWER("RULE_NAME")
HWM_RULE_RUN_INFO_LINE_N2 Non Unique Default TRUNC("CREATION_DATE")
HWM_RULE_RUN_INFO_LINE_N3 Non Unique Default RULE_ID
HWM_RULE_RUN_INFO_LINE_PK Unique FUSION_TS_TX_DATA RUN_LINE_ID

HWM_RULE_SETS_F

Contains the rule sets created for OTL Time Calculation, Time Entry, Time device, and Time Audit rules.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_SETS_F_PK

RULE_SET_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE

Columns

Name Datatype Length Precision Not-null Comments Status
RULE_SET_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable. Active
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective.
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. Active
RULE_SET_UNQ_ID NUMBER 18 Yes RULE_SET_UNQ_ID
RULE_SET_NAME VARCHAR2 80 Yes Name of Rule set
RULE_TYPE VARCHAR2 30 Yes RULE_TYPE
SORT_ENTRY_TYPE VARCHAR2 30 SORT_ENTRY_TYPE
SORT_DURATION VARCHAR2 30 SORT_DURATION
SORT_ATTRIBUTE1 VARCHAR2 30 SORT_ATTRIBUTE1
SORT_ATTRIBUTE2 VARCHAR2 30 SORT_ATTRIBUTE2
SORT_ATTRIBUTE3 VARCHAR2 30 SORT_ATTRIBUTE3
SORT_ATTRIBUTE4 VARCHAR2 30 SORT_ATTRIBUTE4
SORT_ATTRIBUTE5 VARCHAR2 30 SORT_ATTRIBUTE5
SORT_ATTRIBUTE6 VARCHAR2 30 SORT_ATTRIBUTE6
DESCRIPTION VARCHAR2 240 Description of the Rule Set (Optional) Active
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.

Indexes

Index Uniqueness Tablespace Columns Status
HWM_RULE_SETS_F_PK Unique FUSION_TS_TX_DATA RULE_SET_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE Active
HWM_RULE_SETS_F_U1 Unique FUSION_TS_TX_DATA RULE_SET_NAME, EFFECTIVE_START_DATE
HWM_RULE_SETS_F_U2 Unique FUSION_TS_TX_DATA RULE_SET_UNQ_ID

HWM_RULE_SET_MBRS

Contains members of Time Rule Set. Each row has a sequence of precessing the Rule or Rule set and Time category.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: Default

Primary Key

Name Columns

HWM_RULE_SET_MBRS_PK

RULE_SET_MBRS_ID

Columns

Name Datatype Length Precision Not-null Comments Status
RULE_SET_MBRS_ID NUMBER 18 Yes Primary Key column containing a random generated number. This column is not updateable. Active
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. Active
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
RULE_SET_ID NUMBER 18 Yes Foreign key to Ruleset Table
RULE_SET_UNQ_ID NUMBER 18 Yes Foreign key to Ruleset Table
PROCESSING_ORDER NUMBER 9 Yes The Order in which these rules, rulesets should be applied on the TBB.
TCAT_ID NUMBER 18 Time category Run Condition, which determines if this member should be applied on TBB.
MEMBER_TYPE VARCHAR2 30 Yes Lookup type - Determines if this member is a Rule, Conditional Rule or a Rule Set.
MBR_RULE_ID NUMBER 18 MBR_RULE_ID
MBR_RULE_SET_ID NUMBER 18 MBR_RULE_SET_ID
MBR_CNDL_RULE_ID NUMBER 18 MBR_CNDL_RULE_ID
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_SET_MBRS_N1 Non Unique Default MBR_RULE_ID
HWM_RULE_SET_MBRS_PK Unique FUSION_TS_TX_DATA RULE_SET_MBRS_ID
HWM_RULE_SET_MBRS_U1 Unique FUSION_TS_TX_DATA RULE_SET_UNQ_ID, PROCESSING_ORDER

HWM_RULE_TMPLTS

Specifies formula and input and output variables for use with rule instances.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RULE_TMPLTS_PK

RULE_TMPLTS_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_TMPLTS_ID NUMBER 18 Yes RULE_TMPLTS_ID
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
PROCESS_TYPE VARCHAR2 30 Yes PROCESS_TYPE
PRS_FORMULA_ID NUMBER 18 PRS_FORMULA_ID
PRS_SCRIPT_ID NUMBER 18 PRS_SCRIPT_ID
PROCESS_NAME VARCHAR2 80 PROCESS_NAME
TEMPLATE_TYPE VARCHAR2 30 Yes TEMPLATE_TYPE
TEMPLATE_NAME VARCHAR2 80 Yes NAME
CLASSIFICATION VARCHAR2 30 CLASSIFICATION
RUN_SUMMATION_LEVEL VARCHAR2 30 Yes Summation Level
RUN_TBB_LEVEL VARCHAR2 30 Yes Report Level
RULE_EXEC_TYPE VARCHAR2 30 RULE_EXEC_TYPE
RUN_EVENT_SAVE VARCHAR2 1 RUN_EVENT_SAVE
RUN_EVENT_SUB VARCHAR2 1 RUN_EVENT_SUB
RUN_EVENT_RESUB VARCHAR2 1 RUN_EVENT_RESUB
RUN_EVENT_DELETE VARCHAR2 1 RUN_EVENT_DELETE
SUPPRESS_DUP_MSGS VARCHAR2 1 Suppress Duplicate TER messages
INCLUDE_EMPTY_TC VARCHAR2 30 Process NULL timecards
SEEDED_FLAG VARCHAR2 1 Is seeded data
RULE_SUB_TYPE VARCHAR2 30 RULE_SUB_TYPE
FAST_FORMULA_EXEC_TYPE VARCHAR2 30 FAST_FORMULA_EXEC_TYPE
DFLT_ALLOCATION_ID NUMBER 18 DFLT_ALLOCATION_ID
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.
MODULE_ID VARCHAR2 32 Seed Data Framework: indicates the module that owns the row. A module is an entry in Application Taxonomy such as a Logical Business Area. When the MODULE_ID column exists and the owner of the row is not specified, then the Seed Data Framework will not extract the row as seed data.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_TMPLTS_PK Unique Default RULE_TMPLTS_ID
HWM_RULE_TMPLTS_U1 Unique Default TEMPLATE_NAME

HWM_RULE_TMPLTS_TL

Specifies formula and input and output variables for use with rule instances.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RULE_TMPLTS_TL_PK

RULE_TMPLTS_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
RULE_TMPLTS_ID NUMBER 18 Yes RULE_TMPLT_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
SOURCE_LANG VARCHAR2 4 Yes Indicates the code of the language in which the contents of the translatable columns were originally created.
DESCRIPTION VARCHAR2 300 DESCRIPTION
RT_EXPLANATION VARCHAR2 2000 RT_EXPLANATION
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.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_TMPLTS_TL_U1 Unique Default RULE_TMPLTS_ID, LANGUAGE

HWM_RULE_TMPLT_INPUTS

Stores Rule Templates Input PArameters for Formula/Script

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RULE_TMPLT_INPUTS_PK

RULE_TMPLT_INPUT_ID

Columns

Name Datatype Length Precision Not-null Comments
RULE_TMPLT_INPUT_ID NUMBER 18 Yes COLUMN1
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.
ENTERPRISE_ID NUMBER 18 Yes Standard Enterprise Identifier column for multi tenancy support
RULE_TMPLTS_ID NUMBER 18 Yes RULE_TMPLTS_ID
DISPLAY_SEQUENCE NUMBER Yes DISPLAY_SEQUENCE
INPUT_NAME VARCHAR2 30 Yes PROCESS_INPUT
USER_DEFINED_NAME VARCHAR2 80 Deprecated/ Obsolete column. Column replaced with HWM_RULE_TMPLT_INPUTS_TL .USER_DEFINED_IN_NAME
RULE_PARAMETER_TYPE VARCHAR2 30 RULE_PARAMETER_TYPE
PARM_VALUE_REQUIRED VARCHAR2 1 PARM_VALUE_REQUIRED
VALUE_SET_ID NUMBER 18 Forgin key to to FND_VS_VALUE_SETS table
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.
SGUID VARCHAR2 32 The seed global unique identifier. Oracle internal use only.
SEED_DATA_SOURCE VARCHAR2 512 Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file.

Indexes

Index Uniqueness Tablespace Columns
HWM_RULE_TMPLT_INPUTS_N20 Non Unique Default SGUID
HWM_RULE_TMPLT_INPUTS_PK Unique Default RULE_TMPLT_INPUT_ID
HWM_RULE_TMPLT_INPUTS_U1 Unique Default RULE_TMPLTS_ID, DISPLAY_SEQUENCE
HWM_RULE_TMPLT_INPUTS_U2 Unique Default RULE_TMPLTS_ID, INPUT_NAME

HWM_RULE_TMPLT_INPUTS_TL

Translatable information of an instance of the output from a rule template, for example, a return message indicating an issue with the time sent to the repository.

Details

  • Schema: FUSION

  • Object owner: HWM

  • Object type: TABLE

  • Tablespace: REFERENCE

Primary Key

Name Columns

HWM_RULE_TMPLT_INPUTS_TL_PK

RULE_TMPLT_INPUT_ID, LANGUAGE

Columns

Name Datatype Length Precision Not-null Comments
RULE_TMPLT_INPUT_ID NUMBER 18 Yes RULE_TMPLT_INPUT_ID
LANGUAGE VARCHAR2 4 Yes Indicates the code of the language into which the contents of the translatable columns are translated.
OBJECT_VERSION_NUMBER