![](media/image1.png){width="1.5625in" height="1.5729166666666667in"}

Decennial Applicant,\
Personnel and Payroll System\
(DAPPS)

BOC Requirements for DAPPS Infrastructure for the 2010 Census

# Record of Document Changes {#record-of-document-changes .Contents}

  ------------- ------------- -------------- -------------------------------------
  **Document\   **Revision\   **Originator   **Revision Description**
  Version**     Date**        /\             
                              Revised By**   

  0.0           January 25,   Lloyd          New document created for offerors
                2005          Bartoszek      documenting the requirements of DAPPS
                                             for the 2010 Census.

  0.1           February 9,   Lloyd          Incorporated comments from Mark
                2005          Bartoszek      Taylor, Cathy Lacy, and several other
                                             DAPPS project team members.

                                             

                                             
  ------------- ------------- -------------- -------------------------------------

# Contents {#contents .Contents}

[**1** **Overview 1**](#overview)

[2 Operational Architecture 2](#operational-architecture)

[2.1 Front-end Data Capture 3](#front-end-data-capture)

[2.2 Job Applicants or Pre-Appointment Management
3](#job-applicants-or-pre-appointment-management)

[2.3 Personnel 3](#personnel)

[2.4 Time and Expense 3](#time-and-expense)

[2.5 Payroll 4](#payroll)

[3 Interfaces 5](#interfaces)

[4 System Architecture 6](#system-architecture)

[5 Technical Architecture 8](#technical-architecture)

[5.1 Understanding the PeopleSoft Internet Architecture
8](#understanding-the-peoplesoft-internet-architecture)

[5.2 PeopleSoft Architecture Hardware and Software Requirements
11](#peoplesoft-architecture-hardware-and-software-requirements)

[5.2.1 End User Workstation Requirements
11](#end-user-workstation-requirements)

[5.2.1.1 End User Workstation Hardware Requirements
12](#end-user-workstation-hardware-requirements)

[5.2.1.2 End User Workstation Software Requirements
12](#end-user-workstation-software-requirements)

[5.2.2 Web Server Requirements 13](#web-server-requirements)

[5.2.2.1 Web Server Hardware Requirements
13](#web-server-hardware-requirements)

[5.2.2.2 Web Server Software Requirements
13](#web-server-software-requirements)

[5.2.3 File Server Requirements 13](#file-server-requirements)

[5.2.3.1 File Server Hardware Requirements
14](#file-server-hardware-requirements)

[5.2.3.2 File Server Software Requirements
14](#file-server-software-requirements)

[5.2.4 Database Server Requirements 14](#database-server-requirements)

[5.2.4.1 Database Server Hardware Requirements
14](#database-server-hardware-requirements)

[5.2.4.2 Database Server Software Requirements
15](#database-server-software-requirements)

[5.2.5 Process Scheduler (Batch) Server Requirements
15](#process-scheduler-batch-server-requirements)

[5.2.5.1 Process Scheduler Server Hardware Requirements
15](#process-scheduler-server-hardware-requirements)

[5.2.5.2 Process Scheduler Server Software Requirements
15](#process-scheduler-server-software-requirements)

[5.2.6 Application Server Requirements
16](#application-server-requirements)

[5.2.6.1 Application Server Hardware Requirements
16](#application-server-hardware-requirements)

[5.2.6.2 Application Server Software Requirements
16](#application-server-software-requirements)

[5.3 DAPPS Current Architecture 17](#dapps-current-architecture)

[5.3.1 Hardware 17](#hardware)

[5.3.2 Software 19](#software)

[6 Performance Measures 21](#performance-measures)

[7 Decennial Workloads 22](#decennial-workloads)

[8 References 30](#references)

# Overview

DAPPS is the 2010 Census Decennial Applicant, Personnel and Payroll
System. It is the administrative management system that supports
applicant tracking and processing, recruiting reports, and personnel and
payroll processing, including internal and external interfaces. DAPPS
operations will be supported by several databases depending on the
offeror's proposed solution. At a minimum, two production environments
are required and at least one environment is required for fault
tolerance. Up to four production databases may be implemented depending
on the robustness of the network infrastructure. The segmented
database(s) will be accessible to and used by Headquarters (HQ),
Regional Offices (ROs), Regional Census Centers (RCCs) and their
associated Local Census Offices (LCOs).

DAPPS uses state-of-the-art Internet Architecture technology to maximize
information management and it is a server-centric execution architecture
for deploying Internet applications to end users who access the
applications through a web browser. The following diagram illustrates
the various architecture pieces involved in this deployment
architecture:

![](media/image3.png){width="4.385416666666667in"
height="2.2708333333333335in"}

There are several key concepts to take away from the above diagram:

-   End users access the applications through a web browser.

-   The architecture is very server centric. The heart of the
    architecture is the PeopleSoft Internet Application Server that
    consists of the web server and the application server. A relational
    database management system (RDBMS) is required for the repository of
    all PeopleSoft applications data.

-   The above architecture supports all DAPPS end users. The only users
    who will require high-end Windows machines and client configurations
    will be system administrators and developers.

For the 2010 Census, the system supports the applicant, personnel, time
and attendance, and payroll processing and other requirements of both
management and operational personnel at the LCOs. Interactive processing
for ad hoc reports in a user-friendly environment makes the system easy
to operate in the LCOs and in the RCCs.

# Operational Architecture

The operations performed by DAPPS provides automation to support the
collection of applicant data, preparation of selection records and
recruiting reports, hiring of personnel, processing of pay increases,
terminations and other personnel actions, time and attendance processing
from both paper and/or via the Mobile Computing Equipment (MCE) device,
and weekly payroll processing. DAPPS is used in the hiring of all
Schedule A, intermittent staff, and field and office staff at the LCOs.
The number of personnel needed to work at a particular site depends on
the location of the site and the Census operations in progress at the
time. For example, early field operations for the 2010 Census in each
RCC may require an average of 1,000 field employees for the urban block
canvassing operations.

The DAPPS database should be sized to accommodate all of the
approximately 600,000 employees at peak employment levels in the 12 RCCs
working from as many as 520 LCOs. The US Census Bureau expects to hire
as many as 1,000,000 employees for different purposes and operations
between January 2007 and October 2010. To hire and train enough
employees, the US Census Bureau must recruit approximately 4 million
applicants.

Once an application has been received, the applicant's information is
entered manually into the database. All applicants will need to be
geographically coded to the census tract and block to support indigenous
hiring (where they live). This task is accomplished via an internal
interface with the Census Geography Division. Additionally, the
applicant's data will be then sent electronically to the Census Hiring
and Employment Check (CHEC) system. CHEC formats and transmits the
applicant information to the Federal Bureau of Investigation (FBI) in
accordance with specifications provided. The FBI transmits the results
of its suitability check back to CHEC. CHEC transmits those results to
DAPPS on a daily basis. This procedure allows field staff to identify
eligible applicants as quickly as possible. Specific suitability
requirements will need to be developed for the 2010 Census.

Once an applicant has been cleared, he or she can be considered for
hire, and if hired, payable for hours worked and miles traveled through
DAPPS. All DAPPS employees are paid on a weekly basis. DAPPS submits
payroll information to one of the four Department of the Treasury
Disbursing Centers on a weekly basis. Employees are paid by electronic
funds transfer or by paper check.

Use of DAPPS for personnel and payroll processing provides the following
benefits to the U.S. Census Bureau:

-   Efficient payroll processing between the end of the payroll period
    and check disbursement.

-   Improved timeliness and completeness of information available to the
    ROs, RCCs, LCOs, and HQ for managing overall census operations.

DAPPS operations are categorized into five functional components, as
described in the following sections.

## Front-end Data Capture

The ***front-end data capture*** component reflects electronic capture
of all government forms used in the applicant, personnel, and payroll
processes, and of electronic signatures where required for payroll
certification/approval. Front-end data capture applications in both
office and mobile computing environments must be simple,
straightforward, and intuitive because the applications will support
large numbers of temporary field staff with minimal training.

## Job Applicants or Pre-Appointment Management

The ***Job application or Pre-Appointment Management*** component
reflects the production of selection certificates. Certificates list the
top 50 applicants who meet the criteria for the job, taking into
consideration veterans' preference and test scores. All applicants are
geocoded to either a specific census tract and block, or census tract
only. Job application processing also requires that the census applicant
pass an internal employee clearance system, the Census Hiring and
Employment Check (CHEC). The CHEC system interfaces with the OPM and the
Federal Bureau of Investigation (FBI) for processing security
screenings. Information received from the CHEC system is used in
determining an applicant's suitability for hire. Additionally, DAPPS
provides management reports used to monitor the effectiveness of
recruiting efforts.

## Personnel

The ***Personnel*** component is used once an offer of appointment has
been accepted, and the applicant has been hired and received a
notification of the hiring action (SF-50B). A personnel record is
established for the new employee. This component involves recording all
valid personnel actions, such as hiring and termination. It also
includes changes to employee data, such as name or address, or changes
in job data (e.g., pay rate or position). Dates are associated with each
action, and a history of all personnel actions is maintained, per the
requirements defined by the Office of Personnel Management (OPM).
Electronic transfers of personnel data to OPM are also required as well
as providing management reports and generating notices of personnel
actions.

## Time and Expense

The ***Time and Expense*** component capture employee time and expense
reimbursements daily. This data is keyed directly into the system. Hours
worked are categorized by type, assigned to a pre-defined project, and
edited against predefined guidelines established by the Census Bureau
and OPM. The system accommodates the turning in of late time and
retroactive mileage reimbursements.

In addition for the 2010 Census, data entry on time and expenses will be
completed on two platforms: 1) data entry of office employees that do
not have an MCE device or are not assigned to a computer station; and 2)
staff that complete their work and enter their time and expenses on the
MCE device. Based on the selected MCE solution, an interface may be
needed for the transfer of time and expense data from the enumerator's
device to the supervisor's device for approval, additional edits
performed within the DAPPS system, and sending reports back to the
enumerator and/or supervisor's devices.

## Payroll

The ***Payroll*** component captures and tabulates employee hours daily.
At the end of each payroll period, daily payroll totals are combined to
create a single weekly total.

Payroll processing involves generating a weekly payroll and begins after
the RCC has received confirmation from all LCOs that calculation of pay
and reimbursements can begin. Varying tax laws, locality pay
distribution, cost of living adjustments, and overtime pay limits add
complexity to the processing. Employee pay must be calculated employing
federal, state, and local tax guidelines. Employee-specified tax
withholdings, garnishments, and other deductions, direct deposits, and
retroactive pay must be available. Quarterly balances or employee
earnings and taxes must be maintained. Payroll data is transmitted to
the Department of the Treasury for creating checks or Electronic File
Transfer (EFT) payments and to the National Processing Center for
creating employee earnings statements. Payroll data is also transmitted
to Census Bureau Finance Division for General Ledger updates. All or
some of the payroll data may require interface to a number of external
systems (e.g., Federal Reserve Bank, Social Security Administration).

# Interfaces

The following table summaries the key DAPPS interfaces needed for the
applicant, personnel and payroll process interfacing with other
applications within the Census Bureau or external agencies. All files
should be encrypted using either hardware or software methods.

  -------------------------------------------------------------------------------------
  Agency             Type of Data            Interface   Connection   Frequency
  ------------------ ----------------------- ----------- ------------ -----------------
  Treasury           Payroll Data            Outbound    External     Weekly

  US Census Bureau/  Cost Data               Outbound    Internal     Weekly
  General Ledger                                                      
  (GL)                                                                

  US Census Bureau   W2 Data                 Outbound    Internal     Annually
  /National                                                           
  Processing Center                                                   
  (NPC)                                                               

  US Census Bureau   FIPS-Geographic         Inbound     Internal     Daily
  /Geography Div.    Location Data                                    

  US Census Bureau   Suitability/Security    Inbound/    Internal     Daily/On-Demand
  /CHEC              Screening Data          Outbound                 

  Federal Reserve    Bank Routing Numbers    Inbound     External     Monthly

  Talx UC Express    Unemployment Data       Outbound    External     Weekly

  OPM                SF113 Data (SF113A and  Outbound    External     Biweekly
                     SF113G)                                          

  SSA                Child Support Data (new Outbound    External     Weekly
                     hires)                                           

  SSA                Child Support Data      Outbound    External     Quarterly
                     (quarterly wage)                                 

  US Census Bureau   Earnings Data           Outbound    Internal     Weekly
  /NPC                                                                

  SSA                W2 Data                 Outbound    External     Annually

  US Census Bureau   Payroll Data            Outbound    Internal     On-Demand
  /MIS                                                                

  US Census Bureau   Payroll Data            Outbound    Internal     On-Demand
  /OCS                                                                

  US Census Bureau   Recruiting data         Inbound     Internal     Daily/On-Demand
  /Recruiting front                                                   
  end                                                                 

  OPM                Namecheck Request Title Outbound    External     Daily
                     5 Data (subject's                                
                     personal data such as                            
                     name and HIS)                                    

  OPM                Fingerprint Check       Outbound    External     Daily
                     Request Title 5 Data                             
                     (subject's fingerprints                          
                     and personal data such                           
                     as name and HIS)                                 

  OPM                Namecheck Results       Inbound     External     Daily
                     (Namecheck errors,                               
                     NonIdent, Ident)                                 

  OPM                Fingerprint Check       Inbound     External     Daily
                     Results (NonIdent,                               
                     Ident, unclassifiable,                           
                     rap sheets)                                      

  Arrest Disposition Request for disposition Outbound    External     Daily/as needed
  Vendor             on a subject's arrest                            

  Arrest Disposition Disposition on a        Inbound     External     Daily/as needed
  Vendor             subject's arrest                                 
  -------------------------------------------------------------------------------------

#  System Architecture

The aim of the DAPPS architecture is to reduce downtime as much as
possible to ensure that DAPPS users can fulfill their duties and meet
their deadlines during the 2010 Census. This high availability strategy
must be tailored to the Census Bureau's specific business elements and
processes, existing infrastructure, 2010 decennial business models, and
budget constraints. The goal of a high availability infrastructure is to
proactively mitigate and manage key business risks such that the Census
Bureau accomplishes the 2010 Census.

Total downtime will only constitute unplanned shutdown. Planned shutdown
must not affect DAPPS users and must be scheduled out of business hours
to support system maintenance, upgrades, and configuration changes.

The proposed architecture for the DAPPS system in terms of its logical
(e.g., functional) and physical (component) architecture shall meet the
following requirements:

-   The offeror shall provide a secure and dedicated environment for the
    DAPPS application.

-   The offeror shall provide high availability and fault-tolerant
    hardware architecture to support the DAPPS application.

-   The offeror shall design the system infrastructure such that key
    system components are maintained in at least two of the three main
    U.S. power grids (Eastern Interconnect, Western Interconnect, and
    Texas Interconnect) such that system availability will be maintained
    if there is a power loss in one of the power grids.

-   The offeror shall provide complete application management and
    monitoring software for the DAPPS application.

-   The offeror shall provide failover capability for PeopleSoft's
    Internet Architecture using clustering and load balancing which are
    the methods used to provide a resilient environment for the
    application tier.

-   The offeror shall provide a network and communication
    infrastructure, which comprises components such as routers,
    firewalls, and load balancers. All network components must be
    implemented in a fault tolerant fashion. Network high availability
    needs to be achieved mainly by redundancy. The network solution must
    have the ability to automatically reroute the traffic across
    redundant links and devices, providing at least one alternative
    route around any single failed component. In this manner, the
    application is always accessible.

-   The offeror shall provide a high availability storage infrastructure
    because the DAPPS data is one of the most important assets during
    the decennial operations in terms of recruitment, payroll, cost and
    progress and other critical data needed on demand due to
    Congressional inquires, EEO complaints, etc. Therefore, an
    end-to-end approach must be taken by the offeror in designing the
    DAPPS high availability storage infrastructure comprising not only
    components of storage devices but also all other components. A high
    availability storage infrastructure encompasses the following
    components:

```{=html}
<!-- -->
```
-   Storage Subsystems that involve Data Protection, Storage Subsystem
    Interfaces and Storage Subsystem Hardware Redundancy.

```{=html}
<!-- -->
```
-   **Data Protection**. This must be designed in such a way where
    redundant cache is utilized to reduce overall latency and improve
    performance; disk array architecture is utilized to provide disk
    fault-tolerance; and the most important of all is data replication
    or a redundant storage subsystem must be made available at the same
    site and at a site at a different physical location to protect
    against an entire storage subsystem failure; thus, the end result is
    a real time copy of data in two or more independent storage
    subsystems.

-   **Storage Subsystem Interfaces***.* These must be designed in such a
    way where interfaces to the storage are as important as the
    integrity of the storage itself. Redundant interfaces should be
    built in storage subsystem to achieve true high availability. A disk
    logical unit must be exported through multiple interfaces on the
    storage subsystem. This not only allows multipathing at the host
    level but also provides added redundancy of two physical connections
    from the disk subsystem itself.

-   **Storage Subsystem Hardware Redundancy**. This must be designed
    where power redundancy and hot disk sparing are available. Power is
    critical in a storage subsystem for high availability systems.
    Storage subsystems with front-end cache must have battery backup for
    the cache. Batteries are used in a subsystem to keep the entire
    system running long enough to de-stage the data from the cache to
    the physical disk. If RAID technology is part of the offeror's
    solution, hot spare disks must be available for potential signs of
    physical disks failure; thus, data from the failing disk can be
    copied to a hot spare.

```{=html}
<!-- -->
```
-   Storage Network must be designed in such a way that there are no
    single points of failure. Components of storage network encompass
    switch hardware and fabric.

```{=html}
<!-- -->
```
-   The offeror shall provide high availability for the database tier
    where clustering solutions exist and/or implemented at the database
    servers. For example, Oracle's Real Application Clusters (RAC) is
    currently used for the DAPPS application where all active instances
    can concurrently execute transactions against the shared database.
    RAC automatically co-ordinate each instance' access to the shared
    data to provide data consistency and data integrity. Therefore, the
    offeror shall continue to support the current DAPPS Oracle RAC
    implementation.

-   The offeror shall provide 24x7 phone, web-based client support,
    including staff to come in and fix any issues pertaining to the
    hardware.

-   The offeror shall configure the architecture components based on the
    estimated workloads for the 2010 Census. See section 7 Decennial
    Workloads for historical workloads during the 2000 Census.

-   The offeror shall size the production database to handle the
    estimated workloads for the 2010 Census. See section 7 Decennial
    Workloads for historical workloads during the 2000 Census.

-   The offeror proposed solution for the database platform must support
    an Oracle RDBMS.

-   The offeror proposed solution must run a Unix or Linux operating
    system.

-   The offeror shall size sufficient disk space for storing reports and
    archiving of data files and images.

# Technical Architecture

Technical Architecture refers to the hardware and software platforms,
including system software, database software, middleware, presentation
technology as well as special purpose infrastructure for high
availability and fault tolerance. The offeror's proposed technical
architecture definition for DAPPS will involve choices of standards and
product lines together with an evaluation of product evolution based on
sound assumptions and past history and experiences. In addition, the
offeror's proposed technical architecture needs to be installed and
tested for basic interoperability of the choices made as well as
rudimentary performance estimates.

Therefore, the following subsections will provide the offeror a better
understanding for its proposed solution to support the DAPPS
application. The first section describes the PeopleSoft's PIA
architecture and its components; the second describes the hardware and
software requirements to support the PIA architecture for the DAPPS
application; and the last section provides an overview of the current
DAPPS Architecture for both development and production supporting the
2006 Census Test, including an inventory of the current hardware and
software currently used.

## Understanding the PeopleSoft Internet Architecture

As stated in the overview section, the PeopleSoft Internet Architecture
(PIA) is server-centric execution architecture for deploying Internet
applications to end users who access the applications through a web
browser. The following diagram illustrates the various architecture
components involved in this deployment architecture:

![](media/image3.png){width="4.385416666666667in"
height="2.2708333333333335in"}

![](media/image4.png){width="6.697222222222222in"
height="4.665972222222222in"}

The PeopleSoft PIA is used to deploy ultra-thin HTML client-based
applications that look and feel like state-of-the-art web sites. This
situation calls for an application server and a web server. The web
server acts as an intermediary between the client and the application
server. On the client side, all that is needed is a workstation supplied
with a supported browser.

The hardware and software that is needed (purchased, installed, and
tested) to run the DAPPS application using the PeopleSoft application
modules depends on the particular PeopleSoft configuration chosen by the
offeror. The components the offeror needs to consider include:

-   **End User Workstation***.* Because of the PeopleSoft Internet
    Architecture, the end user's machine needs a PeopleSoft supported
    web browser such as Microsoft Internet Explorer. It does not have to
    have database connectivity or any PeopleSoft software. Under the
    PeopleSoft Internet Architecture, the browser communicates with the
    web server via HTTP. The web server translates the request and
    communicates with the application server via Jolt. The application
    server interprets these messages and sends SQL to the database
    server.

-   **PeopleTools Development Environment***.* The traditional
    Windows-based client is still available, but is used primarily as an
    environment for developers or system administrators. This
    Windows-based machine provides traditional two-tier and three-tier
    connectivity to PeopleSoft applications. In the two-tier
    architecture, application logic executes on the client machine using
    data it receives from the PeopleSoft database located on a separate
    relational database management system (RDBMS) server. The
    client/server network conversation uses SQL to transmit database
    calls. In a three-tier configuration, in contrast, the application
    processing logic runs on the application server. In this case, RDBMS
    connectivity is no longer required on the client. The client uses
    Tuxedo to send messages to the application server, which, in turn,
    sends the appropriate SQL to the database server.

-   **File Server**. The file server is the environment (or file)
    repository for the PeopleTools Development Environment and for the
    files necessary to perform an upgrade or customization. A file
    server is required to maintain a master copy of the system programs
    used by PeopleSoft software. Any agency's specific configuration
    requirements are, of course, based upon the requirements for all
    their applications and network software. The file server includes
    the Upgrade Assistant and all of the executables and scripts which
    are necessary to perform an upgrade or apply patches and updates
    from Customer Connection directly to the file server and then copy
    the updated files to other servers. In addition, the file server is
    a source repository for COBOL and SQR.

-   **Database Server***.* The database server houses the PeopleSoft
    database (ORACLE), which includes all of the object definitions,
    system tables, application tables, and data. It needs sufficient
    disk space to accommodate the operating system (Linux or UNIX), and
    all the database instances as described in the detailed requirements
    of section 5.2.4.1 Database Server Hardware Requirements. When
    upgrading to a new PeopleSoft release, the agency will also need
    space for two additional copies of their database. A good rule of
    thumb is to initially oversize the storage media rather than
    undersize it.

-   **Batch Server***.* The batch server runs the PeopleSoft batch
    processes. The term *batch server* is equivalent to the term
    *Process Scheduler* server. The batch server is where the Process
    Scheduler is installed and configured, and it is the location where
    many of the batch programs will run, such as Application Engine
    programs. In most situations this is also where the COBOL and SQR
    executables are installed. PeopleSoft batch processes, such as COBOL
    and SQR, are scheduled and invoked by a Process Scheduler server.
    The batch server maintains connectivity to the database.

-   **Application Server***.* The PeopleSoft Internet Application Server
    consists of the web server and the application server. The
    application server is designed to improve performance over a wide
    area network (WAN) as well as to permit communication between the
    end user workstation (via the web server) and the database. The
    application server runs on UNIX or Linux platforms. It needs ample
    disk space for BEA Tuxedo, PeopleSoft application server files,
    COBOL, SQR, and database connectivity. The application server should
    be a powerful machine with as much memory as possible to ensure
    optimum performance. The PeopleSoft application server uses BEA's
    Tuxedo middleware product, which is designed to enable distributed
    application computing. In addition, it uses BEA's Jolt, which acts
    as the communications layer between the web server and the
    application server. The application server interprets Jolt messages
    coming from the web server into SQL, which it sends to the database
    server. Thus, SQL always takes place between the application server
    and the database server using a high-speed connection such as a
    local area network (LAN) or InfiniBand, avoiding costly
    transmissions across WANs or lower bandwidth Internet connections.

-   **Web Server***.* A web server is required for the PeopleSoft
    Internet Architecture. It serves as the link between the end user's
    workstation and the application server, with which it communicates
    via BEA's Jolt. This server also stores the PeopleBooks and context
    sensitive help.

-   **Report Server***.* A report server is needed to handle PS/nVision,
    Crystal Reports and/or Cube Manager. The report server requires
    Windows 2000 or Windows XP machines.

-   **Auxiliary Hardware/Software***.* Extra hardware and software for
    optional PeopleSoft functionality and/or to support the application
    the agency is running; for example, the report server or additional
    server for the MCE.

-   **Mobile Computing Equipment.** Users will be able to enter payroll
    data and transfer information between PeopleSoft and the MCE. The
    MCE will run a version of the Census Timesheet (D308).

**Note.** The various servers identified above (application, web, and so
on) are considered "logical" servers. Many can exist on the same
machine, although each can also reside on its own machine in a
"physical" configuration.

As follows are some general guidelines about using PeopleSoft 8 on the
Wide Area Network (WAN).

-   **Bandwidth Utilization***.* PeopleSoft applications can support
    roughly 10 users per 56kb of bandwidth. The main determinant of
    exactly how many users can be supported is how fast those users do
    their work. If they type quickly and hit many pages, they use more
    bandwidth. PeopleSoft has found based on average usage patterns of
    average applications, 10 users can perform well with 56kb of
    bandwidth.

-   **WAN Response Time***.* PeopleSoft applications will generally
    perform acceptably down to a connection speed of 24.4kb. They
    perform well or "near LAN" on connection speeds of 128kb or higher.
    Using PeopleSoft products on the WAN or LAN makes no difference to
    the CPU or memory requirements on the various servers.

## PeopleSoft Architecture Hardware and Software Requirements

The following subsections describe the minimum hardware and software
requirements for running PeopleSoft applications over the Internet,
including sizing guidelines where applicable.

### End User Workstation Requirements

The PeopleSoft Internet Architecture leverages the PeopleTools
application server to dynamically generate Internet applications that
are built in the Application Designer. The PeopleSoft Internet
Architecture is not a retrofitted PeopleTools Windows client built to
run on the World Wide Web, but instead is rich with web-specific
features and design paradigms. It provides dynamic hyperlinks, image
support, and user customizable HTML tags, enabling the user to build
applications that look and feel like a modern web site. The PeopleSoft
Internet Architecture customizations are all done through PeopleTools
and therefore are upgradeable and fully global, supporting multilingual
and multicurrency operations.

**No end user installation is required; no PeopleSoft software resides
on the end user workstation. The browser is all that is needed.**

#### End User Workstation Hardware Requirements

The following end user workstation requirements are based on power user
type operations such as intensive data-entry, navigating between many
pages, and so on. Because these requirements stem from real-world
scenarios as well as DAPPS requirements, they are higher than the
manufacturer's minimum for a given web browser and operating system
combination. However, PeopleSoft products will function on platforms
meeting the manufacturer's minimum requirements for a given web browser
and operating system combination, but will not deliver the optimal user
experience.

General end user workstation hardware requirements are as follows:

-   256 MB RAM recommended (64 MB RAM minimum)

-   800 MHz Pentium or equivalent processor (Pentium 166 MHz minimum)

-   VGA controller and display of 800x600 resolution or higher and High
    Color (16 bit) mode for the best display results

In the PeopleSoft Internet Architecture, the web browser renders the
user interface. The web browser receives the HTML generated by the
application server and displays the graphic representation of the HTML.
The CPU speed of the client has a great influence on how fast these HTML
pages are rendered. HTML pages for some PeopleSoft applications can be
quite complicated. The web browser should be configured to take
advantage of the HTTP 1.1 Protocol and should also allow adequate disk
space for HTML object caching.

Memory Requirements:

For an optimal user experience, a power user should have a system with
256 MB RAM. A minimum of 64 MB RAM on the client is required for all
power user applications. This assumes that a typical power user will run
three browsers (two for transactions, one for process monitor). The
browser instances use 10 MB of memory each. A self-service end user
would only need minimum memory to run their operating system plus one
instance of their web browser.

CPU Requirements:

CPU speed affects HTML page rendering and refresh time. For an optimal
user experience, all power users should have an 800 MHz Pentium or
equivalent processor with a decent graphics adapter. Users will not see
much improvement with CPUs faster than 800 MHz.

Screen Resolution Requirements:

Monitor display resolution should be set to a minimum of 800x600 pixels.
To enrich the power user's experience, some PIA pages use a higher
resolution, such as 1024x768 pixels.

#### End User Workstation Software Requirements

Based on PeopleSoft testing, Internet Explorer is the clear leader in
performance and user interface quality. For the functional user, where
performance and reliability are crucial, Internet Explorer version 6 is
the recommended web browser running on Windows 2000 or Windows XP.

Basic end user workstation software requirements are as follows:

-   Recommended browser is Internet Explorer 6.

-   PeopleSoft recommends that customers use Excel 2000 or higher on the
    Report Server.

### Web Server Requirements

The web server performs little logic. It simply relays data back and
forth between the user workstation and application server. The web
server handles encryption and manages the connections between the
browsers. It also caches and serves up images. For the PeopleSoft
Internet Architecture, most of the PeopleSoft logic occurs on an
application server---this is where pages are run and HTML is generated.
This architecture should yield high performance on the WAN, because it
only sends HTML to the client workstation.

#### Web Server Hardware Requirements

The web server does not do a lot of processing; however, because it is a
server it should run on a multiprocessor machine with fast processors.

-   256 MB of memory or higher is recommended for each web server.

-   Disk space is needed for the software itself and for the caching of
    images, JavaScripts, and style sheet files.

-   Disk space is also needed for the report repository. The size will
    depend on how often older reports are removed.

-   PeopleSoft web servers tend to use a very high number of execute
    threads, file descriptors, and TCP sockets. Proper tuning in these
    areas is required.

The web server memory requires a minimum of 512MB for roughly 25 users.
After that add .5 MB per user for each user beyond 25 users. Therefore,
1,000 users require roughly 1.0 GB of web server memory.

#### Web Server Software Requirements

The following web server and Java servlet combinations are supported
with PeopleTools 8.45:

Web Servers:

-   BEA WebLogic Server

-   IBM WebSphere Server

Optional Reverse Proxy Servers (HTTP Servers):

-   Sun ONE (formerly iPlanet) Web Server, Enterprise Edition

-   Apache (WebLogic only)

-   IBM HTTP Server (HIS) (WebSphere only). Packaged with WebSphere
    install.

PeopleSoft will support WebLogic and WebSphere web servers across the
following operating systems:

-   HP-UX PA Risc

-   AIX

-   Solaris

-   RedHat Linux Advanced Server

-   Tru64 (only WebLogic is supported)

### File Server Requirements

The file server is the environment (or file) repository for the
PeopleTools Development Environment and for the files necessary to
perform an upgrade or customization.

In addition, the file server is a source repository for COBOL and SQR.

#### File Server Hardware Requirements

A typical file server configuration requires the following items:

-   Pentium-based computers running NetWare, or Windows 2000. Or, UNIX
    machines that support NFS or comparable networking software.

-   Sufficient disk space to accommodate the following:

```{=html}
<!-- -->
```
-   PeopleSoft software---2.5 to 3 GB per PeopleSoft environment,
    depending on the application(s)

-   Network operating system and associated files

-   Other application files (such as Microsoft Office)

```{=html}
<!-- -->
```
-   Sufficient memory to meet the network operating system requirements.
    PeopleSoft recommends maximizing the amount of memory on the file
    server to ensure optimum performance.

-   VGA video controller and display (800x600 or higher resolution and
    256 colors required).

-   Network interface card.

-   Backup system.

#### File Server Software Requirements

Network operating system such as NetWare or Windows 2000, may be
dictated by RDBMS selection which in this case the agency's RDBMS is
Oracle.

### Database Server Requirements

The database server housing the DAPPS database is Oracle as the RDBMS.

#### Database Server Hardware Requirements

The following are database server hardware requirements:

-   Sufficient disk space to accommodate:

```{=html}
<!-- -->
```
-   Oracle RDBMS software and all requisite products.

-   Operating system (Linux or Unix).

-   The production database server, which must accommodate the operating
    system, several production instances (including production,
    training, and hot spare), all log files, exports, and hot backups.

-   The development database server needs to include demo, development,
    all testing instances, and staging.

```{=html}
<!-- -->
```
-   Backup device.

-   Video controller and display.

-   Appropriate network interface card and cabling to connect to
    network.

-   Uninterruptible power supply (UPS) with sufficient capacity to allow
    an orderly shutdown of the database server and operating system in
    the event of a power failure (optional, but recommended).

#### Database Server Software Requirements

The following are database server software requirements:

-   Oracle RDBMS software and all requisite products

-   Operating system

-   Compilers

-   Supported SQL query tool

-   Any required network connectivity software

### Process Scheduler (Batch) Server Requirements

PeopleSoft batch processes, such as COBOL and SQR, are scheduled and
invoked by a Process Scheduler server. Any computer operating, as a
batch server must have database connectivity installed so that it can
make a two-tier connection to the PeopleSoft database. Also, the Process
Scheduler on UNIX cannot execute Windows-specific batch processes, such
as Crystal Reports, nVision reports, Microsoft Word, or Cube Manager
(Essbase, PowerPlay). Therefore, with UNIX-based databases there will be
a need to set up a Process Scheduler environment on a Windows
application server or on a dedicated Windows workstation. UNIX Process
Schedulers can still be used for Application Engine, COBOL, and SQR
processing.

#### Process Scheduler Server Hardware Requirements

The following are Process Scheduler server hardware requirements:

-   Sufficient disk space to accommodate one of the following operating
    systems:

```{=html}
<!-- -->
```
-   Intel (Windows)

-   Intel (Linux)

-   HP (HP-UXPARisc)

-   IBM (AIX)

-   Sun (Solaris)

-   Compaq (Tru64)

```{=html}
<!-- -->
```
-   Backup device

-   Video controller and display.

-   Appropriate network interface card and cabling to connect to
    network.

#### Process Scheduler Server Software Requirements

The following are Process Scheduler server software requirements:

-   RDBMS connectivity software

-   Operating system and the appropriate COBOL compiler to support the
    Payroll COBOL programs

-   Appropriate C compiler (only if the RDBMS requires C
    compilers---Oracle, for instance)

-   Supported SQL query tool

-   Any required network connectivity software

-   PeopleSoft recommends that customers use Excel 2000 or higher on the
    Report Server.

### Application Server Requirements

The application server serves as an intermediary between the user
workstation and the database server. It connects to the PeopleSoft
database and handles almost all SQL-intensive interaction with the
database server required during online transaction processing. The
application server interacts with the end user workstation (which only
needs a supported browser) via the web server. The application server
also provides functionality required for application messaging and for
implementing the PeopleSoft Internet Architecture.

When installing a UNIX-based RDBMS such as Oracle for UNIX, the
application server can be installed on the same machine as the database
server, a configuration called *logical three-tier*. The application
server can also be installed on one or more separate UNIX or Windows
machines. This configuration is called *physical three-tier*. If the
offeror uses a physical three-tier option, the offeror should plan to
connect the application server to the database using the highest
bandwidth connection available.

In all cases for the application server, PeopleSoft recommends using the
most RAM and processing speed available to take full advantage of the
three-tier configuration. Also consider that to attain desirable
performance, memory must be appropriate for the volume of users. For
instance, the application server requires a minimum of 512MB for roughly
25 users. For additional users, add 1.5 MB per user. Therefore, to
accommodate 1,000 users, the application server requires roughly 2.0 GB
of memory.

#### Application Server Hardware Requirements

The following are UNIX/Linux application server hardware requirements:

-   Sufficient disk space to accommodate:

```{=html}
<!-- -->
```
-   BEA Tuxedo (200 MB).

-   COBOL Compiler (50 -- 70 MB).

-   Database connectivity package varies per platform; check with
    vendor.

-   PeopleSoft application server files (3 GB).

```{=html}
<!-- -->
```
-   Memory requirements depend on the deployed applications, because
    each application has a different memory footprint. For example, CRM
    uses about 100 MB for each PSAPPSRV process, while Financials uses
    about 300 MB per process. The minimum memory configuration for an
    application server domain should be 1 GB. For high volume systems,
    the memory configuration should be 4 GB.

See PeopleSoft Customer Connection, Platforms Supported.

#### Application Server Software Requirements

The following are UNIX application server software requirements:

-   A UNIX application server must be running one of the following
    operating systems:

```{=html}
<!-- -->
```
-   Sun/Solaris

-   HP/HP-UXPARisc

-   IBM/AIX

-   TRU64

-   Linux

```{=html}
<!-- -->
```
-   BEA Tuxedo

-   COBOL Compiler (Micro Focus ServerExpress)

-   Database connectivity package

-   PeopleSoft application server files

-   Any required application server patches

-   FTP capability. (The delivery mechanism for PeopleSoft "patches" and
    other PeopleSoft maintenance files are an FTP server.)

See PeopleSoft Customer Connection, Platforms Supported.

## DAPPS Current Architecture

### Hardware

The DAPPS PeopleSoft database environment is a thin-client architecture
distributed across several servers to which headquarters and field
offices securely connect via the Census Bureau's wide area network
(WAN), which is not accessible to the public. The following diagrams
illustrate the DAPPS Production and Development architecture.

![](media/image5.png){width="6.698611111111111in"
height="8.094444444444445in"}

![](media/image6.png){width="6.698611111111111in"
height="5.385416666666667in"}

### Software

This section describes the commercial off-the-shelf (COTS) PeopleSoft
products and other software development tools used to develop and
operate the subsystems, components, and modules of DAPPS. The core
software products are the Federal HRMS, Time & Labor and North American
Payroll components from PeopleSoft. The following table provides a
listing of the DAPPS software that is applicable to both Development and
Production environments.

+--------------------------+-------------------------------------------+
| **PeopleSoft Software:** |                                           |
+--------------------------+-------------------------------------------+
| Base application release | PeopleSoft Federal HRMS, Time & Labor and |
|                          | North American Payroll 8.8 SP1            |
+--------------------------+-------------------------------------------+
| Tools release            | PeopleTools 8.45.11                       |
+--------------------------+-------------------------------------------+
| Products in development  | HRMS                                      |
| and production           |                                           |
|                          | Time & Labor and                          |
|                          |                                           |
|                          | North American Payroll                    |
+--------------------------+-------------------------------------------+
| Additional products      | Self-Service modules: ePay, eRecruit, and |
| licensed                 | eProfile;                                 |
|                          |                                           |
|                          | Enterprise Portal and HRMS add-on portal  |
|                          | pack;                                     |
|                          |                                           |
|                          | Enterprise Performance Management (EPM);  |
|                          |                                           |
|                          | Data warehouse;                           |
|                          |                                           |
|                          | Mobile Agent                              |
+--------------------------+-------------------------------------------+
| Number of users          | Approximately 50 users for the 2006       |
|                          | Census Test and Approximately 8,000 for   |
|                          | the 2010 Census.                          |
+--------------------------+-------------------------------------------+

  -------------------------------- --------------------------------------
  **PeopleSoft Supplied Vendor     
  Software:**                      

  Client SQR                       4.3

  Development and Production       4.3.4
  Server SQR                       

  Development and Production       MicroFocus 2.2 SP1
  Server Cobol                     

  Development and Production       8.1 SP2
  WebLogic                         

  Development and Production       6.5
  Tuxedo                           

  Development and Production Jolt  1.2

  Crystal Reports                  8.0
  -------------------------------- --------------------------------------

  --------------------------------------- -------------------------------
  **Other Vendor Software:**              

  Client O/S                              Windows 2000 or Windows XP

  Web Browser                             Internet Explorer 6.0.x

  Database Connectivity                   SQLNet 2.3

  Client Cobol                            None

  Microsoft Office                        2000

  Development and Production Application  RedHat ES 2.1
  Server O/S                              

  Development and Production File Server  NetWare 5.1
  O/S                                     

  Development and Production File Client  Netware 4.9 SP1a
  O/S                                     

  Development and Production Database     Compaq TRU64 UNIX 5.1b PK 5
  Server O/S                              

  Development and Production RDBMS        Oracle 9.2.0.5

  Configuration Management Software       Stat 5.0.4
  --------------------------------------- -------------------------------

#  Performance Measures

High-level performance measures for DAPPS include the ability to
complete a payroll in 1 hour. The interactive portions of the system
must respond almost instantly in a manner that does not delay user
interaction. Reports are generated on the basis of user needs; the
timeliness of the reports is measured according to whether they are
still useful when received.

The following specific performance measures for DAPPS have been
identified:

-   Average time to process[^1] D-308 (Daily Pay and Work Record)
    payroll form: 61 seconds.

-   Average time to process BC-170 (Census Employment Inquiry) form: 5
    minutes per employee.

-   Regional earnings statement submitted by all RCCs to National
    Processing Center electronically, and ready to be handed over to
    employees within 3 days.

-   Weekly submission of Applicant Reports, Administrative Reports,
    Office of Personnel Management Reports, and Treasury Reports.

In addition, specific performance measures have been identified for the
interaction between DAPPS and CHEC:

-   Unscheduled nonavailability of CHEC less than 2 hours of production
    time per week.

-   Case status provided to the field within 24 hours of receipt from
    the FBI.

-   Ability to accommodate 40 concurrent users.

-   Database capacity: 6 million names.

-   Interactive response time of the system: less than 30 seconds.

# Decennial Workloads

The following table shows the 2000 Census decennial workloads per pay
period from 1997 through 2000. These workloads will be similar from 2007
through 2010 with an expected growth of 10%.

Also noteworthy for the DAPPS workload is that an average of 1000
D-308\'s and 200 BC-I70\'s per day were processed by LCOs at peak levels
during the 2000 Census. Regarding the interaction between DAPPS and
CHEC, the maximum number of names to process per day was between 93,000
and 100,000.

  -------------------------------------------------------------------------------------
  **Decennial                                                           
  workloads for                                                         
  2000 Census per                                                       
  pay period from                                                       
  1997 through                                                          
  2000**                                                                
  --------------- -------------------- --------------- ---------------- ---------------
  **Pay Period    **Distinct Employees **Chk/Eft       **D308\'s        **Applicant
  End Date**      Paid per Pay         Count**         Keyed**          Count**
                  Period**                                              

  3/29/1997       87                   87              301              158

  4/5/1997        108                  120             477              184

  4/12/1997       110                  134             486              211

  4/19/1997       271                  304             1147             230

  4/26/1997       301                  347             1359             263

  5/3/1997        262                  304             1162             270

  5/10/1997       222                  234             914              271

  5/17/1997       134                  148             525              274

  5/24/1997       53                   54              128              274

  5/31/1997       16                   17              31               277

  6/7/1997        8                    13              16               277

  6/14/1997       1                    1               1                277

  6/21/1997       4                    4               4                277

  6/28/1997       2                    4               4                277

  7/5/4997        0                    0               0                277

  7/12/1997       0                    0               0                277

  7/19/1997       0                    0               0                277

  7/26/1997       0                    0               0                279

  8/2/1997        2                    2               3                287

  8/9/1997        6                    6               19               287

  8/16/1997       6                    6               18               287

  8/23/1997       8                    11              33               294

  8/30/1997       6                    7               18               337

  9/6/1997        6                    6               14               383

  9/13/1997       4                    4               9                403

  9/20/1997       10                   11              34               513

  9/27/1997       8                    8               32               556

  10/4/1997       8                    9               23               711

  10/11/1997      7                    8               22               751

  10/18/1997      5                    5               12               1218

  10/25/1997      4                    4               10               1317

  11/1/1997       4                    6               13               1375

  11/8/1997       2                    2               3                1487

  11/15/1997      2                    3               6                1584

  11/22/1997      7                    7               15               1627

  11/29/1997      8                    8               16               1699

  12/6/1997       31                   32              121              1828

  12/13/1997      178                  182             543              1885

  12/20/1997      173                  177             671              1959

  12/27/1997      162                  222             537              1981

  1/3/1998        153                  200             646              2001

  1/10/1998       140                  164             578              2080

  1/17/1998       127                  157             521              2232

  1/24/1998       112                  151             476              2532

  1/31/1998       101                  131             433              2688

  2/7/1998        91                   115             397              3215

  2/14/1998       109                  143             504              3793

  2/21/1998       120                  137             466              4259

  2/28/1998       160                  176             688              5208

  3/7/1998        132                  143             623              6115

  3/14/1998       330                  349             1458             6922

  3/21/1998       342                  380             1553             7955

  3/28/1998       437                  492             1854             9093

  4/4/1998        518                  566             1888             10549

  4/11/1998       449                  497             1602             12314

  4/18/1998       834                  926             2756             14203

  4/25/1998       637                  759             2247             15939

  5/2/1998        876                  1022            3411             17659

  5/9/1998        858                  1067            3545             19552

  5/16/1998       2834                 2983            13070            22543

  5/23/1998       2658                 3416            11464            24602

  5/30/1998       2685                 4064            12131            26827

  6/6/1998        2915                 4398            15793            30246

  6/13/1998       2612                 3406            12558            34434

  6/20/1998       2184                 2790            9907             39737

  6/27/1998       2146                 2676            9477             47287

  7/4/1998        1676                 2042            6591             52370

  7/11/1998       2206                 2660            10587            60820

  7/18/1998       2526                 3111            12179            69243

  7/25/1998       3581                 4253            15722            79603

  8/1/1998        9159                 10922           38218            89311

  8/8/1998        11059                16286           52532            98380

  8/15/1998       12059                17470           52566            110609

  8/22/1998       11448                17109           50763            126309

  8/29/1998       10408                15551           42757            143887

  9/5/1998        9741                 15796           41979            160699

  9/12/1998       8124                 12855           34650            174814

  9/19/1998       7667                 10389           32913            193944

  9/26/1998       6817                 9581            29061            208030

  10/3/1998       7144                 9695            28185            221582

  10/10/1998      17692                22352           65496            236634

  10/17/1998      23059                36533           105836           250209

  10/24/1998      25255                43338           124847           262458

  10/31/1998      25959                41949           113900           275949

  11/7/1998       31889                48663           147236           286993

  11/14/1998      30682                44295           135020           295925

  11/21/1998      27944                40454           120606           306947

  11/28/1998      22933                33432           86555            314258

  12/5/1998       28988                36892           82597            323904

  12/12/1998      21805                30575           63478            334279

  12/19/1998      13289                20151           50069            346156

  12/26/1998      7425                 10253           24187            353924

  1/2/1999        5904                 8247            20498            365461

  1/9/1999        6055                 7809            25157            382629

  1/16/1999       11545                13193           42409            402396

  1/23/1999       14790                20355           68846            424318

  1/30/1999       16697                23928           80818            451708

  2/6/1999        17116                24124           78909            482267

  2/13/1999       17068                22886           70472            520895

  2/20/1999       17565                24056           71008            553861

  2/27/1999       26425                32442           104589           587910

  3/6/1999        27728                37231           123733           622058

  3/13/1999       28902                40637           129752           649424

  3/20/1999       26406                37462           115450           672493

  3/27/1999       19677                25940           79266            690069

  4/3/1999        15528                19647           59883            705134

  4/10/1999       17390                21015           70949            718492

  4/17/1999       15967                19917           68455            726216

  4/24/1999       13571                17358           56070            731615

  5/1/1999        9076                 11641           35439            735749

  5/8/1999        5359                 6601            19439            740887

  5/15/1999       3896                 4507            12304            744957

  5/22/1999       3299                 3695            10332            748812

  5/29/1999       4041                 4766            13776            752688

  6/5/1999        5499                 6516            18422            755108

  6/12/1999       7129                 8129            26868            758000

  6/19/1999       6731                 7957            26993            761532

  6/26/1999       9293                 9871            14460            765591

  7/3/1999        5419                 5822            12819            768578

  7/10/1999       3317                 3757            10354            770205

  7/17/1999       3606                 4047            12145            772557

  7/24/1999       4849                 5193            14713            775274

  7/31/1999       5490                 5944            16149            778522

  8/7/1999        6046                 6536            18217            781196

  8/14/1999       7098                 7620            22647            783843

  8/21/1999       9121                 10019           31816            786910

  8/28/1999       11321                12570           41861            789083

  9/4/1999        13785                15393           51049            791738

  9/11/1999       13933                16895           51467            793544

  9/18/1999       13275                15995           52933            796622

  9/25/1999       11247                13465           44491            800533

  10/2/1999       9592                 11202           36910            804128

  10/9/1999       7817                 9385            32471            808346

  10/16/1999      7586                 9466            30507            812364

  10/23/1999      7448                 9052            31777            818270

  10/30/1999      8168                 9533            33236            824366

  11/6/1999       8820                 10573           36788            831789

  11/13/1999      8745                 10513           34577            839916

  11/20/1999      8738                 10194           36591            854174

  11/27/1999      8464                 10094           30398            866943

  12/4/1999       9899                 11525           43467            887021

  12/11/1999      11306                12864           50190            922012

  12/18/1999      13075                14550           56682            971860

  12/25/1999      13822                15537           50471            1015881

  1/1/2000        14770                16686           54944            1056109

  1/8/2000        17807                19286           80502            1119294

  1/15/2000       21327                23049           96248            1244857

  1/22/2000       24975                27535           104064           1394001

  1/29/2000       29019                31713           126871           1561741

  2/5/2000        33888                36926           150491           1756442

  2/12/2000       39536                42802           177751           1937716

  2/19/2000       47886                51781           208624           2131266

  2/26/2000       64727                69699           238143           2289783

  3/4/2000        120149               128640          524482           2452663

  3/11/2000       133230               152433          595262           2639558

  3/18/2000       138717               159449          585121           2869067

  3/25/2000       143160               162174          540923           3054938

  4/1/2000        148659               167715          557927           3197640

  4/8/2000        125541               142700          503567           3296373

  4/15/2000       151436               167992          616017           3368867

  4/22/2000       182865               199106          663589           3427868

  4/29/2000       464014               486179          1792952          3471676

  5/6/2000        496656               587605          2261653          3518527

  5/13/2000       512602               627699          2448471          3557740

  5/20/2000       507455               605421          2330780          3597693

  5/27/2000       480898               573111          2152287          3630999

  6/3/2000        406632               489394          1708001          3651588

  6/10/2000       312529               355196          1267668          3668699

  6/17/2000       186788               213355          690403           3678390

  6/24/2000       121356               135149          373934           3684439

  7/1/2000        165637               176730          545974           3690021

  7/8/2000        183712               206200          690175           3692758

  7/15/2000       187394               201236          740025           3695995

  7/22/2000       125956               138154          491549           3698016

  7/29/2000       88662                97117           329678           3699723

  8/5/2000        57319                63579           227873           3702201

  8/12/2000       35941                39562           127939           3704603

  8/19/2000       25145                28280           89777            3706456

  8/26/2000       20599                22929           71805            3707161

  9/2/2000        13409                14923           46416            3708249

  9/9/2000        6382                 7391            19560            3708488

  9/16/2000       3282                 3772            10464            3708499

  9/23/2000       2037                 2444            7085             3708524

  9/30/2000       1481                 1771            5088             3708608

  10/7/2000       1512                 1725            4877             3708608

  10/14/2000      2066                 2351            5917             3708608

  10/21/2000      4771                 5101            13397            3708608

  10/28/2000      4303                 4876            15395            3708608

  11/4/2000       5050                 6271            22078            3708609

  11/11/2000      3752                 4693            15071            3708609

  11/18/2000      2229                 2699            6612             3708610

  11/25/2000      1129                 1296            1749             3708610

  12/2/2000       852                  993             1614             3708610

  12/9/2000       456                  557             1100             3708610

  12/16/2000      244                  298             595              3708610

  12/23/2000      147                  194             554              3708610

  12/30/2000      168                  215             484              3708610

  1/6/2001        432                  529             1486             3708610

  1/13/2001       1102                 1204            4453             3708610

  1/20/2001       1980                 2239            9019             3708610

  1/27/2001       2140                 2519            10417            3708610

  2/3/2001        1599                 1959            6526             3708610

  2/10/2001       940                  1126            2713             3708610

  2/17/2001       483                  575             1033             3708610

  2/24/2001       258                  287             437              3708610

  3/3/2001        150                  184             415              3708610

  3/10/2001       253                  274             655              3708610

  3/17/2001       452                  498             1514             3708611

  3/24/2001       983                  1026            2718             3708611

  3/31/2001       943                  1018            2935             3708611

  4/7/2001        1094                 1220            3581             3708611

  4/14/2001       922                  1053            2905             3708611

  4/21/2001       555                  629             1454             3708611

  4/28/2001       257                  294             639              3708611

  5/5/2001        161                  182             299              3708611

  5/12/2001       115                  130             219              3708611

  5/19/2001       319                  349             1028             3708611

  5/26/2001       375                  449             1369             3708611

  6/2/2001        321                  432             1135             3708611

  6/9/2001        230                  274             696              3708617

  6/16/2001       132                  170             432              3708620

  6/23/2001       53                   64              182              3708622

  6/30/2001       40                   46              134              3708623

  7/7/2001        27                   28              66               3708623

  7/14/2001       45                   56              217              3708624

  7/21/2001       145                  151             533              3708624

  7/28/2001       839                  862             2203             3708624

  8/4/2001        1166                 1225            3485             3708624

  8/11/2001       1483                 1783            6694             3708624

  8/18/2001       1441                 1823            6644             3708624

  8/25/2001       1017                 1296            4293             3708624

  9/1/2001        652                  725             1715             3708624

  9/8/2001        610                  689             1227             3708624

  9/15/2001       520                  617             1459             3708624

  9/22/2001       587                  660             1600             3708624

  9/29/2001       678                  758             1973             3708624

  10/6/2001       573                  661             1858             3708624

  10/13/2001      858                  924             2299             3708624

  10/20/2001      1123                 1308            5485             3708624

  10/27/2001      842                  1019            3589             3708624

  11/3/2001       392                  433             985              3708624

  11/10/2001      449                  469             681              3708624

  11/17/2001      125                  139             211              3708624

  11/24/2001      25                   30              40               3708624

  12/1/2001       16                   17              30               3708624

  12/8/2001       33                   45              66               3708624

  12/15/2001      15                   22              30               3708624

  12/22/2001      0                    0               0                3708624

  12/29/2001      0                    0               0                3708624

  1/12/2002       1                    1               0                3708624

  1/26/2002       3                    3               0                3708624

  2/23/2002       1                    1               0                3708624

  3/30/2002       1                    1               0                3708624

  4/6/2002        2                    2               0                3708624

  5/11/2002       1                    4               0                3708624

  5/25/2002       1                    5               0                3708624

  6/8/2002        1                    1               0                3708624

  7/27/2002       2                    2               0                3708624

  8/3/2002        1                    1               0                3708624

  5/3/2003        1                    7               0                3708624

  **Total:**      **6,892,187**        **8,060,736**   **28,465,629**   **3,708,624**
  -------------------------------------------------------------------------------------

**Note**: Total number of records in the applicant table for all
regions: 16,811,181.

  ------------------------- ---------------------------------------------
  **Number of Distinct      
  Employee\'s Hired**       

  1997                      534

  1998                      72696

  1999                      80607

  2000                      811435

  2001                      37

  **Total**                 **965,309**

                            

  **Number of Distinct      
  Employee\'s Hired or      
  Rehired**                 

  1997                      534

  1998                      72868

  1999                      94079

  2000                      851750

  2001                      2374

  **Total**                 **1,021,605**

                            

  **Count of all            
  Hire/Rehire Actions (Same 
  employee could have been  
  hired and rehired         
  multiple times)**         

  1997                      615

  1998                      73266

  1999                      110128

  2000                      865280

  2001                      2505

  **Total**                 **1,051,794**
  ------------------------- ---------------------------------------------

  ---------------------------------- ------------------------------------
  **Count of all HR Actions          
  (Includes hire, rehire, transfer,  
  data change, termination,          
  cancellations and corrections to   
  any of the previous)**             

  **Regions**                        **Hire Actions**

  Atlanta                            292034

  Boston                             246682

  Denver                             198865

  Charlotte                          355904

  Dallas                             253257

  New York                           196066

  Philadelphia                       240710

  Detroit                            224736

  Chicago                            234300

  Kansas City                        240297

  Seattle                            306306

  Los Angeles                        190070

  Total                              2,979,227
  ---------------------------------- ------------------------------------

#  References

-   *DAPPS* (previously known as CAPPS) *Security Plan*.

-   *PeopleSoft's eBusiness Architecture Assessment for the Bureau of
    the Census*, November 2001.

-   *PeopleSoft's Enterprise PeopleTools 8.45 Hardware and Software
    Requirements*, June 2004.

-   PeopleSoft Customer Connection (www.peoplesoft.com) for up-to-date
    information:

```{=html}
<!-- -->
```
-   *PeopleSoft Platforms Supported*. Here you can find up-to-the-minute
    information on our certified database and operating system
    configurations. The PeopleSoft Platforms Supported information
    should serve as your definitive resource for supported products and
    their version numbers.

-   *Third-Party Patches*. This document contains all required third
    party patches.

-   *The Hardware and Software Requirements Guide*. This document
    contains all the Hardware and Software requirements associated with
    the PeopleTools and PeopleSoft Applications being installed or
    upgraded.

-   *Release Notes.* These are documentation updates delivered with
    every PeopleTools maintenance release that explain new features and
    changes, and summarize resolved incidents (fixes).

-   *Upgrade Information*. To find tools and instructions for performing
    upgrades from previous PeopleTools versions.

-   *Installation Documentation*. For a list of installation guides and
    notes for any products.

```{=html}
<!-- -->
```
-   PeopleSoft Connect 2004 User Conference Presentations:

```{=html}
<!-- -->
```
-   *Deep Dive PeopleSoft Clustering*

-   *iSeries Clustering: Replication and IASP*

```{=html}
<!-- -->
```
-   PeopleSoft Red Papers:

```{=html}
<!-- -->
```
-   *PeopleSoft Internet Architecture--Frequently Asked Questions*,
    April 2002.

-   *Configuring Oracle9i Real Application Clusters for PeopleSoft 8*,
    September 2003.

-   *PeopleSoft Internet Architecture: Universal Access Technology*,
    August 2001.

-   *Clustering and High Availability for PeopleSoft 8.4*, June 2002.

-   *PeopleSoft 8 Batch Performance on Oracle 9i Database*, December
    2004.

-   *Online Performance Configuration Guidelines for PeopleTools 8.44*,
    February 2004.

[^1]: Process time is the elapsed time from when the keying of data
    starts to when the screen is refreshed.