Overview of Regulatory Reporting

General Information 

State Regulatory Reporting (RR) creates reports specific to a state based on the format in which the information needs to be submitted to the corresponding State Agency.  The data is extracted from BusinessPLUS to create the submission files. 

Browser Support 

The Regulatory Reporting module uses Silverlight for the web user interface and SQL Server Reporting Services (SSRS) to produce the reports.  Microsoft’s Internet Explorer for Windows, with all service packs applied and scripting enabled for supporting SSRS is required.  The specific version of IE must correspond to the current version supported for BusinessPLUS.  Support for other browsers will continue to evolve, but Internet Explorer is currently the only browser supported within the Regulatory Reporting module.  Other browsers such as Mozilla, Firefox, Chrome, and Safari are not supported browsers for Regulatory Reporting. 

See Microsoft’s web link:  http://msdn.microsoft.com/en-us/library/ms156511(v=sql.90).aspx for more details about browser support in SSRS.  

Silverlight Plugin Requirement 

The Silverlight Browser plugin must to be installed on all workstations of users that will be running Regulatory Reports.   See separate document “System Information for Regulatory Reporting” for more details. 

Common Buttons/Features 

On any given report screen, if a field described in a table has an asterisk after it that means the field is required. 

Many screens contain common action buttons, as described below. 

Running Reports 

Each report has its own interface that generally includes sections that are used to identify all the information needed for running any given report. 

Setup 

Under Setup we track all the information needed to configure a given report.   

There are several optional submenus that are different for different report depending on all the options allowed by that report.  These can include, but are not limited to the Site Profile, Report Profile, Additional Setup, Crosswalk Mapping, etc.

Site Profile 

The Site Profile page contains employer or site details.  On clicking Site Profile in any report, a window similar to what appears below will display.  The screen may these and/or other fields on it.  At least one Site profile is required to create most Regulatory reports.

Report Profile 

The Report Profile page holds report-specific data such as certain constant amounts that might be used for calculations during report creation or even direct inputs for certain fields.  The data entered is entity based.    

The Unemployment Insurance Account Number is an example of something that may be on this screen.   

Additional Setup 

The Additional Setup page holds specific setup information from BusinessPLUS, e.g., CDH numbers, Pay Bases, Hour Bases, Accumulators, which are required for report generation.  The data entered is entity based. 

Crosswalk/Mapping 

The Crosswalk page is used to define various mapping of code values between the finance system and Regulatory Reporting.  

The predefined code items appear as a list when the “Crosswalk” screen is loaded.  Crosswalk mapping related to the selected code item can be inserted/modified/deleted.  The fields in the table will vary depending upon the purpose of the codes in the Crosswalk.  Required items will appear in bold when inserting/adding new records. 

To add Crosswalk values, data needs to be entered in the fields as described below. 

Instance 

The Instance page is used to set up/define the various Report Instances.  The report instance contains the Year and Month for a Monthly Report, Year and Quarter for a Quarterly Report and Start and End Dates if the report is for a particular date range.  The report instances need to be configured for the Extract and Load processes.  

To add report instances, data needs to be entered in the fields as described below. 

Submitted to State Agency 

The status of the report instance can either be set from the Report Instance screen or the Submission Process screen. 

Status options: 

• ACTIVE – On addition of a new report instance, the default status will be ACTIVE.  

• LOCKED – On setting the status to LOCKED, any further load operation or changes in the Maintenance screen will not be allowed. 

• SUBMITTED – On submitting the report to the state agency, the status of that report instance has to be set to SUBMITTED and the “Date Submitted” field updated.   When the status is set to SUBMITTED, any further submission operation will not be allowed for that report instance. 

Load  

The Load page is used to extract information from BusinessPLUS and load it into the Maintenance table.   A Report Instance may be run multiple times before the report is submitted.  To completely reload data, click on the “Purge Existing Data” checkbox. 

To load data for an instance of a report, enter data in the fields as described below.

Once the Load process has begun, click the “OK” button to proceed.   

The selected report instance details appear as described below. 

Maintenance 

The Maintenance page shows the Load Process results.  The load will include any generated errors and will display those in the bottom half of the screen.  Data manipulation is allowed on the extracted employee data.

Note:  Long-term data correction must be done in the other report screens or in BusinessPLUS itself.  Data entered or updated in a report instance is good only for that instance. 

In this screen, the following actions are available: 

• Data changes (to data extracted from the report instance into the Maintenance table) 

• Adding records 

• Deleting records 

Note:  Since the Load process can take quite a while to run depending on the information being loaded, look for the “End Package” message type to be sure the Load process has completed and all the information for the instance is included.  You can refresh the screen by moving to another instance or tab and then come back to the instance you want to view.   

To select specific records to view or edit, use the filtering criteria.  Double-click any Maintenance record to edit data in the Maintenance table.  

Note:  Save all existing changes before attempting to: 

• Insert or delete records  

• Sort or filter data 

• Navigate to any other window 

Error Log Viewer 

The area at the bottom of the page displays the error messages logged during load extract and submission package execution. 

The “Error Log By Last” is a drop-down.  If Load is selected, all the Load errors will display.  Similarly, if Submission is selected, all the Submission errors will display. 

The errors include invalid/missing mandatory field values.  These values can be corrected by selecting the record from the error log area (click on it once), then check-mark the “Filter Selected Record” checkbox.  The record will display in the top section of the screen and it may be corrected and saved. 

Clearing the “Filter Selected Record” will cause all the Maintenance records to once again be displayed in the Maintenance grid. 

The generate report icon (far right of the “Error Log By Last” field) will create a separate report based upon which the “Error Log By Last” is selected.  This report can then be saved or printed for reference use. 

Submission 

The Submission page is where the creation of the file to be submitted to the reporting agency occurs. 

To create a report file for submission to the reporting agency, data is entered as described below.   

Notes: 

• Only if the Load is performed on the report instance, the report instance will appear in the Report Instance drop-down list. 

About 

Displays information about the specific report.  This includes the Report Title, Version Information, Source Database, Regulatory Database, and other pertinant information.