CDM Table name: VISIT_DETAIL (CDM v5.3 / v5.4)
Reading from hes_episodes, hes_acp, hes_ccare.
Extract the meticulously curated data from Hospital Episode Statistics(HES) Admitted Patient Care (APC) tables, specifically, the tables denoted as hes_episodes, hes_acp, and hes_ccare. Subsequently, systematically transform and align this information into the corresponding OMOP CDM versions outlined below..