7/7
Index
A
ABP Part-Time Percentage
Netherlands ABP Reporting
link
ABS
function
link
absence duration
writing formulas for
link
writing formulas to calculate
link
absence types
database items for
link
ADD_DAYS
function
link
ADD_MONTHS
function
link
ADD_YEARS
function
link
Additional Holiday (Hungary)
sample formula
link link
additional part-time percentages
enable percentages
link
Alias statement
format of
link
Alias statements
in formulas
link
Aliases
in formulas
link
arithmetic operators
in formulas
link
arrears management
sample formula for
link
assignment and return statements
in formulas
link
assignment set formulas
link
assignment sets
writing formulas for
link
Assignment statement
format of
link
assignment statements
in formulas
link
B
balance dimensions
in formulas
link
Base Holiday (Hungary)
sample formula
link
sample formulas
link
Benefit Uplift
link
Benefit Uplift Daily Rate Formula
link
Benefit Uplift Duration Formula
link
benefits
formula types used for
link
formulas for administration of
link
Benefits administration
writing formulas for
link
C
CAEOY_GET_FOOTNOTE_AMOUNT
link
CALC_YEARS_OF_SERVICE
link
CALCULATE_HOURS_WORKED
function
link
CALCULATE_PAYROLL_PERIODS
function
link
CALCULATE_TIME_WORKED
UK only function
link
CALL_FORMULA
function
link
Canadian only functions
CAEOY_GET_FOOTNOTE_AMOUNT
link
CALC_YEARS_OF_SERVICE
link
CHECK_AGE_UNDER18
link
CHECK_AGE_UNDER18_OR_OVER70
link
DD_CONVERT_UPPERCASE
link
GET_EMP_ADDRESS_INFO
link
GET_RATE_ID_FOR_JOB
link
GET_RATE_ID_FOR_WCB_CODE
link
GET_WCB_RATE
link
VALIDATE_GRE_DATA
link
VALIDATE_PMED_ACCOUNT_NUMBER
link
VALIDATE_USER_TABLE_COLUMN
link
VALIDATE_USER_TABLE_NAME
link
VALIDATE_WCB_ACCOUNT_NUMBER
link
VALIDATE_WCB_RATE_CODE
link
Carry Over Absence (Hungary)
link
CHECK_AGE_UNDER18
link
CHECK_AGE_UNDER18_OR_OVER70
link
CHECK_DATE_FORMAT
Japanese only function
link
CHECK_EE_EMPLOYMENT_CRITERIA
link
CHECK_EE_SAL_CRITERIA
link
CHECK_FORMAT
Japanese only function
link
CHR(n)
function
link
CLASS1A_YTD
UK only function
link
CLEAR_GLOBALS
function
link
collective agreement entitlements
writing formulas for calculating eligibility
link
collective agreements
writing formulas for calculating entitlement eligibility
link
comments
in formulas
link
compiling formulas
link
compiling multi-version formulas
link
conditions
format of
link
in formulas
link
constants
date
link
in formulas
link
numeric
link
text
link
constants and variables
in formulas
link
CONVERT
function
link
COUNT_ASSIGNMENTS
UK only function
link
D
data conversion functions
CONVERT
link
in formulas
link
INSTR
link
NUM_TO_CHAR
link
TO_DATE
link
TO_NUMBER
link
TO_TEXT
link
data type
rules for determining
link
data types
in formulas
link
database items
from element input values
link
in formulas
link link link link
list of dynamic items
link
date constants
in formulas
link
date functions
ADD_DAYS
link
ADD_MONTHS
link
ADD_YEARS
link
DAYS_BETWEEN
link
GREATEST
link
in formulas
link
LAST_DAY
link
LEAST
link
MONTHS_BETWEEN
link
NEW_TIME
link
NEXT_DAY
link
date literals
in formulas
link
DAYS_BETWEEN
function
link
DD_CONVERT_UPPERCASE
link
DEBUG
function
link
default assignment costing
writing formulas for
link
Default statement
format of
link
Default statements
in formulas
link
define global values
link
descriptive flexfields
enabling for QuickPaint
link
DIRECTOR_WEEKS
UK only function
link
dynamic database items
for descriptive flexfield segments
link
for key flexfield segments
link
for new absence types
link
for new elements
link
for new grade rates
link
for new pay scale rates
link
E
EEO employment categories
writing formulas for
link
EEO reports
writing formulas of employment categories
link
EFT payment override formula
link
element entries
validation
link
element skip rules
link
elements
database items for
link
formulas for validating entries
link
example
accrual formula (Belgium)
link
checking a user table entry
link
checking an element entry
link
editing a QuickPaint formula
link
expressions
data type of
link
in formulas
link
F
FastFormula
calling from PL/SQL
link
FastFormula Assistant
Overview
link
FLOOR
function
link
formula types
for benefits
link
for total compensation
link
formulas
link
assignment statements in
link
proration sample
link
Additional Holiday (Hungary)
link
Alias statements in
link
Aliases
link
appraisal competency line scoring, samples
link
appraisal objective line scoring, samples
link
arithmetic operators in
link
assignment and return statements
link
assignment set formulas
link
balance dimensions
link
Base Holiday (Hungary)
link
Base Holiday sample formula (Hungary)
link
Canadian legislative functions
link
Carry Over Absence (Hungary)
link
checking a user table entry
link
checking an element entry
link
comments in
link
compiling multi-version formulas
link
components
link
conditions in
link
constants and variables
link
context
link
data conversion functions in
link
data type of expressions
link
data types
link
database items in
link
database items in
link link
date functions in
link
date literals
link
Default statements in
link
EFT payment override (Netherlands)
link
enable additional part-time percentages (Netherlands)
link
errors in
link
expressions in
link
for absence duration
link
for arrears management
link
for assignment sets
link
for Benefits administration
link link
for calculating collective agreement entitlement eligibility
link
for calculating eligibility for collective agreement entitlements
link
for configuring HRMS BIS reports
link
for configuring people management templates
link
for configuring templates
link
for custom global numbering sequences
link
for custom person number generation
link
for default assignment costing
link
for EEO employment categories
link
for EEO reports
link
for element skip rules
link
for payroll calculations
link
for payroll contact
link
for payroll legislative checks
link
for proration
link
for PTO accrual plans
link link
for QuickPaint
link
for Rate By Criteria calculations
link
for rating competencies and objectives
link
for Sickness Holiday (Hungary)
link
for skip rules
link
for validating element entries and user tables
link link
functions for accrual type
link
functions in
link
functions to call
link
functions to get values from tables in
link
functions to set and get globals
link
generating the Formula Wrapper
link
global variables in
link
historic rates (UK)
link
Hungarian legislative functions
link
Input statements
link
inputs
link link
Inputs statement
link
introduction to components
link
Japanese legislative functions for
link
local variables in
link link
making formulas efficient
link
Mexican legislative functions
link
Netherlands
link
numeric functions in
link
order of statements
link
Other Additional Holiday (Hungary)
link link
payee name (Netherlands)
link
payment method (Saudi)
link
Payroll calculations
link
prorating functions for South Africa
link
proration
link
proration (UK)
link
sample formula for additional holiday (Hungary)
link
Sickness Holiday (Hungary)
link
structure
link
text functions in
link
to calculate absence duration
link
types of statement
link
UK only functions
link
using comments
link
using database items in
link
using functions in
link
using global values
link
using nested expressions in
link
variable names
link
variables in
link
wage tax subsidies (Netherlands)
link
WAS DEFAULTED condition
link
working hours (Netherlands)
link
writing and editing
link
functions
link
in formulas
link link
registering
link
functions for accrual type formulas
link
CALCULATE_PAYROLL_PERIODS
link
GET_ABSENCE
link
GET_ACCRUAL_BAND
link
GET_ASG_INACTIVE_DAYS
link
GET_ASSIGNMENT_STATUS
link
GET_CARRY_OVER
link
GET_NET_ACCRUAL
link
GET_OTHER_NET_CONTRIBUTION
link
GET_PAYROLL_PERIOD
link
GET_PERIOD_DATES
link
GET_START_DATE
link
GET_WORKING_DAYS
link
PUT_MESSAGE
link
functions to call a formula
link
CALL_FORMULA
link
LOOP_CONTROL
link
functions to get values from tables
GET_LOOKUP_ MEANING
link
GET_TABLE_VALUE
link
in formulas
link
RAISE_ERROR
link
RATES_HISTORY
link
functions to set and get globals
CLEAR_GLOBALS
link
GET_DATE
link
GET_NUMBER
link
GET_TEXT
link
in formulas
link
ISNULL
link
REMOVE_GLOBALS
link
SET_DATE
link
SET_NUMBER
link
SET_TEXT
link
G
generating the Formula Wrapper
link
GET_ABSENCES
function
link
GET_ACCRUAL_BAND
function
link
GET_ASG_INACTIVE_DAYS
function
link
GET_ASSIGNMENT_STATUS
function
link
GET_BACS_PROCESS_DATE
UK only function
link
GET_CARRY_OVER
function
link
GET_DATE
function
link
GET_EMP_ADDRESS_INFO
link
GET_FTE_VALUE
UK only function
link
GET_LAST_ASSACT
Japanese only function
link
GET_LOOKUP_ MEANING
function
link
GET_MX_TAX_INFO
link
GET_NET_ACCRUAL
function
link
GET_NUMBER
function
link
GET_OTHER_NET_CONTRIBUTION
function
link
GET_PAYROLL_PERIOD
function
link
GET_PERIOD_DATES
function
link
GET_RATE_ID_FOR_JOB
link
GET_RATE_ID_FOR_WCB_CODE
link
GET_SENIORITY
link
GET_SENIORITY_SOCIAL_SECURITY
link
GET_START_DATE
function
link
GET_SUBJECT_EARNINGS_ANN
link
GET_SUBJECT_EARNINGS_FOR_PERIOD
link
GET_TABLE_VALUE
function
link
GET_TAX_SUBSIDY_PERCENT
link
GET_TEXT
function
link
GET_WCB_RATE
link
GET_WORKING_DAYS
function
link
GET_WRIP
link
GetIDW
link
global person numbering
writing formulas for custom numbering sequences
link
global values
defining
link
in formulas
link
global variables
in formulas
link
grade rates
database items for
link
GREATEST
date function
link
numeric function
link
text function
link
H
HR:Execute Legislative Check Formula within Run
link
HRMS BIS reports
writing formulas for configuring
link
HU_ABS_GET_BLIND_DAYS
Hungarian only function
link
HU_ABS_GET_CHILD_INFO
Hungarian only function
link
HU_ABS_GET_JOB_DAYS
Hungarian only function
link
HU_ABS_GET_PREV_EMP_SICKNESS_LEAVE
Hungarian only function
link link
HU_ENTRY_IN_ACCRUAL_PLAN
Hungarian only function
link
HU_PAYROLL_PERIODS
Hungarian only function
link
HU_PERSON_DOB
Hungarian only function
link
Hungarian only functions
HU_ABS_GET_BLIND_DAYS
link
HU_ABS_GET_CHILD_INFO
link
HU_ABS_GET_JOB_DAYS
link
HU_ABS_GET_PREV_EMP_SICKNESS_LEAVE
link link
HU_ENTRY_IN_ACCRUAL_PLAN
link
HU_PAYROLL_PERIODS
link
HU_PERSON_DOB
link
Hungarian Sample Accrual Formula
link
I
If statement
format of
link
INITCAP
function
link
Input statements
in formulas
link
Input values
in Payroll formulas
link
input values
validation
link
Inputs statement
link
format of
link
INSTR
function
link link
INSTRB
function
link
IS_ASG_EXEMPT_FROM_ISR
link
ISNULL
function
link
J
Japanese only functions
CHECK_DATE_FORMAT
link
CHECK_FORMAT
link
GET_LAST_ASSACT
link
ORG_EXISTS
link
K
key flexfields
enabling for QuickPaint
link
L
LAST_DAY
function
link
LEAST
date function
link
numeric function
link
text function
link
LENGTH
function
link
LENGTHB
function
link
local variables
in formulas
link link
LOOP_CONTROL
function
link
LOWER
function
link
LPAD
function
link
LTRIM
function
link
M
Mexican only functions
CHECK_EE_EMPLOYMENT_CRITERIA
link
CHECK_EE_SAL_CRITERIA
link
GET_MX_TAX_INFO
link
GET_SENIORITY
link
GET_SENIORITY_SOCIAL_SECURITY
link
GET_SUBJECT_EARNINGS_ANN
link
GET_SUBJECT_EARNINGS_FOR_PERIOD
link
GET_TAX_SUBSIDY_PERCENT
link
GET_WRIP
link
GetIDW
link
IS_ASG_EXEMPT_FROM_ISR
link
MONTHS_BETWEEN
function
link
N
names
of variables
link
nested expressions
in formulas
link
Netherlands working hours
weekly working hours formula
link
NEW_TIME
function
link
NEXT_DAY
function
link
NI_ABLE_DIR_YTD
UK only function
link
NI_ABLE_PER_PTD
UK only function
link
NI_CO_RATE_FROM_CI_RATE
UK only function
link
NUM_TO_CHAR
function
link
numeric constants
in formulas
link
numeric functions
ABS
link
CALCULATE_HOURS_WORKED
link
FLOOR
link
GREATEST
link
in formulas
link
LEAST
link
POWER
link
ROUND
link
ROUNDUP
link
TRUNC
link
O
Oracle FastFormula
overview
link
predefined formulas
link
summary of uses
link
uses for
link
ORG_EXISTS
Japanese only function
link
Other Additional Holiday (Hungary)
link link
P
pay scale rates
database items for
link
payee name formulas
for Netherlands
link
PAYMENT_YTD
UK only function
link
Payroll
formula inputs
link
making formulas efficient
link
payroll
formula for payroll contact
link
formulas for legislative checks
link
Payroll formulas
writing for elements
link
payroll formulas
link
people management templates
writing formulas for configuring
link
PERIOD_TYPE_CHECK
UK only function
link
person numbers
writing formulas for
link
PL/SQL
calling FastFormula from
link
POWER
function
link
PQP_GB_GAP_GET_FIRST_ENTITLED_DAY
UK only function
link
PQP_GB_GAP_GET_FIRST_PAID_DAY
UK only function
link
PQP_GB_GAP_GET_LAST_ENTITLED_DAY
UK only function
link
PQP_GB_GAP_GET_LAST_PAID_DAY
UK only function
link
PQP_GB_GET_ABSENCE_SMP_FOR_DATE_RANGE
UK only function
link
PQP_GB_GET_ABSENCE_SSP_FOR_DATE_RANGE
UK only function
link
processes
Bulk Compile Formulas
link
Create Descriptive Flexfield DB Items
link
Create Key Flexfield DB Items
link
profiles
HR:Execute Legislative Check Formula within Run
link
Prorate_Calendar_Days
South Africa only function
link
Prorate_Working_Days
South Africa only function
link
proration
formulas
link link
sample formula
link
sample formulas (UK)
link
PTO accrual plans
changing plan rules (Belgium)
link
formulas for
link
sample formula (Belgium)
link
writing formulas for
link
PUT_MESSAGE
function
link
Q
Quickpaint
editing generated formulas
link
QuickPaint formula
copying and adding features to
link
QuickPaint reports
writing formulas for
link
R
RAISE_ERROR
function
link
Rate By Criteria
formulas
link
RATES_HISTORY
function
link
registering
functions
link
REMOVE_GLOBALS
function
link
REPLACE
function
link
Return statement
in formulas
link
ROUND
function
link
ROUNDUP
function
link
RPAD
function
link
RTRIM
function
link
rule types
for total compensation
link
rules
for determining variable class and data type
link
S
sample proration formula
link
Saudi sample payment method formulas
link
Separation Pension
calculations
link
SESSION_DATE
UK only function
link
SET_DATE
function
link
SET_NUMBER
function
link
SET_TEXT
function
link
Sickness Holiday (Hungary)
link link
skip rules
writing formulas for
link
South Africa only functions
Prorate_Calendar_Days
link
Prorate_Working_Days
link
statements
in formulas
link
order in formulas
link
static database items
accrual plan information
link
address detail (US/UK only)
link
applicant information
link
contact addresses
link
contact information
link
contingent worker
link
contracts information
link
date information
link
element type details
link
employee assignment information
link
employee hire information
link
Federal
link
home address details (UK only)
link
home address details (US only)
link
Human Resources Intelligence
link
list of static items
link
location details
link
payroll details
link
people addresses
link
people information
link
person types
link
recruiter information
link
supervisor information
link
work address details (UK only)
link
work address details (US only)
link
SUBSTRB
function
link
SUBSTRING
function
link
T
templates
writing formulas for
link
text constants
in formulas
link
text functions
CHR(n)
link
DEBUG
link
GREATEST
link
in formulas
link
INITCAP
link
INSTR
link
INSTRB
link
LEAST
link
LENGTH
link
LENGTHB
link
LOWER
link
LPAD
link
LTRIM
link
REPLACE
link
RPAD
link
RTRIM
link
SUBSTRB
link
SUBSTRING
link
TRANSLATE
link
TRIM
link
UPPER
link
TO_DATE
function
link
TO_NUMBER
function
link
TO_TEXT
function
link
total compensation
formula types used for
link
TRANSLATE
function
link
TRIM
function
link
TRUNC
function
link
U
UK only functions
CALCULATE_TIME_WORKED
link
CLASS1A_YTD
link
COUNT_ASSIGNMENTS
link
DIRECTOR_WEEKS
link
GET_BACS_PROCESS_DATE
link
GET_FTE_VALUE
link
NI_ABLE_DIR_YTD
link
NI_ABLE_PER_PTD
link
NI_CO_RATE_FROM_CI_RATE
link
PAYMENT_YTD
link
PERIOD_TYPE_CHECK
link
PQP_GB_GAP_GET_FIRST_ENTITLED_DAY
link
PQP_GB_GAP_GET_FIRST_PAID_DAY
link
PQP_GB_GAP_GET_LAST_ENTITLED_DAY
link
PQP_GB_GAP_GET_LAST_PAID_DAY
link
PQP_GB_GET_ABSENCE_SMP_FOR_DATE_RANGE
link
PQP_GB_GET_ABSENCE_SSP_FOR_DATE_RANGE
link
SESSION_DATE
link
UK_TAX_YR_END
link
UK_TAX_YR_START
link
USER_RANGE_BY_LABEL
link
USER_VALUE_BY_LABEL
link
VALIDATE_BACS_DATE
link
VALIDATE_USER_VALUE
link
UK_TAX_YR_END
UK only function
link
UK_TAX_YR_START
UK only function
link
UPPER
function
link
user tables
validating entries
link
USER_RANGE_BY_LABEL
UK only function
link
USER_VALUE_BY_LABEL
UK only function
link
V
VALIDATE_BACS_DATE
UK only function
link
VALIDATE_GRE_DATA
link
VALIDATE_PMED_ACCOUNT_NUMBER
link
VALIDATE_USER_TABLE_COLUMN
link
VALIDATE_USER_TABLE_NAME
link
VALIDATE_USER_VALUE
UK only function
link
VALIDATE_WCB_ACCOUNT_NUMBER
link
VALIDATE_WCB_RATE_CODE
link
validation
writing formulas for
link link
YEA information
link
variable class
rules for determining
link
variable names
in formulas
link
variables
in formulas
link
naming
link
W
wage tax subsidies
link
WAS DEFAULTED condition
link
windows
Database Items
link
Formula
link
Globals
link