VPP Community Common Data Set from CHIE Project

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'