Example of Loading Federal Rules for a Payroll Statutory Unit

These file lines provide an example of creating the Federal Rule card components for the Calculation Rules for Tax Reporting and Payroll Statutory Unit card for a Payroll Statutory Unit.

The following card components are created:

• Federal Income Tax
• Federal Unemployment
• Social Security
• Medicare
• Overtime Rules
• Federal Income Tax for 1099-R

The following value definitions are overridden:

Card Component	Value Definition	Override Value
Federal Unemployment	Federal Unemployment Employer Rate	10
Overtime Rules	Aggregate Overtime Premium Rate for all TRUs within the PSU?	N
Federal Income Tax for 1099-R	Retiree Federal Tax Rate	5

The CalculationCard.dat file is used to bulk-load Calculation Rules for Tax Reporting and Payroll Statutory Unit cards with HCM Data Loader.

METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardDefinitionName|PayrollStatutoryUnitName|EffectiveStartDate|CardSequence
MERGE|CalculationCard|VISION|USPSU_CALC_RULES|US LDG|Calculation Rules for Tax Reporting and Payroll Statutory Unit|US PSU|2018/01/01|1

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|PayrollStatutoryUnitName|EffectiveStartDate|DirCardCompDefName|ComponentSequence
MERGE|CardComponent|VISION|USPSU_CALC_RULES_OVERTIME|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Overtime Rules|1
MERGE|CardComponent|VISION|USPSU_CALC_RULES_1099R|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Federal Income Tax for 1099-R|2
MERGE|CardComponent|VISION|USPSU_CALC_RULES_UNEMP|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Federal Unemployment|3
MERGE|CardComponent|VISION|USPSU_CALC_RULES_SOC_SEC|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Social Security|4
MERGE|CardComponent|VISION|USPSU_CALC_RULES_FIT|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Federal Income Tax|5
MERGE|CardComponent|VISION|USPSU_CALC_RULES_MED|US LDG|USPSU_CALC_RULES|US PSU|2018/01/01|Medicare|6

METADATA|ComponentDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|PayrollStatutoryUnitName|EffectiveStartDate|DirCardCompDefName|DirInformationCategory|FLEX:Deduction Developer DF|_FEDERAL_SELF_ADJUST_METHOD(Deduction Developer DF=HRX_US_ORG_FEDERAL_UNEMPLOYMENT)|_FEDERAL_SELF_ADJUST_METHOD(Deduction Developer DF=HRX_US_ORG_FEDERAL_SOCIAL_SECURITY)|_SUPPLEMENTAL_TAX_CALC_METHOD(Deduction Developer DF=HRX_US_ORG_FEDERAL_INCOME_TAX)|_STATE_WITHHOLDING_RULES(Deduction Developer DF=HRX_US_ORG_FEDERAL_INCOME_TAX)|_REGULAR_AGGREGATE_RULE(Deduction Developer DF=HRX_US_ORG_FEDERAL_INCOME_TAX)|_FEDERAL_SELF_ADJUST_METHOD(Deduction Developer DF=ORA_HRX_US_ORG_FEDERAL_MEDICARE)
MERGE|ComponentDetail|VISION|USPSU_CALC_RULES_UNEMP_DET|US LDG|USPSU_CALC_RULES_UNEMP|US PSU|2018/01/01|Federal Unemployment|HRX_US_ORG_FEDERAL_UNEMPLOYMENT|HRX_US_ORG_FEDERAL_UNEMPLOYMENT|SELF_ADJ|||||
MERGE|ComponentDetail|VISION|USPSU_CALC_RULES_SOC_SEC_DET|US LDG|USPSU_CALC_RULES_SOC_SEC|US PSU|2018/01/01|Social Security|HRX_US_ORG_FEDERAL_SOCIAL_SECURITY|HRX_US_ORG_FEDERAL_SOCIAL_SECURITY||SELF_ADJ||||
MERGE|ComponentDetail|VISION|USPSU_CALC_RULES_FIT_DET|US LDG|USPSU_CALC_RULES_FIT|US PSU|2018/01/01|Federal Income Tax|HRX_US_ORG_FEDERAL_INCOME_TAX|HRX_US_ORG_FEDERAL_INCOME_TAX|||AGGREGATION|||
MERGE|ComponentDetail|VISION|USPSU_CALC_RULES_MED_DET|US LDG|USPSU_CALC_RULES_MED|US PSU|2018/01/01|Medicare|ORA_HRX_US_ORG_FEDERAL_MEDICARE|ORA_HRX_US_ORG_FEDERAL_MEDICARE||||||SELF_ADJ

METADATA|CalculationValueDefinition|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|SourceId(SourceSystemId)|PayrollStatutoryUnitName|EffectiveStartDate|DirCardCompDefName|ValueDefinitionName
MERGE|CalculationValueDefinition|VISION|USPSU_CALC_RULES_OVERTIME_VD1|US LDG|USPSU_CALC_RULES_OVERTIME|US PSU|2018/01/01|Overtime Rules|Aggregate Overtime Premium Rate for all TRUs within the PSU?
MERGE|CalculationValueDefinition|VISION|USPSU_CALC_RULES_1099R_VD1|US LDG|USPSU_CALC_RULES_1099R|US PSU|2018/01/01|Federal Income Tax for 1099-R|Retiree Federal Tax Rate
MERGE|CalculationValueDefinition|VISION|USPSU_CALC_RULES_UNEMP_VD1|US LDG|USPSU_CALC_RULES_UNEMP|US PSU|2018/01/01|Federal Unemployment|Federal Unemployment Employer Rate

METADATA|EnterableCalculationValue|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|ValueDefnId(SourceSystemId)|PayrollStatutoryUnitName|EffectiveStartDate|DirCardCompDefName|ValueDefinitionName|Value1
MERGE|EnterableCalculationValue|VISION|USPSU_CALC_RULES_OVERTIME_VD1|US LDG|USPSU_CALC_RULES_OVERTIME_VD1|US PSU|2018/01/01|Overtime Rules|Aggregate Overtime Premium Rate for all TRUs within the PSU?|N
MERGE|EnterableCalculationValue|VISION|USPSU_CALC_RULES_1099R_VD1|US LDG|USPSU_CALC_RULES_1099R_VD1|US PSU|2018/01/01|Federal Income Tax for 1099-R|Retiree Federal Tax Rate|5
MERGE|EnterableCalculationValue|VISION|USPSU_CALC_RULES_UNEMP_VD1|US LDG|USPSU_CALC_RULES_UNEMP_VD1|US PSU|2018/01/01|Federal Unemployment|Federal Unemployment Employer Rate|10