Fast Formula Reference Guide - Ora-fusion-apps.custhelp
Oracle Fusion HCM Global AbsencesFast Formula Reference GuideLast Update Date: July 18, 2014Page 1
Table of ContentsOracle Fusion HCM Global Absences . 1Fast Formula Reference Guide. 1Table of Contents . 2Global Absence Accrual . 3Global Absence Proration . 9Global Absence Vesting Period . 11Global Absence Carryover. 12Global Absence Carryover Proration . 13Global Absence Accrual Matrix . 18Global Absence Plan Enrollment Start . 24Global Absence Plan Entitlement Start . 26Global Absence Plan Enrollment End. 27Global Absence Entitlement End Date . 28Global Absence Plan Period Anniversary Event Date . 30Global Absence Plan Use Rate . 31Global Absence Partial Accrual Period Rate . 40Global Absence Type Duration . 42Global Absence Plan Duration . 44Global Absence Entry Validation. 46Contexts . 50Extract Database Items . 61Page 2
Global Absence AccrualContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F. Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariableUse predefined names for return variables. The following return variables are available toformulas of this type.Return ValueaccrualceilingcarryOverprorationFactorData TypeNumberNumberNumberNumberPage 3
rationNumberTextNumberNumberSample ************************FORMULA NAME: Absence Accrual FormulaFORMULA TYPE: Global Absence AccrualDESCRIPTION: This sample formula applies the Accrual, Ceiling, CarryOver,Proration Factor,Vesting Units, Vesting UOM, CarryOver Proration and Ceiling Prorationbased on Length of Service and Accrual Plan the person enrolled into.Change ***//* DATABASE ITEM DEFAULTS BEGIN */DEFAULT for PER ASG REL ORIGINAL DATE OF HIRE is '4712/12/31 00:00:00'(date)DEFAULT for ANC ABS PLN NAME is 'A'DEFAULT for ANC ABS PLN PLAN UOM is 'H'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN */l no of days DAYS BETWEEN(GET CONTEXT(EFFECTIVE DATE,'4712/12/3100:00:00' (date)),PER ASG REL ORIGINAL DATE OF HIRE)l length of service (l no of days/365)/* check if employee enrolled into this plan or not */if (ANC ABS PLN NAME 'BM US ABSENCE ACCRUAL PLAN')then(if(ANC ABS PLN PLAN UOM 'H')then(if(l length of service 3)then(accrual 10ceiling 100carryover 50prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25Page 4
ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))then (accrual 12ceiling 120carryover 60prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual 15ceiling 150carryover 75prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25))else if (ANC ABS PLN PLAN UOM 'D')then(if (l length of service 3)then(accrual round(10/24,3)ceiling round(100/24,3)carryover round(50/24,3)prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))then (accrual round(12/24,3)ceiling round(120/24,3)carryover round(60/24,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'Page 5
carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual round(15/24,3)ceiling round(150/24,3)carryover round(75/24,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25))else if (ANC ABS PLN PLAN UOM 'W')then(if (l length of service 3)then(accrual round(10/120,3)ceiling round(100/120,3)carryover round(50/120,3)prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))then (accrual round(12/120,3)ceiling round(120/120,3)carryover round(60/120,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual round(15/120,3)ceiling round(150/120,3)carryover round(75/120,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'Page 6
carryOverProration 0.25ceilingProration 0.25)))if (ANC ABS PLN NAME 'Sickness')then(if(ANC ABS PLN PLAN UOM 'H')then(if(l length of service 3)then(accrual 12ceiling 120carryover 60prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))then (accrual 13ceiling 130carryover 70prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual 14ceiling 160carryover 80prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25))else if (ANC ABS PLN PLAN UOM 'D')then(if (l length of service 3)Page 7
then(accrual round(12/24,3)ceiling round(120/24,3)carryover round(60/24,3)prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))then (accrual round(13/24,3)ceiling round(130/24,3)carryover round(70/24,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual round(14/24,3)ceiling round(160/24,3)carryover round(80/24,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25))else if (ANC ABS PLN PLAN UOM 'W')then(if (l length of service 3)then(accrual round(12/120,3)ceiling round(120/120,3)carryover round(60/120,3)prorationFactor 0.25vestingUnits 40vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if ((l length of service 3) and (l length of service 5))Page 8
then (accrual round(13/120,3)ceiling round(130/120,3)carryover round(70/120,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration 0.25)else if (l length of service 5)then (accrual round(14/120,3)ceiling round(160/120,3)carryover round(80/120,3)prorationFactor 0.25vestingUnits 30vestingUOM 'C'carryOverProration 0.25ceilingProration ilingProrationGlobal Absence ProrationContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPage 9
PAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariablesReturn ValueprorationFactorData TypeNumberSample **********************************FORMULA NAME: Global Absence Proration FormulaFORMULA TYPE: Global Absence ProrationDESCRIPTION: This sample formula returns the proration factor based on employee type.Change ---------------------------------------------Guru Prasad Havaligi 27-Mar-2013 Initial *****//* DATABASE ITEM DEFAULTS BEGINS */DEFAULT for PER JOB REGULAR TEMPORARY is 'R'DEFAULT for PER ASG ATTRIBUTE1 is 'A'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN */if (PER JOB REGULAR TEMPORARY 'T')then (if (PER ASG ATTRIBUTE1 'System Analyst')then(prorationFactor 0.5))else (prorationFactor 1.0)/* FORMULA SECTION ENDS */return prorationFactorPage10
Global Absence Vesting PeriodContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariablesReturn ValuevestingUnitsvestingUOMData TypeNumberTextSample ***************************FORMULA NAME: Absence Vesting Period FormulaFORMULA TYPE: Global Absence Vesting PeriodDESCRIPTION: This sample formula applies the Ceiling based on employment categoryChange ------------------------------------Guru Prasad Havaligi 22-Mar-2013 Initial ************************************//* DATABASE ITEM DEFAULTS BEGIN */Page11
DEFAULT for PER ASG ORG LEGAL EMPLOYER NAME is 'Vision'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN */If ( PER ASG ORG LEGAL EMPLOYER NAME 'Vision Corporation')then(vestingUOM 'C'vestingUnits 90)else(vestingUOM 'C'vestingUnits 30)/* FORMULA SECTION END */return vestingUOM,vestingUnitsGlobal Absence CarryoverContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Page12
Return VariableUse predefined names for return variables. The following return variables are availableto formulas of this type.Return ValuecarryOverData TypeNumberSample ******************************FORMULA NAME: Global Absence CarryOver FormulaFORMULA TYPE: Global Absence CarryOverDESCRIPTION: This sample formula returns the carry over based on the department ofan employee.Change ---------------------------------------Guru Prasad Havaligi 26-Mar-2013 Initial *******************************************//* DATABASE ITEM DEFAULTS BEGINS */DEFAULT for PER ASG ORG DEPARTMENT NAME is 'A'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN */if (PER ASG ORG DEPARTMENT NAME 'Vision Corporation Enterprise')then(carryOver 30)else(carryOver 10)/* FORMULA SECTION END */return carryoverGlobal Absence Carryover ProrationPurposeContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDPage13
HR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariablesReturn ValueprorationFactorData TypeNumberSample ******************************FORMULA NAME: Absence Carry Over Proration FormulaFORMULA TYPE: Global Absence CarryOver ProrationDESCRIPTION: This sample formula returns the proration factor based on employeetype.Change ----------------------------------------Guru Prasad Havaligi 27-Mar-2013 Initial ********************************************//* DATABASE ITEM DEFAULTS BEGINS */DEFAULT for PER JOB REGULAR TEMPORARY is 'R'DEFAULT for PER ASG ATTRIBUTE1 is 'A'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN */if (PER JOB REGULAR TEMPORARY 'T')Then (if PER ASG ATTRIBUTE1 'IT Engineer'then (Page14
ProrationFactor 0.5))else (ProrationFactor 1.0)/* FORMULA SECTION ENDS */return prorationFactorGlobal Absence CeilingContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariablesReturn ValueceilingData TypeNumberSample ****************************FORMULA NAME: Absence Ceiling FormulaFORMULA TYPE: Global Absence CeilingDESCRIPTION: This sample formula applies the Ceiling based on employment categoryPage15
Change --------------------------------------Guru Prasad Havaligi 22-Mar-2013 Initial ******************************************//* DATABASE ITEM DEFAULTS BEGIN */DEFAULT for ANC ABS PLN PLAN UOM is 'H'DEFAULT for PER JOB REGULAR TEMPORARY is 'R'/* DATABASE ITEM DEFAULTS ENDS *//* FORMULA SECTION BEGIN *//* Begin Assign conversion Factor based on Absence Plan UOM */if (ANC ABS PLN PLAN UOM 'H')then(conversionFactor 1/8)else if (ANC ABS PLN PLAN UOM 'W')then(conversionFactor 1/7)elseconversionFactor 1/* End Assign conversion Factor based on Absence Plan UOM *//* Begin assign ceiling */if (PER JOB REGULAR TEMPORARY 'R' )thenceiling 30*conversionFactorelseceiling 10*conversionFactor/* End assign ceiling *//* FORMULA SECTION END */Return ceilingGlobal Absence Ceiling ProrationContextsThe following contexts are available to formulas of this type: ACCRUAL PLAN IDEFFECTIVE DATEENTERPRISE IDHR ASSIGNMENT IDHR RELATIONSHIP IDHR TERM IDJOB IDLEGAL EMPLOYER IDLEGISLATIVE DATA GROUP IDORGANIZATION IDPAYROLL ASSIGNMENT IDPage16
PAYROLL RELATIONSHIP IDPAYROLL TERM IDPERSON IDDatabase ItemsUse only the following database items that are available to formulas of this type: All columns except primary key (which is used as a filter) from table:ANC ABSENCE PLAN F Any database item which has the contexts (ACCRUAL PLAN ID,EFFECTIVE DATE, ENTERPRISE ID, etc.) supported by the formula type can beused.Return VariablesReturn ValueprorationFactorData TypeNumberSample *****************************FORMULA NAME: Global Absence Proration FormulaFORMULA TYPE: Global Absence ProrationDESCRIPTION: This sample formula returns the proration factor based on employeetype.Change History:NameDateComments---------------------
Oracle Fusion HCM Global Absences Fast Formula Reference Guide Last Update Date: July 18, 2014 . Page 2 . Extract Database Items . 61 . Page 3 Global Absence Accrual Contexts The following contexts are available to formulas of this type: ACCRUAL_PLAN_ID .
a synthesizable 8-bit MOS 6502 processor in VHDL fully synthesizable on the Altera DE2 FPGA board. . it developed the video game console, too. Most of . 0000 BRK b ORA (d ,X) ORA d ASL d PHP ORA # ASL A ORA a ASL a 0001 BPL r ORA (d ),Y ORA d ,X ASL d ,X CLC ORA a ,Y ORA a ,X ASL a ,X 0010 JSR a AND (d ,X) BIT d AND d ROL d PLP AND # ROL A .
purified water, Ora-Sweet (syrup vehicle) and Ora-Plus (suspending vehicle). Ora-Sweet contains citric acid, flavouring, glycerine, methylparaben, potassium sorbate, sodium phosphate, sorbitol, sucrose, and purified water. Ora-Plus contains calcium sulphate, carrageenan, citr
Business Intelligence (BI) Business Suite Customer Relationship Planning R/3 BusinessObjects . SQL command not properly ended ORA-00970, ORA-00907, ORA-01756, ORA-00923, . CMC Help Index program objects Java programs Authentication and program objects. CmcAppSteps for RCE 1. Log on to the server computer.
experience, MOA opened Quad City Ambulatory Surgery Center in 1992. The surgery center included two surgery suites and post-operative and recovery areas. Additional physicians were recruited to both MOA and ORA. Dr. Turner joined MOA in 1991 and Drs. Millea, Martin, and Rink joined ORA during the early to mid '90s.
Table 68: Shirt Laundry Formula 04: White (No Starch) Table 69: Shirt Laundry Formula 05: Colored (No Starch) Table 70: Shirt Laundry Formula 06: Delicates Table 71: Shirt Laundry Formula 07: Stain Treatment Table 72: Shirt Laundry Formula 08: Oxygen Bleach Table 73: Shirt Laundry Formula 09: Stain Soak Table 74: Shirt Laundry Formula 10 .
the empirical formula of a compound. Classic chemistry: finding the empirical formula The simplest type of formula – called the empirical formula – shows just the ratio of different atoms. For example, while the molecular formula for glucose is C 6 H 12 O 6, its empirical formula
A Note about Array formulas (not for Excel 365 / Excel 2021) Sometimes, you will need to enter a formula as array formula. In Excel 365/Excel 2021, all formulas are treated as Array formula, hence you need not enter any formula as Array formula. Only for older versions of Excel, you might need to enter a formula as Array formula.
The F1 FORMULA 1 logo, F1 logo, FORMULA 1, FORMULA ONE, F1, FIA FORMULA ONE WORLD CHAMPIONSHIP, GRAND PRIX and related marks are trade marks of Formula One Licensing BV, a . FORMULA 1 HEINEKEN DUTCH GRAND PRIX 2022 - Zandvoort Race History Chart. LAP 6 GAP TIME 1 1:16.350 16 1.051 1:16.213 . Race History Chart. LAP 11 GAP TIME 1 1:16.671 16 .
