SR-03-28-1978-11EAgenda Item 11 -E: Presented at this time was a recommendation for
upgrading of the data processing system to maintain present levels of
productivity and accommodate emerging requirements. Discussion ensued
regarding the presently overloaded situation in regard to computer use,
efficiencies that would result from the upgrading and increased computer
capacity related to down time. Councilmember van den Steenhoven moved
to approve the transfer of funds, $10,000 from Account 31 -S0 - 31 -00 -70 ,
$15,000 from Account #01- 000 - 223 - 000 -100 and $15,000 from Account
#01- 100 - 223 - 000 -100; direct the City Manager to waive the bid process;
and to award Contract No. 2493(CCS)`for acquisition of a Hewlett -
Packard Standard upgrade of the City's data processing computer system
at a price not to exceed $40,000 by issuance of P. 0. No. 36154. Second
by Councilmember Bambrick.
Council Vote: Affirmative: Councilmembers Bambrick, Cohen, Scott,
Trives, van den Steenhoven, Swink
Negative: Councilmember Reed
CITY COUNCIL MINUTES - March 28, 1978
Santa Monica, California, March 20, 1978
To: Mayor and City Council
From: City Staff
Subject: Computer Productivity Upgrade
Introduction
M
MAR 2 8 1976
This report has been prepared to advise Council of the current City Data
Processing equipment condition. There is a need to upgrade critical parts of
the computer in order to maintain present levels of productivity and
accommodate emerging requirements.
Background
A new finance and accounting system was installed in July, 1977. Because this
system was larger and more comprehensive than its predecessor, additional on-
line disc storage was needed and acquired by Council at minimal cost and this
problem has been solved. This report concerns the upgrade of two other components,
the Main Memory and the Central Processing Unit.
Terminology
On -line storage: Data storage space immediately available to the
computer's Main Memory. For example, rotating disc
storage.
Main Memory: Data storage space immediately available to the Central
Processing Unit (CPU) of the computer.
Central Processing Unit: The CPU is the operator portion of the computer.
It actually performs instructions, and is the "heart" of
the computer.
Problem Definition
The amount of work performed by the computer is a function of how fast it
PEAR 2 8 1978
To: Mayor and Council - 2 -
works and how long it is kept running
March 20, 1978
Because of increased demand for
computer resources and time limitations on people resources, the City
computer now must perform more work than it can do within the available time.
Making the computer work faster is a solution to this problem.
Analysis
The speed with which the City computer processes is currently limited by
two electronic components, its Main Memory and its Central Processing Unit.
These components are currently creating a "bottleneck" within the computer
and thereby inhibiting overall Data Processing productivity. (On -line
disc storage was acquired by Council in July, 1977. It has functioned
well and is not a "bottleneck" component.) This "bottleneck" problem
could be eliminated either by replacing the components with faster ones or
running the current components longer.
Running the Computer longer
At present, the City computer operates from 6:00 A.M. to 10:00 P.M.,
five days per week as well as during frequent off -hour and weekend
activity (averaging approximately 20 hours per week). This results in
a total weekly usage of about 100 hours (a week contains 168 hours). Much
work is performed through night processing, whereby the computer is
scheduled to run one job at a time without operator attendance. This
feature has proven invaluable, but is limited by the user imput actually
ready at 5:00 P.M. each day.
No upgrade of equipment would be required if the remaining 68 hours per
week could somehow be utilized. The computer is used for three basic
functions. These are: 1) Routine batch processing 2) Programming and
3) Departmental on -line terminal access. In order to utilize the
To: Mayor and Council - 3 - March 20, 1978
remaining 68 hours, some portion of these three functions must be
performed during that time. Routine batch processing, represents the
major activity and consists largely of key punched input, processing
and report output. Batch processing can and does take place after
5 :00 P.M. and before 8:00 A.M., but is limited to stopping at certain
points for departmental input, error correction or report approval. At
present all accommodation is made to work within the 8 :00 A.M. to 5:00 P.M.
hours of user departments. The night processing limit has been reached in
this area. Programming could take place during these less desireable periods.
This would mean, however, that City Programmer's regular work hours would be
from 10 :00 P.M. to 6 :00 A.M. daily, as well as during some weekend night
hours. On this shift they would be unavailable to assist daily operations
and users, which would radically lower Data Processing productivity. This
might also require a shift differential pay increase to programming staff
to compensate for night work..
Departmental on -line terminal access is direct interaction of user personnel
with data in the computer via a terminal located in their area. At present,
both the Payroll and Accounting Divisions utilize on -line terminal inquiry
into their respective computer files. Use of this function is expected to
expand to other departments, since departmental productivity can be
significantly improved when the normal delays of requesting and receiving
a print -out are eliminated. Of course,, user terminal access cannot occur
during nights and weekends. In order to utilize the remaining 68 hours/
week, then, some very drastic changes would need to occur in the design
of routine batch processing systems and the work schedules both within
Data Processing and within user departments.
To: Mayor and Council - 4 - March 20, 1978
At present all three of these functions are in contention for use of the
computer. This results in almost daily moritoriums on programmer and user
access in order to process routine reports. Each moratorium inhibits
staff productivity. It should be noted that the current computer
system represents an enormous improvement of both quality and quantity
over previous City computers. Data Processing productivity has reflected
this improvement, but has not kept pace with increasing departmental
requirements for automation.
Further expansion of user terminal access and a more accelerated pace
of program development cannot occur, however, without the availability of
more computer time or speed. In view of this analysis, increased speed is
by far the more practical alternative.
Present and.Anticipated Uses
Attachment "A" provides a list of required current uses of the computer.
While it is extensive it is a very basic group of reports and does not
include the more sophisticated systems such as vehicle maintenance or inventory
replacement.
During 1978, City Data Processing would like to provide several new
features to City systems as well as continue to process current systems.
Some of these new features are:
1. Implement of new inventory system which is integated with the new
finance and accounting system.
2. Provide the Accounting Division with on -line data entry, error correction
and reporting for finance system.
To: Mayor and Council - 5 -
March 20, 1978
3. Provide for Urban Mass Transit mandated Bus Transportation Accounting and
Bus Driver's Wage and Time Analysis.
4. Implement complete Water Conservation tracking system.
5. Develop a Police Case Management System.
6. Provide for on -line data entry and reporting of Municipal parking
tickets,
Upgrade Considerations
Replacement of the computer's Main Memory and Central Processing Unit
would improve.the computer's productive capacity by 50 percent. There is
no lesser upgrade available, though several greater upgrade levels
exist through Hewlett Packard. No computer program conversions are required
and no changes to the computer's appearance or peripheral devises is
required. The entire conversion could be accomplished within one weekend and
would not interrupt normal processing. This upgrade will provide enough
computer power to meet all foreseeable needs for at least 2 years.
AlternatiVes
1. Continue with present computer equipment.
Advantages: Disadvantages:
(a) No capital outlay (a) Inhibit user on -line inquiry.
(b) Limit new program development
2. Shift Programming staff hours to night and weekends.
Advantages:
(a) No capital outlay
(b) Gain in program develop-
, I ment and user inquiry
Disadvantages:
(a) Shift differential outlay.
(b) Loss of coordination with Data
Processing and between Data
Processing and the City Depts.
(c) Extreme loss of overall Data
Processing Productivity.
To: Mayor and Council - 6 -
3, Acquire Computer Upgrade,
Advantages:
March 20, 1978
Disadvantages:
(a) Increase overall Data (a) One time capital outlay.
Processing productivity.
(b) Permit unrestricted user inquiry.
(c) Accelerate new system programming
development.
Costs
The upgrade will require a one time capital outlay of $40,000. Funds are
available for this outlay and no additional appropriation is required.
The amounts and account numbers are as follows:
Sewer
Reimbursement of Water
Fund
for Joint Processing
31- 500 -431- 000 -709
$10,000
Urban
Mass Transit Grant *
01 -000- 223 - 000 -100
15,000
Data
Processing salary savings
01- 100 - 223 - 000 -100
15;000
*Data
Processing and Accounting
Division Total:
$40,000
work
on Grant will result in additional
salary savings
Staff Recommendat
That Council direct the City Manager to waive bids and acquire a Hewlett -
Packard standard upgrade (HP 30306A with options 132,200,202, and 501) at
a price not to exceed $40,000.
Prepared by: Edward Fraga
Richard Fuller
Robert Nash
Attachment A
A. Current governmentally required uses of the computer.
1. Federal Government
(a) Employee W -2 Reporting and Income Tax Collection.
(b) Federal Revenue Sharing Grant Accounting.
(c) Community Development Block Grant Accounting.
(d) Economic Development Act Grant Accounting.
(e) Law Enforcement Administration Act Grant Accounting.
(f) Urban Mass Transit Act Reporting.
(g) Equal Employment Opportunity Reporting.
2, State of California
(a) Sales Tax Reporting Input,
(b) Employee W -2 Reporting and Income Tax Collection.
(c) Unemployment Benefit Insurance,
(d) State Controllers Report Input,
(e) Public Employees Retirement System Reports.
(fI Fire Incident Reports to State Fire Marshal.
(g) Department of Motor Vehicles Delinquent Parking Ticket Reporting.
3. Santa Monica City Council
(a) Water Conservation Subsystem
(b) Bargaining Memorandums of Understanding Processing and Reporting
4. Municipal Court
(a) Processing of Parking and Moving Tickets. -
.•;
5, Parking Authority
(a) Expenditure, Revenue and Balance Sheet Reporting.
ALiodnitent A
Page 2
B. Current Departmentally required uses of the computer.
1. Accounting (Number of kinds of reports = 100)
(a) All City Expenditure, Revenue and Balance Sheet Reporting.
(b) All City Purchase Order and Vendor Payment Processing.
(c) All City Warehouse Inventory Processing.
(d) All City Work Order Cost Accounting.
(e) Vehicle Fuel Usage Collection Reporting via Telephone.
2. Payroll /Personnel (Number of kinds of reports = 107)
(a) .City and CETA Payroll Check Processing.
(b) Employee and CETA Pay Record Maintenance.
(c) Labor and Equipment use distribution.
(d) Budget Projections of Personnel Costs.
(e) Special Pays and Deductions Processing.
(f) Sick Leave and Vacation Processing.
(g) Reporting of All Personnel Action Required.
(h) Job _Classification Maintenance and Reporting
(i) Personnel Work Force Analysis Reporting.
3. Utility Billing (Number of kinds of reports = 62)
(a) Water, Sewer and Refuse Bills and Registers.
(b) Reminder, Final and Shutoff Notices.
(c) User Deposit Accounting.
(d) Suspense Accounts Maintenance
(e) Meter Trouble Code Analysis and Reporting.
(f) Water Meter Replacement Reporting.
4. Fire Emergency. Medical Aid System (Total number of types of reports = 6)
(a) EMA Analysis and Reporting.
Atta(_i ant A
Page 3
5. Public Library Number of kinds of reports = 14)
(a) Processing overdue books.
6. Police System (including Parking and Moving Ticket Proc. = 40)
(a) Arrest Disposition Analysis.
(b) Crime Offense Analysis.
(c) Traffic Accident Analysis.
(d) Prosecution Analysis.
At .;hment B
POBAS DATA BASE REPORTS
POB07B -01
Expenditure Budget Worksheet by Organization
POB07B -02
Expenditure Budget Worksheet by Department
POB07B -03
Program Budget Analysis - Program Summary
POB07B -06
Summary Expenditure Budget by Organization
POB07B -07
Detail Expenditure Budget by Organization
POB07B -1A
Program Report - Program Summary
POB07B -1B
Program Report - Program Detail
POB07B -1C
Program Report - Organization Summary
POB07B -1D
Program Report - Organization Detail
POB07B -lE
Object Summary by Program Class
POB07B -1F
Object Summary by Program
POB07C -1G
Program Budget Object Report
POB07B -1L
Object Summary by Organization
POB07B -10
Program Budget Analysis - Program Detail
POB07B -11
Program Budget Analysis - Organization Detail
PBGB7B -12
Program Budget Analysis - Organization Object Detail
POB07B -15
Expenditure Budget by Fund
POB07B -18
Expenditure Master Catalogue
POB07A -20
Administrative Expenditure Guideline Report - by Org. Unit
POB07A -21
Summary Expenditure Guideline Report - by Organizational Unit
POB07A -22
Detail Expenditure Guideline Report - by Organizational Unit
POB07A -23
Detail Expenditure Guideline Report - page break on Organization
POB07A -25
Administrative Expenditure Guideline Report by Source
POB07A -26
Expenditure Guideline Report by Object
POB07A -27
Summary Expenditure Guideline by Object
POB07A -30
Administrative Expenditure Guideline Report by Department
POB07A -31
Summary Expenditure Guideline Report by Program
POB07A -32
Detail Expenditure Guideline Report by Program
POB07A -33
Detail Expenditure Guideline Report by Program - page break on Dept.
POB07A -35
State Expenditure Report
POB07A -36
State Expenditure Summary
POB07A -45
Organization Report - Level 5 (Funds 6, 7, 8)
POB07A -46
Program Report - Level 1
POB07A -47
Program Report - Level 2
POB07A -48
Program Report - Level 3
POB07A -49
Program Report - Level 4
POB07C -50
Inventory on Order
POB07A -51
Zero Balance Inventory (Updates Inventory Master)
POB07A -52
Cycle Physical Inventory (Updates Inventory Master)
POB07C -53
Analysis of Inventory Activity
POB07A -54
Inventory File Listing
PGB07A -55
Inventory Reorder Point
POB07A -56
Supply Catalog Proof List
PGB07C -57
Monthly Stock Status Report
POB07C -58
Annual Stock Status Report
POB07B -60
Revenue Budget Worksheets
POB07B -61
Administrative Revenue Budget
POBO7A -62
Statement of Revenue by Source
POB07A -63
Revenue Summary of Fund
POB07A -64
Source of Revenue by Fund
POB07A -65
State Revenue Report
POB07C -67
Trust Fund Object Detail
J achment B
Page 2
POB07C -68
Trust Fund Object Summary
POB07C -69
Trust Fund Program Summary
POB07C -7A
Work in Process by Organization
POB07C -7B
Work in Process by Foreman
POB07C -7D
Work in Process by Sequence
POB07C -7H
Workorder Master File Listing
POB07A -70
Fund Balance, Asset and Liability Reports
POB07A -71
Balance Sheet Report
POB07A -72
Fund Balance, Asset and Liability Report by Fund
POB07A -73
Balance Sheet Report by Fund
POB07C -74
Workorders - All Funds
POB07A -75
Workorder Sequence Search
PBOB7B -77
Reimbursement Fund Project Summary
POB07B -78
Reimbursement Fund Project Catalogue
POB07A -81
Open Encumbrance Report by Reference Number
POB07A -82
Open Encumbrance Report by Account
POB07A -83
Open Encombrance Report by Vendor
POB07A -85
Open Encumbrance Report by Workorder
POB07B -87
Vendor Activity Analysis by Vendor
POB07B -88
Vendor Lables (Updates Vendor Master)
POB07B -89
Vendor Activity Analysis by YTD Payments
POB07B -91
Disbursement Account Listing by Object
POB07B -92
Disbursement Account Listing by Department
POB07B -93
Disbursement Account Listing by Source
POB07B -94
Disbursement Account Listing by Organization
POB07B -95
Disbursement Code Book with Budgets
POB07B -96
Revenue Account Listing
POB07B -97
Chart of Account Descriptions
POB07B -98
Reporting Level Descriptions
POB07B -99
Reimbursable Claim Percentages
POBAS TRANSACTION REPORTS
POB09 -01
Expenditure Transaction Report
POB09 -02
Check Register of Hand Payables - Detail
POB09 -03
Revenue Transaction Report
POB09 -04
Check Register of Hand Payables - Summary
POB09 -05
Backorders
POB09 -06
Disbursement by Vendor
POB09 -10
Detail General Ledger
POB09 -15
Direct Payments on Encumbered PO's by Account
POB09 -20
Inventory Shipments
POB09 -21
Inventory Shipments and Receipts Journal
POB09 -22
Inventory Receipts
POB09 -23
Backorders Written
POB09 -24
Shipping Orders
POB09 -27
Balance Sheet Reconciliation Report
POB09 -28
Detail Revenue Statement
POB09 -29
Detail Financial Statement
POB09 -30
Prior Year Expenditure and Encumbrance Detail
POB09 -31
State Reimbursement Report
k
3
FRU6
SISEAP
FPF;
IT11L PF WHIPUr
14
s
''. 1(:f I i,w
80190K
U/N
RISSW VORN BASF Wk'.'i
6
salt a
RAMP
u
wnru nAcy-"p frAp")
7
onfloo
sninio
0
WANSALTION EVII 1,
6
101190
86101W
0
INANSACTIM kojT b
q
"D i I o2
S61 10 R
0
APAPrNENT wO COWURCIAL CUSIPMERS
10
.0000
splicH
U
IPANSALF10m R&GISVP Al SFkV AUDREW3
11
"DI300
Seri
0
To- AWBACTfUN RE615TLP' fa LUMBER Mum
12
ND1150
SHION
0
rRAMALTION W03TEP 03 CUSTOVER MAIL AOUPES$
13
OD1350
HIM
0
REMN ACCT STATUS
lu
w0taOO
561109
D
MAMMON REG15TER bN DAPOSITS/ADJUSTS
15
•450
S6110R
0
TRANSACTION MISTER 45 REFUSE
16
woptoo
MOM
0
PAYMENT EDIT FISTING
17
00,00
35091u
0
PAYPENf M13TV
18
ROW9
560M
D
METER RVAO CARD PRINT CONTROL
19
nD3120
S60253
D
METER READ CARUS ffOH WKING)
20
w0300
S6025H
U
ME rtR mo CARDS fhOR REWIND)
21
003200
36020u
D
METER NEAn EDIT LISTI%'
OR
003001
SMOD
D
METER READ (VAkTO) CARDS
P3
003101
360250
0
KETVR QLAD (fROhd6L CODES) CARDS
21
ODS300
0040
0
SECOND METEW READ MT UIVING
ps
n03360
860050
B/P
SECOND W&P PjAD LOOT LISTINQ (BOOK WANLY)
Ph
o4!140V0
360b0f
MTn
RXEMPTTON P0618TCR
?7'
ADO 100
560501
MTH
614LING RLG13TEP
28
HDO200
500561
MTh
BILLS
29
nQ4100
560501
MTm
REFUSE HILLING KEGISIER
30
ADAU00
560501
MTH
ACCUUNT STATUS
31
Mloo
50361E
4
WENTNUER AOTIQ Q6134F
32
:05200
361DIF
F
OILLS-MINKER nOTICK8
33
W05300
86371H
A
FINAL NOTICE REPISTPH
31
MIUO
SWIH
A
BILLS-PTNAL wnrjch(j
3s
Msuc
SMIJ
0
FIELD SHUT PP L19T
36
nO5550
SWIJ
a
HELL SHUTUFF CARDS
37
n06 1 0 0
$6 t I I Y
TH
CLOSING.ACCOU41 EDIT LISTING
38
nob2oo
36090A
F
CLOSING bluMG REGNTER
39
oDh?00
WOOD
F
VR4N5FVR TO 305PENGE REGISTER
u0
,!-)v300
SQ90A
F
bit, 68-CLOSING
al
Aooqoo
S61811
p
CUOSEO ACCQhnT qFMInOVR NOTICE PEGISTRP
02
006500
solulz
F
RKAWOK10 NOTICE
Os
n07110
5060t)
T
MASTER ACCOMS RECEIVABLF
04
n0700
56161 V
bT-,K
Q 03FO ACCOUNT6 RECKI VARLE (:SELECTED BOOKS)
65
CLOW ACCOUNTS &CFIVAHL& (SWENTTALLY)
16
nolljo
S6230J
1
ACCOUNTS RECEIVABLE CONTROLS
47
4-101200
SWAM
ko
SUAKNOF ACCOUNT6 RECEIVAPUL
bi
tD7300
56?13H
mO
OEP05118 OUT3VANDING-NITH ACTIVITY EDIT
09
OD7375
SN201
NO
DEPOSITS OUTSTANOW;
50
vif)7 4 0 0
30,500
00
HONIHF-Y "ATUR COw8UmPTION DISTRIBUTION REPORT
sl
mD7500
MOW
410
NONTHUY ACTIVITY 50"MAqY ACCOUNT
52
n07950
8625o0
mn
MONTHLY ACTIVITY SUP"aRY PETER
53
n0000
SMOS
KO
ACCOWS &CEIVA"K MGM 6ALANCE
54
P01106
WfOw
81-m
oATER KETER EXCHANGE PRQGRAMI
S5
M220
8628OX
We•
013FRIHUilun nk TROUMV COOLS BY HOOKS
Fn
,;mu
5himov
nwo
w5rumiaw
of wout
cnas my
Sin
51
4PARdo
SyPn4X
UT-W
OTSTRjn0f(uN
GF IRMLL
CONS BY
HAKt IS SlZr
Sn
MOO
0594L
H/R
SWILL SP !PR
BA 30 CODES
qq
-54cup
S996hj
on
vapuRr fw ATFH
CONMV,
BY GOVT,
UNIT
no
soqqU5
sqgonj
-n
V3AGE, 6Y TYPE
(M/ 101ALS)
Al
OP9910
8910oj
"u
YATER u34GK by
TYPE (•/
STANDo DEVO
02
AD9450
subulm
MiN
wATER RA IF CHAHI
1
3
t0
ii
1 c?
13
t4'
1 `i
16
17
18
19
20
21
22
23
24
25
26
27
08
29
30
31
32
13
34
35
36
37
36
39
P0LIUF:
PROG, >STRtAM PRE -Q TITLE OF OUTPUT
FCOPY SION00 B/R
FCOPY S50450 I/K
FCOPY JJ 5t505555055E UIRJ
FCOPFCOPY 09SI L1/E\
FCOPY $5200P S -.A
P00040 35030C U/R
PDO120 35010A 0
PDOIRO S50280 N0
P1) 0215 SOO= I /R
PDO220 85040D b/R
PDOM .S MD B/R
PD0350 85050E 6/R
PD0350 85ObOF BIR
PDouoO 55055E blk
PDOW0 55055E 8/R
PD0450 55065E B/R
PD0450 S5070G MO
PD0470 550E+5F h/R
PD0460 35065E b/R
PD120M S5110K 0
PO1.3t)O 550108 No
PD1300 551500 MO
PD1305 550208 No
PD1305 S5000 mo
PD1400 $50006 hO
PD1100 SS1.2A MO
P020 15 850901 MO
P02054 SS080H HO
P04010 SS070G 00
PD4015 85070E 40
P04050 S507OG MO
P05000 8520OF SSA
P05010 552100, oKLY
m
MAT (CITATION) TAPE_
AmI S TAPE: CDMv)
NAME K ADDRESS TAPE_
P -CARD
iAPF "SAVE:" FILE-,
HAIL HEADER LOAD & EDIT
(OAILY)CITATION CONTROL REGI WR�PARKING
NOTE, NOT RUN ON CUTOFF DATE SEE S5028b
(CUTOFF DATE:)CTTATION CONTROL. REGISTFR.PARKI`C
NOTE: RUN ON CUTOFF DATE
PARK C.ITAT N&A WORST E`DIf LIST
INFO RFWUF6T -RWS NOT IN AMIS(SACTO REOUNT)
NON! ACCWABLE N &A REPUEST(FDIT FRRORW61
FIR31 NOTICE. ERROR LIST
WA.RPANT ERROR LIST
NOTICE OF INTENTION TO IS SUE? NARRAWI
DELINW, PARK, CIT, FIRST NOTICE LIST
PARKING COMPLAINTS /(WARRANTS)
AN(1,l.YSIS OF TRAFFIC VIOL BY HOUR OF DAY_.
hARRANI TRANBM[TTAL L AT(FARK16G)
"ARRANT INDEX CARDS(PAWNG)
MOVING CITATION CONTROL REGISTER
PARK ISSUE; DATE CROSS RFF
MOVING ISSUE DATE CROSS REF
DUPLICATE_ PARKING CITATIONS
DUPLICATE MOVING CITATION
PARK VIOLATIONS MONTH OF( ) )
MONTH OR )ANALYSIS OF TRAFF;IC
ARREST DISPOSITION ANACY313
CRIME UFFFNSE ANALYSIS _
EDIT ERRORS FROM POLICE ACCIDENT RECORDS
ANALYSIS OF TRAFFIC ACCIDENTS
TRAFFIC ACCIDENT BULLETIN
MOVTNG TRAFFIC VIOL, UNPROCESS, MAT, NO *S,
PROSECUTION MANAGEMENT REPORT
1
L
I B
R A R Y
2
3
PPOGA
STREAM
F&O
TITLE OF OUTPUT
4
5
413TF
53050A
I
LISTF OF LOVEK
6
LISTF
83500F
T
LTSTF LBHOLDFLHHOLOT
7
STORE:
630158
NKLY
WLEKVY BACK -UP OF l HHO D
9
STORE:
53300D
A
BACK UP OF LIBRARY
`)
FCOPY
53852K
MO
DELETE FROM LtiS( ti
r _ 10
WHO25
$32000
DUPLICATE. RFCORDS
11
L6026
532000
A/N
PROCESS SCHEDULF DUPLICATES
12
L6(205
S3400E
C
OVERDUE NOTSCF5 _ -
I. 13
LH0300
83650G
MO
L [GRAPY USEAG
14
L00400
538001
A/N
DELETE &PECTFIC RECORDS
is
L60500
518501
M -
LATE: RECORDS
i 16
LR0500
89999M
M
RETURNED TRANSACTIONS
17
OR0700
53.350H
M
INVALTD RECORDS
18
L
t
LBIOOO
834000
M
LIBRARY OUTPUT SUMMARY
i
t
i
1
F I
R E
2
3
PROC
STREAM
FPEW
TITLE OF OUTPUT
5
SmF000
S210OU
90
8M FIRE TAPE
6
FJO015
S2010A
MO
LISTING GY DUPL,ICATE ENTREES
C 7
FT0020
S2010A
MO
FIRE REPORTING, EXCEPTION LIMING
6
FI01I0
32010A
MO
FIRES (TOTALS)
9
F10110
52010A
MO
CALLS UThFR THAN FIRES
( 10
F1011?
32010A
MO
SUL.NARY 01 FIRES
11
F10115
S?010A
.00
INGENPIARY ON 306PICIOUS FIRES
12
F10700
8PO30H
MO
FIRE STATISTICS
( 13
FI1000
SP040C
00
FINE STATISTICS EXCEPTION LIST
14
FI1o20
82040C
AIN
EXCEPTION RE=PORT
15
F11030
NOW
MO
FIRE STATISTICS
{ 16
P12010
.120600
,MO
EDIT FRRORS FROM EMA INPUT
I7
FT20 40
SAW
MO
EMPRANCY iWDICAL AID
16 _:
F I2080
S2060E.
AIN
VA EFd OR HYSS DET- ErWoMONTH
( 1.9
EIP100
52090E
AIN
EXCEPTION LIST HUPGF & SO MARY
20
F I ?110
52.090E
mo
EMERGENCY MEDICAL AIU SUMMARY
21
FI2120
0090F
An
ENGINE CU VS INVECTION RTST'RICT
f-
P A Y R.0 L L
3 PROD STRFAN, FRED
TITLF
PAYROl L K..EKE.ND BACKUP
UPDATE CARD FORMAT EDIT
SERIOUS ERRORS
EMPLOYET= UPDATE, EDIT
F.MPL,OYEF UPDATE LD.1T
I- IA51ER (ILE:. UPDATE BAL PUN
SPECIA4 PAYS RUN DATE.
(;.URRkNT ACTIVE: EMPLOYEES
TFRMTNATEO Et'lPLOYEE8
PAYROLL STATUS REGISTER
FIXED PAY & DEDUCTiUPdS BALANCE
FIXED PAY & OEOUCTIOWS BALANCE BY
FIXED PAY &- .DEDUCTIONS PR()OF LIST
WlE. 11ME PAY & D'E'DUCT PRE, EDIT
UNF_ 7JMF PAY & DEDUCT BALANCE
FIXED PAY & OEOUrT SCHEOULFD DEPT
PTXFO PAY R DEDUCTIONS $CHFOUL-ED
ERRORS LISTING
POLICE OVERTIME; REPORT
TIME CARL) PRE-EDIT
TIME.. CARD f3Al_ANCE
ERROR K*ESSAGE:
1IME CARD EDIT AND BALANCE
ITME CAR() EDIT EXCEPTION LIST
TIMF CAPO PROOF L15T
GROSS PAY REGISTER(AS NEEL) EMP)
DEDUCTIONS NOT TAKEN)
TAX & PERS CONIROLS
PAYROLL, REGISTER
PAYROLL- CHECKS K RECON CARDS
PAYROLL. CHECK REGISTER
DFTATt_ OVER1IME REPORT
EMPLOYEE TIME DISTRIBUTION
DIVISION TIME OTSTRT.BUTI ()N
WORKN1ANS C9NPENSATION PAID
EMPLOYEES ABSENT 3+ DAYS
TTME CARD SUMMARY
PERSONNEL ACTT ()N REQUIRED
P,E,R,S, CONTRIBUTIONS REPORT
P,EIR98, CONTRIBUTIONS REPORT
MIXED PAY & DEDUCT REG BY TYPE
SUMMARY OVERTIMF REPORT
CREDIT UNION DEDUCT LIST
DEPT
10fAL.8
BY PERSON
DEFERRED COMPENSATION DEDUCT REPORT
FFJR2j CITY CONTRIBUTIONS
EMPLOYEES I _TSBt,TN(; tvORK COMP CODE.
WORKM019 COMPENSATION PREMIUMS
SICK LEAVE K VACATION,AOJUST
SICK LLAVE, VACATION & CONPENSATORY TIME
HTSTOUT TAPE
UPDATED EMPLOYEE RECORDS
BACKUP
NKL,Y
b
PP0003
540?.5C
BT-NK
7
PP001Ci
S 4 0 3 0 C
bT -OK
PP0016
3403 ?E
BT -WK
§
PPO017
5403.10
HT�WK
i 0
PP -0020
S9050O
81 >ya; 1C
11
PPO023
54050G
Hf -WK
12
PPO()25
5405 O
HI -NK
!3
PPOO26
S4050G
AXN
1�4
PPOO29
840701
8I"WkK
15
PPO061
S41001.
81"WK
Ih
PPOO85
90100L
BTMWK
17
Pt-'0086
5410tM
Ib
PPO100
3411 ON
BI�NK
19
PPO102,
S4IION
81�NK
20
PPO140
54120()
61 -AK
?I
PP0141
S4 -100L
NTH -0,K
22
PP0152
S4125P
8/R
23
PPO154
54125P
81-gv
r?u
Pt "0170
S41t35CI
blwNK
PP0172
841400
1sT -ikK
PPO190
84[155R
%7
P P 0 10
S41E,OU
bIw',UlC
25
FP0211
841558
BI^WK
2v
PP0212
S41b5U
30
PP0240
911170V
6I -WK
31
PP0270
54170V
81 -NK
32
PP0271
34170V
BT -NK
33
PP0280
8418OX
BT-NK
3fa
PPO-280
34190X
1I -'VJK
35
PPO300
54191Y
61"AK
36
PP0310
8420OZ
SI�VJK
37
PP0320
542002
HT-WK
Sty
PP0325
9420OZ
BT -WK
39
PP0329
SUPOOZ
bl"tvK
60
PP0330
542002
bT -WK
'11
PP0332
542002
61"WK
ill
FP0360
81-NK
u3
PP0370
84210A
bl —! ^ ?K
4u
PP0370
34RIiA
BTPWK
US
PP0390
S42VOZ
BI AllK
ci6
PP0400
842001
bl�WK
-117
PP0430
542208
81 -WK
4a
PP01133
542208
BT�wK
u9
PPOUbO
54220@
HIAVdK
50
P00470
542208
61mivK
51
PP0 /-16
542258
b VeK
S2
PPO479
54240D
S3
PP0490
$ 4241U
bI ° >'iK
54
PP0F;0 ()
5 4 ? 5 0 E
55
PP0;29
St) 050G
BTMIf;K
TITLF
PAYROl L K..EKE.ND BACKUP
UPDATE CARD FORMAT EDIT
SERIOUS ERRORS
EMPLOYET= UPDATE, EDIT
F.MPL,OYEF UPDATE LD.1T
I- IA51ER (ILE:. UPDATE BAL PUN
SPECIA4 PAYS RUN DATE.
(;.URRkNT ACTIVE: EMPLOYEES
TFRMTNATEO Et'lPLOYEE8
PAYROLL STATUS REGISTER
FIXED PAY & DEDUCTiUPdS BALANCE
FIXED PAY & OEOUCTIOWS BALANCE BY
FIXED PAY &- .DEDUCTIONS PR()OF LIST
WlE. 11ME PAY & D'E'DUCT PRE, EDIT
UNF_ 7JMF PAY & DEDUCT BALANCE
FIXED PAY & OEOUrT SCHEOULFD DEPT
PTXFO PAY R DEDUCTIONS $CHFOUL-ED
ERRORS LISTING
POLICE OVERTIME; REPORT
TIME CARL) PRE-EDIT
TIME.. CARD f3Al_ANCE
ERROR K*ESSAGE:
1IME CARD EDIT AND BALANCE
ITME CAR() EDIT EXCEPTION LIST
TIMF CAPO PROOF L15T
GROSS PAY REGISTER(AS NEEL) EMP)
DEDUCTIONS NOT TAKEN)
TAX & PERS CONIROLS
PAYROLL, REGISTER
PAYROLL- CHECKS K RECON CARDS
PAYROLL. CHECK REGISTER
DFTATt_ OVER1IME REPORT
EMPLOYEE TIME DISTRIBUTION
DIVISION TIME OTSTRT.BUTI ()N
WORKN1ANS C9NPENSATION PAID
EMPLOYEES ABSENT 3+ DAYS
TTME CARD SUMMARY
PERSONNEL ACTT ()N REQUIRED
P,E,R,S, CONTRIBUTIONS REPORT
P,EIR98, CONTRIBUTIONS REPORT
MIXED PAY & DEDUCT REG BY TYPE
SUMMARY OVERTIMF REPORT
CREDIT UNION DEDUCT LIST
DEPT
10fAL.8
BY PERSON
DEFERRED COMPENSATION DEDUCT REPORT
FFJR2j CITY CONTRIBUTIONS
EMPLOYEES I _TSBt,TN(; tvORK COMP CODE.
WORKM019 COMPENSATION PREMIUMS
SICK LEAVE K VACATION,AOJUST
SICK LLAVE, VACATION & CONPENSATORY TIME
HTSTOUT TAPE
UPDATED EMPLOYEE RECORDS
C
I
C
5b
PPOS30
S40SOG
BT -0iK
57
PP0932
5405OG
GTwOK
58
PP0550
540500
BI. °NK
59
PP0570
S405OG
bfwWK
np
PP0;)00
34090E:
I:IJ, 01K
61
PPO6')0
340701
BI N
62
PP0649
542300
i1l(7
63
PP0652
S405OG
61-WK
64
PP0690
802801.
HI-NK
65
PP0695
S4 ?9 iJ
61-evK
66
P P 0 7 1 S
8y?9YK
B/R
b7
PP0900
54300(
AN
68
PP0905
S4301(,
AN
69
PP0920
S432bL
70
PPIO15
344806
71
PPI020
346806
B/R
72
PP1030
S4480H
6/R
73
PP1080
544900
74
PP1090
15449 oc
75
PP1100
545000
76
PPlt20
511500[)
77
PPl12c?
S450oo
78
PP1l?4
$45000
74
PPll25
34500D
80
PP1126
545000
S!
pp 1150
511510E
-
k2
PP 1157
S4330tl
r�
PP1160
5453OG
N/R
84
PP1310
S4410U
8/R
65
PP1340
S4v10A
8b
PP20PO
54270E
87
PP2040
54,260E
BLINK
STS
PP ?100
S426OF
BI-NK
89
PP2130
54260E
BI�NK
90
PP2180
842801
blr NK
91
PP3010
39620V
92
PP3020
5406oz
93
PP3500
8434ON
94
PP3510
343500
01 -i4K
95
PP3520
54360P
bl-«4K
96
PP3570
543700
BT+v'K
97
PP3560
54370Q
BT ",,qK
98
PP3600
S4380R
99
P03620
S4139019
100
PP3630
54400T
BI -NK
101
PP6017
54740E';
102
PP6020
S4740M
103
PPb0 ?3
B/R
104
PPb0?.5
S406011
B/R
105
PP6055
.9474014
t06
PP6057
S4870H
E.MPL.OYEF.. STATUS LISTING BY EMPLOYEE
EMPLOYE=E STATUS BY DEPT
PERIODIC PAY INCREASES DUE
TIME CARDS EMPLOYEE BY DEPT
PW3ITION CONTROL- K ;;TRlF. NTH REPORT
Pi :RSONNEL A(—(JON REOUII:ED
SICK LEAVE X VACATION UPO ATE & EXCEPT LIST
8PECIAL PAY PROVISIONS BY TYPE'.
TAX BALANCE, -( ) QUARTER
YEAP E.Nt) TAX CORREGIXONS
SERV)C'E PIN ANALYSIS
YEAR END TAX MANGE
w -2 F()kirlIs
ONa+"TINIF PAYS & LUMP SUM SICK LEAVE
JOB CLASS BARG UNIT EXCEPTIONS
SALARY PROJECTIONS CALCULATION$
SALARY PROJECTION WORK SH €;ET
AUTO EXTRACT ERROR*
AU10 EXTRACT ALLO�AI
EXCEPTIONfi�NO CATAGFORY. FUNCTIONS' OR
FEO 4 REPORT
F4ORK FORCE A.NAL.Y813 BY JOtS CAT
WORK- FORCE - ANALYSIS BY K RiMANENT
WORK FORCE ANAI.Y81S BY PART TIME,
WORK FORCE. ANALYSIS TOTAL,
BUDGETED POSITION BY'JOS CLASS
JOS TITLES -EEO
(EEO4 REPORT) SEX CODES BY DIVISION
INVALID EMPLOYEE MASTER F'IL,E UPDATE:
EMPL.OYFE NUrHFR CHANGES
CURRENT FARNI!'IG5 DISTR
EQUIPMENT REPORT EDIT
JOB UDDER LABOR CHARGE EDIT
JOB ORDER EQUIP CHARGE_ EDIT
L-ABOR K E!QUIPT DISTRIBUTION
DIVHEAU CHANQE CARDS
RECORDS TO HE- DELETED
UTRANS CARDS
COMPEN8A'rioid EDIT
CLASSIFICATION MASTER FILE MAINTENANCE
JOB CLASS SCHEtDUI,E'. BY COMPENSATION
COMPENSATION SCHEDULE BY JOB CLASS
SCHED OF CLASS TITLES AND CLASS CODES
SCHEDULE_ OF CLASS TITLES
MASS CHANGE UPDATE EXCEPTIONS
(MATLING)LABLLS PRINTED
ELECT VERIF, LIST BY CLAS8MDIV4
PAY & DEDUCTIONS TABLE CODES LIST
(SPE.CIAL) TIME CARDS
NAMES & ADDRESSES BY DEPT
NAMES BY DEPT
SEX
Reference:
Contract No. 2493
(CCS)