robworth/patientview — pull request #95 by lu-yang (2013-10-14 05:01:03+00:00)
Title: feature/157-Radar-datebase-improvements-datetime

157 - Radar database improvements to aid 3rd party reporting.
1. pv_patientjoin_request ( dateofbirth )
this one just change its type in DB will be ok.
2. rdr_alport_deafness ( ageProblemFirstNoticed,
ageStartedUsingHearingAid )
remove 'ageProblemFirstNoticed' and 'ageStartedUsingHearingAid '
columns, add 'dateProblemFirstNoticed' and 'dateStartedUsingHearingAid '
columns
3. rdr_hnf1b_misc ( ageAtDiabetesDiagnosis, ageAtGoutDiagnosis )
Same as 2th, remove 'ageAtDiabetesDiagnosis' and 'ageAtGoutDiagnosis'
columns, add 'dateAtDiabetesDiagnosis' and 'dateAtGoutDiagnosis' columns
4. tbl_demographics ( DOB )
I think this table isn't in use.
5. tbl_diagnosis ( AGE_AT_DIAG )
In 'tbl_diagnosis' table, there is a column named 'DATE_DIAG', I think
this is unnecessary to change AGE_AT_DIAG.
6 unitstat ( yearmonth )
I think this table isn't in use, because UnitStatAction.java can't be
found in struts-config.xml.