In Cloud Payroll Fast Formulas, some of the database items related to HR are not accessible. To overcome this Oracle has provided a type of formula - Payroll Access to HR Formula Type, with the help of which we can fetch the HR DBIs.
The following contexts are available to all formulas of this type:
The following 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
Input Variables
The following 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
|
Return Values
The following 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
|
Sample Formula
--------------------------
The following sample Oracle Payroll formula returns the salary amount for employees based on their full-time equivalent (FTE). The full-time equivalent is an HR database item. Since HR database items are not 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
