Guidelines for Loading State Reporting Information Card Components for US Employees

Some US states require additional reporting information. This is captured in the State Reporting Information card component, within the Reporting Information calculation card.

State Reporting Information Card Component Hierarchy

State Reporting Information Card Component Hierarchy

Card Component Attributes for State Reporting Information

The State Reporting Information 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 StateReporting Information 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 Reporting 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 State Reporting Information card component, typically the employee’s start date. This must be the same as the EffectiveStartDate on the Reporting Information calculation card.

If updating an existing State Reporting Information 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 ‘Reporting Information’.
ComponentSequence N/A The number to uniquely identify this card component when multiple card components with the same DirCardCompDefName exist. Not required when source keys are used.
Context1 N/A

The geocode that identifies the US state.

Refer to the Cloud Customer Connect topic Template: BI Publisher Report: United States - State, County and City Geography Codes.

These attributes are supplied against the CardComponent file discriminator and must be supplied along with a CalculationCard record for the parent Reporting Information card.

Component Detail Attributes for State Reporting Information

The component detail record type allows you to upload data into flexfield segments.

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

  • Alaska Reporting Information (HRX_US_REP_REL_STATE_AK)
  • California Reporting Information (HRX_US_REP_REL_STATE_CA)
  • Colorado Reporting Information (HRX_US_REP_REL_STATE_CO)
  • Indiana Reporting Information (HRX_US_REP_REL_STATE_IN)
  • Maine Reporting Information (HRX_US_REP_REL_STATE_ME)
  • Missouri Reporting Information (HRX_US_REP_REL_STATE_MO)
  • New Jersey Reporting Information (HRX_US_REP_REL_STATE_NJ)
  • North Carolina Reporting Information (HRX_US_REP_REL_STATE_NC)
  • Pennsylvania Reporting Information (HRX_US_REP_REL_STATE_PA)
  • Vermont Reporting Information (HRX_US_REP_REL_STATE_VT)

A separate Component Detail file line should be included for each flexfield context you are supplying data for.

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

Core attributes for Component Details:

HCM Data Loader Attribute Alternative User Key Attributes Functional Description
SourceSystemId CardSequence, ComponentSequence, DirInformationCategory, LegislativeDataGroupName, AssignmentNumber, DirCardDefinitionName, DirCardCompDefName A unique identifier for the StateReporting Information 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 StateReporting Information 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 StateReporting Information 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_US_REP_REL_STATE_AK’. 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.
Note: When supplying values to lookup validated flexfield segments, you can provide the lookup meaning using the ‘_Display’ suffixed attribute name, but it is recommended that you supply the lookup code to remove potential translation issues.