The excel sheet is attached at the bottom of the article and can also be found in the work item folder:
\\vch\departments\PCAC_EMR\01 - PCCEMR\Work Items\00 - All Items (JIRA)\EMR-3931 Document Profile EMR Data Model\Data Set
| Data Element Category (count = 392) |
Data Element Label | In EMR Summary/ Care Plan Report |
In PARIS Summary Report |
In PARIS Care Plan Report |
In Pixalere Summary Report |
EMR Db Table |
EMR Db Column |
EMR Db Filter |
EMR Lookup Values List |
PARIS Db Table |
PARIS Db Column |
PARIS Db Filter |
PARIS Lookup Values List |
Pixalere Db Table |
Pixalere Db Column |
Pixalere Db Filter |
Pixalere Lookup Values List |
| Patient Identifier | Patient PHN | Y | Y | Y | Y | patient | ptnt_nationalnum | mpi_alt_id | aid_alt_id | aid_type = 'PHN' | patient_accounts | phn | |||||
| Patient Identifier | Patient non-BC PHN | Y | TBD | TBD | patient | ptnt_nationalnum | ptnt_nationalnum_system <> 'BC' | mpi_alt_id | aid_alt_id | aid_type <> 'PHN' | |||||||
| Patient Identifier | Patient PHN province | Y | Y | N | N | patient | ptnt_nationalnum_system | mpi_alt_id | aid_type | ||||||||
| Patient Identifier | Patient PARIS ID | Y | Y | N | Y | patient | ptnt_mpi | mpi_person | per_id | patient_accounts | phn2 | ||||||
| Patient Identifier | Patient Profile EMR file number | TBD | N | N | N | patient | ptnt_patientcode | n/a | |||||||||
| Patient Record Status | Patient last update date - PARIS | n/a | N | Y | N | n/a | txt_cnote_doc | cnx_amended_on | (date of last casenote change) | ||||||||
| Patient Record Status | Patient last update date - Profile EMR | Y | n/a | n/a | N | patient | ptnt_datelastseen & ptnt_datelastchanged | n/a | |||||||||
| Patient Record Status | Patient last update date - Pixalere | n/a | n/a | n/a | N | n/a | n/a | ||||||||||
| Patient Demographics | Patient title | N | N | N | N | patient | ptnt_title | mpi_name | nam_title | ||||||||
| Patient Demographics | Patient family name | Y | Y | Y | Y | patient | ptnt_surname | mpi_name | nam_surname | patient_accounts | lastname | ||||||
| Patient Demographics | Patient given name (s?) | Y | Y | Y | Y | patient | ptnt_firstname | mpi_name | nam_fore1, nam_fore2 | patient_accounts | name | ||||||
| Patient Demographics | Patient preferred name | N | N | N | N | patient | ptnt_prefname | mpi_name | nam_surname, nam_fore1, nam_fore2 | nam_type = 'KNOWNAS' | |||||||
| Patient Demographics | Patient birthdate | Y | Y | N | N | patient | ptnt_dob | mpi_person | per_dob, per_dob_est | patient_accounts | dob | ||||||
| Patient Demographics | Patient date of death | N | N | N | N | patient | ptnt_dod | dis_death | dth_date | ||||||||
| Patient Demographics | Patient gender | Y | Y | Y | N | patient | ptnt_sex | shortcode.shcd_type = 115 | mpi_person | per_gender | patient_accounts | gender | |||||
| Patient Demographics | Patient language | N | N | N | N | patient | shcd_id_preflanguage | shortcode.shcd_type = 19 | mpi_language | lan_language | lup_generic 'LANGTYPE' | ||||||
| Patient Demographics | Patient - interpreter required | N | N | N | N | patient | ptnt_interpreterrequired | mpi_language | lan_interp_req | ||||||||
| Patient Demographics | Patient marital status | N | N | N | N | patient | lkls_id_maritalstatus | lookuplist.lkls_id | mpi_person | per_marital | lup_generic 'MARITAL' | ||||||
| Patient Contact Info | Patient phone home | N | N | N | N | patient | ptnt_homephone | mpi_telecom | tel_prefix + "-" + tel_suffix | tel_type = 'H' | |||||||
| Patient Contact Info | Patient phone cell | N | N | N | N | patient | ptnt_cellphone | mpi_telecom | tel_prefix + "-" + tel_suffix | tel_type = 'C' | |||||||
| Patient Contact Info | Patient e-mail personal | N | N | N | N | patient | ptnt_emailaddr | mpi_telecom | tel_prefix + "@" + tel_suffix | tel_type = 'E' | |||||||
| Patient Contact Info | Patient preferred contact method | N | N | N | N | patient | ptnt_preferrednotifymethod | mpi_telecom | tel_prefix + "@" + tel_suffix | tel_tel_primary = 1 | |||||||
| Patient Address | Patient address line 1 | N | N | N | N | patient | ptnt_street1 | mpi_address | add_line1 | ||||||||
| Patient Address | Patient address line 2 | N | N | N | N | patient | ptnt_buildingstreet | mpi_address | add_line2 + add_line3 | ||||||||
| Patient Address | Patient city | N | N | N | N | patient | ptnt_street3 | mpi_address | add_line4 | ||||||||
| Patient Address | Patient province | N | N | N | N | patient | ptnt_streetstate | lookuplist.lkls_id | mpi_address | add_line5 | |||||||
| Patient Address | Patient postal code | N | N | N | N | patient | ptnt_streetcode | mpi_address | add_postcode | ||||||||
| Patient Address | Patient country | N | N | N | N | patient | ptnt_streetcountry | mpi_address | add_country | ||||||||
| Patient Support Person | Patient support person title | N | N | N | N | IH | <Z..0B | td.texts - nextofkin.lkls_id_nxokrelation = lookuplist.lkls_id | n/a | ||||||||
| Patient Support Person | Patient support person family name | N | N | N | N | patient | ptnt_surname | nextofkin.lkls_id_nxokrelation = lookuplist.lkls_id | mpiu_contact | co2u_lastname | |||||||
| Patient Support Person | Patient support person given name | N | N | N | N | patient | ptnt_firstname | nextofkin.lkls_id_nxokrelation = lookuplist.lkls_id | mpiu_contact | co2u_firstname | |||||||
| Patient Support Person | Patient support person relationship | lookuplist & nok | lkls_description (ll_nok.LKLS_ID = nok.LKLS_ID_NXOKRELATION and ll_nok.LKLS_DELETEDID = 0) | ||||||||||||||
| Patient Support Person Contact Info | Patient support person phone home | N | N | N | N | patient | ptnt_cellphone or ptnt_homephone | nextofkin.lkls_id_nxokrelation = lookuplist.lkls_id | mpiu_contact | co2u_prefix1 + '-' + co2u_suffix1 | |||||||
| Patient Support Person Contact Info | Patient support person e-mail personal | N | N | N | N | patient | ptnt_emailaddr | nextofkin.lkls_id_nxokrelation = lookuplist.lkls_id | n/a | ||||||||
| Patient Support Person Contact Info | Patient support person preferred contact method | N | N | N | N | ? | n/a | ||||||||||
| Patient Support Person Contact Info | Patient support person phone address line 1 | nok | nxok_addr1 | ||||||||||||||
| Patient Support Person Contact Info | Patient support person phone address line 2 | nok | nxok_building | ||||||||||||||
| Patient Support Person Contact Info | Patient support person city | nok | nxok_addr3 | ||||||||||||||
| Patient Support Person Contact Info | Patient support person province | lookuplist & nok | lkls_description (ll_cstate.LKLS_ID = nok.NXOK_ADDRSTATE and ll_cstate.LKLS_DELETEDID = 0) | ||||||||||||||
| Patient Support Person Contact Info | Patient support person postal code | nok | nxok_addrcode | ||||||||||||||
| Patient Support Person Contact Info | Patient support person country | nok | nxok_addr_country | ||||||||||||||
| Patient MRP Identifier | Patient MRP B.C. MSP # | pppualias | pual_reference1 (pppualias.PPPU_ID = pppu.PPPU_ID and pppualias.ALIAS_ID = 4) | ||||||||||||||
| Patient MRP Identifier | Patient MRP BC College of Physicians & Surgeons ID | pppu | pppu_referencecode | ||||||||||||||
| Patient MRP Identifier | Patient alternate MRP B.C. MSP # | Y | Y | N | N | pppu | pppu_lastname | shortcode.shcd_code = 'UP' | mpi_name | nam_surname | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Patient MRP Identifier | Patient alternate MRP organization ID | Y | N | N | N | pppu | pppu_phone1 | shortcode.shcd_code = 'AP' | mpi_telecom | tel_prefix + "-" + tel_suffix | tel_type = 'W' and where ? | ||||||
| Patient Care Team Identifier | Patient care team ID | ||||||||||||||||
| Patient Care Team | Patient care team - date last seen | Y | N | N | N | n/a ? | txt_cnote_doc | cnh_created_on | (latest casenote for team) | ||||||||
| Patient Involved Agency Identifier | Patient involved agency ID | ||||||||||||||||
| Patient Involved Agency | Patient involved agency relationship | N | Y | N | N | pppu | pppu_jobtitle & shortcode.shcd_description | mpi_org_link | olk_relationship | ||||||||
| Patient Involved Agency | Patient involved agency valid from date | N | Y | N | N | care_team | ct_date, ct_closed_date, ct_date_from, ct_date_to, ct_status = 1 (Open) | mpi_org_link | olk_from | ||||||||
| Health Insurance | Health insurance - MSP coverage | Y | N | N | N | VCH_PCCEMR | <Z.2B0 | td.texts | n/a | ||||||||
| Health Insurance | Health insurance - prescription medication coverage | Y | N | N | N | VCH_PCCEMR | <Z.2B8, <Z.2BA, <Z.2BE, <Z.2BI, <Z.2BK, <Z.2BM, <Z.3M0, <Z.3KS, <Z.3KU, <Z.2BO | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - no coverage/unknown | N | N | N | N | VCH_PCCEMR | <Z.2B8 | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - 3rd party | N | N | N | N | VCH_PCCEMR | <Z.2BA | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - self-pay | N | N | N | N | VCH_PCCEMR | <Z.2BE | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - ministry (Plan C) | N | N | N | N | VCH_PCCEMR | <Z.2BI | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - NIHB - First Nations/Inuit | N | N | N | N | VCH_PCCEMR | <Z.2BK | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - IFHP - refugee | N | N | N | N | VCH_PCCEMR | <Z.2BM | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - FNHA (Plan W) | N | N | N | N | VCH_PCCEMR | <Z.3M0 | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - ministry (Plan G) | N | N | N | N | VCH_PCCEMR | <Z.3KS | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - ministry (Plan P) | N | N | N | N | VCH_PCCEMR | <Z.3KU | td.qvalue | n/a ? | ||||||||
| Prescription Medication Coverage | Prescription medication coverage - basic MSP | N | N | N | N | VCH_PCCEMR | <Z.2BO | td.qvalue | n/a ? | ||||||||
| Practitioner Demographics | Practitioner title | ||||||||||||||||
| Practitioner Demographics | Practitioner family name | pppu | pppu_lastname | professional_accounts | lastname | ||||||||||||
| Practitioner Demographics | Practitioner given name(s) | professional_accounts | firstname | ||||||||||||||
| Practitioner Demographics | Practitioner preferred name | pppu | pppu_prefname | ||||||||||||||
| Practitioner Demographics | Practitioner role | N | N | N | N | pppu | pppu_specialty or pppu_specialtyconceptid or pppu_jobtitle | shortcode.shcd_code = 'UP' | mpi_gp | nam_surname (in brackets at end) | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Contact Info | Practitioner phone # | Y | N | N | N | pppu | pppu_phone1 | shortcode.shcd_code = 'UP' | mpi_telecom | tel_prefix + "-" + tel_suffix | tel_type = 'W' and mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Contact Info | Practitioner fax # | N | N | N | N | pppu | pppu_fax | shortcode.shcd_code = 'UP' | mpi_telecom | tel_prefix + "-" + tel_suffix | tel_type = 'F' and mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Contact Info | Practitioner e-mail | N | N | N | N | pppu | pppu_email | shortcode.shcd_code = 'UP' | mpi_telecom | tel_prefix + "@" + tel_suffix | tel_type = 'E' and mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner clinic | N | N | N | N | n/a ? | org_organisation | org_name | how to link from mpi_gp? | ||||||||
| Practitioner Address | Practitioner address line 1 | N | N | N | N | pppu | pppu_street1 | shortcode.shcd_code = 'UP' | mpi_address | add_line1 | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner address line 2 | N | N | N | N | pppu | pppu_street2 | shortcode.shcd_code = 'UP' | mpi_address | add_line2 + add_line3 | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner address line 3 | ||||||||||||||||
| Practitioner Address | Practitioner city | N | N | N | N | pppu | pppu_street3 | shortcode.shcd_code = 'UP' | mpi_address | add_line4 | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner province | N | N | N | N | pppu | pppu_streetstate | shortcode.shcd_code = 'UP' | lookuplist.lkls_id | mpi_address | add_line5 | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner postal code | N | N | N | N | pppu | pppu_streetcode | shortcode.shcd_code = 'UP' | mpi_address | add_postcode | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Practitioner Address | Practitioner country | N | N | N | N | pppu | pppu_street_country | shortcode.shcd_code = 'UP' | mpi_address | add_country | mpi_relationship.rel_relationship = 'GP' and rel_to is null | ||||||
| Care Team | Care team name/place of service | Y | N | N | N | care_team | ct_person_id | pppu.pppu_id to pppu_placename or pppu_fullname | stf_team | tem_name | referral.ref_referred_to | ||||||
| Care Team Contact Info | Care team phone # | Y | N | N | N | care_team | ct_person_id | pppu.pppu_id to pppu_phone1 | mpi_telecom | tel_prefix | see SQL query | ||||||
| Care Team Contact Info | Care team fax # | Y | N | N | N | care_team | ct_person_id | pppu_pppu_id to pppu_fax | mpi_telecom | tel_suffix | see SQL query | ||||||
| Care Team Staff | Care team - staff name | N | N | N | N | care_team | ct_person_id | pppu.pppu_id to pppu_fullname | mpi_name | nam_fore1, nam_fore2, nam_surname | mpi_involved_staff.inp_association = ref_id | ||||||
| Care Team Staff | Care team - staff role | N | N | N | N | care_team | ct_role | shortcode.shcd_code & .shcd_description | lup_profession | pgp_desc | using stf_staff.stf_code | ||||||
| Involved Agency | Involved agency name | N | Y | N | N | pppu | pppu_fullname | care_team.ct_person_id and shortcode.shcd_id = care_team.ct_role where shortcode.shcd_description contains 'Pharmacy' | org_organisation | org_name | n/a | n/a | n/a | n/a | |||
| Involved Agency Contact Info | Involved agency phone # | N | Y | N | N | pppu | pppu_phone1 | pppu_id = care_team.ct_person_id | mpi_telecom | tel_prefix + tel_suffix | using org_organisation & org_tel_link where tel_type = 'W' | n/a | n/a | n/a | n/a | ||
| Involved Agency Contact Info | Involved agency fax # | N | N | N | N | pppu | pppu_fax | mpi_telecom | tel_prefix + tel_suffix | using org_organisation & org_tel_link where tel_type = 'F' | n/a | n/a | n/a | n/a | |||
| Involved Agency Address | Involved agency address line 1 | N | Y | N | N | pppu | pppu_street1 & pppu_street2 & pppu_street3 & pppu_streetstate & pppu_street_country & pppu_streetcode | org_organisation | fnc_van_get_org_adress_from_id (o.org_id) | n/a | n/a | n/a | n/a | ||||
| Involved Agency Address | Involved agency address line 2 | n/a | n/a | n/a | n/a | ||||||||||||
| Involved Agency Address | Involved agency address line 3 | n/a | n/a | n/a | n/a | ||||||||||||
| Involved Agency Address | Involved agency city | n/a | n/a | n/a | n/a | ||||||||||||
| Involved Agency Address | Involved agency province | n/a | n/a | n/a | n/a | ||||||||||||
| Involved Agency Address | Involved agency postal code | n/a | n/a | n/a | n/a | ||||||||||||
| Involved Agency Address | Involved agency country | n/a | n/a | n/a | n/a | ||||||||||||
| Active Alert | Active alert - description | Y | Y | N | N | patientproblem | papr_dxid & papr_dxdescription | papr_alert = -1 (see shortcode.shcd_code & shcd_description) | art_library | arl_desc | n/a | n/a | n/a | n/a | |||
| Active Alert | Active alert - date | Y | Y | N | N | patientproblem | papr_date | art_alert | art_alerted_on | n/a | n/a | n/a | n/a | ||||
| Active Alert | Active alert - extended leave alert | Y | Y | N | N | patientproblem | papr_dxid | papr_dxid in (568,588,589,591,592,593,595,598,599,601, 639,649,2992,3425,3583,6812,7269,8002,8938) or papr_casealerttype = 2362 (see shortcode.shcd_code & shcd_description) | art_alert | art_alert = 'OEL' | n/a | n/a | n/a | n/a | |||
| Active Alert | Active alert - reason / comments | Y | Y | N | N | patientproblem | papr_comment_blob | art_alert | art_reason & art_inac_reason | n/a | n/a | n/a | n/a | ||||
| Risk to Staff | Risk to staff - environmental - site access | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_site_access | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - environmental - phone access | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_phone_access | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - environmental - pets/animals | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_pets_animals | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - environmental - smoking | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_smoking | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - environmental - oxygen | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_oxygen | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - environmental - work space hazards | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_work_space | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - musculoskeletal - client mobility | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_c_mobility | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - musculoskeletal - ergonomics | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_ergonmic | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - violence/social - violence/aggression/abuse | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_violence | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - violence/social - firearms/weapons | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_firearms | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - violence/social - client/family/others behaviour | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_cforb | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - violence/social - substance use | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_sub_abuse | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - violence/social - cognition | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_cognition | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - occupational health - infectious disease | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_disease | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - occupational health - body fluids | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_bbf | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - occupational health - infestation | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_infestation | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - occupational health - sanitation | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_sanitation | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - other | N | N | N | N | n/a ? (these could be populated from alerts, but it is also imported from PARIS) | mpiu_mpcrs | crsu_other | n/a | n/a | n/a | n/a | |||||
| Risk to Staff | Risk to staff - category | Y | Y | N | N | patientproblem | papr_dxdescription | papr_casealerttype in (2255,2257,2259,2266,2267,2270, 2358,2379,2388,2407,2428,2432,2496,2623,2654,2791,3527,3750,4414,5609) or papr_dxid in (3425,3472,4192,4195,6812,7468,7482,7850,7914,8939) (see shortcode.shcd_code & shcd_description) | n/a | n/a | n/a | n/a | n/a | ||||
| Risk to Staff | Risk to staff - date recorded | Y | Y | N | N | patientproblem | papr_date | mpiu_mpcrs | crsu_recorddate | n/a | n/a | n/a | n/a | ||||
| Risk to Staff | Risk to staff - comments (environmental, musculoskeletal, violence/social, occupational health, other) | Y | Y | N | N | patientproblem | papr_comment_blog | mpiu_mpcrs | crsu_rs_details, crsu_en_comments, crsu_msi_comments, crsu_vio_comments, crsu_occ_comments, crsu_oth_comments | n/a | n/a | n/a | n/a | ||||
| Risk to Staff | Risk to staff - control plan (environmental, musculoskeletal, violence/social, occupational health, other) | N | Y | N | N | patientproblem | papr_comment_blog | mpiu_mpcrs | crsu_en_cp, crsu_msi_cp, crsu_vio_cp, crsu_occ_cp, crsu_oth_cp | n/a | n/a | n/a | n/a | ||||
| Allergy | Allergy - description | Y | N | N | N | patientproblem | papr_dxdescription & papr_dxid | papr_dxdescription & papr_dxid to diseasecode.dscd_id & dscd_code & dscd_description where upper(dscd_description) like '%ALLERGY%' (with a few exceptions) (see shortcode.shcd_code & shcd_description) | mpi_allergies | agy_substance | lup_allergies.alp_desc | ||||||
| Allergy | Allergy - reaction | ? | N | N | N | patientproblem | papr_dxdescription & papr_dxid | papr_dxdescription & papr_dxid to diseasecode.dscd_id & dscd_code & dscd_description where upper(dscd_description) like '%ANAPHYLA%' (with a few exceptions) | mpi_allergies | agy_category | lup_generic 'ALGYCTGRY' - What is CATMIG ? | ||||||
| Recent Measures | Recent measures - weight | Y | N | N | N | IH | <Z..2T | td.qvalue + unit.fname | mpiu_growth | grwu_weight_kg & grwu_weight_lbs | |||||||
| Recent Measures | Recent measures - weight - date | Y | N | N | N | IH | <Z..2T | td.dtobserved | mpiu_growth | grwu_dt_measure | |||||||
| Recent Measures | Recent measures - height | N | N | N | N | IH | <Z..2S | td.qvalue + unit.fname | mpiu_growth | grwu_height_cm & grwu_height_ft & grwu_height_in | |||||||
| Recent Measures | Recent measures - height - date | N | N | N | N | IH | <Z..2S | td.dtobserved | mpiu_growth | grwu_dt_measure | |||||||
| Recent Measures | Recent measures - bmi | N | N | N | N | IH | <Z..2U | td.qvalue + unit.fname | mpiu_growth | grwu_bmi | |||||||
| Recent Measures | Recent measures - bmi - date | N | N | N | N | IH | <Z..2U | td.dtobserved | mpiu_growth | grwu_dt_measure | |||||||
| Recent Measures | Recent measures - blood pressure | Y | N | N | N | IH | <Z..2W | td.qmax / td.qmin | mpiu_icvs | vtsu_bp_sitting & vtsu_bp_standing & vtsu_bp_lying | |||||||
| Recent Measures | Recent measures - blood pressure - date | Y | N | N | N | IH | <Z..2W | td.dtobserved | mpiu_icvs | vtsu_date | |||||||
| Recent Measures | Recent measures - heart rate | Y | N | N | N | IH | <Z..2V | td.qvalue + unit.fname | mpiu_icvs | vtsu_heartratepm | |||||||
| Recent Measures | Recent measures - heart rate - date | Y | N | N | N | IH | <Z..2V | td.dtobserved | mpiu_icvs | vtsu_date | |||||||
| Recent Measures | Recent measures - respiration rate | N | N | N | N | IH | <Z..1<N | td.qvalue + unit.fname | mpiu_icvs | vtsu_resprate | |||||||
| Recent Measures | Recent measures - respiration rate - date | N | N | N | N | IH | <Z..1<N | td.dtobserved | mpiu_icvs | vtsu_date | |||||||
| Recent Measures | Recent measures - temperature | N | N | N | N | IH | <Z..6<N | td.qvalue + unit.fname | mpiu_icvs | vtsu_temperature | |||||||
| Recent Measures | Recent measures - temperature - date | N | N | N | N | IH | <Z..6<N | td.dtobserved | mpiu_icvs | vtsu_date | |||||||
| Recent Measures | Recent measures - O2 saturation | Y | N | N | N | IH | 2708-6 | td.qvalue + unit.fname | n/a ? | ||||||||
| Recent Measures | Recent measures - O2 saturation - date | Y | N | N | N | IH | 2708-6 | td.dtobserved | n/a ? | ||||||||
| Recent Measures | Recent measures - notes | N | N | N | N | n/a ? | mpiu_icvs | vtsu_notes | |||||||||
| Active Referral | Active referral - program | N | Y | Y | N | referral | ref_to_pos_id, ref_to_prov_id & ref_to_ext_prov_id | referral.status = 'Open' | ref_referral | ref_type | lup_generic 'REFTYPE' and ref_status = 'OPENONDUTY' | ||||||
| Active Referral | Active referral - referred by | N | N | N | N | referral | ref_by_pos_id, ref_by_prov_id | ref_referral | ref_referrer_role | lup_system 'ROLETYPE' | |||||||
| Active Referral | Active referral - referral reason | N | Y | Y | N | referral | diagnosis_id, diagnosis_description, activity_id, activity_descr, explanation | ref_referral | ref_treat_reason | lup_generic 'TREATREAS' | |||||||
| Active Referral | Active referral - date opened | N | Y | Y | N | referral | referred_on | ref_referral | ref_referred_on | ||||||||
| Active Referral | Active referral - team | N | Y | Y | N | referral | ref_to_pos_id, ref_to_prov_id & ref_to_ext_prov_id | stf_team | tem_name | tem_key = ref_referral.ref_referred_to | |||||||
| Active Referral | Active referral - team phone # | N | Y | Y | N | pppu | pppu_phone1 | mpi_telecom | tel_prefix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id | |||||||
| Active Referral | Active referral - team fax # | N | N | N | N | pppu | pppu_fax | mpi_telecom | tel_suffix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id and begins with 'FAX: ' | |||||||
| Active Referral | Active referral - involved staff | N | Y | Y | N | n/a | mpi_involved_prof | inp_alloc_type | lup_generic 'ALLOCTYPE' and inp_staff = stf_staff.stf_code | ||||||||
| Diagnosis | Diagnosis - code | N | Y | N | N | diseasecode | dscd_system & dscd_code | dscd_id = papr_dxid | hlt_condition | hlc_diag_type | lup_generic 'DIAGTYPE' | ||||||
| Diagnosis | Diagnosis - description | N | Y | N | N | diseasecode | dscd_description & paptientproblem.papr_dxdescription | hlt_condition | hlc_condition | lup_diagnosis.dig_type + dig_code + dig_desc | |||||||
| Diagnosis | Diagnosis - date | N | Y | N | N | patientproblem | papr_date | hlt_condition | hlc_created_on | ||||||||
| Diagnosis | Diagnosis - state | N | Y | N | N | patientproblem | papr_statusid | (this is only active or inactive) | hlt_condition | hlc_state | lup_generic 'DIAGSTATE' | ||||||
| Diagnosis | Diagnosis - team | N | Y | N | N | n/a | hlt_condition | hlc_owner_tem_id | stf_team.tem_name where tem_key = hlt_condition.hlc_owner_tem_id | ||||||||
| Diagnosis | Diagnosis - diagnosed by | N | Y | N | N | patientproblem | createdby | hlt_condition | hlc_diagnosed_by | ||||||||
| Problem | Problem - nature/reaction | ? | N | N | N | patientproblem | papr_nature (shortcode) | n/a ? | |||||||||
| Problem | Problem - past procedure | Y | N | N | N | patientproblem | papr_dxdescription | papr_typeid = 3 | n/a ? | ||||||||
| Problem | Problem - social history/risk | Y | N | N | N | patientproblem | par_dxdescription | papr_typeid = 4 | n/a ? | ||||||||
| Healthcare Instructions | Healthcare instructions - date recorded | N | Y | N | N | n/a ? | mpiu_acisclinhc | tbbu_daterec | |||||||||
| Healthcare Instructions | Healthcare instructions - recorded by | N | Y | N | N | n/a | mpiu_acisclinhc | tbbu_scode | |||||||||
| Healthcare Instructions | Healthcare instructions - team | N | Y | N | N | n/a | mpiu_acisclinhc | tbbu_udfteam | stf_team.tem_name where tem_code = mpiu_acisclinhc.tbbu_udfteam | ||||||||
| Healthcare Instructions | Healthcare instructions - type | N | Y | N | N | n/a | mpiu_acisclinhc | tbbu_acistyp2 | lup_generic 'L_ACISTYP2' | ||||||||
| Healthcare Instructions | Healthcare instructions - notes | N | Y | N | N | n/a | txt_udf_freetext | tuf_free_text | tuf_id = mpiu_acisclinhc.tbbu_docloc | ||||||||
| Client Instruction Note | Client instruction note - type | N | N | N | N | n/a ? | ? | ||||||||||
| Client Instruction Note | Client instruction note - date created | N | N | N | N | n/a | txt_cnote_doc | cnx_created_on | txt_cnote_head.cnh_type = 'CIN' | ||||||||
| Client Instruction Note | Client instruction note - date updated | N | N | N | N | n/a | txt_cnote_doc | cnx_amended_on | |||||||||
| Client Instruction Note | Client instruction note - team | N | N | N | N | n/a | txt_cnote_head | cnh_team | stf_team.tem_code and tem_name | ||||||||
| Client Instruction Note | Client instruction note - reason | N | N | N | N | n/a | txt_cnote_head | cnh_reason | lup_generic 'CNREASON' | ||||||||
| Client Instruction Note | Client instruction note - staff member | N | N | N | N | n/a | txt_cnote_head | cnh_staff | stf_staff.stf_code & stf_per_id | ||||||||
| Client Instruction Note | Client instruction note - client instruction note | N | N | N | N | n/a | txt_cnote_doc | cnx_doc | |||||||||
| Housing | Housing - type | Y | N | N | N | VCH_PCCEMR | <Z.2L4 | td.texts | ? | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - suitable | Y | N | N | N | VCH_PCCEMR | <Z.2LE | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - adequate | Y | N | N | N | VCH_PCCEMR | <Z.2LG | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - affordable | Y | N | N | N | VCH_PCCEMR | <Z.2LI | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - stable | Y | N | N | N | VCH_PCCEMR | <Z.2LK | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - risk of eviction | Y | N | N | N | VCH_PCCEMR | <Z.2LM | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - safe | Y | N | N | N | VCH_PCCEMR | <Z.2LO | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - needs improvement | Y | N | N | N | VCH_PCCEMR | <Z.2LQ | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - application submitted | Y | N | N | N | VCH_PCCEMR | <Z.2LS | td.texts | ? | n/a | n/a | n/a | n/a | ||||
| Housing | Housing - waitlisted | Y | N | N | N | VCH_PCCEMR | <Z.2LU | td.texts | ? | n/a | n/a | n/a | n/a | ||||
| Food Security | Food security - concern | N | N | N | N | VCH_PCCEMR | <Z.3UI | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Food Security | Food security - details | Y | N | N | N | VCH_PCCEMR | <Z.2KX | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| Food Security | Food security - needs | Y | N | N | N | VCH_PCCEMR | <Z.1F4 | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| Food Security | Food security - plan | Y | N | N | N | VCH_PCCEMR | <Z.1F4 | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| IADL/ADL | IADL/ADL - assessment date | N | N | N | N | cdo_transdata | dtobserved | ass_assessment | ass_date_of_ass | ass_type in ('INTERRAI', 'MDSLTC', 'MDSLTCQT') | n/a | n/a | n/a | n/a | |||
| Instrumental ADL | Instrumental ADL - independent | N | N | N | N | VCH_PCCEMR | <Z.2PI | td.texts | ? | n/a | n/a | n/a | n/a | ||||
| Instrumental ADL | Instrumental ADL - meal preparation | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_meal_prep_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - housework | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_housework_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - manage finances | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_finances_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - manage medications | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_medications_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - communication | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_phone_use_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - shopping | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_shopping_code | n/a | n/a | n/a | n/a | |||||
| Instrumental ADL | Instrumental ADL - transportation | Y | N | N | N | n/a | ass_mdshc_h | hch_perf_transportation_code | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - independent | N | N | N | N | VCH_PCCEMR | <Z.2PK | td.texts | ? | n/a | n/a | n/a | n/a | ||||
| Activities of Daily Living | Activities of daily living - bed mobility | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_mobility_code / l07_g1aa | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - locomotion | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_outside_locomotion_code / l07_g1fa | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - dressing | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_dressing_upper_body_code + hch_dressing_lower_body_code /l07_g1ga | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - eating | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_eating_code / l07_g1ha | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - toilet use | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_toileting_code / l07_g1ia | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - personal hygiene | Y | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_hygiene_code / l07_g1ja | n/a | n/a | n/a | n/a | |||||
| Activities of Daily Living | Activities of daily living - change in ADL's | N | N | N | N | n/a | ass_mdshc_h / ass_mdsltc_g | hch_adl_declined /l07_g9 | n/a | n/a | n/a | n/a | |||||
| Psychosocial | Psychosocial - details | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - strengths | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - spiritual practices | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - hobbies/interests | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - other needs/concerns | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - needs | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Psychosocial | Psychosocial - plan | Y | N | N | N | VCH_PCCEMR | <Z.2NK | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - details | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - involved professionals | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - personal relationships | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - family | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - children (MCFD involvement) | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - needs | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a | n/a | n/a | n/a | n/a | ||||
| Social Support/Family | Social support/family - plan | Y | N | N | N | VCH_PCCEMR | <Z.2LA | td.texts ('TX*') | n/a | n/a | n/a | n/a | n/a | ||||
| Social History | Social history - social history | Y | N | N | N | Intrahealth | <Z..C<F | td.texts ('TX*') | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - outreach location | Y | N | N | N | VCH_PCCEMR | <Z.2O5, <Z.2O7, <Z.2O9, <Z.2OB | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - agreement to contact | Y | N | N | N | VCH_PCCEMR | <Z.29O, <Z.29Q, <Z.29S, <Z.29U | td.texts | n/a | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - notes | Y | N | N | N | VCH_PCCEMR | <Z.2AT, <Z.2AV, <Z.2AX, <Z.2AZ | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - income type | Y | N | N | N | VCH_PCCEMR | <Z.2LY, <Z.2M., <Z.2M1, <Z.2M3, <Z.2M5, <Z.2M9, <Z.2MD, <Z.2MF, <Z.2M7, <Z.2MB, <Z.2MH, <Z.2MJ, <Z.2ML, <Z.2MN, <Z.2MP, <Z.2MR, <Z.2MT, <Z.2MV, <Z.2MX, <Z.2MZ, <Z.2N0, <Z.2N2, <Z.2N4, <Z.3M4, <Z.2N6, <Z.2N8 | td.qvalue ('Specify' is td.texts) | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - stable income | Y | N | N | N | VCH_PCCEMR | <Z.2NA | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - livable income | Y | N | N | N | VCH_PCCEMR | <Z.2NC | td.qvalue & td.texts - Why? | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - receiving maximum benefits | Y | N | N | N | VCH_PCCEMR | <Z.2NE | td.qvalue & td.texts - Why? | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - transportation | Y | N | N | N | VCH_PCCEMR | <Z.3L1 | td.qvalue & td.texts - Why? | n/a ? | n/a | n/a | n/a | n/a | ||||
| Social & Financial | Social & financial - citizenship/immigration | Y | N | N | N | VCH_PCCEMR | <Z.2BQ | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding & Income Sources | Funding & income sources - type | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding & Income Sources | Funding & income sources - funding details | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding & Income Sources | Funding & income sources - income details | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding & Income Sources | Funding & income sources - funding ID | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding & Income Sources | Funding & income sources - level of ? | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding & Income Sources | Funding & income sources - valid from date | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding | Funding - no income | N | N | N | N | VCH_PCCEMR | <Z.2LY | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - provincial income assistance | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding | Funding - hardship, regular assistance, PPMB | N | N | N | N | VCH_PCCEMR | <Z.2M3 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - disability income | N | N | N | N | VCH_PCCEMR | <Z.2M9 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - person with disability (PWD) | N | N | N | N | VCH_PCCEMR | <Z.2M5 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - employment income | N | N | N | N | ? | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Funding | Funding - full-time, part-time, casual/not reliable, supplemental income, stipend | N | N | N | N | VCH_PCCEMR | <Z.2MJ & <Z.2ML & <Z.2MN & <Z.2MP & <Z.2MR | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - pension income | N | N | N | N | VCH_PCCEMR | <Z.2MV | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - CCP | N | N | N | N | VCH_PCCEMR | <Z.2MT | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - other income | N | N | N | N | VCH_PCCEMR | <Z.2N6 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - trust fund/inheritance/savings/insurance | N | N | N | N | VCH_PCCEMR | <Z.2N0 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - SAFER - shelter aid for elderly renters | N | N | N | N | VCH_PCCEMR | <Z.2N2 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - MNSB - monthly nutritional supplemental benefit | N | N | N | N | VCH_PCCEMR | <Z.2N4 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - EI | N | N | N | N | VCH_PCCEMR | <Z.3M4 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Funding | Funding - other | N | N | N | N | VCH_PCCEMR | <Z.2N6 | td.qvalue | n/a ? | n/a | n/a | n/a | n/a | ||||
| Home Support Auth. History | Home support auth. history - type | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - start date | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - end date | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - hours/28 days | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - provider | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - responsible team | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Home Support Auth. History | Home support auth. history - responsible clinician | N | N | N | N | n/a | n/a ? | n/a | n/a | n/a | n/a | ||||||
| Active Care Plan | Active care plan - strengths/preferences | Y | N | N | N | VCH_PCCEMR | <Z.3LJ | td.texts ('TX*') | n/a | ||||||||
| Active Care Plan | Active care plan - medication management plan | Y | N | N | N | VCH_PCCEMR | <Z.3L9 | td.texts ('TX*') | n/a | ||||||||
| Active Care Plan | Active care plan - action plan | ? | N | N | N | VCH_PCCEMR | <Z.3KI | td.texts | n/a | ||||||||
| Active Care Plan | Active care plan - plan | N | N | N | N | patientrecallplan | prpl_code, prpl_description, prpl_status | ? | |||||||||
| Active Care Plan | Active care plan - need/issue | Y | N | Y | N | VCH_PCCEMR | <Z.3KC (needs linking...) | td.texts ('TX*') | mpiu_cvc__ccp01 | sf#u_need | lup_generic 'L_CVC__NDS' | ||||||
| Active Care Plan | Active care plan - goal | Y | N | Y | N | VCH_PCCEMR | <Z.3KG | td.texts | mpiu_cvc__ccp01 | sf#u_goal | lup_generic 'L_CVC__GLS' | ||||||
| Active Care Plan | Active care plan - goal detail | N | N | Y | N | ? | txt_udf_freetext | tuf_free_text | tuf_id = mpiu_cvc__ccp01.sf#u_details | ||||||||
| Active Care Plan | Active care plan - goal date | N | N | Y | N | ? | mpiu_cvc__ccp01 | sf#u_created_on or sf#u_dt_identify or sf#u_dt_review ? | |||||||||
| Active Care Plan | Active care plan - goal last updated | Y | N | Y | N | ? | mpiu_cvc__ccp01 | sf#u_amended_on | |||||||||
| Active Care Plan | Active care plan - intervention | Y | N | Y | N | patientrecallvisit | prvs_description, prvs_status | mpiu_cvc__ccp02 | sg#u_intervention | lib_inter.lin_inter_desc on lin_inter_code where lin_inter_type = 'GEN' | |||||||
| Active Care Plan | Active care plan - intervention detail | N | N | Y | N | ? | txt_udf_freetext | tuf_free_text | tuf_id = mpiu_cvc__ccp02.sg#u_details | ||||||||
| Active Care Plan | Active care plan - intervention date | N | N | Y | N | patientrecallvisit | prvs_date | mpiu_cvc__ccp02 | sg#u_start_date | ||||||||
| Active Care Plan | Active care plan - intervention last updated | Y | N | Y | N | patientrecallvisit | dt_modified | mpiu_cvc__ccp02 | sg#u_amended_on | ||||||||
| Active Care Plan | Active care plan - discipline | N | N | Y | N | n/a | mpiu_cvc__ccp01, mpiu_cvc__ccp02 | sf#u_discipline, sg#u_discipline | lup_generic 'L_CVC__DIS' | ||||||||
| Active Care Plan | Active care plan - program | N | N | Y | N | n/a | mpiu_cvc__ccp01 | sf#u_program | lup_generic 'L_CVC__PRG' | ||||||||
| Active Care Plan | Active care plan - team | N | N | Y | N | n/a | mpiu_cvc__ccp01 | sf#u_team_code | stf_team.tem_name on tem_key | ||||||||
| Active Care Plan | Active care plan - team phone # | N | N | Y | N | n/a ? | mpi_telecom | tel_prefix | stf_team_tel.stt_tel_id = mpi_telecom.tel_id and stf_team.tem_id = stf_team_tel.stt_tem_id and mpiu_cvc__ccp01.sf#u_team_code = stf_team.tem_key | ||||||||
| Active Care Plan | Active care plan - team fax # | N | N | N | N | n/a ? | mpi_telecom | tel_suffix | stf_team_tel.stt_tel_id = mpi_telecom.tel_id and stf_team.tem_id = stf_team_tel.stt_tem_id and mpiu_cvc__ccp01.sf#u_team_code = stf_team.tem_key, and begins with 'FAX: ' | ||||||||
| Active Care Plan | Active care plan - last updated | Y | N | N | N | patientrecallplan | dt_modified | mpiu_cvc__ccp01, mpiu_cvc__ccp02 | max(sf#u_amended_on, sg#u_amended_on) | ||||||||
| Extended Leave | Extended leave - yes/no | Y | Y | N | N | VCH_PCCEMR | <Z.3L3 | td.texts | ass_assessment | ass_type | ass_assessment.ass_type = 'MHAELT' and ass_date_comp is null and (txt_cnote_head.cnh_origin_type = 'ASS' and cn2.cnh_reason in ('EIE', 'EWA') and ass_id = cn2.cnh_origin_id) = 0 and nvl(rtrim(a.ass_reason), 'X') <> 'EIE' | n/a | n/a | n/a | n/a | ||
| Extended Leave | Extended leave - program | N | Y | N | N | n/a | stf_department | dpt_name | n/a | n/a | n/a | n/a | |||||
| Extended Leave | Extended leave - start date | N | N | N | N | n/a | ass_assessment | ass_date_of_ass | n/a | n/a | n/a | n/a | |||||
| Extended Leave | Extended leave - team | N | Y | N | N | n/a | stf_team | tem_name | stf_team.tem_key = ass_assessment.ass_owner_tem_id | n/a | n/a | n/a | n/a | ||||
| Extended Leave | Extended leave - team phone # | N | Y | N | N | n/a | mpi_telecom | tel_prefix | stf_team_tel.stt_tel_id = mpi_telecom.tel_id and stf_team.tem_id = stf_team_tel.stt_tem_id and ass_assessment.ass_owner_tem_id = stf_team.tem_key | n/a | n/a | n/a | n/a | ||||
| Extended Leave | Extended leave - team fax # | N | N | N | N | n/a | mpi_telecom | tel_suffix | stf_team_tel.stt_tel_id = mpi_telecom.tel_id and stf_team.tem_id = stf_team_tel.stt_tem_id and ass_assessment.ass_owner_tem_id = stf_team.tem_key, and begins with 'FAX: ' | n/a | n/a | n/a | n/a | ||||
| Extended Leave | Extended leave - review date | Y | Y | N | N | VCH_PCCEMR | <Z.3L5 | td.dt1 | assu_mhaelvrt | min(etru_renewdate#) | etru_renewdate# >= today ? | n/a | n/a | n/a | n/a | ||
| Extended Leave | Extended leave - responsible psychiatrist | Y | Y | N | N | VCH_PCCEMR | <Z.3L7 | td.texts | assu_mhaeli | eliu_respphysic | mpi_name.nam_surname + ", " + nam_fore1 where nam_per_id = stf_staff.stf_per_id and stf_staff.stf_code = assu_mhaeli.eliu_respphysic | n/a | n/a | n/a | n/a | ||
| Extended Leave | Extended leave - case manager / care coordinator | Y | N | N | N | VCH_PCCEMR | <Z.3LX | td.texts | n/a ? | n/a | n/a | n/a | n/a | ||||
| Palliative - Advance Care Planning | Palliative - advance care planning - start date | N | N | N | N | VCH_PCCEMR | <Z.51E | td.dt1 (completed date) | cpl_need or cpl_goal ? | cpn_identified_on or cpg_identified_on | cpn_need_code = 'N310' or cpg_goal_code = 'ACP' | n/a | n/a | n/a | n/a | ||
| Palliative - Advance Care Planning | Palliative - advance care planning - discipline | N | N | N | N | n/a | ref_referral ? | ref_treat_reason ? | ref_referral.ref_id = cpl_header.cph_ref_id and cpl_structure.cps_cph_id = cpl_header.cph_id and cpl_need.cpn_id = cpl_structure.cps_cpn_id and lup_generic 'TREATREAS' and lup_generic.gen_code = ref_referral.ref_treat_reason - should the same be done for | n/a | n/a | n/a | n/a | ||||
| Palliative - Advance Care Planning | Palliative - advance care planning - needs | N | N | N | N | n/a | cpl_need | cpn_need_desc | cpn_need_code = 'N310' | n/a | n/a | n/a | n/a | ||||
| Palliative Status | Palliative status - wishes home death | N | N | N | N | LOINC | 28170-9 (but no values) or Form "Palliative Care - Notification of Expected Death at Home" | mpiu_acp | ac4u_yesonly ? | n/a | n/a | n/a | n/a | ||||
| Palliative Status | Palliative status - wishes to die elsewhere | N | N | N | N | n/a | mpiu_acp | ac4u_yesonly2 ? | n/a | n/a | n/a | n/a | |||||
| Palliative Status | Palliative status - comments | N | N | N | N | LOINC | 78568-3 | td.texts ('CX0') - Collection | cdo_data_e.data - convert from PDF | n/a ? | n/a | n/a | n/a | n/a | ||||
| Palliative Status | Palliative status - date | N | Y | N | N | LOINC | 78568-3 | td.texts ('CX0') - Collection | cdo_transdata.dtobserved | mpiu_acp | ac4u_date | n/a | n/a | n/a | n/a | |||
| Palliative Status | Palliative status - assessed by (or recorded by?) | N | Y | N | N | LOINC | 78568-3 | td.texts ('CX0') - Collection | cdo_trans.createdby | mpiu_acp | ac4u_scode | n/a | n/a | n/a | n/a | |||
| Palliative Status | Palliative status - prognosis | N | Y | N | N | n/a ? | mpiu_acp | ac4u_acp | lup_generic 'L_ACP' | n/a | n/a | n/a | n/a | ||||
| Palliative Performance Scale | Palliative performance scale - date | N | Y | N | N | AccelEMR | <P<P<S | td.qvalue - cdo_transdata.dtobserved | mpiu_acpps | ppsu_date | n/a | n/a | n/a | n/a | |||
| Palliative Performance Scale | Palliative performance scale - assessed by | N | Y | N | N | AccelEMR | <P<P<S | td.qvalue - cdo_trans.createdby | mpiu_acpps | ppsu_scode | n/a | n/a | n/a | n/a | |||
| Palliative Performance Scale | Palliative performance scale - PPS % | N | Y | N | N | AccelEMR | <P<P<S | td.qvalue | mpiu_acpps | ppsu_acpps2 | lup_generic 'F_299' | n/a | n/a | n/a | n/a | ||
| Waitlist for Service | Waitlist for service - date | N | Y | N | N | n/a ? | wal_entry | wlw_date_active | wal_def.wdf_id = wal_entry.wlw_wdf_id and wal_def.wdf_wl_type = 'R' - what is R? | n/a | n/a | n/a | n/a | ||||
| Waitlist for Service | Waitlist for service - program | N | Y | N | N | n/a ? | stf_department | dpt_name | dpt_code = stf_dept_team.dte_dept_code and sft_dept_team.dte_team_code = stf_team.tem_code and stf_team.tem_key = wal_entry.wlw_owner_tem_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Service | Waitlist for service - team | N | Y | N | N | n/a ? | stf_team | tem_name | stf_team.tem_key = wal_entry.wlw_owner_tem_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Service | Waitlist for service - team phone # | N | Y | N | N | n/a ? | mpi_telecom | tel_prefix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Service | Waitlist for service - team fax # | N | N | N | N | n/a ? | mpi_telecom | tel_suffix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id and begins with 'FAX: ' | n/a | n/a | n/a | n/a | ||||
| Waitlist for Service | Waitlist for service - waitlist name | N | Y | N | N | n/a ? | wal_def | wdf_name | n/a | n/a | n/a | n/a | |||||
| Waitlist for Placement | Waitlist for placement - date | N | Y | N | N | VCH_PCCEMR | <Z.2LU | td.texts - cdo_transdata.dtobserved | wal_entry | wlw_date_active | wal_def.wdf_id = wal_entry.wlw_wdf_id and wal_def.wdf_wl_type = 'P' | n/a | n/a | n/a | n/a | ||
| Waitlist for Placement | Waitlist for placement - program | N | Y | N | N | n/a ? | stf_department | dpt_name | dpt_code = stf_dept_team.dte_dept_code and sft_dept_team.dte_team_code = stf_team.tem_code and stf_team.tem_key = wal_entry.wlw_owner_tem_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Placement | Waitlist for placement - team | N | Y | N | N | n/a ? | stf_team | tem_name | stf_team.tem_key = wal_entry.wlw_owner_tem_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Placement | Waitlist for placement - team phone # | N | Y | N | N | n/a ? | mpi_telecom | tel_prefix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id | n/a | n/a | n/a | n/a | ||||
| Waitlist for Placement | Waitlist for placement - team fax # | N | N | N | N | n/a ? | mpi_telecom | tel_suffix | stf_team.tem_id = stf_team_tel.stt_tem_id and mpi_telecom.tel_id = stf_team_tel.stt_tel_id and begins with 'FAX: ' | n/a | n/a | n/a | n/a | ||||
| Waitlist for Placement | Waitlist for placement - waitlist name | N | Y | N | N | VCH_PCCEMR | <Z.2LU | td.texts - "Improved Housing" | wal_def | wdf_name | n/a | n/a | n/a | n/a | |||
| Waitlist for Placement | Waitlist for placement - status | N | Y | N | N | n/a ? | wal_entry | wlw_status | lup_generic 'WLSTATUS' | n/a | n/a | n/a | n/a | ||||
| Immunization Alert | Immunization alert - effective from date | N | Y | N | N | mpi_drug_vac_alert | dva_date_from | n/a | n/a | n/a | n/a | ||||||
| Immunization Alert | Immunization alert - antigen | N | Y | N | N | mpi_drug_vac_alert | dva_antigen | lib_goal.lgl_goal_desc where lgl_category = 'VACCINE' and lgl_goal_code = mpi_drug_vac_alert.dva_antigen | n/a | n/a | n/a | n/a | |||||
| Immunization Alert | Immunization alert - alert | N | Y | N | N | mpi_drug_vac_alert | dva_category | lup_system 'IMMALTCAT' and sys_code = mpi_drug_vac_alert.dva_category | n/a | n/a | n/a | n/a | |||||
| Immunization Alert | Immunization alert - immunization alert type | N | Y | N | N | mpi_drug_vac_alert | dva_alert_code | lup_system 'IMMALERTS' and sys_code = mpi_drug_vac_alert.dva_alert_code | n/a | n/a | n/a | n/a | |||||
| Immunization Alert | Immunization alert - notes | N | Y | N | N | mpi_drug_vac_alert | dva_notes | n/a | n/a | n/a | n/a | ||||||
| Immunization History | Immunization history - date given | N | Y | N | N | mpi_ch_vac_hist | vid_date | n/a | n/a | n/a | n/a | ||||||
| Immunization History | Immunization history - age (on date given) | N | Y | N | N | <calculated> | n/a | n/a | n/a | n/a | |||||||
| Immunization History | Immunization history - description | N | Y | N | N | mpi_ch_vachisdt | vih_base_antigen | lib_goal.lgl_goal_desc where lgl_goal_code = mpi_ch_vachisdt.vih_base_antigen and mpi_ch_vachisdt.vih_vid_id = mpi_ch_vac_hist.vid_id | n/a | n/a | n/a | n/a | |||||
| Immunization History | Immunization history - trade name | N | Y | N | N | mpi_ch_vac_hist | vid_tradename | n/a | n/a | n/a | n/a | ||||||
| Immunization Suspension | Immunization suspension - date recorded | N | Y | N | N | cpl_sched_suspend | csp_start_date | n/a | n/a | n/a | n/a | ||||||
| Immunization Suspension | Immunization suspension - antigen suspended | N | Y | N | N | cpl_sched_suspend | csp_description | n/a | n/a | n/a | n/a | ||||||
| Immunization Suspension | Immunization suspension - reason | N | Y | N | N | cpl_sched_suspend | csp_reason | lup_generic 'SUSPREASON' and cpl_sched_suspend.csp_reason = gen_code | n/a | n/a | n/a | n/a | |||||
| Case/Encounter/Progress Note | Case/encounter/progress note - type | N | N | N | N | txt_cnote_head | cnh_type | lup_generic 'CNTYPE' | n/a | n/a | n/a | n/a | |||||
| Case/Encounter/Progress Note | Case/encounter/progress note - date created | N | N | N | N | txt_cnote_doc | cnx_created_on | n/a | n/a | n/a | n/a | ||||||
| Case/Encounter/Progress Note | Case/encounter/progress note - date updated | N | N | N | N | txt_cnote_doc | cnx_amended_on | n/a | n/a | n/a | n/a | ||||||
| Case/Encounter/Progress Note | Case/encounter/progress note - physician | N | N | N | N | n/a | n/a | n/a | n/a | n/a | |||||||
| Case/Encounter/Progress Note | Case/encounter/progress note - clinic | N | N | N | N | n/a | n/a | n/a | n/a | n/a | |||||||
| Case/Encounter/Progress Note | Case/encounter/progress note - team | N | N | N | N | txt_cnote_head | cnh_team | stf_team.tem_code and tem_name | n/a | n/a | n/a | n/a | |||||
| Case/Encounter/Progress Note | Case/encounter/progress note - reason | N | N | N | N | txt_cnote_head | cnh_reason | lup_generic 'CNREASON' | n/a | n/a | n/a | n/a | |||||
| Case/Encounter/Progress Note | Case/encounter/progress note - staff member | N | N | N | N | txt_cnote_head | cnh_staff | stf_staff.stf_code & stf_per_id | n/a | n/a | n/a | n/a | |||||
| Case/Encounter/Progress Note | Case/encounter/progress note - note | N | N | N | N | txt_cnote_doc | cnx_doc | n/a | n/a | n/a | n/a | ||||||
| Wound Management | Wound management - team location | N | N | N | Y | n/a | n/a | wound_assessment | treatment_location_id | ||||||||
| Wound Management | Wound management - photographs? | N | N | N | Y | n/a | n/a | assessment_images | images | ||||||||
| Wound Management | Wound management - etiology/nursing diagnosis | N | N | N | Y | n/a | n/a | wound_etiology assessment_burn assessment_drain assessment_incision assessment_ostomy assessment_skin assessment_wound | lookup_id etiology | ||||||||
| Wound Management | Wound management - goal of care | N | N | N | Y | n/a | n/a | wound_goals | lookup_id | ||||||||
| Wound Management | Wound management - change frequency | N | N | N | Y | n/a | n/a | nursing_care_plan | visit_frequency | ||||||||
| Wound Management | Wound management - wound/tube/drain/incision/ostomy | N | N | N | Y | n/a | n/a | assessment_drain assessment_incision assessment_ostomy assessment_wound | assessment_id | ||||||||
| Wound Management | Wound management - wound/tube/drain/incision/ostomy assessment | N | N | N | Y | n/a | n/a | redundant? | |||||||||
| Wound Management | Wound management - open wound day (OWD) | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - care location | N | N | N | Y | n/a | n/a | wound_assessment | location | ||||||||
| Wound Management | Wound management - assessment type | N | N | N | Y | n/a | n/a | assessment_drain assessment_incision assessment_ostomy assessment_wound | full_assessment | ||||||||
| Wound Management | Wound management - visit date | N | N | N | Y | n/a | n/a | wound_assessment | visited_on | ||||||||
| Wound Management | Wound management - visit time | N | N | N | Y | n/a | n/a | wound_assessment | visited_on | ||||||||
| Wound Management | Wound management - status | N | N | N | Y | n/a | n/a | wound_assessment assessment_drain assessment_incision assessment_ostomy assessment_wound | active closed_date, status closed_date, status closed_date, status closed_date, status | ||||||||
| Wound Management | Wound management - onset date | N | N | N | Y | n/a | n/a | assessment_wound | wound_date | ||||||||
| Wound Management | Wound management - recurrent | N | N | N | Y | n/a | n/a | assessment_drain assessment_incision assessment_ostomy assessment_wound | recurrent | ||||||||
| Wound Management | Wound management - post-op day | N | N | N | Y | n/a | n/a | assessment_incision assessment_ostomy | postop_days | ||||||||
| Wound Management | Wound management - clinical pathway | N | N | N | Y | n/a | n/a | assessment_incision assessment_ostomy | clinical_path | ||||||||
| Wound Management | Wound management - construction (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | construction | ||||||||
| Wound Management | Wound management - stoma shape | N | N | N | Y | n/a | n/a | assessment_ostomy | shape | ||||||||
| Wound Management | Wound management - post-op management | N | N | N | Y | n/a | n/a | assessment_incision | postop_management | ||||||||
| Wound Management | Wound management - pain at site (0 - 10) | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - tube/drain type | N | N | N | Y | n/a | n/a | assessment_drain | type_of_drain | ||||||||
| Wound Management | Wound management - tube/drain sutured | N | N | N | Y | n/a | n/a | assessment_drain | sutured | ||||||||
| Wound Management | Wound management - drainage amount (ml) | N | N | N | Y | n/a | n/a | assessment_drain | drainage_amount_mls1 drainage_amount_mls2 drainage_amount_mls3 drainage_amount_mls4 drainage_amount_mls5 | ||||||||
| Wound Management | Wound management - incision status | N | N | N | Y | n/a | n/a | assessment_incision | incision_status | ||||||||
| Wound Management | Wound management - pain scale (0 - 10) | N | N | N | Y | n/a | n/a | assessment_burn assessment_drain assessment_incision assessment_ostomy assessment_skin assessment_wound | pain & pain_comments | ||||||||
| Wound Management | Wound management - length (cm) | N | N | N | Y | n/a | n/a | assessment_wound assessment_ostomy | length length_mm | ||||||||
| Wound Management | Wound management - width (cm) | N | N | N | Y | n/a | n/a | assessment_wound assessment_ostomy | width width_mm | ||||||||
| Wound Management | Wound management - depth (cm) | N | N | N | Y | n/a | n/a | assessment_wound | depth | ||||||||
| Wound Management | Wound management - circumference (ostomy) (mm) | N | N | N | Y | n/a | n/a | assessment_ostomy | circumference_mm | ||||||||
| Wound Management | Wound management - profile (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | profile | ||||||||
| Wound Management | Wound management - appearance (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | appearance | ||||||||
| Wound Management | Wound management - devices (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | devices | ||||||||
| Wound Management | Wound management - abdominal contour (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | contour | ||||||||
| Wound Management | Wound management - products | N | N | N | Y | n/a | n/a | assessment_product | product_id | ||||||||
| Wound Management | Wound management - wound bed | N | N | N | Y | n/a | n/a | assessment_woundbed | wound_bed | ||||||||
| Wound Management | Wound management - closure method(s) insitu | N | N | N | Y | n/a | n/a | assessment_incision | incision_closure_methods | ||||||||
| Wound Management | Wound management - exudate characteristics | N | N | N | Y | n/a | n/a | assessment_wound assessment_incision | exudate_type incision_exudate | ||||||||
| Wound Management | Wound management - exudate amount | N | N | N | Y | n/a | n/a | assessment_wound assessment_incision | exudate_amount | ||||||||
| Wound Management | Wound management - odour (after cleansing) | N | N | N | Y | n/a | n/a | assessment_wound | exudate_odour | ||||||||
| Wound Management | Wound management - wound edge | N | N | N | Y | n/a | n/a | assessment_wound | wound_edge | ||||||||
| Wound Management | Wound management - concerns for pouching (ostomy) | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - mucocutaneous margin (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | mucocutaneous_margin & num_mucocutaneous_margin & mucocutaneous_margin_comments | ||||||||
| Wound Management | Wound management - peri-wound/tube/drain/incision/ostomy skin | N | N | N | Y | n/a | n/a | assessment_incision assessment_ostomy assessment_wound | peri_incisional ? periostomy_skin periwound_skin | ||||||||
| Wound Management | Wound management - product review done | N | N | N | Y | n/a | n/a | assessment_treatment | review_done | ||||||||
| Wound Management | Wound management - packing pieces removed | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - packing pieces inserted | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - drainage start date (tube/drain) | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - tube/drain characteristics | N | N | N | Y | n/a | n/a | assessment_drain | drain_characteristics1 drain_characteristics2 drain_characteristics3 drain_characteristics4 drain_characteristics5 | ||||||||
| Wound Management | Wound management - tube/drain site | N | N | N | Y | n/a | n/a | assessment_drain | drain_site | ||||||||
| Wound Management | Wound management - fistula drainage (ostomy) | N | N | N | Y | n/a | n/a | ? | ? | ||||||||
| Wound Management | Wound management - peri-fistula skin (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | perifistula_skin | ||||||||
| Wound Management | Wound management - stool quantity (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | stool_quantity | ||||||||
| Wound Management | Wound management - stool colour (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | stool_colour | ||||||||
| Wound Management | Wound management - stool consistency (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | stool_consistency | ||||||||
| Wound Management | Wound management - nutritional status (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | nutritional_status_other | ||||||||
| Wound Management | Wound management - flange pouch (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | flange_pouch & flange_pouch_comments | ||||||||
| Wound Management | Wound management - self-care progress (ostomy) | N | N | N | Y | n/a | n/a | assessment_ostomy | self_care_progress & self_care_progress_comments | ||||||||
| Wound Management | Wound management - assessment images | N | N | N | Y | n/a | n/a | assessment_images | images | ||||||||
| Wound Management | Wound management - request for referral | N | N | N | Y | n/a | n/a | referrals_tracking | entry_type | ||||||||
| Wound Management | Wound management - progress notes | N | N | N | Y | n/a | n/a | assessment_comments | assessment_id | ||||||||
| Wound Management | Wound management - treatment plan | N | N | N | Y | n/a | n/a | nursing_care_plan | body | ||||||||
| Wound Management | Wound management - wound location | N | N | N | Y | n/a | n/a | wounds | wound_location_detailed | ||||||||
| Assessment | Assessment - type | N | N | N | N | ass_assessment | ass_type | lup_ass_type.lat_desc where lat_code = ass_assessment.ass_type | |||||||||
| Assessment | Assessment - team | N | N | N | N | ass_assessment | ass_owner_tem_id | stf_tem_name where tem_key = ass_assessment.ass_owner_tem_id | |||||||||
| Assessment | Assessment - date completed | N | N | N | N | ass_assessment | ass_date_comp | ||||||||||
| Assessment | Assessment - completed by | N | N | N | N | mpi_name | nam_surname, nam_fore1 | nam_per_id = stf_staff.stf_per_id and stf_staff.stf_code = ass_assessment.ass_carried_out_by | |||||||||
| Previous Procedures | Previous procedures - procedure | Y | N | N | N | n/a | |||||||||||
| Resolved Medical Issues | Resolved medical issues - issue | Y | N | N | N | hlt_condition | hlc_condition | lup_diagnosis.dig_type + dig_code + dig_desc where hlc_to is not null | |||||||||
| Closed Referral | Closed referral - program | N | N | N | N | referral | ref_to_pos_id, ref_to_prov_id & ref_to_ext_prov_id | status = 'Closed' | ref_referral | ref_type | lup_generic 'REFTYPE and ref_status in ('CLOSED', 'NFA') (see sys_prefix = 'REFSTAT' for other options) SYS OR GEN_PREFIX? | ||||||
| Closed Referral | Closed referral - referral reason | N | N | N | N | referral | diagnosis_id, diagnosis_description, activity_id, activity_descr, explanation | ref_referral | ref_treat_reason | lup_generic 'TREATREAS' | |||||||
| Closed Referral | Closed referral - date opened | N | N | N | N | referral | referred_on | ref_referral | ref_referred_on | ref_status = 'CLOSED' | |||||||
| Closed Referral | Closed referral - team | N | N | N | N | referral | ref_to_pos_id, ref_to_prov_id & ref_to_ext_prov_id | ref_referral | ref_referred_to | stf_team.tem_name where tem_key = ref_referral.ref_referred_to and ref_referral.ref_status in ('CLOSED', 'NFA') | |||||||
| Closed Referral | Closed referral - discharge date | N | N | N | N | referral | closed_on | dis_discharge | dis_discharged_on | ||||||||
| Closed Referral | Closed referral - discharge reason | N | N | N | N | referral | decision | dis_discharge | dis_reason | lup_generic 'DISREASON' |