Example of Creating Car and Car Fuel Taxable Benefits for the UK

This example describes how you can create car and car fuel taxable benefits for the UK.

The Car and Car Fuel card component for the UK Taxable Benefits card has this shape:

Refer to the Guidelines for Loading Taxable Benefits for the United Kingdom topic for the attributes to supply for each record type.

This example creates a Taxable Benefits card with the Car and Car Fuel and Period of Unavailability Car card components for employee assignment E451388 starting 6 April, 2020.

The CalculationCard.dat file is used to bulk-load Taxable Benefits cards with HCM Data Loader:

METADATA|CalculationCard|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|AssignmentNumber
MERGE|CalculationCard|VISION|TB_451388|UK LDG|Taxable Benefits|2020/04/06|E451388

METADATA|CardComponent|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|ParentDirCardCompId(SourceSystemId)|DirCardCompDefName|Context1
MERGE|CardComponent|VISION|TB_451388_Car|UK LDG|TB_451388|2020/04/06||Car and Car Fuel|LF20 REG
MERGE|CardComponent|VISION|TB_451388_CUA|UK LDG|TB_451388|2020/04/06|TB_451388_Car|Period of Unavailability Car|

METADATA|ComponentDetail|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardCompId(SourceSystemId)|EffectiveStartDate|DirCardCompDefName|FLEX:Deduction Developer DF|DirInformationCategory|_MAKE(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_MODEL(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_DATE_FIRST_REGISTERED(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_LIST_PRICE(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_APPROVED_CO2_EMISSION(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_CAR_FUEL_POWER(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_ENGINE_SIZE_CC(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_ROTARY_ENGINE(Deduction Developer DF=ORA_HRX_GB_BSC_CAR_2017)|_PROCESS_OR_REPORT(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_PRICE_OF_ACCESSORIES(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_CAPITAL_CONTRIBUTION(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_PAYMENT_MADE_PRIVATE(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_AMOUNT_FOREGONE(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_CASH_EQUIVALENT(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_REGISTERED_ON_FPS(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_REGISTERED_ON_FPS_PA(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_FUEL_BENEFIT_PROVIDED(Deduction Developer DF=ORA_HRX_GB_CAR_PRC_2017)|_DATE_FUEL_PROV_WITHDRAWN(Deduction Developer DF=ORA_HRX_GB_FUEL_PRC_2017)|_ADD_DAYS_AFT_WITHDRAWL(Deduction Developer DF=ORA_HRX_GB_FUEL_PRC_2017)|_FUEL_PROVISION_REINSTD(Deduction Developer DF=ORA_HRX_GB_FUEL_PRC_2017)|_AMOUNT_FOREGONE(Deduction Developer DF=ORA_HRX_GB_FUEL_PRC_2017)|_CASH_EQUIVALENT(Deduction Developer DF=ORA_HRX_GB_FUEL_PRC_2017)|_ADDITION_NUM_DAYS_UNAVAIL(Deduction Developer DF=ORA_HRX_GB_PERD_UNAVAIL_2017)
MERGE|ComponentDetail|VISION|TB_451388_CAR2017|UK LDG|TB_451388_Car|2020/04/06|Car and Car Fuel|ORA_HRX_GB_BSC_CAR_2017|ORA_HRX_GB_BSC_CAR_2017|Ford|Ka|2020/02/04|5999|100|A|1000|N|||||||||||||||
MERGE|ComponentDetail|VISION|TB_451388_PRC2017|UK LDG|TB_451388_Car|2020/04/06|Car and Car Fuel|ORA_HRX_GB_CAR_PRC_2017|ORA_HRX_GB_CAR_PRC_2017|||||||||PAYROLL|3000|2500|2000|1500|1000|||N||||||
MERGE|ComponentDetail|VISION|TB_451388_FLP2017|UK LDG|TB_451388_Car|2020/04/06|Car and Car Fuel|ORA_HRX_GB_FUEL_PRC_2017|ORA_HRX_GB_FUEL_PRC_2017||||||||||||||||||2020/07/01|30|N|4000|3000|
MERGE|ComponentDetail|VISION|TB_451388_UNA2017|UK LDG|TB_451388_CUA|2020/04/06|Period of Unavailability Car|ORA_HRX_GB_PERD_UNAVAIL_2017|ORA_HRX_GB_PERD_UNAVAIL_2017|||||||||||||||||||||||50

METADATA|CardAssociation|SourceSystemOwner|SourceSystemId|LegislativeDataGroupName|DirCardId(SourceSystemId)|EffectiveStartDate|TaxReportingUnitName
MERGE|CardAssociation|VISION|TB_451388_TRU|UK LDG|TB_451388|2020/04/06|UK TRU

METADATA|CardAssociationDetail|SourceSystemOwner|SourceSystemId|DirCardCompId(SourceSystemId)|DirRepCardId(SourceSystemId)|EffectiveStartDate|AssociationAssignmentNumber
MERGE|CardAssociationDetail|VISION|TB_451388_ADC|TB_451388_Car|TB_451388_TRU|2020/04/06|E451388