Difference between revisions of "Employee Reports"

From sbv.wiki
Jump to: navigation, search
(Created page with " ==Employee Reports== image:DropDown.bmp ===Duplicate Social Security Numbers=== Find employees that are in the software more than once (i.e. work for you as an employe...")
 
m (Employee Detail (Excel))
 
(41 intermediate revisions by 5 users not shown)
Line 1: Line 1:
 
+
[[image:EmployeeReports.png|right]]
==Employee Reports==
+
[[File:Employee_Reports_3.png|right]]
 
+
[[image:DropDown.bmp]]
+
 
+
 
===Duplicate Social Security Numbers===
 
===Duplicate Social Security Numbers===
  
Line 12: Line 9:
 
Displays the employee name, and their complete address, one line per employee.
 
Displays the employee name, and their complete address, one line per employee.
  
===Employee Comments===
+
===Employee Anniversary===
  
Displays the comments that were used on the employee’s time cards (pay date, punches and other hours), schedules and placeholders. Select the comment types in the Options tab.
+
Displays employees with hire date anniversary within the selected date range. (also available in Excel)
  
===Employee Detail (Excel)===
+
===Employee Birthday===
  
This report is output into an Excel file and provides most of the employee information. This can be used as the starting point for an Excel spreadsheet that will be used for importing information back into the software.
+
Displays employees with birthdays within the selected date range. (also available in Excel)
  
===Employee Journal===
+
===Employee Break Deduction===
  
Displays the entries made in the Journal tab, within the selected date range.
+
Displays the break induction that the employee will incur with their standard schedule and whether the break deduction exceptions will be calculated.
  
===Employee Labels===
+
===Employee Comments===
  
The employee labels report allows you to create labels using a configuration file. The configuration file contains information about the label design, and the information to print on the label. Specify the configuration file in the Options tab. The software will look for the file in the labels subdirectory. If the file is not placed in the labels subdirectory, then you must provide the full path and filename.
+
Displays the comments that were used on the employee’s time cards (pay date, punches and other hours), schedules and placeholders. Select the comment types in the Options tab.
  
'''Sample Template File'''
+
===Employee Contact List===
  
Here is the content of a sample file. The file uses XML tags to provide the label information. You can create or edit these files in Notepad.
+
Displays the employees with their contact information. One employee is displayed per line with employees grouped by the first letter of their last name. (also available in a landscape format)
  
<Settings>
+
===Employee Daily Hours Change===
  
<RowCount>10</RowCount>
+
Displays employees who daily hours changed in the date range selected.
  
<ColumnCount>3</ColumnCount>
+
===Employee Days Worked===
  
<LeftMargin>13</LeftMargin>
+
The number of days an employee has worked since their hire date.
  
<TopMargin>36</TopMargin>
+
===Employee Detail (Excel)===
  
<LabelHeight>72</LabelHeight>
+
This report is output into an Excel file and provides most of the employee information. This can be used as the starting point for an Excel spreadsheet that will be used for importing information back into the software.
  
<LabelWidth>189</LabelWidth>
+
Available options to include in the report (on the Options tab):
  
<ColumnSpacing>9</ColumnSpacing>
+
''Employee Address Information'' - columns 'Address 1', 'Address 2', 'City', 'State', 'Zip', 'Full Address'.
  
<RowSpacing>0</RowSpacing>
+
''Employee Contact Information'' - columns 'Note', 'Home Phone', 'Note', 'Cellular Phone', 'Note', 'Other', 'Note', 'Email', 'Note', 'Emergency Contact Name', 'Emergency Contact Phone #', 'Emergency Contact Relationship'.
  
<LabelLeftMargin>0</LabelLeftMargin>
+
''Employee CHRC Information (Criminal History Record Check)'' -columns 'CHRC Print Submitted', 'CHRC Response Received', 'CHRC Notes', 'CHRC N/A'.
  
<LabelTopMargin>0</LabelTopMargin>
+
''Employee Custom Information''
  
<FontSize>12</FontSize>
+
''Employee Date Information'' -columns 'First Considered Hired Date', 'First Hire Date Comment', 'Hire Date', 'Hire Date Comment', 'Days Worked', 'Termination Date', 'Term. Date Comment', 'Birth Date', 'Union Date'.
  
<DownThenAcross>False</DownThenAcross>
+
''Employee Worked Information'' -columns 'Days Worked', 'Last Day Worked'.
  
<BorderWidth>0</BorderWidth>
+
''Employee Employment Information'' -columns 'SSN', 'Abuse Screen', 'Evaluation Due', 'Employee Handbook Signed', 'Compliance Form Signed', 'Employee Date 3', 'Employee Date 4'.
  
<nowiki> &lt;LabelContent&gt;&lt;![CDATA[&lt;p align='center'&gt;&lt;b&gt;&lt;FullName&gt;&lt;/b&gt;&lt;br&gt;&lt;LaborLevel3Description&gt;&lt;br&gt;&lt;EmployeeID&gt;&lt;/p&gt;]]&gt;&lt;/LabelContent&gt;</nowiki>
+
''Employee Health Information'' -columns 'Physical Received', 'Physical Due', 'PPD History', 'PPD Received', 'PPD Due', 'CXR Received', 'CXR Due', 'TB Screen Received', 'TB Screen Due', 'Measles Not Applicable', 'Measles Received', 'Mumps Received', 'Rubella Received', 'Hepatitis B Received', 'Hepatitis B Due', 'Influenza Date', 'Influenza Type', 'Pneumococcal Received', 'Pneumococcal Declined', 'Health Date 1', 'Health Date 2'.
  
&lt;/Settings&gt;
+
''Employee I-9 Information'' -columns 'I-9 List A Type', 'I-9 List A ID', 'I-9 List A Expiration', 'I-9 List B Type', 'I-9 List B ID', 'I-9 List B Expiration', 'I-9 List C Type', 'I-9 List C ID', 'I-9 List C Expiration'.
  
'''Base Requirements'''
+
''Employee Licensing Information'' -columns 'License Type 1', 'License Number 1', 'License Expiration 1', 'License Issued 1', 'License Type 2', 'License Number 2', 'License Expiration 2', 'License Issued 2', 'CPR Expiration', 'Med Pass Expiration', 'AED Expiration', 'IV Certified Expiration', 'ACLS Expiration', 'PALS Expiration'.
  
The file requires one top-level tag &lt;Settings&gt;&lt;/Settings&gt;.
+
''Employee Main Information'' -columns 'Pay Rule', 'Base Schedule Group', 'Holiday Group', 'Accrual Group', 'Starting Status', 'Starting Status Date', 'Starting Status', 'Comment', 'Ending Status', 'Ending Status Date', 'Ending Status Comment'.
  
Measurements are specified in points. This is the same measurement used for the font size in programs like Microsoft Word or Excel. There are 72 points to one inch.
+
''Employee Start and End Date'' -columns 'Start Date', 'End Date'.
  
'''Allowable Tags'''
+
''Employee Work Pattern'' -columns 'Shift Date', 'Shift Count', 'Daily Hours', 'Shift', 'Shift Type', 'Work Pattern Date', 'Work Pattern Type'.
  
Within the Settings tag, the following tags are allowed. If a tag is not specified, then the default value is used. The default values are based on the Avery 5160 labels, a standard 30 to a page label. Therefore, if you are using 5160 labels, then you can start with just the LabelContent tag. Other tags need to be added to nudge the labels down or across the page to align perfectly when printing.
+
This report can use an Excel template on the Options tab with customized column headers, Hidden columns, and extra columns with custom Excel formulas inside the template. The software will fill in all the columns in original order.
  
RowCount – specifies how many rows of labels per page. The default is 10.
+
===Employee Form Letter===
  
ColumnCount – specifies how many columns of labels per page. The default is 3.
+
A form letter in the style of a mail merge.
  
LeftMargin – specifies the distance from the left edge of the paper to the left edge of the labels in the first column. The default is 14 (0.19").
+
=== Employee Historical Custom Pivot Grid===
  
TopMargin – specifies the distance from the top edge of the paper to the top edge of the labels in the first row. The default is 36 (1/2").
+
===Employee History===
  
LabelHeight – specifies the height of an individual label. The default is 72 (1").
+
Changes to the employee's pay rule, base schedule group, holiday group, accrual group, and labor levels as shown in the history tab.
  
LabelWidth – specifies the width of an individual label. The default is 189 (2 5/8").
+
===Employee Journal===
  
ColumnSpacing – specifies the horizontal distance between labels. This is the distance between the right edge of a label and the left edge of a label in the next column. The default is 9 (0.12").
+
Displays the entries made in the Journal tab, within the selected date range.
  
RowSpacing – specifies the vertical distance between labels. This is the distance between the bottom edge of a label and the top edge of a label in the next row. The default is 0.
+
===[[Employee Labels Report]]===
  
LabelLeftMargin – specifies the distance between the left edge of the label and the label content. The default is 0. Typically, the label content is centered so no margin needs to be specified.
+
Print employee labels using a template file for layout and content.
  
LabelTopMargin – specifies the distance between the top edge of the label and the label content. The default is 18 (1/4"), so that the text is not too close to the top of the label.
+
===Employee Listing===
  
FontSize – specifies the default size of the font used in the label content. The default is 12. The default font used is Helvetica. Fonts are specified in the label content tag (see below).
+
A simple listing of employees.
  
DownThenAcross – specifies that direction in which labels should be printed. The default is false.
+
===Employee Notes===
  
BorderWidth – by setting the border width (1 is sufficient) you can see the actual layout of the labels. This assists you in making adjustments until what prints out aligns with the labels. The default is 0.
+
The notes maintained on an employee in Excel.
  
Label Content
+
===Employee Pivot Grid===
  
The label content tag uses HTML. The standard HTML tags are allowed. In addition to the HTML, placeholders are used to represent what employee information is required.
+
Display the employees in a pivot grid for analysis.
  
<nowiki>The LabelContent value must start with &lt;![CDATA[ and end with ]]&gt;. This is necessary because both the placeholders and HTML use the characters &lt; and &gt; which have a special meaning in an XML file.</nowiki>
+
===Employee Reasons===
  
'''Placeholders'''
+
If using Reasons in the software, this report displays the employees and the reasons provided when editing their punches, hours and schedules.
  
The following placeholders are supported:
+
===Employee Seniority===
  
&lt;EmployeeID&gt; – replaced with the employee's ID.
+
List employees in order of hire date and current shift (slot) level. This report is used to determine the order of eligibility for an available position.
  
&lt;FullName&gt; – replaced with the employee's full name.
+
===Employee Shift History (Excel)===
  
&lt;FirstName&gt; – replaced with the employee's first name.
+
This report is output to an Excel file and displays up to 10 of the employee’s shift history entries, across the sheet.
  
&lt;LastName&gt; – replaced with the employee's last name.
+
===Employee Signatures===
  
&lt;Initial&gt; – is replaced with the employee's initial.
+
Display the employees name, department, and signature.
  
&lt;LaborLevelXID&gt; – replaced with the employee's labor level ID where X is the level (0 based). For example, if you are using 3 labor levels of Company, Department and Floor, then LaborLevel1ID would be replaced with the employee's department ID.
+
===Employee Status===
  
&lt;LaborLevelXDescription&gt; – replaced with the employee's labor level description where X is the level (0 based). For example, if  using 3 labor levels of Company, Department and Floor, then LaborLevel1Description would be replaced with the employee's department description.
+
A simple employee report that shows an employee and their currently determined status.
  
&lt;PayRule&gt; – replaced with the employee's pay rule ID.
+
===Employee Status Change===
  
&lt;BaseScheduleGroup&gt; – replaced with the employee's base schedule group ID.
+
This report shows employees who had a status change within the selected date range. The software allows you to pre-enter the information about employees who are becoming inactive in the future. The software will maintain the employee as active until the inactive date has been passed and the employee has been paid.
  
&lt;HolidayGroup&gt; – replaced with the employee's holiday group ID.
+
Please note that this report will only show if the employee status on the start date of the report is different then the employee status on the end date of the report. Employees who were hired after the start date and terminated before the end date will not display on the report.
  
&lt;SocialSecurityNumber&gt; – replaced with the employee's SSN (if the user is authorized to see SSNs).
+
===Employee Status Count===
  
&lt;ShiftCount&gt; – replaced with the employee's current shift count.
+
Provides totals on employees based on status and dates using an Excel file as a template.  
  
&lt;DailyHours&gt; – replaced with the employee's current daily hours.
+
This report can be used for the [[Schedule P - Medicaid Cost Report - Staff Turnover RHCF -4]].
  
'''Formatting'''
+
=== Employee Status History===
  
The formatting allows the use of simple HTML. The HTML tags are not case sensitive. The following HTML tags can be used:
+
The employee's status history within the selected date range.  
  
&lt;B&gt; – bold. E.g., this is &lt;B&gt;bold&lt;/B&gt; text.
 
  
&lt;I&gt; – italic. E.g., this is in &lt;I&gt;italics&lt;I&gt;.
+
== See Also ==
  
&lt;U&gt; – underline. E.g. this is &lt;U&gt;underlined&lt;/U&gt;.
+
* [[Reports]]
 
+
&lt;P&gt; – paragraph. The paragraph tag allows for a number of attributes. The most common attribute is align. E.g., &lt;p align='center'&gt;This text is centered&lt;/p&gt;. The allowable values for align are left, right, center and justify.
+
 
+
&lt;BR&gt; – line break.
+
 
+
&lt;Font&gt; – the font tag allows for a number of attributes:
+
 
+
Color, e.g. I am &lt;font color='FF0000'&gt;red&lt;/font&gt; text.
+
 
+
Face, e.g. I am &lt;font face='Times'&gt;Times&lt;/font&gt; text. The allowable fonts are Times, Helvetica, Courier, Symbol and Zapf Dingbats. Helvetica is the default font for the labels.
+
 
+
Size – specifies the HTML font size for the text. This is mapped to a point size internally (0 = 6 points, 1 = 8 points, 2 = 10 points, 3 = 12 points, 4 = 14 points, 5 = 18 points, 6 = 24 points, 7 = 36 points).
+
 
+
PointSize – specifies the size of the text in points. The default point size is 12.
+
 
+
'''Example'''
+
 
+
<nowiki>&lt;LabelContent&gt;&lt;![CDATA[&lt;p align='center'&gt;&lt;b&gt;&lt;FullName&gt;&lt;/b&gt;&lt;br&gt;&lt;LaborLevel3Description&gt;&lt;br&gt;&lt;EmployeeID&gt;&lt;/p&gt;]]&gt;&lt;/LabelContent&gt;</nowiki>
+
 
+
The actual label content information is &lt;p align='center'&gt;&lt;b&gt;&lt;FullName&gt;&lt;/b&gt;&lt;br&gt;&lt;LaborLevel3Description&gt;&lt;br&gt;&lt;EmployeeID&gt;&lt;/p&gt;
+
 
+
The complete content is surrounded by a &lt;p&gt; tag using the align attribute with a value of center. Therefore, the complete label is centered.
+
 
+
The employee's full name is displayed in bold text followed by a line break (&lt;br&gt;).
+
 
+
The description of the 4th labor level is displayed followed by a line break.
+
 
+
The employee ID will be on the third line.
+
 
+
===Employee Contact List===
+
 
+
Displays the employees with their contact information. One employee is displayed per line with employees grouped by the first letter of their last name.
+
 
+
===Employee Reasons===
+
 
+
If using Reasons in the software, this report displays the employees and the reasons provided when editing their punches, hours and schedules.
+
 
+
===Employee Shift History (Excel)===
+
 
+
This report is output to an Excel file and displays up to 10 of the employee’s shift history entries, across the sheet.
+
 
+
===Employee Seniority===
+
 
+
List employees in order of hire date and current shift (slot) level. This report is used to determine the order of eligibility for an available position.
+
 
+
===Employee Status===
+
 
+
A simple employee report that shows an employee and their currently determined status.
+
 
+
===Employee Status Change===
+
 
+
This report shows employees who had a status change within the selected date range. The software allows you to pre-enter the information about employees who are becoming inactive in the future. The software will maintain the employee as active until the inactive date has been passed and the employee has been paid.
+

Latest revision as of 18:41, 27 October 2022

EmployeeReports.png
Employee Reports 3.png

Duplicate Social Security Numbers

Find employees that are in the software more than once (i.e. work for you as an employee and previously worked as agency staff) if you have entered their Social Security Numbers.

Employee Address List

Displays the employee name, and their complete address, one line per employee.

Employee Anniversary

Displays employees with hire date anniversary within the selected date range. (also available in Excel)

Employee Birthday

Displays employees with birthdays within the selected date range. (also available in Excel)

Employee Break Deduction

Displays the break induction that the employee will incur with their standard schedule and whether the break deduction exceptions will be calculated.

Employee Comments

Displays the comments that were used on the employee’s time cards (pay date, punches and other hours), schedules and placeholders. Select the comment types in the Options tab.

Employee Contact List

Displays the employees with their contact information. One employee is displayed per line with employees grouped by the first letter of their last name. (also available in a landscape format)

Employee Daily Hours Change

Displays employees who daily hours changed in the date range selected.

Employee Days Worked

The number of days an employee has worked since their hire date.

Employee Detail (Excel)

This report is output into an Excel file and provides most of the employee information. This can be used as the starting point for an Excel spreadsheet that will be used for importing information back into the software.

Available options to include in the report (on the Options tab):

Employee Address Information - columns 'Address 1', 'Address 2', 'City', 'State', 'Zip', 'Full Address'.

Employee Contact Information - columns 'Note', 'Home Phone', 'Note', 'Cellular Phone', 'Note', 'Other', 'Note', 'Email', 'Note', 'Emergency Contact Name', 'Emergency Contact Phone #', 'Emergency Contact Relationship'.

Employee CHRC Information (Criminal History Record Check) -columns 'CHRC Print Submitted', 'CHRC Response Received', 'CHRC Notes', 'CHRC N/A'.

Employee Custom Information

Employee Date Information -columns 'First Considered Hired Date', 'First Hire Date Comment', 'Hire Date', 'Hire Date Comment', 'Days Worked', 'Termination Date', 'Term. Date Comment', 'Birth Date', 'Union Date'.

Employee Worked Information -columns 'Days Worked', 'Last Day Worked'.

Employee Employment Information -columns 'SSN', 'Abuse Screen', 'Evaluation Due', 'Employee Handbook Signed', 'Compliance Form Signed', 'Employee Date 3', 'Employee Date 4'.

Employee Health Information -columns 'Physical Received', 'Physical Due', 'PPD History', 'PPD Received', 'PPD Due', 'CXR Received', 'CXR Due', 'TB Screen Received', 'TB Screen Due', 'Measles Not Applicable', 'Measles Received', 'Mumps Received', 'Rubella Received', 'Hepatitis B Received', 'Hepatitis B Due', 'Influenza Date', 'Influenza Type', 'Pneumococcal Received', 'Pneumococcal Declined', 'Health Date 1', 'Health Date 2'.

Employee I-9 Information -columns 'I-9 List A Type', 'I-9 List A ID', 'I-9 List A Expiration', 'I-9 List B Type', 'I-9 List B ID', 'I-9 List B Expiration', 'I-9 List C Type', 'I-9 List C ID', 'I-9 List C Expiration'.

Employee Licensing Information -columns 'License Type 1', 'License Number 1', 'License Expiration 1', 'License Issued 1', 'License Type 2', 'License Number 2', 'License Expiration 2', 'License Issued 2', 'CPR Expiration', 'Med Pass Expiration', 'AED Expiration', 'IV Certified Expiration', 'ACLS Expiration', 'PALS Expiration'.

Employee Main Information -columns 'Pay Rule', 'Base Schedule Group', 'Holiday Group', 'Accrual Group', 'Starting Status', 'Starting Status Date', 'Starting Status', 'Comment', 'Ending Status', 'Ending Status Date', 'Ending Status Comment'.

Employee Start and End Date -columns 'Start Date', 'End Date'.

Employee Work Pattern -columns 'Shift Date', 'Shift Count', 'Daily Hours', 'Shift', 'Shift Type', 'Work Pattern Date', 'Work Pattern Type'.

This report can use an Excel template on the Options tab with customized column headers, Hidden columns, and extra columns with custom Excel formulas inside the template. The software will fill in all the columns in original order.

Employee Form Letter

A form letter in the style of a mail merge.

Employee Historical Custom Pivot Grid

Employee History

Changes to the employee's pay rule, base schedule group, holiday group, accrual group, and labor levels as shown in the history tab.

Employee Journal

Displays the entries made in the Journal tab, within the selected date range.

Employee Labels Report

Print employee labels using a template file for layout and content.

Employee Listing

A simple listing of employees.

Employee Notes

The notes maintained on an employee in Excel.

Employee Pivot Grid

Display the employees in a pivot grid for analysis.

Employee Reasons

If using Reasons in the software, this report displays the employees and the reasons provided when editing their punches, hours and schedules.

Employee Seniority

List employees in order of hire date and current shift (slot) level. This report is used to determine the order of eligibility for an available position.

Employee Shift History (Excel)

This report is output to an Excel file and displays up to 10 of the employee’s shift history entries, across the sheet.

Employee Signatures

Display the employees name, department, and signature.

Employee Status

A simple employee report that shows an employee and their currently determined status.

Employee Status Change

This report shows employees who had a status change within the selected date range. The software allows you to pre-enter the information about employees who are becoming inactive in the future. The software will maintain the employee as active until the inactive date has been passed and the employee has been paid.

Please note that this report will only show if the employee status on the start date of the report is different then the employee status on the end date of the report. Employees who were hired after the start date and terminated before the end date will not display on the report.

Employee Status Count

Provides totals on employees based on status and dates using an Excel file as a template.

This report can be used for the Schedule P - Medicaid Cost Report - Staff Turnover RHCF -4.

Employee Status History

The employee's status history within the selected date range.


See Also