Example of Loading Fast Formula
Use HCM Data Loader to create formula that are generic expressions of calculations or comparisons that you want to repeat with different input variables. You can use these predefined rules to perform calculations, such as a legislative specific tax or social insurance calculations.
Create formula with effective start dates on or before the start dates of other objects that refer to your formula.
Supply the fast formula text in a separate text file
and then pass the text file name to the Comments attribute. Further,
place the formula text file in the ClobFiles
folder within the same compressed file as FastFormula.dat file that
references it. Also, don't supply the text directly in the FastFormula.dat
file.
This example loads the fast formula.
METADATA|FastFormula|SourceSystemOwner|SourceSystemId|EffectiveStartDate|FormulaCode|FormulaTypeCode|FormulaName|FormulaText|LegislativeDataGroupId(SourceSystemId)
MERGE|FastFormula|VISION|MGR_SCHED_HRS|2000/01/01|MGR_RANGE_SCHD_HRS|Range of Scheduled Hours|Manager Range of Scheduled Hours|ManagerRangeScheduledHrs.txt|