This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| general:humanresources:utilities:extractinsurancedatato1095data:body [2020/09/01 19:53] – emoreno | general:humanresources:utilities:extractinsurancedatato1095data:body [2021/09/27 20:42] (current) – emoreno | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | <WRAP round intro> | + | <WRAP round intro> |
| - | |Human Resources | + | |Personnel |
| You must be logged on to a current year pay frequency to access this utility. | You must be logged on to a current year pay frequency to access this utility. | ||
| Line 8: | Line 8: | ||
| If **Insert new records from Staff Demo Insurance Records.** is selected: | 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 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 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. | * 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. | 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. | ||
| Line 18: | Line 22: | ||
| 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. | 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. | + | 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. |
| Line 28: | Line 32: | ||
| VCV Under **Extract Option**, select one of the following options: | VCV Under **Extract Option**, select one of the following options: | ||
| - | * **Insert new records from Staff Demo Insurance Records.** | + | * **Insert new records from Staff Demo Insurance Records.** |
| - | * **Delete all existing records and insert all records from Staff Demo Insurance Records.** | + | * **Delete all existing records and insert all records from Staff Demo Insurance Records.** |
| \\ | \\ | ||
| VCV Under** Plan Options**, select one of the following plan options to extract: | VCV Under** Plan Options**, select one of the following plan options to extract: | ||
The Texas Computer Cooperative (TCC) is committed to making its websites accessible to all users. It is TCC policy to ensure that new and updated content complies with Web Content Accessibility Guidelines (WCAG) 2.0 Level AA. We welcome comments and suggestions to improve the accessibility of our websites. If the format of any material on our website interferes with your ability to access the information, use this form to leave a comment about the accessibility of our website.