Advanced - Batch Processing
The Benefits Processing area includes several batch jobs. Refer to the appropriate sections below for a list of all batch and report jobs. For detailed information on the jobs (such as when to run, input, output, and process parameters), refer to the CGI Advantage HRM run sheet guides, available on the User Guide Downloads page.
Job Name |
Description |
Batch Catalog section |
Auto Change Batch Job |
The Auto Change batch job will identify triggers generated by the ESMT when a benefit policy has been changed, triggers that generated by the birthday change for an employee in the ATTR and triggers generated by the Pension Profile (PENS) transaction when an employee has a change to their Retirement Type and/or Plan. The Auto Change batch job will either expire prior benefits/deductions that they employee should no longer be enrolled in or enroll the employee in new benefits/deductions that they are to be enrolled in now based on their benefit policy or retirement type and plan. Benefits/deductions will be expired one day prior to the new benefit/deduction being enrolled. |
On-Request Processing |
Year-end Catch-up Defined Contribution Plan Batch Job |
The Year-end Catch-up Defined Contribution Plan batch job automatically enroll employees who become eligible for Catch-up plans during the specified calendar year into a Catch-up defined contribution plan once the employee turns 50. The batch job utilizes the Auto Benefit Change - (ABCG) reference page and should be run once a year at the end of the calendar year. |
On-Request Processing |
Benefit Eligibility Test Batch Job |
The Benefit Eligibility Test is an offline process that will be available from the HRM Batch Catalog under the On Request Jobs and is to be scheduled to run before benefits that require the eligibility test are processed. The Benefit Eligibility Test batch process will accumulate all events reported by an employee that have the Benefit Eligibility Test check box checked on the EVNT reference page for the eligibility time period selected on the job parameter. This job should be run before benefits with eligibility tests are processed. |
On-Request Processing |
Benefits Roster Extract (HH00200R) |
Generates an extract file in preparation for the Dependent Coordination of Benefits (HHA7000) Report and the Benefit Roster (HHRD020) Report. The Dependent Coordination of Benefits Report lists all dependents who have benefit coverage. The report is generated by the Dependent Coordination of Benefits Report process. These listings can be used in the coordination of benefits to identify dependents covered by other employers, thus avoiding multiple employers covering the same dependent. Dependents are grouped by the benefit class and benefit sub-class of the employee claiming the dependent. No totals are displayed on this report. The Benefit Extract Statistics Report lists the total amount of employee records read, employee records written, dependent records read, and dependent records written during the Benefit Roster Extract process. |
On-Request Processing |
Benefits Statement Record Generator Report (HH00100R) |
Executes two programs called HHRD010 and HHA9000 to create the Benefits Statement Summary Report (HHA9000). The program HHRD010 creates the Benefit Statement Extract File that is used by HHA9000 to create the Benefits Statement Summary Report. The Benefits Statement Summary Report provides information to the employee regarding pay summary or amounts, leave balances, employee and employer contributions to benefits. The report is generated by the Benefits Statement Record Generator/Reporter process. This information includes the cost of benefits to both the employee and the employer. |
On-Request Processing |
COBRA Account Statement (HH05000M) |
Generates the COBRA Account Statement and updates the COBRA interface tables. The COBRA Account Statement (HHA5000) report provides details of all current financial activities in a manner similar to account statements from banks. The report is generated by the COBRA Account Statement process. The employee’s name and all plans in which that employee is enrolled is displayed at the header of the report. Each financial action is then listed in order of the posting date. This report provides a method of billing each qualified beneficiary by providing a payment coupon at the bottom of the page. All totals for this report are found in the payment coupon section of the report. |
Quarterly and Monthly Processing |
COBRA Activity Monitoring (HH02000D) |
Generates the COBRA Activity Monitoring (HHA2000) Report and the COBRA Exception Statistic Report. The COBRA Activity Monitoring Report provides an alphabetical listing of all employees who are selected based on their current COBRA status or COBRA stage. The COBRA Activity Monitoring (CBAC) table defines the tracking functions to be performed at each stage of COBRA processing. This report is used to monitor the tracking activities to be performed for all individuals eligible for COBRA. No totals are displayed on this report. The COBRA Exception Statistics (HHR2100) Report lists the total master records read, summary records written, balance exceptions found, report exceptions round, action exceptions found, and system exceptions found during the COBRA Billing Generation process. |
Nightly Processing |
COBRA Billing Generation (HH03000M) |
This job consists of two programs (HHB3000 and HHA3000) that create the COBRA Generated Billing (HHA3000) report. The program HHB3000 reads through the COBRA_MASTER table and creates an extract file. HHA3000 reads the file created from HHB3000 and creates the COBRA Generated Billing Report. The COBRA Generated Billing report provides detail and summary information for all individual payment activity processed in the period since this report was last run. Individuals are grouped by billing cycle. |
Quarterly and Monthly Processing |
COBRA Coverage Ending - HIPAA Program (HH07100M) |
Creates entries on the HIPPA_QUAL_TXN table when an employee’s COBRA Coverage is coming to an end. COBRA Coverage Ending – HIPAA Program selects COBRA_MASTER Table records when the coverage end date is between the Batch Parameter's Start and End Date. |
Quarterly and Monthly Processing |
COBRA Interface Table Updates (HH01000D) |
Updates the COBRA interface tables based on updates made to the database during the processing day. COBRA Interface Table Updates executes the program HHB1000, which reads the COBRA Triggers that were created by Employment Status Maintenance (ESMT), Department Specific and Accounting Data (DEPTA), Dependent Profile (DPND) and Dependents Losing Coverage program updates to the CQTR table. COBRA Interface Table Updates then uses this information to update the COBRA table. |
Nightly Processing |
COBRA Master Report (HH01000R) |
This consists of only one step, which executes the program HHA1000 that produces the COBRA Roster - by Status. The COBRA Roster (by Status) (HHA1000) Report lists all activity that occurred during the COBRA Master Report process. This information is listed by status. This report lists the COBRA ID, recipient name and address, stage, status, relationship to employee, covered by, benefit type and plan, whether or not an override cost applies and the override amount or percent, total billed, total paid, net balance and the last bill date during the specified COBRA status. |
On-Request Processing |
Dependent Coordination of Benefits Report (HH07000R) |
Executes the program HHA7000 that produces the Dependent Coordination of Benefits Report. The Dependent Coordination of Benefits Report lists all dependents who have benefit coverage. The report is generated by the Dependent Coordination of Benefits Report process. These listings can be used in the coordination of benefits to identify dependents covered by other employers, thus avoiding multiple employers covering the same dependent. are grouped by the benefit class and benefit sub-class of the employee claiming the dependent. No totals are displayed on this report. |
On-Request Processing |
Dependents Losing Coverage Report (HB07000M) |
Executes the program HBA7000 that creates the Dependents Losing Coverage (HBA7000) Report and creates Cobra Triggers by updating the COBRA_QUAL_TXN table. The Dependents Approaching Coverage Limit report lists each employee’s dependent(s) whose benefit coverage will expire within thirty days of the report run date. This report is useful for monitoring continued eligibility for coverage under the employee’s benefit plan. No totals are displayed on this report. For sites utilizing the Next Generation Payroll service, the Dependents Losing Coverage Report can be executed as a chain job. The chain job can be run in either Report Only or Report & Expire mode. When the chain job runs in Report Only (R) mode, it generates the Dependents Losing Coverage (HBA7000) Report that lists the dependents that are losing coverage. When the job is run in Report & Expire (E) mode, it generates the HBA7000 report and creates DPBN triggers for each dependent listed in the report. The second part of the chain job, the Process Dependent Benefits Triggers job processes all the DPBN trigger entries created by the first batch job and creates Dependent Benefits (DBPN) transactions to expire the selected dependents enrolled benefits. The third part of the chain job, Multi-thread Load and Submit (DPBN), loads and submits the DPBN transactions created by the second batch job. |
Quarterly and Monthly Processing |
ESS Enrollment Submission |
The ESS Enrollment Submission batch process is used to report on the number of employee created enrollments that are either ready or in progress, to BNRLs, to submit BNRLs, and to clean up the temporary tables. The ESS Enrollment Submission batch process is a chain job that is run on demand and can be run in either Report or Update mode. There are three jobs in the chain. The first job produces a detailed report by department and enrollment type. Each department and enrollment type in the report further breaks out enrollments into three sections. The first section lists the employees who have submitted the enrollment and the enrollment period is closed. These records trigger the creation of a BNRL if the job is run in Update mode. The second section lists the employees who have submitted the enrollment for an enrollment period that is still open. The employee still has time to make changes to the enrollment. The report lists the employees who have completed the enrollment that would produce a BNRL if the job is run in Update mode. The third section lists the employees who have started enrollment but not submitted. The report is produced in both Report and Update mode. When the chain job runs in Update mode, the second job creates BNRLs based on the information on the temporary tables. A flat file is produced with all the data in BNRL transaction format. This job also cleans up the associated temporary tables. Upon successful completion, the System Maintenance Utility (SMU) will be run to load and submit the created BNRLs. |
On-Request Processing |
Payment Activity /Billing Activity Report (HH04000D) |
Generates the COBRA Payment Activity (HHA4000) and COBRA Billing Activity (HHA4500) reports showing payment and billing activity during the processing day. The COBRA Payment Activity Report provides detail and summary information for all payment activity processed in the period specified in the report header. The COBRA Billing Activity Report provides detail and summary totals for all billing activity that occurred in the period since this report was last run. This report could be viewed as the invoice activity related to COBRA. |
Nightly Processing |
Payment Activity Report by Vendor ID - PayCycle (HH04100M) |
The job executes the program HHA4100, which creates a Payment Activity by Vendor ID Extract File (HHA4100.BRCTSEQ) and a report summarizing the payment activity during the paycycle - COBRA Payment Activity by Vendor report. Note: Start date and time on the report is taken from the Last Run Date and Last Run Time on Benefit Report Control (BRCT). The Stop date and time displays the current date and time. |
Paycycle Processing |
Update HIPAA Master Table |
This consists of a program called AMSHRHIPAAInterface, which updates the HIPAA_MASTER Table for HIPPA triggering events. Some examples of HIPPA triggering events are Dependent Coming of Age, Death of Covered Employee, Divorce, Legal Separation, Termination of Employee, Employee Enrolls in Medicare, and COBRA Coverage Ends. |
On Request Processing |