Oracle HRMS supplies the following tables, already defined using the Table Structure window:
This table has several commonly-used work schedules already entered in it, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday.
Example
Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off.
Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column.
Example
The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
This table has no data already in it, but is ready for your data entry. Its rows hold the shift designators Day, Eve, Night and Split, representing the normal shifts employees work, and its columns have the same headings, for entry of differentials. You can add to or change the shift designators as necessary.
To look at examples of differentials entries, suppose day shift employees receive one and one-half times their regular pay when temporarily working the evening shift, twice their regular pay for the night shift, and three times their regular pay for the split shift. You enter 1.5, 2.0 and 3.0 as the differentials for day shift workers.
Example Shift Differentials Table
| Time Period | D | E | N | S |
|---|---|---|---|---|
| Day | -- | 1.5 | 2.0 | 3.0 |
This table has no data in it when you receive your system, but is ready for your data entry. Its rows hold rate codes, and its single column holds the rate matching each code. This example holds codes for rates associated with the operation of different types of equipment:
Example Wage Rates Table
| Rate Code | Rate |
|---|---|
| FL (forklift) | 6.80 |
| A3 (crane A3) | 8.20 |
| A7 (crane A7) | 9.00 |
Wages defined as subject to the workers compensation premium are referred to as assessable wages. Each year, the workers' compensation board for each province and territory defines the maximum amount of employee wages that are deemed to be assessable. Use this table to enter the maximum assessable amount for each province or territory.
In Manitoba, health and post secondary premiums are paid by the employer. These premiums are calculated as a percentage of wages subject to PMED, as defined in taxability rules. The percentage rate used by the employer may be a flat percent, or vary based on the total amount of wages paid to all employees in the province. It may also involve an exemption. Use this table to enter the rate at which the premiums are calculated for each threshold of earnings. The thresholds are provided in a list of values. You must enter the associated rate for each threshold, including a rate of zero for any exempt earnings.
In Newfoundland, health and post secondary premiums are paid by the employer. These premiums are calculated as a percentage of wages subject to PMED as defined in taxability rules. Use this table to enter the rate at which the premiums are calculated. The thresholds are provided in a list of values. You must enter the associated rate for each threshold, including a rate of zero for any exempt earnings.
In Quebec, health premiums are paid by the employer. These premiums are calculated as a percentage of wages subject to PMED as defined in taxability rules. The percentage paid by the employer may vary based on the total amount of wages paid to all employees in the province. Use this table to enter the rate at which the premiums are to be calculated.
In Ontario, health premiums are paid by the employer. These premiums are calculated as a percentage of wages subject to PMED as defined in taxability rules. The percentage paid by the employer may vary based on the total amount of wages paid to all employees in the province. Use this table to enter the rate at which the premiums are calculated for each threshold of earnings. The thresholds are provided in a list of values. You must enter the associated rate for each threshold, including a rate of zero for any exempt earnings.
The Vacation Bank table holds the values that reflect a length of service band and the associated percentage at which the person would accumulate the vacation amount they are owed by an employer. For example, some provinces legislate that the minimum a person can accrue is 4% of their vacationable wages (as defined in the taxability rules for the province). Depending on the province, this may increase to 6% after a number of years of service. You must define each of these 'length of service' bands in the vacation bank table in order for employees to accrue the correct amount. The Default Vacation Bank table holds a value of 4% for all lengths of service. If you have different rules, you can create a new user table to hold the applicable values.
The table DK_EARNED_NOTICE_PERIOD maps the length of service against the earned notice period. For example, an employee whose length of service is six months has an earned notice period of one month. Oracle HRMS references this table to retrieve the appropriate earned notice period value for an employee assignment.
The table DK_COMPANY_MILEAGE_RATES enables you to use your own mileage rates, if they are different from the official rates. You can record the mileage rate against the mileage range.
The table FI_REGIONAL_MEMBERSHIP maps the place of residence and territory code with any of the three regional memberships, Nordic, EU, and non-EU. Oracle HRMS references this table for income tax calculation and other statutory deductions.
The table FI_EMPLOYEE_PENSION_PCT maps the percentage deduction of the employee pension insurance to the employee's age. Oracle HRMS references this table for calculating the pension insurance deduction accurately.
The table FI_EMPLOYER_UNEMP_INS_PCT maps the percentage of employer unemployment insurance against the employer's yearly income. Oracle HRMS references this table for deducting the employer's contribution towards unemployment insurance.
The table FI_COURT_ORDER_USER_TAB maps the monthly, fortnightly, weekly, and daily protected portions of an employee's income against the number of dependents an employee has. Oracle HRMS references this table for deducting the court order amount from the employee's income after excluding the protected portion.
The table FI_CAR_BENEFIT_RATES_GROUP_A contains the applicable benefit rates for cars that belong to the mobilization period between the years 2002 and 2004 (age group A). Oracle HRMS references this table to calculate the taxable value of the car benefit for cars in this age group.
The table FI_CAR_BENEFIT_RATES_GROUP_B contains the applicable benefit rates for cars that belong to the mobilization period between the years 1992 and 2001 (age group B). Oracle HRMS references this table to calculate the taxable value of the car benefit for cars in this age group.
The table FI_CAR_BENEFIT_RATES_GROUP_C_FULL contains the applicable benefit rates for cars that belong to the mobilization period prior to the year 1992 (age group C). Oracle HRMS references this table to calculate the value of the car benefit for cars in this age group.
The table FI_CAR_BENEFIT_RATES_GROUP_C_TAX contains the applicable benefit rates for cars that belong to the mobilization period prior to the year 1992 (age group C). Oracle HRMS references this table to calculate the taxable value of the car benefit for cars in this age group.
The table FI_TAX_DAY_MAPPING maps the number of tax days against the different payroll frequencies. Oracle HRMS references this table to retrieve the standard number of tax days applicable for a payroll period.
The table FI_POSTAL_CODE maps the postal codes to the corresponding Finnish and Swedish post office names. Oracle HRMS references this table to display the correct post office information.
The table PQH_FR_VALIDATIONS keeps the details regarding the validations available for a person. The Services Validation Process references this table when validating the previous services of the employee.
The table PQH_FR_VALIDATION_EVENTS keeps the details regarding the events for a particular validation. The Services Validation Process references this table to know the events history of the validation process.
The table PQH_FR_VALIDATION_PERIODS keeps the period details for a particular validation of an individual. The Services Validation Process references this table while calculating the period of service.
The table PQH_ROLE_INFO_TYPES keeps the details regarding the committee information types and is used for information purposes.
The table PQH_ROLE_EXTRA_INFO keeps the details regarding the extra information recorded against the role information types. These details are used for information purposes.
The termination reasons table FR_TERM_REASON_ADS_STATUS_CODE includes the reasons for the termination. Oracle HRMS references this information for generating the absence report.
The table FR_ABS_CATG_ADS_STATUS _CODE contains the information on the status of absence.
The table FR_ABS_CATG_ADS_ABS_CODE includes the information on absence categories provided by Oracle HRMS.
Oracle HRMS references these tables for the absence report.
Statutory information for maternity, paternity, and adoption leave duration is maintained in the seeded user defined table FR_MAP_DURATION.
The table FR_WORK_INC_ADS_ABS_CODE keeps the information on the type of work incident. Oracle HRMS references this table.
The table FR_LEGI_RATE_BANDS contains the information on the seniority of the person as of the parent absence date, the percentage rates and days to be paid at each of the rates. Oracle Payroll references this table while processing sick pay.
The table FR_LEGI_WAITING_DAYS provides information on the number of waiting days for the processing of legal guaranteed income. Oracle Payroll references this table.
The table FR_IJSS_NON_OCCUP_RATES_MAX keeps the information on the social security benefit rates for non-occupational sicknesses.
The table FR_IJSS_OCCUP_RATES_MAX keeps the information on the social security benefit rates for occupational sicknesses and social security ceiling.
Oracle Payroll references these tables while processing sick pay.
Note: There are further predefined tables supplied with Oracle HRMS for France that are used in certain statutory reports.
See: User Defined Tables
When the Mandatory Provident Fund (MPF) Board makes changes to the limits for a particular contribution, Oracle Payroll provides legislative updates that include the new limit information.
The MPF limits table, MPF_RI_LIMITS, contains the MPF upper and lower limits for each valid time period.
Oracle Payroll references this table when processing MPF contributions.
The table PQP_COMPANY_WORK_PATTERNS has several commonly-used work schedules already entered in it, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday.
Example
Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off.
Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column.
Example
The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
The EHECS Report uses predefined assignment categories for reporting purposes. The report categorizes these assignments and the EHECS_ASG_CATG_TAB table maps the assignment categories, defined in the EMP_CATG lookup to the employment types. If you define your own assignment categories, then you must map these categories to the employment types using this table.
The EHECS Report uses predefined occupation categories for reporting purposes. The report categorizes these occupations and the EHECS_CATG_TAB table maps the occupation categories, defined in the EMPLOYEE_CATG lookup to the occupations. If you define your own employee categories, you must map them to the occupations using this table.
The occupation categories defined in the lookup are:
11 Legislators and senior officials
12 Corporate managers
13 General managers
21 Physical, mathematical, and engineering science professionals
22 Life science and health professionals
23 Teaching professionals
24 Other professionals
31 Physical and engineering science associate professionals
32 Life science and health associate professionals
33 Teaching associate professionals
34 Other associate professionals
41 Office clerks
42 Customer services clerks
51 Personal and protective services workers
52 Models, salespersons, and demonstrators
61 Market-oriented skilled agricultural and fishery workers
62 Subsistence agricultural and fishery workers
71 Extraction and building trade workers
72 Metal, machinery and related trades workers
73 Precision, handicraft, printing and related trades workers
74 Other craft and related trades workers
81 Stationary-plant and related operators
82 Machine operators and assemblers
83 Drivers and mobile-plant operators
91 Sales and services elementary occupations
92 Agricultural, fishery and related labourers
93 Labourers in mining, construction, manufacturing and transport
The EHECS report categorizes the above occupations as follows:
Occupations 11, 12, 13, 21, 22, 23, 24, 31, 32, 33, 34: Managers, Professionals, and Associate Professionals
Occupations 41, 42, 51, 52: Clerical, Sales and Service Workers
Occupations 61, 62, 71, 72, 73, 74, 81, 82 83, 91, 92, 93: Production, Transport Workers, Craft & Tradespersons, and Other Manual Workers
The PRSI formula uses the following predefined tables with community flag to calculate which PRSI employee or employer deduction to use in a payroll. Community is a scheme run by the Irish Government to encourage employers to employ people for work. They are allowed certain number of people in their workforce, and in return the employer receives a reduced PRSI rate.
IE Class A Community Employee Monthly
IE Class A Community Employer Monthly
IE Class A Community Employee Weekly
IE Class A Community Employer Weekly
The PRSI formula uses the following predefined tables to calculate which PRSI employee or employer deduction to use in a payroll:
IE Class A, B, C, D, H, J, K and S Employee Monthly
IE Class A, B, C, D, H, J, K and S Employer Monthly
IE Class A, B, C, D, H, J, K and S Employee Weekly
IE Class A, B, C, D, H, J, K and S Employer Weekly
The Pension Deduction formula uses this table to calculate Personal Retirement Savings Account (PRSA) contributions. The table holds the age-related limit for tax exempted PRSA contribution that is a percentage of the employee's net relevant earnings.
The BIK Company Vehicle formula uses this table to calculate the mileage percentage for the period being processed. The column holds the annualized mileage percentage and the rows hold the lower and upper limits of mileage.
This table provides several commonly-used work schedules, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday. Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off. Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column. The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
This table provides several commonly-used work schedules, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday.
Example
Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off.
Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column.
Example
The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
The PQP_CONTRACT_TYPES table is used for IDW calculation and is a part of the historic rates infrastructure. Rows are created automatically as a part of the IDW calculation. Users would not normally see these.
The following tables store ISR credit-to-salary information for tax calculation:
ISR Credit to Salary_Week
ISR Credit to Salary_Month
The following tables store ISR tax rate information for tax calculation:
ISR Rates_Week
ISR Rates_Month
ISR Rates_Annual
The following tables store ISR tax subsidy rate information for tax calculation:
ISR Subsidy_Week
ISR Subsidy_Month
ISR Subsidy_Annual
This table has no data already in it but is ready for your data entry. It provides the means to record and track your yearly tax subsidy percentage.
This table has no data already in it but is ready for your data entry. It provides the means to record and track your yearly work risk insurance percentage.
The RU_FLEXFIELD_SEGMENT_MAPPINGS table maps the value of a key flexfield segment to the respective segment number. This table stores information about the Grade Code segment of the Grade Key Flexfield, and the Foreign Language Code and Foreign Language Name segments of the Competence Key Flexfield.
Oracle HRMS references this table to define the grade of an employee. It also uses the table to define the code and name of the foreign language in which an employee is competent.
When the CPF Board makes changes to the rates for a particular contribution, Oracle Payroll for Singapore provides legislative updates that include the new rate information.
The CPF rates tables, CPF_SCHEDULE_A to CPF_SCHEDULE_N, include the CPF rates that are payable for each employee, depending on the employee type, salary range, and age range.
Oracle Payroll references this table when processing involuntary CPF deductions.
The FWL_RATES table holds the rates that are used to calculate an employer's Foreign Workers Levy (FWL) liability. The table includes the codes that determine the type of work performed by the employee, both skilled and unskilled, and the rate payable for that type of employee, depending on whether they worked for the entire month or just part of it.
Oracle Payroll references this table when processing FWL Employer Liability deductions.
The following rate tables provide the monthly contribution rate for each community fund, depending on the employee's salary:
SG_COMM_FUND_CDAC
SG_COMM_FUND_ECF
SG_COMM_FUND_MBMF
SG_COMM_FUND_SINDA
Oracle Payroll references this table when processing involuntary Community Fund deductions.
The EXCHANGE_RATE_TYPES table includes conversion rate type information. Oracle Financials references this table.
The table PQP_COMPANY_WORK_PATTERNS has several commonly-used work schedules already entered in it, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday.
Example
Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off.
Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column.
Example
The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
The ES_CONTRACT_KEY_RELATION table maps the relationship between the contract key, status, type, subtype, and start reason. Oracle HRMS references this table for social security information.
The UAE_CITY_VALIDATION table stores the list of cities that are valid for a particular Emirate.
The UAE_AREA_VALIDATION table holds the list of areas that are valid for a particular city.
The UAE_MARITAL STATUS table stores values used to map the codes required by Dubai Naturalization and Residency Department (DNRD) to the codes in the core lookup.
This table has several commonly-used work schedules already entered in it, and you can add more. A work schedule shows the hours employees normally work each day from Monday through Sunday.
Example
Employees with the schedule 10-10-10-10-0-0-0 work 10 hours each day Monday through Thursday, and have Friday, Saturday and Sunday off.
Each column in this table holds a separate schedule, with each row holding the hours worked each day of the week for the schedule. For convenience, each column header names the schedule held in the column.
Example
The header for the column holding the first schedule is 1 Schedule: 8-8-8-8-8-0-0.
For use in Oracle Payroll, this table holds the cost of Group Term Life insurance premiums per $1,000 of coverage by age range, as maintained in the IRS Uniform Premiums table. The table rows hold age ranges, and its single column holds the premium for each $1,000 of coverage for each age range.
Oracle provides you with updates to the GTL Premiums table, which your system administrator applies.
The predefined imputed earnings GTL Imputed Income references this table in its processing.
This table has no data already in it, but is ready for your data entry. Its rows hold the shift designators Day, Eve, Night and Split, representing the normal shifts employees work, and its columns have the same headings, for entry of differentials. You can add to or change the shift designators as necessary.
To look at examples of differentials entries, suppose day shift employees receive one and one-half times their regular pay when temporarily working the evening shift, twice their regular pay for the night shift, and three times their regular pay for the split shift. You enter 1.5, 2.0 and 3.0 as the differentials for day shift workers.
Example Shift Differentials Table
| Time Period | D | E | N | S |
|---|---|---|---|---|
| Day | -- | 1.5 | 2.0 | 3.0 |
The predefined earnings types Regular Wages and Shift Pay reference this table in their processing in Oracle Payroll.
This table has no data in it when you receive your system, but is ready for your data entry. Its rows hold rate codes, and its single column holds the rate matching each code. This example holds codes for rates associated with the operation of different types of equipment:
Example Wage Rates Table
| Rate Code | Rate |
|---|---|
| FL (forklift) | 6.80 |
| A3 (crane A3) | 8.20 |
| A7 (crane A7) | 9.00 |
Oracle Payroll's predefined earnings types Regular Wages, Overtime, and Shift Pay reference this table in their processing.