Guidelines for Loading Canadian Payroll Tax Card Components

The Payroll Tax card component is used to capture information that will impact an employee's payroll tax calculations for the provinces of Northwest Territories and Nunavut.

Each Tax Credit Information calculation card should have one Payroll Tax card component, if the province is Northwest Territories and Nunavut.

Payroll Tax Card Component Hierarchy

Most provinces use the Provincial Tax card component, but Northwest Territories and Nunavut use the Payroll Tax card component.

Card Component Attributes for Payroll Tax

The Payroll Tax Card Component uses these attributes:

HCM Data Loader Attribute	Alternative User Key Attributes	Functional Description
SourceSystemId	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName	A unique identifier for the Payroll Tax card component. For new card components supply the source key attributes. You can also identify card components with the user key attributes.
SourceSystemOwner	N/A	The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName	N/A	The name of the legislative data group for the card component definition.
DirCardId(SourceSystemId)	CardSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName	The parent Tax Credit Information calculation card should be identified by using the same key type used to identify the calculation card. When using source keys, supply this attribute with the value supplied for the calculation card’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent calculation card
EffectiveStartDate	N/A	The start date of the Payroll Tax card component. This must be the same as the EffectiveStartDate on the Tax Credit Information calculation card. If updating an existing Payroll Tax card component, the effective start date must be original start date of the component.
EffectiveEndDate	N/A	The end date is optional for the card component
DirCardCompDefName	N/A	The component definition name. Specify ‘Payroll Tax’.
ComponentSequence	N/A	A number to uniquely identify this card component when multiple card components for the same card component definition exist on the same card. Not required when source keys are used.
Context1	N/A	The code of the province. Refer to the Geography Code for Canadian Provinces topic.

Card Component Detail Attributes for Payroll Tax

In addition to the attributes defined here, include the necessary flexfield segment attribute values for the flexfield context:

Payroll Tax Context (HRX_CA_WTH_PROVINCE_PAYROLL_TAX)

Note: You can find the flexfield segment attribute names for this flexfield context using the View Business Objects task.

HCM Data Loader Attribute	Alternative User Key Attributes	Functional Description
SourceSystemId	CardSequence, ComponentSequence, DirInformationCategory, LegislativeDataGroupName, AssignmentNumber, DirCardDefinitionName, DirCardCompDefName	A unique identifier for the component detail. For new component detail records supply the source key attributes. You can also identify card components with the user key attributes.
SourceSystemOwner	N/A	The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName	N/A	The name of the legislative data group for the card component definition.
DirCardCompId(SourceSystemId)	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName	The parent Payroll Tax card component should be referenced using the same key type used to identify the parent record. When using source keys, supply this attribute with the value supplied for the card component’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent card component.
EffectiveStartDate	N/A	The start date of the component detail, or update to the component detail if you are providing date-effective history. This must be after or equal to the EffectiveStartDate provided for the Payroll Tax card component.
EffectiveEndDate	N/A	The optional end date of the component detail, or if you are providing date-effective history the last day of the date-effective changes.
DirCardCompDefName	N/A	The name of the card component this detail is for. This is used to identify the flexfield context and should be supplied even when a source key is used to identify the parent card component.
DirInformationCategory	N/A	The code for the flexfield context, such as ‘HRX_CA_WTH_PROVINCE_PAYROLL_TAX’. Flexfield context codes are visible on the Flexfield Attributes tab of the View Business Objects task.
FLEX:Deduction DeveloperDF	N/A	Supply the same value as for the DirInformationCategory attribute.

Payroll Tax Value Definitions

The Payroll Tax card component uses these value definitions to supply override values:

Value Definition Name	Functional Description
Total Claim Amount	The provincial tax exemption amount. Note: This value defaults to the basic amount populated from the Load Payroll Tax Information process. For employees with the basic amount, do not populate the Total Claim Amount, as the value will be read as an override and will not be updated by the Load Payroll Tax Information process when the basic amounts change. If the employee has a total claim amount different than the basic amount, the amount should be entered here. This override is not reset to the basic amount or updated at the beginning of the year. It will remain the same until modified by the user, or reset using the Tax Overrides Report.
Other Tax Credits	An additional tax credit used to reduce the income tax amount, as authorized by the government.

Value Definition Name

Functional Description

Total Claim Amount

The provincial tax exemption amount.

Note: This value defaults to the basic amount populated from the Load Payroll Tax Information process. For employees with the basic amount, do not populate the Total Claim Amount, as the value will be read as an override and will not be updated by the Load Payroll Tax Information process when the basic amounts change. If the employee has a total claim amount different than the basic amount, the amount should be entered here. This override is not reset to the basic amount or updated at the beginning of the year. It will remain the same until modified by the user, or reset using the Tax Overrides Report.

Other Tax Credits

An additional tax credit used to reduce the income tax amount, as authorized by the government.

Calculation Value Definition Attributes for Payroll Tax

The Calculation Value Definition record type uses these attributes:

HCM Data Loader Attribute	Alternative User Key Attributes	Functional Description
SourceSystemId	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName	A unique identifier for the calculation value definition record. For new records supply the source key attributes. You can also identify calculation value definition records with the user key attributes.
SourceSystemOwner	N/A	The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName	N/A	The name of the legislative data group for the card component definition.
SourceId(SourceSystemId)	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName	The parent Payroll Tax card component should be referenced by using the same key type used to identify the card component. When using source keys, supply this attribute with the value supplied for the card component’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent card component.
EffectiveStartDate	N/A	The start date of the parent Payroll Tax card component or the date the calculation value definition starts, if later.
DirCardCompDefName	N/A	The definition name of the parent Payroll Tax card component. Specify the same value as provided on the parent card component record.
ValueDefinitionName	N/A	The name of the value being overridden. The list of value definitions applicable to this card component are listed above.

These attributes are supplied against the CalculationValueDefinition file discriminator and must be supplied along with a CardComponent record for the parent Payroll Tax card component and a CalculationCard record for the owning Tax Credit Information card.

Enterable Calculation Value Attributes for Payroll Tax

The Enterable Calculation Value provides the override value for the value definition. It references the Calculation Value Definition record which defines the Value Definition being overridden.

The Enterable Calculation Value record type uses these attributes:

HCM Data Loader Attribute	Alternative User Key Attributes	Functional Description
SourceSystemId	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName	A unique identifier for the enterable calculation value record. For new records supply the source key attributes. You can also identify calculation value definition records with the user key attributes.
SourceSystemOwner	N/A	The name of the source system owner used to generate the source system ID.
LegislativeDataGroupName	N/A	The name of the legislative data group for the override value.
ValueDefnIdSourceSystemId)	CardSequence, ComponentSequence, AssignmentNumber, DirCardDefinitionName, LegislativeDataGroupName, DirCardCompDefName, ValueDefinitionName	Identify the parent Calculation Value Definition record using the same key type used to identify the calculation value definition. When using source keys, supply this attribute with the value supplied for the calculation value definition’s SourceSystemId attribute. Otherwise, supply the user key attributes with the same values as the parent record.
EffectiveStartDate	N/A	The effective start date of the parent calculation value definition record, or the update to the override value if supplying date-effective history.
EffectiveEndDate	N/A	The optional end date of the override value, or if you are providing date-effective history, the last day of the date-effective changes
Value1	N/A	The value for the value definition identified by the parent calculation value definition record.

These attributes are supplied against the EnterableValueDefinition file discriminator. You must supply an EnterableValueDefinition record for each CalculationValueDefinition record supplied.