select this_.metadata_term_mapping_id as metadata1_83_1_, this_.metadata_source_id as metadata2_83_1_, this_.code as code3_83_1_, this_.metadata_class as metadata4_83_1_, this_.metadata_uuid as metadata5_83_1_, this_.name as name6_83_1_, this_.description as descript7_83_1_, this_.creator as creator8_83_1_, this_.date_created as date_cre9_83_1_, this_.changed_by as changed10_83_1_, this_.date_changed as date_ch11_83_1_, this_.retired as retired12_83_1_, this_.date_retired as date_re13_83_1_, this_.retired_by as retired14_83_1_, this_.retire_reason as retire_15_83_1_, this_.uuid as uuid16_83_1_, metadataso1_.metadata_source_id as metadata1_82_0_, metadataso1_.name as name2_82_0_, metadataso1_.description as descript3_82_0_, metadataso1_.creator as creator4_82_0_, metadataso1_.date_created as date_cre5_82_0_, metadataso1_.changed_by as changed_6_82_0_, metadataso1_.date_changed as date_cha7_82_0_, metadataso1_.retired as retired8_82_0_, metadataso1_.date_retired as date_ret9_82_0_, metadataso1_.retired_by as retired10_82_0_, metadataso1_.retire_reason as retire_11_82_0_, metadataso1_.uuid as uuid12_82_0_ from metadatamapping_metadata_term_mapping this_ inner join metadatamapping_metadata_source metadataso1_ on this_.metadata_source_id=metadataso1_.metadata_source_id where this_.retired=0 and this_.code='emr.exitFromInpatientEncounterType' and metadataso1_.name='org.openmrs.module.emrapi'
select this_.metadata_term_mapping_id as metadata1_83_1_, this_.metadata_source_id as metadata2_83_1_, this_.code as code3_83_1_, this_.metadata_class as metadata4_83_1_, this_.metadata_uuid as metadata5_83_1_, this_.name as name6_83_1_, this_.description as descript7_83_1_, this_.creator as creator8_83_1_, this_.date_created as date_cre9_83_1_, this_.changed_by as changed10_83_1_, this_.date_changed as date_ch11_83_1_, this_.retired as retired12_83_1_, this_.date_retired as date_re13_83_1_, this_.retired_by as retired14_83_1_, this_.retire_reason as retire_15_83_1_, this_.uuid as uuid16_83_1_, metadataso1_.metadata_source_id as metadata1_82_0_, metadataso1_.name as name2_82_0_, metadataso1_.description as descript3_82_0_, metadataso1_.creator as creator4_82_0_, metadataso1_.date_created as date_cre5_82_0_, metadataso1_.changed_by as changed_6_82_0_, metadataso1_.date_changed as date_cha7_82_0_, metadataso1_.retired as retired8_82_0_, metadataso1_.date_retired as date_ret9_82_0_, metadataso1_.retired_by as retired10_82_0_, metadataso1_.retire_reason as retire_11_82_0_, metadataso1_.uuid as uuid12_82_0_ from metadatamapping_metadata_term_mapping this_ inner join metadatamapping_metadata_source metadataso1_ on this_.metadata_source_id=metadataso1_.metadata_source_id where this_.retired=0 and this_.code='emr.admissionEncounterType' and metadataso1_.name='org.openmrs.module.emrapi'
select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='internal transfer location' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc
select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='disposition concept set' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc
select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='date of death' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc
select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='admission decision' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') and concept3_.retired=0
select this_.concept_id as y0_ from concept_reference_map this_ inner join concept concept3_ on this_.concept_id=concept3_.concept_id left outer join concept_numeric concept3_1_ on concept3_.concept_id=concept3_1_.concept_id left outer join concept_complex concept3_2_ on concept3_.concept_id=concept3_2_.concept_id inner join concept_reference_term term1_ on this_.concept_reference_term_id=term1_.concept_reference_term_id inner join concept_reference_source source2_ on term1_.concept_source_id=source2_.concept_source_id where lower(term1_.code)='disposition' and (lower(source2_.name)='org.openmrs.module.emrapi' or lower(source2_.hl7_code)='org.openmrs.module.emrapi') order by concept3_.retired asc
select this_.property as property1_61_0_, this_.property_value as property2_61_0_, this_.description as descript3_61_0_, this_.datatype as datatype4_61_0_, this_.datatype_config as datatype5_61_0_, this_.preferred_handler as preferre6_61_0_, this_.handler_config as handler_7_61_0_, this_.uuid as uuid8_61_0_, this_.changed_by as changed_9_61_0_, this_.date_changed as date_ch10_61_0_ from global_property this_ where lower(this_.property)='reporting.testpatientscohortdefinition'