Payroll Access to HR Formula Type
Use the Payroll Access to HR formula type to call a payroll formula when your payroll formula requires an HR database item.
For example, you can use the payroll formula to return the salary amount, and then use the Payroll Access to HR formula to return a full-time equivalent (FTE) database item for a specific group of employees.
These contexts are available to all formulas of this type:
-
HR_RELATIONSHIP_ID
-
HR_TERM_ID
-
GRADE_RATE_ID
-
LEGAL_EMPLOYER_ID
-
AREA1
-
LOCATION_ID
-
HR_ASSIGNMENT_ID
-
PERSON_ID
-
JOB_ID
-
GRADE_ID
-
ADDRESS_ID
-
ADDRESS_TYPE
-
ACCRUAL_PLAN_ID
-
EFFECTIVE_DATE
-
LEGISLATIVE_DATA_GROUP_ID
-
ORGANIZATION_ID
These input variables are available to formulas of this type.
Enter Data |
Data Type |
---|---|
ACTUAL_END_DATE |
Date |
ACTUAL_START_DATE |
Date |
EFF_DATE |
Date |
END_DATE |
Date |
ENTRY_LEVEL |
Text |
HR_ASSG_ID |
Number |
HR_ASSIGN_ID |
Number |
HR_EFFECTIVE_DATE |
Date |
HR_ENTRY_LEVEL |
Text |
HR_ID |
Number |
HR_ID2 |
Number |
HR_TRM_ID |
Number |
MODE |
Text |
START_DATE |
Date |
UNIT_TYPE |
Text |
These return values are available to formulas of this type:
Return Value |
Data Type |
Description |
---|---|---|
L_SALARY |
Number |
Salary ID of employee |
L_SALARY_BASIS_CODE |
Text |
Salary basis of employee |
L_UNITS |
Number |
Number of units worked |
X_OUTPUT |
Date |
Output date |
X_OUTPUT |
Text |
Output text |
X_OUTPUT_NUMBER |
Number |
Output number |
X_OUTPUT_TEXT |
Text |
Output text |
This sample Oracle Payroll formula returns the salary amount for employees based on their full-time equivalent (FTE), which is an HR database item. Because HR database items aren’t accessible through Oracle Payroll formulas, you must create a Payroll Access to HR formula to retrieve the database item. And then call the formula that retrieves the database item from the formula that returns the salary amount.
/***************************************************************
FORMULA TYPE: Payroll Access to HR
DESCRIPTION: Retrieve FTE DBI
***************************************************************/
/* Default Statement Section */
Default for PER_ASG_FTE_VALUE is 1/
* Calculation Section */
HR_FTE = PER_ASG_FTE_VALUE
/* Return Statement Section */
Return HR_FTE
/*************************************************************
FORMULA NAME: GB Salary by FTE
FORMULA TYPE: Oracle Payroll
DESCRIPTION: Calculate the salary amount for OK employees based on their FTE.
**************************************************************/
/* Alias Statement Section */
ALIAS ANNUAL_SALARY_UK_AMOUNT_ASG_ENTRY_VALUE AS UK_ASG_SAL
/* Default Statement Section */
Default for ASG_HR_ASG_ID is 1
Default for UK_ASG_SAL is 0
Default for Salary_UK is 0
/* Calculation Section */
Salary_UK = UK_ASG_SAL
SET_INPUT('HR_ASSIGNMENT_ID', ASG_HR_ASG_ID)
EXECUTE('Call HR FTE DBI')
FTE = GET_OUTPUT('HR_FTE',1)
l_amount = round((FTE * Salary_UK),2)
Message = 'Salary Value is'||to_Char(l_Amount)
/* Return Statement Section */
RETURN l_Amount,Message