API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 22nd, 2013
56
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.69 KB | None | 0 0
raw download clone embed print report
  1. -- eval Moh361ACohortDefinition, cache: []
  2. ---- eval SqlCohortDefinition, cache: []
  3. ---- done SqlCohortDefinition, cache: [org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition{query=select person_id from amrsreports_hiv_care_enrollment where enrollment_date is not NULL and enrollment_date <= '2013-05-22' and enrollment_location_id in ( :locationList ) union select pa.person_id from person_attribute pa join amrsreports_hiv_care_enrollment ae on pa.person_id = ae.person_id and ae.enrollment_date is not null and ae.enrollment_date <= '2013-05-22' join encounter e on e.patient_id = pa.person_id and e.voided = 0 and e.location_id in ( :locationList ) where (pa.voided = 0 or (pa.voided = 1 and pa.void_reason like 'New value: %')) and pa.person_attribute_type_id = 7 and pa.value = '5' and pa.date_created <= '2013-05-22'}]
  4. -- done Moh361ACohortDefinition, cache: [org.openmrs.module.amrsreports.reporting.cohort.definition.Moh361ACohortDefinition{}, org.openmrs.module.reporting.cohort.definition.SqlCohortDefinition{query=select person_id from amrsreports_hiv_care_enrollment where enrollment_date is not NULL and enrollment_date <= '2013-05-22' and enrollment_location_id in ( :locationList ) union select pa.person_id from person_attribute pa join amrsreports_hiv_care_enrollment ae on pa.person_id = ae.person_id and ae.enrollment_date is not null and ae.enrollment_date <= '2013-05-22' join encounter e on e.patient_id = pa.person_id and e.voided = 0 and e.location_id in ( :locationList ) where (pa.voided = 0 or (pa.voided = 1 and pa.void_reason like 'New value: %')) and pa.person_attribute_type_id = 7 and pa.value = '5' and pa.date_created <= '2013-05-22'}]
  5. -- eval PatientDataSetDefinition, cache: []
  6. .. eval Person ID, cache: []
  7. ---- eval PersonToPatientDataDefinition, cache: []
  8. ------ eval PersonIdDataDefinition, cache: []
  9. ------ done PersonIdDataDefinition, cache: [PersonIdDataDefinition{}]
  10. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=PersonIdDataDefinition}, PersonIdDataDefinition{}]
  11. .. done Person ID, cache: [PersonToPatientDataDefinition{joinedDefinition=PersonIdDataDefinition}, PersonIdDataDefinition{}]
  12. .. eval Serial Number, cache: [PersonToPatientDataDefinition{joinedDefinition=PersonIdDataDefinition}, PersonIdDataDefinition{}]
  13. ---- eval PersonToPatientDataDefinition, cache: []
  14. ------ eval SerialNumberDataDefinition, cache: []
  15. ------ done SerialNumberDataDefinition, cache: [SerialNumberDataDefinition{}]
  16. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=SerialNumberDataDefinition}, SerialNumberDataDefinition{}]
  17. .. done Serial Number, cache: [PersonToPatientDataDefinition{joinedDefinition=SerialNumberDataDefinition}, SerialNumberDataDefinition{}]
  18. .. eval Date Chronic HIV Care Started, cache: [PersonToPatientDataDefinition{joinedDefinition=SerialNumberDataDefinition}, SerialNumberDataDefinition{}]
  19. ---- eval PersonToPatientDataDefinition, cache: []
  20. ------ eval EnrollmentDateDataDefinition, cache: []
  21. ------ done EnrollmentDateDataDefinition, cache: [EnrollmentDateDataDefinition{}]
  22. ---- done PersonToPatientDataDefinition, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  23. .. done Date Chronic HIV Care Started, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  24. .. eval First Encounter Date At Facility, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  25. ---- eval PersonToPatientDataDefinition, cache: []
  26. ------ eval FirstEncounterAtFacilityDataDefinition, cache: []
  27. ------ done FirstEncounterAtFacilityDataDefinition, cache: [FirstEncounterAtFacilityDataDefinition{}]
  28. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=FirstEncounterAtFacilityDataDefinition}, FirstEncounterAtFacilityDataDefinition{}]
  29. .. done First Encounter Date At Facility, cache: [PersonToPatientDataDefinition{joinedDefinition=FirstEncounterAtFacilityDataDefinition}, FirstEncounterAtFacilityDataDefinition{}]
  30. .. eval Unique Patient Number, cache: [PersonToPatientDataDefinition{joinedDefinition=FirstEncounterAtFacilityDataDefinition}, FirstEncounterAtFacilityDataDefinition{}]
  31. ---- eval PatientIdentifierDataDefinition, cache: []
  32. ---- done PatientIdentifierDataDefinition, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=false, types=[CCC Number]}]
  33. .. done Unique Patient Number, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=false, types=[CCC Number]}]
  34. .. eval AMPATH Identifier, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=false, types=[CCC Number]}]
  35. ---- eval PatientIdentifierDataDefinition, cache: []
  36. ---- done PatientIdentifierDataDefinition, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=true, types=[ACTG Study ID, AMRS Medical Record Number, AMRS Universal ID, HCT ID, INVALID CHECK DIGIT, Invalid X Number (version 1.0), KENYAN NATIONAL ID NUMBER, MTCT Plus ID, MTRH Amenity Number, MTRH ANC Number, MTRH CARE Number, MTRH Casualty Number, MTRH CWC Number, MTRH Dental Number, MTRH ENT Number, MTRH Eye Clinic Number, MTRH FP Number, MTRH IP Number, MTRH Memorial Number, MTRH OPD Number, MTRH ORTHO Number, MTRH SCC Number, MTRH Staff PF Number, MTRH X-Ray Number, Old AMPATH Medical Record Number, pMTCT ID, X Number]}]
  37. .. done AMPATH Identifier, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=true, types=[ACTG Study ID, AMRS Medical Record Number, AMRS Universal ID, HCT ID, INVALID CHECK DIGIT, Invalid X Number (version 1.0), KENYAN NATIONAL ID NUMBER, MTCT Plus ID, MTRH Amenity Number, MTRH ANC Number, MTRH CARE Number, MTRH Casualty Number, MTRH CWC Number, MTRH Dental Number, MTRH ENT Number, MTRH Eye Clinic Number, MTRH FP Number, MTRH IP Number, MTRH Memorial Number, MTRH OPD Number, MTRH ORTHO Number, MTRH SCC Number, MTRH Staff PF Number, MTRH X-Ray Number, Old AMPATH Medical Record Number, pMTCT ID, X Number]}]
  38. .. eval Name, cache: [PatientIdentifierDataDefinition{includeFirstNonNullOnly=true, types=[ACTG Study ID, AMRS Medical Record Number, AMRS Universal ID, HCT ID, INVALID CHECK DIGIT, Invalid X Number (version 1.0), KENYAN NATIONAL ID NUMBER, MTCT Plus ID, MTRH Amenity Number, MTRH ANC Number, MTRH CARE Number, MTRH Casualty Number, MTRH CWC Number, MTRH Dental Number, MTRH ENT Number, MTRH Eye Clinic Number, MTRH FP Number, MTRH IP Number, MTRH Memorial Number, MTRH OPD Number, MTRH ORTHO Number, MTRH SCC Number, MTRH Staff PF Number, MTRH X-Ray Number, Old AMPATH Medical Record Number, pMTCT ID, X Number]}]
  39. ---- eval PersonToPatientDataDefinition, cache: []
  40. ------ eval PreferredNameDataDefinition, cache: []
  41. ------ done PreferredNameDataDefinition, cache: [PreferredNameDataDefinition{}]
  42. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=PreferredNameDataDefinition}, PreferredNameDataDefinition{}]
  43. .. done Name, cache: [PersonToPatientDataDefinition{joinedDefinition=PreferredNameDataDefinition}, PreferredNameDataDefinition{}]
  44. .. eval Date of Birth, cache: [PersonToPatientDataDefinition{joinedDefinition=PreferredNameDataDefinition}, PreferredNameDataDefinition{}]
  45. ---- eval PersonToPatientDataDefinition, cache: []
  46. ------ eval BirthdateDataDefinition, cache: []
  47. ------ done BirthdateDataDefinition, cache: [BirthdateDataDefinition{}]
  48. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=BirthdateDataDefinition}, BirthdateDataDefinition{}]
  49. .. done Date of Birth, cache: [PersonToPatientDataDefinition{joinedDefinition=BirthdateDataDefinition}, BirthdateDataDefinition{}]
  50. .. eval Age at Enrollment, cache: [PersonToPatientDataDefinition{joinedDefinition=BirthdateDataDefinition}, BirthdateDataDefinition{}]
  51. ---- eval PersonToPatientDataDefinition, cache: []
  52. ------ eval AgeAtDateOfOtherDataDefinition, cache: []
  53. -------- eval BirthdateDataDefinition, cache: []
  54. -------- done BirthdateDataDefinition, cache: [BirthdateDataDefinition{}]
  55. -------- eval EnrollmentDateDataDefinition, cache: []
  56. -------- done EnrollmentDateDataDefinition, cache: [EnrollmentDateDataDefinition{}]
  57. ------ done AgeAtDateOfOtherDataDefinition, cache: [EnrollmentDateDataDefinition{}, AgeAtDateOfOtherDataDefinition{effectiveDateDefinition=EnrollmentDateDataDefinition}]
  58. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=AgeAtDateOfOtherDataDefinition}, EnrollmentDateDataDefinition{}, AgeAtDateOfOtherDataDefinition{effectiveDateDefinition=EnrollmentDateDataDefinition}]
  59. .. done Age at Enrollment, cache: [PersonToPatientDataDefinition{joinedDefinition=AgeAtDateOfOtherDataDefinition}, EnrollmentDateDataDefinition{}, AgeAtDateOfOtherDataDefinition{effectiveDateDefinition=EnrollmentDateDataDefinition}]
  60. .. eval Sex, cache: [PersonToPatientDataDefinition{joinedDefinition=AgeAtDateOfOtherDataDefinition}, EnrollmentDateDataDefinition{}, AgeAtDateOfOtherDataDefinition{effectiveDateDefinition=EnrollmentDateDataDefinition}]
  61. ---- eval PersonToPatientDataDefinition, cache: []
  62. ------ eval GenderDataDefinition, cache: []
  63. ------ done GenderDataDefinition, cache: [GenderDataDefinition{}]
  64. ---- done PersonToPatientDataDefinition, cache: [GenderDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=GenderDataDefinition}]
  65. .. done Sex, cache: [GenderDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=GenderDataDefinition}]
  66. .. eval Entry Point, cache: [GenderDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=GenderDataDefinition}]
  67. ---- eval PersonToPatientDataDefinition, cache: []
  68. ------ eval PersonAttributeDataDefinition, cache: []
  69. ------ done PersonAttributeDataDefinition, cache: [PersonAttributeDataDefinition{personAttributeType=Point of HIV Testing}]
  70. ---- done PersonToPatientDataDefinition, cache: [PersonAttributeDataDefinition{personAttributeType=Point of HIV Testing}, PersonToPatientDataDefinition{joinedDefinition=entryPoint}]
  71. .. done Entry Point, cache: [PersonAttributeDataDefinition{personAttributeType=Point of HIV Testing}, PersonToPatientDataDefinition{joinedDefinition=entryPoint}]
  72. .. eval Confirmed HIV Date, cache: [PersonAttributeDataDefinition{personAttributeType=Point of HIV Testing}, PersonToPatientDataDefinition{joinedDefinition=entryPoint}]
  73. ---- eval PersonToPatientDataDefinition, cache: []
  74. ------ eval EnrollmentDateDataDefinition, cache: []
  75. ------ done EnrollmentDateDataDefinition, cache: [EnrollmentDateDataDefinition{}]
  76. ---- done PersonToPatientDataDefinition, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  77. .. done Confirmed HIV Date, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  78. .. eval CTX Start Stop Date, cache: [EnrollmentDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EnrollmentDateDataDefinition}]
  79. ---- eval PersonToPatientDataDefinition, cache: []
  80. ------ eval CtxStartStopDataDefinition, cache: []
  81. ------ done CtxStartStopDataDefinition, cache: [CtxStartStopDataDefinition{}]
  82. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=CtxStartStopDataDefinition}, CtxStartStopDataDefinition{}]
  83. .. done CTX Start Stop Date, cache: [PersonToPatientDataDefinition{joinedDefinition=CtxStartStopDataDefinition}, CtxStartStopDataDefinition{}]
  84. .. eval Fluconazole Start Stop Date, cache: [PersonToPatientDataDefinition{joinedDefinition=CtxStartStopDataDefinition}, CtxStartStopDataDefinition{}]
  85. ---- eval PersonToPatientDataDefinition, cache: []
  86. ------ eval FluconazoleStartStopDataDefinition, cache: []
  87. ------ done FluconazoleStartStopDataDefinition, cache: [FluconazoleStartStopDataDefinition{}]
  88. ---- done PersonToPatientDataDefinition, cache: [FluconazoleStartStopDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FluconazoleStartStopDataDefinition}]
  89. .. done Fluconazole Start Stop Date, cache: [FluconazoleStartStopDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FluconazoleStartStopDataDefinition}]
  90. .. eval TB Treatment Start Stop Date, cache: [FluconazoleStartStopDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FluconazoleStartStopDataDefinition}]
  91. ---- eval PersonToPatientDataDefinition, cache: []
  92. ------ eval TbStartStopDataDefinition, cache: []
  93. ------ done TbStartStopDataDefinition, cache: [TbStartStopDataDefinition{}]
  94. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=TbStartStopDataDefinition}, TbStartStopDataDefinition{}]
  95. .. done TB Treatment Start Stop Date, cache: [PersonToPatientDataDefinition{joinedDefinition=TbStartStopDataDefinition}, TbStartStopDataDefinition{}]
  96. .. eval Pregnancy EDD and Referral, cache: [PersonToPatientDataDefinition{joinedDefinition=TbStartStopDataDefinition}, TbStartStopDataDefinition{}]
  97. ---- eval PersonToPatientDataDefinition, cache: []
  98. ------ eval PmtctPregnancyDataDefinition, cache: []
  99. ------ done PmtctPregnancyDataDefinition, cache: [PmtctPregnancyDataDefinition{}]
  100. ---- done PersonToPatientDataDefinition, cache: [PmtctPregnancyDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=PmtctPregnancyDataDefinition}]
  101. .. done Pregnancy EDD and Referral, cache: [PmtctPregnancyDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=PmtctPregnancyDataDefinition}]
  102. .. eval LTFU TO DEAD, cache: [PmtctPregnancyDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=PmtctPregnancyDataDefinition}]
  103. ---- eval PersonToPatientDataDefinition, cache: []
  104. ------ eval LTFUTODeadDataDefinition, cache: []
  105. ------ done LTFUTODeadDataDefinition, cache: [LTFUTODeadDataDefinition{}]
  106. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=LTFUTODeadDataDefinition}, LTFUTODeadDataDefinition{}]
  107. .. done LTFU TO DEAD, cache: [PersonToPatientDataDefinition{joinedDefinition=LTFUTODeadDataDefinition}, LTFUTODeadDataDefinition{}]
  108. .. eval WHO Clinical Stage, cache: [PersonToPatientDataDefinition{joinedDefinition=LTFUTODeadDataDefinition}, LTFUTODeadDataDefinition{}]
  109. ---- eval PersonToPatientDataDefinition, cache: []
  110. ------ eval FirstWHOStageDataDefinition, cache: []
  111. ------ done FirstWHOStageDataDefinition, cache: [FirstWHOStageDataDefinition{}]
  112. ---- done PersonToPatientDataDefinition, cache: [FirstWHOStageDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FirstWHOStageDataDefinition}]
  113. .. done WHO Clinical Stage, cache: [FirstWHOStageDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FirstWHOStageDataDefinition}]
  114. .. eval Date Medically Eligible for ART, cache: [FirstWHOStageDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=FirstWHOStageDataDefinition}]
  115. ---- eval PersonToPatientDataDefinition, cache: []
  116. ------ eval EligibilityForARTDataDefinition, cache: []
  117. ------ done EligibilityForARTDataDefinition, cache: [EligibilityForARTDataDefinition{}]
  118. ---- done PersonToPatientDataDefinition, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  119. .. done Date Medically Eligible for ART, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  120. .. eval Reason Medically Eligible for ART, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  121. ---- eval PersonToPatientDataDefinition, cache: []
  122. ------ eval EligibilityForARTDataDefinition, cache: []
  123. ------ done EligibilityForARTDataDefinition, cache: [EligibilityForARTDataDefinition{}]
  124. ---- done PersonToPatientDataDefinition, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  125. .. done Reason Medically Eligible for ART, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  126. .. eval Date ART Started, cache: [EligibilityForARTDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=EligibilityForARTDataDefinition}]
  127. ---- eval PersonToPatientDataDefinition, cache: []
  128. ------ eval DateARTStartedDataDefinition, cache: []
  129. ------ done DateARTStartedDataDefinition, cache: [DateARTStartedDataDefinition{}]
  130. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=DateARTStartedDataDefinition}, DateARTStartedDataDefinition{}]
  131. .. done Date ART Started, cache: [PersonToPatientDataDefinition{joinedDefinition=DateARTStartedDataDefinition}, DateARTStartedDataDefinition{}]
  132. .. eval Last HIV Encounter Date, cache: [PersonToPatientDataDefinition{joinedDefinition=DateARTStartedDataDefinition}, DateARTStartedDataDefinition{}]
  133. ---- eval PersonToPatientDataDefinition, cache: []
  134. ------ eval LastHIVEncounterDataDefinition, cache: []
  135. ------ done LastHIVEncounterDataDefinition, cache: [LastHIVEncounterDataDefinition{}]
  136. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  137. .. done Last HIV Encounter Date, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  138. .. eval Last HIV Encounter Location, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  139. ---- eval PersonToPatientDataDefinition, cache: []
  140. ------ eval LastHIVEncounterDataDefinition, cache: []
  141. ------ done LastHIVEncounterDataDefinition, cache: [LastHIVEncounterDataDefinition{}]
  142. ---- done PersonToPatientDataDefinition, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  143. .. done Last HIV Encounter Location, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  144. .. eval Last Return to Clinic Date, cache: [PersonToPatientDataDefinition{joinedDefinition=LastHIVEncounterDataDefinition}, LastHIVEncounterDataDefinition{}]
  145. ---- eval PersonToPatientDataDefinition, cache: []
  146. ------ eval LastRTCDateDataDefinition, cache: []
  147. ------ done LastRTCDateDataDefinition, cache: [LastRTCDateDataDefinition{}]
  148. ---- done PersonToPatientDataDefinition, cache: [LastRTCDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=LastRTCDateDataDefinition}]
  149. .. done Last Return to Clinic Date, cache: [LastRTCDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=LastRTCDateDataDefinition}]
  150. -- done PatientDataSetDefinition, cache: [LastRTCDateDataDefinition{}, PersonToPatientDataDefinition{joinedDefinition=LastRTCDateDataDefinition}]
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!