Patterns of Care Therapy Report Processing

SEER Patterns of Care (POC) Support

For the SEER POC study, the POC coordinator (Mary Jane Byrne) requests processing of a POC datafile to generate therapies maintained in the central registry database.

Steps

• POC Coordinator drops excel file and csv version into POC directory
• Currently j:\Ericd\MJ-Eric SEER POC YYYY (YYYY = diag year for study)
• The file contains a row for each case, populated with PID, DOB, Seq, HospId, LastName, FirstName, SSN (and several empty columns)
• Copy POC csv file to working directory
• Currently mordor:/kcr/research/maryjaneSEERPOC2010/
• Rename files to current calendar year (i.e. 2010 POC DiagYear data processed in 2012)
• Customize poc.php with new filenames
• POC Input file: POCSEERYYYY.csv (YYYY= current calendar year, not POC study year)
• POC Missing Patient File:NotFoundYYYY.txt (list of any patients not found)
• ListNewYYYY.rpt
• Save and execute poc.php > SEERPOC_TherapiesYYYY.txt
• poc.php opens and reads POC Input file
• for each case
• stdout display SSN, LN, Seq
• stdout display all class_hx
• stdout display all therapies
• ListNewYYYY.rpt: writes SSN, LN, FN, BDate, HospId, LHospId, LCaseClass, LAccYear, LAccNo
• Copy files to drop directory