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
  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