[The following is an excerpt from an actual contract for Y2K remediation work managed by Departmental Technology Solutions (DTS) for a department on campus. The same level of detail is appropriate for work contracted for outside of the university as well as work done within a department by departmental staff.]

Scope of Work

The Y2K compliance work on the System involves discovery and modification. First, discovery includes a search of code for Clipper date functions, of tables for fields that are DATE type, of table indices that include DATE type, of all MEM files for stored variables of date values, and of all report form files for date fields. Then, all screens and reports that display/output date values/variables must be rebuilt according to user specifications and all system calculations involving dates must be reviewed and corrected, if necessary. Certain Clipper software options must reviewed and set to display 4-digit year, if desired, and EPOCH must be set on for all 2-digit dates. Unit testing of the modified code is performed and then the program source is migrated with executables for acceptance testing by the customer on site. Any bugs/missing features must be corrected/provided that are detected during acceptance testing and that were part of the original scope of work. Upon acceptance of the Y2K modifications, XYZ Consulting must provide system documentation of the changes made.

The Y2K work is detailed further in the following milestones.

MILESTONE NUMBER AND DESCRIPTION OF SERVICES	REQUIRED HOURS
#01 Provide Y2K discovery on the System	60
#02 Identify all screens and reports that display/output date values/variables and rebuild according to user specifications	100
#03 Using discovery research, make code changes to noted date occurrences to eliminate/correct date calculations/conversions	70
#04 Correct MEM files, FORM files, and INDEX files as necessary	20
#05 Make general Y2K code enhancements to Clipper to insure all date calculations are display 4 digit year, if desired, and set EPOCH mark for all 2 digit dates	8
#06 Perform unit testing 24
#07 Migrate programs to staging area for acceptance test by UCB staff	2
#08 Fix bugs/meet specifications for items uncovered in acceptance testing	20
#09 Provide documentation of Y2K changes made and perform any knowledge transfer to operational staff	16
Total	320

Return to Possible Outside Sources of Y2K Programming Expertise