Sidebar
humanresources:utilities:extractinsurancedatato1095data
This is an old revision of the document!
Extract Insurance Data to 1095 Data - HRS7965
Human Resources > Utilities > Extract Insurance Data to 1095 Data
This page is used to extract insurance data from the Maintenance > Staff Demo > Insurance tab to the ACA Covered Individuals section on the Maintenance > 1095-B and 1095-C pages. The extract only includes those employees who have a self-insured insurance plan (i.e., Self-Insured is selected for the plan on the Tables > Insurance Company Codes page) on the Maintenance > Staff Demo > Insurance tab.
You must be logged on to a current year pay frequency to access this utility.
Notes:
If Insert new records from Staff Demo Insurance Records. is selected:
- If 1095-B or 1095-C employee records exist without coverage data, then the 1095-B or 1095-C coverage rows are inserted.
- If 1095-B or 1095-C employee records exist with coverage data, then no new coverage rows are inserted.
- If insurance plan data is available but no coverage data, a 1095-B or 1095-C employee record is created if it does not exist.
The All field is only selected if the employee has coverage for the entire year based on the Coverage Begin and Coverage End dates on the Maintenance > Staff Demo > Insurance page.
Individual month check boxes are selected based on the earliest Coverage Begin and latest Coverage End date.
Staff demo insurance coverage records are combined when multiple records have the same first name, middle name, last name, social security number, and date of birth.
If a staff demo insurance coverage record exists where the Coverage End date is less than the selected calendar year, or the Coverage Begin date is greater than the selected calendar year, then the 1095-B and 1095-C records are inserted without selected check boxes.
Extract data:
Under Extract Option, select one of the following options:
- Insert new records from Staff Demo Insurance Records.
- Delete all existing records and insert all records from Staff Demo Insurance Records.
Under Plan Options, select one of the following plan options to extract:
- Self-Insured Plans
- Non Self-Insured Plans - If selected and ACA 1095-C records are extracted, no individual coverage records are extracted from the employee insurance table.
Under Record Type, select one of the following options:
- ACA 1095-B (selected by default)
- ACA 1095-C
| Field | Description |
|---|---|
| Calendar Year (YYYY) | Type the calendar year for which you want to extract data. |
If ACA 1095-B is selected, in the Coverage Type field, click 
to select the coverage type to be extracted.
If ACA 1095-C is selected, enter data in the following fields:
| Plan Start Month | Type the two-digit number (01 through 12) indicating the calendar month during which the plan year begins for the health plan in which the employee is offered coverage (or would be offered coverage if the employee were eligible to participate in the plan). If more than one plan year could apply (for instance, if the ALE Member changes the plan year during the year), enter the earliest applicable month. | |
|---|---|---|
| Offer of Coverage | Click to select the coverage offer to be extracted. The selected Offer of Coverage code is populated in the All column. Coverage offers | |
| Safe Harbor | Click to select safe harbor code to be extracted. The selected Safe Harbor code is populated in the All column. |
Under Employee Share of Lowest Cost Monthly Premium, type the set share of the lowest-cost monthly premium amount for employees in each pay type (1-4).
- The Employee Share field should only be entered if the Offer of Coverage field is set to 1B (Offer to employee only), 1C (Offer to employee and dependents), 1D (Offer to employee and spouse), or 1E (Offer to employee, spouse, and dependents). Offer of coverage codes 1J - Offer to employee, spouse conditional, not to dependents and 1K - Offer to employee and dependents, spouse conditional are included if the Calendar Year is set to 2016.
- If the set share of the lowest-cost monthly premium amount is the same for all 12 calendar months, type that monthly amount in the All field and do not enter data in the individual month fields.
- If the set share of the lowest-cost monthly premium amount was not the same for all 12 calendar months, type that monthly amount in the respective month (Jan-Dec) fields.
Note: When the data is extracted, if the All field is populated, the individual monthly fields are set to zero. If the individual monthly amounts are entered, the All column is set to zero and the individual monthly fields are populated.
- Only one set of values can exist for each local education agency (LEA); therefore, these values should not be updated by individual users.
- The values are saved upon clicking Execute.
Under Employees with Calendar YTD Data Who Do Not Have Staff Demo Insurance Records, select one of the following options:
- Pay Type 1-3 Employees
- Pay Type 1-4 Employees
Click Execute. If any errors are encountered, an Extract Staff Demo Insurance Data to 1095-B/1095C Error Report is displayed.
Click Cancel to return to the Extract Insurance Data to 1095 Data page.
A message is displayed indicating that the process was successful. The extracted records can be viewed and modified on the Maintenance > ACA 1095 YTD Data page.
6. If ACA 1095-C is selected, enter data in the following fields:
● In the Plan Start Month, type the two-digit number (01 through 12) indicating the calendar month during which the plan year begins for the health plan in which the employee is offered coverage (or would be offered coverage if the employee were eligible to participate in the plan). If more than one plan year could apply (for instance, if the ALE Member changes the plan year during the year), enter the earliest applicable month.
● In the Offer of Coverage field, click to select the coverage offer to be extracted. The selected Offer of Coverage code is populated in the All column.
● In the Safe Harbor field, click to select safe harbor code to be extracted. The selected Safe Harbor code is populated in the All column.
● Under Employee Share of Lowest Cost Monthly Premium, type the set share of the lowest-cost monthly premium amount for employees in each pay type (1-4).
□ The Employee Share field should only be entered if the Offer of Coverage field is set to 1B (Offer to employee only), 1C (Offer to employee and dependents), 1D (Offer to employee and spouse), or 1E (Offer to employee, spouse, and dependents). Offer of coverage codes 1J - Offer to employee, spouse conditional, not to dependents and 1K - Offer to employee and dependents, spouse conditional are included if the Calendar Year is set to 2016.
□ If the set share of the lowest-cost monthly premium amount is the same for all 12 calendar months, type that monthly amount in the All field and do not enter data in the individual month fields.
□ If the set share of the lowest-cost monthly premium amount was not the same for all 12 calendar months, type that monthly amount in the respective month (Jan-Dec) fields.
Note: When the data is extracted, if the All field is populated, the individual monthly fields are set to zero. If the individual monthly amounts are entered, the All column is set to zero and the individual monthly fields are populated.
□ Only one set of values can exist for each local education agency (LEA); therefore, these values should not be updated by individual users.
□ The values are saved upon clicking Execute.
● Under Employees with Calendar YTD Data Who Do Not Have Staff Demo Insurance Records, select one of the following options:
□ Pay Type 1-3 Employees
□ Pay Type 1-4 Employees
Other functions and features:
humanresources/utilities/extractinsurancedatato1095data.1513205749.txt.gz · Last modified: 2017/12/13 17:55 (external edit)