You are currently viewing How to load/delete the status processing rule for elements using HDL?

In this article, let’s look into loading the status processing rules using HDL.

As part of elements migration, we also need to load the status processing rules for elements.

Table of Contents

Sample HDL for Status Processing Rule and Formula Result Rule Load:

COMMENT Save file as PayrollElementDefinition.dat
METADATA|StatusProcessingRule|EffectiveStartDate|EffectiveEndDate|ElementCode|LegislativeDataGroupName|FormulaCode|BalanceAdjustment
MERGE|StatusProcessingRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|CLINIC CHARGES_VOL_DEDN_CALCULATOR|No
MERGE|StatusProcessingRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|ACTING ALLOWANCE EARNINGS|No

           
            

METADATA|FormulaResultRule|EffectiveStartDate|EffectiveEndDate|ElementCode|LegislativeDataGroupName|ResultReturned|ResultRule|TargetElementCode|TargetInputValueCode|BalanceAdjustment|SeverityLevel MERGE|FormulaResultRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|dedn_amt|Indirect Result|Clinic Charges Results|Pay Value|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|mesg|Message|||No|W MERGE|FormulaResultRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|not_taken|Indirect Result|Clinic Charges Results|Not Taken|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|to_arrears|Indirect Result|Clinic Charges Results|Arrear|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Clinic Charges Calculator|US Legislative Data Group|to_total_owed|Indirect Result|Clinic Charges Results|Accrued|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce_abs_days|Direct Result|Acting Allowance|REDUCE_REGULAR_ABSENCE_DAYS|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce_abs_hours|Direct Result|Acting Allowance|REDUCE_REGULAR_ABSENCE_HOURS|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce_abs|Direct Result|Acting Allowance|REDUCE_REGULAR_ABSENCE_EARNINGS|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce_days|Direct Result|Acting Allowance|Reduce Regular Days|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce_hours|Direct Result|Acting Allowance|Reduce Regular Hours|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_reduce|Direct Result|Acting Allowance|Reduce Regular Earnings|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|l_value|Direct Result|Acting Allowance|Pay Value|No| MERGE|FormulaResultRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|mesg|Message|||No|I

Status Processing Rules and Formula Result Rules go hand in hand. We need to load them both at once.

Sample HDL to delete the status processing rule:

METADATA|StatusProcessingRule|EffectiveStartDate|EffectiveEndDate|ElementCode|LegislativeDataGroupName|FormulaCode|BalanceAdjustment
DELETE|StatusProcessingRule|1951/01/01|4712/12/31|Acting Allowance|US Legislative Data Group|ACTING ALLOWANCE EARNINGS|No