Labels

2017 absence absence management Account accounting AIM aliases AME and API application application utilities lookups approval assignments ATO Australia Bank bi publisher budget business business groups CAGR candidates cartisian product case CEMLI Center Stage channels Classification competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing coverage area customization data database date DateTracked deductions define design develop DFF diagnostics document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links lists localization location management New Year obia obiee OLF onboarding oracle oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position primary key process profile programs project qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Friday, 28 November 2014

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.
Labels: , , , , , , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)