Search This Blog

Saturday, February 12, 2011

Oracle HRMS Tables - Part2


HR_H2PI_ORGANIZATION_CLASS

HR_H2PI_ORGANIZATION_INFO
This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to  organization info while data upload is in progress.
HR_H2PI_ORG_PAYMENT_METHODS

HR_H2PI_PATCH_STATUS

HR_H2PI_PAYMENT_METHODS

HR_H2PI_PAYROLLS

HR_H2PI_PAY_BASES

HR_H2PI_PERIODS_OF_SERVICE

HR_H2PI_SALARIES

HR_H2PI_STATE_TAX_RULES

HR_H2PI_US_CITY_NAMES

HR_H2PI_US_MODIFIED_GEOCODES
This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and  stores data related to  US midified geocodes while data upload is in progress.
HR_INCOMPATIBILITY_RULES
Incompatibility rules for navigation units.
HR_ITEM_CONTEXTS
Combinations table for the item context key flexfield ICX
HR_ITEM_PROPERTIES_B
Properties for form or template items used by configurable forms.
HR_ITEM_PROPERTIES_TL
Translatable properties of items for configurable forms
HR_JP_PARAMETERS
This table holds unique id for Japanese legislative specific data in order not to hard-code Multibyte characters in Japanese localization code objects.
HR_KI_EXT_APPLICATIONS
This table holds the details of the KI integration external applications
HR_KI_SESSIONS

HR_LAYOUTS
Information about an instance of a Self-Service User Interface configuration.
HR_LAYOUTS_TL
Translation table for HR_LAYOUTS.
HR_LAYOUT_COMPONENTS
Set of User Interface Components used within a configurable Self-Service layout.
HR_LAYOUT_COMP_DEFINITIONS
Definitions of the set of User Interface components that can be used within a configurable Self Service User Interface Layout.
HR_LAYOUT_COMP_PROMPTS
Set of prompt codes associated with a Configurable UI Layout Component
HR_LAYOUT_COMP_QUALIFIERS
Set of layout qualifiers which can be used to modify the rendering of a Self Service User Interface component.
HR_LAYOUT_COMP_QUAL_RULES
Set of rules that determine whether a Self Service User Interface component can use a particular layout qualifier.
HR_LEGISLATION_INSTALLATIONS
Status of each product/legislation combination installed
HR_LOCATIONS_ALL
Work location definitions.
HR_LOCATIONS_ALL_TL
Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO
Extra information for a location.
HR_LOCATION_INFO_TYPES
Types of extra information that may be held against a Location.
HR_NAME_FORMATS
Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by customers. Additional rows can be created.
HR_NAVIGATION_CONTEXT_RULES
Context specific rules for taskflow navigation.
HR_NAVIGATION_NODES
Taskflow node definitions.
HR_NAVIGATION_NODE_USAGES
Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
HR_NAVIGATION_PATHS
Taskflow navigation path details.
HR_NAVIGATION_PATHS_TL

HR_NAVIGATION_UNITS
Information about potential navigation options in a taskflow.
HR_NAVIGATION_UNITS_TL
Translated fields for hr_navigation_units
HR_NAV_UNIT_GLOBAL_USAGES
Global variable usage by specific navigation unit.  (Form or block).
HR_ORGANIZATION_INFORMATION
Additional attributes of an organization, dependent on class or organization information type.
HR_ORGANIZATION_INFORMATIO_EFC
This is a copy of theHR_ORGANIZATION_INFORMATION  table which is populated by the EFC (Euro as Functional Currency) process.
HR_ORG_INFORMATION_TYPES
Information types that are used to add information for an organization.
HR_ORG_INFO_TYPES_BY_CLASS
Defines organization information types for specific organization classifications.
HR_PATTERNS
A repeating time pattern, eg a work pattern, SSP qualifying pattern or a resource schedule.
HR_PATTERN_BITS
A defined period of time used to construct a pattern.
HR_PATTERN_CONSTRUCTIONS
Decomposition of a repeating pattern into its individual 'bits' of time.
HR_PATTERN_EXCEPTIONS
An exception to a repeating pattern.
HR_PATTERN_PURPOSES
Potential purpose for the parent pattern, eg 'Work Pattern', 'Resource schedule', etc.
HR_PATTERN_PURPOSE_USAGES
Valid combinations of entities and pattern purposes.
HR_PTL_SUMMARY_DATA

HR_PUMP_BATCH_EXCEPTIONS
Holds data pump processing exception (error) information.
HR_PUMP_BATCH_HEADERS
Stores information on a batch to be loaded by the data pump.
HR_PUMP_BATCH_LINES
Each rows stores the information required to make an API call. OUT-parameter values are written back after the API call.
HR_PUMP_BATCH_LINE_USER_KEYS
User keys and their associated information is stored here on the creation of entities that require user keys.
HR_PUMP_DEFAULT_EXCEPTIONS
Lists API modules that do not conform to the API parameter defaulting rules.

No comments:

Post a Comment