<span style=" font-size:10pt;font-family:sans-serif">Dear all,</span>
<br><span style=" font-size:10pt;font-family:sans-serif">
I am aware that the decision
at the Mountain View Meeting with respect to the CCSDS RID database was
to use an Excel based approach. However after having spent a little time
on it I've uploaded an MS Access based database that could be used. This
contained 4 forms;</span>
<br>
<ol>
<li value=1><span style=" font-size:10pt;font-family:sans-serif">Document
Details Entry Form - Used to enter the
details of the document(s) under review.</span>
<li value=2><span style=" font-size:10pt;font-family:sans-serif">Reviewer
Details Entry Form - Used to enter
details of the reviewer(s)</span>
<li value=3><span style=" font-size:10pt;font-family:sans-serif">RID Entry
Form -
Used to enter the RID details</span>
<li value=4><span style=" font-size:10pt;font-family:sans-serif">RID Review
Form -
Used to review the RIDs</span>
<li value=5></ol><span style=" font-size:10pt;font-family:sans-serif">The
fields in the RID forms correspond pretty much to the existing CCSDS text
based form with the addition of 2 fields, 1 for attachments and 1 to indicate
which other RIDs the RID may be related to. </span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">It is also possible
to produce a a Word report of the RIDs from the database using Words mail
merge facility.</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">In the upload
there are 4 files;</span>
<br>
<ol>
<li value=1><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb><span style=" font-size:10pt;color:blue;font-family:sans-serif">https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database.accdb</span></a><span style=" font-size:10pt;font-family:sans-serif">
-
An
empty access database with the appropriate table, forms etc.</span>
<li value=2><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database%20Report%20Template.docx><span style=" font-size:10pt;color:blue;font-family:sans-serif">https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/CCSDS%20RID%20Database%20Report%20Template.docx</span></a><span style=" font-size:10pt;color:blue;font-family:sans-serif">
- </span><span style=" font-size:10pt;font-family:sans-serif">Word
document providing the template for the mail merge report.</span>
<li value=3><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb><span style=" font-size:10pt;color:blue;font-family:sans-serif">https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example.accdb</span></a><span style=" font-size:10pt;font-family:sans-serif">
-
An example populated database (data
used to populate it comes from an old Simple Schedule Red Review + some
test data)</span>
<li value=4><a href=https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example%20RIDs%20Database%20Report.docx><span style=" font-size:10pt;color:blue;font-family:sans-serif">https://cwe.ccsds.org/cesg/docs/CWE%20Private/CCSDS%20Access%20Database%20Example/Example%20RIDs%20Database%20Report.docx</span></a><span style=" font-size:10pt;font-family:sans-serif">
-
An example report generated via mail
merge from the example database.</span>
<li value=5></ol><span style=" font-size:10pt;font-family:sans-serif">The
above was nailed together quite quickly and I won't claim its totally bullet
proof but I think it covers pretty much all that's needed.</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">Anyway if you're
interested please take a look.</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">Cheers for now,</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif">Colin</span>
<br>
<br><span style=" font-size:10pt;font-family:sans-serif"><br>
<br>
---------------------------------------------------------------------------------------------------------<br>
Dr. Colin R. Haddow,<br>
HSO-GI, European Space Agency,<br>
European Space Operations Centre,<br>
Robert-Bosch-Str 5,<br>
64293 Darmstadt,<br>
Germany.<br>
<br>
Phone; +49 6151 90 2896<br>
Fax; +49 6151 90 3010<br>
E-Mail; colin.haddow@esa.int<br>
---------------------------------------------------------------------------------------------------------<br>
</span><PRE>This message is intended only for the recipient(s) named above. It may contain proprietary information and/or
protected content. Any unauthorised disclosure, use, retention or dissemination is prohibited. If you have received
this e-mail in error, please notify the sender immediately. ESA applies appropriate organisational measures to protect
personal data, in case of data privacy queries, please contact the ESA Data Protection Officer (dpo@esa.int).
</PRE>