Oracle Payroll 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_BALANCES

Denormalised assignment level latest 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 upload batch.

PAY_BALANCE_BATCH_LINES

Individual batch lines for the balance upload 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_MEMBERS

Individual members 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 account details with the correct branch information (e.g. GB bank, sort code, branch).

PAY_BATCH_CONTROL_TOTALS

Holds user 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 user 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_ACCOUNTS

Canadian Provincial Medical account 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_TL

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_EFC

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

Bank account 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 passed 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,Interface table used for uploading data into PAYE tables from a flat file.

PAY_IE_TAX_ERROR

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

PAY_IE_TAX_HEADER_INTERFACE

PAY_IE_TAX_HEADER_INTERFACE,Interface table used for uploading data into PAYE tables from a flat file.

PAY_IE_TAX_TRAILER_INTERFACE

PAY_IE_TAX_TRAILER_INTERFACE,Interface table used for uploading 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