Project Scope for Job Portal - Excel

Document Sample
Project Scope for Job Portal - Excel 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.




2fc93451-abcf-4467-9daf-70698dc94897.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).




2fc93451-abcf-4467-9daf-70698dc94897.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.




2fc93451-abcf-4467-9daf-70698dc94897.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




    2fc93451-abcf-4467-9daf-70698dc94897.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




    2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                    Mandatory /        Priority
 Owner     Function SubFunction                      Req #   Functional Requirements                                                                    Comments                                     Recommended?   Script Needed?
                                                                                                                                                                   Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                         (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
SDC       TECH       ARCHITECTURE                   4.00     DBMS 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



      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                            Mandatory /        Priority
 Owner     Function SubFunction                      Req #   Functional Requirements                                                                    Comments                                                             Recommended?   Script Needed?
                                                                                                                                                                                           Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                                 (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
APP       TECH       SECURITY                       38.00                                                                                                                                        M           H
                                                             how 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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                   Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                      Comments                                     Recommended?   Script Needed?
                                                                                                                                                                  Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                        (Y/N)           (Y/N)
                                                          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
                                                          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.



      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                             Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                                                Recommended?   Script Needed?
                                                                                                                                                                                            Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                                  (Y/N)           (Y/N)
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.

                                                          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



      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                     Recommended?   Script Needed?
                                                                                                                                                               Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                     (Y/N)           (Y/N)
                                                          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

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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                         Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                                              Recommended?   Script Needed?
                                                                                                                                                                                        Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                              (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



      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                       Mandatory /        Priority
 Owner     Function SubFunction                        Req #   Functional Requirements                                                                     Comments                                     Recommended?   Script Needed?
                                                                                                                                                                      Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                            (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
APP       TECH       DESKTOP                         162.00    web browsers such as Mozilla, Firefox, Safari, Netscape -- must support recent                               M           H
                                                               versions of industry standard browsers.



      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                     Recommended?   Script Needed?
                                                                                                                                                               Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                     (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


      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                     Recommended?   Script Needed?
                                                                                                                                                               Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                     (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




      2fc93451-abcf-4467-9daf-70698dc94897.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                     Vendor Demo Script
 Owner     Function SubFunction                      Req #   Functional Requirements                                                                            Comments                                     Recommended?
                                                                                                                                                                           Desirable (M/D)   Level (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                               M           H
                                                             Center 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.
SDC       TECH       ARCHITECTURE                   7.00     e.g. n-tier architecture; can bring down or scale an individual web or app server without                           M           H
                                                             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 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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                    Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                               Comments                                                             Recommended?   Script Needed?
                                                                                                                                                                                   Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                         (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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                      Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                      Comments                                                        Recommended?   Script Needed?
                                                                                                                                                                                     Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                           (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
APP       TECH       SECURITY                    38.00                                                                                                                                     M           H
                                                          how 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


      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                           Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                                                Recommended?   Script Needed?
                                                                                                                                                                                          Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                                (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.




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                  Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                     Recommended?   Script Needed?
                                                                                                                                                                 Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                       (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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                   Comments                                     Recommended?   Script Needed?
                                                                                                                                                               Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                     (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.


      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                               Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                  Comments                                     Recommended?   Script Needed?
                                                                                                                                                              Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                    (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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                                         Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                  Comments                                                               Recommended?   Script Needed?
                                                                                                                                                                                        Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                                              (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.




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                       Mandatory /        Priority
 Owner     Function SubFunction                        Req #   Functional Requirements                                                                     Comments                                     Recommended?   Script Needed?
                                                                                                                                                                      Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                            (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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                             Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                Comments                                     Recommended?   Script Needed?
                                                                                                                                                            Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                  (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.




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                      Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                         Comments                                     Recommended?   Script Needed?
                                                                                                                                                     Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                           (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).




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                              Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                 Comments                                     Recommended?   Script Needed?
                                                                                                                                                             Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                   (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




      2fc93451-abcf-4467-9daf-70698dc94897.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     Vendor Demo
                                                                                                                                                                  Mandatory /        Priority
 Owner     Function SubFunction                   Req #   Functional Requirements                                                                     Comments                                     Recommended?   Script Needed?
                                                                                                                                                                 Desirable (M/D)   Level (H,M,L)
                                                                                                                                                                                                       (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




      2fc93451-abcf-4467-9daf-70698dc94897.xls                                                                                                                                                                    Page 28 of 28

				
DOCUMENT INFO
Description: Project Scope for Job Portal document sample