Reusable procedures were created for MySQL TM (4) to load and transform standard EpiCenter TM data exports. Structured Query Language (SQL) statements process export file data elements to create: more granular temporal elements, category groupings to mirror daily activities and generalized lifestyles, categories based on spatial calculations and scores derived from the frequency of symptom and syndrome categories.