Oracle Payroll table Name

Oracle Payroll table Names

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	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_RETRIEVALS	Monitors the source of balance retrievals
PAY_MX_EARN_EXEMPTION_RULES_F	Used to hold the Earnings exemption 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_EFC	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_TL	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 user can access.
PAY_PEOPLE_GROUPS	People group flexfield information.
PAY_PERSONAL_PAYMENT_METHODS_F	Personal payment method details for an 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) work-in-progress for Payroll Payments self-service.
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 re-processing.
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_EXCLUSIONS	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 Sub-Classification Rules
PAY_STATE_RULES	US state tax information.
PAY_STATUS_PROCESSING_RULES_F	Assignment status rules for processing specific elements.