Imp HR and Payroll Tables - Part IV

>> PAY_PAYMENT_TYPES

This payroll table holds details of the payment types that can be processed by the system. Used to define specific payment methods in PAY_ORG_PAYMENT_METHODS_F

>> PAY_ORG_PAYMENT_METHODS_F

This payroll table holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION

This DateTracked table holds the definitions of all payment methods used in a Business Group. It includes details of the payment type (cash, check/cheque, magnetic tape) and the source bank account.

Details of payment methods available to specific payrolls are held in PAY_ORG_PAY_METHOD_USAGES_F. Details of personal payment methods for employees are held in PAY_PERSONAL_PAYMENT_METHODS_F.

NOTE: Users must not enter information into the Developer Descriptive Flexfield columns of this table. These are reserved for the use of localization teams, for entry and maintenance of legislative or industry–specific data.

>> PAY_EXTERNAL_ACCOUNTS

This table stores bank account information to enable payments to people. It includes source account details, payment methods and destination accounts.

NOTE: This table holds information used in the Bank Details protected key flexfield. Localization teams are responsible for setting up this flexfield for use under their legislation code. Users cannot change this flexfield structure

>> PAY_ELEMENT_TYPES_F

This payroll date tracked table that holds the definitions of elements in Oracle HRMS. Elements are the units used to build all the earnings, deductions and benefits that users can give to employees.

Localization teams define primary classifications for the payroll processing of elements according to the requirements of their legislation, for example, Pre–Tax Deduction or Tax Deduction. Elements are also used to hold non–payment types of information linked to employee assignments, for example, information about assets and other equipment issued to employees for their work.

NOTE: Users must not enter information into the Developer Descriptive Flexfield columns of this table. These are reserved for the use of localization teams, for entry and maintenance of legislative or industry–specific data.

>> PAY_ELEMENT_CLASSIFICATIONS

This table holds the definitions of element classification that define groups of elements for legislation and information needs. Primary classifications are specific to a legislation and are predefined for all supported payroll legislations, for e.g. Earnings. You may not create, amend or delete primary classifications.

Secondary, or sub–classifications, are specific to a business group and may be predefined for a specific legislation. Users can create, update and delete their own secondary classifications, but may not change any that are predefined.

PREVIOUS POST || NEXT POST