Hi, I attach a python script which works with MS SQL Server and creates a table UNMC_PATID_TO_HASHED_SSN_DOB, which has PATIENT_IDE and SSN_DOB_HMAC fields.
The SSN_DOB_HMAC is computed using the hash key provided by KUMC when the hashed SSN Death Index is transferred and using the python logic which Dan Connolly documented. The other hashed values can be computed similarly using the dmf_hash function. With that table in place, we can join that table with the SSDI_hash table received from KUMC to find those patients who are deceased as documented by the SSN Death index. The python logic is very much SQL-Server specific, and relies on the use of pymssql library and uses Windows Authentication (which can be easily changed to SQL Server authentication if needed). Jay Pedersen, M.A. Department of Pathology/Microbiology University of Nebraska Medical Center 985900 Nebraska Medical Center Omaha NE 68198-5900 402-559-9487<tel:402-559-9593> (office) 402-739-3496<tel:402-350-7851> (mobile) The information in this e-mail may be privileged and confidential, intended only for the use of the addressee(s) above. Any unauthorized use or disclosure of this information is prohibited. If you have received this e-mail by mistake, please delete it and immediately contact the sender.
ssdi_hash_dob_ssn.py
Description: ssdi_hash_dob_ssn.py
_______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev