PR
PRAcaCompanyMonthlyInformation
Stores the information related to the ACA coverage of a company for a specific month. The information will be displayed on the ACA Reporting (PR207000) form.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
BranchIDObsolete | int | - | ||
Description:No description available | ||||
CertificationOfEligibility | nvarchar(3) | Certification of Eligibility | - | |
Description:No description available | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
Month | int | Month | - | |
Description:No description available | ||||
NumberOfEmployees | int | Nbr. Employees | - | |
Description:No description available | ||||
NumberOfFte | int | Nbr. FTE | - | |
Description:No description available | ||||
Numberof1095C | int | Nbr. of 1095-C Forms | - | |
Description:No description available | ||||
OrgBAccountID | int | Organization | ||
Description:No description available | ||||
PctEmployeesCoveredByMec | decimal | % of Employees Covered by MEC | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
SelfInsured | bit | Self-Insured | - | |
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
Year | nvarchar(4) | Year | PRAcaCompanyYearlyInformation | |
Description:No description available | ||||