1.- Review of pending requests: =============================== 1.1.- Request #10 (D. Given): ----------------------------- --> Add new column "nread" to NETMAG table. ------------------------------------------------------------------------ ==> Request has been approved but the implementation is on hold until: 1.- NC is done migrating to the new CISN software. 2.- SC is done migrating to the leap seconds compliant code. ==> Caltech's deadline: April 20, 2009 ------------------------------------------------------------------------ 1.2.- Request #53 (D. Given): ----------------------------- --> Add integer attribute for each channel to hold COSMOS "Table 6" value. ------------------------------------------------------------------------ ==> A. Walter is currently involved in NSMP project. We should wait until he has more information concerning this matter. ==> A. Walter to send out COSMOS documentation. ------------------------------------------------------------------------ 1.3.- Request #19 (D. Given): ----------------------------- --> Add "timequality" to WAVEFORM. ------------------------------------------------------------------------ ==> Request was clarified by Egill during the Standards call; Clock quality would be associated with a pick, not a waveform. ==> D. Neuhauser will send email to Egill. Should we store the datalogger type as well? Different dataloggers have different representations of the quality. ==> D. Neuhauser & D. Given to talk to Egill during Earthscope meeting. ------------------------------------------------------------------------ 1.4.- Request #4 (B. Worden): ----------------------------- --> Add new association table between amps and events. ----------------------------------------------------------------- Need to associate amplitudes with events. (The schema originally had this association, and it was removed at Caltech's request, due to performance implications in the real-time system when events were merged). ==> D. Neuhauser to come up with strawman for implementing sets. ----------------------------------------------------------------- 2.- New requests: ================= 2.1.- Request #123 (D. Oppenheimer): ------------------------------------ ----------------------------------------------------------------- --> Create a new rflag value ("S") for saved events. Allows NC Jigglers to use catalog filters that distinguish between events "accepted" on Duty Review Page from those "saved" by Jigglers. The former need to be reviewed before begin Finalized, the latter are still be worked on. This is requested to enable NC to transition to the RT system without disrupting work flow. ----------------------------------------------------------------- ----------------------------------------------------------------- ==> Approved. A new value 'I' (intermediate) for the Origin.rflag field will be introduced. This value will reflect an event that has been "saved" by analysts, but not yet "finalized". ----------------------------------------------------------------- 3.- SVN Repository: =================== There seems to be discrepancies between the DDL scripts in the SVN repository and the schema documentation. So far, about 15 tables have been identified (cf. DIFF_DOC_SVN.txt file).