DAS-HRIS-Tech-Req

Document Sample
DAS-HRIS-Tech-Req Powered By Docstoc
					          State of Oregon
Department of Administrative Services

Human Resource Information System Project




      Enterprise HR Technical
           Requirements


     Pre-Implementation Consulting Services
   Requirements Definition and Planning Phase


               January 2009
DAS HRIS Technical Requirements - Introduction


Introduction
This section provides an overview of the State of Oregon Human Resource Information System (HRIS) project. It
also explains the purpose and organization of the Technical Requirements deliverable, describes assumptions
related to the requirements and the team’s approach for gathering and validating the functional requirements.

Project Background
The Oregon Department of Administrative Services (DAS) has been mandated to provide excellent service to its
employees, the executive and legislative branch, and the citizens of Oregon. In terms of human resource
management, DAS is currently hindered in meeting this business objective by outdated and inflexible HRIS
technology.
The existing HR applications, the Position Personal Database (PPDB) and the Position Information Control System
(PICS) currently lack the needed functionality and flexibility to fully implement this vision. Due to age and the
number of changes that have been made over the years, these applications are increasingly difficult to operate and
maintain.
These issues include:
 - Increased risk of identity theft as result of sensitive information in disparate systems
 - Increased difficulty in complying with federal and state laws, regulations, and mandates.
 - Vulnerability in terms of system sustainability as employees who maintain these systems leave state service.
 - High total cost of ownership of HR data due to many agency shadow systems.
 - Expanding data needs that stretch beyond the capabilities of PPDB and PICS, with the addition of new data
elements to PPDB or PICS both costly and time consuming.
 - Non-standard and inefficient (manual or semi-manual) HR processes.
 - Lack of available information for effective and timely management decision making.
 - Multiple non-integrated systems, which make reporting burdensome.
 - DAS and agency HR staff are often focused on employee maintenance activities, not HR decision support.
In response to these issues, the DAS Human Resource Service Division (HRSD) has initiated a project to implement
a new commercial-off-the-shelf (COTS) statewide Human Resource Information System (HRIS). The new HRIS will
enable DAS to provide more effective processing and management of the state’s human resource information. The
proposed HRIS will be able to expand on the capabilities of the current PPDB and PICS applications by supplying
additional information, functionality, and processes required by individual agencies to meet the requirements of their
increasingly complex business environments.
The HRIS will enable HRSD to provide improved customer service through the use of standardized, on demand
reporting; electronic workflow; updated human resource business rules and support for additional business
processes requested by agency human resources managers and staff. The proposed HRIS will also provide for a
reduction in the number of redundant, shadow agency level human resource systems.
DAS HRSD may work in partnership with other agencies (to be determined) to identify and implement a single HRIS
software application to address DAS and other agency enterprise human resource requirements.
DAS is currently in the Pre-Implementation and Planning phase for the purchase of the new HRIS/ERP. This phase
includes analyzing existing as-is HR processes; defining could-be business processes; defining functional and
technical requirements for the new HRIS/ERP; establishing a proposed implementation strategy and timeline; and
preparing a business case for the proposed new HRIS/ERP. Dye Management Group, Inc. has been engaged by
DAS to assist with these pre-implementation planning activities.




bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                Page 2 of 28
DAS HRIS Technical Requirements - Introduction

Document Purpose
The purpose of this document is to provide DAS with the detailed technical requirements to support the new
enterprise HR system. These are ‘could-be’ HRIS technical requirements, and are written to conform to the
requirements of a commercially available HRIS/ERP software application.
The requirements detailed in this document will provide a starting point and framework for review by DAS HRIS
project team members, the State Data Center (SDC), and possibly other agency stakeholders, such as the ODOT
ERP team. The review will be iterative, with DAS HRIS project team members conducting the initial analysis and
revision. It is expected that this review will result in the elimination of some of the requirements and the addition of
others. Following the DAS HRIS project team review, the State Data Center will be invited to review these revised
requirements and provide their feedback. It is expected that this review will result in requirements that more closely
conform to SDC standards and practices.
Requirements validation and review will be completed in the following steps:
 - The core HRIS project team will review and modify in a working session with Dye Management Group, Inc.
 - The core HRIS project team will distribute the document to the SDC resources for review and validation.
 - The core HRIS team will meet in person with SDC resources to verify and validate the requirements.
 - Dye Management Group, Inc. will finalize the documentation based on feedback provided by the DAS core HRIS
team and the SDC resources.
 - Provide prospective HRIS/ERP vendors a detailed list of requirements the State of Oregon believes are necessary
to fulfill its HR mandate and to conform to State Data Center standards and practices. In order for a vendor to
participate in later vendor selection rounds, they will first have to complete the requirements document and indicate
whether their product can meet the State’s needs. Vendor responses to each of the requirements can be later used
when the project team completes the Requirements Traceability Matrix.
The technical requirements were developed by Dye Management Group, Inc. using a variety of sources. The
requirements are presented to the State using two different methods:
 - A Word document for contract delivery purposes.

 - An Excel spreadsheet for requirements development, review, and presentation purposes. This is the document
that will become the working document. It is hoped that providing the requirements in this format will help facilitate
the reusability of the requirements in a manner of the State’s discretion. This document can be used for a later
Request for Information (RFI) or a Request for Proposal (RFP) from the prospective software vendors.

Requirements Source, Approach and Assumptions
This section briefly describes the sources of requirements, the approach for validating these requirements and other
working assumptions.

Source of Information
The technical requirements were distilled from multiple sources, including:
- Requirements from other state HRIS projects.
- Requirements from county, city and other public sector HRIS projects.
- Requirements from DMG consultants.
- Requirements indicated by DAS project team members.
- Requirements indicated by the State Data Center (SDC).




bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                   Page 3 of 28
DAS HRIS Technical Requirements - Introduction

Approach
The approach used for documenting this first set of technical requirements is one of inclusion, rather than exclusion.
There may be more requirements included in the first draft than are probably necessary to support the new
enterprise HR system.

Specific State terminology has been used whenever possible. However, a detailed review of each requirement will
provide more specific and appropriate terminology such as specific SDC terms and standards, specific DAS
requirement wording, and the technical terminology for State hardware, software, and infrastructure.
Requirements for functionality which is currently viewed as out of scope have been included but may be eliminated
at the discretion of DAS. These requirements include the technical requirements to support an enterprise ERP,
including financial and supply-chain applications.
Dye Management Group provided an initial assessment of whether a requirement should be considered Mandatory
(M), or Desirable (D). It is expected that the state will re-set requirement priorities, however the initial prioritization is
based on:
 - Understanding the relationship between PPDB and PICS and a COTS HRIS.
 - Experience in developing requirements for other state governments.
 - Stated project scope. If the requirement is aimed at functionality which is beyond the scope of replacing PPDB
and PICS, the requirements is generally indicated as Desirable (D).
 - Where a requirement is indicated as being Mandatory (M) the Priority Level of the requirement is Required (R). If
the requirement is indicated as being Desirable (D), then no Priority Level is assigned. The Priority Level will be
assigned in requirements review with the SDC.

Assumptions
This is the first set of requirements delivered to the State. It is assumed that as a result of a rigorous review
process:
 - Some requirements will be eliminated.
 - Additional requirements may be added.
 - Some of the requirements will be modified or re-worded to more closely represent the State’s needs.




bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                        Page 4 of 28
    DAS HRIS Technical Requirements - Functional Descriptions

Enterprise HR Technical Requirements
All technical requirements are presented in one technical requirements document. Each of the above is presented as
a sub-category in the document. Following the technical requirements description, all of the detailed technical
requirements are listed. These requirements were pulled from the requirements Excel spreadsheet, and do not
include all the columns found in the spreadsheet. Information that the vendor is expected to provide (i.e., requirement
met?, customization required?, etc.) will not be presented in this document because these columns will not be
completed until a vendor is selected and therefore there is no information to include at this time.

Enterprise HR Technical Requirements Summary
The requirements listed in this section focus on the environment that supports the HRIS/ERP system and its users.
The State has developed hardware, software, infrastructure, and security standards as part of its overall IT strategy. It
is expected that the HRIS/ERP vendor will be able to accommodate many of these standards with its software.
However, the State also recognizes that implementing an HR system will require the State to evaluate its standards
and make adjustments where necessary. It is also understood that the State may have to supplement its current
technical environment with additional supporting hardware and software in order to fully utilize the new system.

 Technical requirements were developed to address the following key areas. Each item is a link which will jump to the
requiremenst spreadsheet in this workbook.
 - Integration and system architecture
 - ADA compliance
 - System and user security
 - Data entry and data entry auditing
 - Hardware and database
 - Application development support and development tools
 - System processing and performance
 - Networking and internet and intranet support
 - Workflow and workflow integration and security
 - Reporting tools and protocols

INTEGRATION and ARCHITECTURE
Integration and Architecture requirements address the need for the solution to include toolsets to manage and support
security administration, compliance management, end user interface design, data archiving, data purging, data
recovery and toolsets to help re-start, reject, or recycle transactions.
Link to Integration and Architecture Requirements

ADA COMPLIANCE
This section addresses the ADA requirements which are mandatory for recruitment and any other application soliciting
information from the public at large.
Link to ADA Requirements

SYSTEM AND USER SECURITY
This section captures requirements related to user, application and database security.
Link to Security Requirements

DATA ENTRY AND DATA ENTRY AUDITING
This section provides detailed requirements for managing data entry and auditing.
Link to Data Entry and Auditing Requirements




    bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                  Page 5 of 28
    DAS HRIS Technical Requirements - Functional Descriptions

HARDWARE & DATABASE
This section provides the requirements related to data purging, archival, and recovery; as well as input devices for
sourcing data.
Link to Hardware and Database Requirements

APPLICATION DEVELOPMENT SUPPORT AND DEVELOPMENT TOOLS
This section specifies the requirements for error message handling, development tools and technical documentation
and knowledge transfer.
Link to App Development and Support Tools Requirements

SYSTEM PROCESSING AND PERFORMANCE
This section addresses the requirements for indexing and processing multiple processes simultaneously or in specified
sequence.
Link to System Performance Requirements

NETWORKING, INTERNET, AND INTRANET SUPPORT REQUIREMENTS
This section addresses the requirements for network protocols.
Link to Networking and Internet Support Requirements

WORKFLOW AND WORKFLOW INTEGRATION
This section addresses requirements for workflow integration and processing.
Link to Workflow Requirements

REPORTING TOOLS
This section specifies the requirements for job scheduling and report processing tools.
Link to Reporting Tools Requirements




    bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                  Page 6 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                            To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                    BPR Change
                                                                                                                                                                   Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                     Req #   Functional Requirements                                                                    Comments                                    Recommended?
                                                                                                                                                                  Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                       (Y/N)
                                                            Application is 100% Web-enabled, i.e., all functions can be accessed via a web
APP       TECH      ARCHITECTURE                   1.00                                                                                                                 M         H
                                                            browser.
APP       TECH      ARCHITECTURE                   2.00     Content is delivered via browser without plug-in support (e.g., JRE, Flash)                                 M         H
                                                            Provides a consistent user interface across all components, including Consistent
APP       TECH      ARCHITECTURE                   3.00                                                                                                                 M         H
                                                            function keys and Consistent Navigation patterns
                                                            Solution is not dependent on use of specific DBMS.Preference for solution with DBMS
SDC       TECH      ARCHITECTURE                   4.00     currently supported by the State as indicated in Oregon State Data Center                                   M         H
                                                            Requirements and Standards, as well as a wide customer install base.
                                                            Solution is not dependent on use of specific operating systems. Preference for
SDC       TECH      ARCHITECTURE                   5.00     solution with operating system(s) currently supported by the State as detailed in                           M         H
                                                            Oregon State Data Center Requirements and Standards
                                                            Solution is not dependent on use of specific middle tier platform. Preference for
SDC       TECH      ARCHITECTURE                   6.00     solution with middle tier currently supported by the State as detailed in Oregon State                      M         H
                                                            Data Center Requirements and Standards
                                                            solution architecture is multi-tiered, with independent scalability and manageability by
SDC       TECH      ARCHITECTURE                   7.00     tier. e.g. n-tier architecture; can bring down or scale an individual web or app server                     M         H
                                                            without impacting the overall solution operation

SDC       TECH      ARCHITECTURE                   8.00     solution architecture supports high system availability with business continuity.                           M         H

                                                            Solution architecture supports rapid failover or redeployment in the event of planned
SDC       TECH      ARCHITECTURE                   9.00                                                                                                                 M         H
                                                            or unplanned interruptions.
                                                            User interface for all application and infrastructure configuration and maintenance
APP       TECH      ARCHITECTURE                   10.00                                                                                                                M         H
                                                            functionality must be available via web.
                                                            Configuration must be data/table-driven with administrative screens/pages to update
APP       TECH      ARCHITECTURE                   11.00                                                                                                                M         H
                                                            parameters.
                                                            Effective dates are used for transactions, including support for future dated entry and
APP       TECH      INTEGRATION AND ARCHITECTURE   12.00                                                                                                                M         H
                                                            automatic processing of retroactive transactions

APP       TECH      INTEGRATION AND ARCHITECTURE   13.00    Solution provides integrated toolset(s) accommodating application maintenance                               M         H

                                                            System provides integrated toolset(s) accommodating report design, development,
APP       TECH      INTEGRATION AND ARCHITECTURE   14.00                                                                                                                M         H
                                                            generation, and distribution.
APP       TECH      INTEGRATION AND ARCHITECTURE   15.00    Solution provides integrated toolset(s) for Security administration                                         M         H
APP       TECH      INTEGRATION AND ARCHITECTURE   16.00    Solution provides integrated toolset(s) for Compliance management                                           M         H
APP       TECH      INTEGRATION AND ARCHITECTURE   17.00    Solution provides integrated toolset(s) for End-user interface design                                       M         H
APP       TECH      INTEGRATION AND ARCHITECTURE   18.00    Solution provides integrated toolset(s) for Archiving of data                                               M         H
APP       TECH      INTEGRATION AND ARCHITECTURE   19.00    Solution provides integrated toolset(s) for Purging of data                                                 M         H
APP       TECH      INTEGRATION AND ARCHITECTURE   20.00    Solution provides integrated toolset(s) for Recovery of data                                                M         H
                                                            Solution provides integrated toolset(s) for Re-start, recycle rejected or errored
APP       TECH      INTEGRATION AND ARCHITECTURE   21.00                                                                                                                M         H
                                                            adhoc/batch transactions
APP       TECH      INTEGRATION AND ARCHITECTURE   22.00    Public facing portals support multiple languages                                                            D
                                                            Ability to configure the logon screen with "branding" for state of Oregon (logo, color
APP       TECH      INTEGRATION AND ARCHITECTURE   23.00                                                                                                                M         H
                                                            schemes, and user warnings & messages)
APP       TECH      INTEGRATION AND ARCHITECTURE   24.00    Solution supports attachments of files to each transaction                                                  M         H




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                      Page 7 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                                                    To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                            BPR Change
                                                                                                                                                                                           Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                     Req #   Functional Requirements                                                                    Comments                                                            Recommended?
                                                                                                                                                                                          Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                               (Y/N)
                                                            Solution supports Attachments of files as database content, reference to file server or
APP       TECH      INTEGRATION AND ARCHITECTURE   25.00                                                                                                                                        M         H
                                                            files in a document Management system
                                                                                                                                                       Mandatory for recruitment and
                                                            Solution must be compliant with section 508 standards of the American with                 any other application soliciting
APP       TECH      ADA COMPLIANCE                 26.00                                                                                                                                        D
                                                            Disabilities Act (ADA)                                                                     information from the public at
                                                                                                                                                       large
                                                                                                                                                       Mandatory for recruitment and
                                                            Solution must provide toolsets to enable the state to be compliant with section 508        any other application soliciting
APP       TECH      ADA COMPLIANCE                 27.00                                                                                                                                        D
                                                            standards of the American with Disabilities Act (ADA)                                      information from the public at
                                                                                                                                                       large
                                                                                                                                                       Mandatory for recruitment and
                                                            Solution must provide tools and adhere to the Web Content Accessibility Guidelines         any other application soliciting
APP       TECH      ADA COMPLIANCE                 28.00                                                                                                                                        D
                                                            developed by the Web Accessibility Initiative of the W3c consortium                        information from the public at
                                                                                                                                                       large
                                                            Access at any level require users to authenticate consistent with existing State
APP       TECH      SECURITY                       29.00                                                                                                                                        M         H
                                                            security practices and single-sign infrastructure.

                                                            Solution provides ability to restrict all reporting and query functions with the same
APP       TECH      SECURITY                       30.00                                                                                                                                        M         H
                                                            security profiles and related data access limitations of the core application.

                                                            Solution must be flexible / configurable to accommodate enhanced security
APP       TECH      SECURITY                       31.00                                                                                                                                        M         H
                                                            requirements, such as two-factor authentication and/or digital signatures.

APP       TECH      SECURITY                       32.00    All suites/modules/applications can be accessed with one universal sign-in or log-in.                                               M         H

                                                            System has an associate's identity system (e.g., applicants, vendor self-service, other
APP       TECH      SECURITY                       33.00                                                                                                                                        M         H
                                                            agencies, volunteers, State contractors, etc.)
APP       TECH      SECURITY                       34.00    System has a public identity system (e.g., constituents, media, applicant, etc.)                                                    M         H
                                                            System has strong and documented boundaries between extranet, Internet and
APP       TECH      SECURITY                       35.00                                                                                                                                        M         H
                                                            internal system
                                                            Provides an identity management solution for internal (i.e. Intranet portal) users
APP       TECH      SECURITY                       36.00                                                                                                                                        M         H
                                                            (please describe how you can meet this requirement in the comment field)

                                                            Provides an identity management solution for external (i.e. Extranet portal) users
APP       TECH      SECURITY                       37.00                                                                                                                                        M         H
                                                            (please describe how you can meet this requirement in the comment field)

                                                            Provides an identity management solution for public portal users (please describe how
APP       TECH      SECURITY                       38.00                                                                                                                                        M         H
                                                            you can meet this requirement in the comment field)
                                                            The internal/intranet application or service must be enabled to run in a Single Sign On
                                                                                                                                                    DAS Team: Ask the vendor to
APP       TECH      SECURITY                       39.00    environment as implemented through: Tivoli Access Manager 6.x and/or Active                                                         M         H
                                                                                                                                                    please explain support for LDAP.
                                                            directory

APP       TECH      SECURITY                       40.00    Solution provides ability for administrator to restrict data access by Role or group                                                M         H

                                                            Solution provides ability for administrator to restrict data access by Person id or user
APP       TECH      SECURITY                       41.00                                                                                                                                        M         H
                                                            id
                                                            Solution provides ability for administrator to restrict data access by Person Type
APP       TECH      SECURITY                       42.00                                                                                                                                        M         H
                                                            (candidate versus employee versus contractor versus volunteer)



      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                              Page 8 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                            To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                    BPR Change
                                                                                                                                                                   Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                      Comments                                    Recommended?
                                                                                                                                                                  Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                       (Y/N)
APP       TECH      SECURITY                     43.00    Solution provides ability for administrator to restrict data access by IP address                             M         H
                                                          Solution provides ability for administrator to restrict data access by Screen/page field
APP       TECH      SECURITY                     44.00                                                                                                                  M         H
                                                          and menu and transaction type
APP       TECH      SECURITY                     45.00    Solution provides ability for administrator to restrict data access by Report                                 M         H

APP       TECH      SECURITY                     46.00    Solution provides ability for administrator to restrict data access by Database table                         M         H

                                                          Solution provides ability for administrator to restrict data access by Job function /
APP       TECH      SECURITY                     47.00                                                                                                                  M         H
                                                          position
                                                          Solution provides ability for administrator to define security profiles that restrict user
APP       TECH      SECURITY                     48.00                                                                                                                  M         H
                                                          ability to log on
                                                          Solution provides ability for administrator to define security profiles that restrict user
APP       TECH      SECURITY                     49.00                                                                                                                  M         H
                                                          ability to add/change/delete/update and view data.
                                                          Allows administrator to view or obtain security reports showing
APP       TECH      SECURITY                     50.00                                                                                                                  M         H
                                                          Authorized/Unauthorized system use
                                                          Generates warning message to notify administrator if multiple security profiles applied
APP       TECH      SECURITY                     51.00                                                                                                                  M         H
                                                          to a single user are conflicting.
APP       TECH      SECURITY                     52.00    Provides effective dates to security changes                                                                  M         H
APP       TECH      SECURITY                     53.00    Solution must allow encryption of all data transmitted via intranet and internet                              M         H
APP       TECH      SECURITY                     54.00    Provides the following password management functionality:                                                     M         H
                                                          Solution must provide for Password length to be a system administrator-defined
APP       TECH      SECURITY                     55.00                                                                                                                  M         H
                                                          number of positions
                                                          Solution must provide for Password aging as a system administrator defined
APP       TECH      SECURITY                     56.00                                                                                                                  M         H
                                                          maximum number of days
                                                          Solution must provide for Password lock-out after system administrator defined
APP       TECH      SECURITY                     57.00                                                                                                                  M         H
                                                          number of failed attempts

                                                          Solution must provide for System Administrator to be notified when the number of
APP       TECH      SECURITY                     58.00    failed attempts is exceeded. (The system must provide flexibility in configuration such                       M         H
                                                          that DAS can re-set the number of logon attempts if desired).

                                                          Solution must provide for Passwords to be reset/deleted by security and system
APP       TECH      SECURITY                     59.00                                                                                                                  M         H
                                                          administrators
                                                          Solution must provide for self service for Passwords to be changed by users if access
APP       TECH      SECURITY                     60.00                                                                                                                  M         H
                                                          password is correct.
                                                          Solution must provide for Passwords to be alphanumeric, numeric and/or
APP       TECH      SECURITY                     61.00                                                                                                                  M         H
                                                          alphanumeric characters as required by security administrator
APP       TECH      SECURITY                     62.00    Solution must provide for Passwords to be case sensitive if required                                          M         H

                                                          Solution must incorporates functionality from external identity management systems
APP       TECH      SECURITY                     63.00                                                                                                                  M         H
                                                          that allow user password re-sets with authentication (i.e., challenge questions)

APP       TECH      SECURITY                     64.00    Ensures transmittal of passwords using secure protocols/algorithms.                                           M         H
                                                          Defines User Access Groups based on job responsibilities to ensure separation of
APP       TECH      SECURITY                     65.00                                                                                                                  M         H
                                                          duties.
APP       TECH      SECURITY                     66.00    Disconnects or log out user session during designated periods of inactivity.                                  M         H




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                      Page 9 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                                                      To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                              BPR Change
                                                                                                                                                                                             Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                                               Recommended?
                                                                                                                                                                                            Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                                 (Y/N)
                                                                                                                                                      DAS Team: If the vendor
                                                                                                                                                      indicates that third party software
SDC       TECH      SECURITY                     67.00    Provides data encryption at rest or in transit                                                                                          M         H
                                                                                                                                                      is required, ask them to explain
                                                                                                                                                      the solution.
                                                          All password and security related configuration files are maintained in an encrypted
APP       TECH      SECURITY                     68.00                                                                                                                                            M         H
                                                          state.
APP       TECH      SECURITY                     69.00    Solution provides ability to encrypt stored data at the database-level.                                                                 M         H
APP       TECH      SECURITY                     70.00    Solution provides ability to administer security in a de-centralized manner.                                                            M         H
                                                          Solution provides ability to validate business logic (edit checks) for all data input
APP       TECH      SECURITY                     71.00                                                                                                                                            M         H
                                                          automatically.
                                                          Solution architecture isolates sessions such that a failure in one session does not
APP       TECH      SECURITY                     72.00                                                                                                                                            M         H
                                                          impact other sessions.
                                                          Solution automates the creation and deactivation of user accounts relative to
APP       TECH      SECURITY                     73.00                                                                                                                                            M         H
                                                          employment status.

                                                          Solution complies with RFC2109 Cookie Standards for storing encrypted data on a
APP       TECH      SECURITY                     74.00                                                                                                                                            M         H
                                                          device for reuse and set configurable expirations of data requiring a refresh.

APP       TECH      SECURITY                     75.00    Solution deactivates a user logon id after an administrator-defined period of inactivity.                                               M         H

                                                          Solution denies access to user after a specified number of failed logon attempts, with
APP       TECH      SECURITY                     76.00                                                                                                                                            M         H
                                                          explanation.
APP       TECH      SECURITY                     77.00    Solution does not use embedded logins and passwords.                                                                                    M         H
                                                          Solution provides ability for administrator to resume and/or revoke user accounts or
APP       TECH      SECURITY                     78.00                                                                                                                                            M         H
                                                          passwords.

APP       TECH      SECURITY                     79.00    Solution provides ability for administrator to define required password characteristics.                                                M         H

                                                          Provides security based on organization hierarchy level e.g.. Enterprise, Agency,
APP       TECH      SECURITY                     80.00                                                                                                                                            M         H
                                                          department, Division, Section, Unit, Union
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     81.00                                                                                                                                            M         H
                                                          profile by application module.
APP       TECH      SECURITY                     82.00    Solution provides ability to encrypt stored data at the database-level.                                                                 M         H
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     83.00                                                                                                                                            M         H
                                                          profile by application module.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     84.00                                                                                                                                            M         H
                                                          profile by application report.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     85.00                                                                                                                                            M         H
                                                          profile by application screen or page.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     86.00                                                                                                                                            M         H
                                                          profile by security role.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     87.00                                                                                                                                            M         H
                                                          profile by User ID.

APP       TECH      SECURITY                     88.00    Allows administrator to view or obtain security reports based on security profiles                                                      M         H

                                                          Solution provides security for e-commerce functions, including customer / Proposer
APP       TECH      SECURITY                     89.00                                                                                                                                            M         H
                                                          authentication and encryption to protect customer data.

      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                               Page 10 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                         To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                 BPR Change
                                                                                                                                                                Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                    Recommended?
                                                                                                                                                               Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                    (Y/N)
                                                          Solution must provide for the ability to secure transmission of attachments such as
APP       TECH      SECURITY                     90.00                                                                                                               M         H
                                                          résumés from external sources
                                                          The solution must include functionality to mask (or scramble) specific data elements
APP       TECH      SECURITY                     91.00    when being migrated from one environment to another. Example: masking salary or
                                                          SSN data when migrating from Production to the Sandbox.
                                                          The solution will have a built-in security function with can prevent an inbound patch
APP       TECH      SECURITY                     92.00                                                                                                               M
                                                          (hardening) from damaging existing database code.
APP       TECH      SECURITY                     93.00    The solution will include a way to monitor and track virus attacks.                                        M

APP       TECH      DATA ENTRY                   94.00    Allows complete validation and editing of data at the point of entry (on-line or batch)                    M         H

APP       TECH      DATA ENTRY                   95.00    Allows both online and batch entry of data.                                                                M         H
                                                          The system must allow to establish rules for each transaction type which determine
APP       TECH      DATA ENTRY                   96.00                                                                                                               M         H
                                                          whether data is Required, Optional or Not Allowed
                                                          The system must prevent transactions from posting until all "required" fields are
APP       TECH      DATA ENTRY                   97.00                                                                                                               M         H
                                                          completed and validated.
                                                          The system must highlight errors on the screen for immediate correction (online,
APP       TECH      DATA ENTRY                   98.00                                                                                                               M         H
                                                          immediate validity checks).
                                                          The system must allow line item descriptions up to 255 characters (Please list any
APP       TECH      DATA ENTRY                   99.00                                                                                                               M         H
                                                          limitations in the comments field).
APP       TECH      DATA ENTRY                   100.00   Allows mass changes or deletes by table-driven data through proper security.                               M         H
APP       TECH      DATA ENTRY                   101.00   Validates mass data entered in batch form.                                                                 M         H
APP       TECH      DATA ENTRY                   102.00   Validation rules for mass entries can be established                                                       M         H
APP       TECH      DATA ENTRY                   103.00   Invalid transactions from a mass upload are held in a suspend file                                         M         H
                                                          Rules are established for data precedence (e.g., accept this source file as opposed
APP       TECH      DATA ENTRY                   104.00                                                                                                              M         H
                                                          another source file)
                                                          Solution provides ability to store user preferences for menu, screen, column & field
APP       TECH      DATA ENTRY                   105.00                                                                                                              M
                                                          and default values
APP       TECH      DATA ENTRY                   106.00   Profiles are portable (e.g., not stored on a client but on the server)                                     M         H
APP       TECH      DATA ENTRY                   107.00   Data entry options available are based on security profiles                                                M         H
                                                          Solution must provide ability to mask sensitive data as required by law or deemed by
APP       TECH      DATA ENTRY                   108.00                                                                                                              M
                                                          the State such as TaxID, SSN, passwords
APP       TECH      DATA ENTRY                   109.00   The system must allow electronic authorization for transactions.                                           M         H
APP       TECH      DATA ENTRY                   110.00   The system must allow customized form creation with auto-fill.                                             D
APP       TECH      DATA ENTRY                   111.00   The system must allow colored fonts in forms and on viewable screens.                                      D
APP       TECH      DATA ENTRY                   112.00   The system must allow user the ability to increase font size                                               D
                                                          Solution supports ability to archive and retrieve application data, with controls for
APP       TECH      DATA ENTRY                   113.00                                                                                                              M         H
                                                          verifying referential integrity of data.
                                                          Solution application(s) pages support automatic population of data values where
APP       TECH      DATA ENTRY                   114.00                                                                                                              M         H
                                                          appropriate, relative to user data entry.

APP       TECH      DATA ENTRY                   115.00   Solution provides ability to define data edits by transaction type and input source.                       M         H




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                  Page 11 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                                                  To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                          BPR Change
                                                                                                                                                                                         Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                                           Recommended?
                                                                                                                                                                                        Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                             (Y/N)
                                                          Audit trails that provide a trace of user actions with Automated tools to review audit
                                                          trails - for users viewing and/or doing data updates from the back end. Audit file
APP       TECH      DATA AUDITING                116.00                                                                                                                                       M         H
                                                          secured so that higher level security is required to access the data. This is to ensure a
                                                          separation.
                                                          Solution must provide configurable auditing capability as required by an administrator
APP       TECH      DATA AUDITING                117.00                                                                                                                                       M         H
                                                          or business area
APP       TECH      DATA AUDITING                118.00   Configuration transactions are audited                                                                                              M         H
                                                          Solution must provide auditing of all workflow transaction s and electronic signatures
APP       TECH      DATA AUDITING                119.00                                                                                                                                       M         H
                                                          /Approvals
                                                          Solution provides ability for historical records of transactions, and these transaction
APP       TECH      DATA AUDITING                120.00   logs are stored in database tables. Data logged includes, but is not limited to, User                                               M         H
                                                          ID, before/after change data and date-timestamp.
APP       TECH      DATA AUDITING                121.00   Solution provides auditing inquiry and reporting capabilities.                                                                      M         H
                                                          Solution provides the ability to audit internet and intranet transactions. Data logged
APP       TECH      DATA AUDITING                122.00   includes, but is not limited to IP Address, Date and Time and historical transaction                                                M         H
                                                          records
APP       TECH      DATABASES                    123.00   HCM/ERP system is backward compatible for archived data                                                                             M         H
APP       TECH      DATABASES                    124.00   HCM/ERP system is forward compatible for archived data                                                                              M         H

APP       TECH      DATABASES                    125.00   Archives records upon request for records within a user-defined time and criteria.                                                  M         H

                                                          Configuration and data is preserved after system upgrade (as a disaster recovery
APP       TECH      DATABASES                    126.00                                                                                                                                       M         H
                                                          tool).
                                                          Configuration and data is preserved prior to a system upgrade (as a disaster recovery
APP       TECH      DATABASES                    127.00
                                                          tool).

APP       TECH      DATABASES                    128.00   Purges records upon request for records within a user-defined time and criteria.                                                    M         H

                                                          Recovers and restores records upon request for records within a user-defined time
APP       TECH      DATABASES                    129.00                                                                                                                                       M         H
                                                          and criteria.
APP       TECH      INPUT DEVICES                130.00   Solution must provide for document attachments from external sources                                                                D
APP       TECH      INPUT DEVICES                131.00   Supports gathering information from Scanner/digitizing device                                                                       D
                                                                                                                                                   DAS Team:
                                                          Solution provides flexibility and is not constrained in any manner to gather information Ask the software vendor to
APP       TECH      INPUT DEVICES                132.00   from a wide variety of sources such as but not limited to Bar Code, RFID, Wireless       please explain any restrictions or         M         H
                                                          devices, Keyboard, MICR, PDA's                                                           third party add-on's that would be
                                                                                                                                                   required.
                                                          Allows for separate, complete duplication of the software across the production
APP       TECH      DEVELOPMENT                  133.00                                                                                                                                       M         H
                                                          system and multiple development and test landscapes.
                                                          Solution must be compatible with common development platforms such as but not
APP       TECH      DEVELOPMENT                  134.00                                                                                                                                       M
                                                          limited to XML, Microsoft framework, .Net, java
APP       TECH      DEVELOPMENT                  135.00   Solution must provide Web services capability                                                                                       M         H

APP       TECH      DEVELOPMENT                  136.00   Solution must provide ability to create new objects such as tables, fields, screens                                                 M         H

APP       TECH      DEVELOPMENT                  137.00   Solution must provide ability to modify/change objects such tables, fields screens                                                  M         H



      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                           Page 12 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                               To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                       BPR Change
                                                                                                                                                                      Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                       Req #   Functional Requirements                                                                     Comments                                    Recommended?
                                                                                                                                                                     Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                          (Y/N)
APP       TECH      DEVELOPMENT                     138.00    Allows for identification/reporting of new user-defined objects                                              M         H

APP       TECH      DEVELOPMENT                     139.00    Solution must provide ability to includes new user-defined objects in upgrade path.                          M         H

                                                              Software should provide version control, to help insure that when code is moved from
APP       TECH      DEVELOPMENT                     140.00    one box to another; such as sandbox to test, and test to prod - that updated code can
                                                              be tracked and controlled.
                                                              Complete set of technical documentation: glossaries, diagrams, data dictionaries,
APP       TECH      DEVELOPMENT                     141.00                                                                                                                 M
                                                              restart manual/run books
                                                              Vendor will facilitate knowledge transfer sessions to ensure DAS support team is
APP       TECH      DEVELOPMENT                     142.00                                                                                                                 M
                                                              trained on the new database and application.
APP       TECH      DEVELOPMENT                     143.00    Solution provides toolset(s) for Data conversion                                                             M         H

                                                              Data transfers between systems utilize XML or DAS approved formats. For example,
APP       TECH      INTERFACES                      144.00                                                                                                                 M         H
                                                              public safety applications need to follow the Global Justice XML or HRXML.

                                                              Solution provides toolset(s) with ability to develop interfaces for internal and external
APP       TECH      INTERFACES                      145.00    systems using technology such as but not limited to web services, XML, SOAP,                                 M         H
                                                              REST, EDI.
APP       TECH      APPLICATION ERROR METHODOLOGIES 146.00    Error messages appear in a consistent format across all system modules.                                      M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 147.00    Error messages are integrated with on-line help function.                                                    M         H

APP       TECH      APPLICATION ERROR METHODOLOGIES 148.00    Help functions are associated with functional transaction at menu, screen ,field level                       M         H

                                                              Allows users to send system error reports (automatically or Administrator defined) to
APP       TECH      APPLICATION ERROR METHODOLOGIES 149.00                                                                                                                 M         H
                                                              software vendor.
APP       TECH      APPLICATION ERROR METHODOLOGIES 150.00    Allows Administrators to maintain a log of errors.                                                           M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 151.00    Utilizes automatic notifications of errors to user-defined stakeholders                                      M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 152.00    Automatic notifications support threshold arguments                                                          M         H

SDC & APP TECH      UPGRADE                         153.00    Provides upgrade path cycle clearly defined with no interruption to end-user availability                    M         H

APP       TECH      UPGRADE                         154.00    Solution provides integrated toolset(s) for System upgrade support and tools                                 M         H
                                                              Solution architecture supports separation of report server tier from the transaction
APP       TECH      PERFORMANCE                     155.00                                                                                                                 M         H
                                                              application server.
                                                              Provides ability to administer/control the priority of processes based on multiple
APP       TECH      PERFORMANCE                     156.00                                                                                                                 M         H
                                                              configurable criteria.
APP       TECH      NETWORKING                      157.00    The application uses IP based communications for its networking protocol                                     M         H
APP       TECH      EMAIL PROTOCOL                  158.00    Supports network E-mail Services using X.500 standards and LDAP protocols.                                   M         H
                                                              Solution is web-based and requires no installation on client workstations for
SDC       TECH      INTERNET ARCHITECTURE           159.00                                                                                                                 M         H
                                                              Client/Agents/Suppliers (self-service).
                                                              Content delivered via a web browser must be compliant with Microsoft Internet
APP       TECH      DESKTOP                         160.00                                                                                                                 M         H
                                                              Explorer (6.x and higher) - State Standard
                                                              Solution must be able to deliver content to Mobile devices such as Blackberry (State
APP       TECH      DESKTOP                         161.00                                                                                                                 M         H
                                                              Standard)
                                                              Internet content delivered via a web browser must be compliant with other popular web
APP       TECH      DESKTOP                         162.00    browsers such as Mozilla, Firefox, Safari, Netscape -- must support recent versions of                       M         H
                                                              industry standard browsers.



      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                        Page 13 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                         To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                 BPR Change
                                                                                                                                                                Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                    Recommended?
                                                                                                                                                               Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                    (Y/N)
APP       TECH      WORKFLOW                     163.00   Solution provides toolset(s) for Workflow design and management                                            M         H
APP       TECH      WORKFLOW                     164.00   Solution uses workflow to electronically route documents                                                   M         H
APP       TECH      WORKFLOW                     165.00   Solution must provide the ability for initiator to track approval process                                  M         H
APP       TECH      WORKFLOW                     166.00   Workflow works between all modules                                                                         M         H
                                                          Workflow can be configured to work with systems interfaced to the ERP application
APP       TECH      WORKFLOW                     167.00                                                                                                              M         H
                                                          (provide limitations in comments column or as an attachment)
                                                          Solution must provide for Workflow rules to be established based on User-defined
APP       TECH      WORKFLOW                     168.00                                                                                                              M         H
                                                          criteria (provide limitations in comments column or in attachment)
APP       TECH      WORKFLOW                     169.00   Workflow is compliant with BPMN standards                                                                  M         H
                                                          Workflow assignments can be re-routed to different authorized approvers based upon
APP       TECH      WORKFLOW                     170.00                                                                                                              M         H
                                                          availability
APP       TECH      WORKFLOW                     171.00   Workflow alerts can be integrated with Microsoft Exchange 2007                                             M         H
                                                          Solution architecture is integrated, designed and implemented on a workflow
APP       TECH      WORKFLOW                     172.00                                                                                                              M         H
                                                          architecture
                                                          Solution must provide for Workflow rules to be established based on Events, User,
APP       TECH      WORKFLOW                     173.00                                                                                                              M         H
                                                          Role, Percentage and numerical thresholds

APP       TECH      WORKFLOW                     174.00   Solution must provide Workflow rules to allow delegation of Workflow approval                              M         H

                                                          Solution must provide Workflow capability across all functional areas proposed in the
APP       TECH      WORKFLOW                     175.00                                                                                                              M         H
                                                          functional requirements
                                                          Solution includes job scheduling tools for reports, interfaces, batch programs etc.. or
                                                          integration with a third-party tool that allow users to sequence multiple jobs based on
SDC       TECH      JOB SCHEDULING               176.00   configurable rules. If third Party, preference for solution with Job Scheduling tools                      M         H
                                                          currently supported by the State as detailed in Oregon State Data Center
                                                          Requirements and Standards
SDC       TECH      JOB SCHEDULING               177.00   System notification must be provided on failed jobs                                                        M         H
APP       TECH      REPORTING                    178.00   Solution provides ability for report repository / library                                                  M         H
APP       TECH      REPORTING                    179.00   Reports must provide drill down capabilities                                                               M         H
APP       TECH      REPORTING                    180.00   Users can add and link tables in query tools or data warehouse functions                                   M         H
APP       TECH      REPORTING                    181.00   Provides end-users the ability to create & generate ad-hoc reports.                                        M         H
APP       TECH      REPORTING                    182.00   Allows ad-hoc report/query definitions to be saved.                                                        M         H
APP       TECH      REPORTING                    183.00   Allows end-users, with appropriate security, to modify report queries on-line.                             M         H
APP       TECH      REPORTING                    184.00   Allows users to save ad-hoc report results                                                                 M         H
                                                          Allows users to export the data to a spreadsheet application for manipulation and/or
APP       TECH      REPORTING                    185.00                                                                                                              M         H
                                                          reporting of data.
APP       TECH      REPORTING                    186.00   Allows for merged word processor reports to be edited and saved directly.                                  M         H
APP       TECH      REPORTING                    187.00   Allows users to report on any user-defined parameter values or ranges.                                     M         H
APP       TECH      REPORTING                    188.00   Reports can include end-user defined headings and borders.                                                 M         H
APP       TECH      REPORTING                    189.00   Filters reports based upon user-defined criteria.                                                          M         H
APP       TECH      REPORTING                    190.00   Allows user to create and print reports on special forms.                                                  M         H
                                                          Provides on-line real-time reporting and query capability with the ability to
APP       TECH      REPORTING                    191.00                                                                                                              M         H
                                                          reference a data dictionary.
                                                          Allows user to create reports that can suppress or print information based on user's
APP       TECH      REPORTING                    192.00                                                                                                              M         H
                                                          security


      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                  Page 14 of 28
      DAS HRIS Technical Requirements - All Requirements
Jump to Functional
                   Requirements Area                                                                                                                                         To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                 BPR Change
                                                                                                                                                                Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                    Recommended?
                                                                                                                                                               Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                    (Y/N)
APP       TECH      REPORTING                    193.00   Allows user to print reports to any printer (e.g. laser jets, networked copiers)                           M         H
                                                          Solution must provide end-user definition of criteria's such as but not limited to
APP       TECH      REPORTING                    194.00                                                                                                              M
                                                          wildcards, text searches
APP       TECH      REPORTING                    195.00   Solution must provide ability to distribute reports such as via links, email                               M         H
APP       TECH      REPORTING                    196.00   System produces dashboard data                                                                             M         H
APP       TECH      REPORTING                    197.00   Users can define dashboard reports                                                                         M         H
APP       TECH      REPORTING                    198.00   Provides for access to data via ODBC (through appropriate security).                                       M         H
                                                          Provides Administrator-defined limits on the time a report or query takes to execute
APP       TECH      REPORTING                    199.00                                                                                                              M         H
                                                          and the number of records to be retrieved.
                                                          Administrator defined limits are defined for other types of query functions such as but
APP       TECH      REPORTING                    200.00                                                                                                              M         H
                                                          not limited to number of table joins
                                                          Solution must provide for Report to be generated and published in various formats
APP       TECH      REPORTING                    201.00                                                                                                              M         H
                                                          such as but not limited to Screen, Printer, XML, PDF, word, excel




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                  Page 15 of 28
      DAS HRIS Technical Requirements - Architecture & Integration
Jump to Functional
                   Requirements Area                                                                                                                                                        To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                  BPR Change
                                                                                                                                                                               Mandatory /      Priority Level                  Vendor Demo Script
 Owner    Function SubFunction                       Req #   Functional Requirements                                                                               Comments                                      Recommended?
                                                                                                                                                                              Desirable (M/D)      (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                     (Y/N)

APP       TECH       ARCHITECTURE                   1.00     Application is 100% Web-enabled, i.e., all functions can be accessed via a web browser.                                M           H

APP       TECH       ARCHITECTURE                   2.00     Content is delivered via browser without plug-in support (e.g., JRE, Flash)                                            M           H
                                                             Provides a consistent user interface across all components, including Consistent function
APP       TECH       ARCHITECTURE                   3.00                                                                                                                            M           H
                                                             keys and Consistent Navigation patterns
                                                             Solution is not dependent on use of specific DBMS.Preference for solution with DBMS
SDC       TECH       ARCHITECTURE                   4.00     currently supported by the State as indicated in Oregon State Data Center Requirements and                             M           H
                                                             Standards, as well as a wide customer install base.
                                                             Solution is not dependent on use of specific operating systems. Preference for solution with
SDC       TECH       ARCHITECTURE                   5.00     operating system(s) currently supported by the State as detailed in Oregon State Data Center                           M           H
                                                             Requirements and Standards
                                                             Solution is not dependent on use of specific middle tier platform. Preference for solution with
SDC       TECH       ARCHITECTURE                   6.00     middle tier currently supported by the State as detailed in Oregon State Data Center                                   M           H
                                                             Requirements and Standards
                                                             solution architecture is multi-tiered, with independent scalability and manageability by tier. e.g.
SDC       TECH       ARCHITECTURE                   7.00     n-tier architecture; can bring down or scale an individual web or app server without impacting                         M           H
                                                             the overall solution operation
SDC       TECH       ARCHITECTURE                   8.00     solution architecture supports high system availability with business continuity.                                      M           H
                                                             Solution architecture supports rapid failover or redeployment in the event of planned or
SDC       TECH       ARCHITECTURE                   9.00                                                                                                                            M           H
                                                             unplanned interruptions.
                                                             User interface for all application and infrastructure configuration and maintenance
APP       TECH       ARCHITECTURE                   10.00                                                                                                                           M           H
                                                             functionality must be available via web.
                                                             Configuration must be data/table-driven with administrative screens/pages to update
APP       TECH       ARCHITECTURE                   11.00                                                                                                                           M           H
                                                             parameters.
                                                             Effective dates are used for transactions, including support for future dated entry and
APP       TECH       INTEGRATION AND ARCHITECTURE   12.00                                                                                                                           M           H
                                                             automatic processing of retroactive transactions
APP       TECH       INTEGRATION AND ARCHITECTURE   13.00    Solution provides integrated toolset(s) accommodating application maintenance                                          M           H
                                                             System provides integrated toolset(s) accommodating report design, development,
APP       TECH       INTEGRATION AND ARCHITECTURE   14.00                                                                                                                           M           H
                                                             generation, and distribution.
APP       TECH       INTEGRATION AND ARCHITECTURE   15.00    Solution provides integrated toolset(s) for Security administration                                                    M           H
APP       TECH       INTEGRATION AND ARCHITECTURE   16.00    Solution provides integrated toolset(s) for Compliance management                                                      M           H
APP       TECH       INTEGRATION AND ARCHITECTURE   17.00    Solution provides integrated toolset(s) for End-user interface design                                                  M           H
APP       TECH       INTEGRATION AND ARCHITECTURE   18.00    Solution provides integrated toolset(s) for Archiving of data                                                          M           H
APP       TECH       INTEGRATION AND ARCHITECTURE   19.00    Solution provides integrated toolset(s) for Purging of data                                                            M           H
APP       TECH       INTEGRATION AND ARCHITECTURE   20.00    Solution provides integrated toolset(s) for Recovery of data                                                           M           H
                                                             Solution provides integrated toolset(s) for Re-start, recycle rejected or errored adhoc/batch
APP       TECH       INTEGRATION AND ARCHITECTURE   21.00                                                                                                                           M           H
                                                             transactions
APP       TECH       INTEGRATION AND ARCHITECTURE   22.00    Public facing portals support multiple languages                                                                       D
                                                             Ability to configure the logon screen with "branding" for state of Oregon (logo, color schemes,
APP       TECH       INTEGRATION AND ARCHITECTURE   23.00                                                                                                                           M           H
                                                             and user warnings & messages)
APP       TECH       INTEGRATION AND ARCHITECTURE   24.00    Solution supports attachments of files to each transaction                                                             M           H
                                                             Solution supports Attachments of files as database content, reference to file server or files in
APP       TECH       INTEGRATION AND ARCHITECTURE   25.00                                                                                                                           M           H
                                                             a document Management system




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                  Page 16 of 28
      DAS HRIS Technical Requirements - ADA Compliance
Jump to Functional
                   Requirements Area                                                                                                                                                             To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                     BPR Change
                                                                                                                                                                                    Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                               Comments                                                            Recommended?
                                                                                                                                                                                   Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                        (Y/N)
                                                                                                                                                Mandatory for recruitment and
                                                          Solution must be compliant with section 508 standards of the American with            any other application soliciting
APP       TECH      ADA COMPLIANCE               26.00                                                                                                                                   D
                                                          Disabilities Act (ADA)                                                                information from the public at
                                                                                                                                                large
                                                                                                                                                Mandatory for recruitment and
                                                          Solution must provide toolsets to enable the state to be compliant with section 508   any other application soliciting
APP       TECH      ADA COMPLIANCE               27.00                                                                                                                                   D
                                                          standards of the American with Disabilities Act (ADA)                                 information from the public at
                                                                                                                                                large
                                                                                                                                                Mandatory for recruitment and
                                                          Solution must provide tools and adhere to the Web Content Accessibility Guidelines    any other application soliciting
APP       TECH      ADA COMPLIANCE               28.00                                                                                                                                   D
                                                          developed by the Web Accessibility Initiative of the W3c consortium                   information from the public at
                                                                                                                                                large




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                      Page 17 of 28
      DAS HRIS Technical Requirements - Security
Jump to Functional
                   Requirements Area                                                                                                                                                               To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                       BPR Change
                                                                                                                                                                                      Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                      Comments                                                       Recommended?
                                                                                                                                                                                     Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                          (Y/N)
                                                          Access at any level require users to authenticate consistent with existing State
APP       TECH      SECURITY                     29.00                                                                                                                                     M         H
                                                          security practices and single-sign infrastructure.

                                                          Solution provides ability to restrict all reporting and query functions with the same
APP       TECH      SECURITY                     30.00                                                                                                                                     M         H
                                                          security profiles and related data access limitations of the core application.

                                                          Solution must be flexible / configurable to accommodate enhanced security
APP       TECH      SECURITY                     31.00                                                                                                                                     M         H
                                                          requirements, such as two-factor authentication and/or digital signatures.

APP       TECH      SECURITY                     32.00    All suites/modules/applications can be accessed with one universal sign-in or log-in.                                            M         H

                                                          System has an associate's identity system (e.g., applicants, vendor self-service, other
APP       TECH      SECURITY                     33.00                                                                                                                                     M         H
                                                          agencies, volunteers, State contractors, etc.)
APP       TECH      SECURITY                     34.00    System has a public identity system (e.g., constituents, media, applicant, etc.)                                                 M         H
                                                          System has strong and documented boundaries between extranet, Internet and
APP       TECH      SECURITY                     35.00                                                                                                                                     M         H
                                                          internal system
                                                          Provides an identity management solution for internal (i.e. Intranet portal) users
APP       TECH      SECURITY                     36.00                                                                                                                                     M         H
                                                          (please describe how you can meet this requirement in the comment field)

                                                          Provides an identity management solution for external (i.e. Extranet portal) users
APP       TECH      SECURITY                     37.00                                                                                                                                     M         H
                                                          (please describe how you can meet this requirement in the comment field)

                                                          Provides an identity management solution for public portal users (please describe how
APP       TECH      SECURITY                     38.00                                                                                                                                     M         H
                                                          you can meet this requirement in the comment field)
                                                          The internal/intranet application or service must be enabled to run in a Single Sign On
                                                                                                                                                  DAS Team: Ask the vendor to
APP       TECH      SECURITY                     39.00    environment as implemented through: Tivoli Access Manager 6.x and/or Active                                                      M         H
                                                                                                                                                  please explain support for LDAP.
                                                          directory

APP       TECH      SECURITY                     40.00    Solution provides ability for administrator to restrict data access by Role or group                                             M         H

                                                          Solution provides ability for administrator to restrict data access by Person id or user
APP       TECH      SECURITY                     41.00                                                                                                                                     M         H
                                                          id
                                                          Solution provides ability for administrator to restrict data access by Person Type
APP       TECH      SECURITY                     42.00                                                                                                                                     M         H
                                                          (candidate versus employee versus contractor versus volunteer)
APP       TECH      SECURITY                     43.00    Solution provides ability for administrator to restrict data access by IP address                                                M         H
                                                          Solution provides ability for administrator to restrict data access by Screen/page field
APP       TECH      SECURITY                     44.00                                                                                                                                     M         H
                                                          and menu and transaction type
APP       TECH      SECURITY                     45.00    Solution provides ability for administrator to restrict data access by Report                                                    M         H

APP       TECH      SECURITY                     46.00    Solution provides ability for administrator to restrict data access by Database table                                            M         H

                                                          Solution provides ability for administrator to restrict data access by Job function /
APP       TECH      SECURITY                     47.00                                                                                                                                     M         H
                                                          position
                                                          Solution provides ability for administrator to define security profiles that restrict user
APP       TECH      SECURITY                     48.00                                                                                                                                     M         H
                                                          ability to log on
                                                          Solution provides ability for administrator to define security profiles that restrict user
APP       TECH      SECURITY                     49.00                                                                                                                                     M         H
                                                          ability to add/change/delete/update and view data.
                                                          Allows administrator to view or obtain security reports showing
APP       TECH      SECURITY                     50.00                                                                                                                                     M         H
                                                          Authorized/Unauthorized system use



      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                        Page 18 of 28
      DAS HRIS Technical Requirements - Security
Jump to Functional
                   Requirements Area                                                                                                                                                                    To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                            BPR Change
                                                                                                                                                                                           Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                                               Recommended?
                                                                                                                                                                                          Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                               (Y/N)
                                                          Generates warning message to notify administrator if multiple security profiles applied
APP       TECH      SECURITY                     51.00                                                                                                                                          M         H
                                                          to a single user are conflicting.
APP       TECH      SECURITY                     52.00    Provides effective dates to security changes                                                                                          M         H
APP       TECH      SECURITY                     53.00    Solution must allow encryption of all data transmitted via intranet and internet                                                      M         H
APP       TECH      SECURITY                     54.00    Provides the following password management functionality:                                                                             M         H
                                                          Solution must provide for Password length to be a system administrator-defined
APP       TECH      SECURITY                     55.00                                                                                                                                          M         H
                                                          number of positions
                                                          Solution must provide for Password aging as a system administrator defined
APP       TECH      SECURITY                     56.00                                                                                                                                          M         H
                                                          maximum number of days
                                                          Solution must provide for Password lock-out after system administrator defined
APP       TECH      SECURITY                     57.00                                                                                                                                          M         H
                                                          number of failed attempts

                                                          Solution must provide for System Administrator to be notified when the number of
APP       TECH      SECURITY                     58.00    failed attempts is exceeded. (The system must provide flexibility in configuration such                                               M         H
                                                          that DAS can re-set the number of logon attempts if desired).

                                                          Solution must provide for Passwords to be reset/deleted by security and system
APP       TECH      SECURITY                     59.00                                                                                                                                          M         H
                                                          administrators
                                                          Solution must provide for self service for Passwords to be changed by users if access
APP       TECH      SECURITY                     60.00                                                                                                                                          M         H
                                                          password is correct.
                                                          Solution must provide for Passwords to be alphanumeric, numeric and/or
APP       TECH      SECURITY                     61.00                                                                                                                                          M         H
                                                          alphanumeric characters as required by security administrator
APP       TECH      SECURITY                     62.00    Solution must provide for Passwords to be case sensitive if required                                                                  M         H

                                                          Solution must incorporates functionality from external identity management systems
APP       TECH      SECURITY                     63.00                                                                                                                                          M         H
                                                          that allow user password re-sets with authentication (i.e., challenge questions)

APP       TECH      SECURITY                     64.00    Ensures transmittal of passwords using secure protocols/algorithms.                                                                   M         H
                                                          Defines User Access Groups based on job responsibilities to ensure separation of
APP       TECH      SECURITY                     65.00                                                                                                                                          M         H
                                                          duties.
APP       TECH      SECURITY                     66.00    Disconnects or log out user session during designated periods of inactivity.                                                          M         H
                                                                                                                                                    DAS Team: If the vendor
                                                                                                                                                    indicates that third party software
SDC       TECH      SECURITY                     67.00    Provides data encryption at rest or in transit                                                                                        M         H
                                                                                                                                                    is required, ask them to explain
                                                                                                                                                    the solution.
                                                          All password and security related configuration files are maintained in an encrypted
APP       TECH      SECURITY                     68.00                                                                                                                                          M         H
                                                          state.
APP       TECH      SECURITY                     69.00    Solution provides ability to encrypt stored data at the database-level.                                                               M         H
APP       TECH      SECURITY                     70.00    Solution provides ability to administer security in a de-centralized manner.                                                          M         H
                                                          Solution provides ability to validate business logic (edit checks) for all data input
APP       TECH      SECURITY                     71.00                                                                                                                                          M         H
                                                          automatically.
                                                          Solution architecture isolates sessions such that a failure in one session does not
APP       TECH      SECURITY                     72.00                                                                                                                                          M         H
                                                          impact other sessions.
                                                          Solution automates the creation and deactivation of user accounts relative to
APP       TECH      SECURITY                     73.00                                                                                                                                          M         H
                                                          employment status.




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                             Page 19 of 28
      DAS HRIS Technical Requirements - Security
Jump to Functional
                   Requirements Area                                                                                                                                           To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                   BPR Change
                                                                                                                                                                  Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                    Recommended?
                                                                                                                                                                 Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                      (Y/N)

                                                          Solution complies with RFC2109 Cookie Standards for storing encrypted data on a
APP       TECH      SECURITY                     74.00                                                                                                                 M         H
                                                          device for reuse and set configurable expirations of data requiring a refresh.

APP       TECH      SECURITY                     75.00    Solution deactivates a user logon id after an administrator-defined period of inactivity.                    M         H

                                                          Solution denies access to user after a specified number of failed logon attempts, with
APP       TECH      SECURITY                     76.00                                                                                                                 M         H
                                                          explanation.
APP       TECH      SECURITY                     77.00    Solution does not use embedded logins and passwords.                                                         M         H
                                                          Solution provides ability for administrator to resume and/or revoke user accounts or
APP       TECH      SECURITY                     78.00                                                                                                                 M         H
                                                          passwords.

APP       TECH      SECURITY                     79.00    Solution provides ability for administrator to define required password characteristics.                     M         H

                                                          Provides security based on organization hierarchy level e.g.. Enterprise, Agency,
APP       TECH      SECURITY                     80.00                                                                                                                 M         H
                                                          department, Division, Section, Unit, Union
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     81.00                                                                                                                 M         H
                                                          profile by application module.
APP       TECH      SECURITY                     82.00    Solution provides ability to encrypt stored data at the database-level.                                      M         H
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     83.00                                                                                                                 M         H
                                                          profile by application module.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     84.00                                                                                                                 M         H
                                                          profile by application report.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     85.00                                                                                                                 M         H
                                                          profile by application screen or page.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     86.00                                                                                                                 M         H
                                                          profile by security role.
                                                          Solution provides ability for administrator to restrict data access for each security
APP       TECH      SECURITY                     87.00                                                                                                                 M         H
                                                          profile by User ID.

APP       TECH      SECURITY                     88.00    Allows administrator to view or obtain security reports based on security profiles                           M         H

                                                          Solution provides security for e-commerce functions, including customer / Proposer
APP       TECH      SECURITY                     89.00                                                                                                                 M         H
                                                          authentication and encryption to protect customer data.
                                                          Solution must provide for the ability to secure transmission of attachments such as
APP       TECH      SECURITY                     90.00                                                                                                                 M         H
                                                          résumés from external sources
                                                          The solution must include functionality to mask (or scramble) specific data elements
APP       TECH      SECURITY                     91.00    when being migrated from one environment to another. Example: masking salary or
                                                          SSN data when migrating from Production to the Sandbox.
                                                          The solution will have a built-in security function with can prevent an inbound patch
APP       TECH      SECURITY                     92.00                                                                                                                 M
                                                          (hardening) from damaging existing database code.
APP       TECH      SECURITY                     93.00    The solution will include a way to monitor and track virus attacks.                                          M




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                    Page 20 of 28
      DAS HRIS Technical Requirements - Data Entry & Data Auditing
Jump to Functional
                   Requirements Area                                                                                                                                           To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                   BPR Change
                                                                                                                                                                  Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                    Recommended?
                                                                                                                                                                 Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                      (Y/N)

APP       TECH      DATA ENTRY                   94.00    Allows complete validation and editing of data at the point of entry (on-line or batch)                      M         H

APP       TECH      DATA ENTRY                   95.00    Allows both online and batch entry of data.                                                                  M         H
                                                          The system must allow to establish rules for each transaction type which determine
APP       TECH      DATA ENTRY                   96.00                                                                                                                 M         H
                                                          whether data is Required, Optional or Not Allowed
                                                          The system must prevent transactions from posting until all "required" fields are
APP       TECH      DATA ENTRY                   97.00                                                                                                                 M         H
                                                          completed and validated.
                                                          The system must highlight errors on the screen for immediate correction (online,
APP       TECH      DATA ENTRY                   98.00                                                                                                                 M         H
                                                          immediate validity checks).
                                                          The system must allow line item descriptions up to 255 characters (Please list any
APP       TECH      DATA ENTRY                   99.00                                                                                                                 M         H
                                                          limitations in the comments field).
APP       TECH      DATA ENTRY                   100.00   Allows mass changes or deletes by table-driven data through proper security.                                 M         H
APP       TECH      DATA ENTRY                   101.00   Validates mass data entered in batch form.                                                                   M         H
APP       TECH      DATA ENTRY                   102.00   Validation rules for mass entries can be established                                                         M         H
APP       TECH      DATA ENTRY                   103.00   Invalid transactions from a mass upload are held in a suspend file                                           M         H
                                                          Rules are established for data precedence (e.g., accept this source file as opposed
APP       TECH      DATA ENTRY                   104.00                                                                                                                M         H
                                                          another source file)
                                                          Solution provides ability to store user preferences for menu, screen, column & field
APP       TECH      DATA ENTRY                   105.00                                                                                                                M
                                                          and default values
APP       TECH      DATA ENTRY                   106.00   Profiles are portable (e.g., not stored on a client but on the server)                                       M         H
APP       TECH      DATA ENTRY                   107.00   Data entry options available are based on security profiles                                                  M         H
                                                          Solution must provide ability to mask sensitive data as required by law or deemed by
APP       TECH      DATA ENTRY                   108.00                                                                                                                M
                                                          the State such as TaxID, SSN, passwords
APP       TECH      DATA ENTRY                   109.00   The system must allow electronic authorization for transactions.                                             M         H
APP       TECH      DATA ENTRY                   110.00   The system must allow customized form creation with auto-fill.                                               D
APP       TECH      DATA ENTRY                   111.00   The system must allow colored fonts in forms and on viewable screens.                                        D
APP       TECH      DATA ENTRY                   112.00   The system must allow user the ability to increase font size                                                 D
                                                          Solution supports ability to archive and retrieve application data, with controls for
APP       TECH      DATA ENTRY                   113.00                                                                                                                M         H
                                                          verifying referential integrity of data.
                                                          Solution application(s) pages support automatic population of data values where
APP       TECH      DATA ENTRY                   114.00                                                                                                                M         H
                                                          appropriate, relative to user data entry.

APP       TECH      DATA ENTRY                   115.00   Solution provides ability to define data edits by transaction type and input source.                         M         H

                                                          Audit trails that provide a trace of user actions with Automated tools to review audit
                                                          trails - for users viewing and/or doing data updates from the back end. Audit file
APP       TECH      DATA AUDITING                116.00                                                                                                                M         H
                                                          secured so that higher level security is required to access the data. This is to ensure a
                                                          separation.
                                                          Solution must provide configurable auditing capability as required by an administrator
APP       TECH      DATA AUDITING                117.00                                                                                                                M         H
                                                          or business area
APP       TECH      DATA AUDITING                118.00   Configuration transactions are audited                                                                       M         H
                                                          Solution must provide auditing of all workflow transaction s and electronic signatures
APP       TECH      DATA AUDITING                119.00                                                                                                                M         H
                                                          /Approvals
                                                          Solution provides ability for historical records of transactions, and these transaction
APP       TECH      DATA AUDITING                120.00   logs are stored in database tables. Data logged includes, but is not limited to, User                        M         H
                                                          ID, before/after change data and date-timestamp.


      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                    Page 21 of 28
      DAS HRIS Technical Requirements - Data Entry & Data Auditing
Jump to Functional
                   Requirements Area                                                                                                                                        To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                BPR Change
                                                                                                                                                               Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                  Comments                                    Recommended?
                                                                                                                                                              Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                   (Y/N)
APP       TECH      DATA AUDITING                121.00   Solution provides auditing inquiry and reporting capabilities.                                            M         H
                                                          Solution provides the ability to audit internet and intranet transactions. Data logged
APP       TECH      DATA AUDITING                122.00   includes, but is not limited to IP Address, Date and Time and historical transaction                      M         H
                                                          records




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                 Page 22 of 28
      DAS HRIS Technical Requirements - Hardware & Database
Jump to Functional
                   Requirements Area                                                                                                                                                                  To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                                          BPR Change
                                                                                                                                                                                         Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                  Comments                                                              Recommended?
                                                                                                                                                                                        Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                                             (Y/N)
APP       TECH      DATABASES                    123.00   HCM/ERP system is backward compatible for archived data                                                                             M         H
APP       TECH      DATABASES                    124.00   HCM/ERP system is forward compatible for archived data                                                                              M         H

APP       TECH      DATABASES                    125.00   Archives records upon request for records within a user-defined time and criteria.                                                  M         H

                                                          Configuration and data is preserved after system upgrade (as a disaster recovery
APP       TECH      DATABASES                    126.00                                                                                                                                       M         H
                                                          tool).
                                                          Configuration and data is preserved prior to a system upgrade (as a disaster recovery
APP       TECH      DATABASES                    127.00
                                                          tool).

APP       TECH      DATABASES                    128.00   Purges records upon request for records within a user-defined time and criteria.                                                    M         H

                                                          Recovers and restores records upon request for records within a user-defined time
APP       TECH      DATABASES                    129.00                                                                                                                                       M         H
                                                          and criteria.
APP       TECH      INPUT DEVICES                130.00   Solution must provide for document attachments from external sources                                                                D
APP       TECH      INPUT DEVICES                131.00   Supports gathering information from Scanner/digitizing device                                                                       D
                                                                                                                                                   DAS Team:
                                                          Solution provides flexibility and is not constrained in any manner to gather information Ask the software vendor to
APP       TECH      INPUT DEVICES                132.00   from a wide variety of sources such as but not limited to Bar Code, RFID, Wireless       please explain any restrictions or         M         H
                                                          devices, Keyboard, MICR, PDA's                                                           third party add-on's that would be
                                                                                                                                                   required.




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                                           Page 23 of 28
      DAS HRIS Technical Requirements - Development Support & Tools
Jump to Functional
                   Requirements Area                                                                                                                                               To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                       BPR Change
                                                                                                                                                                      Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                       Req #   Functional Requirements                                                                     Comments                                    Recommended?
                                                                                                                                                                     Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                          (Y/N)
                                                              Allows for separate, complete duplication of the software across the production
APP       TECH      DEVELOPMENT                     133.00                                                                                                                 M         H
                                                              system and multiple development and test landscapes.
                                                              Solution must be compatible with common development platforms such as but not
APP       TECH      DEVELOPMENT                     134.00                                                                                                                 M
                                                              limited to XML, Microsoft framework, .Net, java
APP       TECH      DEVELOPMENT                     135.00    Solution must provide Web services capability                                                                M         H

APP       TECH      DEVELOPMENT                     136.00    Solution must provide ability to create new objects such as tables, fields, screens                          M         H

APP       TECH      DEVELOPMENT                     137.00    Solution must provide ability to modify/change objects such tables, fields screens                           M         H

APP       TECH      DEVELOPMENT                     138.00    Allows for identification/reporting of new user-defined objects                                              M         H

APP       TECH      DEVELOPMENT                     139.00    Solution must provide ability to includes new user-defined objects in upgrade path.                          M         H

                                                              Software should provide version control, to help insure that when code is moved from
APP       TECH      DEVELOPMENT                     140.00    one box to another; such as sandbox to test, and test to prod - that updated code can
                                                              be tracked and controlled.
                                                              Complete set of technical documentation: glossaries, diagrams, data dictionaries,
APP       TECH      DEVELOPMENT                     141.00                                                                                                                 M
                                                              restart manual/run books
                                                              Vendor will facilitate knowledge transfer sessions to ensure DAS support team is
APP       TECH      DEVELOPMENT                     142.00                                                                                                                 M
                                                              trained on the new database and application.
APP       TECH      DEVELOPMENT                     143.00    Solution provides toolset(s) for Data conversion                                                             M         H

                                                              Data transfers between systems utilize XML or DAS approved formats. For example,
APP       TECH      INTERFACES                      144.00                                                                                                                 M         H
                                                              public safety applications need to follow the Global Justice XML or HRXML.

                                                              Solution provides toolset(s) with ability to develop interfaces for internal and external
APP       TECH      INTERFACES                      145.00    systems using technology such as but not limited to web services, XML, SOAP,                                 M         H
                                                              REST, EDI.
APP       TECH      APPLICATION ERROR METHODOLOGIES 146.00    Error messages appear in a consistent format across all system modules.                                      M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 147.00    Error messages are integrated with on-line help function.                                                    M         H

APP       TECH      APPLICATION ERROR METHODOLOGIES 148.00    Help functions are associated with functional transaction at menu, screen ,field level                       M         H

                                                              Allows users to send system error reports (automatically or Administrator defined) to
APP       TECH      APPLICATION ERROR METHODOLOGIES 149.00                                                                                                                 M         H
                                                              software vendor.
APP       TECH      APPLICATION ERROR METHODOLOGIES 150.00    Allows Administrators to maintain a log of errors.                                                           M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 151.00    Utilizes automatic notifications of errors to user-defined stakeholders                                      M         H
APP       TECH      APPLICATION ERROR METHODOLOGIES 152.00    Automatic notifications support threshold arguments                                                          M         H

SDC & APP TECH      UPGRADE                         153.00    Provides upgrade path cycle clearly defined with no interruption to end-user availability                    M         H

APP       TECH      UPGRADE                         154.00    Solution provides integrated toolset(s) for System upgrade support and tools                                 M         H




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                        Page 24 of 28
      DAS HRIS Technical Requirements - System Performance
Jump to Functional
                   Requirements Area                                                                                                                                      To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                              BPR Change
                                                                                                                                                             Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                Comments                                    Recommended?
                                                                                                                                                            Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                 (Y/N)
                                                          Solution architecture supports separation of report server tier from the transaction
APP       TECH      PERFORMANCE                  155.00                                                                                                           M         H
                                                          application server.
                                                          Provides ability to administer/control the priority of processes based on multiple
APP       TECH      PERFORMANCE                  156.00                                                                                                           M         H
                                                          configurable criteria.




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                               Page 25 of 28
      DAS HRIS Technical Requirements - Networking
Jump to Functional
                   Requirements Area                                                                                                                               To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                       BPR Change
                                                                                                                                                      Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                         Comments                                    Recommended?
                                                                                                                                                     Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                          (Y/N)
APP       TECH      NETWORKING                   157.00   The application uses IP based communications for its networking protocol                         M         H
APP       TECH      EMAIL PROTOCOL               158.00   Supports network E-mail Services using X.500 standards and LDAP protocols.                       M         H
                                                          Solution is web-based and requires no installation on client workstations for
SDC       TECH      INTERNET ARCHITECTURE        159.00                                                                                                    M         H
                                                          Client/Agents/Suppliers (self-service).




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                        Page 26 of 28
      DAS HRIS Technical Requirements - Workflow
Jump to Functional
                   Requirements Area                                                                                                                                       To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                               BPR Change
                                                                                                                                                              Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                 Comments                                    Recommended?
                                                                                                                                                             Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                  (Y/N)
APP       TECH      WORKFLOW                     163.00   Solution provides toolset(s) for Workflow design and management                                          M         H
APP       TECH      WORKFLOW                     164.00   Solution uses workflow to electronically route documents                                                 M         H
APP       TECH      WORKFLOW                     165.00   Solution must provide the ability for initiator to track approval process                                M         H
APP       TECH      WORKFLOW                     166.00   Workflow works between all modules                                                                       M         H
                                                          Workflow can be configured to work with systems interfaced to the ERP application
APP       TECH      WORKFLOW                     167.00                                                                                                            M         H
                                                          (provide limitations in comments column or as an attachment)
                                                          Solution must provide for Workflow rules to be established based on User-defined
APP       TECH      WORKFLOW                     168.00                                                                                                            M         H
                                                          criteria (provide limitations in comments column or in attachment)
APP       TECH      WORKFLOW                     169.00   Workflow is compliant with BPMN standards                                                                M         H
                                                          Workflow assignments can be re-routed to different authorized approvers based upon
APP       TECH      WORKFLOW                     170.00                                                                                                            M         H
                                                          availability
APP       TECH      WORKFLOW                     171.00   Workflow alerts can be integrated with Microsoft Exchange 2007                                           M         H
                                                          Solution architecture is integrated, designed and implemented on a workflow
APP       TECH      WORKFLOW                     172.00                                                                                                            M         H
                                                          architecture
                                                          Solution must provide for Workflow rules to be established based on Events, User,
APP       TECH      WORKFLOW                     173.00                                                                                                            M         H
                                                          Role, Percentage and numerical thresholds

APP       TECH      WORKFLOW                     174.00   Solution must provide Workflow rules to allow delegation of Workflow approval                            M         H

                                                          Solution must provide Workflow capability across all functional areas proposed in the
APP       TECH      WORKFLOW                     175.00                                                                                                            M         H
                                                          functional requirements




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                Page 27 of 28
      DAS HRIS Technical Requirements - Reporting
Jump to Functional
                   Requirements Area                                                                                                                                           To Be Completed by DAS HR Staff
  Descriptions
                                                                                                                                                                                                   BPR Change
                                                                                                                                                                  Mandatory /    Priority Level                  Vendor Demo Script
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                    Recommended?
                                                                                                                                                                 Desirable (M/D)    (H,M,L)                        Needed? (Y/N)
                                                                                                                                                                                                      (Y/N)
                                                          Solution includes job scheduling tools for reports, interfaces, batch programs etc.. or
                                                          integration with a third-party tool that allow users to sequence multiple jobs based on
SDC       TECH      JOB SCHEDULING               176.00   configurable rules. If third Party, preference for solution with Job Scheduling tools                        M         H
                                                          currently supported by the State as detailed in Oregon State Data Center
                                                          Requirements and Standards
SDC       TECH      JOB SCHEDULING               177.00   System notification must be provided on failed jobs                                                          M         H
APP       TECH      REPORTING                    178.00   Solution provides ability for report repository / library                                                    M         H
APP       TECH      REPORTING                    179.00   Reports must provide drill down capabilities                                                                 M         H
APP       TECH      REPORTING                    180.00   Users can add and link tables in query tools or data warehouse functions                                     M         H
APP       TECH      REPORTING                    181.00   Provides end-users the ability to create & generate ad-hoc reports.                                          M         H
APP       TECH      REPORTING                    182.00   Allows ad-hoc report/query definitions to be saved.                                                          M         H
APP       TECH      REPORTING                    183.00   Allows end-users, with appropriate security, to modify report queries on-line.                               M         H
APP       TECH      REPORTING                    184.00   Allows users to save ad-hoc report results                                                                   M         H
                                                          Allows users to export the data to a spreadsheet application for manipulation and/or
APP       TECH      REPORTING                    185.00                                                                                                                M         H
                                                          reporting of data.
APP       TECH      REPORTING                    186.00   Allows for merged word processor reports to be edited and saved directly.                                    M         H
APP       TECH      REPORTING                    187.00   Allows users to report on any user-defined parameter values or ranges.                                       M         H
APP       TECH      REPORTING                    188.00   Reports can include end-user defined headings and borders.                                                   M         H
APP       TECH      REPORTING                    189.00   Filters reports based upon user-defined criteria.                                                            M         H
APP       TECH      REPORTING                    190.00   Allows user to create and print reports on special forms.                                                    M         H
                                                          Provides on-line real-time reporting and query capability with the ability to reference a
APP       TECH      REPORTING                    191.00                                                                                                                M         H
                                                          data dictionary.
                                                          Allows user to create reports that can suppress or print information based on user's
APP       TECH      REPORTING                    192.00                                                                                                                M         H
                                                          security
APP       TECH      REPORTING                    193.00   Allows user to print reports to any printer (e.g. laser jets, networked copiers)                             M         H
                                                          Solution must provide end-user definition of criteria's such as but not limited to
APP       TECH      REPORTING                    194.00                                                                                                                M
                                                          wildcards, text searches
APP       TECH      REPORTING                    195.00   Solution must provide ability to distribute reports such as via links, email                                 M         H
APP       TECH      REPORTING                    196.00   System produces dashboard data                                                                               M         H
APP       TECH      REPORTING                    197.00   Users can define dashboard reports                                                                           M         H
APP       TECH      REPORTING                    198.00   Provides for access to data via ODBC (through appropriate security).                                         M         H
                                                          Provides Administrator-defined limits on the time a report or query takes to execute
APP       TECH      REPORTING                    199.00                                                                                                                M         H
                                                          and the number of records to be retrieved.
                                                          Administrator defined limits are defined for other types of query functions such as but
APP       TECH      REPORTING                    200.00                                                                                                                M         H
                                                          not limited to number of table joins
                                                          Solution must provide for Report to be generated and published in various formats
APP       TECH      REPORTING                    201.00                                                                                                                M         H
                                                          such as but not limited to Screen, Printer, XML, PDF, word, excel




      bc764058-59e0-49f7-a6c4-42bf54cd7428.xls                                                                                                                                                                    Page 28 of 28

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:6
posted:12/3/2011
language:English
pages:28