Laserfiche WebLink
<br />\Jl}d37l <br /> <br />Approach: <br /> <br />5.1. Develop Scripts Develop the database definition scripts and the table definition <br />scripts for HB-CRDSS in Informix and Microsoft Access. <br /> <br />5.2. Run Scripts Create and run the scripts necessary to create the database spaces, the <br />database itself and the tables with HydroBase. The tables created under this task are <br />presented in Exhibit I. The table creation scripts contain the table and attribute <br />dellnitions as well as constraints and indexing strategy for each table. The SQL <br />scripts available trom ERWIN in the development of Exhibit I will be used as a <br />starting point, but will need to be modified to include any indexing strategies <br />necessary for the administration 1001. <br /> <br />5.3. Draft Documcntation Document the results of this task for inclusion as a new <br />section in the Developers Manual. <br /> <br />5.4. Final Documentation Incorporate State comments into a final section of the <br />Developers Manual in the following formats: one hard copy. one version in Microsoli <br />Word. one version included in the existing online (HTML) Developers Manual. <br /> <br />Dc/il'cmh/cs: <br /> <br />RTi will: <br /> <br />I. Database detinition scripts. <br />2. Operational database. <br />3. Draft Developers Manual <br />4. Final Developers Manual <br /> <br />Task 6 - Develop V AX to Server Communications <br /> <br />Responsibility: RTi <br /> <br />Objective: Develop the scripts and/or the utilities needed to transfer real time satellite <br />information Irom the State's V AX computer into HB-CRDSS residing on a Windows NT <br />Database Server. <br /> <br />Approach: <br /> <br />I. Review SPWRMS Review and document in a 2-4 page memorandum the scripts and <br />processes being used by the South Platte Water Rights Management System <br />(SPWRMS) to transfer satellite data from the V AX computer to the SPWRMS <br />relational database. <br /> <br />2. Data Transfer Utility Modify or rewrite the SPWRMS scripts and processes to <br />populate real time data into HydroBase. <br /> <br />Deliverables: <br /> <br />l. Memorandum describing SPWRMS database population scripts. <br /> <br />c:1 wlcrdsslscopelph III blscope.doc <br /> <br />2119197 - II <br />