User:Bms0416/sandbox

= Login names and passwords= These can be found in the REDS-Credentials xlsx file. This has username passwords for Aurora SFTP Site, the zip password for files downloaded from the SFTP Aurora site, the username/ password for the BRIBMI1.bloodcenter.wi unix system, AKA the reds DB Server, the username/password for sqlplus and the site that Froedert deposits into. = Tools =

recreate_ICD9_tables
This recreates the ICD9 tables. It does this based on the files in /home/reds/REDS/data/Global. This data is downloaded from the site that maintains it at http://www.cms.gov/Medicare/Coding/ICD9ProviderDiagnosticCodes/codes.html -- This will require downloading a zip file to a windows machine, unzipping it, editing the 2 xlsx files, saving them as cvs files and "ftp"ing those files to the BRIBMI1.bloodcenter.wi host in the directory /home/reds/REDS/data/Global for the load scripts to be able to access them and load them correctly. Running the script recreate_ICD9_tables from /home/reds/REDS/scripts will use those files to update the appropriate tables.

reloadDonationTables
This clears and reloads the donation tables. This is done using the files in /home/reds/REDS/data/Donation/2013Q1 on host BRIBMI1.bloodcenter.wi -- These files are pushed in the directory /home/reds/REDS/data/Donation/2013Q1 ( With the quarter updated appropriately ). There is 1 csv file for each of the core tables for donations. To update the tables, run the reloadDonationTables script from /home/reds/REDS/scripts directory. It will create a clean load and enable the contraints for all of the core tables. These can be found in the

fixRecipientTables
This script runs the code necessary to clean up the recipient tables. The current data is missing some of the E-codes and types of donation. It also has corrupted division codes. To fix the division codes, it adds a 0 to the end of the current division is only 1 character long. The product codes and tods are modified through a combination of the rc_issuedtxproducts table and a set of repair data that was sent to us by Craig. This fixes the rc_issuedtxproducts table. The issuedtxproducts table is then used as a reference to repair the rc_transfusion and rc_crossmatch tables.

recreateRecipientDB
This is a script that drops all of the recipient tables, recreates them and then populates them with the latest data. This is necessary after the schema has been modified for any of the recipient tables. This does a drop table and create table for each table. The it populates the tables and enables the constraints ( see reloadRecipientTables for details on the load ).

recreateDonationDB
This is a script that drops all of the donation tables, recreates them and then populates them with the latest data. This is necessary after the schema has been modified for any of the donation tables. This does a drop table and create table for each table. The it populates the tables and enables the constraints ( see reloadDonationTables for details on the load ).

reloadRecipientTables
= Donation =

Export data
Create an export zip file in the ~reds/REDS/data/Donations/2013Q1 directory

Full
ant donation-export -load=2013Q1 Creates one zip file with the information with all of the tables included

Partial
ant donation-export -Dtable=DOM_CHAGASBACKFILL -load=2013Q1 Creates one zip file which only has the exported data associated with the specific table specified =Recipient=