Docstoc

Eligibility Requirements for Medicare

Document Sample
Eligibility Requirements for Medicare Powered By Docstoc
					State of Tennessee                                                                                                                     RFP 317.03-134
Project Edison
                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                         10/21/05




    Requirements Matrix Instructions

    Proposers must indicate whether their proposed offering meets the listed requirements by providing a response to each individual requirement
    using the legend that follows. Areas that are grayed out represent information provided to structure or add context to the requirements and a
    response code should not be entered. Any requirements that are left blank, or requirements for which responses other than the responses
    listed below are given, will be evaluated as an "N".

    Y – Standard Function
    The proposed software provides the requested functionality (data entry, inquiry, report, form, etc.) without screen, code, or design changes.
    The proposed product can satisfy the requirement without any modification to the standard baseline software offering. Only use Y if the
    software fully meets the requirement. Vendors should not be tempted to answer “Y” to all questions to ensure higher compliance.

    M – Modification Required
    Screen, code, or design modifications must be made to the standard offering to satisfy the specified requirement. A brief explanation must be
    required to explain any proposed modification. Explanations must be provided in the “Comments” section of the matrix. The explanation must
    include an assessment of the impact of the modifications on system performance. The fixed fee cost proposal must include the cost associated
    with all “M” responses including design, coding, testing, installation, and all other costs associated with the modification.

    N – Cannot Meet Requirement
    The requirement is not available as existing functionality and a modification is not being proposed.

    Q – Query Report/Inquiry
    The proposed solution cannot satisfy the reporting/inquiry requirement in the standard baseline software offering as delivered; however, the
    requirement can be met through the development of a query report using proposed ad hoc reporting tools.




RFP Attachment 6.8                                                     Instructions                                                                 i
State of Tennessee                                                                                                  RFP 317.03-134
Project Edison
                            FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05




                                                  Job Requisition/ Applicant Tracking

                     Applicant Services addresses the management of job requisitions, and the application process,
                     including testing and examinations. In addition, this section includes the capability to:

                           Manage recruiting of both internal and external candidates
                           Manage and process eligibility lists
                           Manage testing requirements and results
                           Support online job postings, applications, resumes, and profiles




                     Additional Information:

                     Certificate of Eligibles: The document or record containing the names of the highest ranking
                     available eligible applicants for a class of positions for consideration by an appointing authority in
                     filling a vacancy.

                     Employment Register: A list of all persons eligible for appointment to a class of positions.

                     Register: A list of names of persons attaining an examination score of seventy (70) or greater for
                     a class of positions.

                     Reduction in Force (RIF): Any job action affecting an employee due to lack of funds, curtailment
                     of work, changes in organizational structure, abolishment or reclassification of positions.
RFP Attachment 6.8                                      Introduction                                                            ii
State of Tennessee                                                                                                  RFP 317.03-134
Project Edison
                           FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05




                     Additional Information:

                     Certificate of Eligibles: The document or record containing the names of the highest ranking
                     available eligible applicants for a class of positions for consideration by an appointing authority in
                     filling a vacancy.

                     Employment Register: A list of all persons eligible for appointment to a class of positions.

                     Register: A list of names of persons attaining an examination score of seventy (70) or greater for
                     a class of positions.

                     Reduction in Force (RIF): Any job action affecting an employee due to lack of funds, curtailment
                     of work, changes in organizational structure, abolishment or reclassification of positions.




RFP Attachment 6.8                                      Introduction                                                            ii
     State of Tennessee                                                                                                                  RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
                                Applicant Services General Requirements
               The system should support the function of recruiting and applicant tracking
               within the State. At a minimum the following broad functions will be
AS    1.00     supported:
                   Creation of authorization requests (i.e. open positions - position
AS    1.01         vacancies)
                   Approval of authorization requests (i.e. open positions - position
AS    1.02         vacancies)
AS    1.03         Tracking of request status
AS    1.04         Tracking of applicants
AS    1.05         Generate eligibility list and registers
AS    1.06         Management of testing and interview process
AS    1.07         Tracking of the interview process
AS    1.08         Review standing on various registers
                   Selecting hard copy or email notifications throughout the entire applicant
AS    1.09         process
AS    1.10         Open and End Dates.
AS    2.00     System prohibits reapplication for a user define period of time.
               This component shall be integrated with other components of the system,
AS    3.00     including :
AS    3.01         Personnel Administration
AS    3.02         Compensation/Classification
AS    3.03         Position Control
As    3.04         Other Internal State Systems.
               All applicant notifications/letters may be by email or US mail based on
AS    4.00     applicant selectable option (self-mailing letter).
AS    4.01         System should allow for multiple page letters.
               Applicant tracking should interface with the following State and external
AS    5.00     systems:
AS    5.01         Drivers License database
AS    5.02         Resume banks
AS    5.03         Professional Licensure.
AS    6.00     Provide applicant self service for the following:
AS    6.01         Completion of online job applications/profile

     RFP Attachment 6.8                                            Applicant Services Requirements                                                   AS1
     State of Tennessee                                                                                                                   RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                               Hours to
   Number                                   System Requirements                                  Response                   Comments                    Modify
AS    6.02        Reviewing outstanding vacancies
AS    6.03        Reviewing application status
AS    6.04        Review standing on various registers
AS    6.05        Resume preparation
AS    6.06        Reviewing location of outstanding vacancies
AS    6.07        Changing of applicant's address
                  System should provide ability for applicants to establish and maintain
                  multiple electronic job applications through the use of an industry-
AS    6.08        standard web browser
                  System should provide self-service resume preparation, posting and job
AS    6.09        application functions
                  System should allow applicants to request reinstatement on a register
                  once dropped, including a comment field to indicate why they believe the
AS    6.10        request to be justified.
               System provides an option for end users to automatically make a position
AS    7.00     available on the web site

               System provides the ability for the end user to identify a future date and have
AS    8.00     the position automatically become available on the website on that date
               System provides the ability to create a job opening and not make the position
AS    9.00     available on the website
               System should be integrated with imaging capability to associate scanned
               data with an applicant allow scanned resume to fall into online application
AS    10.00    format.

AS    10.01       System should allow scanned resume to fall into online application format.
               System should support attachment of comments and other documents
AS    11.00    (excel, word, etc.) to applicant records.
               Support the generation of user defined letters to applicants based on user
AS    12.00    defined selection criteria.
               System should support flexible approval routing/workflow for all system
AS    13.00    events.
                                Job Authorization Requests and Tracking
AS    14.00    Support the following types of job openings:

     RFP Attachment 6.8                                            Applicant Services Requirements                                                    AS2
     State of Tennessee                                                                                                                  RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
AS    14.01        Promotional (intra-departmental)
AS    14.02        Inter-departmental (all State employees)
AS    14.03        Non competitive
AS    14.04        Open competitive (internal and external applicants)
AS    14.05        Layoff
AS    14.06        Transfer
AS    14.07        Rehire.
AS    15.00    System makes job opening information available on a web site.
               System makes job opening information available through an IVR based
AS    16.00    hotline.
AS    17.00    System links posted job vacancies to job descriptions.
               System links agency specific job postings with and/or update DOP job
AS    18.00    postings.
               The system supports applicants having the ability to apply for multiple
AS    19.00    classifications.
AS    20.00    Reduction in Force list included in register list.
AS    21.00    Job openings can be assigned multiple qualified applicants.
AS    22.00    Notify user of existing valid eligibility list when a job opening is created.
AS    23.00    Provide capability to post recruiting needs to a web site by:
AS    23.01        Agency
AS    23.02        Classification
AS    23.03        Location
AS    23.04        Opening Date
AS    23.05        Closing Date
AS    23.06        Position Type (Part-time, Temporary, etc.)
AS    23.07       Minimum qualifications
AS    23.08       Salary range
AS    23.09       Work hours and days
AS    23.10       % of Travel time (If required)
AS    23.11        Special Selection Criteria
AS    23.12        Plans to fill by external or internal appointment
AS    23.13        Comments.
               System provides the ability to link the position and employee records to the
AS    24.00    imaged applications maintained in the ECM system.

     RFP Attachment 6.8                                            Applicant Services Requirements                                                   AS3
     State of Tennessee                                                                                                                   RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                               Hours to
   Number                                   System Requirements                                  Response                   Comments                    Modify
               System provides the ability to include a hyperlink in the position and/or
               employee record(s) that makes the ECM-stored application files accessible
AS    25.00    directly from the system.
               System provides the ability to trigger the systems application review process
               based on the capture of the scanned application in the ECM system.
AS    26.00
               System provides the ability at the conclusion of the process, generate a letter
AS    27.00    notifying the applicant of the decision.
               System provides the ability to commit the decision letter to the ECM system.
AS    28.00
               System provides the capability to link the scanned applications and decision
               notification letter maintained in the ECM system to the ERP record.
AS    29.00
               System provides the capability to include a hyperlink in the employee record
               to the signed evaluation acceptance form stored in the ECM system.
AS    30.00
                                             Applicant Tracking
               System provides an applicant tracking system for both new applicants and
AS    31.00    existing state employee job applicants.
               All applicants are tracked as persons in the HR database using unique
AS    32.00    identifiers.
               System allows interested applicants to create profile(s) for job requisition
AS    33.00    notification based on job class, department, and other pertinent data.
AS    34.00    Records results of offers.
               The system applicant file can be purged or archived by user defined criteria.
AS    35.00
               System provides for user defined application forms (web based) based on
AS    36.00    job classifications on application.
               System allows user to define steps in the hiring process, including non-
AS    37.00    testing steps and to track the status and results of the steps; for example:
                   System supports pre-employment criminal background screening for
                   required positions and State designated sensitive positions by
                   establishing workflow processes to track an applicant's progress through
                   the background screening, recording the information regarding the
AS    37.01        background, medical and psychological check.
     RFP Attachment 6.8                                            Applicant Services Requirements                                                    AS4
     State of Tennessee                                                                                                                  RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
                   System to track an applicant progress and prepare sign off letters as
AS    37.02        appropriate.
                   The system can support scheduling medical appointments (background
                   medical checks) with the available contracted medical facilities.
AS    37.03
                   System supports scheduling psychological appointments (background
                   psychological checks) with the available contracted psychologist.
AS    37.04
AS    37.05        Track results of medical assessments
AS    37.06        Track results of psychological assessments
AS    37.07        Track results of criminal background screening
AS    37.08        Track recruitment costs.
               System shall support the tracking of recruiting prospects, including, but not
AS    38.00    limited to the following:
AS    38.01        Prospect name and identifying information
AS    38.02        Classifications of interest
AS    38.03        History of contacts
AS    38.04        Next contact type (alternate means of contact)
AS    38.05        Next contact date (availability date)
AS    38.06        Veteran's Preference
AS    38.07        Location Interest
AS    38.08        Current state employee
AS    38.09        Comments.
AS    38.10       Education level
AS    38.11       Media Source
AS    38.12       Letter - 2nd means of communication
AS    38.13       Gender (with appropriate security levels)
AS    38.14       Race (with appropriate security levels)
AS    38.15       Age (with appropriate security levels)
               System tracks and reports when applicant is hired with the state and what
AS    39.00    position and department hired into.
               System integrates employee and applicant information with the following
AS    40.00    modules to eliminate duplicate data input:
AS    40.01        Personnel Administration

     RFP Attachment 6.8                                            Applicant Services Requirements                                                   AS5
     State of Tennessee                                                                                                                    RFP # 317.03-134
     Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                               Hours to
   Number                                    System Requirements                                  Response                   Comments                    Modify
AS    40.02       Payroll
AS    40.03       Benefits
AS    40.04       Classification/Compensation.
                                       Testing and Examinations
AS    41.00    System provides for continuous and scheduled testing.

AS    42.00    System provides a zip code search component that identifies the following:
AS    42.01      Closest testing site
AS    42.02      Closest agency
AS    42.03      Directions
AS    43.00    Record testing and hiring process requirements, including:
                  Steps required (written test, appraisal of promotability, rating from
AS    43.01       register, etc.)
AS    43.02       Order of testing steps
AS    43.03       Dates of tests
AS    43.04       Locations of tests.
AS    44.00    System must provide for an unlimited number of testing components.
               System provides for administration of tests by various methods, including:
AS    45.00
AS    45.01        Computer based
AS    45.02        Written
AS    45.03        Oral
AS    45.04        Training and work experience
AS    45.05        Skills based.
               After applications are received, the system must provide for test scheduling
AS    46.00    based on:
AS    46.01        Type of test (written, oral, etc.)
AS    46.02        Location requested
AS    46.03        Test components which must be taken.

               Notify applicant of testing arrangements, including date, time, location,
AS    47.00    logistical information, etc. via mail or email as specified by the applicant.
               Testing component may be specified as general and applicable to many
AS    48.00    positions (typing test) with expiration dates.

     RFP Attachment 6.8                                              Applicant Services Requirements                                                   AS6
     State of Tennessee                                                                                                                   RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                               Hours to
   Number                                   System Requirements                                  Response                   Comments                    Modify
               System stores the test scores of applicants and allows for the transfer of test
AS    49.00    scores for applicants who have applied for multiple exams.
               General components (typing test) may be skipped for individual applicants
AS    50.00    that have passed this step for another application process.
               The system is capable of recording unlimited versions of tests components
AS    51.00    and related answer keys.
               System tracks matching answer keys to valid tests (recorded in the same
               manner as the tests and there can be multiple keys to each test with valid
AS    52.00    dates and person authorizing).
AS    53.00    System will track the following information for each answer key:
AS    53.01        Unique test number that the answer key maps to
AS    53.02        Unique answer key number
AS    53.03        Reference to paper file
AS    53.04        Link to electronic file
AS    53.05        Valid dates
AS    53.06        Person authorizing.
               The system records test data by person, linked to the person's information in
AS    54.00    the system, including:
AS    54.01        Pass / Fail
AS    54.02        Unique test number (version of the test taken)
AS    54.03        Test date and time
AS    54.04        Person or persons conducting the specific test
AS    54.05        Response by question
AS    54.06        Test score
AS    54.07        Location
AS    54.08        Comments.
               System must provide for the processing of the expiration of test scores, at a
AS    55.00    minimum:
AS    55.01        Expires after a user defined amount of time (varying by examination)
AS    55.02        Removes the applicant from the appropriate registers
AS    55.03        Notifies the applicant of the expiration and removal.
               System provides for an exam item bank with lists of numerous questions by
AS    56.00    exam objective.
               System provides a test item analysis feature that computes and displays
AS    57.00    standard statistics including the following:
     RFP Attachment 6.8                                            Applicant Services Requirements                                                    AS7
     State of Tennessee                                                                                                                    RFP # 317.03-134
     Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                               Hours to
   Number                                    System Requirements                                  Response                   Comments                    Modify
AS    57.01        Test score means
AS    57.02        Standard deviations
AS    57.03        Frequency distributions
AS    57.04        Item difficulties
AS    57.05        Point biserial correlations with total score.
                   Response frequency for defined sets of test questions and applicant
AS    57.06        groups.
               Provide ability to exclude questions that are deemed invalid from final scoring
AS    58.00    of tests.
AS    59.00    Provide ability to globally recalculate scores.
               Ability to record multiple scores for the same applicant and the same test.
AS    60.00
               Ability to specify whether the system will use the highest or last test score in
AS    61.00    ranking by the following:
AS    61.01        Globally
AS    61.02        Job class
AS    61.03        Test component
AS    61.04        Applicant.
                                           Merit Hiring Guidelines
               System should automatically record a score in one or more of the following
               ways/elements for each unique test number and grade achievement for
AS    62.00    each unique test component and test set:
AS    62.01        Test number
AS    62.02        Attend (Y/N)
AS    62.03        Method of scoring (time, percentage, count, etc.)
AS    62.04        Time results
AS    62.05        Passing grade
AS    62.06        Skills score
AS    62.07        Raw score (numeric)
AS    62.08        Pass / Fail
AS    62.09        Percentage score
AS    62.10        Interview score
AS    62.11        Physical agility component
AS    62.12        Education Rating

     RFP Attachment 6.8                                             Applicant Services Requirements                                                    AS8
     State of Tennessee                                                                                                                  RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
AS    62.13        Experience Rating
AS    62.14        Other scoring (user defined)
AS    62.15        Comments.
               System should have the capability to create history at a user defined point in
AS    63.00    time (ex: content of application at time of rating).
               System evaluates application data against minimum qualifications for the
               classifications on the application (application and job classifications coded
               using skill and experience codes as defined in Personnel Administration
AS    64.00    requirements).
               System provides ability to capture education and experience on the
               application using skill and experience codes as defined in Personnel
AS    65.00    Administration requirements.
               System provides for recording and calculation of ratings for experience,
AS    66.00    education, etc., at a minimum:
                   Provide user defined "relevance" factors for education and experience.
AS    66.01
AS    66.02        Provide user defined weighting based on age of experience by years.
                   Provide user defined weighting based on number of years of a particular
                   type of experience by year (first year receives x points, second year
AS    66.03        receives y points, etc.).
                   Provide user defined weighting based on number of months of a
                   particular type of experience by month (first month receives x points,
AS    66.04        second month receives y points, etc.).
               System provides the ability to automatically calculate a final earned rating
               (FER) once all testing components (including rating) are completed to enable
               placement on the register for each classification applied for, using user
AS    67.00    defined variables such as:
AS    67.01        Job class
AS    67.02        Component (test, rating, etc.)
AS    67.03        Passing score for component
AS    67.04        Weighting
AS    67.05        Raw score (numeric).
AS    68.00    Automatically recalculate FER's if component tests are retaken
AS    68.01        Job class
AS    68.02        Component (test, rating, etc.)
     RFP Attachment 6.8                                           Applicant Services Requirements                                                    AS9
     State of Tennessee                                                                                                                       RFP # 317.03-134
     Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                    10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

  Reference                                                                                           Vendor                                               Hours to
   Number                                     System Requirements                                    Response                   Comments                    Modify
AS    68.03        Passing score for component
AS    68.04        Weighting
AS    68.05        Raw score (numeric).
               Produce a user definable score letter/notification and/or email notification
AS    69.00    with information such as:
AS    69.01        Component (test, rating, etc.)
AS    69.02        Score
AS    69.03        Score range
AS    69.04        Register rank
AS    69.05        Text (user defined).
               System must be able to match key words used in application against
AS    70.00    minimum qualifications for position(s) applied.
                                   Register and Eligibility List Management
               Register and track all applicants that are eligible for filling a position by class
               (note: the register for a classification is dynamic, changing each time a new
AS    71.00    applicant completes the testing process for the classification).
               Allow applicants to review testing components necessary for register
AS    72.00    placement.
               System will calculate applicants score automatically upon completion of
AS    73.00    application if all requirements are met.
               Allow a preview list to be created for an approved opening by the following
AS    74.00    categories, ordered by user defined criteria:
AS    74.01        Promotional
AS    74.02        Transfer
AS    74.03        Rehire
AS    74.04        Open competitive (appointment)
AS    74.05        Non-competitive (all have the same ranking)
AS    74.06        Layoff.
               Provide for the filtering of lists for promotional registers by current agency
               organization of employees (statewide, department-wide, division, work unit,
AS    75.00    etc.).




     RFP Attachment 6.8                                               Applicant Services Requirements                                                    AS10
     State of Tennessee                                                                                                                       RFP # 317.03-134
     Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                     10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

  Reference                                                                                           Vendor                                               Hours to
   Number                                     System Requirements                                    Response                   Comments                    Modify
                The following adjustments will be included when creating the list for an
               approved opening based on user parameters, in which adjustments to apply
               to which types of openings (final ranking is based on test/ranking scores plus
AS    76.00    adjustment points):
AS    76.01        Apply veterans preference points
AS    76.02        Performance bonus
AS    76.03        Disabled
AS    76.04        Other user specified.
AS    76.05        System must include different register types with edits.
AS    77.00    Must have the ability to access job application from register table.
               System should have the capability of automatically rating the applicant for
AS    78.00    placement on register list.
AS    79.00    Provide lists to be filtered by approved parameters, including:
                   Geographic breakdown (County, Area, Region, Judicial district, District,
AS    79.01        Division and Statewide)
AS    79.02        County of preference
AS    79.03        Legal county (county of residence)
AS    79.04        Work County
AS    79.05        Agency organization.
                                          SELECTIVE CERTIFICATION
               System must allow for the specification of list hierarchy such that certain
               types of applicants are always evaluated first (ex - all of those that have been
AS    80.00    laid off are considered before other candidates).
               System must specify rules for selecting candidates for inclusion on the
AS    81.00    register (list):
AS    81.01        Minimum number
AS    81.02        All of a particular category (layoffs, disabled, etc.)
AS    81.03        Other user specified
AS    81.04        Combinations.
               Once a list is satisfactory to the hiring authority, allow the list and supporting
               data to be saved and uniquely identified for use in interviews and
AS    82.00    appointments (Certificate of Eligibles).
               Provide the ability to associate a Certificate of Eligibles with a position(s) that
AS    83.00    are to be filled.

     RFP Attachment 6.8                                              Applicant Services Requirements                                                     AS11
     State of Tennessee                                                                                                                   RFP # 317.03-134
     Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                               Hours to
   Number                                    System Requirements                                 Response                   Comments                    Modify
               System must provide the ability to record offers made and candidate
AS    84.00    responses.
               System must provide the ability for closure of uniquely identified list due to:
AS    85.00
AS    85.01        Expiration after user defined time period
AS    85.02        Position(s) have been filled (working the list)
AS    85.03        Cancellation of list by appointing authority.
               System must provide the ability for the notification of applicants removed
AS    86.00    from the list and the reason for removal.
               System must provide the ability to generate modifiable interview letters to
AS    87.00    applicants.
               System must provide the ability for the reinstatement of applicants to the list
AS    88.00    once they have been removed.
               System must provide for the generation of letters to candidates who have
AS    89.00    been interviewed with user defined format and selection criteria.
               System must provide for tracking and audit of all actions taken during the
               appointment process (working the register), including user defined codes for
AS    90.00    results.
               System must provide user defined rules for monitoring the appointment of
               candidates that meet the rules for appointment from the Certificate. At a
AS    91.00    minimum:
AS    91.01        Register type
AS    91.02        Picking required from the top x candidates and ties
                   Allows moving down the register once candidates are considered (may
AS    91.03        be eliminated for user defined reasons)
AS    91.04        Allows moving down the register once candidates are appointed
                   Recognize when applicants have received three considerations on the
AS    91.05        same register
                   Provide for correction of errors during the appointment process and
AS    91.06        reissue of applicant letters if required
AS    91.07        System allows post audit with editing capabilities.
               System must track the status of all uniquely created lists (Certificate of
AS    92.00    Eligibles).
AS    93.00    Notify agency x days before a Certificate expires.

     RFP Attachment 6.8                                             Applicant Services Requirements                                                  AS12
     State of Tennessee                                                                                                                  RFP # 317.03-134
     Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify

               System allows for identification on register of applicants "not recommended
AS    94.00    for rehire within agency"
               System allows for identification on register of applicants "not recommended
AS    95.00    for rehire within state government"
               System allows the removal of applicants from a list for user defined reasons.
AS    96.00
               System notifies applicants of removal from register, including the reason for
AS    97.00    the removal via email or US mail.
AS    98.00    System should provide the ability to correct coding on worked registers.
AS    99.00    System provides for the removal of applicants from all lists.
                                     Reporting and Query Requirements
               The system will provide for online access to all applicant and position data
AS    100.00   with appropriate security.
               System will include a flexible report writing/query capability that will allow
               inquiry on any field in any combination and allow reports to be formatted
AS    101.00   easily by user personnel.
AS    102.00   System provides listings of vacant/frozen/unfunded positions as required.
AS    103.00   System prints mailing lists and/or labels for applicant correspondence.
               System prints letters or send emails for employee/applicant correspondence.
AS    104.00
             System produces statistical reports reflecting historical EEO data on
AS    105.00 applicants.

               Systems will provide a report that details register responses by applicant.
AS    106.00
             System should have the capability to produce multiple formats for each
AS    107.00 register (list) (ex: by city, county, etc.).
             System tracks and reports number of applicants applying for positions by
AS    108.00 title.




     RFP Attachment 6.8                                            Applicant Services Requirements                                                  AS13
State of Tennessee                                                                                                RFP 317.03-134
Project Edison
                                  FUNCTIONAL REQUIREMENTS MATRIX                                                        10/21/05




                                                             Benefits

                Benefit Administration addresses the comprehensive administration of multiple employee benefit,
                retirement and insurance plans. In addition, this section addresses the ability to:

                        Maintain multiple eligibility rules
                        Maintain eligibility dates for different plans based on different rules
                        Track eligibility and enrollment of dependents
                        Maintain beneficiary information
                        Calculate employer and employee costs
                        Provide online (Web based or kiosks) and telephone benefit enrollment
                        Interface with benefit providers and third-party administrators




                Additional Information:




RFP Attachment 6.8                                           Introduction                                                     ii
      State of Tennessee                                                                                                                    RFP # 317.03-134
      Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

     Reference                                                                                      Vendor                                             Hours to
      Number                                   System Requirements                                 Response                   Comments                  Modify
                                 Benefits Administration General Requirements
                  HR records for Central State employees (which does not include any of the
                  groups in BA 2.00) will be utilized in the ERP Benefits Module, with
BA        1.00    integration of insurance related records to the Insurance Module.
                  K-12 school district participants, local government participants, and higher
                  education participants, retirees, certain former agencies previously
                  associated with the State and certain other former participants records will
                  not be maintained in the ERP Payroll/Personnel (including Benefits
                  Administration) modules. This group of participants insurance only related
BA        2.00    records will be maintain within the Insurance Module.
                  Insurance must provide functional integration with at least the following
BA        3.00    system components for all Participants:
BA        3.01        Personnel Administration
BA        3.02        Position Control
BA        3.03        Budget Development
BA        3.04        Payroll
BA        3.05        Financial Information
BA        3.06        Accounts Payable
BA        3.07        Accounts Receivable
BA        3.08        General Ledger
BA        3.09        Cash Management
BA        3.10        Insurance
                  In addition to the above listed components that are integrated with employee
                  Benefits, a number of State systems and internal and external organizations
                  will be interfaced, both online and in batch, to the system:
BA        4.00
BA        4.01       Retirement system (CRIS - Retired Employees Data Base)
BA        4.02       Retirement System (TRACS - Active Employee Database)
BA        4.03       Revenue
BA        4.04       TENNCARE
BA        4.05       Worker's Comp Benefits Administrator (Sedgwick James)
BA        4.06       Center for Medicare and Medicaid services
BA        4.07       Other external employers
BA        4.08       Vendors
BA        5.00    Provide information to third party administrators for:
BA        5.01       utilization

      RFP Attachment 6.8                                             Benefits Administration Requirements                                               BA1
      State of Tennessee                                                                                                                      RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

     Reference                                                                                        Vendor                                             Hours to
      Number                                   System Requirements                                   Response                   Comments                  Modify
BA        5.02        demographic data
BA        5.03        Deferred Compensation (401k, 457)

BA        6.00    System should allow update interface files by third party administrators for:
BA        6.01        Resource planning
BA        6.02        Update programs
BA        6.03        Establish dependent eligibility and enrollment
BA        6.04        Update of deduction amounts
BA        6.05        Other user defined parameters
                  System should track employee data to disallow duplicate coverage within the
                  same plan and/or program. (Employee can be the head of contract in State
                  plan and Local Gov. or Local Ed. plan but can not be a HOC and a
BA        7.00    dependent the same plan).
                  System should track dependent data to disallow duplicate coverage within
                  the same plan and/or program (Dependents can be covered in the State plan
                  and Local Gov. or Local Ed. plan but not twice under the same plan).
BA        8.00
                  System should track current and historical beneficiary information (including
BA        9.00    multiple beneficiaries per product).
                  System should have the ability to enter and track dual and / or temporary
BA        10.00   changes in employee's status and track the corresponding accruals.
                  System should maintain complete insurance transaction history by participant
                  (including premium payment history and history with multiple employers) with
BA        11.00   date and time stamp.
                  System should provide user defined multi-step workflow for all benefits
BA        12.00   administration events.
BA        13.00   System must meet requirements of COBRA.
BA        14.00   System must meet requirements of HIPAA.
                  System should allow Benefit transactions to be retroactive, subject to user
BA        15.00   defined edits by transaction type.
                  System should provide the ability to cancel transactions (rather than reverse
BA        16.00   and reenter) subject to pre-defined edit criteria and security.
                  System should provide a flexible notification capability that allows the user to
                  define content, rules for production, and distribution method (email or US
BA        17.00   mail).


      RFP Attachment 6.8                                             Benefits Administration Requirements                                                 BA2
      State of Tennessee                                                                                                                     RFP # 317.03-134
      Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                       N = Cannot Meet Requirement
M = Modification Required                                                                                      Q = Custom Report/Query

     Reference                                                                                       Vendor                                             Hours to
      Number                                   System Requirements                                  Response                   Comments                  Modify
                  System should record in the employees history, the fact that a notification
BA        18.00   was sent.
                  System should allow copies of notifications to be sent to benefits
BA        19.00   administrator based on user option.
                  System should allow copies of notifications to be retrievable by benefits
BA        20.00   administration based on user option.
                  System should provide ability to provide comments for employees
BA        21.00   dependents, vendors, etc. records
                  System should provide for user defined batch processing for various control
BA        22.00   purposes, such as but not limited to:
BA        22.01       Checking the validity of current eligibility information.
BA        22.02       Check for duplicate SSN's.
BA        22.03       Applying premium updates.
                      Automatically changing enrollment coverage from family to single when
BA        22.04       no dependents are enrolled.
                  System should provide browser based employee self service capability for
BA        23.00   the following benefits administration functions:
BA        23.01       Current benefits elections and costs
BA        23.02       Explanation of benefit options
                      Enrollment for all benefits (including insurance, retirement (multiple
                      plans), etc.) for both employees and dependents consistent with eligibility
BA        23.03       rules defined in Benefits Administration.
BA        23.04       Maintenance of dependent information.
BA        23.05       Benefit package pricing worksheet for employee costs.
BA        23.06       Benefit eligibility checking at time of enrollment.
BA        23.07       Enrollment options (e.g., cost of two party vs. family coverage).
BA        23.08       Review of premiums paid and current premiums due.
                      Link to third party administrators as appropriate to provide detailed
BA        23.09       information concerning program participation.
BA        23.10       View & update flexible expenditure account.
BA        23.11       Ability to provide a third party link to employee's self service options.
BA        24.00   System should provide to nullify transactions:
BA        24.01       If updates have occurred nullified transactions should remain in history
BA        24.02       If updates have not occurred nullify transaction and delete record.



      RFP Attachment 6.8                                             Benefits Administration Requirements                                                BA3
      State of Tennessee                                                                                                                   RFP # 317.03-134
      Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

     Reference                                                                                     Vendor                                             Hours to
      Number                                  System Requirements                                 Response                   Comments                  Modify
                  System should be compatible with Interactive Voice Response and TTY
                  systems to allow employees to establish and modify specified enrollment
BA        25.00   information.
                  System should provide for scanning abilities for submitting required
BA        26.00   documentation and link to coordinating fields.
                  System should provide passive and returnable codes HELP screens must be
          27.00
BA                available to the users.
                  System should provide the ability to inquire on the status of a pending
          28.00
BA                transaction, both online and through ESS.
                  System should, with TL module integration, automatically notify the agency's
BA        29.00   benefits staff when an employee has been on leave without pay.
                                             Benefit Plan Administration
                  System should support various types of benefit plans, including, but not
BA        30.00   limited to the following:
BA        30.01        Deferred Compensation (401k, 457)
BA        30.02        401(k) Loan Repayments
BA        30.03        Unemployment Insurance
BA        30.04        Medical
BA        30.05        Life/accident Insurance
BA        30.06        Dental
BA        30.07        Flexible spending accounts
BA        30.08        Optional life/accident insurance
BA        30.09        Long term disability
BA        30.10        Short term disability
BA        30.11        Day Care
BA        30.12        Retirement
BA        30.13        Long term care
BA        30.14        Medicare supplement
BA        30.15        Wellness
BA        30.16         Employee Assistance Program
BA        30.17        Various new benefit plans as may be approved in the future

                  System should have data defaults that comply with Civil Service Rules, Court
BA        31.00   Orders, State law, Federal requirements and State Policies & Procedures.
                  System should support multiple versions of benefit plans. Plan versions are
BA        32.00   processed based on effective date.

      RFP Attachment 6.8                                            Benefits Administration Requirements                                               BA4
      State of Tennessee                                                                                                                    RFP # 317.03-134
      Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

     Reference                                                                                      Vendor                                             Hours to
      Number                                  System Requirements                                  Response                   Comments                  Modify
                  System should provide for cafeteria benefit plans and the specification of
BA        33.00   whether a particular benefit type (see above) is part of a cafeteria plan.
                  System should provide ESS for requesting reimbursements for eligible
BA        34.00   medical/child care expenses and scanning required documents.
                  System should provide ability to approve and reimburse eligible medical,
BA        35.00   dental and dependent daycare cost.
                  System should provide the ability to record on-line enrollment/changes by
BA        36.00   plan year in medical/child care reimbursements accounts.
                  System should provide enrollment/change notification to employees via email
BA        37.00   or letter.
                  System should provide the ability for employee or department to view
BA        38.00   benefits enrollment data based on security access.
                  System should provide the ability to confirm enrollment/changes in benefits to
BA        39.00   employee via US Postal or email as defined by user.
                  System should provide the ability to display potential tax savings on flex
BA        40.00   expenditure accounts.
                  System should provide the ability to record/change online reimbursement
BA        41.00   request for employees by plan year.
                  System should provide the ability to image and attach required
BA        42.00   documentation for enrollments, changes or request for reimbursements.
                  System should provide the ability to validate and confirm reimbursement to
BA        43.00   employees via US Postal or email as defined by user.
                  System should provide the ability to enter adjustment transaction for
BA        44.00   reimbursements.
                  System should provide the ability for employee or department to view
BA        45.00   reimbursements based on user security.
                  System should provide the ability to interface with the payroll process to
                  derive reductions/reimbursements based on reimbursement rules and
BA        46.00   availability.
                  System should provide the ability to generate online voucher request for
BA        47.00   reimbursement refunds outside the payroll process.
                  System should provide the ability to handle missed premiums by pro-rating
BA        48.00   the deduction of the remaining schedule of the plan year.
                  System should provide the ability to handle missed premiums by a one-time
BA        49.00   catch-up method.


      RFP Attachment 6.8                                            Benefits Administration Requirements                                                BA5
      State of Tennessee                                                                                                                    RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

     Reference                                                                                      Vendor                                             Hours to
      Number                                   System Requirements                                 Response                   Comments                  Modify
                  System should provide the ability to report period/year to date activities in
BA        50.00   flex via US Postal or email as specified by user.
                  System should provide the ability to notify employee of a prior plan year
                  balance available for reimbursement and the pending deadlines via US
BA        51.00   Postal or email as specified by user.
                  System should provide a online year to date summary of reimbursement
BA        52.00   accounts with pending activity.
                  System should provide the ability to notify employees on or returning from
                  leave of absence concerning benefit restrictions or limitation and re-
BA        53.00   enrollment.
                  System should provide a friendly end user query tool with remote print and
BA        54.00   download option with user defined security access.
                  System should track flexible claim processing to prevent duplicate payments.
BA        55.00
                  System should allow the ability to roll over pre-tax flexible expenditures
BA        56.00   dollars past the predefined grace period.
                  System should track demographic and enrollment data for analysis of specific
BA        57.00   plans.
                  System should provide the ability to change groups of employees from one
BA        58.00   program to another.
                  System should provide the ability to terminate groups of employees and
BA        59.00   maintain history.
                  System should provide the ability to backup system data in the event of a
BA        60.00   disaster.
                  System should provide the ability for employees to self enroll and update
                  status in seminars and special events for wellness and employee assistance
BA        61.00   programs.
                  System should provide the ability to add and accurately process premiums
                  for short term enrollments. (COBRA enrollment for one or two month period).
BA        62.00
                  System should provide the ability to identify and report all employees that
BA        63.00   were previously associated with a particular agency.
                  System should provide the option to elect or not elect pre-tax medical &
BA        64.00   dental insurance premium deductions.
                  System should provide detailed data for user approved refund or
BA        65.00   reimbursement amounts and the ability to view related data:

      RFP Attachment 6.8                                             Benefits Administration Requirements                                               BA6
      State of Tennessee                                                                                                                       RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                         N = Cannot Meet Requirement
M = Modification Required                                                                                        Q = Custom Report/Query

     Reference                                                                                         Vendor                                             Hours to
      Number                                    System Requirements                                   Response                   Comments                  Modify
BA        65.01    Associated collection
BA        65.02    Amount of refund/reimbursement
BA        65.03    Status and dates
BA        65.04    Recipients
BA        65.05    Type of payment, ACH, check, etc.
BA        66.00   System should provide the ability to use debit cards for flex expenditures.
BA        67.00   System should automatically notify employees of:
BA        67.01      Program eligibility
BA        67.02      Program terminations or changes
BA        67.03      Dependents ineligibility
BA        67.04      COBRA eligible for Head of Contract or dependent
BA        68.00   System should provide ESS inquiry to all benefit related data.
                  System should provide the ability for the Benefits module to generate
BA        69.00   Accounting entries for:
BA        69.01      Recording monies received as unearned.
                     Reduce unearned monies and recognize revenue as coverage is
BA        69.02      certified.

BA        69.03       Reduce revenue and record unearned revenue for retroactive payments
                  System should provide the ability to post a collection to an individuals
BA        70.00   account not to a specific program or benefit type.
BA        71.00   System should use monies according to user defined priority
                  System should be integrated with Cash Management for processing
BA        72.00   insufficient checks or ACH collections.
                  System should provide the user the ability to enter all elected benefits at one
BA        73.00   time or separate time if within the enrollment time frame
                  System should provide the ability to enter effective dates of enrollment
                  across plan years or premium years. (Ex: Effective 1/1/ each year there are
                  new premium rates, system should provide the ability to enter an effective
                  date of 12/1 and calculate both the old premium and new premium.)
BA        74.00
                  System should provide the ability to add, change or terminate coverage with
BA        75.00   a future effective date.
                  System should provide the ability to transfer individuals with a future effective
BA        76.00   date.


      RFP Attachment 6.8                                              Benefits Administration Requirements                                                 BA7
      State of Tennessee                                                                                                                       RFP # 317.03-134
      Project Edison
                                                       FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                         N = Cannot Meet Requirement
M = Modification Required                                                                                        Q = Custom Report/Query

     Reference                                                                                         Vendor                                             Hours to
      Number                                    System Requirements                                   Response                   Comments                  Modify
                  System should provide the ability to add COBRA dental coverage and
                  automatically calculate the correct begin date, end date, and amount due, for
BA        77.00   a retiring individual.
BA        78.00   System should provide the ability for same day error corrections.
                  System should be able to produce multiple (20 or more) vendor interface files
BA        79.00   daily.
                  System should provide the ability to correct an individuals enrollment and
BA        80.00   issue a corrected billing statement (invoice) if applicable.
                  System should maintain all notifications for a period as determined by the
BA        81.00   Benefits Administrator
                                                Benefit Plan Eligibility
BA        82.00   System should create ACH files in PPD consumer format.
                  System should maintain multiple eligibility dates for different benefit plans
BA        83.00   based on different rules for the plan and the employee.
                  System should be fully integrated with PA and TA transactions to determine
                  employee's eligibility/ineligibility, enrollment effective/end dates as well as
BA        84.00   premium amounts due from employee and/or employer.
                  System should maintain eligibility rules by benefit plan with variables
BA        85.00   including:
BA        85.01       Plan type
BA        85.02       Group
BA        85.03       Required employee's status for coverage
BA        85.04       Geographic coverage
BA        85.05       Waiting period
BA        85.06       Minimum hours worked
BA        85.07       Dependent coverage
BA        85.08       Which dependents are eligible
BA        85.09       Split coverage
BA        85.10       Medicare eligibility
BA        85.11       COBRA requirements
BA        85.12       HIPAA requirements
                      Ability to enroll during annual enrollment (yes, no, only if in another plan)
BA        85.13
BA        85.14       Prior plan requirement (which plans qualify)
BA        85.15       May continue on leave without pay
BA        85.16       How long eligible after leave begins

      RFP Attachment 6.8                                              Benefits Administration Requirements                                                 BA8
      State of Tennessee                                                                                                                    RFP # 317.03-134
      Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

     Reference                                                                                      Vendor                                             Hours to
      Number                                   System Requirements                                 Response                   Comments                  Modify
BA        85.17        Type of leave (military, workers compensation, etc..)
BA        85.18        May continue if disabled
BA        85.19        Dependents eligible after employee's death
BA        85.20        How long eligible after employee's death
BA        85.21        Re-enrollment after return from leave without pay
BA        85.22        Re-enrollment period
BA        85.23        Re-enrollment rules after return from military leave
BA        85.24        Continue after retirement
BA        85.25        Employment status (full time, part time, etc.)
BA        85.26        Job class
BA        85.27        Effective date
BA        85.28        Hire date
BA        85.29        Age of employee
BA        85.30        Age of dependents
BA        85.31        Hours worked by period
BA        85.32        Wage base
BA        85.33        Track leave without pay for limitations
BA        85.34        Chart of account fields
BA        85.35        Over-ride of eligibility with proper security
                       Flexible Spending Account eligibility as defined in Internal Revenue Code
BA        85.36        Section 125 and Section 129.
                       System must monitor and prevent overages from employee contribution
BA        85.37        on deferred compensation based on federal guideline.
BA        85.38        Eligibility for match in 401(k) as determined by T.C.A. 8-25-303.
                       System must meet all other State and Federal laws, policies and
                       guidelines pertaining to Flexible Spending Accounts and Deferred
BA        85.39        Compensation.
BA        85.40        All other user defined variables
                  System should provide for various types of enrollment consistent with
BA        86.00   eligibility rules, including:
                       Enrollment of new hires and rehires within a user defined period of hire
BA        86.01        date.
BA        86.02        Annual enrollment transfer period.
BA        86.03        Late enrollment with medical underwriting.
BA        86.04        Special enrollment due to HIPAA qualifying event.


      RFP Attachment 6.8                                             Benefits Administration Requirements                                               BA9
      State of Tennessee                                                                                                                      RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

     Reference                                                                                        Vendor                                             Hours to
      Number                                   System Requirements                                   Response                   Comments                  Modify
                  System should provide Insurance Administration the ability to apply status’s
BA        87.00   to insurance programs:
                       “open” - in this case, employees may be enrolled in this program as of
                       the effective date of the program. All normal processing may be done
BA        87.01        against “open” programs, including retroactive transactions.
                       “closed but active” - in this status, employees cannot be newly enrolled in
                       the program after the close effective date, however all normal
                       processing, including retroactive transactions may be carried out against
                       the program. Interfaces for a user specified period after the program
BA        87.02        becomes inactive.
                       “inactive” - inactive programs may not have any processing done against
BA        87.03        them.
                  System should provide detailed notifications to employees of benefit eligibility
                  when eligibility begins or changes and as part of the annual enrollment
BA        88.00   /transfer process (email and letter).
                  System should provide notification (email or letter) to benefits administration
BA        89.00   that employee's eligibility is beginning or changing.
                  System should process split eligibility (both spouses both work for the State)
                  for certain types of benefits based on user defined options, including:
BA        90.00
                      System must notify the 2nd party spouse and their agency designated
                      benefits assistant of changes including but not limited to the cancellation
                      of the 1st party spouse's enrollment so appropriate changes can be
BA        90.01       completed.
                      2nd party spouse must also receive a notice showing the additional
                      amounts owed and requesting dependent enrollment of the terminating
BA        90.02       spouse.
                      ERP Benefits Administration must provide both agencies designated
                      benefits assistants with the capability of viewing details about both
BA        90.03       “sides” of split contracts via on-line inquiry.
BA        90.04       System must be able to link both parties.
                  System should support employee's with dual eligibility (ex - State agency and
BA        91.00   local school district).
                  System should prevent employees from being enrolled in a plan for which
BA        92.00   they are not eligible, with secure override capability for exceptions.


      RFP Attachment 6.8                                             Benefits Administration Requirements                                                BA10
      State of Tennessee                                                                                                                      RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

     Reference                                                                                        Vendor                                             Hours to
      Number                                   System Requirements                                   Response                   Comments                  Modify
                  System should provide for processing the following benefits eligibility events:
BA        93.00
BA        93.01        Establishment and maintenance of employee information
                       Activation of coverage for employee, spouse, and non-spouse
BA        93.02        dependents
                       Activation of coverage for survivors (former dependents of employees
BA        93.03        that are allowed to continue their benefits coverage)
BA        93.04        Maintenance of beneficiary information for multiple products
BA        93.05        Extended coverage of dependent
BA        93.06        Medicare eligibility
                       Initiation of COBRA processing when an individual’s coverage is
BA        93.07        terminated due to a COBRA qualifying event
BA        93.08        Evidence of insurability
BA        93.09        Terminating/retiring employees
                       Termination of coverage for employee, spouse, and non-spouse
BA        93.10        dependents
                  System should automatically generate notification (email or letter) to
BA        94.00   employees based on certain events such as:
BA        94.01        Prior to obtaining Medicare Eligibility by virtue of age
BA        94.02        Prior to dependent’s l9th birthday
BA        94.03        Prior to dependent’s 24th birthday
BA        94.04        Proof of continuing eligibility (receipt of proof, i.e. college transcript)
BA        94.05        By semester for ages 19-25
BA        94.06        Beginning and end of COBRA eligibility
                  System should provide employee benefits enrollment election verification
                  notification (email or letter) indicating choices and associated information
                  (i.e., levels of coverage, dependent enrollment and deduction amounts) via
BA        95.00   the following methods:
BA        95.01        Email
BA        95.02        Letter
BA        96.00   System should provide a chronological history of benefits elections.
BA        97.00   System should process eligibility of COBRA eligible individuals:
                       System allows for the tracking of COBRA eligibility based on user-defined
BA        97.01        criteria.



      RFP Attachment 6.8                                             Benefits Administration Requirements                                                BA11
      State of Tennessee                                                                                                                        RFP # 317.03-134
      Project Edison
                                                       FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                          N = Cannot Meet Requirement
M = Modification Required                                                                                         Q = Custom Report/Query

     Reference                                                                                          Vendor                                             Hours to
      Number                                     System Requirements                                   Response                   Comments                  Modify
                       System should provide ability to establish appropriate qualifying events
                       that will initiate COBRA processing, and should generate standard letters
                       notifying employee or dependent of COBRA eligibility.
BA        97.02
BA        97.03         Extend COBRA eligibility and enrollment due to disability.
BA        97.04         Prepare COBRA billings and issue accordingly.
BA        97.05         Track COBRA payments based on pre-defined criteria.
                   System should provide ability to record and monitor dependent demographic
BA        98.00    data.
                   System should allow for dependent to become "head of contract" and track
BA        99.00    appropriate history.
                   System should provide the capability for automated detection of expiration of
                   benefits eligibility and subsequent termination of enrollment based on pre-
BA        100.00   defined criteria.
BA        100.01        Automatically provide notifications advising of pending cancellation.
                   System should provide ability to monitor work location and residence address
                   changes and trigger notification of those events affecting all insurance and
BA        101.00   eligibility.
                   System should provide the ability to maintain an alternate address record for
BA        102.00   all participants.
BA        103.00   System should allow for addresses outside of the United States.
                   System should provide the ability to track, refund, and apply excess funds to
BA        104.00   all transactions subject to user defined rules
                   System should maintain history of eligibility as well as a history of enrollments
BA        105.00   for employee.
                   System should maintain history of eligibility as well as a history of enrollments
BA        106.00   for the dependents.
BA        107.00   System should provide interface with HR for eligibility rules.
                   System should provide the ability to extend COBRA enrollments for an
BA        108.00   additional specified period and bill the individual accordingly.
                                                  Benefit Plan Costs
                   System should provide for the following financial processes associated with
BA        109.00   benefits administration, including but not limited to:
BA        109.01        State FICA savings on FLEX amounts.
                        Approval of Flex eligible claims as designated in Internal Revenue code
BA        109.02        section 125 and section 129.

      RFP Attachment 6.8                                               Benefits Administration Requirements                                                BA12
      State of Tennessee                                                                                                                     RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                       N = Cannot Meet Requirement
M = Modification Required                                                                                      Q = Custom Report/Query

     Reference                                                                                       Vendor                                             Hours to
      Number                                   System Requirements                                  Response                   Comments                  Modify
                      Additional remittance advice will be prepared immediately if a payment is
BA        109.03      received that is insufficient to balance due.
                      Direct bill employees should receive one invoice that shows amounts for
BA        109.04      individual coverage's.
                      Billing of State agencies for insurance for the entire group while
BA        109.05      maintaining individual eligibility.
                      Ability to set specified collection method for payees, individual or groups
                      of including: cash/check, ACH, external agency paid, or State agency
BA        109.06      paid
BA        109.07      Online entry of cash receipts from direct premium payers.
BA        109.08      Scanned receipts from Revenue (lock-box) or direct online entry).
                      If premiums are delinquent, the system will apply payments to the oldest
BA        109.09      balances first.
BA        109.10      Processing of prepayment of premiums.
BA        109.11      Returned payments due to insufficient funds.
BA        109.12      Calculation and processing of payments to benefit vendors.
BA        109.13      Electronic transmission of eligibility information to benefit vendors.
BA        109.14      Refund of insurance premiums to employees.
BA        109.15      Refund of insurance premiums to agencies.
                      Maintain separate record of premiums and fees billed, collected or
BA        109.16      outstanding from either employee or employer.
BA        109.17      Forfeitures of FLEX insurance amounts.
                      Accounting entries must have the ability to track to individual employees.
BA        109.18
BA        109.19      Integration of financial entries to the financial system.
                      Ability to recover money for claims paid in error. Recovered money can
BA        109.20      be from employee or agency/department.
                      System must be able to split premium cost between employee and
BA        109.21      employer based on user defined criteria.
BA        109.22      Must provide the ability to use debit cards for flex expenditures.
                   System should provide at least the following methods of calculating
BA        110.00   employee/agency premium costs or contribution amounts:
BA        110.01      Percentage
BA        110.02      Flat amount
BA        110.03      Wage type(s) to include in calculation
BA        110.04      Wage as of date for calculations

      RFP Attachment 6.8                                             Benefits Administration Requirements                                               BA13
      State of Tennessee                                                                                                                    RFP # 317.03-134
      Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

     Reference                                                                                      Vendor                                             Hours to
      Number                                   System Requirements                                 Response                   Comments                  Modify
BA        110.05        Individual, individual or spouse, family
BA        110.06        Pre or post taxable income calculation
BA        110.07        Monthly limit
BA        110.08        Quarterly limits
BA        110.09        Annual limits
BA        110.10        Age
BA        110.11        Amount of coverage
BA        110.12        Frequency
BA        110.13        Group
BA        110.14        Premium level
BA        110.15        Benefit/product
BA        110.16        Agency
BA        110.17        Administrative fee
                   System should calculate costs based on effective date with more than one
BA        111.00   cost effective during a particular period.
                   System should collect employer portion of delinquent premium when
BA        112.00   employee portion is paid.
                   System should provide the ability input specific premium amounts for any
BA        113.00   coverage for any period (override system calculated amount).
                   System should provide for deferral of premium costs if pay or premium paid
BA        114.00   is insufficient based on user defined option and duration.
                   System should provide ability to automatically cancel employees insurance
BA        115.00   after user defined period of unpaid premiums.
                   System should provide support for the refunding or applying overpayments.
BA        116.00
                 System should provide for continued employee deductions when coverage is
                 cancelled if original election paid premiums from pre-tax wages. These must
                 be accounted for properly and kept separate such that refunds are not made
BA        117.00 to employees without approval.
                 System should provide the ability to track, refund, and apply excess funds to
BA        118.00 all transactions subject to user defined rules.
                 System should provide the ability to apply retroactive changes, for example:
BA        119.00
BA        119.01      Adjust large groups of employees when rates change
BA        119.02      Verify eligibility if eligibility rules change


      RFP Attachment 6.8                                             Benefits Administration Requirements                                              BA14
      State of Tennessee                                                                                                                   RFP # 317.03-134
      Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

     Reference                                                                                     Vendor                                             Hours to
      Number                                  System Requirements                                 Response                   Comments                  Modify
                      Apply retroactive changes to a single employee or a combination of
BA        119.03      employee and employer
BA        120.00 System should accumulate benefit costs by one or a combination of:
BA        120.01      Agency (organization at user specified level)
BA        120.02      Bargaining unit
BA        120.03      Benefit type
BA        120.04      Plan
BA        120.05      Vendor
BA        120.06      Employee
BA        120.07      Other Charts of Accounts
                 System should maintain employee premium or contribution history and
BA        121.00 agency cost history on-line by:
BA        121.01      Plan
BA        121.02      employee
BA        121.03      Vendor
BA        121.04      Notification
                                       Vendor / Contract Administration:
                 System should provide interfaces to and from vendor and insurance module
BA        121.05 for:
BA        121.06   Plan costs
BA        121.07   Deduction amount
BA        121.08   Enrollment and/or eligibility
BA        121.09   Utilization
BA        121.10   Other user defined parameters
                 System should provide the vendor daily notification if coverage has been
BA        122.00 certified once a past due premium is received:
BA        122.01   Due to the collection and certification of a month's premium.
BA        122.02   Due to the collection and certification of a previous month's premium.
                 System should support payments (through financial system) to vendors for
BA        123.00 administrative fees.
                 System should support payments (through financial system) to vendors for
BA        124.00 premiums.
                 System should provide tracking of vendors compliance with contract
BA        125.00 performance guarantees.
                 System should provide the ability to terminate coverage for all employees of
BA        126.00 an agency when the agency terminates coverage.

      RFP Attachment 6.8                                            Benefits Administration Requirements                                              BA15
      State of Tennessee                                                                                                                       RFP # 317.03-134
      Project Edison
                                                       FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                         N = Cannot Meet Requirement
M = Modification Required                                                                                        Q = Custom Report/Query

     Reference                                                                                         Vendor                                             Hours to
      Number                                    System Requirements                                   Response                   Comments                  Modify
                 System should provide the ability to terminate all coverage associated with a
BA        127.00 vendor that is being replaced.
                 System should provide daily vendor notification when coverage is certified,
BA        128.00 when a past due premium is received.
                 System should provide daily vendor notification of un-certified coverage, if a
                 payment is marked insufficient or coverage is cancelled for non-payment of
BA        129.00 premium.
                 System should continue to provide interfaces with terminated vendors for a
BA        130.00 specified period of time after termination.
                 System should provide the ability to transfer whole groups to new vendor
BA        131.00 coverage.
                 System should provide 3rd party vendor links to employee data and related
BA        132.00 benefit information.
                 System should provide analysis and “WHAT-IF” capabilities for contract
BA        133.00 analysis purposes.
                                      Reporting and Query Requirements
                 System should provide for online access to all employee, plan, and vendor
BA        134.00 data with appropriate security.
                 System should include a flexible report writing capability that will allow reports
BA        135.00 to be formatted easily by user.
                 System should provide ability to project and inquire on future premiums due
BA        136.00 by individual, group, etc.
BA        137.00 System should produce State's current standard reports.
BA        138.00 System should utilize data from vendor for analysis of specific plans:
BA        138.01     Costs by plan
BA        138.02     Costs by benefit type
BA        138.03     Costs by vendor
BA        138.04     Utilization
BA        138.05     Comparison reporting
                 System should provide online current and historical employee information
BA        139.00 such as:
BA        139.01     Employee
BA        139.02     Dependents
BA        139.03     Benefit elections and dates
BA        139.04     Hire date
BA        139.05     Benefit history

      RFP Attachment 6.8                                              Benefits Administration Requirements                                                BA16
      State of Tennessee                                                                                                                      RFP # 317.03-134
      Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

     Reference                                                                                        Vendor                                             Hours to
      Number                                    System Requirements                                  Response                   Comments                  Modify
BA        139.06        Costs and contributions
BA        139.07        Beneficiaries
                   System should provide ability to name search on for head of contract and
BA        140.00   dependents
                   System should track and monitor utilization of benefit plans by various
BA        141.00   criteria.
                   System should produce vendor reports that provides the following information
BA        142.00   on detailed and summary reports:
BA        142.01        Plan participation
BA        142.02        Plan revenues
BA        142.03        State costs by vendor
                        Provide reporting for Agencies that provides the following on detailed and
BA        142.04        summary reports:
BA        142.05        Employee participation by plan
BA        142.06        Costs by plan
BA        142.07        Costs by organizational unit
BA        142.08        Costs by benefit type
BA        142.09        Employees eligible but not participating
BA        143.00   System should print mailing labels for:
BA        143.01        All employees
BA        143.02        Employees within a given benefit plan
BA        143.03        Employees within a given benefit status
BA        143.04        Employees within a given bargaining unit
BA        143.05        Employees within a given job class
BA        143.06        Employees by residential and/or work locations
BA        143.07        Employees within a given agency, by index, by location code
                   System should provide reports reflecting eligible employees not enrolled in
BA        144.00   benefit plans.
                   System should provide report of employees that will have premium increases
BA        145.00   or decrease on the next cycle.
                   System should provide inquiry showing all excess amounts for a employee.
BA        146.00
                 System should produce report of purged data per individual upon user
BA        147.00 request.
BA        148.00 System should provide inquire of flex forfeiture amounts


      RFP Attachment 6.8                                              Benefits Administration Requirements                                               BA17
      State of Tennessee                                                                                                                  RFP # 317.03-134
      Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

     Reference                                                                                    Vendor                                             Hours to
      Number                                 System Requirements                                 Response                   Comments                  Modify
                 System should produce rosters of employees in specific benefit plans in
BA        149.00 various sequences.
                 System should produce report of purged data per individual upon user
BA        150.00 request.
                 System should provide capability to compare data from outside agencies to
                 data within the system for discrepancy or identification reporting (data
BA        151.00 match).
                 System should take advantage of sorting software for printed
BA        152.00 correspondence that is to be distributed through the U. S. Postal.
                 System should take advantage of bar-coding on printed correspondence that
BA        153.00 is to be distributed through the U. S. Postal.




      RFP Attachment 6.8                                           Benefits Administration Requirements                                              BA18
State of Tennessee                                                                                                       RFP 317.03-134
Project Edison
                                FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05




                                                     Classification/Compensation

                     Classification/Compensation addresses the administration of the State's rules for calculating pay
                     and classifying positions. In addition, this section includes specific functions as follows:

                           Maintain history of classification and position changes
                           Track status of position actions
                           Calculate additional pay based on flexible, user-defined criteria
                           Calculate step, increment, and percentage pay increases for all or for a group of
                            employees
                           Project costs for future fiscal years
                           Provide analysis of compensation by budget / class / Chart of Account elements




                     Additional Information:




RFP Attachment 6.8                                           Introduction                                                            ii
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query


  Reference                                                                                    Vendor                                               Hours to
   Number                                  System Requirements                                Response                   Comments                    Modify
                          Classification Compensation General Requirements
              System allows separate salary schedules to be maintained by job
  CC 1.00     classification.
              System maintains effective dates for salary table to allow for future pay
  CC 2.00     adjustments.
              System maintains effective dates for Class data to allow for future pay
  CC 3.00     adjustments.
              System retains previous salary and hours data and effective dates for use
  CC 4.00     when calculating retroactive pay adjustments.
  CC 5.00     System provides salary data for user defined employee groups.
  CC 6.00     System maintains salary tables with the following types of programs :
                  Salary range structure (minimum / control points (mid, quartile, etc.) /
  CC   6.01       maximum structure).
  CC   6.02       Salary schedules with steps within schedule (unlimited steps)
  CC   6.03       Special salary schedules: steps defined by classification.
  CC   7.00   System will record base rate as follows:
  CC   7.01       Per annum
  CC   7.02       Per month
  CC   7.03       Per day
  CC   7.04       Per hour
  CC   7.05       Per session
  CC   7.06       Per visit.
  CC   8.00   System will code additional pay as follows:
  CC   8.01       Flat rate
  CC   8.02       Percentage of current salary
  CC   8.03       Based on other combinations of base rate and additional pay
  CC   8.04       Overridden amounts (user entered)
  CC   8.05       Per hour
  CC   8.06       Schedule and level bonus (pays on a different schedule and/or level)
  CC   8.07       Longevity.
              System supports the ability to generate additional pay based on
  CC 9.00     circumstances as follows:
  CC 9.01         Pay type
  CC 9.02         Organization (Agency, Dept, Div, Cost Center)
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                              CC1
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query


  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
  CC   9.03       Work location
  CC   9.04       Position
  CC   9.05       State classification
  CC   9.06       Duties performed
  CC   9.07       Shift worked
  CC   9.08       Skills
  CC   9.09       Certificates
  CC   9.10       Licenses
  CC   9.11       Languages
  CC   9.12       Education
  CC   9.13       Current base pay step
  CC   9.14       Pay differentials
  CC   9.15       Time in classification
  CC   9.16       Months of Service
  CC   9.17       Time & attendance
                  Status of any other variable as of a particular date (ex - work location 2
  CC   9.18       years ago).
  CC   10.00   System provides analysis of compensation by dept. for the following:
  CC   10.01      Salary
  CC   10.02      State contributions to Benefits
  CC   10.03      State contributions to retirement
  CC   10.04      Anticipated future salary increases.
  CC   11.00   System provides analysis of compensation by budget for the following:
  CC   11.01      Salary
  CC   11.02      State contributions to Benefits
  CC   11.03      State contributions to retirement
  CC   11.04      Anticipated future salary increases.
  CC   12.00   System provides analysis of compensation by division for the following:
  CC   12.01      Salary
  CC   12.02      State contributions to Benefits
  CC   12.03      State contributions to retirement
  CC   12.04      Anticipated future salary increases.
  CC   13.00   System provides analysis of compensation by class for the following:
  CC   13.01      Salary
    RFP Attachment 6.8                                         Classification/Compensation Requirements                                              CC2
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
  CC 13.02        State contributions to Benefits
  CC 13.03        State contributions to retirement
  CC 13.04        Anticipated future salary increases.
               System provides analysis of compensation by salary grade for the following:
  CC   14.00
  CC   14.01       Salary
  CC   14.02       State contributions to Benefits
  CC   14.03       State contributions to retirement
  CC   14.04       Anticipated future salary increases.
  CC   15.00   System provides analysis of compensation by EEO for the following:
  CC   15.01       Salary
  CC   15.02       State contributions to Benefits
  CC   15.03       State contributions to retirement
  CC   15.04       Anticipated future salary increases.
               System must allow the pre-payment of state contributions to retirement
  CC 16.00     (including the pre-payment of State portion.
               System must record the pre-payment of state contributions to retirement to
  CC 17.00     appropriate the period.

  CC   18.00   System projects annual salary (gross and net) and benefit costs for the year:
  CC   18.01       By Person
  CC   18.02       By Organization (Agency, Dept, Div, Cost Center, Segments)
  CC   18.03       By Class
  CC   18.04       By EEO.
               System projects costs for future fiscal years or specific time periods,
               assuming variable user specified increases in salary and benefits; and time
  CC   19.00   frames:
  CC   19.01       By Person
  CC   19.02       By Organization (Agency, Dept, Div, Cost Center, Segments)
  CC   19.03       By Class
  CC   19.04       By EEO.
               System must have the ability to change cost factors so that comprehensive
  CC 20.00     forecasts can be generated and reported:
  CC 20.01         By Person
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                               CC3
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query


  Reference                                                                                         Vendor                                               Hours to
   Number                                    System Requirements                                   Response                   Comments                    Modify
  CC 20.02         By Organization (Agency, Dept, Div, Cost Center, Segments)
  CC 20.03         By Class
  CC 20.04         By EEO.
               System must have the ability to model cost factors so that comprehensive
  CC   21.00   forecasts can be generated and reported:
  CC   21.01       By Person
  CC   21.02       By Organization (Agency, Dept, Div, Cost Center, Segments)
  CC   21.03       By Class
  CC   21.04       By EEO.

               System must be able to provide actual costs and benefits of each employee
  CC 22.00     including regular salary and wages, incentive pay, and all State paid costs.
               System must be able to provide actual costs and benefits of each employee
               including temporary salary and wages, incentive pay, and all State paid
  CC 23.00     costs.

               System must be able to sort and report actual costs and benefits of each
               employee including regular salary and wages, incentive pay, and all State
  CC 24.00     paid costs by the various groups such as agency, fund and budget unit field.

               System must be able to sort and report actual costs and benefits of each
               employee including temporary salary and wages, incentive pay, and all State
  CC 25.00     paid costs by the various groups such as agency, fund and budget unit field.
               System assesses the impact of salary proposals by accessing the amount of
               all payment and benefit provisions. Costs should be provided by various
               sorts (total, organization, etc.) and show individual benefit costs and totals by
  CC   26.00   the following benefit types:
  CC   26.01        Base pay
  CC   26.02        Overtime
  CC   26.03        Call back (RIF - Laid off Employees)
  CC   26.04        Schedule and step bonuses
  CC   26.05        Sick
  CC   26.06        Clothing allowance
  CC   26.07        Leave (all types)
    RFP Attachment 6.8                                          Classification/Compensation Requirements                                                CC4
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query


  Reference                                                                                    Vendor                                               Hours to
   Number                                  System Requirements                                Response                   Comments                    Modify
  CC   26.08      Shift differential pay
  CC   26.09      Premium pay
  CC   26.10      Education allowance
  CC   26.11      Retirement
  CC   26.12      Cafeteria plans
  CC   26.13      Savings plan
  CC   26.14      State Disability Insurance
  CC   26.15      Standby pay (Ex: Medical Officer on-call pay)
  CC   26.16      Equity increases
  CC   26.17      Assignment differentials
  CC   26.18      Working out of class increases
  CC   26.19      Classification upgrades
  CC   26.20      Other special allowances.
               Classification/Compensation should be integrated with the following areas:
  CC   27.00
  CC   27.01        Personnel Administration
  CC   27.02        Payroll
  CC   27.03        Budget Development
  CC   27.04        Position Control
  CC   27.05        Applicant Tracking
  CC   27.06        Retirement System
  CC   27.07        Benefits
  CC   27.08        Timekeeping.
               System automatically recalculates salary due to personnel actions such as
  CC 28.00     promotions, demotions, etc.
  CC 29.00     System provides override capability for automatic recalculations.
               System supports user defined approval and routing for all compensation
  CC 30.00     changes (base rate, bonuses, additional pay, etc.).
               System supports workflow routing based upon types of job class involved
  CC 31.00     (i.e. Career Service).
  CC 32.00     System supports workflow notification and or emails.
  CC 33.00     System supports choice to generate email notification as needed.
               Systems provides approval for multiple line requests at the line level to
  CC 34.00     enable individual actions to process.
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                              CC5
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
               Systems provides at least four levels of approval and routing for all
  CC 35.00     compensation changes.
  CC 36.00     System must be compatible with FileNet.
               System must be able to retrieve or convert information currently stored in
  CC 37.00     FileNet.
               System must allow the establishment and maintenance of classifications
  CC   38.00   (class/comp) including:
  CC   38.01       Class code
  CC   38.02       Effective Date of Change
  CC   38.03       Salary grade
  CC   38.04       Class Abbreviation
  CC   38.05       Suspense Code
  CC   38.06       Class title
  CC   38.07       Minimum salaries
  CC   38.08       Maximum salaries
  CC   38.09       Career service status
  CC   38.10       Overtime
  CC   38.11       Probationary code
  CC   38.12       Flex Code
  CC   38.13       Flex Number
  CC   38.14       Target grade
  CC   38.15       Longevity Code
  CC   38.16       Leave code
  CC   38.17       PE system code
  CC   38.18       PE catalog code
  CC   38.19       Selective certification code
  CC   38.20       Minimum Qualifications codes
  CC   38.21       Fiscal code
  CC   38.22       Standard occupational code
  CC   38.23       Public safety code
  CC   38.24       EEOC code
  CC   38.25       Establishment date of class
  CC   38.26       Occupational code
  CC   38.27       Number of applicants
    RFP Attachment 6.8                                        Classification/Compensation Requirements                                              CC6
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query


  Reference                                                                                    Vendor                                               Hours to
   Number                                  System Requirements                                Response                   Comments                    Modify
  CC 38.28         Number of positions
  CC 38.29         Number of employees
  CC 38.30         Budget approval code.
               System must have the ability to change any of the data elements (fields) on
 CC 39.00      the class record and:
 CC 39.01         Interface with Applicant Services.
               System must have the ability to consolidate 2 or more classes into 1 class.
  CC 40.00     (The class can be a new class or an existing class).
               System must allow the abolishment (deletion) of a class with appropriate
  CC 41.00     edits.
               System must adjust employee or position information based on changes in
               class (ex: overtime codes, salary grade, exec, etc.) or consolidation of
  CC 42.00     classes.
               System must be able to calculate amount of time an employee has been in a
  CC   43.00   class.
  CC   44.00   System must allow the designation of a class for the following:
  CC   44.01       Longevity
  CC   44.02       Hours worked for leave purpose accrual or usage (7.5, 8.0, etc.)
  CC   44.03       Leave eligibility
  CC   44.04       Performance Evaluation.
               System must maintain the number of positions, employees, and applicants.
  CC 45.00
               System should have the capability for mass transaction processing for the
  CC 46.00     changes of salary grade, exec, etc.
  CC 47.00     System must maintain a history of class actions (transactions).
               System must have the ability to change class number of class and update all
  CC 48.00     employees and positions data for the class.
               System must allow the processing of future transactions (length of time
  CC 49.00     defined by Department of Personnel).
               System must allow the processing of retroactive transactions (length of time
  CC 50.00     defined by Department of Personnel)
  CC 51.00     System must allow the establishment and maintenance of positions.
               System must have the ability to change and interface the changes to the
  CC 52.00     benefits modules for the following:
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                              CC7
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
  CC   52.01       Work county
  CC   52.02       Cost center
  CC   52.03       Job Group Code
  CC   52.04       Misclass code
  CC   52.05       Overtime
  CC   52.06       Work unit
  CC   52.07       Full or part-time indicator
  CC   52.08       Civil Service.
               System must have the ability to process mass positions created
  CC 53.00     (established).
               System must have the ability to process mass position number changes
  CC   54.00   (reorganizations) and interface with the following:
  CC   54.01       Personnel Administration
  CC   54.02       Benefits
  CC   54.03       Timekeeping
  CC   54.04       Payroll
  CC   54.05       Budget.
               System must have the ability to process mass position change and interface
  CC   55.00   the changes to the benefits modules for the following:
  CC   55.01       Work county
  CC   55.02       Cost center
  CC   55.03       Job Group Code
  CC   55.04       Misclass code
  CC   55.05       Overtime
  CC   55.06       Work unit
  CC   55.07       Full or part-time indicator
  CC   55.08       Civil Service
  CC   55.09       Interdepartmental Group.
  CC   56.00   System must maintain position history.
               System must have the ability to reclass positions from one classification to
  CC 57.00     another with edits defined by Department of Personnel.
               System must have the ability to interface reclass positions transactions with
  CC 58.00     the following:
  CC 58.01         Personnel Administration
    RFP Attachment 6.8                                        Classification/Compensation Requirements                                              CC8
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query


  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
  CC   58.02        Benefits
  CC   58.03        Timekeeping
  CC   58.04        Payroll
  CC   58.05        Budget.
               System must have the ability to abolish (delete) a position with edits defined
  CC 59.00     by Department of Personnel.
               System must interface with cost accounting system for validation of cost
  CC 60.00     center.
  CC 61.00     System must interface with department/division table.
  CC 62.00     System must have the ability to process mass position abolishment's.
               System must allow the processing of future position transactions (length of
  CC 63.00     time defined by Department of Personnel).
               System must allow the processing of retroactive position transactions (length
  CC 64.00     of time defined by Department of Personnel).
               System provides the ability to link the position records to the imaged PCQ
  CC 65.00     maintained in the ECM system.
               System provides a hyperlink in the position record that makes the ECM-
  CC 66.00     stored PCQ files accessible directly from the ERP interface.
                                           Pay Rate Maintenance
  CC   67.00   System provides on-line update of salary schedule changes :
  CC   67.01        Across the board
  CC   67.02        By individual performance
  CC   67.03        By job classification
  CC   67.04        By agency/organization
  CC   67.05        By bonus.
               System provides the ability to automatically implement employee step pay
  CC   68.00   plan
  CC   69.00   System supports the determination of eligibility for step increases by:
  CC   69.01        Effective Date of Current Step
  CC   69.02        Last Overall Performance Rating, including effective date of rating
  CC   69.03        Classification
  CC   69.04        Duties performed
  CC   69.05        Skills
  CC   69.06        Certificates
    RFP Attachment 6.8                                        Classification/Compensation Requirements                                               CC9
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query


  Reference                                                                                      Vendor                                               Hours to
   Number                                    System Requirements                                Response                   Comments                    Modify
  CC   69.07       Licenses
  CC   69.08       Languages
  CC   69.09       Education
  CC   69.10       Work location
  CC   69.11       Hours worked last 12 months
  CC   69.12       Hours worked last 12 months in current classification
  CC   69.13       Eligible to advance step
  CC   69.14       Eligible for over top step
  CC   69.15       Work unit
                   Status of any other variable as of a particular date (ex - work location 2
  CC 69.16         years ago).
               System supports mass change capability for the purposes of changing
  CC 70.00     salaries (e.g. COLA changes).
               System supports mass pay transactions based on fields held within the
  CC 71.00     database (e.g.: uniform allowances).
  CC 72.00     System records historical information for all compensation changes.
  CC 73.00     System supports user defined reasons for pay rate changes.
               System supports a base pay rate to four digits past the decimal point
  CC 74.00     ($0.0000) and corresponding salary schedule,
               System supports recording persons additional pay to four digits past the
  CC 75.00     decimal point ($0.0000).
               System supports user defined approval mechanisms for the approval of all
  CC 76.00     compensation changes (base rate, bonus, additional pay, etc.).
  CC 77.00     System provides salary history for each employee.
  CC 78.00     System tracks position history.
                                      Position and Classification Tools

  CC   79.00   System should provide ability to route change request documents as follows:
  CC   79.01      Job descriptions (PCQ's) associated with all new positions
  CC   79.02      Job descriptions (PCQ's) or job classifications under revision
  CC   79.03      All job descriptions (PCQ's) associated with a specific job class
                  Upon request by agency to properly classify a position management
  CC 79.04        believed to be misclassified
  CC 79.05        Salary increases based on changes in duties or salary compression
    RFP Attachment 6.8                                         Classification/Compensation Requirements                                             CC10
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query


  Reference                                                                                    Vendor                                               Hours to
   Number                                  System Requirements                                Response                   Comments                    Modify
  CC   79.06       Selective Certification
  CC   79.07       Career service status changes
  CC   79.08       Approvals including Budget
  CC   79.09       At user defined interval since last audit
  CC   79.10       Random audits of all existing job descriptions.
  CC   80.00   System should support audit of job descriptions for:
  CC   80.01       Classification
  CC   80.02       FLSA status
  CC   80.03       Pay group (employee type)
  CC   80.04       Position
  CC   80.05       Minimum job requirements
  CC   80.06       Licenses required
  CC   80.07       Certificates required
  CC   80.08       Any other user defined fields associated with the job
  CC   80.09       Career status
  CC   80.10       Executive Service status
  CC   80.11       Salary increases based on changes in duties or salary compression
  CC   80.12       Selective Certification
  CC   80.13       Career service status changes.
               System should provide ability to capture and maintain pertinent information
  CC 81.00     associated with job classification audits.
               System should provide ability to maintain a complete history, via multiple
  CC 82.00     effective dated rows, associated with all audit activity.
  CC 83.00     System should provide ability to send out and capture salary surveys.
                                            Query Requirements
               System provides the ability to perform analysis of personnel cost based on
  CC 84.00     user defined selection criteria.
               System provides ability to perform "what if" analysis on proposed
  CC 85.00     compensation changes.
               System provides the ability to query by the following employee data
  CC   86.00   elements:
  CC   86.01       Position number
  CC   86.02       Social Security Number
  CC   86.03       Last Name
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                             CC11
    State of Tennessee                                                                                                               RFP # 317.03-134
    Project Edison
                                                FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                               N = Cannot Meet Requirement
M = Modification Required                                                                              Q = Custom Report/Query


  Reference                                                                                  Vendor                                               Hours to
   Number                                  System Requirements                              Response                   Comments                    Modify
  CC   86.04      First Name
  CC   86.05      Middle Initial
  CC   86.06      Marital status
  CC   86.07      Veteran
  CC   86.08      Sex
  CC   86.09      U.S. Citizen
  CC   86.10      Race
  CC   86.11      Handicap
  CC   86.12      Date of birth
  CC   86.13      Office Phone Number
  CC   86.14      Work Building
  CC   86.15      Suspense Code
  CC   86.16      Incumbent Code
  CC   86.17      Incumbent Date
  CC   86.18      Hire Date
  CC   86.19      Appointment Code
  CC   86.20      Employee Transfer Date
  CC   86.21      Previous Position
  CC   86.22      Class codes
  CC   86.23      Salary Grade
  CC   86.24      Salary Step
  CC   86.25      Class Abbreviation
  CC   86.26      Reclass Date
  CC   86.27      Previous Class
  CC   86.28      Previous Grade
  CC   86.29      Previous Step
  CC   86.30      Probation Code
  CC   86.31      Probation Date
  CC   86.32      Current Salary
  CC   86.33      Salary Date
  CC   86.34      Salary Code
  CC   86.35      Previous Salary
  CC   86.36      Previous Salary Date
  CC   86.37      Previous Salary Code
    RFP Attachment 6.8                                     Classification/Compensation Requirements                                             CC12
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
  CC   86.38      Service Anniversary Date
  CC   86.39      Longevity Months
  CC   86.40      Months of Service
  CC   86.41      Longevity Code
  CC   86.42      Longevity Due Date
  CC   86.43      Certification Number
  CC   86.44      Full/Part Code
  CC   86.45      Overtime Code
  CC   86.46      Pay Differential Code
  CC   86.47      Civil Service
  CC   86.48      Flex Code
  CC   86.49      Transactions Code
  CC   86.50      Transaction Effective Date
  CC   86.51      Date Transaction Entered
  CC   86.52      Last Day Worked
  CC   86.53      Separation Code
  CC   86.54      Rehire Code
  CC   86.55      Training Type
  CC   86.56      Performance Evaluation Due Date
  CC   86.57      Performance Evaluation Start Cycle
  CC   86.58      Performance Evaluation Status
  CC   86.59      Performance Evaluation Rating
  CC   86.60      Performance Evaluation Rating Date
  CC   86.61      Public Safety Code
  CC   86.62      Dept. Accounting Code
  CC   86.63      Division Number
  CC   86.64      Classification title
  CC   86.65      EEO Code
  CC   86.66      Civil Service Code
  CC   86.67      Department Number
  CC   86.68      Interdepartmental Group.

  CC 87.00     System provides the ability to query by the following position data elements:
  CC 87.01        Position number
    RFP Attachment 6.8                                        Classification/Compensation Requirements                                             CC13
    State of Tennessee                                                                                                               RFP # 317.03-134
    Project Edison
                                                FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                               N = Cannot Meet Requirement
M = Modification Required                                                                              Q = Custom Report/Query


  Reference                                                                                  Vendor                                               Hours to
   Number                                  System Requirements                              Response                   Comments                    Modify
  CC   87.02      Data create date
  CC   87.03      Vacate date
  CC   87.04      Unemployment code
  CC   87.05      Employee suspense date
  CC   87.06      Number of employees
  CC   87.07      Job group code
  CC   87.08      Position suspense code
  CC   87.09      Establish date
  CC   87.10      Position status
  CC   87.11      Class codes
  CC   87.12      Position grade
  CC   87.13      Position title
  CC   87.14      Overtime Code
  CC   87.15      Civil service
  CC   87.16      Work county
  CC   87.17      Full/part time code
  CC   87.18      Position type
  CC   87.19      Transfer date
  CC   87.20      Previous Position
  CC   87.21      Reclass Date
  CC   87.22      Previous class
  CC   87.23      EEO Code
  CC   87.24      Last transaction
  CC   87.25      Effective date
  CC   87.26      Cost center
  CC   87.27      Flex Code
  CC   87.28      Public Safety Code
  CC   87.29      Work unit
  CC   87.30      Job share
  CC   87.31      Dept. Accounting Code
  CC   87.32      Division code
  CC   87.33      Sequence number
  CC   87.34      Misclassified positions
  CC   87.35      Commission
    RFP Attachment 6.8                                     Classification/Compensation Requirements                                             CC14
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
  CC   87.36      Interdepartmental Group.
  CC   88.00   System provides the ability to query by the following class data elements:
  CC   88.01      Class code
  CC   88.02      Activity code
  CC   88.03      Grade
  CC   88.04      Class title
  CC   88.05      Class abbreviation
  CC   88.06      Class overtime
  CC   88.07      Class civil service code
  CC   88.08      Class minimum salary
  CC   88.09      Class maximum salary
  CC   88.10      Class establish date
  CC   88.11      Flex class code
  CC   88.12      Flex Code
  CC   88.13      Probation code
  CC   88.14      Performance evaluation form type
  CC   88.15      EEOC code
  CC   88.16      Number of Employees in a classification by agency
  CC   88.17      Average salary of employees in a classification by agency.
                                         Reporting Requirements
  CC   89.00   System provides the following reports :
  CC   89.01      Cost Projections
  CC   89.02      Classifications (needed by Applicant Services)
  CC   89.03      Salary Grade Change History
  CC   89.04      Turnover Report (Executive and Non-Executive Branches)
  CC   89.05      Total Positions by Agency
  CC   89.06      Classes with Average Salary and Longevity
  CC   89.07      Occupational List of Class Titles Includes:
  CC   89.08      Total evaluation points (Point factor evaluation)
  CC   89.09      Target grade (Projected grade once fully funded)
  CC   89.10      Salary grade
  CC   89.11      Salary Step
  CC   89.12      Executive Service Positions by Class Including:
  CC   89.13      Filled positions
    RFP Attachment 6.8                                        Classification/Compensation Requirements                                             CC15
    State of Tennessee                                                                                                               RFP # 317.03-134
    Project Edison
                                                FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                               N = Cannot Meet Requirement
M = Modification Required                                                                              Q = Custom Report/Query


  Reference                                                                                  Vendor                                               Hours to
   Number                                  System Requirements                              Response                   Comments                    Modify
  CC 89.14         Vacant positions
  CC 89.15         Total Positions
  CC 89.16         Division total.
               System provides the data needed to prepare the annual Class\Comp Plan,
  CC   90.00   including the following:
  CC   90.01       Class codes
  CC   90.02       Class titles
  CC   90.03       Occupational / Groups
  CC   90.04       Monthly salaries
  CC   90.05       Minimum salaries
  CC   90.06       Maximum salaries
  CC   90.07       Class Abbreviation
  CC   90.08       Overtime Code
  CC   90.09       Salary Grade
  CC   90.10       EEO Code
  CC   90.11       Career Service status
  CC   90.12       Staffing report (patterns):
  CC   90.13       Position number
  CC   90.14       Sequence number of the position
  CC   90.15       Class abbreviation of the position
  CC   90.16       Class abbreviation of the incumbent of the position
  CC   90.17       Cost center of the position
  CC   90.18       Social Security number of the incumbent
  CC   90.19       Status code of the incumbent
  CC   90.20       Incumbent's name
  CC   90.21       Sex of the incumbent
  CC   90.22       Race of the incumbent
  CC   90.23       Incumbent's monthly salary
  CC   90.24       Effective date of last salary change of the incumbent
  CC   90.25       Reason for the salary change
  CC   90.26       Work county of the position
  CC   90.27       Overtime status of the position
  CC   90.28       Full or part-time position
  CC   90.29       Permanent or seasonal position
    RFP Attachment 6.8                                     Classification/Compensation Requirements                                             CC16
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query


  Reference                                                                                    Vendor                                               Hours to
   Number                                  System Requirements                                Response                   Comments                    Modify
  CC   90.30        Career Service, Executive Service or Non-competitive
  CC   90.31        Overtime status
  CC   90.32        Salary Grade
  CC   90.33        Career Service status
  CC   90.34        Commission
  CC   90.35        Interdepartmental Group.
               System provides the data required in the Salary Report which includes the
  CC   91.00   following:
  CC   91.01        Number of positions by class
  CC   91.02        Number of terminations by class
  CC   91.03        Number of hires by class
  CC   91.04        Number of promotions by class
  CC   91.05        Termination reasons by class.
               System shall have the ability to generate standard and user defined reports
               (for instance, Position Classification Questionnaire used for Auditing
  CC 92.00     purposes).
               System shall have the ability to generate standard and user defined reports
  CC 93.00     regarding training information.
               System shall have the ability to generate standard and user defined reports
  CC 94.00     regarding position information.
               System shall have the ability to generate standard and user defined reports
  CC 95.00     regarding employee information.
               System shall have the ability to generate standard and user defined reports
  CC 96.00     regarding class/comp information.
                                             Data Requirements
  CC   97.00   System tracks the following data within each salary schedule :
  CC   97.01        Step
  CC   97.02        Schedule type (fixed, range, etc.)
  CC   97.03        Minimum
  CC   97.04        Maximum
  CC   97.05        Midpoint
  CC   97.06        Quartile
  CC   97.07        Salary table
  CC   97.08        Overtime eligible.
    RFP Attachment 6.8                                       Classification/Compensation Requirements                                             CC17
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query


  Reference                                                                                     Vendor                                               Hours to
   Number                                   System Requirements                                Response                   Comments                    Modify
  CC   98.00   System provides the following data for additional pay items:
  CC   98.01      Pay code (Wage type)
  CC   98.02      Calculation method (%, flat rate, etc.)
  CC   98.03      Amount (fixed amount, %, etc.)
                  Calculation frequency (every pay period, monthly, on anniversary date,
  CC   98.04      etc.)
  CC   98.05      Taxable (federal, state, FICA, etc.)
  CC   98.06      Longevity
  CC   98.07      Civil Service
  CC   98.08      Date of Last Audit
  CC   98.09      Justification for action data requirements (PCQ):
  CC   98.10      Employee name
  CC   98.11      Current position classification title
  CC   98.12      Current position number
  CC   98.13      Class codes
  CC   98.14      Sequence number
  CC   98.15      Organizational unit (at least three levels)
  CC   98.16      Proposed position number and title
  CC   98.17      Location of work headquarters
  CC   98.18      Full time or part time
  CC   98.19      Number of hours worked per week
  CC   98.20      If seasonal, indicate period of year worked
  CC   98.21      Name and title of immediate supervisor
  CC   98.22      Name and title of employees supervised
  CC   98.23      Job duties description which includes percentage of time
  CC   98.24      Primary work objective of current position
                  Equipment utilized with percentage of time with space to indicate at least
  CC   98.25      four types
  CC   98.26      Date of Last Audit
  CC   98.27      Percentage of time spent typing if applicable
  CC   98.28      Period of time performing current job duties
  CC   98.29      Capability to include employee comments
  CC   98.30      Capability to support employee certification of accuracy


    RFP Attachment 6.8                                       Classification/Compensation Requirements                                              CC18
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                    10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query


  Reference                                                                                         Vendor                                               Hours to
   Number                                   System Requirements                                    Response                   Comments                    Modify
                  Ability for supervisor to comment on accuracy of data and add additional
  CC 98.31        information on job duties
                  Ability for supervisor to comment on accuracy of supervisory data
  CC 98.32        supplied and to project employee supervisory time by percentage

  CC 98.33        Ability for supervisor to comment on most important duties of the position.
                  Ability for supervisor to comment on employee job duties in a minimum of
                  six specific areas (i.e. policies and procedures, and fiduciary
  CC   98.34      responsibilities)
  CC   98.35      Supports minimum qualifications required for a position
  CC   98.36      Supports preferred qualifications required for a position
  CC   98.37      Ability for supervisor to project training required for position
  CC   98.38      Supports supervisory approval of the action request
                  Supports department head approval of and comments on the action
  CC 98.39        request
                  Ability for supervisor to comment on the nature, frequency and detail or
  CC 98.40        closeness of supervision received by the employee.

  CC 98.41        Justification to support funding availability (Salary Administration Plan)
                  Equity funding available by funding sources (i.e. total, state, federal, other
  CC 98.42        prior to the proposed change)
                  Establishments including new position, proposed monthly salary, annual
                  calculation of action in total and by funding source (i.e. total, state,
  CC 98.43        federal, other)
                  Upward reclassification including old position number, current position
                  number, new position if applicable, current position title, proposed
                  position title if applicable, current monthly salary, proposed monthly
                  salary, annual calculation of action in total and by funding source (i.e.
  CC 98.44        total, state, federal, other)
                  Downward reclassifications including old position number, current
                  position number, new position if applicable, current position title,
                  proposed position title if applicable, current monthly salary, proposed
                  monthly salary, annual calculation of action in total and by funding source
  CC 98.45        (i.e. total, state, federal, other)
    RFP Attachment 6.8                                         Classification/Compensation Requirements                                                CC19
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query


  Reference                                                                                      Vendor                                               Hours to
   Number                                   System Requirements                                 Response                   Comments                    Modify
                 Lateral reclassifications including old position number, new position if
                 applicable, current position title, proposed position title, current monthly
                 salary, proposed monthly salary, annual calculation of action in total and
  CC 98.46       by funding source (i.e. total, state, federal, other)
                 Equity/ salary adjustment including old position number, new position if
                 applicable, current monthly salary, proposed monthly salary, annual
                 calculation of action in total and by funding source (i.e. total, state,
                 federal, other) and beginning and ending effective dates if the salary
  CC 98.47       adjustment is for a fixed period of time.
                 Abolishment including old position number, current monthly salary,
                 proposed monthly salary, annual calculation of action in total and by
  CC 98.48       funding source (i.e. total, state, federal, other)
  CC 98.49       Supports three levels of approval for the proposed funding change.
  CC 99.00    System must be able to track overlapped positions.




    RFP Attachment 6.8                                        Classification/Compensation Requirements                                              CC20
State of Tennessee                                                                                                         RFP 317.03-134
Project Edison
                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05




                                                                Insurance

                     Insurance module will be used for processing and maintenance of all Participant Insurance
                     related data. Eligibility and enrollment will be entered and maintained in multiple ways due to the
                     business needs. Eligibility data for all Central State Employees will be integrated from the
                     Personnel Modules. State agencies such as the University of Tennessee, the Tennessee Board
                     of Regents, former State agencies, participating Local Education and the Quasi Governmental
                     employee’s Personnel data will not be maintained in the Edison System, therefore, the eligibility
                     data will need to be interfaced or entered online by an authorized user. The Insurance Module
                     addresses the need to administer insurance products as a private Insurance Company would.

                           Maintain multiple types of eligibility rules for multiple type of participants
                           Maintain multiple eligibility dates for different plans based on different rules
                           Maintains and tracks current and historical demographic, eligibility, enrollment and
                            payment data of participants (head of contracts and dependents), programs
                            (health, dental, life, etc.) and vendors.
                           Maintain current and historical beneficiary information
                           Calculate employer and employee costs
                           Provide online (Web based or kiosks) enrollment ability for Central State
                           Interface with benefit providers and third party administrators
                           Reconcile premium collections to vendor payments or claims paid for medical
                            insurance

                     Additional Information:




RFP Attachment 6.8                                             Introduction                                                            ii
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                   System Requirements                                  Response                   Comments                  Modify
    .                        Insurance Administration General Requirements
               K-12 school district participants, local government participants, and higher
               education participants, retirees, certain former agencies previously
               associated with the State and certain other former participants records will
               not be maintained in the ERP Payroll/Personnel (including Benefits
               Administration) modules. This group of participants insurance only related
   IA 1.00     records will be maintain within the Insurance Module.
               HR records for Central State employees (which does not include any of the
               groups in BA 1.00) will be utilized in the ERP Benefits Module, with
   IA 2.00     integration of insurance related records to the Insurance Module.
               Insurance must provide functional integration with at least the following
   IA   3.00   system components for all Participants:
   IA   3.01       Personnel Administration
   IA   3.02       Position Control
   IA   3.03       Budget Development
   IA   3.04       Payroll
   IA   3.05       Financial Information
   IA   3.06       Accounts Payable
   IA   3.07       Accounts Receivable
   IA   3.08       General Ledger
   IA   3.09       Cash Management
   IA   3.10       Benefits Administration
               In addition to the above listed components that are integrated with participant
               insurance, a number of State systems as well as internal and external
               organizations will be interfaced, both online and in batch, to the system for
   IA   4.00   demographic, premium and other data:
   IA   4.01       Retirement system (CRIS) Retired Participants Database
   IA   4.02       UT
   IA   4.03       TBR
   IA   4.04       Local governments and school districts
   IA   4.05       Revenue
   IA   4.06       TENNCARE
   IA   4.07       Worker's Compensation benefits administrator (Sedgwick James)
   IA   4.08       Center for Medicare and Medicaid services
   IA   4.09       Other external employers
   IA   4.10       Vendors
    RFP Attachment 6.8                                            Insurance Administration Requirements                                                IA1
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
   IA 5.00     Provide information to third party administrators:
   IA 5.01        utilization
   IA 5.02        demographic data

   IA   6.00   System should allow update interface files by third party administrators for:
   IA   6.01       Resource planning
   IA   6.02       Update programs
   IA   6.03       Establish dependent eligibility and enrollment
   IA   6.04       Update of deduction amounts
   IA   6.05       Other user defined parameters
               System should track participant data to disallow duplicate coverage within the
               same plan. (Employee can be the head of contract in State plan and Local
               Gov. or Local Ed. plan but can not be a HOC and a dependent the same
   IA 7.00     plan).
               System should track dependent data to disallow duplicate coverage within
               the same plan and/or program . (Dependents can be covered in the State
               plan and Local Gov. or Local Ed. plan but not twice under the same plan).
   IA 8.00
               System should track current and historical beneficiary information (including
   IA 9.00     multiple beneficiaries per product)
               System should have the ability to enter and track dual and / or temporary
   IA 10.00    changes in participant status and track the corresponding accruals
               System should maintain complete insurance transaction history by participant
               (including premium payment history and history with multiple employers) with
   IA 11.00    date and time stamp.
               System should provide user defined multi-step workflow for all insurance
   IA 12.00    events
   IA 13.00    System must meet requirements of COBRA
   IA 14.00    System must meet requirements of HIPAA
               System should allow insurance transactions to be retroactive, subject to user
   IA 15.00    defined edits by transaction type
               System must provide the ability to cancel transactions (rather than reverse
   IA 16.00    and reenter) subject to pre-defined edit criteria and security.
               System must provide a flexible notification capability that allows the user to
               define content, rules for production, and distribution method (email or US
   IA 17.00    mail).
    RFP Attachment 6.8                                              Insurance Administration Requirements                                               IA2
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                    System Requirements                                 Response                   Comments                  Modify
   IA 18.00     System must maintain notifications and record in the employees history.
                System should allow notifications to be sent to insurance administration
   IA 19.00     based on user option
                System should allow notifications to be viewable and retrievable by insurance
   IA 20.00     administration based on user option
                System should provide ability to provide comments for participants, HOC,
   IA 21.00     dependents, vendors, etc based on user defined security level.
                System must provide for user defined batch processing for various control
   IA   22.00   purposes, such as:
   IA   22.01        Checking the validity of current eligibility information
   IA   22.02        Check for duplicate SSN's
   IA   22.03        Applying premium updates
                     Automatically changing enrollment coverage from family to single when
   IA 22.04          no dependents are enrolled
                System to provide browser based participant self service capability for the
   IA 23.00     following insurance functions:
   IA 23.01          Current insurance elections and costs
   IA 23.02          Explanation of insurance options
                   Enrollment into insurance plans for all participants and their dependent
                   consistent with eligibility rules defined in Insurance Administration
   IA   23.03
   IA   23.04      Maintenance of dependent information
   IA   23.05      Insurance package pricing worksheet (participant costs)
   IA   23.06      Insurance eligibility validation at time of enrollment
   IA   23.07      Enrollment options (e.g., cost of two party vs. family coverage)
                   Inquiry of premiums paid and current premiums due with draw down
                   detail on each collection, as to how it was received, used, refunded,
   IA 23.08        cancelled…etc.
                   Link to third party administrators as appropriate to provide detailed
   IA 23.09        information as appropriate.
                   Provide ability for participants and retirees) to use the self service
   IA   23.10      capabilities with appropriate security
   IA   23.11      Ability to provide a third party link to employee's self service options.
   IA   24.00   System should provide the ability to nullify transactions:
   IA   24.01      If updates have occurred nullified transactions should remain in history
   IA   24.02      If updates have not occurred nullify transaction and delete record.

    RFP Attachment 6.8                                             Insurance Administration Requirements                                               IA3
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
                System should be compatible with Interactive Voice Response and TTY
                systems to allow participants to establish and modify specified enrollment
   IA 25.00     information
                System should track Insurance participant with both Social Security Number
                and generic identification number. Generic identification number is used on
   IA 26.00     all letters issued by the system.
                System should provide passive and returnable codes HELP screens must be
   IA 27.00
                available to the users
   IA   28.00   System should provide user manual available online for user access
   IA   29.00   System should automatically notify participants of:
   IA   29.01        Program eligibility
   IA   29.02        Program terminations or changes
   IA   29.03        Dependents ineligibility
   IA   29.04        COBRA eligible for Head of Contact (HOC) or dependent
   IA   30.00   System should purge data according to user defined criteria
                System should provide the ability to inquire on the status of a pending
   IA 31.00     transaction, both online and through ESS.
                                         Insurance Plan Administration
   IA 32.00     System should create ACH files in PPD consumer format.

                System should have data defaults that comply with Civil Service Rules, Court
   IA 33.00     Orders, State law, Federal requirements and State Policies & Procedures.
                System should support various types of benefit plans, including, but not
   IA   34.00   limited to the following:
   IA   34.01        Medical
   IA   34.02        Life/accident Insurance
   IA   34.03        Dental
   IA   34.04        Optional life/accident insurance
   IA   34.05        Long term disability
   IA   34.06        Short term disability
   IA   34.07        Retirement Insurance
   IA   34.08        Long term care
   IA   34.09        Medicare supplement
   IA   34.10        Wellness
   IA   34.11        Employee Assistance Program
   IA   34.12        New benefit plans as may be approved in the future
    RFP Attachment 6.8                                            Insurance Administration Requirements                                               IA4
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                   System Requirements                                  Response                   Comments                  Modify
                System should support multiple versions of benefit plans. Plan versions are
   IA 35.00     processed based on effective date.
                System should track demographic and enrollment data for analysis of specific
   IA 36.00     plans
                System should provide the ability to add a new entity, change, or terminate
                an existing entity (Central state, K-12 school systems, local government,
   IA 37.00     higher ed., other quasi-governmental agencies).
                System should provide the ability to collect insurance premiums from multiple
   IA 38.00     entities
                System should allow the user to determine insurance premiums source and
   IA   39.00   bills accordingly
   IA   39.01       Payroll
   IA   39.02        Retirement Payroll
   IA   39.03       Cash, Check, Money Order
                   Entity ACH to collect premiums for all of their employees from the entity's
                   bank account and apply premiums to each employee individually.
   IA 39.04
                   Individual ACH to collect premiums from a private account (all individuals
   IA 39.05        State, Teacher, Local Government, active and inactive).
                System should provide the ability to specify the amount of excess premiums
                paid that should be refunded to either the participant or agency.
   IA 40.00
                Systems should provide the ability to net the premiums over paid from the
   IA 41.00     current premiums due for an entity.
                System should provide the ability to add and accurately process premiums
                for short term enrollments. (COBRA enrollment for one or two month period).
   IA 42.00
                System should allow the user to determine if overages should be refunded or
   IA 43.00     used for additional coverage months.
                System should provide the option to elect or not elect pre-tax medical &
   IA 44.00     dental insurance premium deductions.
                System should provide the ability to backup system data in the event of a
   IA 45.00     disaster.
                System should be able to produce multiple (20 or more) vendor interface files
   IA 46.00     daily.


    RFP Attachment 6.8                                            Insurance Administration Requirements                                                IA5
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                             Hours to
   Number                                     System Requirements                                  Response                   Comments                  Modify
                System should maintain all notifications for a period as determined by the
   IA 47.00     Benefits Administrator
   IA 48.00     System should provide ESS inquiry to all insurance related data.
                                          Insurance Plan Eligibility
                System should maintain multiple eligibility dates for different benefit plans
   IA 49.00     based on different rules for the plan and the participant
                System should maintain eligibility rules by benefit plan with variables
   IA 50.00     including:
   IA 50.01         Plan type
                    Group (Central state, K-12, local government, higher ed., other quasi-
   IA   50.02       governmental agencies)
   IA   50.03       Required participant status for coverage
   IA   50.04       Geographic coverage
   IA   50.05       Waiting period
   IA   50.06       Minimum hours worked
   IA   50.07       Dependent coverage
   IA   50.08       Which dependents are eligible
   IA   50.09       Medicare eligibility
   IA   50.10       COBRA eligible
   IA   50.11       HIPAA requirements
                   Ability to enroll during annual enrollment (yes, no, only if in another plan)
   IA   50.12
   IA   50.13      Prior plan requirement (which plans qualify)
   IA   50.14      May continue on leave without pay
   IA   50.15      How long eligible after leave begins
   IA   50.16      Type of leave (military, workers compensation, etc..)
   IA   50.17      Track leave without pay for limitations
   IA   50.18      May continue if disabled
   IA   50.19      Dependents eligible after participant death
   IA   50.20      How long eligible after participant death
   IA   50.21      Reinstatement after return from leave without pay
   IA   50.22      Reinstatement period
   IA   50.23      Reinstatement rules after return from military leave
   IA   50.24      Continue after retirement
   IA   50.25      Employment status (full time, part time, etc.)
   IA   50.26      Job class

    RFP Attachment 6.8                                              Insurance Administration Requirements                                                IA6
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                             Hours to
   Number                                     System Requirements                                  Response                   Comments                  Modify
   IA   50.27        Effective date
   IA   50.28        Hire date
   IA   50.29        Age of head of contract
   IA   50.30        Age of dependents
   IA   50.31        Hours worked by period
   IA   50.32        Wage base
   IA   50.33        Chart of account fields
   IA   50.34        System provides over-ride capabilities
                System should provide for various types of enrollment consistent with
   IA 51.00     eligibility rules, including:
                     Enrollment of new hires and rehires within a user defined period of hire
   IA   51.01        date
   IA   51.02        Annual enrollment transfer period
   IA   51.03        Late enrollment with medical underwriting
   IA   51.04        Special enrollment due to HIPAA qualifying event
                System should provide Insurance Administration the ability apply status’s to
   IA 52.00     insurance programs:
                     “open” - in this case, participants may be enrolled in this program as of
                     the effective date of the program. All normal processing may be done
   IA 52.01          against “open” programs, including retroactive transactions.
                     “closed but active” - in this status, participants cannot be newly enrolled
                     in the program after the close effective date, however all normal
                     processing, including retroactive transactions may be carried out against
   IA 52.02          the program.
                     “inactive” - inactive programs may not have any processing done against
   IA 52.03          them.
                System should continue providing vendor interfaces for a user specified
   IA 53.00     period after program becomes inactive for claims run off.
                System should provide notifications to participants of benefit eligibility when
                eligibility begins or changes and as part of the annual enrollment process
   IA 54.00     (email and letter)
                System should provide notification (email or letter) to Insurance
   IA 55.00     Administration that participant's eligibility is beginning or changing
                System should process split eligibility (both spouses both work for the State)
                for certain types of benefits based on user defined options, including:
   IA 56.00

    RFP Attachment 6.8                                              Insurance Administration Requirements                                                IA7
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
                                             nd
                    System must notify the 2 party spouse and their agency designated
                    benefits assistant of changes including but not limited to the cancellation
                    of the 1st party spouse's enrollment so appropriate changes can be
   IA 56.01         completed.
                    2nd party spouse must also receive a notice showing the additional
                    amounts owed and requesting dependent enrollment of the terminating
   IA 56.02         spouse.
                    ERP Insurance Administration must provide both agencies designated
                    benefits assistants with the capability of viewing details about both
   IA 56.03         “sides” of split contracts via on-line inquiry.
   IA 56.04         System must be able to link both parties
                System must support participants with dual eligibility (ex - State agency and
   IA 57.00     local school district)
                System should prevent participants from being enrolled in a plan for which
   IA 58.00     they are not eligible, with secured override capability for exceptions
                System should provide for processing the following insurance eligibility
   IA 59.00     events:
   IA 59.01         Establishment and maintenance of participant information
   IA 59.02         Establishment and maintenance of dependent information
                    Activation of coverage for participant, spouse, and non-spouse
   IA 59.03         dependents
                    Activation of coverage for survivors (former dependents of participants
   IA   59.04       that are allowed to continue their insurance coverage)
   IA   59.05       Maintenance of beneficiary information for multiple products
   IA   59.06       Extended coverage of dependent
   IA   59.07       Medicare eligibility
                    Initiation of COBRA notification processing when an individual’s coverage
   IA 59.08         is terminated due to a COBRA qualifying event
   IA 59.09         Evidence of insurability
   IA 59.10         Terminating/retiring participants
                    Termination of coverage for participant, spouse, and non-spouse
   IA 59.11         dependents
                System should automatically generate notification (email or notification) to
   IA 60.00     participants based on certain events such as:
                    Prior to obtaining Medicare Eligibility by virtue of age with the exception
   IA 60.01         of selected former officials.
    RFP Attachment 6.8                                             Insurance Administration Requirements                                                IA8
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                     FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                             Hours to
   Number                                    System Requirements                                   Response                   Comments                  Modify
   IA   60.02        Prior to dependent’s l9th birthday
   IA   60.03        Prior to dependent’s 24th birthday
   IA   60.04        Proof of continuing eligibility (receipt of proof, i.e. college transcript)
   IA   60.05        By semester for ages 19-25
   IA   60.06        Beginning and end of COBRA eligibility
                System should provide participant insurance enrollment verification
                notification indicating choices and associated information (i.e., levels of
   IA   61.00   coverage, deduction amounts) via the following methods:
   IA   61.01        Email
   IA   61.02        Letter
   IA   62.00   System should provide a chronological history of insurance elections
   IA   63.00   System should process eligibility of COBRA eligible individuals:
                     System allows for the tracking of COBRA eligibility based on user-defined
   IA 63.01          criteria.
                     System should provide ability to establish appropriate qualifying events
                     that will initiate COBRA processing, and should generate standard letters
   IA   63.02        notifying participant of COBRA eligibility.
   IA   63.03        Extend COBRA eligibility and enrollment due to disability.
   IA   63.04        Prepare COBRA billings and issue accordingly.
   IA   63.05        Track COBRA payments based on pre-defined criteria.
                System should allow for dependent to become "head of contract" and track
   IA 64.00     appropriate history
                System should provide the capability for automated detection of expiration of
                insurance eligibility and subsequent termination of enrollment based on pre-
   IA 65.00     defined criteria.
                     Automatically provide notifications (email or U.S. Postal) advising of
   IA 65.01          pending cancellation.
                System should provide ability to monitor work location and residence address
                changes and trigger notification of those events effecting all insurance and
   IA 66.00     eligibility.
                System should allow for temporary SSN's and the ability to change a SSN for
   IA 67.00     both the HOC and/or a dependent.
                System should only display insurance programs for which the participant is
   IA 68.00     eligible
   IA 69.00     System should maintain eligibility history for participant


    RFP Attachment 6.8                                             Insurance Administration Requirements                                                 IA9
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                   System Requirements                                   Response                   Comments                  Modify
              System should determine life coverage amounts based upon user defined
              age and salary criteria at a fixed point in time, not as changes occur.
   IA 70.00
              System should allow enrollment coverage to be extended beyond normal end
   IA 71.00   rules based on user defined extension criteria
   IA 72.00   System should provide scanning abilities and links to coordinating fields.
              System should provide the user the ability to enter all elected benefits at one
   IA 73.00   time or separate time if within the enrollment time frame
              System should provide the ability to enter effective dates of enrollment
              across plan years or premium years. (Ex: Effective 1/1/ each year there are
              new premium rates, system should provide the ability to enter an effective
              date of 12/1 and calculate both the old premium and new premium.)
   IA 74.00
              System should provide the ability to add, change or terminate coverage with
   IA 75.00   a future effective date.
              System should provide the ability to transfer individuals with a future effective
   IA 76.00   date.
              System should provide the ability to add COBRA dental coverage and
              automatically calculate the correct begin date, end date, and amount due, for
   IA 77.00   a retiring individual.
   IA 78.00   System should provide the ability for same day error corrections.
              System should provide the ability to correct an individuals enrollment and
   IA 79.00   issue a corrected billing statement (invoice) if applicable.
              System should provide the ability to extend COBRA enrollments for an
   IA 80.00   additional specified period and bill the individual accordingly.
                                            Insurance Plan Costs
              System should provide for the following financial processes associated with
   IA 81.00   insurance administration, including:
   IA 81.01       Billing of direct premium payers for costs of group insurance
                  Remittance advices will be produced monthly for direct payment
   IA 81.02       participants
                  Additional remittance advice will be prepared immediately if a payment is
   IA 81.03       received that is insufficient to balance due
                  Daily notification to vendors to hold processing of claims for payments
   IA 81.04       that have been returned due to insufficient funds.


    RFP Attachment 6.8                                            Insurance Administration Requirements                                                IA10
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
                   Daily notification to vendors to process claims when sufficient payment
   IA 81.05        has been received.
                   Automatic termination of coverage if an insufficient payment is received
   IA 81.06        twice for the same coverage period
                   Direct bill participants should receive one invoice that shows premium
   IA 81.07        amounts due for all insurance programs in which they are enrolled
                   Billing of agencies for insurance for the entire group while maintaining
   IA 81.08        individual eligibility
                   Billing of external agencies for insurance for the entire group while
   IA 81.09        maintaining individual eligibility
                   Ability to specify collection method for covered individual, group, or
   IA 81.10        agency internally or externally.
                   Online entry of cash receipts from direct premium payers (scanned data
   IA 81.11        from Department of Revenue or direct online entry)
                   If premiums are delinquent, the system must apply payments to the
   IA   81.12      oldest balances first in the user defined hierarchy.
   IA   81.13      Processing of prepayment of premiums
   IA   81.14      Returned payments due to insufficient funds
   IA   81.15      Calculation and processing of payments to benefit vendors
   IA   81.16      Electronic transmission of eligibility information to benefit vendors
   IA   81.17      Refund of insurance premiums to participants
   IA   81.18      Refund of insurance premiums to agencies
                   Maintain separate record of premiums and fees billed, collected or
   IA 81.19        outstanding from either participant or employer.
   IA 81.20        Forfeitures of FLEX insurance amounts
                   Accounting entries must have the ability to track to individual participants
   IA 81.21
   IA 81.22         Integration of all financial entries to the financial system
                    Ability to recover money for claims paid in error. Recovered money can
   IA 81.23         be from employee or agency/department.
                System should provide at least the following methods of calculating
                participant and or participant/agency premium costs or contribution amounts:
   IA   82.00
   IA   82.01      Percentage
   IA   82.02      Flat amount
   IA   82.03      Wage type(s) to include in calculation

    RFP Attachment 6.8                                             Insurance Administration Requirements                                               IA11
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                    System Requirements                                 Response                   Comments                  Modify
   IA   82.04        Wage as of date for calculations
   IA   82.05        Individual, individual or spouse, family
   IA   82.06        Pre or post taxable income calculation
   IA   82.07        Monthly limit
   IA   82.08        Quarterly limits
   IA   82.09        Annual limits
   IA   82.10        Age
   IA   82.11        Amount of coverage
   IA   82.12        Frequency
                     Group (Central state, K-12 school systems, quasi governmental
   IA   82.13        agencies, and higher ed.)
   IA   82.14        Premium level
   IA   82.15        Benefit/product
   IA   82.16        Agency
   IA   82.17        Administrative fee
                     System should be able to split premium cost between participant and
   IA 82.18          employer based on user defined criteria.
                System should calculate costs based on effective date with more than one
   IA 83.00     cost effective during a particular period.
                System should collect employer portion of delinquent premium when
   IA 84.00     participants portion is paid
                System should provide the ability input specific premium amounts for any
   IA 85.00     coverage for any period (override system calculated amount)
                System should provide for deferral of premium costs if pay or premium paid
   IA 86.00     is insufficient based on user defined option and duration
                System should provide ability to automatically cancel participants insurance
   IA 87.00     after user defined period of unpaid premiums
                System should provide support for the refunding or applying overpayments
   IA 88.00
                System should provide for continued participant deductions when coverage
                cancelled if original election paid premiums from pre-tax wages. These must
                be accounted for properly and kept separate such that refunds are not made
   IA 89.00     to participants without approval.
                System should maintain employer and participant demographic information
                both current and historical must be maintained and retrievable in the system
   IA 90.00

    RFP Attachment 6.8                                             Insurance Administration Requirements                                              IA12
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                    System Requirements                                 Response                   Comments                  Modify
                System should provide the ability to maintain an alternate address record for
   IA 91.00     all participants.
   IA 92.00     System should allow for addresses outside of the United States.
                System should provide the ability to track, refund, and apply excess funds to
   IA 93.00     all transactions subject to user defined rules
                System should provide detailed data for user approved refund or
   IA   94.00   reimbursement amounts and the ability to view related data:
   IA   94.01     Associated collection
   IA   94.02     Amount of refund/reimbursement
   IA   94.03     Status and dates
   IA   94.04     Recipients
   IA   94.05     Type of payment, ACH, check, etc.
                System should provide the ability to apply retroactive changes, for example:
   IA 95.00
   IA 95.01        Adjust large groups of participants when rates change
   IA 95.02        Verify eligibility if eligibility rules change
                   Apply retroactive changes to a single participant or a combination of
   IA   95.03      participant and employer
   IA   96.00   System should accumulate benefit costs by one or a combination of:
   IA   96.01      Agency (organization at user specified level)
   IA   96.02      Bargaining unit
   IA   96.03      Benefit type
   IA   96.04      Plan
   IA   96.05      Vendor
   IA   96.06      Participant
   IA   96.07      Other Charts of Accounts
                System should provide the ability for the Benefits module to generate
   IA 97.00     Accounting entries for:
   IA 97.01        Recording monies received as unearned.
                   Reduce unearned monies and recognize revenue as coverage is
   IA 97.02        certified.
                   Reduce revenue and record unearned revenue for retroactive payments
   IA 97.03
                System should be integrated with Cash Management for processing
   IA 98.00     insufficient checks or ACH collections.


    RFP Attachment 6.8                                             Insurance Administration Requirements                                              IA13
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
             System should provide the ability to post a collection to an individuals
   IA 99.00 account not to a specific program or benefit type.
   IA 100.00 System should use monies according to user defined priority
             System should maintain participant premium or contribution history and
   IA 101.00 agency cost history on-line by:
   IA 101.01      Plan
   IA 101.02      Participant
   IA 101.03      Vendor
   IA 101.04      Notification
                              Insurance Vendor / Contract Administration:
             System should provide interfaces to and from vendor and insurance module
   IA 102.00 for:
   IA 102.01    Plan costs
   IA 102.02    Deduction amount
   IA 102.03    Enrollment
   IA 102.04    Eligibility
   IA 102.05    Utilization
   IA 102.06    Other user defined parameters
             System should provide the vendor daily notification when coverage has been
   IA 103.00 certified, when a past due premium is received.
   IA 103.01    Due to the collection and certification of a month's premium
   IA 103.02    Due to the collection and certification of a previous month's premium
             System should provide the ability for vendor payments to be automatically
             calculated by the system for review, modification, and release by authorized
   IA 104.00 users
             System should provide the vendor daily notification of un-certified coverage,
             if a payment is marked insufficient or coverage is cancelled for non-payment
   IA 105.00 of premium.
             System should support payments (through financial system) to vendors for
   IA 106.00 administrative fees
             System should support payments (through financial system) to vendors for
   IA 107.00 premiums
             System should provide tracking of vendors compliance with contract
   IA 108.00 performance guarantees



    RFP Attachment 6.8                                           Insurance Administration Requirements                                              IA14
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
               System should provide the ability to terminate coverage for all active and
               former (COBRA or Retired) participants of an agency when the agency
   IA 109.00   terminates coverage
               System should provide the ability to terminate all coverage associated with a
   IA 110.00   vendor that is being replaced
               System should continue to provide interfaces with terminated vendors for a
   IA 111.00   user specified period of time after termination.
               System should provide the ability to retain program information when vendors
   IA 112.00   are replaced
               System should provide the ability to transfer whole groups to new vendor
   IA 113.00   coverage

   IA 114.00 System should provide notification of specified eligibility changes to vendors.
             System should provide 3rd party vendor secured links to participant data and
   IA 115.00 related benefit information.
             System must provide ability to scan contracts linking them to the associated
   IA 116.00 programs and/or plans
             System should provide analysis and “WHAT-IF” capabilities for contract
   IA 117.00 analysis purposes
             System should provide the ability input specific premium amounts for any
   IA 118.00 coverage for any period (override system calculated amount).
                                  Reporting and Query Requirements
             System should provide for online access to all participant, plan, and vendor
   IA 119.00 data with appropriate security
             System should include a flexible report writing capability that will allow reports
   IA 120.00 to be formatted easily by user.
             System should have the ability to project and inquire on future premiums due
   IA 121.00 by individual, group, etc.
   IA 122.00 System should produce State's current standard reports.
   IA 123.00 System should utilize data from vendor for analysis of specific plans:
   IA 123.01     Costs by plan
   IA 123.02     Costs by benefit type
   IA 123.03     Costs by vendor
   IA 123.04     Utilization
   IA 123.05     Comparison reporting
   IA 124.00 System should provide online participant information

    RFP Attachment 6.8                                             Insurance Administration Requirements                                               IA15
    State of Tennessee                                                                                                                      RFP # 317.03-134
    Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                             Hours to
   Number                                     System Requirements                                  Response                   Comments                  Modify
   IA   124.01        Participant
   IA   124.02        Dependents
   IA   124.03        Benefit elections and dates
   IA   124.04        Hire date
   IA   124.05        Benefit history
   IA   124.06        Costs and contributions
                 System should provide the ability to name search on for head of contract and
   IA 125.00     dependents
                 System should track and monitor utilization of benefit plans by various
   IA 126.00     criteria.
                 System should produce vendor reports that provides the following
   IA   127.00   information on detailed and summary reports:
   IA   127.01        Plan participation
   IA   127.02        Plan revenues
   IA   127.03        State costs by vendor
                      Provide reporting for Agencies that provides the following on detailed and
   IA   127.04        summary reports:
   IA   127.05        participant participation by plan
   IA   127.06        Costs by plan
   IA   127.07        Costs by organizational unit
   IA   127.08        Costs by benefit type
   IA   127.09        Participants eligible but not participating
   IA   128.00   System should be able to print mailing labels for:
   IA   128.01        All participants
   IA   128.02        Participants within a given benefit plan
   IA   128.03        Participants within a given benefit status
   IA   128.04        Participants within a given Bargaining Unit
   IA   128.05        Participants within a given job class
   IA   128.06        Participants by residential and/or work locations
   IA   128.07        Participants within a given Agency, by index, by location code
                 System should provide reports reflecting eligible participants not enrolled in
   IA 129.00     benefit plans.
                 System should provide report listing participants that will have premium
   IA 130.00     increases on the next cycle
                 System should provide inquiry showing all excess amounts for a participant
   IA 131.00

    RFP Attachment 6.8                                              Insurance Administration Requirements                                               IA16
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                   System Requirements                                  Response                   Comments                  Modify
             System should produce rosters of participants in specific benefit plans in
   IA 132.00 various sequences.
             System should produce report of purged data per individual upon user
   IA 133.00 request
               System should provide capability to compare data from outside the system to
               data within the system for discrepancy or identification reporting (data match)
   IA 134.00
             System should take advantage of sorting software for printed
   IA 135.00 correspondence that is to be distributed through the U. S. Postal.
             System should take advantage of bar-coding on printed correspondence that
   IA 136.00 is to be distributed through the U. S. Postal.




    RFP Attachment 6.8                                            Insurance Administration Requirements                                               IA17
State of Tennessee                                                                                            RFP 317.03-134
Project Edison
                              FUNCTIONAL REQUIREMENTS MATRIX                                                        10/21/05




                                                     Personnel Administration

                     Personnel Administration addresses maintenance of information pertaining to each employee.
                     This information includes the following:

                           New Hire Records
                           Maintaining Employee Data
                           Personnel Actions (promotion, demotion, salary increase, extended leave)
                           Separating Employee Records
                           Tracking Disciplinary Actions and Grievances
                           Longevity
                           Employee Suggestion Award Program
                           Performance Evaluations
                           Reductions in Force




RFP Attachment 6.8                                       Introduction                                                     ii
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
                           Personnel Administration General Requirements
              The system should have the ability to store and maintain all personnel
              information for each employee, including personnel actions, employee
  PA 1.00     demographics and chronological history of employment.
              System should provide the ability to have an employee number field other
  PA 2.00     than the Social Security Number to act as the employee's key.
              System should provide the ability to use the same key other than the Social
  PA 3.00     Security Number for employees who are rehired with the State.
              When employees are rehired, the system should link all previous
  PA 4.00     employment information to the new record.
              System should provide the ability to automatically assign an employee
  PA 5.00     number with the ability to edit for dual or existing employee numbers.
              System should store and retrieve employee data in numerous individual and
  PA   6.00   aggregate formats for such purposes as:
  PA   6.01       Employee Relations' negotiations
  PA   6.02       Affirmative Action
  PA   6.03       Performance Evaluations
  PA   6.04       Employee Suggestion Award Program
  PA   6.05       FLSA and EEO-4 reporting
  PA   6.06       Employee Training History
  PA   6.07       Education, Skills Bank
  PA   6.08       Other, user defined.
              System should include an integrated imaging capability for linking scanned
  PA 7.00     data to personnel records as part of an organized electronic personnel file.
              System needs to interface with FileNet for content management for at least
  PA   8.00   the following:
  PA   8.01       Supporting documents for any type of transaction
  PA   8.02       Performance Evaluations
  PA   8.03       Other, user defined.
              System should provide for the usage of electronic signature at each approval
  PA 9.00     step.
              System should allow the maintenance of an employee’s data to be
              accomplished by all key agencies that have the need and the security to
  PA 10.00    review/edit this data.

    RFP Attachment 6.8                                           Personnel Administration Requirements                                              PA1
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
               System should provide the ability to automatically set up default security
  PA 11.00     access to the system as employees are hired.
               System should provide the ability to automatically delete security access to
               the system as employees are separated from State service using a user
  PA 12.00     defined date parameter.
               System should provide the ability to automatically delete security access to
               the system as employees are transferred within or between agencies using a
  PA 13.00     user defined date parameter.
  PA 14.00     System should allow future dated personnel transactions.
               System should have the ability to cancel transactions that are future dated to
  PA 15.00     the payroll cycle.
               System should provide the ability to create, edit and view employee data for
  PA 16.00     all effective dates and maintain historically (history, current, future).

  PA 17.00     System should have the ability to purge transactions based on court orders.
               System should have the ability to purge transaction history based on court
  PA 18.00     orders.

               The system should adhere to and comply with all Civil Service Rules, Court
  PA 19.00     Orders, State law, Federal requirements and State Policies & Procedures.
               The Personnel component should maintain and support all the basic
               employee data through the life of the employee’s involvement with the State
               of Tennessee. The Personnel record for the employee begins at the time the
               individual’s application is accepted for employment consideration.
               Maintenance continues through the hiring process, through all promotions,
               transfers, job changes and other personnel changes through separation from
  PA 20.00     the State.
               System supports functionality for contract workers, volunteer workers, and
  PA 21.00     other non-employees.
               Personnel Administration will be integrated with components of the State
  PA   22.00   ERP system including:
  PA   22.01       Benefits Administration
  PA   22.02       Position Control
  PA   22.03       Applicant Tracking
  PA   22.04       Payroll
  PA   22.05       Timekeeping/Leave Accounting

    RFP Attachment 6.8                                            Personnel Administration Requirements                                              PA2
    State of Tennessee                                                                                                                        RFP # 317.03-134
    Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

  Reference                                                                                           Vendor                                             Hours to
   Number                                     System Requirements                                    Response                   Comments                  Modify
  PA   22.06       Classification/Compensation
  PA   22.07       Training
  PA   22.08       Budget
  PA   22.09       General Ledger.
  PA   23.00   System interfaces with the following:
  PA   23.01       Employee retirement system
  PA   23.02       Worker's comp
  PA   23.03       TENNCARE
  PA   23.04       Postal Service
  PA   23.05       State's E-mail Systems
  PA   23.06       Social Security Administration
  PA   23.07       State licensing agencies (DMV, Health, Commerce & Insurance, etc.)
  PA   23.08       Unemployment insurance
  PA   23.09       Secretary of State's Division of Charitable Solicitation
  PA   23.10       Felony Database (NCIC)
  PA   23.11       Others as defined by the State.
               System assigns and tracks multiple restrictions and/or requirements to
               position (i.e., physical requirements / restrictions, licenses, fingerprinting,
  PA 24.00     drug program, criminal history, Certifications, etc.) by agency.
               The system should provide an appropriate level of security such that
               confidential data is not readily available to those not qualified to receive it via
  PA 25.00     report or view it via screen.
               System should provide ability to designate certain employee information data
               as “confidential”, i.e., social security number and restrict access accordingly
  PA 26.00     through security.
               System should allow employee to designate address and contact information
  PA 27.00     as available for release (home phone, address, and email).
               System provides user defined multi-step approval/workflow for review and
  PA 28.00     approval of all personnel transactions.
  PA 29.00     System should provide unlimited number of approvals.
               System should provide templates for freeze exemption requests and other
               exception requests that are created in the agency and processed through
  PA 30.00     workflow for approval.
               System should provide for the creation of an agency employee directory
               containing business address, business phone and e-mail. This directory
  PA 31.00     should be viewable through the use of an industry-standard web browser.

    RFP Attachment 6.8                                              Personnel Administration Requirements                                                 PA3
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
               System should provide the ability to capture and report on employee turnover
  PA   32.00   by agency or statewide.
  PA   33.00   System tracks employee turnover rate by user defined criteria, including:
  PA   33.01        Gender
  PA   33.02        Ethnicity
  PA   33.03        Appointment to class date
  PA   33.04        Transfer
  PA   33.05        Age
  PA   33.06        Classification
  PA   33.07        Probation release
  PA   33.08        Termination
  PA   33.09        ADA qualified
  PA   33.10        Promotion
  PA   33.11        Disciplinary release
  PA   33.12        Resignation
  PA   33.13        Demotion
  PA   33.14        Months of Service
  PA   33.15        Appointment type
  PA   33.16        Other, user defined.
               System should support the tracking of Employment Eligibility Verification (I-
  PA 34.00     9s).
               System should provide the ability to link one position to another for the
  PA 35.00     purpose of identifying superior/subordinate relationships.
               System should provide the ability to produce organizational charts by
               maintaining employee specific reporting levels (both current and historical).
  PA 36.00
               System should provide the ability to designate when an employee may hold
  PA 37.00     more than one position by Agency and job class.
               When an employee occupies more than one position, the system should
  PA 38.00     provide the ability to designate one as primary.
               System should provide the ability to designate multiple employees per
  PA 39.00     position.
               When more than one employee occupies a position, the system should
               provide the ability to designate one as primary (incumbent) and the other
               employees as "overlapped" employees (name given to other employees
  PA 40.00     occupying the same position as the incumbent).
    RFP Attachment 6.8                                            Personnel Administration Requirements                                              PA4
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify

               System should provide the ability to designate unlimited part-time employees
               in a job-share status in one position with the following requirements:
  PA 41.00
                    Total hours for all employees in the position should not exceed standard
  PA 41.01          hours for the pay period and/or fiscal year.
                    All employees in the position are not required to be the same
  PA 41.02          classification.
               System should track the costs associated with having more than one
  PA 42.00     employee in a position.
               System should provide the ability to assign an employee classification that is
  PA 43.00     different from the position classification (mismatch situation).
               System should provide the ability to place part-time employees in full-time
  PA 44.00     positions.
               System should provide for employee self service with at least the following
  PA 45.00     (additional items in Benefit Administration, Timekeeping, etc.):
                    Maintenance of personal data (name, address, W-4 information, marital
  PA 45.01          status, emergency information, etc.)
                    Enter and review the status of suggestions provided under the employee
  PA   45.02        suggestion program
  PA   45.03        Enter performance evaluation information
  PA   45.04        Exit interviews (agency specific)
  PA   45.05        Employee Orientation (agency specific)
  PA   45.06        View their own employment information
  PA   45.07        Generate Information for Loan Documents
  PA   45.08        Configurable by the State with the appropriate security.

               System should inform the employee of required supporting documentation
  PA 46.00     when information or forms are updated through employee self service.
               System should notify or route forms through workflow to appropriate staff
  PA 47.00     within the agency as updates are made through employee self service.
  PA 48.00     System should provide the ability to maintain exit interview data.
               System easily processes reorganization. Capabilities that must be included
  PA   49.00   are:
  PA   49.01       Move organization units between higher level organization units
  PA   49.02       Combine organization units of the same level
  PA   49.03       Provide history on all reorganizations.

    RFP Attachment 6.8                                            Personnel Administration Requirements                                              PA5
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
              Reorganizations should also update personnel, payroll, budget, benefits,
              training and financial information as appropriate once approved and
  PA 50.00    accepted.
              System should provide ability to reallocate positions and the individuals
  PA 51.00    within those positions globally. (Mass Changes)
              System should provide the ability to change classification information and
  PA 52.00    adjust individuals within those classifications globally. (Mass Changes)
              System should provide that new hire or employee change data be edited
  PA 53.00    against the position table for class and salary grade/pay level.
              System should provide ability to link the FLSA status to a position and
              provide the option to override the FLSA status through the employee
  PA 54.00    assignment.
              System should provide the ability to edit employee information based on all
              Fair Labor Standards Act requirements, especially new requirements
  PA 55.00    effective as of August 2004.
              System should provide the ability to survey agencies automatically including
  PA 56.00    the following capabilities:
  PA 56.01         Ability to create user designed surveys
  PA 56.02         Ability to report statistics from the user defined survey.
              System should provide a job satisfaction survey component to be
  PA 57.00    electronically administered to new employees on user-defined dates.
              System should provide the capability to coordinate and manage feedback
  PA 58.00    sent electronically from an employee.
              System should provide the ability to perform key-word text search on job
  PA 59.00    classification data.
              System should provide the ability to track property assigned to employees
  PA 60.00    (laptop, computers, beepers, cell phones, uniforms, etc.).
  PA 61.00    System should provide the ability to store employee photograph.
              System should provide the ability to maintain employee background check
  PA 62.00    information.
              System should provide the ability to maintain multiple work locations by town,
  PA 63.00    and address.
              System should provide the ability to document periods of employment earned
  PA 64.00    outside the State's system (service with a State University).
  PA 65.00    System should provide the ability to maintain employee data by:


    RFP Attachment 6.8                                           Personnel Administration Requirements                                              PA6
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
                    Employment type and status (regular, temporary, seasonal, retiree, full or
  PA 65.01          part-time, etc.
  PA 65.02          Work schedules (37.5 or 40.0 hour per week employee).
               System should provide the ability to specify benefit and accrual eligibility for
  PA 66.00     time reporting.
               System should provide the ability to monitor time periods for certain
               appointment types or transactions (emergency, interim, flex classifications,
  PA 67.00     retiree, etc.).
               System should provide the ability to maintain the following for employees
               receiving temporary pay adjustments (pay/shift differentials, working out of
  PA   68.00   class adjustments).
  PA   68.01        More than one base salary amount
  PA   68.02        More than one temporary pay adjustment type
  PA   68.03        Percentage received for each temporary pay adjustment

  PA 68.04         Reason for temporary pay adjustment type identified on position record.
               System should provide the ability to view all compensation associated to
               employee's position (salary, stipend, tips, housing allowances, or user
  PA 69.00     defined).
               System should provide the ability to create an individual statement of
  PA 70.00     benefits.
               System should provide the ability for employee level calculations/modeling of
  PA 71.00     gross-to-net, tax/benefit options, etc., for "what if" questions.
               System should provide the ability for online comparison of data at two or
  PA 72.00     more points of time.
               The system should support the approximate volumes presented below plus
  PA 73.00     annual growth of 10% for the next 10 years:
                   Employees - 50,000 plus possibly over 200,000 to house records for
  PA 73.01         insurance participants
  PA 73.02         New hires per month - 700
  PA 73.03         Personnel transactions per month - 3,000.
               System should provide the ability to track service months by job classification
  PA 74.00     for each employee.
               System should provide the ability to track level of experience (i.e.,
               professional, technical, clerical, etc.) for each job classification held by an
  PA 74.01     employee.
    RFP Attachment 6.8                                             Personnel Administration Requirements                                               PA7
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
                            Employee Maintenance / Personnel Data Changes
              Employee data changes may be entered at any location as controlled by
  PA 75.00    security.
              System should provide the ability to enter unlimited transactions with the
              same effective date (per employee with date and time) with a user defined
  PA 76.00    hierarchy.
              System should provide the ability to transfer employees within their agency
              and between agencies on any day of the month and provide accurate pay
  PA 77.00    calculations.
              System should provide the ability to transfer employees between pay types
              (monthly or semi-monthly) on any day of the month and provide accurate pay
  PA 78.00    calculations.
              System should provide the ability to make multiple salary adjustments for the
              same pay period with different effective dates and provide accurate pay
  PA 79.00    calculations.
              System automatically produces a letter to the employee verifying personnel
              data or changes for certain events as defined by the user with the ability to
  PA 80.00    override the production of a letter on individual transactions.
              System automatically produces an email message to the employee verifying
              personnel data or changes for certain events as defined by the user with the
              ability to override the production of the email message on individual
  PA 81.00    transactions.
              System should provide the ability to generate e-mail or letter notification to
  PA 82.00    employees and other appropriate staff of transaction approvals.
              System automatically calculates user-defined critical dates based on the
              employee status and the effective date of the transaction (e.g., end of
  PA 83.00    probationary period).
              System should provide the ability to automatically calculate salary changes
  PA 84.00    based on salary policy established for individual transactions.
              System should provide the ability to maintain historical percentage increase
  PA 85.00    amount for all salary adjustments.
              System automatically flags employees that require personnel action (e.g.,
              transactions placed in pending status) and institutes notification to
  PA 86.00    appropriate personnel based on user defined criteria.
              System provides the ability to link spouses when both work for the State for
  PA 87.00    use in determining eligibility for certain types of benefits.
    RFP Attachment 6.8                                           Personnel Administration Requirements                                              PA8
    State of Tennessee                                                                                                                     RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                             Hours to
   Number                                    System Requirements                                  Response                   Comments                  Modify
               System links personnel action changes to key changes based on relational
  PA 88.00     edits.
               System allows for an employee to have multiple personnel transaction types
               at the same time. At a minimum, the following transaction types must be
  PA   89.00   supported:
  PA   89.01        Reemployment
  PA   89.02        Reinstatement
  PA   89.03        Regular appointment (full or part time, civil service or executive service)
  PA   89.04        Temporary Appointment (full or part-time, executive service only)
  PA   89.05        Seasonal Appointment (full or part-time, executive service only)
                    Emergency Appointment (full-time only, executive service appointment in
  PA 89.06          civil service position)
                    Temporary Provisional Appointment (full-time only, executive service
  PA 89.07          appointment in civil service position)
                    Interim Appointment (full-time only, executive service appointment in civil
  PA 89.08          service position from a register)

  PA   89.09      Limited Term Appointment (full-time only, executive service appointment)
  PA   89.10      Reappointment of Retiree (full or part-time)
  PA   89.11      Administrative Adjustment (salary adjustment)
  PA   89.12      Equity Increase (salary adjustment)
  PA   89.13      Salary Policy Adjustment (salary adjustment)
  PA   89.14      Adjustment to minimum of salary range (salary adjustment)
  PA   89.15      Pay/Shift Differential Adjustment (salary adjustment)
  PA   89.16      Working out of Class Adjustment (salary adjustment)
  PA   89.17      Upgrade Adjustments (salary adjustment)
  PA   89.18      Promotions
  PA   89.19      Demotions for Cause
  PA   89.20      Voluntary Reductions in Rank
  PA   89.21      Involuntary Reductions in Rank
  PA   89.22      Transfers
  PA   89.23      Reclassifications
  PA   89.24      Career Path Changes
  PA   89.25      Flex Reclassifications
  PA   89.26      Reallocations
  PA   89.27      Dismissals (termination/separation)

    RFP Attachment 6.8                                             Personnel Administration Requirements                                               PA9
    State of Tennessee                                                                                                                        RFP # 317.03-134
    Project Edison
                                                      FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                        N = Cannot Meet Requirement
M = Modification Required                                                                                       Q = Custom Report/Query

  Reference                                                                                           Vendor                                             Hours to
   Number                                     System Requirements                                    Response                   Comments                  Modify
  PA   89.28      Retirement (termination/separation)
  PA   89.29      Expiration of Appointment (termination/separation)
  PA   89.30      Death (termination/separation)
  PA   89.31      Layoff (termination/separation)
  PA   89.32      Disability Retirement (termination/separation)
  PA   89.33      Dismissal – Gross Misconduct (termination/separation)
  PA   89.34      Resigned not in Good Standing (termination/separation)
  PA   89.35      Personal (termination/separation)
  PA   89.36      Job Change (termination/separation)
  PA   89.37      For Health (termination/separation)
  PA   89.38      To Remain at Home (termination/separation)
  PA   89.39      For Better Pay (termination/separation)
  PA   89.40      Moved from Area (termination/separation)
  PA   89.41      Return to School (termination/separation)
  PA   89.42      Job Dissatisfaction (termination/separation)
  PA   89.43      Other Reasons (termination/separation)
  PA   89.44      Job Abandonment (termination/separation)
  PA   89.45      Mandatory Retirement (termination/separation)
  PA   89.46      Incentive Retirement (termination/separation)
  PA   89.47      Suspension
  PA   89.48      Special Leave (Normally used for Illnesses)
  PA   89.49      Maternity Leave/Paternity Leave
  PA   89.50      Educational Leave With Pay
  PA   89.51      Board of Claims (Worker’s Comp)
  PA   89.52      Military Leave With or Without Pay
  PA   89.53      Educational Leave Without Pay
  PA   89.54      Sick Leave Bank
  PA   89.55      Reduction In Hours for Seasonal Park Employees
  PA   89.56      Return from Suspension
  PA   89.57      Return from Leave
  PA   89.58      FMLA
                  Addition of skill, certificate, qualifications, etc. (note: this may result in a
  PA   89.59      salary adjustment based on rules in Compensation requirements).
  PA   89.60      Probation Date, Hire Date, Service and Longevity Date Changes
  PA   89.61      Service and Longevity Months Adjustments
  PA   89.62      Personal Data

    RFP Attachment 6.8                                               Personnel Administration Requirements                                               PA10
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
  PA 89.63         User defined.
               The system should provide for multiple types of promotion actions. At a
  PA   90.00   minimum, the following must be supported:
  PA   90.01       Permanent promotion
  PA   90.02       Probationary promotion
  PA   90.03       Temporary promotion.
               The system should provide for multiple types of demotion actions. At a
  PA   91.00   minimum, the following must be supported:
  PA   91.01       Demotions for Cause
  PA   91.02       Involuntary Reductions in Rank
  PA   91.03       Voluntary Reductions in Rank.
               The system should provide for multiple types of salary changes. At a
  PA   92.00   minimum, the following must be supported:
  PA   92.01       Administrative Adjustment
  PA   92.02       Equity Increase
  PA   92.03       Salary Policy Adjustment
  PA   92.04       Adjustment to minimum of salary range
  PA   92.05       Pay/Shift Differential Adjustment
  PA   92.06       Working out of Class Adjustment
  PA   92.07       Upgrade Adjustments.
               The system should provide for the designation of a recommendation of rehire
  PA 93.00     for separating/terminating employees.
               System provides the capability to require that specific employee actions be
  PA 94.00     associated with a valid Certificate of Eligibles for the appointing agency.
               System should provide the capability to assign user defined edits to any
  PA 95.00     transaction that the user may want to interrogate.

               System should provide for the creation of user-defined employee checklists
  PA 96.00     for various processing activities such as new hire, separation, etc.
               System allows transfers of an employee to another agency and provides
  PA   97.00   access to all historical data for the employee to the new organization.
  PA   98.00   System should allow for multiple separation codes:
  PA   98.01       Dismissals
  PA   98.02       Retirement
  PA   98.03       Expiration of Appointment
  PA   98.04       Death

    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA11
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
  PA   98.05       Layoff
  PA   98.06       Disability Retirement
  PA   98.07       Dismissal - Gross Misconduct
  PA   98.08       Resigned not in Good Standing
  PA   98.09       Personal
  PA   98.10       Job Change
  PA   98.11       For Health
  PA   98.12       To Remain at Home
  PA   98.13       For Better Pay
  PA   98.14       Moved from Area
  PA   98.15       Return to School
  PA   98.16       Job Dissatisfaction
  PA   98.17       Job Abandonment
  PA   98.18       Mandatory Retirement
  PA   98.19       Incentive Retirement
  PA   98.20       Other user defined.
                System should generate e-mail notifications to user-defined destinations
  PA   99.00    when employees separate from state service.
  PA   100.00   System should allow for multiple extended leave codes:
  PA   100.01      Special Leave (Normally used for illnesses)
  PA   100.02      Maternity Leave
  PA   100.03      Educational Leave With Pay
  PA   100.04      Worker's Comp
  PA   100.05      Military Leave With or Without Pay
  PA   100.06      Educational Leave Without Pay
  PA   100.07      Sick Leave Bank
  PA   100.08      Reduction in Hours for Seasonal Park Employees
  PA   100.09      FMLA.

  PA 101.00 System should provide a record or indication as to whether an employee has:
  PA 101.01    Applied for FMLA
  PA 101.02    Been approved for FMLA
  PA 101.03    Been notified of his/her status for FMLA.
            System should provide a record of dates (beginning, intermittent scheduling,
  PA 102.00 and ending) of FMLA.


    RFP Attachment 6.8                                            Personnel Administration Requirements                                             PA12
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
            System should provide the ability to attach notes (includes date and time of
  PA 103.00 note) to personnel transactions and/or fields.
            System should provide the ability to attach comments at various approval
  PA 104.00 levels within the workflow.
            System should provide the ability to attach justification information in letter
  PA 105.00 format to individual transactions.
            System should provide the ability to automatically reinstate certain benefits
  PA 106.00 based on user defined criteria for rehired state employees.
            System should provide the ability to do Social Security Number (SSN)
  PA 107.00 maintenance (pre or post payroll run) including the following:
  PA 107.01     To Delete SSN
  PA 107.02     To Modify SSN
  PA 107.03     To Give Temporary SSN.
                                  Retroactive Employee Transactions
            System should provide the ability to create, edit and view retroactive
  PA 108.00 transactions and maintain historically.
            System should provide the ability to process retroactive transactions for an
  PA 109.00 employee that has separated from state service.
  PA 110.00 System should provide the ability to back out retroactive transactions.
            System should provide the ability to perform retroactive process based on
            the related effective date rules and appropriately reflect the updated data
  PA 111.00 through any actions between the retroactive date and current rules.
            System should provide the ability to have a summary screen for retroactive
  PA 112.00 transactions which includes detailed history and actions as they occurred.
                                             Mass Changes
            System should provide the ability to process mass changes (retroactive,
  PA 113.00 current and future) of salary and non-salary related data.
            System should provide the ability to identify population based on different
  PA 114.00 selection criteria for mass change.
            System should provide the ability to generate edit reports prior to and after
            mass changes for those records that should be adjusted and for those
  PA 115.00 records that were not adjusted.
                                            Skills Inventory
            System provides the ability to track education, qualifications, and skills for
  PA 116.00 employees, including licenses.

    RFP Attachment 6.8                                            Personnel Administration Requirements                                             PA13
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
  PA 117.00 System should track certifications, i.e., CPA, CFE, etc.
  PA 118.00 Systems allows each employee to have an unlimited number of skills.
            Skills and qualifications may be specified and stored for a job class, position,
  PA 119.00 etc.
  PA 120.00 For each skill, the following information must be maintained:
  PA 120.01      Skill code
  PA 120.02      Skill description
  PA 120.03      Experience level
  PA 120.04      Last year used
  PA 120.05      Last location used
  PA 120.06      Proficiency level
  PA 120.07      Effective date
  PA 120.08      Expiration date.
            Skills inventory integrates with other areas of the system to allow skill
  PA 121.00 information to be used for various functions, including:
  PA 121.01      New hires
  PA 121.02      Recruiting and applicant tracking
  PA 121.03      Transfers.
            Skills inventory integrates with payroll for the purpose of allowing payroll to
  PA 122.00 calculate pay that is dependent on various skills.
                            Longevity/Service Anniversary/Service Awards
            System should support a comprehensive longevity program to include annual
            payments for most employees as well as monthly payments for agency
  PA 123.00 specific program.
  PA 124.00 System provides tickler reports for forthcoming longevity payments.
  PA 125.00 System tracks an employee’s receipt of longevity pay historically.
  PA 126.00 System tracks adjustments to employee's longevity pay historically.
            System should support the calculation of longevity payments by various
  PA 127.00 measures, including:
  PA 127.01      Months of Service
  PA 127.02      Years of Service.
            System should provide the ability to calculate longevity payment due date
            and service anniversary date based on creditable months (months in which
  PA 128.00 an employee completes the major portion for accrual purposes).
            System should provide the ability to override longevity payment due date and
  PA 129.00 service anniversary date.
    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA14
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                    System Requirements                                 Response                   Comments                  Modify
                System should provide the ability to adjust longevity payment due date and
                service anniversary date based on retroactive leave adjustments that affect
  PA 130.00     accrual.
  PA 131.00     System should integrate with payroll calculations.
                System should integrate with Timekeeping/Leave Accounting to determine
  PA   132.00   service and longevity credit eligibility.
  PA   133.00   System should determine eligibility for longevity based on:
  PA   133.01       Job Classification
  PA   133.02       Employee Status (regular, emergency, temporary, full or part-time, etc.)
  PA   133.03       Extended leave type
  PA   133.04       Other, user defined.
                System should provide the ability to automatically reinstate longevity and
  PA 134.00     service credit for rehired state employees.
  PA 135.00     System should track dates for service awards.
  PA 136.00     System should provide the ability to generate service award certificates.
                                             Reduction In Force (RIF)
  PA 137.00     Support the following capabilities for layoff processing:
                    Report of possible affected employees by classification or any user
  PA 137.01         defined fields
  PA 137.02         Notify employees that may be impacted (90 day notice letter)
                    Provide capability of a complete RIF determination path including
  PA 137.03         bumping, retreating, and placement
                    Provide capability to automatically cross reference employees on RIF list
  PA 137.04         against proposed vacancies
  PA 137.05         Generate letters to employees outlining options
  PA 137.06         Place affected employees on RIF list with appropriate priority
                    Provide capability to automatically check RIF list prior to performing any
  PA 137.07         personnel action
                    Generate updated RIF list for any transaction that affects the employee's
  PA 137.08         status/priority on the list
                    Lists may be edited by users with appropriate security and then released
  PA 137.09         for processing
  PA 137.10         Generate letters of removal from list.
                                             Performance Evaluation
  PA 138.00     System triggers an evaluation X days prior to due date based on:
  PA 138.01         Due date
    RFP Attachment 6.8                                             Personnel Administration Requirements                                             PA15
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
  PA   138.02       Hours worked
  PA   138.03       End of probation
  PA   138.04       Promotion, Demotion, reclassification
  PA   138.05       Transfers between agencies
  PA   138.06       Appointment
  PA   138.07       Other.
                Automatically extend probation date when employee on leave based on user
  PA   139.00   defined parameters.
  PA   140.00   Track all performance evaluations and evaluation scores by employee,.
  PA   140.01       Employee
  PA   140.02       Rater
  PA   140.03       Reviewer
  PA   140.04       Agency
  PA   140.05       Division
  PA   140.06       Race
  PA   140.07       Sex
  PA   140.08       Job Classification
  PA   140.09       Cost Center
  PA   140.10       Training Code
  PA   140.11       Other, user defined.
  PA   141.00   System should allow overrides to evaluation dates.

            System should automatically calculate the due date of the next performance
  PA 142.00 evaluation based on user defined criteria (6, 9, 12, or 24 months).
            System should have the capability of establishing evaluation due dates
  PA 143.00 based on user defined criteria.
            System should produce a personnel action history since the last performance
  PA 144.00 evaluation.
            System should allow for the tracking of variable probationary periods (e.g., 6,
            9, 12, or 24 months) which are based on user defined rules for each job
  PA 145.00 class:
  PA 145.01     Time limits
  PA 145.02     Type of probation (initial or subsequent)
  PA 145.03     Adjustments of probationary period.

  PA 146.00 System provides notices to agencies for personnel evaluations not received.

    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA16
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
            System provides notices to agencies for upcoming performance evaluations
  PA 147.00 that are due (30, 60, and/or 90 days in advance).
  PA 148.00 System should allow statistical reporting on performance evaluations.

             System provides for and tracks improvement needed performance situations
  PA 149.00 and triggers follow-up at user defined interval (as defined by Agency).
            System edits performance evaluation data to ensure all required information
  PA 150.00 is provided.

            Provide ability to supplement standard performance evaluation forms (online
  PA 151.00 and printed) with user defined information based on class, dept, etc.

            Performance evaluations are integrated with recruiting to provide input to
  PA 152.00 potential internal managers (consistent with employee privacy requirements).
            Performance evaluations are integrated with recruiting to provide for the
  PA 153.00 calculation of performance bonus points for promotional appointments.
            System should integrate employee's compensation with employee
  PA 154.00 performance evaluations.
            System should be flexible enough to accommodate Agencies completing
            evaluations for all employees as a single event, as well as those completing
  PA 155.00 evaluations throughout the year.
            System should allow supervisors to develop Job Performance Plans, Interim
            Reviews, and Formal Evaluations on-line inputting directly into a database
            (internet enabled) with the ability to print documents from the information
  PA 156.00 entered.
  PA 157.00 System should provide a catalog of job duties for creating job plans.
            Notify supervisors of scheduled events (Job Performance Plans, Interim
  PA 158.00 Reviews, and Formal Evaluations).
            System should provide the ability to create a user defined schedule of events
  PA 159.00 for each evaluation cycle.
            System should generate e-mail notifications to supervisors based on
  PA 160.00 schedule of events for each evaluation cycle.
            System should have a flexible workflow that follows schedule of events for
  PA 161.00 review and approval.
  PA 162.00 System should provide user defined security requirements.
                                               Grievances

    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA17
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
  PA   163.00   Track grievance information to appropriate personnel.
  PA   164.00   Track the current status of any grievance.
  PA   165.00   Track types of grievances.
  PA   165.01      Performance evaluations
  PA   165.02      Disciplinary actions
  PA   165.03      Other, user defined.
  PA   166.00   Track types of grievances by:
  PA   166.01      Agency
  PA   166.02      Division
  PA   166.03      Time Period
  PA   166.04      Resolutions
  PA   166.05      Other, user defined.
  PA   167.00   System tracks by grievant and respondent(s).

  PA 168.00 System provides the ability to have user defined steps to track grievances.
            The system should provide warnings when grievance decisions are not
  PA 169.00 determined in a timely manner.
  PA 170.00 Provide historical information for all grievances.
                                          Disciplinary Actions
            Automatically route information to HR, supervisors, etc. regarding disciplinary
  PA 171.00 actions.
  PA 172.00 Provide ability to define steps in the disciplinary action process.
  PA 173.00 System tracks all disciplinary actions:
  PA 173.01     Letters of reprimand
  PA 173.02     Letters of intent
  PA 173.03     Removing written warning after 2 years
  PA 173.04     Disciplinary demotions
  PA 173.05     Suspensions
  PA 173.06     Dismissal
  PA 173.07     Date
  PA 173.08     Appeal process
  PA 173.09     Other, user defined
  PA 174.00 Track disciplinary actions by:
  PA 174.01     Agency
  PA 174.02     Division
  PA 174.03     Job Classification

    RFP Attachment 6.8                                            Personnel Administration Requirements                                             PA18
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
  PA   174.04     Supervisor
  PA   174.05     Race
  PA   174.06     Sex
  PA   174.07     Time Period
  PA   174.08     Other, user defined.
  PA   175.00 System tracks number of written warnings by agency or system wide.
  PA   176.00 System tracks multiple written warnings per day.
  PA   177.00 System should provide historical information for all disciplinary actions.
                                     Employee Suggestion Program
              System provides for the submission, evaluation, and management of
  PA   178.00 employee suggestions.
              System should allow for employees to submit suggestions directly into the
  PA   179.00 system using internet technology.
              System should include an integrated imaging capability for linking scanned
  PA   180.00 data to suggestion file.
              System shall allow for employees to inquire on the status of the suggestions
  PA   181.00 which they submit.
              System should provide the ability to have user defined required fields for
  PA   182.00 suggestion.
              System should provide the ability to have user defined required fields for
  PA   183.00 suggestion evaluation.
              System should notify employee and administrator of receipt of new
  PA   184.00 suggestion.
              System should provide the ability for automatic notification to users (DOP
  PA   185.00 and agency) on pending suggestions.
              System should track costs associated with the administration of the
  PA   186.00 employee suggestion program.
              System should provide for the tracking of costs and benefits associated with
  PA   187.00 the implementation of suggestions.
              System should provide for the following levels of online approval as defined
  PA   188.00 by the user; for example:
  PA   188.01     Evaluator
  PA   188.02     Suggestion program coordinator
  PA   188.03     Review Panel
  PA   188.04     Board
  PA   188.05     Appointing Authority

    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA19
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
  PA 188.06       Fiscal Officer.

            System should produce user definable notices to suggestion originator as
  PA 189.00 well as appropriate State personnel when action on a suggestion is taken.
            Status information may be automatically provided via email at the option of
  PA 190.00 the employee or applicable State personnel.
            A flexible research capability will exist for matching new suggestions with
  PA 191.00 previously submitted suggestions.
            System should provide the ability to track multiple employees for the same
  PA 192.00 suggestion.
            System should provide the ability to pay multiple employees for one
  PA 193.00 suggestion.
  PA 194.00 System should track and charge cost to multiple agencies.

  PA   195.00 Provide for the payments to employees when suggestions are implemented:
  PA   195.01     Payment amount
  PA   195.02     Date
  PA   195.03     Total payment.
              System tracks and reports on information for employee suggestion program
  PA   196.00 results:
                  Number of new, denied, duplicate, ineligible, and adopted suggestions
  PA   196.01     for the requested period
  PA   196.02     Turnaround time for each process step
  PA   196.03     Number of certificates awarded for the requested period
  PA   196.04     Amount of savings by user defined period
  PA   196.05     Amount of cash awards for the requested period.
                                         Affirmative Action/EEO
              System provides the ability to meet federal government reporting
  PA   197.00 requirements for Affirmative Action and EEO-4.
  PA   198.00 System should provide Affirmative Action planning to include:

  PA 198.01       Workforce analysis and job group analysis for the beginning of fiscal year
  PA 198.02       Census data by county, MSA, total state by census occupational group
                  Two factor availability for computation (Internal availability for state
  PA 198.03       government and factor computation for census population selected)

    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA20
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
  PA 198.04       Placement goals determined for the fiscal year
                  Actual hiring data and applicant data to be used in determining whether
  PA 198.05       goals are being met
  PA 198.06       Problems, objectives and action to be taken in meeting goals set
  PA 198.07       Ability to print reports for each agency.
                                           Safety & Worker's Comp
  PA 199.00    System produces the OSHA-200 reports.
               System interfaces with payroll for processing employees receiving workers’
               compensation to ensure that employees are not receiving Worker's Comp
  PA 200.00    and State pay (including leave) for the same hours.

  PA   201.00 System should provide the ability for agencies to enter accidents, including:
  PA   201.01     Worker's comp
  PA   201.02     Incident only.
  PA   202.00 System should support transitional duty assignments.
  PA   203.00 System should track permanent and temporary work restrictions.
              System must support processing for temporary partial disability assignments,
  PA   204.00 including proper handling of employee payments.
  PA   205.00 System should maintain history of multiple incidents.
  PA   206.00 System should maintain multiple current injuries.
  PA   207.00 System should maintain history of all injuries.
              System should provide information to Benefits Administration such that the
  PA   208.00 State pays 100% of medical insurance premiums while on lost time.
              System should provide the ability to track total cost of injuries by employee,
  PA   209.00 Agency, type of injury, etc.; including:
  PA   209.01     Medical payments
  PA   209.02     Lost time
  PA   209.03     Backfill costs
  PA   209.04     Any accommodations.
              System tracks accidents by the following elements with clearly defined
              operational procedures to avoid mis-identification of comparable data among
  PA   210.00 agencies:
  PA   210.01     Incident number
  PA   210.02     Recording location
  PA   210.03     Date and type of accident
  PA   210.04     Injury class code
    RFP Attachment 6.8                                            Personnel Administration Requirements                                             PA21
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
  PA   210.05     Body part
  PA   210.06     Days restricted work
  PA   210.07     Severity
  PA   210.08     Attending Physician
  PA   210.09     In network (Y/N)
  PA   210.10     Names of employees
  PA   210.11     Days lost from work
  PA   210.12     OSHA reported injury
  PA   210.13     Job titles of employees
  PA   210.14     Supervisor name
  PA   210.15     Cause of injury
  PA   210.16     Workers’ compensation claim
  PA   210.17     Claim status
  PA   210.18     Preventable/not preventable
  PA   210.19     Medical payments.

  PA 211.00 System tracks accident history by employee of the following data elements:
  PA 211.01     Date and time of injury
  PA 211.02     Expected date of return
  PA 211.03     Flag if on restricted duty
  PA 211.04     Name and job title of injured worker
  PA 211.05     Actual date of return to work
  PA 211.06     Date temporary restricted duty should end
  PA 211.07     Date of maximum medical improvement
  PA 211.08     Lost time hours
  PA 211.09     Cost of time lost
  PA 211.10     Type of restriction
  PA 212.00 System tracks light duty accommodations, including:
  PA 212.01     Start date
  PA 212.02     End date
  PA 212.03     Maximum time per incident.
            System tracks injured in the line of duty (ILD) time from date of injury to date
  PA 213.00 of approval.

  PA 214.00 System should indicate if fitness for duty required before employee returns.


    RFP Attachment 6.8                                            Personnel Administration Requirements                                             PA22
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
            System should track fitness for duty physical and psychological dates and
  PA 215.00 results.
                                            Employee History
            System should maintain a history that includes the date and time of all
  PA 216.00 personnel actions.
  PA 217.00 System should maintain a history of all personnel actions on the same day.
            Employee history record shall reflect unlimited personnel actions per
  PA 218.00 employee.
            System should maintain historical employment and payment data in easily
  PA 219.00 retrievable format.
            System should maintain historical name and Social Security Number
  PA 220.00 changes in easily retrievable format.
            System provides an Employee Profile Screen(s) which defines all key fields
  PA 221.00 associated with an employee such as:
  PA 221.01      Employee name
  PA 221.02      Demographic data
  PA 221.03      Position data
  PA 221.04      Benefit plan participation
  PA 221.05      Salary data
  PA 221.06      Classification data
  PA 221.07      Beneficiaries
  PA 221.08      Workers’ compensation status
  PA 221.09      User defined.
  PA 222.00 System tracks employee history on:
  PA 222.01      Position changes
  PA 222.02      Salary changes
  PA 222.03      Status changes
  PA 222.04      Demographic changes
  PA 222.05      Payroll data
  PA 222.06      Benefit elections
  PA 222.07      User defined.
            System provides on-line inquiry and tracks the date of inquiry of all salary
  PA 223.00 history for all employees.
            System tracks application date of leave and status of short and long term
  PA 224.00 employee leave.
                                  Reporting and Query Requirements
    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA23
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                   System Requirements                                  Response                   Comments                  Modify
            The system should provide for online access to all employee data with
  PA 225.00 appropriate security.
            System should provide ability to access information in the employee
  PA 226.00 information table(s) by:
  PA 226.01     Employee name
  PA 226.02     Previous name
  PA 226.03     Employee number
  PA 226.04     Position number
  PA 226.05     Social Security Number
  PA 226.06     Class code
  PA 226.07     Location
  PA 226.08     Other user defined.
            System should include a flexible report writing capability that will allow reports
  PA 227.00 to be formatted easily by user personnel.
            System should include a flexible report writing capability that will allow reports
  PA 228.00 to be generated based on user defined criteria. (Ad Hoc)
  PA 229.00 System should include the ability to print the query.
            System should include the ability to print the query with user defined
  PA 230.00 attachments. (e.g. scanned documents)
            Standard reports will include selection criteria based on such data items as
            employee class, status, organization, etc. These must be available without
  PA 231.00 modifying the standard report.
            System maintains control and reports on employees by special
  PA 232.00 characteristics as defined by user.
            System should provide an establish position report that details staffing for
  PA 233.00 each agency.
            Promotion Report for any given time (generally the fiscal year). The report
            would include employee name, old classification, old budget unit, new
  PA 234.00 classification, new budget unit, EEO information.
               New Hires Report for any given time (generally the fiscal year). The report
               would include employee name, classification, budget unit, EEO information.
  PA 235.00
            Transfer Report for any given time (generally the fiscal year). The report
            would include employee name, old classification, old budget unit, new
  PA 236.00 classification, new budget unit, EEO information.


    RFP Attachment 6.8                                            Personnel Administration Requirements                                              PA24
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
            Termination Report for any given time (generally the fiscal year). The report
            would include employee name, classification, budget unit, EEO information,
  PA 237.00 and reason for termination.

            System has the capability to support requests from outside agencies
  PA 238.00 regarding employment issues as well as for Retirement and COBRA needs.
            System should provide the ability to automatically generate mailing labels
  PA 239.00 when letters are generated.
            System should provide the ability for Ad Hoc query tools for the comparison
  PA 240.00 of data at two or more points in time.
            System should provide the ability to query or report on the total hours by
  PA 241.00 position for job share positions.
            System generates reports on upcoming significant events in the Performance
  PA 242.00 Evaluation process such as:
  PA 242.01      Job performance planning discussions
  PA 242.02      Interim reviews
  PA 242.03      Formal evaluations
  PA 242.04      Employees without an evaluation for the previous cycle
  PA 242.05      Employees without an evaluation in the system
  PA 242.06      Employees with an evaluation due in the next 30, 60, 90 days
            System should generate reports by department and division to satisfy
  PA 243.00 Affirmative Action requirements, including:
                 Total workforce (number of employees and percent by EEO code and
  PA 243.01      percent of minorities and females
  PA 243.02      Total new hires by race and sex for each EEO category
  PA 243.03      Total terminated by race and sex for each EEO category
  PA 243.04      Total promoted by race and sex for each EEO category
  PA 243.05      Compensation analysis by race and sex for each EEO category
  PA 243.06      New hires by salary range
  PA 243.07      Terminated by salary range
  PA 243.08      Promoted employees by salary range.
  PA 244.00 System should generate reports to satisfy federal guidelines for EEO-4.
  PA 245.00 System should generate a transactions report monthly by transaction type.
  PA 246.00 System should report monthly employees eligible for service awards.
  PA 247.00 System should report average filled positions by organizational unit.


    RFP Attachment 6.8                                           Personnel Administration Requirements                                             PA25
State of Tennessee                                                                                                  RFP 317.03-134
Project Edison
                                 FUNCTIONAL REQUIREMENTS MATRIX                                                           10/21/05




                                                             Payroll

                Payroll addresses the calculation, production and distribution of payroll payments. Additionally,
                Payroll performs the following:

                        Maintains earnings and tax history by employee and fund
                        Complies with State and Federal payroll tax withholding and reporting requirements
                        Supports retroactive and supplemental payments, and various pay cycle frequencies
                        Calculates benefit deductions based on rules specified in Benefit Administration
                        Calculates pay based on user-defined criteria (pay status, overtime rules, etc.)




                Additional Information:




RFP Attachment 6.8                                          Introduction                                                        ii
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                           10/21/05




Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                               Business Requirements                                   Response             Comments              Modify
                                     Payroll General Requirements
                          Maintain Employee Data including Deductions
PY 1.00      The system should have the ability to support the following key payroll
             volumes:
PY 1.01          Capability of handling 300,000 to one million employees
PY 2.00      The system will provide for online access to all detailed payroll data with
             appropriate security such as the following:
PY   2.01        Department only
PY   2.02        Department and division only
PY   2.03        Statewide
PY   2.04        Two or more departments
PY   3.00    The system should use an Employee ID number instead of social security
             number as key identifier.
PY 4.00      System should provide social security number query capability secured by
             user
PY 5.00      System should provide name search capability
PY 6.00      System should have the ability to make social security number corrections
             without changing employee status.
PY 7.00      System tracks social security number changes in historical payroll history
             data.
PY 8.00      System has the ability to maintain salary, deduction, and pay history for
             each employee for user defined number of periods
PY 9.00      System provides ability to archive and retrieve employee payroll data
             based on user defined criteria
PY 10.00     System should have payroll integrated with the following system
             components:
PY   10.01       Personnel Administration
PY   10.02       Benefits Administration
PY   10.03       Compensation
PY   10.04       Position Control

RFP Attachment 6.8                                       Payroll Administration Requirements                                                 PY1
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                   RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY   10.05       Cost Allocation
PY   10.06       Accounts Payable
PY   10.07       General Ledger
PY   10.08       Labor Distribution
PY   10.09       Budget Development
PY   10.10       Budget Control
PY   10.11       Timekeeping
PY   10.12       Leave Accounting
PY   10.13       Travel
PY   10.14       Accounts Receivable
PY   10.15       Cash Management
PY   10.16       Asset Management
PY   10.17       Fleet Management
PY   11.00   System should provide employee self-service (ESS) capabilities with the
             following:
PY 11.01         Review of pay, deductions, leave balances. Historical data available to
                 employee for at least 16 months thru 4/15 of each year.
PY 11.02         Review W-2 data for last 3 years. Ability to request duplicate W-2
                 either from ERP or Content Management for user defined timeframe.
                 If employee request a W-2 for a time period not available on the
PY 11.03         Sign-up for savings bonds
PY 11.04         Review savings bonds purchased and any accumulated balance
PY 11.05         Flag to update savings bond address when employee's address is
                 changed.
PY 11.06         What-if capability for determining effect on paycheck of changes to
                 deduction, exemptions, etc.
PY 11.07         Request duplicate pay stubs
PY 11.08         Change banking information. Restrict deletion of direct deposit data by
                 employee in ESS.
PY 11.09         Change personal information such as address, marital status, last
                 name.
RFP Attachment 6.8                                      Payroll Administration Requirements                                                 PY2
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                Business Requirements                                   Response             Comments              Modify
PY 11.10         Change voluntary deductions.
PY 11.11         Available 24/7 hours with a time-out function when user fails to log out.

PY 11.12         Support links to service providers and third party administrators as
                 appropriate. For example, a link to the employee's 401K administrator.

PY 11.13         Ability to interface with an email system. Email accounts for all
                 employees.
PY 11.14         Email notification of current pay stub availability or personal data entry
                 by someone other than employee such as lien deduction
PY   11.15       Notification of direct deposit prenote status
PY   11.16       View document in Content Management from ESS.
PY   11.17       Show Longevity Date on ESS screen.
PY   11.18       Show Flexible benefit contribution/reimbursement history.
PY   12.00   System provides online field and screen level help for online transactions
             including valid field values.
PY 13.00     System provides that all changes made are real-time.
PY 14.00     System provides for the ability to override compensation amounts for
             individual employees.
PY 15.00     System has the capability to perform combination edits to coordinate
             personnel codes with retirement type. Examples are when personnel
             appointment code is 08 for 120 day employee, the retirement type is
             always 009. Appointment code for part-time always has a retirement type
             of 008. When employee changes from part-time to full-time status, edit to
             ensure that retirement type is changed accordingly.
PY 16.00     The ability to support non-paying types of pay (such as a housing value for
             retirement contributions).
PY 17.00     System provides for direct deposit of employee pay to one or more bank
             accounts based on employee and user selectable options.
PY 18.00     System should provide temporary overrides to direct deposit status.


RFP Attachment 6.8                                        Payroll Administration Requirements                                                 PY3
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                   RFP # 317.03-134
Project Edison                                                                                                                           10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                                Business Requirements                                  Response             Comments              Modify
PY 19.00     System should contain flexible workflow for approval and routing of all
             payroll events including notification of HR approval of new hires.
PY 20.00     System should contain email notification to employee, agency, or payroll or
             by letter of transaction processing, including:
PY 20.01         Notification of lien or personal data entry to employee, agency, or court
                 either by email or generating a letter.
PY 20.02         Notification when voluntary deductions removed because of lien
                 requirements.
PY 20.03         Correspondence option by employee either by email or letter to
                 accommodate sending letters to employees without email address
PY 21.00     System should provide deduction capability for the following:
PY 21.01         Ability to group deductions in categories (exemptions, deductions,
                 reductions, etc).
PY 21.02         Capability for employees to donate to more than one charitable
                 agency.
PY 21.03         Deduction entered with a start and stop date. For example, charitable
                 contributions can be entered in November with a start date of 1/31 for
                 the following year.
PY 21.04         Edit capability to block voluntary deductions entered online and/or
                 uploaded for employees with a bankruptcy or IRS tax levy.
PY 21.05         Automatically resumes employee deductions when return to work from
                 leave without pay status, etc.
PY 21.06         Allows for 9999 number of deductions within each category.
PY 21.07         Edits transactions for valid account numbers, object codes, etc at the
                 time of initial entry.
PY 21.08         Supports deductions based on a percent of gross and /or fixed dollar
                 amount.
PY 21.09         Supports 9999 number of deductions per person per payment.
PY 21.10         Supports deductions with negative amounts such as flex
                 reimbursements, flex refunds, or savings bond refunds.


RFP Attachment 6.8                                       Payroll Administration Requirements                                                 PY4
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                   RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 21.11         Supports user defined maximum deductions/contributions based on
                 percent and dollar amount and employee attributes. (Examples are
                 retirement caps).
PY 22.00     System needs to interface with FileNet for content management for at
             least the following:
PY 22.01         Garnishment and lien documents scanned for automatic data entry.
PY 22.02         Personal data documents scanned after data entry for record retention
                 such as Form W-4 and charity pledge card.
PY 23.00     System should support OCR imaging requirements.
                            Additional Payments including Fringe Benefits
PY 24.00     System should provide the ability to accommodate 9999 earnings codes
             and define earnings setup centrally (for example, type, method, calculation
             method, to what deductions an earning is subject, whether an earning
             adds to gross, frequency, defined schedule).
PY 25.00     System should provide the ability to setup and process multiple shift
             differential types based on FLSA.
PY 26.00     System should provide the ability to setup and process multiple overtime
             based on FLSA.
PY 27.00     System should provide the capability of processing multiple additional pay
             types in one pay period.
PY 28.00     System should provide the ability to track additional pay in order to
             eliminate any duplicate payments.
PY 29.00     System should provide the ability to make mass additional payments
             current and retroactively.
PY 30.00     System should allow for electronic approval for online entry of payroll
             transactions
PY 31.00     System should perform calculations and processing required for employee
             terminations including:
PY 31.01         Salary and additional pay
PY 31.02         Payoff of vacation and compensatory leave
PY 31.03         Longevity
RFP Attachment 6.8                                      Payroll Administration Requirements                                                 PY5
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                 Business Requirements                                  Response             Comments              Modify
PY 31.04         Capability of leave Buy-Back
PY 31.05         Defer payoff of benefits at the time of termination (pay later and in
                 installments). Terminal leave: Running out compensatory leave
                 balance allows for the accrual of leave and holiday hours earned.
                 Once annual leave coded terminal annual leave, employee no longer
                 earns other leave or holiday pay.
PY 31.06         Ability to produce a separate check for termination pay at employee
                 option
PY 31.07         Ability to combine last regular check and payoff check
PY 31.08         Deceased employee payments may include longevity payment and
                 holiday pay. Annual and comp leave are run out to determine if any
                 holiday pay or longevity pay is earned as a side calculation.
PY 31.09         Capability for business rule that allows calculation for annual lump sum
                 payout if employee terminating in their anniversary month instead of
                 annual leave greater than specified hours rollover to sick.

PY 32.00     System should support retroactive processing for the following types of
             events:
PY 32.01        Hours adjustments: Needs to capture hours and dollar amount.
                Overtime should be allocated between regular and premium overtime
                and calculated according to FLSA guidelines. If leave hours used while
                absent and then approved for Workman's comp, employee requests
PY 32.02        Additional pay adjustments, such as longevity, shift differential, etc
PY 32.03        Salary adjustments for an individual
PY 32.04        Salary adjustment to a group of individuals due to schedule changes

PY 32.05         Contributions (savings plans, retirement plans, cafeteria plans, etc.)
                 including both employee and State contributions
PY 32.06         Override capability for deferred comp state match ceiling for a prior
                 period catch-up.
PY 32.07         Reinstatements
RFP Attachment 6.8                                        Payroll Administration Requirements                                                 PY6
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                Business Requirements                                   Response             Comments              Modify
PY 32.08        Separations including deceased
PY 32.09        Deduction adjustments to individuals
PY 32.10        Deduction adjustments to groups of employees due to changes to
                benefit rates, TSEA union dues, etc.
PY 32.11        Leave balances
PY 33.00     System should provide the ability to charge a retroactive payment to the
             appropriate accounting codes.
PY 34.00     System should provide the ability to link retroactive payments back to the
             earnings type.
PY 35.00     System should provide the ability to capture pay history information for
             user define period and to retroactively calculate this information as
             needed.
PY 36.00     System should provide the ability to designate tax method on retroactive
             payments (by pay period, or percentage or at the current tax rate).

PY 37.00     The system should provide the capability for all additional payments
             including fringe benefits itemized to be on pay stub and payroll register.

PY 38.00     The system should provide an accurate allocation of fringe benefits to the
             correct funding source when an employee transfers.
PY 39.00     The system should provide the capability for fringe benefit should be
             allocated to sick leave bank in the case of a sick leave bank payment
             instead of agency.
PY 40.00     The system should have the ability for Content Management interface with
             vehicle travel log to data entry to system.
PY 41.00     The system should provide the ability to redirect fringe benefit matching
             costs to another funding source.
PY 42.00     The system should support the automation of regular pay (not
             supplemental pay) for military payments by executive orders .



RFP Attachment 6.8                                        Payroll Administration Requirements                                                 PY7
State of Tennessee                            FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 43.00     The system should support the automation of military payments by
             executive orders processed to pay for current benefits only when military
             pay greater than state or pay the difference of state and military salary
             when state salary greater than military.
PY 44.00     The system should provide the capability for Account Receivables for
             wage overpayments to be deducted from future pay periods
PY 45.00     All additional payments including uploads will automatically credit
             retirement service interface file
PY 46.00     System should provide the ability to know the grievance payment amount
             beforehand to support information needed during the hearing process.

PY 47.00     System should provide the ability to forecast projections of the grievance
             payment amount
PY 48.00     System should contain flexible workflow for approval and routing of all
             payroll events BEFORE FINAL PAYROLL RUNS for the items listed
             below:
PY 48.01        Additional pay must be approved by Department of Personnel
PY 48.02        Fringe Benefit must be approved by Payroll
PY 48.03        Deceased and separated employee payments require workflow
                notification to asset management.
PY 49.00     System should allow for data entry of tips for servitor employees.
PY 50.00     System needs to interface with FileNet for content management for at
             least the following:
PY   50.01         Additional Pay support documents
PY   50.02         Death Certificates
PY   50.03         Charge Tips
PY   50.04         Voided Checks
                                           Payroll Process
PY 51.00     The Payroll component is designed to meet a number of management and
             accounting objectives. These objectives include the ability to:

RFP Attachment 6.8                                      Payroll Administration Requirements                                                 PY8
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                Business Requirements                                   Response             Comments              Modify
PY 51.01         Maintain data files for year-to-date totals (fiscal and calendar year) by
                 individual employee and source of fund
PY   51.02       Provide a single approval point for all payroll hours, leave hours
PY   51.03       Control distribution of payroll check / warrants to employees
PY   51.04       Review employee pay and benefit detail on-line
PY   52.00   System should contain flexible workflow for approval and routing of all
             payroll events, including the simulation results for review prior to the final
             payroll processing
PY   53.00   Payroll will interface with various other systems, including:
PY   53.01       Third party carriers (coverage information, deduction amounts, etc.)
PY   53.02       Retirement (TRACS)
PY   53.03       Bargaining units (union dues) TSEA
PY   53.04       Other governmental agencies (IRS, SSA, etc.)
PY   53.05       TDOT Maintenance Management System
PY   53.06       Cost Recovery
PY   54.00   The system should provide the ability to perform base rate calculations as
             defined in Compensation using salary schedules, hourly rates, daily, per
             visit, etc.
PY 55.00     System should provide the ability to calculate rates to four decimal places
             and pay $99,999,999.99
PY 56.00     The system should perform pay calculations for temporary employees
             based on Army National Guard Personnel system. Base pay is taxable but
             daily housing and food allowance is non-taxable (off-line military payroll).

PY 57.00     System should have the ability to calculate additional pay as defined in
             Compensation (flat rate, % of base, skills & certificates, etc.) for the
             following:
PY 57.01         The system should calculate Medical Officer of the Day pay. Number
                 of total hours X a flat rate added to the regular pay.



RFP Attachment 6.8                                        Payroll Administration Requirements                                                 PY9
State of Tennessee                            FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 57.02         Calculate Tips 'Additional Pay' when employee does not make
                 minimum wage when hourly rate plus tips calculated plus overtime.
                 Add cash and charge tips together when calculating but distinguish
                 between the two for reporting and pay stub. (Ex. Base rate of $2.13,
                 worked 42 hours, & $23 in tips. 40hrs X $2.13 = $85.20 + $23.00 =
                 $108.20; $206.00 ($5.15 X 40) - $108.20 = $97.80 additional payment;
                 $97.80/40 = $2.45 hourly rate of add'l pay. OT Calculation $7.73
                 ($5.15 X 1.5) - $2.45 = $5.28/hr X 2 OT hours = $10.56. Total
                 payment: $108.20 + $97.80 + $10.56 = $216.56).
PY 57.03         Calculate schedule and level bonuses (pay at a different level in the
                 salary schedules based on eligibility for this bonus).
PY 57.04         Perform the longevity pay calculation which is a flat amount X number
                 of credited months/12.
PY 57.05         Longevity is paid on separate check
PY 57.06         Perform the monthly longevity pay calculation for commissioned
                 officers
PY 57.07         Support dual service contract process
                 (Once the dual service contract is approved, state employee earns the
                 agreed upon salary amount, and the procuring agency (generally
                 higher ed) makes payment to the employing agency, the employee is
                 paid the additional earnings.)
PY 58.00     The system should provide automatic calculation of step, increment and
             percentage increase amounts for all employees based on user defined
             criteria. Ability to exclude certain employees such as military leave by
             executive order from COL increase in payroll but not in personnel record.

PY 59.00     When computing step increase timing, system must provide for a step
             increases at varying time intervals based on user defined parameters (ex -
             step increase in 1/2 normal time if below bottom of range after a
             promotion)


RFP Attachment 6.8                                      Payroll Administration Requirements                                                PY10
State of Tennessee                               FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                             10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Inquiry


 Reference                                                                                        Vendor                                   Hours to
  Number                                 Business Requirements                                   Response             Comments              Modify
PY 60.00     The system should automatically calculate salary when personnel actions
             change compensation (promotions, demotions, etc.).
PY 61.00     The system should automatically calculate salary when personnel actions
             change compensation (promotions, demotions, etc.) within a pay period.

PY 62.00     The system should have the ability to allow one employee to have multiple
             pay types during any pay period (hours worked, vacation, sick leave, etc.)

PY 63.00     The system should allow one employee to be paid in more than one
             position during a pay period. Memo of Understanding when employee
             works for two different departments in the same pay period.
PY 64.00     System should have the capability to pay more than one employee in one
             position for the same pay period.
PY 65.00     The system should support when more than one position is used for the
             pay period, the position that is designated as primary will govern benefit,
             leave, and other calculations
PY 66.00     System should provide the ability to properly calculate pay for employees
             that transfer during a pay period for the following items:
PY 66.01         Pay is prorated based on both salaries
PY 66.02         Benefit costs are determined by user defined selection (benefits that
                 were effective at the start of the period, benefits that were effective at
                 the end of the period, prorated)
PY 66.03         Leave accruals and eligibility are determined by user defined selection
                 (leave rules that were effective at the start of the period, leave rules
                 that were effective at the end of the period, prorated)
PY 66.04         User parameters for charging costs to cost centers
PY 67.00     System should provide the ability to properly calculate pay for employees
             paid from more than one agency ( for example sick leave bank) during a
             pay period for the following items:
PY 67.01         Pay is prorated based on both salaries

RFP Attachment 6.8                                         Payroll Administration Requirements                                                PY11
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                     RFP # 317.03-134
Project Edison                                                                                                                             10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Inquiry


 Reference                                                                                        Vendor                                   Hours to
  Number                                 Business Requirements                                   Response             Comments              Modify
PY 67.02         Benefit costs are determined by user defined selection (benefits that
                 were effective at the start of the period, benefits that were effective at
                 the end of the period, prorated)
PY 67.03         User parameters for charging costs to cost centers
PY 68.00     System should calculate leave payments in accordance with rules and
             methods specified in leave accounting
PY 69.00     The system should support the advancement of annual leave accrual rate
             to a higher rate based on dates or time intervals
PY 70.00     System should calculate/verify overtime and shift differential consistent
             with FLSA rules, including:
PY 70.01         Overtime calculations over more than one position
PY 70.02         Overtime across multiple departments (Capability for employee to
                 complete timesheet with multiple allotment code).
PY 70.03         Overtime that is recorded on multiple timesheets
PY 70.04         Overtime calculations for various user defined thresholds (over 37.5 or
                 40 hours, over 160 hours, all FLSA thresholds, different workweeks,
                 firefighters, 28 day public safety employees, etc.)
PY 70.05         Overtime determination by job class
PY 70.06         Overtime may be accumulated as Compensatory Time Off (CTO)
                 based on FLSA and user defined rules Paid straight pay for any comp
                 hours greater than 480 hours, some exceptions apply in emergency
                 situations.
PY 70.07         Recognize differences between FLSA time periods and pay periods /
                 work schedules Currently more than 600 irregular schedules.

PY 70.08         Shift Differential calculated using different rates.
PY 70.09         Shift differential should be included in the premium overtime rate
                 calculation.
PY 70.10         Most recent longevity payment should be included in the regular and
                 premium overtime rate calculation.


RFP Attachment 6.8                                         Payroll Administration Requirements                                                PY12
State of Tennessee                            FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 71.00     The system should allow calculation of overtime based on funding source.
             For example, overtime only allowed on reimbursable grant salary
             expenditures
PY 72.00     The system should have the ability to determine where to charge overtime
             when it has been earned by a specific cost center to allow for proper cost
             accounting
PY 73.00     System should have the ability to calculate tax amounts in accordance
             with:
PY   73.01       Legal requirements
PY   73.02       Employee elections
PY   73.03       Withholding of additional amounts as specified by employee
PY   73.04       Considerations for pre-tax salary reductions for certain items (401K,
                 flexible spending accounts, mega-flex, etc.)
PY   73.05       Effective date of tax
PY   73.06       IRS Earned Income Credit requirements
PY   73.07       IRS for supplemental payments-flexibility in tax calculation method
PY   74.00   The system should calculate the appropriate taxes for taxable non-cash
             values that were reported and to withhold the taxes from the employee's
             current/subsequent regular wage payment (for example, personal use of a
             state vehicle).
PY 75.00     The system should calculate FICA/MFICA according to whether the
             employee is FICA exempt or subject to Medicare only and track FICA
             balance across multiple positions as well as automatically adjust FICA
PY 76.00     System should support software vendor to provide mandatory tax updates
             and follow withholding deposit laws according to federal and state
             guidelines
PY 77.00     The system should provide for the deduction of user specified amounts
             (miscellaneous deductions)
PY 78.00     The system should provide for user specified deduction priorities in table
             format (consistent with legal requirements)


RFP Attachment 6.8                                      Payroll Administration Requirements                                                PY13
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                   RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 79.00     System should have the ability to process partial deductions if an
             employee's pay is insufficient to cover the deduction, automatically
             recalculate tax withholding if a tax exempt deduction is not taken, and
             maintain and adjust arrears balances.
PY 80.00     System should provide the ability to distinguish which deduction types
             require full deduction or allow for partial deduction.
PY 81.00     System calculates employee deductions and State contributions based on
             rules specified in Benefit Administration using the following variables:

PY   81.01       Fixed amount
PY   81.02       % amount of pay (base pay, all pay, departmental pay, etc.)
PY   81.03       Limit amounts (State defined and employee defined)
PY   81.04       Start date (future effective date)
PY   81.05       Stop date
PY   81.06       Future separation date
PY   81.07       Process of arrears options as specified by employee (employee may
                 defer payment according to State policy and still maintain benefits)
                 Employee can submit a check to pay a past due insurance premiums
                 or elect a double deduction through payroll. Their insurance would
                 continue but no claims paid until deferred amounts paid in full.

PY 81.08         One time overrides to amounts
PY 81.09         User and employee defined distribution of cafeteria benefits such as
                 flex benefits, health and dental premiums, and possible additional
                 insurance premiums - long term care.
PY 82.00     System should support the deduction, processing, and tracking of 401K
             and 457 contributions (including monitoring limits and providing
             information and payments to plan administrators) and other State
             sponsored employee retirement savings plans for the following:
PY 82.01         Deductions from employee payroll
PY 82.02         Tracking of amounts
RFP Attachment 6.8                                      Payroll Administration Requirements                                                PY14
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                           10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                                Business Requirements                                  Response             Comments              Modify
PY 82.03         Calculate appropriate tax whether pre-tax or post-tax contribution
PY 82.04         Provide information and payments to plan administrators
PY 82.05         Calculation of State match and payment to plan administrators -
                 increase match based on user defined criteria such as employees'
                 future effective date.
PY 82.06         Ability to suspend State match
PY 82.07         Ability to track amounts of suspended match and retroactively apply the
                 match particularly, in grievance situation when payment retroactive
                 over multiple pay periods and sometimes multiple years.

PY 82.08         Report of separated employees who contributed to deferred
                 compensation
PY 82.09         Defer longevity only and receive maximum annual state match
                 (Currently, receive up to $30 match per month. Option to defer up to
                 $360 of longevity and receive $360 in match instead of monthly
                 deferral).
PY 83.00     System should provide the ability to process flexible benefits such as
             dependant care and medical for the following items:
PY 83.01         Track flexible benefit amounts - contributed and reimbursed on the
                 payroll stub
PY 83.02         Calculate taxes on any pre-tax amounts as provided by the flex
                 program
PY 83.03         Payment of reimbursed amounts when elected
PY 83.04         Ability to reimburse through the AP system and report reimbursement
                 on the next pay stub generated.
PY 83.05         The employer portion of FICA Savings routed to user defined
                 accounting codes Example, FICA Savings funds 50% of the 401K
                 match . Also, funds other projects as indicated in the Appropriations
                 Bill such as the dependant care subsidy.
PY 84.00     System should provide the ability to process other pre-tax benefits in the
             future for the following:
RFP Attachment 6.8                                       Payroll Administration Requirements                                                PY15
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                Business Requirements                                   Response             Comments              Modify
PY 84.01         Track pre-tax amounts and on the payroll stub.
PY 84.02         Calculate taxes on any pre-tax amounts deferred as provided by the
                 flex program
PY 84.03         Payment of reimbursed amounts when elected
PY 84.04         Ability to reimburse through the AP system and report reimbursement
                 on the next pay stub generated.
PY 85.00     System should calculate, pay and track state share of benefit deductions
             regardless of whether or not an employee receives a paycheck for Budget
             Salary Savings.
PY 86.00     System should support the retirement contribution process for the
             following: based upon statutes, maintain retirement deduction balances
             across multiple positions, and interface the data with Retirement.

PY   86.01      Compute the contribution in accordance with statues
PY   86.02      Maintain retirement deductions across multiple positions
PY   86.03      Capability of prorating retirement credit
PY   86.04      Capability to report credited service for 10 month employees as 1.2
                months as opposed to 1.0
PY 86.05        Interface contributions to the retirement system
PY 87.00     Provide the ability to process liens using the following calculation methods:

PY   87.01       Fixed amount
PY   87.02       Fixed amount up to a % of pay
PY   87.03       Fixed amount Plus % up to a maximum
PY   87.04       % of disposable income limit
PY   87.05       Outstanding balance if less than computed amount
PY   88.00   System should provide lien information on paycheck stub
PY   89.00   System should process a garnishment admin fee to pass the revenue
             data for payroll to the financial system. TCA does not allow for the fee
             unless within the garnishable amount (25% of net disposable earnings). If
             currently taking the full garnishable amt, fee held until garnishment stops
             (after 6 months). Or if any other involuntary lien type, must honor before
RFP Attachment 6.8                                        Payroll Administration Requirements                                                PY16
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                           10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                               Business Requirements                                   Response             Comments              Modify
PY 90.00     System should process liens on all earnings including longevity, OT, etc.

PY 91.00     System should prevent voluntary deductions either online or upload after
             bankruptcy and IRS lien in effect.
PY 92.00     System should have override capability if court allows voluntary deduction.

PY 93.00  System should stop deducting lien amount using an end date.
PY 94.00  System should process multiple liens per employee and assign user
          defined priorities
PY 95.00 System should maintain history, balances, and case or docket number &
          processing fee.
PY 96.00 System should maintain garnishment rules according to federal and state
          regulations.
PY 97.00 System provides Savings Bond processing for the following:
PY 97.01      Track deduction amount, purchase amount, owners
PY 97.02      Provide sign-up and inquiry via employee self service
PY 97.03      Provide separate bond address
PY 97.04      Flag when employee address changes to change savings bond
              address.
PY 97.05      Purchase multiple bonds per payroll cycle, including different
              denominations and owners
PY 97.06      Accumulate balance across pay periods if funds not sufficient to
              purchase bond
PY 97.07      Support series of saving bonds, including e-bonds and I-bonds
PY 97.08      Process bond deduction refunds during pay event cycle.
PY 98.00 System should provide the ability to automatically accrue annual and sick
          leave based on current pay or hours worked
PY 99.00 System should provide direct deposit prenote capability
PY 100.00 System should support direct deposit processing and file creation
PY 101.00 System should support the ACH file using the consumer format of PPD


RFP Attachment 6.8                                       Payroll Administration Requirements                                                PY17
State of Tennessee                            FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 102.00 Provides transmission of direct deposit to financial institution on request

PY 103.00 Maintains direct deposit distributions on payroll history
PY 104.00 System should provides the ability to generate multiple direct deposit
          release dates for the same pay cycle.
PY 105.00 System should have the capability to upload bank routing and account
          number changes when the ban issues a large number of changes.
PY 106.00 System should provide editing capability on the direct deposit file prior to
          transmission
PY 107.00 System should accumulate, store, and maintain creditable service by
          employee in order to calculate the amount of an annual longevity payment

PY 108.00 System should accumulate, stores and maintain the hours of premium
          overtime paid to the employee during the past year. This will be used in
          calculating longevity pay for pay adjustments
PY 109.00 System must allow for the following pay cycle frequencies:
PY 109.01     Monthly (existing)
PY 109.02     Semi-monthly (existing)
PY 109.03     Bi-weekly
PY 109.04     Weekly (Legislative interns)
PY 109.05     Special (on demand)
PY 110.00 System should provide the ability to select a group of employees for any
          payroll processing event
PY 111.00 System should have the ability to run simulation runs for review prior to the
          final pay run including the following:
PY 111.01     Allow adjustments to data prior to the final run
PY 111.02     Recalculate only that is required based on changes
PY 111.03     Exception reports in excel format
PY 111.04     Ability to run simulation for specified situation, for example, bonus run.



RFP Attachment 6.8                                      Payroll Administration Requirements                                                PY18
State of Tennessee                            FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                          10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Inquiry


 Reference                                                                                     Vendor                                   Hours to
  Number                               Business Requirements                                  Response             Comments              Modify
PY 112.00 System should allow ability to restrict changes to central payroll staff once
          simulation results are accepted as final.
PY 113.00 The system should flag user-defined exception conditions on simulation
          run reports such as but not limited to the following:
PY 113.01      Zero Hours
PY 113.02      Worked over X hours
PY 113.03      Incomplete benefit data
PY 113.04      Timesheet not approved
PY 113.05      New hire: If start date not at beginning of pay period, only pay for
               hours worked.
PY 113.06      Additional payments
PY 113.07      Involuntary deduction start and stopped
PY 114.00 System should provide the ability to group and sort checks, for example by
          zip code or agency
PY 115.00 System should provide the ability for bar-coding, zip code, and sorting
          software to support cost reductions for printed correspondence that is to
          be distributed through U.S. Postal System.
PY 116.00 System allows for minimum check amounts to avoid zero payments
PY 117.00 System supports production of various user definable pay stub and check
          (if requested) formats
PY 118.00 System provides the ability to enter information regarding any manual
PY 119.00 System allows for two or more checks per employee as required.
PY 120.00 The system provides the ability to calculate pay on-line and produce
          manual checks including deductions and taxes for the following:
PY 120.01      Validate against employee’s master file for deductions, job
               classification, tax data, etc.
PY 120.02      Update all employee and employer accumulators automatically
PY 120.03      Include in pay event reconciliation
PY 120.04      Entered at any point in time
PY 120.05      Print to a remote printer
PY 120.06      Batch manual check or warrants to print together
RFP Attachment 6.8                                      Payroll Administration Requirements                                                PY19
State of Tennessee                               FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                             10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Inquiry


 Reference                                                                                        Vendor                                   Hours to
  Number                                 Business Requirements                                   Response             Comments              Modify
PY 120.07         Ability to produce applicable financial transactions as a result of
                  manual check or off-cycle processing.
                                               Audit Controls
PY 121.00     System should provide controls that specify expected minimum and
              maximum hours and amounts by:
PY   121.01       Department
PY   121.02       Division
PY   121.03       Job class
PY   121.04       Other user specified, such as appointment type
PY   122.00   Prior to payroll processing, system should validate beginning balances
              against ending balances from last run, and stop processing if error occurs
              (must consider any valid transactions that have occurred between pay
              cycles)
PY 123.00     During payroll processing, system should have the ability to stop
              processing if error occurs (must consider any valid transactions that have
              occurred between pay cycles).
PY 124.00     System should provide the ability to define error condition counters that will
              allow payroll to continue processing if individual errors occur, but will stop
              processing if large numbers of errors are identified (indicating an
              underlying set-up problem)
PY 125.00     System provides validations at field level for both on-line and batch input
              such as:
PY   125.01       Validation of all input for new employees
PY   125.02       Validation of changes for current employees on the master file
PY   125.03       Validation of all deduction changes
PY   125.04       Validation of cost accounting data elements
PY   125.05       Balance of total rate, hours, over-time hours, exception hours
PY   125.06       Balance of vacation and sick used by
PY   125.07       Department / Agency
PY   125.08       User defined
PY   126.00   System provides totals for reconciliation of:
RFP Attachment 6.8                                         Payroll Administration Requirements                                                PY20
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                           10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                                Business Requirements                                  Response             Comments              Modify
PY   126.01     Changes to employee pay, deductions, and taxes
PY   126.02     Changes to employer deductions and taxes
PY   126.03     Government reporting for each employee
PY   126.04     Department/division
PY   126.05     Deferred comp (employee and State match)
PY   126.06     Other user specified
PY   127.00 System provides historical records for every financial transaction as a
            complete audit trail.
PY   128.00 System provides a complete audit trail of all records updated on-line.
PY   129.00 System provides a payroll simulation report of all payroll calculations,
            gross-to-net, before check / warrants are produced, including:
PY   129.01     Hours by type
PY   129.02     Earnings by type
PY   129.03     Employee tax liabilities
PY   129.04     Employee deduction amount
PY   129.05     Employer contribution amount
PY   129.06     Deductions not taken and set-up in arrears
PY   129.07     Employer portion of all taxes
PY   129.08     Any user specified chart of account field or combination of fields
PY   129.09     Totals by employee, project, cost center, division, department, total
                State
PY   130.00 System should produce financial transactions as a result of all payroll
            activity
PY   131.00 System should produce financial transactions to reflect funding of leave
            and longevity accruals at the time of accrual
PY   132.00 System should have the ability to distribute longevity and leave costs
            based on the accounts where they were earned regardless of when paid

PY 133.00 System should have the ability to transfer charges for an individual
          employee for a prior payment from one account to another account
          including the associated staff benefits (post-payroll labor distribution)
RFP Attachment 6.8                                       Payroll Administration Requirements                                                PY21
State of Tennessee                              FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                            10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Inquiry


 Reference                                                                                       Vendor                                   Hours to
  Number                                Business Requirements                                   Response             Comments              Modify
PY 134.00 System will include a flexible report writing capability that will allow reports
          to be formatted easily by user personnel
PY 135.00 The system must be able to automate the distribution and recovery of
          reports.
PY 136.00 System produces the following standard reports:
PY 136.01     Savings Bonds
PY 136.02     Deferred compensation report including state match with totals for
              each fund and a grand total plus number of total participants.
PY 136.03     Miscellaneous deduction maintenance listing
PY 136.04     Levy tracking report by type (garnishments) including fees
PY 136.05     Selected deduction register by type
PY 136.06     Deduction register
PY 136.07     Payroll adjustment register showing all changes to employee payroll
              record.
PY 136.08     Quarterly and annual payroll control register
PY 136.09     Current, quarterly, & year-to-date balancing reports
PY 136.10     Quarterly withholding summary
PY 136.11     Quarterly State unemployment insurance
PY 136.12     Federal 941 report
PY 136.13     W-2 audit / final reports by employee
PY 136.14     Social Security Verification Report
PY 136.15     Net deposit financial institutions
PY 136.16     Manual issue check / warrant / warrant listing
PY 136.17     Mid-pay period changes report
PY 136.18     W-4 changes
PY 136.19     Salary changes
PY 136.20     Earned income credit report
PY 136.21     Error log
PY 136.22     Payroll simulation report
PY 136.23     Retirement report
PY 136.24     Separating employee report
RFP Attachment 6.8                                        Payroll Administration Requirements                                                PY22
State of Tennessee                             FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                           10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Inquiry


 Reference                                                                                      Vendor                                   Hours to
  Number                                Business Requirements                                  Response             Comments              Modify
PY   136.25      Arrears report
PY   136.26      Longevity report (Report by pay period or by Dept/Div or longevity
PY   136.27      history by employee) start and end date plus longevity payments
                 Employee History with
PY   136.28      Retroactive pay
PY   136.29      Payroll costs by project supporting federal reimbursement
PY   136.30      Journal Voucher
PY   136.31      Cost Centers by Employee shows funding source, grand fund
                 structure, etc.
PY 136.32        Employee leave balances report
PY 136.33        Annual , Compensatory, Sick Leave Accrual Report for CAFR
PY 136.34        Comp Time Paid when Employee transfers to Executive Branch from
                 Non-Executive Branch.
PY   136.35      Annual and Comp leave pay out when employee separates.
PY   136.36      Flexible Benefit report
PY   136.37      Tip Report
PY   136.38      Employment by allotment code and county
PY   136.39      Payroll register
PY   136.40      Deduction and other earnings report
PY   136.41      Leave balance reports (vacation, sick, compensatory time off (CTO))

PY   136.42    Error log
PY   136.43    Sick Leave Bank Costs per Employee and Allotment Code
PY   136.44    Sick Leave Bank History Record
PY   137.00 System should provide tracking reports linked to work distribution fields

PY 138.00 The system must be able to produce management buy-back information
          for annual and sick leave
PY 139.00 Produce detailed descriptions on pay stubs such as YTD balances, leave
          balances, hourly rates, and deductions.
PY 140.00 System should maintain payroll calendar to ensure proper and timely
          payroll processing
RFP Attachment 6.8                                       Payroll Administration Requirements                                                PY23
State of Tennessee                          FUNCTIONAL REQUIREMENTS MATRIX                                                   RFP # 317.03-134
Project Edison                                                                                                                       10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                              N = Cannot Meet Requirement
M = Modification Required                                                                             Q = Custom Report/Inquiry


 Reference                                                                                  Vendor                                   Hours to
  Number                             Business Requirements                                 Response             Comments              Modify
                          Payment Replacement & Payment Reversal
PY 141.00 The system should provide the ability to reissue a new check number while
          maintaining a link to the old check number with the option to change the
          check date and payee on the reissued check.
PY 142.00 System should provide the ability to process a check reversal using the
          check or advice number to automatically generate the adjustment
          transactions at any point in the payroll cycle
PY 143.00 System should provide the ability to adjust an employee's year to date
          wages, taxes, and/or specific deductions
PY 144.00 System should perform automatic adjustments to pay based on changes
          to hours worked
PY 145.00 System should have the ability to process unlimited adjustments per
          employee pay transaction
PY 146.00 System should provide the ability to recover overpayments (for example
          wage overpayments and travel advance funds not used that need to be
          reimbursed back to the agency) by the next payroll
PY 147.00 System provides the ability to recover overpayments by installment
          amounts over specified time period
PY 148.00 System has the ability to generate stop payment and reversal requests
          online.
PY 149.00 System supports the ability to cancel a prior payment while updating the
          payroll history, employee records, and generating the financial
          transactions
                                            Reporting
PY 150.00 The Payroll component is designed to meet a number of management and
          accounting objectives. These objectives include the ability to:
PY 150.01     Retain State taxes.
PY 150.02     Payment of Federal taxes withheld
PY 150.03     Comply with Federal payroll tax reporting requirements.
PY 150.04     Comply with State payroll tax reporting requirements.


RFP Attachment 6.8                                   Payroll Administration Requirements                                                PY24
State of Tennessee                           FUNCTIONAL REQUIREMENTS MATRIX                                                    RFP # 317.03-134
Project Edison                                                                                                                         10/21/05



Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Inquiry


 Reference                                                                                    Vendor                                   Hours to
  Number                              Business Requirements                                  Response             Comments              Modify
PY 151.00 System should produce W-2 and W-2C forms electronically and paper
          form. The state will generate the forms in the correct format and have the
          ability to select from varying formats (i.e. mailer or side by side).
PY 152.00 System should calculate and produce duplicate W-2, and W-2C forms for
          multiple years
PY 153.00 System should calculate Allocated Tips automatically by tracking servitor
          sales
PY 154.00 System should provide YTD Total Gross on pay stub reconciled to Box 1
          on W-2
PY 155.00 System should properly report deceased employee payments on the W-2
          and death benefits on the 1099R
PY 156.00 System should report dependant care subsidy on W-2 through benefits
          module
PY 157.00 System should allow a change of address before reissue duplicate W-2.

PY 158.00 System should create Form 941 on a quarterly basis and Form 941C as
          needed
PY 159.00 System should create W-2 electronic file to SSA
PY 160.00 System should import taxable fringe benefits to the W-2
PY 161.00 System should have the ability to import information from a third party to
          the W-2 (perma plan).
PY 162.00 System should have the ability to make adjustments to tax information
          retrieved from payroll history and/or outside sources both before and after
          reporting to the IRS (SSN changes, check cancellations, fringe benefits,
          and refunds)
PY 163.00 System should produce W-2s for Respite Care Providers (babysitting for
          foster care children) paid through AP in accordance with IRS regulations

PY 164.00 System should allow for statewide access capability of online manual on
          intranet.


RFP Attachment 6.8                                     Payroll Administration Requirements                                                PY25
State of Tennessee                                                                                                  RFP 317.03-134
Project Edison
                                FUNCTIONAL REQUIREMENTS MATRIX                                                            10/21/05




                                            Timekeeping and Leave Accounting

                Timekeeping/Leave Accounting addresses the administration of the State's multiple rules for
                capturing and calculating time and for granting and using the various types of employee leave. In
                addition, this section includes functions to:

                          Support positive and exception based time entry
                          Allow online time entry to the appropriate Chart of Accounts element, e.g., grants,
                           projects
                          Calculate overtime hours and eligibility
                          Allow flexible definition of shift and work schedules
                          Provide flexible workflow for review and approval of timesheets
                          Calculate leave eligibility and available leave
                          Allow employees to request leave online with automatic routing for approval
                          Notify employees of leave approvals or denials
                          Integrate leave types with Benefits Administration and Payroll
                          Track leave taken by leave type and reason



                Additional Information:




RFP Attachment 6.8                                          Introduction                                                        ii
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
                       Timekeeping and Leave Accounting General Requirements
 TL 1.00       System allows employees and employee groups to be processed based on
               positive or exception time entry.
 TL 2.00       System should provide the ability to accommodate time entry for different pay
               schedules, including:
 TL   2.01        Weekly
 TL   2.02        Biweekly
 TL   2.03        Semi-monthly
 TL   2.04        Monthly.
 TL   3.00     System should provide for online access and update capabilities to all
               employee data with appropriate security.
 TL 4.00       System should provide the ability to group employees by functional or
               organizational unit.
 TL 5.00       System checks employee status prior to allowing time entry (check for
               suspension, terminated, etc.).
 TL 6.00       System should provide the ability to produce unlimited default schedules and
               work hours for exception based employees based on user defined profile.

 TL 7.00       System should provide the ability to adjust default schedule and work hours
               for individual employees.
 TL 8.00       System should provide the ability to track scheduled beginning time and
               scheduled ending time on a daily basis.
 TL 9.00       System should provide the ability to change scheduled beginning time and
               scheduled ending time on a daily basis based on actual time periods worked.
 TL   10.00    System should provide for the following types of time entry:
 TL   10.01         Online by the employee (web enabled)
 TL   10.02         Entry by data entry personnel or timekeepers
 TL   10.03         Third party time entry systems (ex - KRONOS).
 TL   11.00    System should provide the ability to support the use of automated time
               collection (ex - magnetic card readers) for time.
 TL 12.00      System should allow employees to submit more than one timesheet per pay
               period (one per Agency).
 TL 13.00      System provides the ability to define timesheet fields by:
 TL 13.01           Agency
 TL 13.02           Division

      RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                           TL1
    State of Tennessee                                                                                                                RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                             10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Query

  Reference                                                                                   Vendor                                             Hours to
   Number                                  System Requirements                               Response                   Comments                  Modify
 TL   13.03       Job classification
 TL   13.04       Hour type
 TL   13.05       Cost Center
 TL   13.06       User defined.
 TL   14.00    System allows timesheet edits to be defined by:
 TL   14.01       Agency
 TL   14.02       Division
 TL   14.03       Job classification
 TL   14.04       Hour type
 TL   14.05       Status
 TL   14.06       Cost Center
 TL   14.07       User defined.
 TL   15.00    System should default as much information as possible, including:
 TL   15.01       Agency
 TL   15.02       Division
 TL   15.03       Cost Center
 TL   15.04       Project
 TL   15.05       Other COA fields
 TL   15.06       Name
 TL   15.07       Employee number
 TL   15.08       Social Security Number
 TL   15.09       Pay period and dates
 TL   15.10       Workgroup
 TL   15.11       FLSA
 TL   15.12       28 day schedule group indicator
 TL   15.13       Units
 TL   15.14       Position number
 TL   15.15       Classification title
 TL   15.16       Pay period number
 TL   15.17       Service anniversary date
 TL   15.18       Hire date
 TL   15.19       Service group code
 TL   15.20       Sick bank indicator
 TL   15.21       Daily schedule information for hours worked, leave, etc.
 TL   15.22       Leave balances
 TL   15.23       Other, user defined.

      RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                         TL2
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                              10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                   System Requirements                                Response                   Comments                  Modify
 TL 16.00      System should allow an unlimited number of hour types in a pay period for an
               employee.
 TL 17.00      System should allow an unlimited number of hour types in a day for an
               employee.
 TL   18.00    System should provide the ability to restrict hour types by:
 TL   18.01       Agency
 TL   18.02       Division
 TL   18.03       Job classification
 TL   18.04       Status
 TL   18.05       Workgroup
 TL   18.06       On certain days (ex - holidays)
 TL   18.07       User defined.
 TL   19.00    System should provide the ability to define maximum number of hours by:
 TL   19.01       Agency
 TL   19.02       Division
 TL   19.03       Job classification
 TL   19.04       Status
 TL   19.05       Workgroup
 TL   19.06       User defined.
 TL   20.00    System should verify hours worked based on work schedule and hour type.

 TL 21.00      System provides the ability to associate a shift with the hours worked.
 TL 22.00      System provides the ability to generate a shift differential pay amount based
               on hours worked during certain shifts based on user-defined parameters.

 TL 23.00      The system displays current leave accrual rates, codes and the maximum
               balances for each employee while time is being entered or reviewed.
 TL 24.00      System allows interactive edits of time data against the employee leave
               balances.
 TL 25.00      The system should adhere to and comply with all Civil Service Rules, Court
               Orders, State law, Federal requirements and State Policies & Procedures.

 TL 26.00      System should check FMLA eligibility when entering time.
 TL 27.00      System should provide for the adjustment of leave balances for the two prior
               pay periods without going to a different data entry window.
 TL 28.00      System allows for daily entry.

      RFP Attachment 6.8                                     Timekeeping and Leave Accounting Requirements                                          TL3
    State of Tennessee                                                                                                                RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                              10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Query

  Reference                                                                                   Vendor                                             Hours to
   Number                                 System Requirements                                Response                   Comments                  Modify
 TL 29.00     System should provide the ability for supervisors to override any timesheet
              entry.
 TL 30.00     System should provide the ability to lock out employee time entry after
              supervisor has approved the time record.
 TL 31.00     System allows for entry of total hours per pay period by hour type.
 TL 32.00     System should include an integrated imaging capability for linking scanned
              data to time records.
 TL 33.00     System should allow for a comment area on the time sheet that includes date
              and time of entry.
 TL 34.00     System should require a comment on certain types of requests, i.e., sick
              leave requests, overtime requests, etc.
 TL 35.00     System should allow for supervisory comments for denials of time and leave
              on the employee's timesheet.
 TL 36.00     System allows input of time and leave in decimal increments in tenths.
 TL 37.00     System should display and accurately total time and leave during split
              workweeks (portions of workweek are a part of two pay periods).
 TL 38.00     System calculates/verifies overtime hour eligibility based on user defined
              rules, including:
 TL 38.01         FLSA
 TL 38.02         Exceptions to FLSA (ability to override the FLSA status through the
                  employee assignment).
 TL 38.03         System should provide the capability to generate overtime for any user-
                  defined schedule such as 37.5 hour or 40 hour weekly schedules, 7 day,
                  14 day, 21 day or 28 day, etc.
 TL 38.04         Calculate overtime for 28 day schedules over possibly three pay periods.

 TL 38.05        Calculate overtime for 21 day schedules over possibly two pay periods.

 TL 38.06        Ability to correctly compute overtime for split work weeks (portions of
                 work week are a part of two pay periods)
 TL 38.07        Ability to correctly compute overtime for new employees for split work
                 weeks.
 TL 38.08        System has the ability to handle combined rates of overtime for
                 employees who have time tied to more than one job which may be in
                 more than one Agency
 TL 38.09        Spread overtime among cost centers worked

    RFP Attachment 6.8                                      Timekeeping and Leave Accounting Requirements                                         TL4
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
 TL 38.10         Recognize distinction between regular and premium overtime
 TL 38.11         Ability to pay overtime based on a rate that is different from the
                  employee's regular hourly rate.
 TL 38.12         Other State policies
 TL 39.00      System generates holiday schedules and automatically updates eligible
               employee time and attendance records.
 TL 40.00      Automatically determines holiday eligibility based on:
 TL 40.01         Employee status (regular, emergency, interim, temporary, etc.)
 TL 40.02         Extended leave type (maternity leave, worker's comp, educational leave,
                  etc.)
 TL 40.03         Pay status (ex - positive pay status for the major portion of prior day, on
                  qualified leave type, etc.)
 TL   40.04       Hour type after holiday for separating employees
 TL   40.05       Other, user defined.
 TL   41.00    Automatically calculates holiday hours for eligible employees, including:
 TL   41.01       Defaults hours for all eligible employees based on schedule
 TL   41.02       Accrues holiday time (similar to compensatory time) for certain
                  employees that work on holidays (per DOP rules)
 TL 41.03         Allow payment for holiday hours worked based on Agency, division, and
                  job class
 TL 41.04         Allow for varying methods of calculating payment for holiday hours
                  worked based on Agency, division, and job class
 TL   41.05       Other, user defined.
 TL   42.00    System allows for the processing of two different years at the same time.
 TL   43.00    System allows various bonuses to be tied to:
 TL   43.01       Job classification
 TL   43.02       Employee
 TL   43.03       Type of work
 TL   43.04       Shift
 TL   43.05       Other user defined fields.
 TL   44.00    System provides user defined eligibility rules for entry of bonus hour types.

 TL 45.00      System allows each Agency to create work shifts and work schedules of
               variable duration, for example:
 TL 45.01          24 hour shift
 TL 45.02          12 hour shift

      RFP Attachment 6.8                                     Timekeeping and Leave Accounting Requirements                                           TL5
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                  System Requirements                                  Response                   Comments                  Modify
 TL 45.03        21 day schedule
 TL 45.04        Day of schedule start (Monday, Tuesday, day after end of last schedule,
                 etc.)
 TL 45.05        Combinations of shift, schedule, and schedule start
 TL 45.06        User defined.
 TL 46.00     System allows scheduling of periodic shifts or schedules on an annual basis.

 TL 47.00     System should provide the ability for changes to prior periods to integrate
              with payroll to correct pay, hours worked, etc.
 TL 48.00     System automatically generates pay adjustment transactions when
              necessary based on retroactive data entered, i.e., hours entered causes
              overtime in a prior pay period.
 TL 49.00     System should automatically adjust accruals for retroactive entry of hours.
 TL 50.00     System should provide the ability to make mass changes for a single
              employee or group of employees within an interval of time and make any
              necessary corresponding adjustments to records, balances or pay.
 TL 51.00     System should provide for the automatic adjustment of existing leave
              balances to all applicable employees when accrual rules change (including
              retroactive changes).
 TL 52.00     System should provide the ability to make prior pay period adjustments and
              apply time, pay rules and accrual balances that were in effect at that point in
              time (and for each pay period affected through the current pay period) with
              automatic recalculation.
 TL 53.00     System should provide the ability to adjust service and longevity credit
              automatically based on the type of retroactive adjustment.
 TL 54.00     System should provide an audit trail of all retroactive adjustments.
 TL 55.00     Ability to future date transactions for processing during the appropriate pay
              period.
 TL 56.00     System should provide the ability to approve leave and overtime requests for
              future pay periods.
 TL 57.00     System updates timesheet for current pay period with leave approvals that
              were approved in advance.
 TL 58.00     System should verify that leave requested and approved in advance is
              available for usage at the time of payroll for the affected pay period.
 TL 59.00     System should automatically compensate for daylight savings time.


    RFP Attachment 6.8                                       Timekeeping and Leave Accounting Requirements                                           TL6
    State of Tennessee                                                                                                                 RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                              10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                 N = Cannot Meet Requirement
M = Modification Required                                                                                Q = Custom Report/Query

  Reference                                                                                    Vendor                                             Hours to
   Number                                  System Requirements                                Response                   Comments                  Modify
 TL 60.00      System should automatically compensate for daylight savings time based on
               new federal guidelines.
 TL 61.00      System should provide for flexible workflow for multi-step review and
               approval of timesheets, including:
 TL 61.01         Routing of individual timesheets to timekeepers and/or supervisors for
                  employees performing direct entry
 TL 61.02         Routing of batches of timesheets to appropriate management personnel

 TL 61.03          Assign employees to workgroups that are routed through workflows.
 TL 61.04          Routing may vary depending on exceptions to time reported (leave taken,
                   overtime, etc.)
 TL 61.05          Provide for e-mail notifications as defined by user
 TL 61.06          Other, user defined.
 TL 62.00      System should provide electronic approval of time entered by employee,
               timekeeper and supervisor.
 TL 63.00      System should require supervisor's approval on all timesheets before
               sending information to payroll.
 TL 64.00      System should provide the ability for agency to approve and release time and
               pay data at end of each pay cycle.
 TL 65.00      System should provide controls that specify expected minimum and
               maximum hours by:
 TL   65.01        Department
 TL   65.02        Job classification
 TL   65.03        Time sheet transmittal (positive & exception reporting)
 TL   65.04        Employee status
 TL   65.05        Other, user defined.
 TL   66.00    System should support processing of both paid and unpaid leave.
 TL   67.00    System should support short term leave (sick, vacation, etc.) and long term
               leave.
 TL 68.00      System should support both the computation of leave available and the
               taking of leave (whether paid or unpaid).
 TL 69.00      Leave calculations for accrual and payment will be effective dated based on
               user defined criteria.
 TL 70.00      Timekeeping and Leave Accounting will be integrated with the following:
 TL 70.01          Personnel administration
 TL 70.02          Benefit administration

      RFP Attachment 6.8                                   Timekeeping and Leave Accounting Requirements                                           TL7
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
 TL   70.03        Insurance
 TL   70.04        Payroll
 TL   70.05        Financial system
 TL   70.06        Travel
 TL   70.07        Fleet Management
 TL   70.08        Plant Maintenance.
 TL   71.00    Timekeeping and Leave Accounting will interface with the following:
 TL   71.01        Worker's compensation
 TL   71.02        Insurance carriers/third party administrators
 TL   71.03        Social Security Disability
 TL   71.04        Retirement.
 TL   72.00    Provide employee self service capabilities that include:
 TL   72.01        Inquiries on all leave balances
 TL   72.02        Inquiries on all leave accruals
 TL   72.03        Inquiries on all leave usage
 TL   72.04        Request leave and overtime in advance
 TL   72.05        Inquiries on the status of all leave and overtime requests
 TL   72.06        Enroll in Sick Leave Bank
 TL   72.07        Donate Sick Leave
 TL   72.08        Request FMLA
 TL   72.09        Other, user defined.
                                      Labor Distribution Requirements
 TL 73.00      System allows for employees to charge time to any accounting element as
               defined in the Chart of Accounts to include:
 TL   73.01        Grants
 TL   73.02        Sub-grants
 TL   73.03        Projects
 TL   73.04        Sub-projects
 TL   73.05        Work Order
 TL   73.06        Cost Center
 TL   73.07        Fund
 TL   73.08        Statistics
 TL   73.09        Department/Division
 TL   73.10        Other, user defined.
 TL   74.00    Provide for designation of default ("home") accounting information to be used
               on time entries to include:
      RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                           TL8
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                   System Requirements                                  Response                   Comments                  Modify
 TL   74.01        Grants
 TL   74.02        Sub-grants
 TL   74.03        Projects
 TL   74.04        Sub-projects
 TL   74.05        Work Order
 TL   74.06        Cost Center
 TL   74.07        Fund
 TL   74.08        Department/Division
 TL   74.09        Other, user defined.
 TL   75.00    System allows employees to charge time to multiple accounting distributions
               other than their “home” accounting distribution (with interactive edit).

 TL 76.00      System allows employees to charge time to a different division.
 TL 77.00      System provides ability for user to specify distribution percentages when
               multiple accounting distributions are charged.
 TL 78.00      System provides ability for user to specify distribution of actual hours when
               multiple accounting distributions are charged.
 TL 79.00      System provides ability for home base accounting distribution needs to allow
               for up to 50 accounting lines.
 TL 80.00      System provides the ability to allocate time off on a different basis than time
               worked.
 TL 81.00      Allows entry of statistics (i.e., sessions/visits) as well as hours.
 TL 82.00      Provides ability to enter statistical information when required (equipment
               usage, units of work accomplished).
 TL 83.00      System allows employee to enter multiple time records for a 24 hour period
               including varying periods of time worked, cost centers, projects and other
               COA elements worked within a given shift.
 TL 84.00      System provides the ability to make on-line retroactive corrections of work
               distribution.
 TL 85.00      Support "matrix" style labor distribution for multiple employees when all
               employees have the same pay type and accounting distribution (ex - unit time
               sheets for the Safety personnel).
 TL 86.00      Collects the following time reporting information at a minimum:
 TL 86.01          Employee number
 TL 86.02          Employee name


      RFP Attachment 6.8                                     Timekeeping and Leave Accounting Requirements                                            TL9
    State of Tennessee                                                                                                                RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                             10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Query

  Reference                                                                                   Vendor                                             Hours to
   Number                                   System Requirements                              Response                   Comments                  Modify
 TL 86.03          Accounting information for "home" cost center (agency, project, other
                   COA information)
 TL   86.04        Accounting information for each line (if different from "home")
 TL   86.05        Hours worked
 TL   86.06        Hour type (regular, vacation, leave, etc.)
 TL   86.07        FLSA
 TL   86.08        Workgroup
 TL   86.09        Units
 TL   86.10        Comments
 TL   86.11        Other, user defined.
                                      Leave Calculations and Payments
 TL 87.00      System calculates the accrual and tracks eligibility, usage and payment of
               unlimited amount of leave types such as:
 TL   87.01        Sick leave
 TL   87.02        Sick leave bank
 TL   87.03        Accrued Holiday
 TL   87.04        Bereavement
 TL   87.05        Donated Sick Leave
 TL   87.06        Workers’ compensation
 TL   87.07        Maternity/Paternity
 TL   87.08        Adoption
 TL   87.09        Compensatory Time Off (CTO)
 TL   87.10        Family (Sick Leave)
 TL   87.11        Annual
 TL   87.12        Witness (State)
 TL   87.13        Civil leave
 TL   87.14        Military Leave without pay
 TL   87.15        Military Leave with pay
 TL   87.16        Special Military Leave/Pay (OEF)
 TL   87.17        Administrative leave with pay
 TL   87.18        Educational leave with pay
 TL   87.19        Educational leave without pay
 TL   87.20        Terminal leave
 TL   87.21        Separation leave without pay
 TL   87.22        Current without pay
 TL   87.23        Injured in line of duty

      RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                        TL10
    State of Tennessee                                                                                                                RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                             10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Query

  Reference                                                                                   Vendor                                             Hours to
   Number                                  System Requirements                               Response                   Comments                  Modify
 TL   87.24       Sick leave excludable
 TL   87.25       FMLA - annual
 TL   87.26       FMLA - sick
 TL   87.27       FMLA - without pay
 TL   87.28       Assault injury
 TL   87.29       Terminal comp time
 TL   87.30       Special leave with pay (teachers)
 TL   87.31       Extended leave without pay
 TL   87.32       Red cross leave
 TL   87.33       Disciplinary leave
 TL   87.34       User defined.
 TL   88.00    System supports different rules for each leave type.
 TL   89.00    System allow users to define leave accrual calculation and usage rules
               based on user defined combinations of variables, including:
 TL   89.01       Job class
 TL   89.02       Length of service (range)
 TL   89.03       Agency or Division
 TL   89.04       Effective dates
 TL   89.05       Expiration dates
 TL   89.06       Minimum hours worked/paid in a month for accrual
 TL   89.07       Type of hours required for accrual
 TL   89.08       Accrual amount
 TL   89.09       Frequency
 TL   89.10       Maximum hours accrued
 TL   89.11       Dollars paid
 TL   89.12       Payout option available
 TL   89.13       Work week (37.5 vs. 40)
 TL   89.14       Benefit accrual plan
 TL   89.15       Minimum hours worked in a fiscal or calendar year for accrual to begin
                  (1600 hours)
 TL   89.16       May be taken in period accrued
 TL   89.17       May not be taken before accrued
 TL   89.18       FMLA
 TL   89.19       Rollover
 TL   89.20       Rollover amount
 TL   89.21       Rollover dated

      RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                        TL11
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
 TL   89.22       Other, user defined.
 TL   90.00    Accrues and tracks compensatory time, including:
 TL   90.01       Provides for user defined types of compensatory time
 TL   90.02       Provides for definition of maximum accrual by compensatory leave type

 TL 90.03          Provides for exceptions to maximum accrual by compensatory leave type

 TL 90.04          Provides for automatic payment over maximum
 TL 90.05          Provides for the accrual of compensatory time in lieu of cash for overtime
                   in compliance with FLSA requirements.
 TL 90.06          Provides for the accrual of combinations of compensatory time and cash
                   overtime within the same workweek.
 TL 90.07          Other, user defined.
 TL 91.00      System should provide the ability to override individual leave balances by
               entering specific leave amounts.
 TL 92.00      System should provide the ability to allow employees to select cash
               payments for leave based on:
 TL   92.01        Agency
 TL   92.02        Job classification
 TL   92.03        Leave Type
 TL   92.04        Other, user defined.
 TL   93.00    System should support calculation of leave based on hours worked on
               temporary assignments. Utilization of this feature is user defined by leave
               type.
 TL   94.00    System should support terminal leave processing by leave type including:
 TL   94.01        Pay or don't pay (Gross Misconduct)
 TL   94.02        Lump sum or "run out" available at employee or agency option
 TL   94.03        Carryover for reinstatement on rehire (Sick Leave Reinstatement)
 TL   94.04        Lose on termination (Lose of Sick Leave).
 TL   95.00    Provide rollover of balances above maximums from one type of leave to
               another based on user defined parameters.
 TL 96.00      System validates against leave accrued prior to usage and payment to
               ensure appropriate balance is available (or projected to be available at time
               of use).
 TL 97.00      System provides the ability for leave exceptions due to work related
               circumstances (Assault injury) with routing .

      RFP Attachment 6.8                                     Timekeeping and Leave Accounting Requirements                                          TL12
    State of Tennessee                                                                                                                  RFP # 317.03-134
    Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                             Hours to
   Number                                  System Requirements                                 Response                   Comments                  Modify
 TL 98.00     System should analyze leave balances and perform leave defaulting if the
              balance has been depleted based on user defined rules.
                                      Special Military Leave/Pay (OEF)
 TL 99.00     System should provide the ability to track leave and pay information for
              employees receiving special military payments under executive order.
 TL 100.00    System should provide the ability to continue leave accruals for employees
              receiving special military payments.
 TL 101.00    System should provide the ability to continue longevity payments for
              employees receiving special military payments.
                                              Donated Sick Leave
 TL 102.00    Ability to transfer donated leave according to user defined rules:
 TL 102.01        Ability to automatically transfer leave based on user defined requirements
                  for transferring leave
 TL 102.02        Ability to update receiving employee's balances based on user defined
                  requirements for accepting leave
 TL 102.03        Types of eligible leave
 TL 102.04        Track medical verification
 TL 102.05        Automatic notifications as defined by the user, i.e., when medical
                  information is approved, when leave has been deducted, affected
                  agencies, etc.
 TL 102.06        Ability to track historic information regarding donated leave for each
                  employee to include hours donated, hours received, affected periods,
                  etc.
 TL 102.07        Ability to track historic information regarding donated leave per illness.

                                          Sick Leave Bank
 TL 103.00 Ability to "process and track" sick leave bank:
 TL 103.01     Initial enrollment and deduction of user specified amount from leave
               balance.
 TL 103.02     Periodic reassessment and periodic reprocessing (monthly) if leave
               balance not available and employee on qualifying leave the month before
               reassessment.
 TL 103.03     Ability to set reassessment amount.
 TL 103.04     Dropping from sick leave bank if reassessment not complete within one
               year.


    RFP Attachment 6.8                                      Timekeeping and Leave Accounting Requirements                                          TL13
    State of Tennessee                                                                                                                   RFP # 317.03-134
    Project Edison
                                                    FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                             Hours to
   Number                                   System Requirements                                 Response                   Comments                  Modify
 TL 103.05         Ability to notify the employee and agency after enrollment and
                   reassessment.
 TL 103.06         Requests for sick leave bank made online.
 TL 103.07         Ability to notify member’s department when application filed online or
                   directly to Personnel.
 TL 103.08         Ability to automatically update timesheet based on approvals.
 TL 103.09         Ability to generate retroactive payment amounts if approvals affect prior
                   pay periods
 TL 103.10         Ability to determine leave without pay requirements prior to using leave
                   from the bank.
 TL   103.11       Track medical verification.
 TL   103.12       Track physicians.
 TL   103.13       Track multiple diagnosis.
 TL   103.14       Track sick leave bank taken by illness type for entire career.
 TL   103.15       Track sick leave bank taken by year.
 TL   103.16       Ability to remove employees from sick leave bank based on status or
                   agency changes.
 TL 103.17         Ability to track appeal process.
 TL 103.18         Ability to enter historic information regarding sick leave bank membership
                   and usage.
 TL 103.19         Provide alert to person entering time when usage of sick leave will take
                   the balance below sick leave bank annual donation requirements (this
                   check to begin during a user defined portion of the year).
                                                 Leave Tracking
 TL 104.00     System should provide the ability to track all leave accrued and taken by type
               of eligible leave and reason.
 TL 105.00     System should be able to project leave "run out" for separating employees
               (What if scenarios), including any additional accruals that will occur.

 TL   106.00 System should track leave by dates, including:
 TL   106.01    Expected start of leave
 TL   106.02    Expected end of leave
 TL   106.03    Actual start of leave
 TL   106.04    Actual end of leave
 TL   106.05    Date leave requested
 TL   106.06    Date approved or rejected
      RFP Attachment 6.8                                     Timekeeping and Leave Accounting Requirements                                          TL14
    State of Tennessee                                                                                                               RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                              10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                               N = Cannot Meet Requirement
M = Modification Required                                                                              Q = Custom Report/Query

  Reference                                                                                  Vendor                                             Hours to
   Number                                System Requirements                                Response                   Comments                  Modify
 TL 106.07      Reviewer/approver
 TL 106.08      Other, user defined.
 TL 107.00 System should prohibit the request of leave that is in excess of leave balance
           in the case of paid leave or policy maximums in the case of unpaid leave.
           This must be user definable by type of leave (ex - sick leave, FMLA
           maximums).
 TL 108.00 System should prohibit the usage of certain types of leave based on leave
           balances at the time leave is requested. (within two days of maximum law)

 TL 109.00 System should provide the ability to code leave and reflect impact to service
           dates, service hours, etc. based on leave type.
 TL 110.00 System provides ability for user to define whether leave is accrued while on
           leave by leave type (ex - continue to accrue vacation while on sick leave).
 TL 111.00 Support the tracking of Doctor's release when required.
 TL 112.00 System provides employee status that reflects that they are on leave of
           absence (long term leave).
 TL 113.00 System provides notifications to employees and agency of leave that will be
           lost or automatically paid (email or paycheck comment).
 TL 114.00 System should provide notification when employee is eligible for increase in
           accrual rate.
 TL 115.00 System should display when a part time employee is nearing part time
           threshold (ex - 1599 hours per year).
 TL 116.00 System should track part time hours by fiscal and calendar year.
 TL 117.00 System should display when a retired employee is nearing retiree threshold
           (ex - 900 hours per year).
 TL 118.00 System should track hours worked for employees in job share positions by
           pay period and/or fiscal year.
 TL 119.00 System should track when employees have used sick leave continuously for
           a six month period.
                                                 FMLA
 TL 120.00 System should determine eligibility for FMLA based on working 1250 hours
           during the previous 12 months from beginning date of FMLA.
 TL 121.00 System should automatically classify leave as counting toward FMLA limits
           after a user defined period by leave type.
 TL 122.00 Track FMLA hours and eligibility by employee.
                                       Time and Leave History
    RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                         TL15
    State of Tennessee                                                                                                                    RFP # 317.03-134
    Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                             Hours to
   Number                                  System Requirements                                   Response                   Comments                  Modify
 TL 123.00 System provides history of time and leave type entered by calendar, State's
           fiscal year and Federal fiscal year.
 TL 124.00 System provides a detailed history of all leave adjustments.
 TL 125.00 System should provide the ability to retain detail historical data of all activity,
           including scheduled hours, hours worked and leave hours and type.
 TL 126.00 System should maintain history of all leave accounting actions, including:
 TL 126.01     Modifications to leave definitions
 TL 126.02     Accrual calculations
 TL 126.03     Leave taken
 TL 126.04     Leave claimed (on T&L form)
 TL 126.05     Leave paid
 TL 126.06     Leave adjustments
 TL 126.07     Leave without pay
 TL 126.08     Other, user defined.
                               Query and Reporting Requirements
 TL 127.00 System should provide for online access for query to all employee data with
           appropriate security.
 TL 128.00 System should include a flexible report writing capability that will allow reports
           to be formatted easily by user personnel.
 TL 129.00 System produces a report each pay period listing all employees sick,
           vacation, other leave balances (Leave Balance Report).
 TL 130.00 System should produce a report of employees due back from leave (this
           report should be produced XX days before an employee returns), including
           type of leave and type of end date (return to work, reevaluate, etc.).
 TL 131.00 System should produce a Leave Buyback Report.
 TL 132.00 System should produce a report that documents work schedules for a
           workgroup by period and employee.
 TL 133.00 System should produce a sick leave bank used by pay period report.
 TL 134.00 System should produce an excessive leave balance report.
 TL 135.00 System should provide for online access to all employee time and
           attendance data with appropriate security.
 TL 136.00 System should include a flexible report writing capability that will allow reports
           to be generated based on user defined criteria. (Ad Hoc)
 TL 137.00 System should include a flexible report writing capability that will allow for
           statistical information on leave usages for a user defined period of time.

    RFP Attachment 6.8                                       Timekeeping and Leave Accounting Requirements                                           TL16
    State of Tennessee                                                                                                                RFP # 317.03-134
    Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                               10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                N = Cannot Meet Requirement
M = Modification Required                                                                               Q = Custom Report/Query

  Reference                                                                                   Vendor                                             Hours to
   Number                                 System Requirements                                Response                   Comments                  Modify
 TL 138.00 System provides exception reports after time input that will capture a variety
           of incidents, including:
 TL 138.01      No time for active employee
 TL 138.02      Excessive overtime
 TL 138.03      Error or Unapproved Timesheets
 TL 138.04      Overtime for Fair Labor Standards Act (FLSA).
 TL 139.00 System should produce an attendance report.
 TL 140.00 System should produce overtime reports to include hours, dollars spent by
           cost center.
 TL 141.00 System should produce a time & leave input report that identifies what, who
           and when entries are made.
 TL 142.00 System should produce an hour type exception report.
 TL 143.00 System should provide a report that details scheduled hours, time worked,
           leave usages, leave balances, etc., on a daily basis each pay period for
           every employee.
 TL 144.00 System should provide the ability to customize employee time sheets and
           print by employee or group of employees.
 TL 145.00 System should produce an employee availability report by pay period.
 TL 146.00 System should produce a detailed employee history by user defined
           beginning and ending date.
 TL 147.00 System should produce a report that provides total scheduled hours, time
           worked, total leave usages (per type) and total overtime hours by cost center,
           division, interdepartmental group, or agency.
 TL 148.00 System should prepare a leave taken report by employee and allotment code
           of leave taken during the prior fiscal year by leave category (annual and
           compensatory time).
 TL 149.00 System should prepare a leave value report by employee and allotment code
           of leave balances at the end of the fiscal year with the following information:
           leave balance in hours, hourly wage, hours times hourly wage, FICA, total
           leave value plus FICA. (annual, compensatory time, and sick time.).




    RFP Attachment 6.8                                    Timekeeping and Leave Accounting Requirements                                          TL17
State of Tennessee                                                                                                   RFP 317.03-134
Project Edison
                                FUNCTIONAL REQUIREMENTS MATRIX                                                             10/21/05




                                                  Training/Employee Development

                     Training and Employee Development addresses the management of training and skills including
                     proficiency levels and expiration dates. In addition, this section includes functions to:

                           Provide standard career development curriculum based on position, skill category, and
                            other criteria
                           Allow employees to request training online and route request for appropriate approvals
                           Record training session attendance, grades, costs, certifications, etc.
                           Track classes and courses needed for career / job progression planning
                           Track prerequisites




                     Additional Information:




RFP Attachment 6.8                                         Introduction                                                          ii
   State of Tennessee                                                                                                                    RFP # 317.03-134
   Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                              Hours to
   Number                                   System Requirements                                 Response                   Comments                   Modify
                                    Training General Requirements

              System should provide for the definition of a standard education and career
              development curriculum based on position, skill category, and other criteria.
              This capability allows supervisors to work with their subordinates to establish
  TR 1.00     a career development plan specific to each particular employee.

  TR   2.00   System should provide for planning of future training (Full Fiscal Year):
  TR   2.01      Classes/sessions to be given and location
  TR   2.02      Number of employees to be trained
  TR   2.03      Projected cost of training (internal and external costs)
  TR   2.04      Opportunity cost of employees attending training
  TR   2.05      Source of funding
  TR   2.06      Track actual against plan.
  TR   3.00   System should provide for scheduling of require future training.

  TR 4.00     System provides for automatic notification of upcoming required training.
              System provides the ability to create a plan by division and employee each
  TR 5.00     fiscal year.
              System should provide for the definition of a career development plan,
  TR 6.00     including standard and alternative career paths (position series).
              The system should support the functions of training, employee development,
              skills tracking, testing, licenses, and certifications. At a minimum, the
  TR 7.00     following broad functions will be supported:
                   Creation, tracking and maintenance of lessons (the lowest grouping of
  TR 7.01          items taught - same lesson can belong to more than one class)
  TR 7.02          Creation, tracking, and maintenance of classes (a group of one or more
                   Creation, tracking and maintenance of courses (a group of one or more
  TR 7.03          classes - same course can belong to more than one program)
                   Creation, tracking, and maintenance of programs / curriculums (a group
  TR 7.04          of one or more courses)
                   Tracking of Outside Training - training provided by other agencies,
  TR 7.05          vendors, and organizations


   RFP Attachment 6.8                                     Training and Employee Development Requirements                                             TR1
   State of Tennessee                                                                                                                   RFP # 317.03-134
   Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                              Hours to
   Number                                  System Requirements                                 Response                   Comments                   Modify
                    Tracking of employee training and enrollment in classes, courses,
                    programs, and outside training, including Continuing Professional
                    Education (CPE), Continuing Legal Education (CLE) and/or Continuing
  TR 7.06           Legal Education (CLE) credits.
  TR 7.07           Tracking of hours and type of training by certification.
               The tracking and reporting upon completion of a lesson, class, course,
  TR   8.00    program or outside training for the following:
  TR   8.01         Skills
  TR   8.02         Certifications
  TR   8.03         Licenses
  TR   8.04         Continuing Professional Education (CPE)
  TR   8.05         Continuing Education Units (CEU)
  TR   8.06         Continuing Legal
               System should support flexible approval routing/workflow for all system
  TR 9.00      events.
               This component should be integrated/interfaced with other components of the
  TR   10.00   system, including:
  TR   10.01        Personnel Administration
  TR   10.02        Accounts Payable
  TR   10.03        Position Control
  TR   10.04        General Ledger
  TR   10.05        Budget Development
  TR   10.06        Travel
               System should provide the capability to interface with outside vendors (ex:
  TR 11.00     ALVA, New Horizons and Athena)
               System should be integrated with the employee performance evaluations
  TR 12.00     within the Personnel Administration component
               System must be 5.08 compliant (ADA and SCORM (Sharable Content Object
  TR 13.00     Reference Model)
               The system should provide the capability to track and report direct costs for
               training including costs for training instructor(s) (whether staff time or
  TR   14.00   contractor-provided), venue cost, travel expenses, materials, etc. by:
  TR   14.01       Individual
  TR   14.02       Course
  TR   14.03       Chart of Accounts

   RFP Attachment 6.8                                    Training and Employee Development Requirements                                             TR2
   State of Tennessee                                                                                                                     RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                              Hours to
   Number                                   System Requirements                                  Response                   Comments                   Modify
  TR 14.04         User defined time periods
               The system should provide the capability to track and report indirect costs for
               training including employee time by classification, hourly cost linked to a
  TR   15.00   salary table, etc. by:
  TR   15.01       Individual
  TR   15.02       Course
  TR   15.03       Chart of Accounts
  TR   15.04       User defined time periods
               The system should track budgeted vs. actual expenses related to the training
  TR 16.00     class/course/program.
               System will provide the ability to reference travel authorization associated
  TR 17.00     with training.
               The system should provide the capability to book conference rooms directly
  TR 18.00     or through on-line links to facilities management programs.
  TR 19.00     System will send notification regarding conference room conflicts.
  TR 20.00     System will send notification regarding conference room overrides.
               The system should provide the capability to track and report budget and
               statistical information such as fund, revenue source, no. of persons per
               workshop, date of workshop, priority rating, training date, justification
  TR 21.00     statements, organization, program, etc.
               The system should provide on-line inquiry screens that displays training data
  TR 22.00     including but not limited to budget and financial information.
               The system should provide on-line approval of training budget requests
  TR 23.00     based on varying levels of security as defined by the agency.
               The system should provide on-line approval of training requests based on
  TR 24.00     varying levels of security as defined by the agency.

               The system should provide the capability to summarize varying levels of chart
  TR 25.00     of account codes such as organization, expenditure, and fund levels, etc.
  TR 26.00     The system should provide the capability to generate ad-hoc reports.

               The system should provide user defined security features including ability to
  TR 27.00     control access and update capabilities based on any data element values.
               The system should provide user defined security features including ability to
  TR 28.00     control access and update capabilities based on screen.

   RFP Attachment 6.8                                      Training and Employee Development Requirements                                             TR3
   State of Tennessee                                                                                                                      RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                              Hours to
   Number                                    System Requirements                                  Response                   Comments                   Modify
  TR 29.00     The system should produce notification conflicts of training schedules.
               The system should produce a Training Evaluation email and generate to
  TR 30.00     attendees by class and:

                  Upon completion, Training Evaluation email will be routed back to DOP
  TR 30.01     and Training Session Coordinator summarized by course, class, etc.
               The system shall comply with the minimum standards for the following
  TR   31.00   organizations:
  TR   31.01      CALEA (Commission Accreditation of Law Enforcement
  TR   31.02      OSHA (Occupational Safety and Health Administration)
  TR   31.03      TOSHA (Tennessee Occupational Safety & Health Administration)
  TR   31.04      POST (Police Officer Standard Training)
  TR   31.05      AICPA (American Institute of Certified Public Accountants)
  TR   31.06      Property Assessors organization.
               The system should track type of training taken such as web based,
  TR 32.00     classroom, lecture, self-study, etc.
               System should include archiving capabilities for retrieval information of
  TR 33.00     separated employees.
               System should include archiving capabilities for retrieval information of active
  TR 34.00     employees.
                                         Training and Development
               The system tracks classes and courses needed for career / job progression
  TR 35.00     planning and for required prerequisites for employees.
               The system should allow for the recording of prerequisites for courses (other
  TR 36.00     courses, entry exams, certifications, licenses, etc.).
               The system should monitor prerequisites by employee when enrollment in
               classes takes place and prohibit (with override capability) enrollment if
  TR 37.00     prerequisites are not satisfied.
               The system should provide the ability to produce a course catalog and
  TR 38.00     schedule of training sessions.
               The system will provide the capability for employees to be able to view and
  TR 39.00     search the course catalog and the schedule of training sessions.
               They system should have the ability for employees to use and enroll in
  TR 40.00     statewide training without affecting security limits in other HR modules.


   RFP Attachment 6.8                                      Training and Employee Development Requirements                                              TR4
   State of Tennessee                                                                                                                     RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                  10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                    N = Cannot Meet Requirement
M = Modification Required                                                                                   Q = Custom Report/Query

  Reference                                                                                       Vendor                                              Hours to
   Number                                   System Requirements                                  Response                   Comments                   Modify
               The system will provide the capability of tracking which lessons, classes,
  TR   41.00   courses, programs, and outside training are mandatory.
  TR   42.00   Each Mandatory Training entry must include:
  TR   42.01      General Lesson
  TR   42.02      Class
  TR   42.03      Course
  TR   42.04      Training session information
  TR   42.05       Frequency
  TR   42.06       Reason for being mandated
  TR   42.07       Mandating Agency / Organization.
               The system should provide the capability to allow mandatory training to be
               displayed and updated when any individual lesson, class, course, program, or
  TR 43.00     outside training is created and/or updated.

  TR 44.00     System reports scheduled training sessions and anticipated attendance list.
               The system calculates the number of training sessions required to train
               various populations according to flexible criteria. The results would be
               available for the training coordinators' use for flexible scheduling and
  TR 45.00     enrollment.
               The system will provide the capability for any lesson, class, course, or
               program to be scheduled as a training session. The training session inherits
               information as appropriate from the referenced lesson, class, course, or
  TR 46.00     program. Regardless, if course has CEU credits or not.
               The system creates a training session outline that lists all the lessons,
  TR 47.00     classes, courses, and programs associated with the training session.

               The system flexibly allows groups of employees to be associated with a staff
  TR 48.00     development training coordinator for their functional development needs.
               The system allows for designation of a logistical training coordinator to be
  TR 49.00     associated with specific training sessions.
               The system allows for designation of a subject matter training coordinator to
  TR 50.00     be associated with a set of lessons / classes / courses / programs.
               The system notifies all appropriate training coordinators of a planned training
  TR 51.00     session.


   RFP Attachment 6.8                                      Training and Employee Development Requirements                                             TR5
   State of Tennessee                                                                                                                    RFP # 317.03-134
   Project Edison
                                                FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                   N = Cannot Meet Requirement
M = Modification Required                                                                                  Q = Custom Report/Query

  Reference                                                                                      Vendor                                              Hours to
   Number                                  System Requirements                                  Response                   Comments                   Modify
              The system will provide the training coordinator to be able to enroll
  TR 52.00    employees in a specific training session.
              The system creates a wait list when training session maximum enrollment is
  TR 53.00    reached.
              The system lists replacements for the training session roster based on the
              most deficient employee, or the position of the employee in the wait list
  TR 54.00    queue.
              The system creates the appropriate roster for the training session in a
  TR 55.00    predefined modifiable format.
              The system notifies enrollees and their supervisor via email / paper / TTY
  TR 56.00    when enrolled in, or wait listed for, a training session.
                 The email may be sent from either the employee's regular training
  TR 56.01       coordinator and/or the training session coordinator.

  TR 56.02        Of these two, one is the sender and the other receives a copy of the email
              The enrollees' email also contains a link to a web page for the enrollee to
  TR 57.00    perform various activities such as:
                      Cancel attendance - generates an email via workflow to the
                      employee's training coordinator, the training session coordinator, and
  TR 57.01            the employee's supervisor
                      Ask a question about the training session - generates an email to the
  TR 57.02            training session coordinator
                      Ask a question of their training coordinator - generates an email via
  TR 57.03            workflow.
              The system records attendance of an attendee at a training session (lesson,
  TR 58.00    class, course, program, or outside training) in hours.
              The system tracks attendance of a lesson, class, course, or outside training
              based upon attendance of a training session inclusive of that lesson, class, or
  TR 59.00    course.
              The system tracks the grade or score achieved (user defined - pass/fail, %
              score, grade, complete/incomplete, etc.) by an attendee for a lesson, class,
              course, or outside training based upon grade achieved at a training session
  TR 60.00    inclusive of that lesson, class, course, or outside training.
              The system updates training session roster based on actual attendance at
  TR 61.00    the completion of the training.

   RFP Attachment 6.8                                    Training and Employee Development Requirements                                              TR6
   State of Tennessee                                                                                                                       RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                    10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                              Hours to
   Number                                    System Requirements                                   Response                   Comments                   Modify
               The system will automatically update skills / certifications / licenses of
               attendees who have met the course completion (time) and grade
  TR 62.00     requirements.
               System should support identification of employees and contractors via
               'swiping' of badges for appropriate situations such as recording attendance
               at a training session, signing into the rifle range for ammunition allowance,
  TR 63.00     etc.
               The system notifies the employee's training coordinator and supervisor if
               actual attendance hours don't match the planned attendance hours (if
               employee missed part of the training session). The level of missed class time
  TR 64.00     allowable may be set by the user.
               The system will generate at least the following notification letters (paper
  TR   65.00   and/or email):
  TR   65.01        Wait list notification to employee with copy to manager
  TR   65.02        Closed class notification to employee with copy to manager
  TR   65.03        Confirmation of class notification to employee with copy to manager
                    No-show and cancellation notifications to employee with copy to
  TR 65.04          manager.
               The system will generate customizable notification forms by user definable
               criteria (division for example) at a predefined period of time prior to the start
  TR 66.00     of the training session.
  TR 67.00     The system will generate labels for mass notification mailings.

               The system will provide the capability to record and report planned and actual
  TR 68.00     information based on user defined criteria, for each training session.
               The system, for each training session, will notify instructors and enrollees
  TR   69.00   (email / paper / TTY) of:
  TR   69.01       Location
  TR   69.02       Logistical requirements
  TR   69.03       Supplies needed
  TR   69.04       Prework
  TR   69.05       Time Zone and Date.
               System should provide the ability for multiple levels to authorize training
  TR 70.00     requests (Automate In-Service/Out-Service Nomination Form).


   RFP Attachment 6.8                                       Training and Employee Development Requirements                                              TR7
   State of Tennessee                                                                                                                      RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                   10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                     N = Cannot Meet Requirement
M = Modification Required                                                                                    Q = Custom Report/Query

  Reference                                                                                        Vendor                                              Hours to
   Number                                   System Requirements                                   Response                   Comments                   Modify
              System should provide the ability for employees to request training using a
              standard Web based browser (Automate In-Service/Out-Service Nomination
  TR 71.00    Form in sequential numbers).
              System should provide the ability for employees to request travel
  TR 72.00    authorization linked to an approved or requested training request.
              System should provide the ability for employees to request a travel advance
  TR 73.00    linked to an approved training request and travel authorization.
              System should track training for specific job classification (multiple text
  TR 74.00    entries) for applicants.
              System should track training qualifications for specific job classification
  TR 75.00    (multiple text entries), for applicants.
  TR 76.00    The system will track the following information on instructors:
                  Instruction certification by which lessons, classes, courses, or programs
  TR 76.01
                   Which classes, courses and training sessions they instruct, even if the
                   State does not offer that training. For example, instructing a class for the
  TR 76.02         FBI.
  TR 76.03         Location
  TR 76.04         Contact Information
              The system should provide for easy and flexible interfacing with State
  TR 77.00    institutions such as community colleges and State Universities for:
  TR 77.01         Attendance (including credit hours certifications, grades, etc.)
  TR 77.02         Billing.
              The system should support non-agency and non-State attendees with
  TR 78.00    functionality including:
  TR 78.01         Enrollment (with or without a Social Security number)
  TR 78.02         Attendance tracking (by person).
                   Identification of the outside attendee's training coordinator (name and
  TR 78.03         contact information).
                   Billing (flexible rules according to class, course, offering agency,
  TR 78.04         attending agency/organization, etc.).
                   Billing (flexible rules according to class, course, offering agency,
  TR 78.05         attending agency/organization including outside vendors, etc.).
                   Limitation of number of training session slots available to outside
  TR 78.06         agencies / organizations.

   RFP Attachment 6.8                                      Training and Employee Development Requirements                                              TR8
   State of Tennessee                                                                                                                        RFP # 317.03-134
   Project Edison
                                                   FUNCTIONAL REQUIREMENTS MATRIX                                                                    10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                       N = Cannot Meet Requirement
M = Modification Required                                                                                      Q = Custom Report/Query

  Reference                                                                                          Vendor                                              Hours to
   Number                                    System Requirements                                    Response                   Comments                   Modify

                  Prioritization of training session slots by outside agency / organization.
  TR 78.07
                  Automatic increase of (or reminder to training session coordinator to
                  increase) number slots available for outside agencies / organizations at a
                  predetermined time period prior to the start of the training session.
  TR 78.08
               The system will track the attendance of the employee and record the
  TR 79.00     completion on employee's personnel record.
               System will provide statewide security for training activities only but also allow
  TR 80.00     security at agency level in HR & Financial Modules.
               The system should provide user defined security features including ability to
               control access and update capabilities based on screen. Access security will
               be defined at the activity level. Access to the system will be provided at
  TR 81.00     several levels.
                                   Training and Tuition Reimbursement
               The system should support the Tuition Reimbursement program including:
  TR   82.00
  TR   82.01       Courses enrolled in / completed
  TR   82.02       Units enrolled in / completed
  TR   82.03       Total cost of educational program
  TR   82.04       Summary and detailed reports.
               System should allow the employee to be able to request tuition
               reimbursement via Employee Self Service and track the status of the request
  TR 83.00     and payment.
               The system should support the Training Reimbursement program including:
  TR   84.00
  TR   84.01       Courses enrolled in / completed
  TR   84.02       Units enrolled in / completed
  TR   84.03       Total cost of educational program
  TR   84.04       Summary and detailed reports.
               The system should track situations where employee is required to maintain
               employment for a certain period of time after the completion of training and
               notify designated personnel when employee terminates prior to the time
  TR 85.00     period.
                                            Query Requirements

   RFP Attachment 6.8                                       Training and Employee Development Requirements                                               TR9
   State of Tennessee                                                                                                                       RFP # 317.03-134
   Project Edison
                                                  FUNCTIONAL REQUIREMENTS MATRIX                                                                    10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                      N = Cannot Meet Requirement
M = Modification Required                                                                                     Q = Custom Report/Query

  Reference                                                                                         Vendor                                              Hours to
   Number                                    System Requirements                                   Response                   Comments                   Modify
               System allows employees to query the database to find all classes, courses,
  TR   86.00   programs, and outside training including:
  TR   86.01       Employee classes, with test scores and dates
  TR   86.02       Classes in which employee is enrolled
  TR   86.03       That teach / impart a specific skill or certification
                   Needed for career / job / level of certification progression (classes and
  TR 86.04         courses to address a skills / certification gap).
               System allows flexible queries that allows the analysis of lesson, class,
  TR   87.00   course, program and outside training information including:
  TR   87.01       Offerings (training sessions)
  TR   87.02       Attendance
  TR   87.03       Costs
  TR   87.04       Over periods of time.
               System allows flexible queries that allows the analysis of training, license, and
  TR   88.00   certification gaps.
  TR   89.00   System allows queries by:
  TR   89.01      Course code
  TR   89.02      Agency.
                                           Reporting Requirements
               System produces detailed and summary ad-hoc and regularly scheduled
  TR 90.00     reports utilizing user defined criteria.

  TR 91.00     System provides a report for employees training categorized by job function.
                             Certification with Related Continuing Education
  TR 92.00     The system must provide a central list of all designations/certifications.
               The system must allow a variable number of requirements to be entered per
  TR 93.00     designation/certification.
  TR 94.00     The system must have an indicator showing the employee’s current level.
               The system must have the ability to show that an employee has received a
  TR 95.00     specific designation/certification.
               The system must have the ability to show the employee’s progress toward
  TR 96.00     obtaining designation/certification.
               The system must have the ability to show what classes are required to reach
  TR 97.00     a designation/certification or level.


   RFP Attachment 6.8                                       Training and Employee Development Requirements                                             TR10
   State of Tennessee                                                                                                                   RFP # 317.03-134
   Project Edison
                                                 FUNCTIONAL REQUIREMENTS MATRIX                                                                 10/21/05


Vendor Response Codes:
Y = Standard Function ("Out-of-the-Box")                                                                  N = Cannot Meet Requirement
M = Modification Required                                                                                 Q = Custom Report/Query

  Reference                                                                                     Vendor                                              Hours to
   Number                                  System Requirements                                 Response                   Comments                   Modify
            The system must have the ability to show required period of experience for a
  TR 98.00  designation.
            The system must have the ability to show what tests are required for a
  TR 99.00 designation or level.
            The system must have an indicator as to whether the designation is state,
  TR 100.00 federal or organizational. If organizational, which organization?
            The system must have the ability to indicate if the person is current on their
  TR 101.00 dues through ESS.
  TR 102.00 The system must have a delinquent dues indicator.

  TR 103.00 The system should have a date field for the date on which dues are payable.
            The system must show the number of continuous education hours required
  TR 104.00 for a level or designation.

            The system should be able to calibrate cycle from January 1 of certification
  TR 105.00 year through a variable year cycle dependent upon certification.
  TR 106.00 The system must contain a Recertification Needed in current year flags.

            The system must allow a person to be designated as a State employee,
  TR 107.00 county staff member, or private industry employee.
            The training information stored in the system should include a designator for
  TR 108.00 indication that the training counts toward recertification.
            The training information stored in the system should include a field stating the
  TR 109.00 number of hours that the training counts toward recertification.
            The system should provide the ability to change the thresholds per
  TR 110.00 certification requirements with effective dates.




   RFP Attachment 6.8                                    Training and Employee Development Requirements                                            TR11

				
DOCUMENT INFO
Description: Eligibility Requirements for Medicare document sample