Oracle HRMS Table Name
|
Table Description
|
HR_ALL_ORGANIZATION_UNITS
|
Organization unit definitions.
|
HR_ALL_ORGANIZATION_UNITS_TL
|
Translated organization unit name definitions.
|
HR_ALL_POSITIONS_F
|
Position definition information.
|
HR_ALL_POSITIONS_F_TL
|
Translation table
|
HR_API_BATCH_MESSAGE_LINES
|
Results and messages generated during batch API processing.
|
HR_API_HOOKS
|
Lists the hook points which are available in each API module.
|
HR_API_HOOK_CALLS
|
Lists which extra logic, package procedures or formula, should be called from the API hook points.
|
HR_API_MODULES
|
Holds details of the business processes and row handlers.
|
HR_API_TRANSACTIONS
|
Kiosk processes in progress
|
HR_API_TRANSACTION_STEPS
|
Kiosk workflow data rows
|
HR_API_TRANSACTION_VALUES
|
Kiosk workflow data columns and values
|
HR_API_USER_HOOK_REPORTS
|
Used to hold HR_API_USER_HOOK error information if this exists otherwise no information is held.
|
HR_ASSIGNMENT_SETS
|
Formula definitions that identify sets of assignments.
|
HR_ASSIGNMENT_SET_AMENDMENTS
|
Identifies explicit include and exclude rules for an assignment set.
|
HR_ASSIGNMENT_SET_CRITERIA
|
Identifies individual criteria in the definition of an assignment set.
|
HR_ATH_ELIGIBLE_TBLS
|
|
HR_ATH_ENROLL_TBLS
|
This table contains ODBC connectivity information for the Authoria enrolled plans table(s).
|
HR_ATH_VARIABLEMAP
|
Variable mappings table for the Authoria Integration
|
HR_AUTHORIA_MAPPINGS
|
Authoria Mapping Information
|
HR_CALENDARS
|
Dated instances of a repeating pattern.
|
HR_CALENDAR_USAGES
|
Assignments of calendars to individual entities.
|
HR_CANVAS_PROPERTIES
|
Canvas properties for configurable forms
|
HR_COMMENTS
|
Central repository for comments.
|
HR_DE_LIABILITY_PREMIUMS_F
|
Holds Liability Insurance Providers Premium rates for the Organization
|
HR_DE_ORGANIZATION_LINKS
|
Holds extra information for Organizations links with External Orgs
|
HR_DE_SOC_INS_CONTR_LVLS_F
|
Holds German Social Insurance Contibution data
|
HR_DM_APPLICATION_GROUPS
|
Data Migrator locking ladder groups for applications.
|
HR_DM_COLUMN_DEFINITIONS
|
Column definitions for sequence range management
|
HR_DM_DATABASES
|
Table containing names of all databases within database farm
|
HR_DM_DT_DELETES
|
This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information of data that has been downloaded but not been uploaded.
|
HR_DM_EXP_IMPS
|
This table holds the data from various tables in the source database that will be moved to the destination database using the transportable tablespace for upload in the destination database
|
HR_DM_GROUPS
|
This table holds information about the groupings used in the data migration process.
|
HR_DM_HIERARCHIES
|
This entity will contain the relationships between tables. The following relationship will be recorded:
|
HR_DM_LOADER_PARAMS
|
This entity contains the configuration data for the AOL loader files
|
HR_DM_LOADER_PHASE_ITEMS
|
This entity contains the migration specific configuration data for the AOL loader files.
|
HR_DM_MIGRATIONS
|
This table contains the data migration information. There is one row per migration in progress.
|
HR_DM_MIGRATION_RANGES
|
This table holds the allocated ranges for each slave process to process during each Download Application/Participant data phase of the migration.
|
HR_DM_MIGRATION_REQUESTS
|
This table holds the information about the request id of the issuing concurrent program.
|
HR_DM_PHASES
|
This table holds the information about each phase of the migration process.
|
HR_DM_PHASE_ITEMS
|
This table details the work to be undertaken for each phase of the Data Migrator.
|
HR_DM_PHASE_RULES |