Use the Coins ERP+ function Load 1095-C Part III – Spouse/Dependent Coverage in Administration > ACA Processing to import the employee’s covered individual records directly into Coins ERP+. Use the layout shown in the table below.
Cells on Spreadsheet | Value | Information |
A1 | pp_orgtypes | Must be exact. |
B1 | ppt_ type=ACAXXXX | XXXX stands for the 4 digit calendar year. NO SPACES. Ex. ppt_type=ACA2025 |
A3 | ppo_seq | Employee’s Social Security Number. This is required to associate covered individuals to employees for ACA reporting. |
B3 | pqy_deptype | This value will be: D-Covered individual S-Spouse L-Domestic Partner F-Former Spouse O-Other |
C3 | ppt_surname | Covered individual’s Last Name |
D3 | ppt_1stname | Covered individual’s First Name |
E3 | ppt_2ndname | Covered individual’s Middle Initial (may be blank) |
F3 | pqy_suffix | Covered individual’s Suffix (may be blank) |
G3 | pqy_NINO | Covered individual’s Social Security Number. If this is blank, the Date of Birth must be filled in. |
H3 | ppt_dob | Covered individual’s Date of Birth, only required when SSN is omitted. Use ? when not including the DOB. |
I3 | pqy_other2__1 | Covered in Month 1 Yes or No (blank = NO) |
J3 | pqy_other2__2 | Covered in Month 2 Yes or No (blank = NO) |
K3 | pqy_other2__3 | Covered in Month 3 Yes or No (blank = NO) |
L3 | pqy_other2__4 | Covered in Month 4 Yes or No (blank = NO) |
M3 | pqy_other2__5 | Covered in Month 5 Yes or No (blank = NO) |
N3 | pqy_other2__6 | Covered in Month 6 Yes or No (blank = NO) |
O3 | pqy_other2__7 | Covered in Month 7 Yes or No (blank = NO) |
P3 | pqy_other2__8 | Covered in Month 8 Yes or No (blank = NO) |
Q3 | pqy_other2__9 | Covered in Month 9 Yes or No (blank = NO) |
R3 | pqy_other2__10 | Covered in Month 10 Yes or No (blank = NO) |
S3 | pqy_other2__11 | Covered in Month 11 Yes or No (blank = NO) |
T3 | pqy_other2__12 | Covered in Month 12 Yes or No (blank = NO) |
