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 V

>> PAY_INPUT_VALUES_F
Each defined element generally has one or multiple input segment, this DateTracked  payroll table holds the definitions of the input values associated with a specific element. Users can add or modify input values for non–legislative elements.

>> PAY_ELEMENT_ENTRIES_F
This payroll DateTracked table holds the list of element entries for each assignment. The actual values for each entry are held in PAY_ELEMENT_ENTRY_VALUES_F.


>> PAY_ELEMENT_ENTRY_VALUES_F
As mentioned above, this payroll DateTracked table holds the actual values entered for a specific element entry, (unless the element is defined with no input values). For example, the element Overtime may have an input value of Hours Worked. The number of Hours Worked by an employee in a fixed period is the entry value for that period

>> PAY_ELEMENT_LINKS_F
This DateTracked payroll table holds the eligibility rules that link elements to groups of employees. An assignment must match the eligibility criteria defined for the element link before it can have an entry of that element. Default values for the element input values can be set or overridden for each link.

Standard links indicate that an element entry, with any default values, should be created automatically when an assignment matches the eligibility criteria.
  
>> FF_FORMULAS_F
This DateTracked table that holds formula definitions, including formula text. It is a good idea to store the dump of this table on regular basis in order to keep a backup of all payroll and HR related fast formulas


No comments:

Post a Comment