Oracle Payroll Tables
Written by Anil Passi   
Saturday, 20 January 2007
Please find the list of tables in Oracle Payroll upto Release 11.5.10

For details, please visit Main tables in Oracle HRMS and Oracle Payroll

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.

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_ADJUSTMENTS

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_SUPPORT

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

PAY_USER_COLUMNS

Column definitions for user defined tables.

PAY_USER_COLUMN_INSTANCES_F

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

PAY_USER_ROWS_F

Row definitions for user defined tables.

PAY_USER_TABLES

Table definitions for user 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_F

County level tax details for employee 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_F

Used for holding the Garnishment 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 user 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_ACCOUNTS

Workers Compensation Accounts 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_USER_GEN_NOS

PAY_ZA_ACB_USER_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 verify Bank account numbers.

PAY_ZA_CDV_PARAMETERS

PAY_ZA_CDV_PARAMETERS holds information needed to perform the CDV on bank account 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_REGISTERS

PAY_ZA_TAX_REGISTERS is used for the South African Tax Register 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 verify Bank account 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

 


Comments (4)add
...
written by sanjeev kulkarni , February 20, 2007
Hi
Could you confirm whether Run Type is avaiable for Saudi Arabia legislation
Regards
Sanjeev
...
written by Anil Passi , February 20, 2007
Hi Sanjeev

that table has a column for legislation_code. is there an entry for UAE in that table? If not, then you need a localization.

thanks
anil
Application programmer
written by Amy Jo , October 26, 2007
I'm trying to connect to the table that holds the PTO balances for Salaried employees. I'm doing this from inside Noetix and I'm not having any luck. Any suggestions would be appreciated. Thanks.
Can some one tell me this
written by rahulaaaaa , November 19, 2007
i shave to develop a sql query giving information

1)List of employees who are on unpaid LOA
2)Auditing address state versus tax withholding state, unemployment state and local taxes
3)Provides name and address of all teammates for mailing birthday cards
4)List of employees whose address was changed within prior two weeks
5)Provides list of all drivers for validation purposes
60List of employees by cost center code
7)Provides OT hours and wages for the month
smilies/cool.gifOMS Director to know exact number of teammates in OMS and their assignment
9)Employee Home Address, Job Title, DOH, DOB
10)Compensation Changes

any help is greatly appreciated
You must be logged in to a comment. Please register if you do not have an account yet.

busy