Oracle Hrms Tables 445z25

Oracle HRMS Tables - Part1 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__HOOK_REPORTS

Used to hold HR_API__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_S_F

Holds Liability Insurance Providers 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 ed but not been ed.

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 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 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

This table contains the rules governing which phases apply to which migrations.

HR_DM_RESOLVE_PKS

This entity contains the values of the primary key for both the source and destination database for each table for use by the TUPS package.

HR_DM_SEQUENCE_DEFINITIONS

Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/ SSP/GHR/HXT/BEN applications.

HR_DM_SEQUENCE_HISTORIES

Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking.

HR_DM_SEQUENCE_RANGES

Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given Sequence and Database.

HR_DM_TABLES

This entity contains a HRMS table listing that will be processed by the data migrator.

HR_DM_TABLE_GROUPINGS

This entity holds the information for the grouping of tables.

HR_DOCUMENT_EXTRA_INFO

Documents of Record Information

HR_DOCUMENT_TYPES

Document Types for Documents od Record

HR_DOCUMENT_TYPES_TL

Translated Document Types for Documents of Record

HR_DU_COLUMN_MAPPINGS

This table holds the relationship between the column name used in the source object (e.g. the spreadsheet column) and the output target (e.g. the Data Pump parameter name).

HR_DU_DESCRIPTORS

This table holds the descriptor details for each API to be ed.

HR_DU_ERRORS

This table holds details about errors encountered during processing of a batch by any of the Data er modules.

HR_DU_MODULES

This table holds the details about each module which can be used for either input, process or output with in the data er.

HR_DU_S

This table holds the data relating to information ed from a single source file.

HR_DU__HEADERS

This table holds the details for each API to be ed.

HR_DU__LINES

This table holds the details for each item to be ed with an item spanning one or more rows

HR_EFC_ACTIONS

Contains one row for each time the EFC conversion process or delete _EFC table data process is run.

HR_EFC_CURRENCY_HISTORIES

Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU.

HR_EFC_PROCESS_COMPONENTS

Holds one row for each processing script in each conversion processing run.

HR_EFC_ROUNDING_ERRORS

Holds one row for each time a rounding error adjustment has been made.

HR_EFC_WORKERS

Holds one row for each parallel worker instance of a processing component.

HR_EFC_WORKER_AUDITS

Holds one row for each HR_EFC_WORKER row per currency code processed for update scripts only.

HR_EXCEPTION_USAGES

Identifies usage of defined exceptions to a repeating pattern.

HR_FORM_CANVASES_B

Canvas definition for configurable forms

HR_FORM_CANVASES_TL

Translated canvas definitions for configurable forms.

HR_FORM_DATA_GROUPS_B

Form data group definition for configurable forms

HR_FORM_DATA_GROUPS_TL

Translated form data group definitions for configurable forms

HR_FORM_DATA_GROUP_ITEMS

Links items with data groups for configurable forms

HR_FORM_ITEMS_B

Definition of items available for configurable forms

HR_FORM_ITEMS_TL

Translated definitions of form items for configurable forms

HR_FORM_PROPERTIES

Configurable properties for configurable forms modules

HR_FORM_TAB_PAGES_B

Definition of form tab page for configurable forms

HR_FORM_TAB_PAGES_TL

Translated definition of form tab page for configurable forms

HR_FORM_TAB_STACKED_CANVASES Definition of stacked canvas for tab pages in configurable forms HR_FORM_TEMPLATES_B

Definition of template used by configurable forms

HR_FORM_TEMPLATES_TL

Translated template definition for use in configurable forms

HR_FORM_WINDOWS_B

Definition of windows for use in configurable forms

HR_FORM_WINDOWS_TL

Translated definition of windows for configurable form

HR_H2PI_ADDRESSES

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to addresses while data is in progress.

HR_H2PI_ASSIGNMENTS

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to assignments while data is in progress.

HR_H2PI_BG_AND_GRE

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to bg_and_gre while data is in progress.

HR_H2PI_CITY_TAX_RULES

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employees city tax rules while data is in progress.

HR_H2PI_COST_ALLOCATIONS

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to cost allocations s while data is in progress.

HR_H2PI_COUNTY_TAX_RULES

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employee county tax rules while data is in progress.

HR_H2PI_DATA_FEED_HIST

This table stores information about date feed history for Oracle HR to Oracle Payroll Interface (H2PI).

HR_H2PI_ELEMENT_ENTRIES

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to element entries while data is in progress.

HR_H2PI_ELEMENT_ENTRY_VALUES HR_H2PI_ELEMENT_LINKS HR_H2PI_ELEMENT_NAMES HR_H2PI_ELEMENT_TYPES HR_H2PI_EMPLOYEES

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to employees while data is in progress.

HR_H2PI_FEDERAL_TAX_RULES HR_H2PI_HR_ORGANIZATIONS HR_H2PI_ID_MAPPING

This table stores information about ID

mapping for Oracle HR to Oracle Payroll Interface (H2PI). HR_H2PI_INPUT_VALUES HR_H2PI_LOCATIONS

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to locations while data is in progress.

HR_H2PI_MESSAGE_LINES

This table stores information about all the messages for Oracle HR to Oracle Payroll Interface (H2PI).

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 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 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 hardcode 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 Interface configuration.

HR_LAYOUTS_TL

Translation table for HR_LAYOUTS.

HR_LAYOUT_COMPONENTS

Set of Interface Components used within a configurable Self-Service layout.

HR_LAYOUT_COMP_DEFINITIONS

Definitions of the set of Interface

components that can be used within a configurable Self Service 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 Interface component.

HR_LAYOUT_COMP_QUAL_RULES

Set of rules that determine whether a Self Service 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__KEYS

keys and their associated information is stored here on the creation of entities that require keys.

HR_PUMP_DEFAULT_EXCEPTIONS

Lists API modules that do not conform to the API parameter defaulting rules.

Oracle HRMS Tables - Part3

HR_PUMP_MAPPING_PACKAGES

Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may be used by all APIs.

HR_PUMP_MODULE_PARAMETERS

Holds seeded information about API parameters for data pump code generation.

HR_PUMP_RANGES

Controls the parallelisation of the work when the data pump is running on multiprocessor platforms.

HR_PUMP_REQUESTS

Holds information on data pump concurrent requests currently running.

HR_QUESTIONNAIRES

Questionnaires used within SSHR.

HR_QUEST_ANSWERS

Answers for a questionnaire.

HR_QUEST_ANSWER_VALUES

Answer values for a questionnaire.

HR_QUEST_FIELDS

Fields of a questionnaire.

HR_SOFT_CODING_KEYFLEX

Legislation specific information for payrolls, organizations and assignments.

HR_SOURCE_FORM_TEMPLATES

Identities of templates which have been copied and the resulting copy. Helps distinguish seeded templates from copied ones.

HR_STU_EXCEPTIONS

Error conditions from the startup data process.

HR_STU_HISTORY

Versions of HRMS Startup data installed

HR_SUMMARY

HR_SUMMARY holds all data for the Generic Summary Process.

HR_SUMMARY_EFC

This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process.

HR_S_MAGNETIC_BLOCKS HR_S_MAGNETIC_RECORDS HR_S_US_CITY_GEOCODES HR_S_US_CITY_NAMES

US cities and their VERTEX geocodes, used to validate US addresses.

HR_S_US_CITY_SCHOOL_DSTS HR_S_US_CITY_TAX_INFO_F

Element definitions.

HR_S_US_COUNTY_TAX_INFO_F

Element definitions.

HR_S_US_FEDERAL_TAX_INFO_F

Element definitions.

HR_S_US_GARN_EXEMPTION_RULES_ F HR_S_US_GARN_FEE_RULES_F HR_S_US_GARN_LIMIT_RULES_F HR_S_US_STATE_TAX_INFO_F

Element definitions.

HR_S_US_ZIP_CODES

Valid zip code ranges for VERTEX cities, used to validate US addresses.

HR_S_VALID_DEPENDENT_TYPES

- Retrofitted

HR_S_WC_STATE_SURCHARGES

- Retrofitted

HR_TAB_PAGE_PROPERTIES_B

Properties of tab pages for configurable forms

HR_TAB_PAGE_PROPERTIES_TL

Translated properties of tab pages for configurable forms

HR_TEMPLATE_CANVASES_B

Definition of canvases on template for configurable forms

HR_TEMPLATE_DATA_GROUPS

Definition for data group on template for configurable forms

HR_TEMPLATE_ITEMS_B

Definition of items on template for configurable forms

HR_TEMPLATE_ITEM_CONTEXTS_B

Definition of items on a template for given context, for configurable forms

HR_TEMPLATE_ITEM_CONTEXT_PAGE Information about which tab pages item S belongs to for a specific context, on template for configurable form. HR_TEMPLATE_ITEM_TAB_PAGES

Information about which tab pages item belongs to on template for configurable form.

HR_TEMPLATE_TAB_PAGES_B

Definition of tab page for template, for configurable forms

HR_TEMPLATE_WINDOWS_B

Definition of window for a template, for configurable forms

HR_TIPS

Help components used within SSHR.

HR_WINDOW_PROPERTIES_B

Properties of windows for configurable

forms HR_WINDOW_PROPERTIES_TL

Translated properties of windows for configurable forms

HR_WIP_LOCKS

Stores context lock for a transaction

HR_WIP_TRANSACTIONS

Stores the transaction information and state

HR_WORKFLOWS

Taskflows in Oracle HRMS.

HR_WORKING_PERSON_LISTS

Holds a list of people who constitute a current list, used in the Line Manager Web pages

PER_ABSENCE_ATTENDANCES

Records of absence, or attendance for an employee.

PER_ABSENCE_ATTENDANCES_EFC

This is a copy of the PER_ABSENCE_ATTENDANCES table which is populated by the EFC (Euro as Functional Currency) process.

PER_ABSENCE_ATTENDANCE_TYPES

defined absence types.

PER_ABS_ATTENDANCE_REASONS

Valid absence reasons for an absence type.

PER_ABS_ATTENDANCE_TYPES_TL

Holds translated information for Absence Types

PER_ADDRESSES

Address information for people.

PER_ALL_ASSIGNMENTS_F

Employee and applicant assignment details.

PER_ALL_PEOPLE_F

DateTracked table holding personal information for employees, applicants

and other people. PER_ALL_POSITIONS

Dual-maintained position definition information.

PER_ALL_VACANCIES

Vacancies within a specific requisition.

PER_ANALYSIS_CRITERIA

Flexfield combination table for the personal analysis key flexfield.

PER_APPLICATIONS

Applications for employment.

PER_APPRAISALS

An appraisal is a record of an evaluation of a person by others.

PER_APPRAISAL_TEMPLATES

The heading or grouping of appraisal questions.

PER_ASSESSMENTS

The grouping of a set of assessment elements.

PER_ASSESSMENT_GROUPS

Grouping of People for 360 reviews

PER_ASSESSMENT_TYPES

The definition of an assessment template

PER_ASSIGNMENT_BUDGET_VALUES_ Budget values for an assignment. F PER_ASSIGNMENT_BUDGET_VALU_EF This is a copy of the C PER_ASSIGNMENT_BUDGET_VALUES _F table which is populated by the EFC (Euro as Functional Currency) process. PER_ASSIGNMENT_EXTRA_INFO

Extra information for an assignment.

PER_ASSIGNMENT_EXTRA_INFO_EFC

This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as

Functional Currency) process. PER_ASSIGNMENT_INFO_TYPES

Types of extra information that may be held against an assignment.

PER_ASSIGNMENT_INFO_TYPES_TL

Translated types of extra information that may be held against an assignment.

PER_ASSIGNMENT_LIST

List of assignments that a secure can access.

PER_ASSIGNMENT_STATUS_TYPES

Predefined and defined assignment status types.

PER_ASSIGNMENT_STATUS_TYPES_T L

Predefined and defined translated assignment status types.

PER_ASSIGN_PROPOSAL_ANSWERS

Web Candidate Offer Answers

PER_ASS_STATUS_TYPE_AMENDS

amendments to predefined assignment status types.

PER_ASS_STATUS_TYPE_AMENDS_TL Translated amendments to predefined assignment status types. PER_BF_BALANCE_AMOUNTS

Holds assignment level run amount and summary values for backfeed balances by payroll processing period

PER_BF_BALANCE_AMOUNTS_EFC PER_BF_BALANCE_TYPES

Types of balances that can be held

PER_BF_BALANCE_TYPES_EFC PER_BF_PAYMENT_DETAILS

Holds details of payments that have been processed by a 3rd party payroll provider, by assignment.

PER_BF_PAYMENT_DETAILS_EFC PER_BF_PAYROLL_RUNS

Payrolls processed by 3rd party payroll provider.

PER_BF_PROCESSED_ASSIGNMENTS

Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run

PER_BOOKINGS

Event booking details.

PER_BUDGETS

Definitions of HR budgets.

PER_BUDGET_ELEMENTS

Combinations of organization, grade, job, and position used to define detailed budget values.

PER_BUDGET_VALUES

Planned HR budget values for specific budget elements.

PER_BUDGET_VALUES_EFC

This is a copy of the PER_BUDGET_VALUES table which is populated by the EFC (Euro as Functional Currency) process.

PER_BUDGET_VERSIONS

Identifies specific versions of an HR budget.

PER_CAGR_APIS PER_CAGR_APIS_TL PER_CAGR_API_PARAMETERS PER_CAGR_API_PARAMETERS_TL PER_CAGR_COPY_LOG

PER_CAGR_ENTITLEMENTS PER_CAGR_ENTITLEMENT_ITEMS PER_CAGR_ENTITLEMENT_ITEMS_TL PER_CAGR_ENTITLEMENT_LINES_F PER_CAGR_ENTITLEMENT_RESULTS PER_CAGR_GRADES

The reference collectively agreed grades for a Collective Agreement.

PER_CAGR_GRADES_DEF

Collective agreement grades key flexfield combinations table.

PER_CAGR_GRADE_STRUCTURES

The valid collectively agreed grade key flexfield structures for a particular collective agreement

PER_CAGR_LOG PER_CAGR_REQUESTS PER_CAGR_RETAINED_RIGHTS PER_CALENDAR_ENTRIES

Calendar Entries

PER_CAL_ENTRY_GEO_LIST

Calendar Entry Geo Coverage Cache

PER_CAL_ENTRY_ORG_LIST

Calendar Entry Org Coverage Cache

PER_CAL_ENTRY_VALUES

Calendar Entry Values

PER_CAREER_PATHS

List of career paths for jobs.

PER_CAREER_PATH_ELEMENTS

Progression paths for specific jobs.

PER_CA_EE_REPORT_LINES PER_CHECKLIST_ITEMS

Checklist information.

PER_COBRA_COVERAGE_BENEFITS_F Details of a benefit that the employee accepts or rejects as part of their COBRA coverage. PER_COBRA_COVERAGE_PERIODS

Holds coverage periods for COBRA qualifying events.

PER_COBRA_COVERAGE_STATUSES

Tracks the status of a COBRA enrollment.

PER_COBRA_COV_ENROLLMENTS

Enrollments for people who are eligible for continued benefit coverage under COBRA.

PER_COBRA_DEPENDENTS_F

Holds employee dependents coverage for a COBRA qualifying event.

PER_COBRA_QFYING_EVENTS_F

Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc.

PER_COLLECTIVE_AGREEMENTS

Collective agreement information.

PER_COMPETENCES

A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.

PER_COMPETENCES_TL

This table is used for language translations

PER_COMPETENCE_DEFINITIONS

COMPETENCES Key flexfield combinations table

PER_COMPETENCE_ELEMENTS

A competence element is used to

record an individual competence and an evaluation rating. PER_COMPETENCE_OUTCOMES

Competence outcomes

PER_COMP_ELEMENT_OUTCOMES

The outcomes achieved towards a given Competency .

PER__EXTRA_INFO_F

Extra information for a relationship.

PER__INFO_TYPES

Types of extra information that may be held against a relationship.

PER__INFO_TYPES_TL

Translated types of extra information that may be held against a relationship.

PER__RELATIONSHIPS

s and relationship details for dependents, beneficiaries, emergency s, parents etc.

PER_CONTRACTS_F

The details of a persons contract of employment

PER_N_DATA_UPGRADE

Used to log errors / warnings during the conversion of competences to a key flex structure.

PER_DEPLOYMENT_FACTORS

A factor affecting a person's capacity to be deployed within an organization.

PER_DISABILITIES_F

Hold Disability information for one person

PER_ELECTIONS

Holds election related information.

PER_ELECTION_CANDIDATES

Holds information of Election candidates.

PER_ELECTION_CONSTITUENCYS

This table holds information related to constituencies participating in the election.

PER_EMPDIR_ASSIGNMENTS PER_EMPDIR_JOBS PER_EMPDIR_LOCATIONS PER_EMPDIR_LOCATIONS_TL PER_EMPDIR_ORGANIZATIONS PER_EMPDIR_PEOPLE PER_EMPDIR_PHONES PER_EMPDIR_POSITIONS PER_ESTABLISHMENTS

This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc.

PER_ESTABLISHMENT_ATTENDANCES A record of educational establishments that a person is currently attending or has previously attended. PER_EVENTS

Record of events such as interviews and appraisals for applicants and employees.

PER_FORM_FUNCTIONS

Navigation and person change information for the Enter Person information screens.

PER_GENERIC_REPORT_OUTPUT

Text lines for output by a generic report script, including: title, header, footer and body lines.

PER_GEN_HIERARCHY PER_GEN_HIERARCHY_NODES PER_GEN_HIERARCHY_VERSIONS PER_GEN_HIER_NODE_TYPES PER_GRADES

Grade definitions for a business group.

PER_GRADES_TL

Trnslated fields for per_grades

PER_GRADE_DEFINITIONS

Grade key flexfield combinations table.

PER_GRADE_SPINES_F

Stores the progression points for each grade scale.

PER_HEADCOUNT_PORTLET_TBL PER_HTML_TOOLKIT_REC_TYPES

Default values for the HR html toolkit.

PER_IMAGES

Images for a designated row in a designated table.

PER_INFO_TYPE_SECURITY

Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.

PER_JOBS

Jobs defined for a Business Group.

PER_JOBS_TL

Translated columns for per_jobs

PER_JOB_DEFINITIONS

Job key flexfield combinations table.

PER_JOB_EVALUATIONS

Job evaluation details for specific jobs or positions.

PER_JOB_EXTRA_INFO

Extra information for a job.

PER_JOB_GROUPS

Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.

PER_JOB_INFO_TYPES

Types of extra information that may be held against a job.

PER_JOB_REQUIREMENTS

Requirements for specific jobs or positions. For example, skills, qualifications, experience, training.

PER_JP_ADDRESS_LOOKUPS

Lookups for Japanese Addresses

PER_JP_BANK_LOOKUPS

Lookups for Japanese Bank Branches

PER_JP_POSTAL_CODES

Lookups for Japanese postal codes and districts

PER_JP_SCHOOL_LOOKUPS

Lookups for Japanese Educational Institutions

PER_KR_ADDRESSES

KR specific

PER_KR_GRADES

KR specific

PER_KR_GRADE_AMOUNT_F

KR specific

PER_KR_G_POINTS

KR specific

PER_KR_G_POINT_AMOUNT_F

KR specific

PER_LETTER_GEN_STATUSES

Associations between letter types and possible status type changes.

PER_LETTER_REQUESTS

Requests for specific types of standard letter.

PER_LETTER_REQUEST_LINES

Details of individual letter requests.

PER_LETTER_TYPES

Letter types and auto-request definitions.

PER_MASS_MOVES

High level mass move definition.

PER_MEDICAL_ASSESSMENTS

Hold Medical Assessment information for one person

PER_MM_ASSIGNMENTS

PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.

PER_MM_JOB_REQUIREMENTS

PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position.

PER_MM_POSITIONS

PER_MM_POSITIONS holds positions that were defined as part of a mass move.

PER_MM_VALID_GRADES

PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.

PER_NL_ABSENCE_ACTIONS

Dutch Specific Absence Actions

PER_NL_ABSENCE_CHANGES

Dutch Specific Absence Changes

PER_NL_ASG_SCL_UPGRADE

Records the Dutch Assignment SCL Context Information Migrated used by the Report

PER_NUMBER_GENERATION_CONTRO PER_NUMBER_GENERATION_CON LS TROLS holds the numbers that are automatically generated for a Business Group.

PER_OBJECTIVES

A target or goal which may be evaluated during an appraisal.

PER_ORGANIZATION_LIST

List of organizations that a secure can access.

PER_ORGANIZATION_STRUCTURES

Organization hierarchy names.

PER_ORG_STRUCTURE_ELEMENTS

Organization hierarchy details showing parent-child reporting relationships between organizations.

PER_ORG_STRUCTURE_VERSIONS

Version control information for specific organization hierarchies.

PER_PARENT_SPINES

Details of pay scales, (previously known as parent spines).

PER_PARTICIPANTS

A person participating in an appraisal or assessment.

PER_PAY_BASES

Definitions of specific salary bases.

PER_PAY_PROPOSALS

Salary proposals and performance review information for employee assignments.

PER_PAY_PROPOSALS_EFC

This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process.

lso

Component details of a pay proposal for an employee assignment.

PER_PAY_PROPOSAL_COMPONENT_E This is a copy of the FC PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC (Euro as Functional Currency) process.

PER_PAY_PROPOSAL_COMPONENT_E FC PER_PEOPLE_EXTRA_INFO

Extra information for a person.

PER_PEOPLE_INFO_TYPES

The table holds the definitions of extra information types that may be held against a person.

PER_PERFORMANCE_RATINGS

A single evaluation of an objective.

PER_PERFORMANCE_REVIEWS

Performance review information for employees.

PER_PERIODS_OF_PLACEMENT

Periods of placement details for a nonpayrolled worker

PER_PERIODS_OF_SERVICE

Period of service details for an employee.

PER_PERIODS_OF_SERVICE_EFC

This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process.

PER_PERSON_ANALYSES

Special information types for a person.

PER_PERSON_DLVRY_METHODS

The communication delivery method for a person.

PER_PERSON_LIST

List of people that a secure can access.

PER_PERSON_LIST_CHANGES

List of people that are to be added to current PER_PERSON_LIST.

PER_PERSON_LIST_CHG_ARCH

Archive table to hold content of PER_PERSON_LIST_CHANGES on upgrade.

PER_PERSON_TYPES

Person types visible to specific Business Groups.

PER_PERSON_TYPES_TL

Translated person types information.

PER_PERSON_TYPE_USAGES_F

Identifies the types a person may be.

PER_PHONES

PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee s.

PER_POSITION_DEFINITIONS

Combinations of segments stored in the PER_POSTIONS table.

PER_POSITION_EXTRA_INFO

Extra information for a position.

PER_POSITION_INFO_TYPES

Types of extra information that may be held against a position.

PER_POSITION_LIST

List of positions that a secure can access.

PER_POSITION_STRUCTURES

Position Hierarchy names.

PER_POS_STRUCTURE_ELEMENTS

Position hierarchy details showing parent-child reporting relationships between positions.

PER_POS_STRUCTURE_VERSIONS

Version control information for specific position hierarchies.

PER_PREVIOUS_EMPLOYERS PER_PREVIOUS_JOBS

Used to store Previous Jobs

PER_PREVIOUS_JOB_EXTRA_INFO

Previous Jobs extra info

PER_PREVIOUS_JOB_INFO_TYPES

Used to store previous job info types

PER_PREVIOUS_JOB_USAGES

Used to store previous job Usages

PER_PREV_JOB_EXTRA_INFO

Previous Jobs extra info

PER_PREV_JOB_INFO_TYPES

Used to store previous job info types

PER_PROPOSAL_CATEGORY_MEMBE RS

Web Offers profile categories of questions

PER_PROPOSAL_CATEGORY_TYPES

Generic web offer category definitions

PER_PROPOSAL_OFFER_PARAGRAPH Web Offer letter text S PER_PROPOSAL_QUESTIONS_ADV

Web Offer advanced questions

PER_PROPOSAL_QUESTION_MEMBER S

Web offer profile questions

PER_PROPOSAL_QUESTION_TYPES

Generic web offer questions

PER_PROPOSAL_TEMPLATES

- Retrofitted

PER_PTU_DFF_MAPPING_HEADERS

Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.

PER_PTU_DFF_MAPPING_LINES

Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.

PER_PTU_DFF_MIG_FAILED_PEOPLE

This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.

PER_QUALIFICATIONS

A record of educational qualification,

certificates, licenses, etc that a person holds or is acquiring. PER_QUALIFICATIONS_EFC

This is a copy of the PER_QUALIFICATIONS table which is populated by the EFC (Euro as Functional Currency) process.

PER_QUALIFICATIONS_TL

Translated qualification details.

PER_QUALIFICATION_TYPES

Maintains the list of qualiification types that can be attained.

PER_QUALIFICATION_TYPES_TL

Maintains the list of qualiification type translations

PER_QUERY_CRITERIA

Used to store criteria to build up a query

PER_QUICKPAINT_INVOCATIONS

Identifies QuickPaint report runs.

PER_QUICKPAINT_RESULT_TEXT

Text description for the result of a single QuickPaint run.

PER_RATING_LEVELS

A rating scale step is a single point on a rating scale and is used to rate competences.

PER_RATING_LEVELS_TL

A rating scale step is a single point on a rating scale and is used to rate competences.

PER_RATING_SCALES

A scale used to rate compentencies.

PER_RATING_SCALES_TL

Translated rating scale name and description.

PER_RECRUITMENT_ACTIVITIES

Recruitment activities and costs.

PER_RECRUITMENT_ACTIVITIES_EFC

This is a copy of the

PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC (Euro as Functional Currency) process. PER_RECRUITMENT_ACTIVITY_FOR

Vacancies associated with a specific recruitment activity.

PER_REQUISITIONS

Vacancy requisition details.

PER_RI_DEPENDENCIES

Dependencies among Workbench tasks

PER_RI_REQUESTS

Concurrent requests for workbench componenets

PER_RI_SETUP_SUB_TASKS

Workbench setup sub-tasks

PER_RI_SETUP_SUB_TASKS_TL

TL table for PER_RI_SETUP_SUB_TASKS

PER_RI_SETUP_TASKS

Workbench Setup Tasks

PER_RI_SETUP_TASKS_TL

TL table for PER_RI_SETUP_TASKS table

PER_RI_VIEW_REPORTS

Stores data related to view reports for HRMS

PER_RI_VIEW_REPORTS_TL

Workbench View Reports Translation Table

PER_RI_WORKBENCH_ITEMS

Workbench items

PER_RI_WORKBENCH_ITEMS_TL

Translation table for Per_ri_workbench_items

PER_ROLES

Holds the different roles that a person performs.

PER_SALARY_SURVEYS

Market salary survey information.

PER_SALARY_SURVEY_LINES

Details for market salary surveys.

PER_SALARY_SURVEY_LINES_EFC

This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC (Euro as Functional Currency) process.

PER_SALARY_SURVEY_MAPPINGS

Mapping information for a salary survey line.

PER_SCHED_COBRA_PAYMENTS

Payment schedules for benefits provided by a COBRA coverage.

PER_SECONDARY_ASS_STATUSES

Secondary assignment statuses used for information and reporting.

PER_SECURITY_ORGANIZATIONS

List of organizations to include or exclude from security list

PER_SECURITY_PROFILES

Security profile definitions to restrict access to specific HRMS records.

PER_SECURITY_S

List of s for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance.

PER_SEC_PROFILE_ASSIGNMENTS

Security profile assignments for , Responsibility and Business Group.

PER_SHARED_TYPES

Holds 'type' and 'status' information.

PER_SHARED_TYPES_TL

Translated information for shared types.

PER_SPECIAL_INFO_TYPES

Special information types available to a

Business Group. PER_SPECIAL_INFO_TYPE_USAGES

Limits usage of special information types to specific windows.

PER_SPINAL_POINTS

List of progression points in a pay scale.

PER_SPINAL_POINT_PLACEMENTS_F

Details of assignment placements to a grade step and point.

PER_SPINAL_POINT_SEPS_F

Grade steps defined in a specific grade scale and their incremental order.:\\

PER_STANDARD_HOLIDAYS

Statutory Holiday information.

PER_STARTUP_PERSON_TYPES_TL

Predefined list of translated person types.

PER_STD_HOLIDAY_ABSENCES

Records when Statutory Holidays are taken.

PER_SUBJECTS_TAKEN

Holds a record of a person's subject usages for a qualification

PER_SUBJECTS_TAKEN_TL

Translated grade_attained.

PER_SUCCESSION_PLANNING

The record of a person's proposed succession to a position.

PER_TIME_PERIODS

Time period definitions for payroll processing and HR budget calendars.

PER_TIME_PERIOD_RULES

Rules for time periods used by the system.

PER_TIME_PERIOD_SETS

Specific dates for a defined calendar.

PER_TIME_PERIOD_TYPES

Predefined list of valid period types for payroll and HR budget calendars.

PER_TIME_PERIOD_TYPES_TL

Predefined list of translated period types for payroll and HR budget calendars.

PER_US_INVAL_ADDRESSES

Temporary table used to hold invalid addresses.

PER_US_INVAL_LOCATIONS

Temporary table used to hold invalid location addresses.

PER_VALID_GRADES

Lists valid grades for jobs and positions.

PER_WORK_INCIDENTS

Holds information on Incidents that happen at work or en route to work, for example, an industrial accident

PER_WORK_INCIDENTS_EFC

This is a copy of the PER_WORK_INCIDENTS table which is populated by the EFC (Euro as Functional Currency) process.

PER_ZA_AREAS_OF_ASSESSMENT

Table to store the Areas of assessment per NQF Assessment

PER_ZA_ASSESSMENTS

Table to store the NQF Assessment info for a person

PER_ZA_EMPLOYMENT_EQUITY

Temporary table for Employment Equity Reporting

PER_ZA_FORMAL_QUALIFICATIONS

Table to store additional NQF Qualification info for a person

PER_ZA_LEARNERSHIP_AGREEMENT S

Table to store the NQF learnership agreement info between a person and

the organization PER_ZA_QUALIFICATION_TYPES

Table to link qualification types (titles) to NQF qualification types

PER_ZA_TRAINING

Table to store NQF Training info for a person

HR_PUMP_MAPPING_PACKAGES

Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may be used by all APIs.

HR_PUMP_MODULE_PARAMETERS

Holds seeded information about API parameters for data pump code generation.

HR_PUMP_RANGES

Controls the parallelisation of the work when the data pump is running on multiprocessor platforms.

HR_PUMP_REQUESTS

Holds information on data pump concurrent requests currently running.

HR_QUESTIONNAIRES

Questionnaires used within SSHR.

HR_QUEST_ANSWERS

Answers for a questionnaire.

HR_QUEST_ANSWER_VALUES

Answer values for a questionnaire.

HR_QUEST_FIELDS

Fields of a questionnaire.

HR_SOFT_CODING_KEYFLEX

Legislation specific information for payrolls, organizations and assignments.

HR_SOURCE_FORM_TEMPLATES

Identities of templates which have been

copied and the resulting copy. Helps distinguish seeded templates from copied ones. HR_STU_EXCEPTIONS

Error conditions from the startup data process.

HR_STU_HISTORY

Versions of HRMS Startup data installed

HR_SUMMARY

HR_SUMMARY holds all data for the Generic Summary Process.

HR_SUMMARY_EFC

This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process.

HR_S_MAGNETIC_BLOCKS HR_S_MAGNETIC_RECORDS HR_S_US_CITY_GEOCODES HR_S_US_CITY_NAMES

US cities and their VERTEX geocodes, used to validate US addresses.

HR_S_US_CITY_SCHOOL_DSTS HR_S_US_CITY_TAX_INFO_F

Element definitions.

HR_S_US_COUNTY_TAX_INFO_F

Element definitions.

HR_S_US_FEDERAL_TAX_INFO_F

Element definitions.

HR_S_US_GARN_EXEMPTION_RULES_ F HR_S_US_GARN_FEE_RULES_F

HR_S_US_GARN_LIMIT_RULES_F HR_S_US_STATE_TAX_INFO_F

Element definitions.

HR_S_US_ZIP_CODES

Valid zip code ranges for VERTEX cities, used to validate US addresses.

HR_S_VALID_DEPENDENT_TYPES

- Retrofitted

HR_S_WC_STATE_SURCHARGES

- Retrofitted

HR_TAB_PAGE_PROPERTIES_B

Properties of tab pages for configurable forms

HR_TAB_PAGE_PROPERTIES_TL

Translated properties of tab pages for configurable forms

HR_TEMPLATE_CANVASES_B

Definition of canvases on template for configurable forms

HR_TEMPLATE_DATA_GROUPS

Definition for data group on template for configurable forms

HR_TEMPLATE_ITEMS_B

Definition of items on template for configurable forms

HR_TEMPLATE_ITEM_CONTEXTS_B

Definition of items on a template for given context, for configurable forms

HR_TEMPLATE_ITEM_CONTEXT_PAGE Information about which tab pages item S belongs to for a specific context, on template for configurable form. HR_TEMPLATE_ITEM_TAB_PAGES

Information about which tab pages item belongs to on template for configurable form.

HR_TEMPLATE_TAB_PAGES_B

Definition of tab page for template, for configurable forms

HR_TEMPLATE_WINDOWS_B

Definition of window for a template, for configurable forms

HR_TIPS

Help components used within SSHR.

HR_WINDOW_PROPERTIES_B

Properties of windows for configurable forms

HR_WINDOW_PROPERTIES_TL

Translated properties of windows for configurable forms

HR_WIP_LOCKS

Stores context lock for a transaction

HR_WIP_TRANSACTIONS

Stores the transaction information and state

HR_WORKFLOWS

Taskflows in Oracle HRMS.

HR_WORKING_PERSON_LISTS

Holds a list of people who constitute a current list, used in the Line Manager Web pages

PER_ABSENCE_ATTENDANCES

Records of absence, or attendance for an employee.

PER_ABSENCE_ATTENDANCES_EFC

This is a copy of the PER_ABSENCE_ATTENDANCES table which is populated by the EFC (Euro as Functional Currency) process.

PER_ABSENCE_ATTENDANCE_TYPES

defined absence types.

PER_ABS_ATTENDANCE_REASONS

Valid absence reasons for an absence type.

PER_ABS_ATTENDANCE_TYPES_TL

Holds translated information for Absence Types

PER_ADDRESSES

Address information for people.

PER_ALL_ASSIGNMENTS_F

Employee and applicant assignment details.

PER_ALL_PEOPLE_F

DateTracked table holding personal information for employees, applicants and other people.

PER_ALL_POSITIONS

Dual-maintained position definition information.

PER_ALL_VACANCIES

Vacancies within a specific requisition.

PER_ANALYSIS_CRITERIA

Flexfield combination table for the personal analysis key flexfield.

PER_APPLICATIONS

Applications for employment.

PER_APPRAISALS

An appraisal is a record of an evaluation of a person by others.

PER_APPRAISAL_TEMPLATES

The heading or grouping of appraisal questions.

PER_ASSESSMENTS

The grouping of a set of assessment elements.

PER_ASSESSMENT_GROUPS

Grouping of People for 360 reviews

PER_ASSESSMENT_TYPES

The definition of an assessment template

PER_ASSIGNMENT_BUDGET_VALUES_ Budget values for an assignment. F PER_ASSIGNMENT_BUDGET_VALU_EF This is a copy of the C PER_ASSIGNMENT_BUDGET_VALUES _F table which is populated by the EFC (Euro as Functional Currency) process.

PER_ASSIGNMENT_EXTRA_INFO

Extra information for an assignment.

PER_ASSIGNMENT_EXTRA_INFO_EFC

This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.

PER_ASSIGNMENT_INFO_TYPES

Types of extra information that may be held against an assignment.

PER_ASSIGNMENT_INFO_TYPES_TL

Translated types of extra information that may be held against an assignment.

PER_ASSIGNMENT_LIST

List of assignments that a secure can access.

PER_ASSIGNMENT_STATUS_TYPES

Predefined and defined assignment status types.

PER_ASSIGNMENT_STATUS_TYPES_T L

Predefined and defined translated assignment status types.

PER_ASSIGN_PROPOSAL_ANSWERS

Web Candidate Offer Answers

PER_ASS_STATUS_TYPE_AMENDS

amendments to predefined assignment status types.

PER_ASS_STATUS_TYPE_AMENDS_TL Translated amendments to predefined assignment status types. PER_BF_BALANCE_AMOUNTS

Holds assignment level run amount and summary values for backfeed balances by payroll processing period

PER_BF_BALANCE_AMOUNTS_EFC PER_BF_BALANCE_TYPES PER_BF_BALANCE_TYPES_EFC

Types of balances that can be held

PER_BF_PAYMENT_DETAILS

Holds details of payments that have been processed by a 3rd party payroll provider, by assignment.

PER_BF_PAYMENT_DETAILS_EFC PER_BF_PAYROLL_RUNS

Payrolls processed by 3rd party payroll provider.

PER_BF_PROCESSED_ASSIGNMENTS

Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run

PER_BOOKINGS

Event booking details.

PER_BUDGETS

Definitions of HR budgets.

PER_BUDGET_ELEMENTS

Combinations of organization, grade, job, and position used to define detailed budget values.

PER_BUDGET_VALUES

Planned HR budget values for specific budget elements.

PER_BUDGET_VALUES_EFC

This is a copy of the PER_BUDGET_VALUES table which is populated by the EFC (Euro as Functional Currency) process.

PER_BUDGET_VERSIONS

Identifies specific versions of an HR budget.

PER_CAGR_APIS PER_CAGR_APIS_TL PER_CAGR_API_PARAMETERS

PER_CAGR_API_PARAMETERS_TL PER_CAGR_COPY_LOG PER_CAGR_ENTITLEMENTS PER_CAGR_ENTITLEMENT_ITEMS PER_CAGR_ENTITLEMENT_ITEMS_TL PER_CAGR_ENTITLEMENT_LINES_F PER_CAGR_ENTITLEMENT_RESULTS PER_CAGR_GRADES

The reference collectively agreed grades for a Collective Agreement.

PER_CAGR_GRADES_DEF

Collective agreement grades key flexfield combinations table.

PER_CAGR_GRADE_STRUCTURES

The valid collectively agreed grade key flexfield structures for a particular collective agreement

PER_CAGR_LOG PER_CAGR_REQUESTS PER_CAGR_RETAINED_RIGHTS PER_CALENDAR_ENTRIES

Calendar Entries

PER_CAL_ENTRY_GEO_LIST

Calendar Entry Geo Coverage Cache

PER_CAL_ENTRY_ORG_LIST

Calendar Entry Org Coverage Cache

PER_CAL_ENTRY_VALUES

Calendar Entry Values

PER_CAREER_PATHS

List of career paths for jobs.

PER_CAREER_PATH_ELEMENTS

Progression paths for specific jobs.

PER_CA_EE_REPORT_LINES PER_CHECKLIST_ITEMS

Checklist information.

PER_COBRA_COVERAGE_BENEFITS_F Details of a benefit that the employee accepts or rejects as part of their COBRA coverage. PER_COBRA_COVERAGE_PERIODS

Holds coverage periods for COBRA qualifying events.

PER_COBRA_COVERAGE_STATUSES

Tracks the status of a COBRA enrollment.

PER_COBRA_COV_ENROLLMENTS

Enrollments for people who are eligible for continued benefit coverage under COBRA.

PER_COBRA_DEPENDENTS_F

Holds employee dependents coverage for a COBRA qualifying event.

PER_COBRA_QFYING_EVENTS_F

Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc.

PER_COLLECTIVE_AGREEMENTS

Collective agreement information.

PER_COMPETENCES

A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.

PER_COMPETENCES_TL

This table is used for language translations

PER_COMPETENCE_DEFINITIONS

COMPETENCES Key flexfield combinations table

PER_COMPETENCE_ELEMENTS

A competence element is used to record an individual competence and an evaluation rating.

PER_COMPETENCE_OUTCOMES

Competence outcomes

PER_COMP_ELEMENT_OUTCOMES

The outcomes achieved towards a given Competency .

PER__EXTRA_INFO_F

Extra information for a relationship.

PER__INFO_TYPES

Types of extra information that may be held against a relationship.

PER__INFO_TYPES_TL

Translated types of extra information that may be held against a relationship.

PER__RELATIONSHIPS

s and relationship details for dependents, beneficiaries, emergency s, parents etc.

PER_CONTRACTS_F

The details of a persons contract of employment

PER_N_DATA_UPGRADE

Used to log errors / warnings during the conversion of competences to a key flex structure.

PER_DEPLOYMENT_FACTORS

A factor affecting a person's capacity to be deployed within an organization.

PER_DISABILITIES_F

Hold Disability information for one person

PER_ELECTIONS

Holds election related information.

PER_ELECTION_CANDIDATES

Holds information of Election candidates.

PER_ELECTION_CONSTITUENCYS

This table holds information related to constituencies participating in the election.

PER_EMPDIR_ASSIGNMENTS PER_EMPDIR_JOBS PER_EMPDIR_LOCATIONS PER_EMPDIR_LOCATIONS_TL PER_EMPDIR_ORGANIZATIONS PER_EMPDIR_PEOPLE PER_EMPDIR_PHONES PER_EMPDIR_POSITIONS PER_ESTABLISHMENTS

This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc.

PER_ESTABLISHMENT_ATTENDANCES A record of educational establishments that a person is currently attending or has previously attended. PER_EVENTS

Record of events such as interviews and appraisals for applicants and employees.

PER_FORM_FUNCTIONS

Navigation and person change

information for the Enter Person information screens. PER_GENERIC_REPORT_OUTPUT

Text lines for output by a generic report script, including: title, header, footer and body lines.

PER_GEN_HIERARCHY PER_GEN_HIERARCHY_NODES PER_GEN_HIERARCHY_VERSIONS PER_GEN_HIER_NODE_TYPES PER_GRADES

Grade definitions for a business group.

PER_GRADES_TL

Trnslated fields for per_grades

PER_GRADE_DEFINITIONS

Grade key flexfield combinations table.

PER_GRADE_SPINES_F

Stores the progression points for each grade scale.

PER_HEADCOUNT_PORTLET_TBL PER_HTML_TOOLKIT_REC_TYPES

Default values for the HR html toolkit.

PER_IMAGES

Images for a designated row in a designated table.

PER_INFO_TYPE_SECURITY

Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.

PER_JOBS

Jobs defined for a Business Group.

PER_JOBS_TL

Translated columns for per_jobs

PER_JOB_DEFINITIONS

Job key flexfield combinations table.

PER_JOB_EVALUATIONS

Job evaluation details for specific jobs or positions.

PER_JOB_EXTRA_INFO

Extra information for a job.

PER_JOB_GROUPS

Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.

PER_JOB_INFO_TYPES

Types of extra information that may be held against a job.

PER_JOB_REQUIREMENTS

Requirements for specific jobs or positions. For example, skills, qualifications, experience, training.

PER_JP_ADDRESS_LOOKUPS

Lookups for Japanese Addresses

PER_JP_BANK_LOOKUPS

Lookups for Japanese Bank Branches

PER_JP_POSTAL_CODES

Lookups for Japanese postal codes and districts

PER_JP_SCHOOL_LOOKUPS

Lookups for Japanese Educational Institutions

PER_KR_ADDRESSES

KR specific

PER_KR_GRADES

KR specific

PER_KR_GRADE_AMOUNT_F

KR specific

PER_KR_G_POINTS

KR specific

PER_KR_G_POINT_AMOUNT_F

KR specific

PER_LETTER_GEN_STATUSES

Associations between letter types and possible status type changes.

PER_LETTER_REQUESTS

Requests for specific types of standard letter.

PER_LETTER_REQUEST_LINES

Details of individual letter requests.

PER_LETTER_TYPES

Letter types and auto-request definitions.

PER_MASS_MOVES

High level mass move definition.

PER_MEDICAL_ASSESSMENTS

Hold Medical Assessment information for one person

PER_MM_ASSIGNMENTS

PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.

PER_MM_JOB_REQUIREMENTS

PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position.

PER_MM_POSITIONS

PER_MM_POSITIONS holds positions that were defined as part of a mass move.

PER_MM_VALID_GRADES

PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.

PER_NL_ABSENCE_ACTIONS

Dutch Specific Absence Actions

PER_NL_ABSENCE_CHANGES

Dutch Specific Absence Changes

PER_NL_ASG_SCL_UPGRADE

Records the Dutch Assignment SCL Context Information Migrated used by

the Report PER_NUMBER_GENERATION_CONTRO PER_NUMBER_GENERATION_CON LS TROLS holds the numbers that are automatically generated for a Business Group. PER_OBJECTIVES

A target or goal which may be evaluated during an appraisal.

PER_ORGANIZATION_LIST

List of organizations that a secure can access.

PER_ORGANIZATION_STRUCTURES

Organization hierarchy names.

PER_ORG_STRUCTURE_ELEMENTS

Organization hierarchy details showing parent-child reporting relationships between organizations.

PER_ORG_STRUCTURE_VERSIONS

Version control information for specific organization hierarchies.

PER_PARENT_SPINES

Details of pay scales, (previously known as parent spines).

PER_PARTICIPANTS

A person participating in an appraisal or assessment.

PER_PAY_BASES

Definitions of specific salary bases.

PER_PAY_PROPOSALS

Salary proposals and performance review information for employee assignments.

PER_PAY_PROPOSALS_EFC

This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process.

lso

Component details of a pay proposal for an employee assignment.

PER_PAY_PROPOSAL_COMPONENT_E This is a copy of the FC PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC (Euro as Functional Currency) process. PER_PAY_PROPOSAL_COMPONENT_E FC PER_PEOPLE_EXTRA_INFO

Extra information for a person.

PER_PEOPLE_INFO_TYPES

The table holds the definitions of extra information types that may be held against a person.

PER_PERFORMANCE_RATINGS

A single evaluation of an objective.

PER_PERFORMANCE_REVIEWS

Performance review information for employees.

PER_PERIODS_OF_PLACEMENT

Periods of placement details for a nonpayrolled worker

PER_PERIODS_OF_SERVICE

Period of service details for an employee.

PER_PERIODS_OF_SERVICE_EFC

This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process.

PER_PERSON_ANALYSES

Special information types for a person.

PER_PERSON_DLVRY_METHODS

The communication delivery method for a person.

PER_PERSON_LIST

List of people that a secure can

access. PER_PERSON_LIST_CHANGES

List of people that are to be added to current PER_PERSON_LIST.

PER_PERSON_LIST_CHG_ARCH

Archive table to hold content of PER_PERSON_LIST_CHANGES on upgrade.

PER_PERSON_TYPES

Person types visible to specific Business Groups.

PER_PERSON_TYPES_TL

Translated person types information.

PER_PERSON_TYPE_USAGES_F

Identifies the types a person may be.

PER_PHONES

PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee s.

PER_POSITION_DEFINITIONS

Combinations of segments stored in the PER_POSTIONS table.

PER_POSITION_EXTRA_INFO

Extra information for a position.

PER_POSITION_INFO_TYPES

Types of extra information that may be held against a position.

PER_POSITION_LIST

List of positions that a secure can access.

PER_POSITION_STRUCTURES

Position Hierarchy names.

PER_POS_STRUCTURE_ELEMENTS

Position hierarchy details showing parent-child reporting relationships between positions.

PER_POS_STRUCTURE_VERSIONS

Version control information for specific position hierarchies.

PER_PREVIOUS_EMPLOYERS PER_PREVIOUS_JOBS

Used to store Previous Jobs

PER_PREVIOUS_JOB_EXTRA_INFO

Previous Jobs extra info

PER_PREVIOUS_JOB_INFO_TYPES

Used to store previous job info types

PER_PREVIOUS_JOB_USAGES

Used to store previous job Usages

PER_PREV_JOB_EXTRA_INFO

Previous Jobs extra info

PER_PREV_JOB_INFO_TYPES

Used to store previous job info types

PER_PROPOSAL_CATEGORY_MEMBE RS

Web Offers profile categories of questions

PER_PROPOSAL_CATEGORY_TYPES

Generic web offer category definitions

PER_PROPOSAL_OFFER_PARAGRAPH Web Offer letter text S PER_PROPOSAL_QUESTIONS_ADV

Web Offer advanced questions

PER_PROPOSAL_QUESTION_MEMBER S

Web offer profile questions

PER_PROPOSAL_QUESTION_TYPES

Generic web offer questions

PER_PROPOSAL_TEMPLATES

- Retrofitted

PER_PTU_DFF_MAPPING_HEADERS

Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.

PER_PTU_DFF_MAPPING_LINES

Table for storing DFF migration mapping Information from

PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. PER_PTU_DFF_MIG_FAILED_PEOPLE

This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.

PER_QUALIFICATIONS

A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.

PER_QUALIFICATIONS_EFC

This is a copy of the PER_QUALIFICATIONS table which is populated by the EFC (Euro as Functional Currency) process.

PER_QUALIFICATIONS_TL

Translated qualification details.

PER_QUALIFICATION_TYPES

Maintains the list of qualiification types that can be attained.

PER_QUALIFICATION_TYPES_TL

Maintains the list of qualiification type translations

PER_QUERY_CRITERIA

Used to store criteria to build up a query

PER_QUICKPAINT_INVOCATIONS

Identifies QuickPaint report runs.

PER_QUICKPAINT_RESULT_TEXT

Text description for the result of a single QuickPaint run.

PER_RATING_LEVELS

A rating scale step is a single point on a rating scale and is used to rate competences.

PER_RATING_LEVELS_TL

A rating scale step is a single point on a rating scale and is used to rate competences.

PER_RATING_SCALES

A scale used to rate compentencies.

PER_RATING_SCALES_TL

Translated rating scale name and description.

PER_RECRUITMENT_ACTIVITIES

Recruitment activities and costs.

PER_RECRUITMENT_ACTIVITIES_EFC

This is a copy of the PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC (Euro as Functional Currency) process.

PER_RECRUITMENT_ACTIVITY_FOR

Vacancies associated with a specific recruitment activity.

PER_REQUISITIONS

Vacancy requisition details.

PER_RI_DEPENDENCIES

Dependencies among Workbench tasks

PER_RI_REQUESTS

Concurrent requests for workbench componenets

PER_RI_SETUP_SUB_TASKS

Workbench setup sub-tasks

PER_RI_SETUP_SUB_TASKS_TL

TL table for PER_RI_SETUP_SUB_TASKS

PER_RI_SETUP_TASKS

Workbench Setup Tasks

PER_RI_SETUP_TASKS_TL

TL table for PER_RI_SETUP_TASKS table

PER_RI_VIEW_REPORTS

Stores data related to view reports for HRMS

PER_RI_VIEW_REPORTS_TL

Workbench View Reports Translation Table

PER_RI_WORKBENCH_ITEMS

Workbench items

PER_RI_WORKBENCH_ITEMS_TL

Translation table for Per_ri_workbench_items

PER_ROLES

Holds the different roles that a person performs.

PER_SALARY_SURVEYS

Market salary survey information.

PER_SALARY_SURVEY_LINES

Details for market salary surveys.

PER_SALARY_SURVEY_LINES_EFC

This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC (Euro as Functional Currency) process.

PER_SALARY_SURVEY_MAPPINGS

Mapping information for a salary survey line.

PER_SCHED_COBRA_PAYMENTS

Payment schedules for benefits provided by a COBRA coverage.

PER_SECONDARY_ASS_STATUSES

Secondary assignment statuses used for information and reporting.

PER_SECURITY_ORGANIZATIONS

List of organizations to include or exclude from security list

PER_SECURITY_PROFILES

Security profile definitions to restrict access to specific HRMS records.

PER_SECURITY_S

List of s for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance.

PER_SEC_PROFILE_ASSIGNMENTS

Security profile assignments for , Responsibility and Business Group.

PER_SHARED_TYPES

Holds 'type' and 'status' information.

PER_SHARED_TYPES_TL

Translated information for shared types.

PER_SPECIAL_INFO_TYPES

Special information types available to a Business Group.

PER_SPECIAL_INFO_TYPE_USAGES

Limits usage of special information types to specific windows.

PER_SPINAL_POINTS

List of progression points in a pay scale.

PER_SPINAL_POINT_PLACEMENTS_F

Details of assignment placements to a grade step and point.

PER_SPINAL_POINT_SEPS_F

Grade steps defined in a specific grade scale and their incremental order.:\\

PER_STANDARD_HOLIDAYS

Statutory Holiday information.

PER_STARTUP_PERSON_TYPES_TL

Predefined list of translated person types.

PER_STD_HOLIDAY_ABSENCES

Records when Statutory Holidays are taken.

PER_SUBJECTS_TAKEN

Holds a record of a person's subject usages for a qualification

PER_SUBJECTS_TAKEN_TL

Translated grade_attained.

PER_SUCCESSION_PLANNING

The record of a person's proposed succession to a position.

PER_TIME_PERIODS

Time period definitions for payroll processing and HR budget calendars.

PER_TIME_PERIOD_RULES

Rules for time periods used by the system.

PER_TIME_PERIOD_SETS

Specific dates for a defined calendar.

PER_TIME_PERIOD_TYPES

Predefined list of valid period types for payroll and HR budget calendars.

PER_TIME_PERIOD_TYPES_TL

Predefined list of translated period types for payroll and HR budget calendars.

PER_US_INVAL_ADDRESSES

Temporary table used to hold invalid addresses.

PER_US_INVAL_LOCATIONS

Temporary table used to hold invalid location addresses.

PER_VALID_GRADES

Lists valid grades for jobs and positions.

PER_WORK_INCIDENTS

Holds information on Incidents that happen at work or en route to work, for example, an industrial accident

PER_WORK_INCIDENTS_EFC

This is a copy of the PER_WORK_INCIDENTS table which is populated by the EFC (Euro as Functional Currency) process.

PER_ZA_AREAS_OF_ASSESSMENT

Table to store the Areas of assessment per NQF Assessment

PER_ZA_ASSESSMENTS

Table to store the NQF Assessment info for a person

PER_ZA_EMPLOYMENT_EQUITY

Temporary table for Employment Equity Reporting

PER_ZA_FORMAL_QUALIFICATIONS

Table to store additional NQF Qualification info for a person

PER_ZA_LEARNERSHIP_AGREEMENT S

Table to store the NQF learnership agreement info between a person and the organization

PER_ZA_QUALIFICATION_TYPES

Table to link qualification types (titles) to NQF qualification types

PER_ZA_TRAINING

Table to store NQF Training info for a person

Oracle Payroll Tables Table Name

Table Description

PAY_ACCRUAL_BANDS

Length of service bands used in calculating accrual of paid time off.

PAY_ACCRUAL_PLANS

PTO accrual plan definitions, (Paid time

off). PAY_ACTION_CLASSIFICATIONS

Payroll Action Type classifications.

PAY_ACTION_CONTEXTS

Assignment Action Contexts.

PAY_ACTION_INFORMATION

Archived data stored by legislation

PAY_ACTION_INTERLOCKS

Assignment action interlock definitions to control rollback processing.

PAY_ACTION_PARAMETERS

Global parameters to control process execution.

PAY_ACTION_PARAMETER_GROUPS

Groups of Pay Action Parameters

PAY_ACTION_PARAMETER_VALUES

Values for the specified action parameters

PAY_AC_VENDOR_MAPPINGS

North American Table to control the mapping of internal Values to External Vendor Values

PAY_ALL_PAYROLLS_F

Payroll group definitions.

PAY_ASSIGNMENT_ACTIONS

Action or process results, showing which assignments have been processed by a specific payroll action, or process.

PAY_ASSIGNMENT_LATEST_BALANC Denormalised assignment level latest ES balances. PAY_ASSIGNMENT_LINK_USAGES_F

Intersection between PAY_ELEMENT_LINKS_F and PER_ALL_ASSIGNMENTS_F.

PAY_AU_MODULES

Defines the processes that can be executed by the generic code caller.

PAY_AU_MODULE_PARAMETERS

Defines the parameters associated with the module used in the generic code

PAY_AU_MODULE_TYPES

Defines the module types used in the generic code caller

PAY_AU_PROCESSES

This table defines the processes that can be executed by the generic code caller.

PAY_AU_PROCESS_MODULES

Defines the intersection between processes and modules used by the generic code caller.

PAY_AU_PROCESS_PARAMETERS

Defines the parameters for a process.

PAY_BACKPAY_RULES

Balances to be recalculated by a RetroPay process.

PAY_BACKPAY_SETS

Identifies backpay, or RetroPay sets.

PAY_BALANCE_ATTRIBUTES

Holds mappings between attributes and defined balances.

PAY_BALANCE_BATCH_HEADERS

Batch header information for balance batch.

PAY_BALANCE_BATCH_LINES

Individual batch lines for the balance process.

PAY_BALANCE_CATEGORIES_F

Holds seeded categories for balances.

PAY_BALANCE_CLASSIFICATIONS

Information on which element classifications feed a balance.

PAY_BALANCE_CONTEXT_VALUES

Localization balance contexts.

PAY_BALANCE_DIMENSIONS

Information allowing the summation of a balance.

PAY_BALANCE_FEEDS_F

Controls which input values can feed a balance type.

PAY_BALANCE_SETS

Allows related balances to be grouped for reporting purposes.

PAY_BALANCE_SET_

Individual of the balance set

PAY_BALANCE_TYPES

Balance information.

PAY_BALANCE_TYPES_EFC

This is a copy of the PAY_BALANCE_TYPES table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_BALANCE_TYPES_TL

Translated balance type definitions

PAY_BALANCE_VALIDATION

Balance Validity information

PAY_BAL_ATTRIBUTE_DEFAULTS

Balance attribution defaulted according to values in this table.

PAY_BAL_ATTRIBUTE_DEFINITIONS

Balance attributes help to identify which balances should be usedin which reports.

PAY_BANK_BRANCHES

Stores bank branch information to enable entry of bank details with the correct branch information (e.g. GB bank, sort code, branch).

PAY_BATCH_CONTROL_TOTALS

Holds defined control totals for the Batch Element Entry process.

PAY_BATCH_HEADERS

Header information for a Batch Element Entry batch.

PAY_BATCH_LINES

Batch lines for a Batch Element Entry batch.

PAY_CALENDARS

Details of defined budgetary calendars.

PAY_CA_EMP_FED_TAX_INFO_F

Canadian federal tax information

PAY_CA_EMP_PROV_TAX_INFO_F

Canadian provincial tax information

PAY_CA_FILE_CREATION_NUMBERS

Used by Canadian direct deposit

PAY_CA_LEGISLATION_INFO

Canadian legislation specific data

PAY_CA_PMED_S

Canadian Provincial Medical information

PAY_CE_RECONCILED_PAYMENTS

Holds reconciliation information for payments processed through Oracle Cash Management.

PAY_COIN_ANAL_ELEMENTS

Monetary unit quantities for automatic make-up of cash payments.

PAY_COMPARISON_ROWS PAY_CONSOLIDATION_SETS

Consolidation set of results of payroll processing.

PAY_COSTS

Cost details and values for run results.

PAY_COSTS_EFC

This is a copy of the PAY_COSTS table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_COST_ALLOCATIONS_F

Cost allocation details for an assignment.

PAY_COST_ALLOCATION_KEYFLEX

Cost Allocation key flexfield combinations table.

PAY_CUSTOMIZED_RESTRICTIONS

CustomForm restrictions for specific

forms. PAY_CUSTOM_RESTRICTIONS_TL

Translated data for the table PAY_CUSTOMIZED_RESTRICTIONS

PAY_DATED_TABLES

Holds details of datetracked columns

PAY_DATETRACKED_EVENTS

Stores details of events to track on HRMS Datetrack tables

PAY_DEFINED_BALANCES

Intersection between PAY_BALANCE_TYPES and PAY_BALANCE_DIMENSIONS.

PAY_DIMENSION_ROUTES

Stores balance dimension relationships.

PAY_ELEMENT_CLASSIFICATIONS

Element classifications for legislation and information needs.

PAY_ELEMENT_CLASSIFICATIONS_T L

Translated element classification definitions

PAY_ELEMENT_ENTRIES_F

Element entry list for each assignment.

PAY_ELEMENT_ENTRY_VALUES_F

Actual input values for specific element entries.

PAY_ELEMENT_ENTRY_VALUES_F_E FC

This is a copy of the PAY_ELEMENT_ENTRY_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_ELEMENT_LINKS_F

Eligibility rules for an element type.

PAY_ELEMENT_SETS

Element sets. Used to restrict payroll runs, customize windows, or as a distribution set for costs.

PAY_ELEMENT_SPAN_USAGES

PAY_ELEMENT_TEMPLATES

Element Templates

PAY_ELEMENT_TYPES_F

Element definitions.

PAY_ELEMENT_TYPES_F_EFC

This is a copy of the PAY_ELEMENT_TYPES_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_ELEMENT_TYPES_F_TL

Translated element definitions

PAY_ELEMENT_TYPE_EXTRA_INFO

Stores extra information for an element

PAY_ELEMENT_TYPE_INFO_TYPES

Types of extra information that may be held against an element.

PAY_ELEMENT_TYPE_RULES

Include and exclude rules for specific elements in an element set.

PAY_ELEMENT_TYPE_USAGES_F

Used to store elements included or excluded from a defined run type.

PAY_ELE_CLASSIFICATION_RULES

Intersection table for PAY_ELEMENT_SETS and PAY_ELEMENT_CLASSIFICATIONS.

PAY_ELE_PAYROLL_FREQ_RULES

Frequency rules for a deduction/payroll combination.

PAY_ENTRY_PROCESS_DETAILS

Internal processing details for certain element entries

PAY_EVENT_GROUPS

Provides grouping for control of event monitoring

PAY_EVENT_PROCEDURES

Code to execute if event detected.

PAY_EVENT_QUALIFIERS_F

Event Qualification definitions

PAY_EVENT_UPDATES

Process event update transactions

PAY_EVENT_VALUE_CHANGES_F

Values changes that cause an event

PAY_EXTERNAL_S

Bank details that enable payments to be made.

PAY_FILE_DETAILS

Report file details that have been saved in the system

PAY_FORMULA_RESULT_RULES_F

Rules for specific formula results.

PAY_FREQ_RULE_PERIODS

Stores frequency rule for a deduction/ payroll combination.

PAY_FR_CONTRIBUTION_USAGES

PAY_FR_CONTRIBUTION_USAGES holds the definition of statutory payroll contributions in the French legislation.

PAY_FUNCTIONAL_AREAS

Holds definitions of functional areas

PAY_FUNCTIONAL_TRIGGERS

Defines the triggers contained in a functional area

PAY_FUNCTIONAL_USAGES

Enables functional areas for specific legislations, business groups and payrolls

PAY_GB_SOY_OUTPUTS

Temporary table for GB Start of Year process outputs.

PAY_GB_TAX_CODE_INTERFACE

Interface table for the UK Start of Year process.

PAY_GB_YEAR_END_ASSIGNMENTS

Extraction table for UK End of Year processing, which holds information about assignments.

PAY_GB_YEAR_END_PAYROLLS

Payroll information for the UK EOY

process. PAY_GB_YEAR_END_VALUES

Extraction table for the UK End of Year process that holds information about the NI balances at the year end.

PAY_GL_INTERFACE

Costed details to be ed to the General Ledger

PAY_GRADE_RULES_F

Stores the values for grade or progression point rates.

PAY_GRADE_RULES_F_EFC

This is a copy of the PAY_GRADE_RULES_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_GROSSUP_BAL_EXCLUSIONS

Stores balances which will be excluded for gross up by the net to gross process

PAY_IE_PAYE_DETAILS_F

PAY_IE_PAYE_DETAILS_F holds the PAYE Tax Details for an assignment. It is a Date Tracked table.

PAY_IE_PRSI_DETAILS_F

PAY_IE_PRSI_DETAILS_F holds the PRSI Details for an assignment. It is a Date Tracked table.

PAY_IE_SOCIAL_BENEFITS_F

PAY_IE_SOCIAL_BENEFITS_F holds the social benefit details for an assignment.This is a date tracked table

PAY_IE_TAX_BODY_INTERFACE

PAY_IE_TAX_BODY_INTERFACE,Interfac e table used for ing data into PAYE tables from a flat file.

PAY_IE_TAX_ERROR

PAY_IE_TAX_ERROR,Table used to populate errors occured during ing PAYE details.

PAY_IE_TAX_HEADER_INTERFACE

PAY_IE_TAX_HEADER_INTERFACE,Inte rface table used for ing data into PAYE tables from a flat file.

PAY_IE_TAX_TRAILER_INTERFACE

PAY_IE_TAX_TRAILER_INTERFACE,Int erface table used for ing data into PAYE tables from a flat file.

PAY_INPUT_VALUES_F

Input value definitions for specific elements.

PAY_INPUT_VALUES_F_EFC

This is a copy of the PAY_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_INPUT_VALUES_F_TL

Translated input value definitions

PAY_ITERATIVE_RULES_F

Holds the processing rules of iterative elements.

PAY_JOB_WC_CODE_USAGES

Workers Compensation codes for specific job and state combinations.

PAY_JP_BANKS

This table is used for Japanese bank information.

PAY_JP_BANK_BRANCHES

This table is used for Japanese bank branch information.

PAY_JP_PRE_TAX

This table is a temporary table for Japanese legislative reports.

PAY_JP_SWOT_NUMBERS

Holds Japanese Tax Special Withholding Obligation Taxpayer Numbers.

PAY_LEGISLATION_CONTEXTS

Maps core contexts to legislative names

PAY_LEGISLATION_RULES

Legislation specific rules and structure

identifiers. PAY_LEGISLATIVE_FIELD_INFO

Controls legislative rules on individual form fields

PAY_LINK_INPUT_VALUES_F

Input value overrides for a specific element link.

PAY_LINK_INPUT_VALUES_F_EFC

This is a copy of the PAY_LINK_INPUT_VALUES_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_MAGNETIC_BLOCKS

Driving table for fixed format version of the magnetic tape process.

PAY_MAGNETIC_RECORDS

Controls the detailed formatting of the fixed format version of the magnetic tape process.

PAY_MESSAGE_LINES

Error messages from running a process.

PAY_MONETARY_UNITS

Valid denominations for currencies.

PAY_MONETARY_UNITS_TL

Translated data for the table PAY_MONETARY_UNITS_TL

PAY_MONITOR_BALANCE_RETRIEVA Monitors the source of balance retrievals LS PAY_MX_EARN_EXEMPTION_RULES_ Used to hold the Earnings exemption F rules for Mexico PAY_MX_LEGISLATION_INFO_F

Mexican legislation specific data

PAY_NET_CALCULATION_RULES

Element entry values which contribute to the net value of Paid Time Off.

PAY_NL_IZA_UPLD_STATUS

Holds the Status of the Data Records in

the Processed IZA File PAY_ORG_PAYMENT_METHODS_F

Payment methods used by a Business Group.

PAY_ORG_PAYMENT_METHODS_F_E FC

This is a copy of the PAY_ORG_PAYMENT_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_ORG_PAYMENT_METHODS_F_T L

Translated payment method information

PAY_ORG_PAY_METHOD_USAGES_F

Payment methods available to assignments on a specific payroll.

PAY_PATCH_STATUS

Used to track the application of patches.

PAY_PAYMENT_TYPES

Types of payment that can be processed by the system.

PAY_PAYMENT_TYPES_TL

Translated payment type details

PAY_PAYROLL_ACTIONS

Holds information about a payroll process.

PAY_PAYROLL_ACTIONS_EFC

This is a copy of the PAY_PAYROLL_ACTIONS table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_PAYROLL_GL_FLEX_MAPS

Payroll to GL key flexfield segment mappings.

PAY_PAYROLL_LIST

List of payrolls that a secure can access.

PAY_PEOPLE_GROUPS

People group flexfield information.

PAY_PERSONAL_PAYMENT_METHOD Personal payment method details for an S_F employee. PAY_PERSONAL_PAYMENT_METHO_ EFC

This is a copy of the PAY_PERSONAL_PAYMENT_METHODS _F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_PERSON_LATEST_BALANCES

Latest balance values for a person.

PAY_POPULATION_RANGES

PERSON_ID ranges for parallel processing.

PAY_PRE_PAYMENTS

Pre-Payment details for an assignment, including the currency, the amount and the specific payment method.

PAY_PRE_PAYMENTS_EFC

This is a copy of the PAY_PRE_PAYMENTS table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_PROCESS_EVENTS

Process event capture table.

PAY_PROCESS_GROUPS

Defines groups of processes

PAY_PROCESS_GROUP_ACTIONS

Processes within the Process Group

PAY_PSS_TRANSACTION_STEPS

Table holding (denormalised) workin-progress for Payroll Payments selfservice.

PAY_PURGE_ACTION_TYPES

Details of the processing order required to purge action types.

PAY_PURGE_ROLLUP_BALANCES

Populated during Purge. Stores details of the balance values being removed.

PAY_QUICKPAY_EXCLUSIONS

List of element entries that are to be

excluded from a QuickPay run. PAY_QUICKPAY_INCLUSIONS

List of element entries that can be included in a QuickPay run.

PAY_RATES

Definitions of pay rates, or pay scales that may be applied to grades.

PAY_RECORDED_REQUESTS

Dated process information.

PAY_REPORT_FORMAT_ITEMS_F

Individual items for the report mapping.

PAY_REPORT_FORMAT_MAPPINGS_ F

Maps a report for a given jurisdiction to the fixed format defined for the magnetic tape.

PAY_REPORT_TOTALS PAY_RESTRICTION_PARAMETERS

Restrictions to the rows retrieved by a customized form.

PAY_RESTRICTION_VALUES

The specific values to be used to customize a form.

PAY_RETRO_ASSIGNMENTS

Identifies assignment for reprocessing

PAY_RETRO_COMPONENTS PAY_RETRO_COMPONENT_USAGES PAY_RETRO_DEFINITIONS PAY_RETRO_DEFN_COMPONENTS PAY_RETRO_ENTRIES

Identifies the Entries required for reprocessing.

PAY_RETRO_NOTIF_REPORTS

Populated and used in the

RetroNotification Report PAY_ROUTE_TO_DESCR_FLEXS

Store of routes to Descriptive Flexfields

PAY_RUN_BALANCES

Store of run level balances.

PAY_RUN_RESULTS

Result of processing a single element entry.

PAY_RUN_RESULT_VALUES

Result values from processing a single element entry.

PAY_RUN_RESULT_VALUES_EFC

This is a copy of the PAY_RUN_RESULT_VALUES table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_RUN_TYPES_F

The different types of Payroll Run processing

PAY_RUN_TYPES_F_TL

Translated run type descriptions

PAY_RUN_TYPE_ORG_METHODS_F

Organisation level payment methods associated with a particular run type.

PAY_RUN_TYPE_ORG_METHODS_F_ EFC

This is a copy of the PAY_RUN_TYPE_ORG_METHODS_F table which is populated by the EFC (Euro as a Functional Currency) process.

PAY_RUN_TYPE_USAGES_F

Holds child run types where the run type parent is of type Cumulative.

PAY_SECURITY_PAYROLLS

List of payrolls and security profile access rules.

PAY_SHADOW_BALANCE_CLASSI

Element Template Shadow Balance Classifications

PAY_SHADOW_BALANCE_FEEDS

Element Template Shadow Balance Feeds

PAY_SHADOW_BALANCE_TYPES

Element Template Shadow Balance Types

PAY_SHADOW_BAL_ATTRIBUTES PAY_SHADOW_DEFINED_BALANCES

Element Template Shadow Defined Balances

PAY_SHADOW_ELEMENT_TYPES

Element Template Shadow Element Type

PAY_SHADOW_ELE_TYPE_USAGES

Element Template Shadow Element Type Usages

PAY_SHADOW_FORMULAS

Element Template Shadow Formulas

PAY_SHADOW_FORMULA_RULES

Element Template Shadow Formula Result Rules

PAY_SHADOW_GU_BAL_EXCLUSION S

Element Template Grossup Balance Exclusions

PAY_SHADOW_INPUT_VALUES

Element Template Shadow Input Values

PAY_SHADOW_ITERATIVE_RULES

Element Template Shadow Iterative Rules

PAY_SHADOW_SUB_CLASSI_RULES

Element Template Shadow SubClassification Rules

PAY_STATE_RULES

US state tax information.

PAY_STATUS_PROCESSING_RULES_ F

Assignment status rules for processing specific elements.

PAY_STAT_TRANS_AUDIT

PAY_SUB_CLASSIFICATION_RULES_ F

Rules to determine the inclusion of an element in a secondary element classification.

PAY_TAXABILITY_RULES

Taxability rules for categories of earnings and deductions.

PAY_TAXABILITY_RULES_DATES

Maintains taxability rules date-effectively, to allow for end-of-year updates.

PAY_TEMPLATE_CORE_OBJECTS

Keeps track of the core schema objects generated from an element template.

PAY_TEMPLATE_EXCLUSION_RULES

Controls the exclusion of an object from an Element Template

PAY_TEMPLATE_FF_USAGES

Allows multiple formulas to be associated with a shadow object.

PAY_TEMP_BALANCE_ADJUSTMENT S

Holds temporary data used by the balance initialization process.

PAY_TEST_CONTEXTS PAY_TEST_EXPIRY_INFO PAY_TEST_FEED_INFO PAY_TEST_PARAMETERS PAY_TEST_PARAMETER_USAGES PAY_TEST_RUNS PAY_TEST_STAGES PAY_TEST_STEPS

PAY_TEST_SUITE_USAGES PAY_TRIGGER_COMPONENTS

Stored procedures that are executed from dynamic triggers

PAY_TRIGGER_DECLARATIONS

Variables declared in dynamic triggers

PAY_TRIGGER_EVENTS

Definitions of triggers that are dynamically generated

PAY_TRIGGER_INITIALISATIONS

How dynamically generated triggers initialise their local variables

PAY_TRIGGER_PARAMETERS

Parameter mappings for dynamically generated procedure and function calls

PAY_TRIGGER_

Allows package for dynamically generated trigger to be linked to the trigger

PAY__COLUMNS

Column definitions for defined tables.

PAY__COLUMN_INSTANCES_F

Actual values for each row and column combination in a defined table.

PAY__ROWS_F

Row definitions for defined tables.

PAY__TABLES

Table definitions for defined tables.

PAY_US_ASG_REPORTING

Denormalised performance table for accessing balances.

PAY_US_CITY_GEOCODES

Holds all distinct combinations of state code, county code and city code.

PAY_US_CITY_NAMES

US cities and their VERTEX geocodes, used to validate US addresses.

PAY_US_CITY_SCHOOL_DSTS

VERTEX geocodes for school districts within a city.

PAY_US_CITY_TAX_INFO_F

Holds city tax information.

PAY_US_CONTRIBUTION_HISTORY

Contribution History stores yearly consolidated contribution data for a Person per GRE per contribution type

PAY_US_COUNTIES

US counties and their VERTEX geocodes, used to validate US addresses.

PAY_US_COUNTY_SCHOOL_DSTS

VERTEX geocodes for school districts that span counties.

PAY_US_COUNTY_TAX_INFO_F

Holds county tax information.

PAY_US_EMP_CITY_TAX_RULES_F

City level tax details for employee assignments.

PAY_US_EMP_COUNTY_TAX_RULES_ County level tax details for employee F assignments. PAY_US_EMP_FED_TAX_RULES_F

Federal level tax details for employee assignments.

PAY_US_EMP_STATE_TAX_RULES_F

State level tax details for employee assignments.

PAY_US_FEDERAL_TAX_INFO_F

Holds federal tax information.

PAY_US_GARN_ARREARS_RULES_F

Used for holding the Garnishment Arrears Rules

PAY_US_GARN_EXEMPTION_RULES_ Used for holding the Garnishment F Exemption Rules PAY_US_GARN_FEE_RULES_F

Used for holding the Garnishment Fee rules

PAY_US_GARN_LIMIT_RULES_F

Used for holding the Garnishment Limit Rules.

PAY_US_GEO_UPDATE

To keep track of changes made to the data by the geocode patch.

PAY_US_MODIFIED_GEOCODES

US cities and their VERTEX geocodes, used for showing modified geocodes.

PAY_US_RPT_TOTALS

A temporary table to be used in Payroll and Paper W2 Reports.

PAY_US_SCHOOL_DSTS_TAX_INFO_ F

The Federal Liaison Services ( FLS ) agency codes have been mapped to the School District Jurisdiction Information Codes

PAY_US_STATES

US states and their VERTEX geocodes, used to validate US addresses.

PAY_US_STATE_TAX_INFO_F

Holds the state tax information.

PAY_US_TAX_BALANCES

Tax balances used by US Payroll Tax balance reporting.

PAY_US_TAX_REPORT_BALANCES

Identifies tax balances for US Payroll Tax Summary Listing report.

PAY_US_TAX_REPORT_DIMENSIONS

Balance dimensions used by the US Payroll Tax Summary Listing report.

PAY_US_TAX_TYPES

US Tax Types used by US Payroll Tax Balance reporting.

PAY_US_ZIP_CODES

Valid zip code ranges for VERTEX cities, used to validate US addresses.

PAY_WCI_S

Workers Compensation s table.

PAY_WCI_OCCUPATIONS

Workers Compensation occupations table.

PAY_WCI_RATES

Workers Compensation rates table. NB. This table is currently used for Canadian workers compensation, but is designed to be used globally.

PAY_WC_FUNDS

Workers Compensation Funds table.

PAY_WC_RATES

Workers Compensation Rates table.

PAY_WC_STATE_SURCHARGES

Workers Compensation Surcharges table.

PAY_ZA_ACB__GEN_NOS

PAY_ZA_ACB__GEN_NOS holds the ACB generation number information needed when submitting magnetic tapes to ACB.

PAY_ZA_BRANCH_CDV_DETAILS

PAY_ZA_BRANCH_CDV_DETAILS stores Bank and Branch information used to Bank numbers.

PAY_ZA_CDV_PARAMETERS

PAY_ZA_CDV_PARAMETERS holds information needed to perform the CDV on bank numbers.

PAY_ZA_IRP5_BAL_CODES

Table holds codes for IRP5 balances

PAY_ZA_TAXREG_BAL_TEMP

Table holds balance types for specific assignments

PAY_ZA_TAX_S

PAY_ZA_TAX_S is used for the South African Tax Report.

PAY_ZA_TAX_TRACES

PAY_ZA_TAX_TRACES holds tax trace data calculated during the payroll run. Only the most recent run's data will be stored.

PAY_ZA_TEMP_BRANCH_DETAILS

PAY_ZA_TEMP_BRANCH_DETAILS is a temporary table that holds Bank and Branch information used to Bank numbers, used in the population of PAY_ZA_BRANCH_CDV_DETAILS.

PAY_ZA_TYS_PROCESSES

PAY_ZA_TYS_PROCESSES stored information about each Tax Year Start Process that was run to ensure that the process will not be run for the same payroll and tax year, and to ensure that a rollback on the process will not occur if the specific