PR
PRAcaEmployeeMonthlyInformation
Stores the information related to the ACA coverage for an employee for a 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 | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
EmployeeID | int | Employee ID | PREmployee | |
Description:No description available | ||||
FTStatus | nvarchar(3) | ACA FT Status | - | |
Description:No description available | ||||
HoursWorked | decimal | Number of Hours Worked | - | |
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 | ||||
MinimumIndividualContribution | decimal | Minimum Individual Contribution | - | |
Description:No description available | ||||
Month | int | Month | - | |
Description:No description available | ||||
OfferOfCoverage | nvarchar(2) | Offer of Coverage | - | |
Description:No description available | ||||
OrgBAccountID | int | Organization | ||
Description:No description available | ||||
Section4980H | nvarchar(2) | Section 4980H | - | |
Description:No description available | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
TStamp | timestamp | - | ||
Description:No description available | ||||
Year | nvarchar(4) | Year | PRAcaCompanyYearlyInformation | |
Description:No description available | ||||