Payroll Access to HR Formula Type - Accessing HR Database Items in Payroll Fast Formulas

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:

• 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