REVISION CONTROL
Author: Business Intelligence / Data Operations (BI/DO)
| Date | By | Action | Pages |
| 08/06/24 | BIDO | Created/Revised | |
| 08/18/25 | Training | Upload to KB | |
| Table of Contents | |
|---|---|
|
Section I: ACA – Three reports appear in tabs on main ACA Report Page 1.0 ACA Reporting - ACA_TRANS_RPT_ALL_EES
2.0 ACA Reporting - ACA_TRANS_RPT_HIRE_EES
3.0 ACA Reporting - ACA_TRANS_RPT_TERM_EES
|
Section II: Benefits Enrollment Cost - Two reports appear on main Benefits Enrollment Cost Report 4.0 Benefits Enrollment Cost-Benefits Health Enrollment Cost
5.0 Benefits Enrollment Cost Benefits Health Enrollment Cost Detail
|
1.0 ACA Reporting - ACA_TRANS_RPT_ALL_EES
1.1 Report Description
This report returns all active employees, as of the run date. In addition to active, this report also returns recent terminations.
1.2 Report Screenshot
1.3 Dataset
This report was developed using the following dataset:
• Benefits_ACA_Snowflake
1.4 Control Prompts
This report contains the following Control Prompts to allow users to filter data:
- Campus
- Effective Date After
1.5 Report Fields
This report contains the following report fields:
- Campus
- Employee ID
- Empl Rcd #
- Last Name
- First Name
- SCO Position Number
- Job Code
- Date of Hire
- Job Effdt
- Job End Date
- Separation Date
- Benefit Covg Effdt
- Coverage End Date
- Benefit Program
- Benefit Plan
- Prior Benefit Program
- Prior Benefit Plan
- ACAS Status Code
- FTE
- Action
- Rehired Annuitant
2.0 ACA Reporting - ACA_TRANS_RPT_HIRE_EES
2.1 Report Description
This report returns all employees Hired and Rehired during a time period.
2.2 Report Screenshot
2.3 Dataset
This report was developed using the following dataset:
• Benefits_ACA_Snowflake
2.4 Control Prompts
- Campus
- Effective Date Between
2.5 Report Fields
This report contains the following report fields:
- Campus
- Employee ID
- Empl Rcd #
- Last Name
- First Name
- SCO Position Number
- Job Code
- Date of Hire
- Job Effdt
- Job End Date
- Separation Date
- Benefit Covg Effdt
- Coverage End Date
- Benefit Program
- Benefit Plan
- ACAS Status Code
- FTE
- Action
- Rehired Annuitant
- ACA Status (1A)
- ACA Status (2A)
- ACA Status (2D)
- ACA Status (3A)
- ACA Status (4A/4B)
3.0 ACA Reporting - ACA_TRANS_RPT_TERM_EES
3.1 Report Description
This report returns all employees Terminated during a time period.
3.2 Report Screenshot
3.3 Dataset
This report was developed using the following dataset:
• Benefits_ACA_Snowflake
3.4 Control Prompts
- Campus
- Effective Date Between
3.5 Report Fields
This report contains the following report fields:
- Campus
- Employee ID
- Empl Rcd #
- Last Name
- First Name
- SCO Position Number
- Job Code
- Date of Hire
- Job Effdt
- Job End Date
- Separation Date
- Benefit Covg Effdt
- Coverage End Date
- Benefit Program
- Benefit Plan
- Prior Benefit Program
- Prior Benefit Plan
- ACAS Status Code
- FTE
- Action
- Rehired Annuitant
- ACA Status (5D)
4.0 Benefits Enrollment Cost – Benefits Health Enrollment Cost
4.1 Report Description
This report provides summary data related to health benefits enrollment cost.
4.2 Report Screenshot
4.3 Dataset
This report was developed using the following dataset:
• BA_Benefits_Enrollment_Snowflake
4.4 Control Prompts
Business Unit
Job Code
- Union Code
- Plan Type
- Coverage Code
- Department Tree
- Department Level 1
- Department Level 2
- Department Level 3
- Department Level 4
- Department Level 5
4.5 Report Fields
This report contains the following report fields:
- Business Unit
- Plan Type
- Coverage Code
- Enrollment Count
- Benefit Employee Rate
- Benefit Employer Rate
5.0 Benefits Enrollment Cost – Benefits Health Enrollment Cost Detail
5.1 Report Description
This report provides details related to health benefits enrollment cost.
5.2 Report Screenshot
5.3 Dataset
This report was developed using the following dataset:
• BA_Benefits_Enrollment_Snowflake
5.4 Control Prompts
- Business Unit
- Job Code
- Union Code
- Plan Type
- Coverage Code
- Department Tree
- Department Level 1
- Department Level 2
- Department Level 3
- Department Level 4
- Department Level 5
5.5 Report Fields
This report contains the following report fields:
- Business Unit
- Name
- Employee ID
- Employee Record
- Department Level 2
- Department Level 3
- Department
- Union Code
- Jobcode
- Plan Type
- Coverage Code
- FTE
- Benefit Employee Rate
- Benefit Employer Rate
End of Article
0 Comments
Add your comment