Scribd
Upload
39 views21 pages

Fast Formula Salary Adjustments

The document outlines a formula for calculating the annual increase of Transport Allowance based on a specified percentage. It includes input parameters such as Amount, Ray value, and Percentage, and specifies the default hire date. The formula checks for a specific date to apply the percentage increase to the allowance amount.

Uploaded by

balasuk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
39 views21 pages

Fast Formula Salary Adjustments

The document outlines a formula for calculating the annual increase of Transport Allowance based on a specified percentage. It includes input parameters such as Amount, Ray value, and Percentage, and specifies the default hire date. The formula checks for a specific date to apply the percentage increase to the allowance amount.

Uploaded by

balasuk
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 21

Name: Transport Allowance FF

Type: Element Input Validation


Description: This Formula is used to increase the Transport Allowance annually by some percentage
DBI
******/
DEFAULT for PER_PERSON_ENTERPRISE_HIRE_DATE is '1900/01/01' (date)
INPUTS ARE Amount, Ray value. Percentage
1 effective = GET_CONTEXT (EFFECTIVE DATE, '1900/01/01' (date))
CHANGE CONTEXTS (DATE_EARNED = Estiv
1 percentage = Percentage/100
IF (TO_CHAR (GET_SYSDATE(), 'DD/MM/YYYY') = '17/10/+TO_CHAR (GET_SYSDATE(), 'YYYY') AND
DAYS_BETWEEN (éfestivs. PER PERS
(
Amount = ROUND (Pay_value + Ray value1 percentage, 2)
ELSE(
Pax value
)
Amount
RETURN Amount, Pay value

You might also like