Laserfiche WebLink
CRDSS <br />TASK MEMORANDUM 1.09-1 <br />User Database <br />User Database Year 1 Summary <br />1.0 ISSUE <br />The purpose of this task memorandum is to document the user database task activities performed during <br />Year 1. <br />2.0 DISCUSSION/ANALYSIS <br />The primary focus of the database effort was to create a populated user database to support the <br />administration of the project. During Phase I, the database design was formulated, and construction of <br />the database began. Beginning in Phase IIa, the database design was refined, and database construction <br />and population continued. Character-based displays were built using the INFORMIX tools as a <br />prototyping tool, debugging tool, and a tool to verify database contents. <br />The progress on the user database task will be summarized by first briefly discussing the work products <br />specified in the scope of work. <br />1.A comprehensive database of CRDSS users, installed at the DWR and/or CWCB as deemed <br />appropriate by the State's project manager. This database will include the administrative <br />information necessary to automatically distribute data reports. When available to CRDSS <br />users, this database will facilitate the exchange and development of ideas between CRDSS <br />users. <br />Figure 1, User Database Data Entry and Display Screen, is an example of the types of data which are <br />found in the user database. The database currently holds entries for the Technical Advisory Committee, <br />the Technical Subcommittees, members of the consultant team, and others. There are currently <br />approximately 70 names in the database. This database was demonstrated as part of the user <br />involvement program. There were few comments received, and the database will probably remain as an <br />administrative tool. <br />2.A mechanism for updating the database as the user community evolves. Maintenance will be <br />accomplished through the use of a data entry form so that users can be added or deleted, and <br />the relevant information can be modified. <br />The data entry screen in Figure 1 allows the user database to be updated and new users added. Note that <br />the individual designated to update the database must have the correct database permissions The <br />corrections and new users should be submitted to the database team or other staff designated by the State. <br />There is a recommendation to add a subtask to the Phase IIb scope to update the database. <br />1 <br />A275 01.09.95 1.09-1 Greer, Ritsch <br />