ACA export task exported fields

Field Name	Description	Valid Values
EMP_NAME	Direct from employee record.	String
EMP_FIRST_NAME	Direct from employee record.	String
EMP_LAST_NAME	Direct from employee record.	String
EMP_FULL_NAME	Direct from employee record.	String
EMP_HIRE_DATE	Direct from employee record.	String
EMP_BIRTH_DATE	Direct from employee record.	String
ACAMG_NAME	The name of the measurement group being exported, for example: California.	String
ACAMG_UNITS	Measurement groups are defined as being of a certain duration in either weeks or months. This field indicates how many weeks or months the group is defined to span.	Number
ACAMG_UNIT_TYPE	Whether the group's duration is tracked in months or weeks.	M, W
ACA_PERIOD_START_DATE	The start date of the measurement period being exported.	Date
ACA_PERIOD_END_DATE	The end date of the measurement period being exported.	Date
ACA_PERIOD_TOTAL_DAYS	The number of days between the period start and end dates.	Number
ACA_NEW_HIRE	Flag indicating whether the employee is also a newly hired employee. This flag may be important information for administrators because an employee might be over the average threshold as a new hire and thus qualify for coverage, even though they are not over the threshold as part of the particular group being exported.	Y, N
ACA_ASOF_DATE	The final date that is considered when calculating average service hours.	Date
ACA_ASOF_DAYS	The number of days into the period being exported. This number is equal the ACA_PERIOD_TOTAL_DAYS value because mid-period exports were not enabled for this initial release. If mid-period exports are enabled in a future release, this value will be the difference between the start date of the measurement period being exported and an as-of date. The as-of date indicates when, in mid-period, the user wants to get average data. For example: Initial Period Start = 01/01/2014 As of Date = 9/11/2014 As of Days = 254	Number
ACA_ASOF_DAYS_REMAINING	The number of days remaining in the period being exported. For now, this number is always zero because mid-period exports were not enabled for this initial release. If mid-period exports are enabled in a future release, this value will be the difference between the date the export ran and the future end date of the measurement period being exported. For example: Initial Period End = 10/01/2014 Export Runs = 9/11/2014 Days Remaining = 20	Number
ACA_TOTAL_SERVICE_MINUTES	The raw total of recorded service minutes in the ACA_SERVICE_SUMMARY log for the period being exported.	Number
ACA_TOTAL_LEAVE_MINUTES	The raw total of recorded leave minutes in the ACA_SERVICE_SUMMARY log for the period being exported.	Number
ACA_AVG_HOUR_PER_WEEK	The calculated average weekly service hour value for the specified period.	Number
ACA_AVG_HOUR_PER_MONTH	The calculated average monthly service hour value for the specified period.	Number
ACA_WEEK_AVG_OVER	Flag indicating whether the employee's average weekly service hours is above the 30 hour threshold.	Y, N
ACA_MONTH_AVG_OVER	Flag indicating whether the employee's average monthly service hours is above the 130 hour threshold.	Y, N
ACA_MULTIPLE_PERIOD	Flag indicating whether the user's recorded service hours span multiple measurement periods. If an employee changed measurement groups, the employee can end up with time in multiple measurement periods. This flag is meant to warn administrators to look at both periods when making their determination as to whether the employee qualifies for coverage.	Y, N

EMP_NAME

Direct from employee record.

String

EMP_FIRST_NAME

Direct from employee record.

String

EMP_LAST_NAME

Direct from employee record.

String

EMP_FULL_NAME

Direct from employee record.

String

EMP_HIRE_DATE

Direct from employee record.

String

EMP_BIRTH_DATE

Direct from employee record.

String

ACAMG_NAME

The name of the measurement group being exported, for example: California.

String

ACAMG_UNITS

Measurement groups are defined as being of a certain duration in either weeks or months. This field indicates how many weeks or months the group is defined to span.

Number

ACAMG_UNIT_TYPE

Whether the group's duration is tracked in months or weeks.

M, W

ACA_PERIOD_START_DATE

The start date of the measurement period being exported.

Date

ACA_PERIOD_END_DATE

The end date of the measurement period being exported.

Date

ACA_PERIOD_TOTAL_DAYS

The number of days between the period start and end dates.

Number

ACA_NEW_HIRE

Flag indicating whether the employee is also a newly hired employee. This flag may be important information for administrators because an employee might be over the average threshold as a new hire and thus qualify for coverage, even though they are not over the threshold as part of the particular group being exported.

Y, N

ACA_ASOF_DATE

The final date that is considered when calculating average service hours.

Date

ACA_ASOF_DAYS

The number of days into the period being exported. This number is equal the ACA_PERIOD_TOTAL_DAYS value because mid-period exports were not enabled for this initial release. If mid-period exports are enabled in a future release, this value will be the difference between the start date of the measurement period being exported and an as-of date. The as-of date indicates when, in mid-period, the user wants to get average data. For example:

Initial Period Start = 01/01/2014
As of Date = 9/11/2014
As of Days = 254

Number

ACA_ASOF_DAYS_REMAINING

The number of days remaining in the period being exported. For now, this number is always zero because mid-period exports were not enabled for this initial release. If mid-period exports are enabled in a future release, this value will be the difference between the date the export ran and the future end date of the measurement period being exported. For example:

Initial Period End = 10/01/2014
Export Runs = 9/11/2014
Days Remaining = 20

Number

ACA_TOTAL_SERVICE_MINUTES

The raw total of recorded service minutes in the ACA_SERVICE_SUMMARY log for the period being exported.

Number

ACA_TOTAL_LEAVE_MINUTES

The raw total of recorded leave minutes in the ACA_SERVICE_SUMMARY log for the period being exported.

Number

ACA_AVG_HOUR_PER_WEEK

The calculated average weekly service hour value for the specified period.

Number

ACA_AVG_HOUR_PER_MONTH

The calculated average monthly service hour value for the specified period.

Number

ACA_WEEK_AVG_OVER

Flag indicating whether the employee's average weekly service hours is above the 30 hour threshold.

Y, N

ACA_MONTH_AVG_OVER

Flag indicating whether the employee's average monthly service hours is above the 130 hour threshold.

Y, N

ACA_MULTIPLE_PERIOD

Flag indicating whether the user's recorded service hours span multiple measurement periods. If an employee changed measurement groups, the employee can end up with time in multiple measurement periods. This flag is meant to warn administrators to look at both periods when making their determination as to whether the employee qualifies for coverage.

Y, N