Employee Records - Excel by jqo16280

VIEWS: 59 PAGES: 4

More Info
									                                         Attachment G - Employee Specifications

                                                                           Comply
ID#                    Requirement                                                Could be                            Explanation
                                                             Yes         No       provided at an
                                                                                  additional cost
                                                            Technical Requirements
      The employee master must have the following
      fields: Last/First/Middle Name, Display Name for
      Schedule, Previous Names, Address, City, State,
      Zip, Official Name, Birth Date, SSN, Race, Sex,
      Shift, Assignment, Sworn or Non-Sworn,
      Employee ID-Internal Identifier, Agency, Hire
      Date, Separation Date, Separation Reason,
      Multiple Contact Numbers to include Home,
      Work, Cell Phone and E-mail Address, Rank and
      Seniority, Status Reason (Active, Inactive, On
      Leave, Probationary, Retired, Trainee, etc.),
      Radio number, Payroll Classification, Payroll ID
      Number, Bargaining Unit, Union Affiliation, Union
      Role, Position Identification Number, Certification
      Type, Certification Expiration Date, Multiple
      Training Types, Multiple Training Expiration
      Dates, Overtime Usage, Emergency Contact
      Information: Name, Address, Phone Numbers,
      Special Remarks, Date Updated, Relationship to
      Employee, and Name of Spouse and/or Children.
      Display Information on Main Screen with
      Photograph.
      Ability to attach employee photographs to the
      employee record and maintain an archive of old
      photographs.




                                              Dane County Dat Collection/Employee Specifications RFP - Attachment G
                                                                                                                                    1
                                                                            Comply
ID#                     Requirement                                                Could be                            Explanation
                                                             Yes          No       provided at an
                                                                                   additional cost
      Ability to display on main employee screen
      employee number, pager number, radio number,
      name, address, phone numbers, shift, division,
      current assignment, start date for that
      assignment, rotation, emergency contacts,
      sworn/non-sworn status, supervisor/non-
      supervisor status, date of birth, SSN, race, sex,
      date of hire, status, separation date, seniority
      rank, employee photo, and date updated.
      Ability to include medical screens: blood type,
      allergies, religion, physician and address.
      Ability through security access levels to control
      who in the agency has access to individual
      employee records.
      Ability to track the status of job classification-
      active, inactive, probationary.
      Ability to track work assignments or position
      changes per employee; promotions, demotions,
      transfers to include start and end dates; total
      days in specific assignments; and store for
      historical analysis.
      Ability to track by FTE designation for a job class
      (0.1 to 1.0).
      Ability to distinguish seniority for two or more
      individuals with identical hire dates.
      Ability to support multiple job classifications for
      each employee with only one primary job
      classification.
      Ability to check for duplicate records when
      creating new records.
      Ability to maintain and enforce bargaining unit
      information and skills by name, number and
      effective dates.



                                               Dane County Dat Collection/Employee Specifications RFP - Attachment G
                                                                                                                                     2
                                                                             Comply
ID#                     Requirement                                                 Could be                            Explanation
                                                              Yes          No       provided at an
                                                                                    additional cost
      Ability to enter an employee's availability
      preferences: work times preferred, or limitations,
      contact preference-phone or email, overtime
      preferences, workplace exclusions.
      Ability to provide employee skills table and
      service time table.
      Ability to associate training requirements to
      position.
      Ability to print envelopes for employee mailings.
      Ability to print seniority lists by department, work
      area, shift, etc.
      Ability to link training table to employee master
      table.
      Employee lists by: name, name and DOB,
      position/assignment, name ID, race, date hired,
      separation date and reason, rotation, shift, social
      security number, division, sworn or non-sworn
      and classification.

      Reporting Functionality

      Ability to create, view and print reports for all
      employees by name, status, department, hire
      date, contact information, employee number, job
      classification, seniority, rotation, assignment,
      work location, date of birth, separation dates,
      promotions, birthdays, employee phone numbers,
      seniority ranking, hire and separation dates, time
      between positions, etc.
      Ability to create custom reports.
      Ability to visually differentiate between various
      scenarios.


                                                Dane County Dat Collection/Employee Specifications RFP - Attachment G
                                                                                                                                      3
                                                                             Comply
ID#                     Requirement                                                 Could be                            Explanation
                                                              Yes          No       provided at an
                                                                                    additional cost
      System provides reports that can be printed and
      exported to text, portable document format
      (PDF), word processor, spreadsheet, and
      database table formats.
      Ability to generate evaluation or certification due
      dates.
      Ability to customize the list of reports available to
      each system user, including standard and custom
      reports.
      Ability to run reports based upon system security
      roles.
      How many standard reports are available?
      Please provide a list of available reports, and
      include examples of some of your standard
      options.




                                                Dane County Dat Collection/Employee Specifications RFP - Attachment G
                                                                                                                                      4

								
To top