eForm Magic Part A – Standard Tags

UpdatedSeptember 24, 2023

By Peter Hutten-CzapskiPeter Hutten-Czapski

Standard Database Tags

The following tags from OSCAR 19 are designed for users to use if they want certain fields to be automatically filled out with information from the patient’s chart/demographics/system data.

The tag should appear in the following style oscarDB=<tag> (note lack of quotation marks) as in the following example:

<input type="text" name="pname" id="pname" oscarDB=patient_name>

The following is a list of all the standard database tags available. All tags are readable and some (just 4 currently) marked as (u) tags which the eForm can also update the database based on user input

Notes on the list

12 marked tags are older and work across most OSCAR versions and forks
15 marked tags have been added to OSCAR 15 since June 2016
15b803 represent tags added from disparate OSCAR forks in July 2018 (build 803) back into OSCAR EMR
19 marked tags were developed for OSCAR 19

Oscar Version	oscarDB tag	updatable	Description	Example
15	time		system time in this time zone	12:34:23
12	today		system date	2016-01-29
12	appt_date		appointment date	2012-12-11
12	current_form_id		fid of current eform	number
12	current_form_data_id		fdid of current eform	number
12	current_user		logged in user	Hutten-Czapski, Peter
19	current_user_fname		logged in user	Peter
19	current_user_lname		logged in user	Hutten-Czapski
12	current_user_fname_lname		logged in user	Peter Hutten-Czapski
12	current_user_ohip_no		OHIP provider No	120692
12	current_user_specialty_code		OHIP specialty	0
15b803	current_user_specialty		Specialty	GP
12	current_user_cpsid		College Registration	54345
12	current_user_id		Oscar User No	121
15	current_user_address		from the provider table	2913 Meridian
15	current_user_work_phone		from the provider table	705-672-1111
15	current_user_email		from the provider table	phc@oscarcanada.org
15	current_user_fax		from the provider table	705-672-2222
15	current_user_team		from the provider table	KME
15	current_user_signature		Oscar User Signature	MD (entered from Pref, Edit your Signature)
12	patient_name		Upper Case Name	MACDONALD, JOHN A
12	first_last_name		Mixed Case Name	John a Macdonald
12	patient_nameL	U	Last Name	MACDONALD
12	patient_nameF	U	First Name	JOHN
19	patient_nameM	U	Middle Name	ALEXANDER
15	patient_alias	U	Patient Alias as per demographic	Old Chieftain
15b803	patient_title		Patients title if listed in demographic	MR
12	patient_id		Oscar Generated Demographic No	3781
12	label		LASTNAME, FIRSTNAME Address line Telephones DOB SEX HIN	MACDONALD, JOHN A Box 812, 16 Whitewood Ave., New Liskeard, ON P0J 1P0 Tel:705-647-4399(H) (W) 03/06/1938(F) HIN:7999962999CR
19	residential_address		residential address and if not found address	Box 812, 16 Whitewood Ave. New Liskeard, ON P0J 1P0 Canada
12	address		Address City Postal	Box 812, 16 Whitewood Ave. New Liskeard, ON P0J 1P0
12	addressline		one line address	Box 812, 16 Whitewood Ave., New Liskeard, ON P0J 1P0
12	address_street_number_and_name		street and number	Box 812, 16 Whitewood Ave.
12	province		2 digit province	ON
12	city		City	New Liskeard
12	postal		Postal Code	P0J 1P0
12	dob		dd/mm/yyyy (d/m/y)	13/06/1938 (d/m/y)
12	dobc		dd/mm/yyyy	13/06/1938
12	dobc2		yyyy/mm/dd	1938/06/13
15	dobc3		mm/dd/yyyy	1938-06-13
15b803	dob_MONTH-dd-yyyy		MONTH-dd-yyyy	1938-06-13
12	dob_year		yyyy	1938
12	dob_month		mm	6
12	dob_day		dd	3
12	NameAddress		Name Address	MACDONALD, JOHN A Box 812, 16 Whitewood Ave., New Liskeard, ON P0J 1P0
12	hin		HIN and Version	7999962999 CR
12	hinc		HIN	7999962999
12	hinversion		Version Code	CR
15b803	hc_type		Insurance province/state	ON
12	hc_renew_date		Health Card Renewal	2006-01-23
12	chartno		User provided Chart No eg the paper chart	29973
12	phone		home phone	705-647-4399
12	phone2		work phone	705-647-4399
12	cell		cell phone	705-647-4399
12	phone_extension		extension	23
12	phone2_extension		extension	23
12	age		Current age in years	74
15	age_in_months		Current age in months	14
12	ageComplex		Age expressed in days weeks or months for infants and toddlers and years for older children or adults	3 day old 4 week old 6 month old 74 year old
15b803	ageComplex2		Years and Months of age	74 years 7 Months
12	sex		gender	M
15b803	She_He		She or He based on gender	He
15b803	him_her		him or her based on gender	him
15b803	his_her		his_her based on gender	his
12	sin		Social Security Number	111-222-333
15	date_joined		from demographic table	2005-11-01
15b803	partner_nameL		Partners last name from relationships	MACDONALD
15b803	partner_nameF		Partner’s first name	AGNES
15b803	partner_dob		dd/mm/yyyy (d/m/y)	13/06/1938 (d/m/y)
15b803	partner_dob2		yyyy/mm/dd	1938/06/13
15b803	partner_hin		Partners health number and version	7999962999 CR
15b803	partner_phone		Partners phone	705-647-4399
12	medical_history		history	1984 ANTEROLATERAL MYOCARDIAL INFARCT 2000 COPD 2001 ATYPICAL PNEUMONIA 2007 OSTEOPENIA 2009 CATARACT REMOVAL & IOL IMPLANT(Right) 2016 CVA (CEREBROVASCULAR)(Right)
15b803	medical_history_ext		<br> delineated history	1984 ANTEROLATERAL MYOCARDIAL INFARCT<br>2000 COPD <br>2001 ATYPICAL PNEUMONIA<br>2007 OSTEOPENIA
12	other_medications_history		Comma delineated list of family history and other meds	dad renal failure 76 IHD, mom AMI 75 NIDDM
15b803	other_medications_history_ext		<br> delineated list of family history and other meds	dad renal failure 76 IHD mom AMI 75 NIDDM
12	social_family_history		Comma delineated social history	Lives with son James, Retired Prime Minister
15b803	social_family_history_ext		<br> delineated list of social history	Lives with son James Retired Prime Minister
12	ongoingconcerns		Comma delineated list of ongoing concerns	Limited finances
15b803	ongoingconcerns_ext		<br> delineated list of ongoing concerns	Limited finances
15b803	riskfactors		Comma delineated list of ongoing concerns
15b803	riskfactors_ext		<br> delineated list of ongoing concerns
12	reminders		Comma delineated list of reminders	Findlay’s, If unable to reach patient at home tel , contact Mike (caretaker) at 705-676-7995(cell).
15b803	reminders_ext		<br> delineated list of reminders
12	risk_factors_json		Risk Factors from CPP	[{“note”:”risky gambling”}]
12
12	family_history_json		Family History from CPP	[{“note”:”Father cardiomyopathy 32 passed out\nuncle died of brain tumour 1.5yo”}]
12	dxregistry		Comma delineated disease registry items	ESSENTIAL HYPERTENSION, CHRONIC BRONCHITIS
12	OHIPdxCode		Comma delimited OHIP diagnosis codes billed	7.13E+50
12	allergies_des		Comma delineated allergies and archived (deleted)	PENICILLIN archived allergies: AMOXIL
12	allergies_des_no_archived		Comma delineated current allergies	PENICILLIN
12	recent_rx		recent Rx	2012-11-12 AGGRENOX Take 1 Tabs PO BID for 90 Days LU Code: 349 Qty:180 Repeats:3 2012-11-08 MUCOMYST INJ 200MG/ML 2 ml by nebuliser TID for 30 days Qty:90 ml Repeats:4 2012-10-31 PULMICORT NEBUAMP 0.5 MG/ML inhale contents of 1 nebule BID for 60 days LU Code: 264 Qty:120 Repeats:0 SALBUTAMOL 1MG LIQUID Take 1 neb qid for 90 days Qty:360 Repeats:3 IPRATROPIUM BROMIDE .25MG SOLUTION 1 neb Q6H for 90 days Qty:360 Repeats:3 SALBUTAMOL 100MCG METERED-DOSE AEROSOL 1-2puff QID INH PRN for 30 days Qty:2 Repeats:12
12	today_rx		todays Rx	2012-11-12 AGGRENOX Take 1 Tabs PO BID for 90 Days LU Code: 349 Qty:180 Repeats:3
12	current_rx		current Rx	Darco healing shoe With custom insole Qty:1 Repeats:0SITAGLIPTIN 25MG TABLET Take 1 po od Qty:0 Repeats:0METFORMIN 500MG Take 1 po bid Qty:0 Repeats:0TOBRAMYCIN FOR INJECTION 1.2G 120 mg iv q 12h for 19 days 1.5mg/kg = 120mg eGFR 45 Qty:5700 Repeats:0VENOFER 20MG 300mg for iv infusion please fill today Qty:1 Repeats:0CYANOCOBALAMIN INJECTION, USP 1000MCG Aminister 1ml IM or sc monthly Qty:10 Repeats:0CIPROFLOXACIN 500MG Take 1 po bid for 14 days LU 332 Qty:28 Repeats:0WARFARIN 4MG Take 1 po od or as directed for 30 days Qty:30 Repeats:2FUROSEMIDE 40MG Take 2 Tabs PO OD for 60 Days Qty:120 Repeats:3WARFARIN 2MG take as directed Qty:90 Repeats:0CLOXACILLIN 500MG Take 2 capsules (1 g) PO QID for two months Qty:480 Repeats:0PERCOCET 325MG/5MG Take 1-2 tabs PO QID PRN (Max 8 tabs per day) Qty:112 Repeats:0LYRICA 75MG take BID PO Qty:60 Repeats:0CLOXACILLIN 250MG CAPSULE Take 1 po qid for 14 days Qty:56 Repeats:0WARFARIN 1MG PO OD as directed Qty:90 Repeats:0FELODIPINE 2.5MG TABLET (EXTENDED-RELEAS
12	current_rx_lt		current drugs marked as long term	CYANOCOBALAMIN INJECTION, USP 1000MCG Aminister 1ml IM or sc monthly Qty:10 Repeats:0WARFARIN 4MG Take 1 po od or as directed for 30 days Qty:30 Repeats:2FUROSEMIDE 40MG Take 2 Tabs PO OD for 60 Days Qty:120 Repeats:3WARFARIN 2MG take as directed Qty:90 Repeats:0CLOXACILLIN 500MG Take 2 capsules (1 g) PO QID for two months Qty:480 Repeats:0SITAGLIPTIN 100MG TABLET Take 1 po od for 90 days Qty:90 Repeats:0COUMADIN 5MG Take 1 po od for 90 days Qty:90 Repeats:0BISOPROLOL 5MG Take 1 po od for 90 days Qty:90 Repeats:3ATORVASTATIN 20MG TABLET Take 1 po od for 90 days Qty:90 Repeats:3FELODIPINE 5MG Take 1 Tabs PO OD for 90 days Qty:90 Repeats:3METFORMIN 500MG Take 1 tab at breakfast, 1 tab at luch and 2 tabs at supper. Qty:360 Repeats:3RAMIPRIL 10MG Take 2 tabs OD Qty:180 Repeats:3Glucometer Strips and Lancets 1 QID prn Qty:100 Repeats:99SILDENAFIL 100MG Take 1/2 Tabs PO OD for PRN 30Days Qty:4 Repeats:0FUROSEMIDE 40MG Take 1 Tabs PO OD for 90Days Qty:90 Repeats:3 FELODIPINE 5 MG Take 1 Ta
12	druglist_generic		Generic drug list one per line	ACETYLSALICYLIC ACID 25.0 MG DIPYRIDAMOLE 200.0 MG 1 BID ACETYLCYSTEINE 0 TID SALBUTAMOL (SALBUTAMOL SULFATE) 0 QID prn IPRATROPIUM BROMIDE 0 Q6H SALBUTAMOL (SALBUTAMOL SULFATE) 1 qid BETAHISTINE HYDROCHLORIDE 16.0 MG 1 TID FUROSEMIDE 20.0 MG 1 OD
12	druglist_trade		Trade drug list one per line	AGGRENOX 1 BID MUCOMYST INJ 200MG/ML 0 TID VENTOLIN 100MCG METERED-DOSE AEROSOL 0 QID prn ATROVENT .25MG SOLUTION 0 Q6H VENTOLIN 1MG LIQUID 1 qid NOVO-BETAHISTINE 16MG 1 TID LASIX 20 TAB 1 OD
12	druglist_line		the shortest druglist mixed case comma delineated	Aggrenox 1 BID, Mucomyst inj 200mg/ml 0 TID, Salbutamol 100mcg metered-dose aerosol 0 QID prn, Ipratropium bromide .25mg solution 0 Q6H, Salbutamol 1mg liquid 1 qid, Novo-betahistine 16mg 1 TID, Furosemide 20 tab 1 OD
12
15b803	latest_echart_note			[04-Jul-2018 .: inpatient 2/7 post pacemaker][8:18] Subjective: Doing well, some knee pain Objective: BP 123-146 systolic HR 60 minimal oedema painful rt knee on rom no effusion ligaments intact clinically rt heel necrotic patch basically unchanged apprx loonie sized Analysis: 1) Knee OA limited response post steroid injection 2) Heart block controlled with pacer 3) Vascular impairment rt foot Plan: physio and rehab d/w vascular sx [Signed on 04-Jul-2018 8:26 by Dr. P Hutten-Czapski]
15b803	todays_notes
15b803	todays_notes_ext
12	document_list		list of ids and documents	4865,Ultrasound Doppler Venous Lower Rt;7774,1-Pap 2010 recall;7993,4-Flu 2010 recall;32342,1-Pap 2010 recall;44341,CCAC- Initial;44411,CCAC – Client Services Plan;48232,Dr. Lewis
12	onGTPAL		Ontario Antenatal Record GTPAL code	GxTxPxAxLx
12	onEDB		Ontario Antenatal Record EDB	2016-12-31
12	bcGTPAL		British Columbia Antenatal Record GTPAL code	GxTxPxAxLx
12	bcEDD		British Columbia Antenatal Record EDD	2016-12-31
12	doctor		Last, First of doctor listed by Oscar in demographics	Hutten-Czapski, Peter
12	doctor_provider_no		Provider number	1007
12	doctor_ohip_no		Their billing number	120692
12	doctor_specialty_code		Their specialty	0
12	doctor_cpsid		Their CPSID	54345
15	doctor_title		from provider table	MD (this column is in the database but not editable)
12	provider_name		Last, First	Hutten-Czapski, Peter
12	provider_name_first_init		Name	P. Hutten-Czapski
12	doctor_work_phone		work no from the provider table	705-672-1111
15	doctor_signature		Their signature from provider preferences	MD
12	appt_provider_name		The provider listed for the appointment	Hutten-Czapski, Peter
12	appt_provider_id		The provider’s id listed for the appointment	121
12	appt_no		The appointment no	353104
15b803	appt_date		yyyy-mm-dd	2018-07-05
15b803	appt_time		hh:mm:ss	13:45:00
15b803	appt_end_time		hh:mm:ss	14:14:00
15b803	appt_provider_ohip_no		providers OHIP	120692
15b803	appt_provider_cpsid		providers College id	54345
15b803	next_appt_provider_id		OSCAR provider id	121
15b803	next_appt_provider_name		Provider name	Hutten-Czapski, Peter
15b803	next_appt_date		Date and time	2018-07-05, 13:45:00
15b803	next_appt_time		hh:mm	13:45:00
15b803	nextf_appt_date		yyyy-MONTH-dd	2018-07-05
12	referral_name		Last, First	Spade, Sam (These come from the ProfessionalSpecialists table using the ReferralNo)
15b803	referral_Last_name		Last	Spade
15b803	referral_first_name		First	Sam
12	referral_address		Multiline address	431 Whitewood Ave New Liskeard ON P0J 1P0
15b803	dr_referral_name		Dr.First Last	Dr.Sam Spade
15b803	referral_no		OHIP Provider Number of the referral	120692
12	referral_phone		Referral phone	(705) 647-1112 Ext 5422
12	referral_fax		Fax no	705-647-1234
12	bc_referral_name		Last, First	SPADE, SAM (These come from the billingreferral table using the ReferralNo)
12	bc_referral_address		Multiline address	431 Whitewood Ave New Liskeard ON P0J 1P0
12	bc_referral_phone		Referral phone	(604) 647-1112 Ext 5422
12	bc_referral_fax		Fax no	604-647-1234
12	bc_referral_no		Referring MD no	666666
12	clinic_name		name	Haileybury Family Health Team
12	clinic_phone		As per admin	705-672-1111
12	clinic_fax		As per admin	705-672-2222
12	clinic_label		Multiline name and address	Haileybury Family Health Team 2913 Meridian Haileybury,Ontario,P0J 1P0 Tel:672-1111Fax:705-672-2222
12	clinic_addressLine		Street	2913 Meridian
12	clinic_addressLineFull		Street, City, Province, Postal	2913 Meridian, Haileybury, Ontario, P0J 1P0
12	clinic_address		Multiline Note bug in where the P0J 1K0 goes	2913 Meridian Haileybury,P0J 1P0 Ontario,Canada
12	clinic_city		city	Haileybury
12	clinic_province		province	Ontario
12	clinic_postal		postal	P0J 1K0
12	dtap_immunization_date		DTaP date	1997-04-11
12	flu_immunization_date		flu shot date	2017-11-06
15b803	bcg_immunization_date		BCG date	1997-04-11
15b803	rmenb_immunization_date		BEXSERO or rMenB	1997-04-11
15b803	cholera_immunization_date		CHOLERA date	1997-04-11
15b803	chol_ecol_o_immunization_date		Chol-Ecol-Oral date	1997-04-11
19b1360	covid_immunization_date		COVID-19 vaccination date	2021-07-01
15b803	dpt_polio_immunization_date		DPT POLIO date	DEPRECIATED prevention type use DTaP-IPV instead
15b803	dptp_hib_immunization_date		DPTP-Hib date	DEPRECIATED prevention type use TdP-IPV-Hib instead
15b803	dt_ipv_immunization_date		DT-IPV date	1997-04-11
15b803	dtap_hbv_ipv_hib_immunization_date		DTaP-HBV-IPV-Hib	1997-04-11
15b803	dtap_hib_immunization_date		DTaP-Hib date	1997-04-11
15b803	dtap_ipv_immunization_date		DTaP-IPV date	1997-04-11
15b803	dtap_ipv_hb_immunization_date		DTaP-IPV-HB date	1997-04-11
15b803	dtap_ipv_hib_immunization_date		DTaP-IPV-Hib date	1997-04-11
15b803	h1n1_immunization_date		H1N1 date	1997-04-11
15b803	hbtmf_immunization_date		HBTmf date	1997-04-11
15b803	hpv_vaccine_immunization_date		HPV date	1997-04-11
15b803	hpv_vaccine_9_immunization_date		HPV Vaccine 9 date	DEPRECIATED prevention type use HPV instead
15b803	hepa_immunization_date		HepA date	1997-04-11
15b803	hepab_immunization_date		HepAB date	1997-04-11
15b803	hepb_immunization_date		HepB date	1997-04-11
15b803	hib_immunization_date		Hib date	1997-04-11
15b803	ipv_immunization_date		IPV date	1997-04-11
15b803	je_immunization_date		JE date	1997-04-11
15b803	men_con_acwy_immunization_date		MEN-CONJ-ACWY or Men-C-ACYW-135	1997-04-11
15b803	mmr_immunization_date		MMR date	1997-04-11
15b803	mmrv_immunization_date		MMRV date	1997-04-11
15b803	mr_immunization_date		MR date	1997-04-11
15b803	mantoux_immunization_date		Mantoux date	1997-04-11
15b803	measles_immunization_date		Measles date	1997-04-11
15b803	men_p_ac_immunization_date		Men-P-AC date	1997-04-11
15b803	men_p_acwy_immunization_date		Men-P-ACWY date	1997-04-11
15b803	menb_b_immunization_date		MenB-B date	DEPRECIATED prevention type use rMenB instead
15b803	menc_c_immunization_date		MenC-C date	1997-04-11
15b803	mumps_immunization_date		Mumps date	This apconfig.xml entry is currently broken
15b803	opv_immunization_date		OPV date	No matching prevention currently
15b803	otherA_immunization_date		OtherA date	1997-04-11
15b803	pediacel_immunization_date		pediacel date	DEPRECIATED prevention type use DTaP-IPV-Hib instead
15b803	pneu_c_immunization_date		Pneu-C or prevnar	1997-04-11
15b803	pneumovax_immunization_date		Pneumovax date	1997-04-11
15b803	prolia_immunization_date		prolia date	DEPRECIATED prevention type
15b803	RABIES_immunization_date		RABIES date	DEPRECIATED prevention type use Rabies instead
15b803	rabies_immunization_date		Rabies date	1997-04-11
15b803	rot_immunization_date		Rot date	1997-04-11
15b803	rubella_immunization_date		Rubella date	DEPRECIATED prevention type
15b803	shingles_immunization_date		SHINGLES or HZV or RZV	1997-04-11
15b803	t_immunization_date		T date	1997-04-11
15b803	tbe_immunization_date		TBE date	1997-04-11
15b803	td_immunization_date		Td date	1997-04-11
15b803	td_ipv_immunization_date		Td-IPV (adult) date	1997-04-11
15b803	tdp_immunization_date		TdP date	1997-04-11
15b803	tdp_ipv_hib_immunization_date		TdP-IPV-Hib date	1997-04-11
15b803	tdap_ipv_immunization_date		Tdap-IPV date	1997-04-11
15b803	tuberculosis_immunization_date		Tuberculosis date	DEPRECIATED prevention type use BCG instead
15b803	typh-o_immunization_date		Typh-O(ral) date	1997-04-11
15b803	typhoid_immunization_date		Thyphoid date	1997-04-11
15b803	vz_immunization_date		Varicella V date	1997-04-11
15b803	varicella_immunization_date		Varicella date	DEPRECIATED prevention type use VZ instead
15b803	yf_immunization_date		Yellow Fever date	1997-04-11
15b803	bmd_immunization_date		BMD date	1997-04-11
15b803	bmd_immunization_last_value		BMD Value	abnormal
15b803	colonoscopy_immunization_date		COLONOSCOPY date	1997-04-11
15b803	colonoscopy_immunization_last_value		COLONOSCOPY Value	normal
15b803	fobt_immunization_date		FOBT date	1997-04-11
15b803	fobt_immunization_last_value		FOBT Value	pending
15b803	bmd_immunization_date		date	1997-04-11
15b803	pft_immunization_date		PFT date	DEPRECIATED prevention type
15b803	mam_immunization_date		MAM date	1997-04-11
15b803	mam_immunization_data		all MAM result	pending normal normal
15b803	mam_immunization_last_value		MAM Value	normal
15b803	pap_immunization_date		PAP Date	1997-04-11
15b803	pap_immunization_last_value		PAP Value	normal
15b803	psa_immunization_date		PSA Date	1997-04-11
15b803	psa_immunization_last_value		PSA Value	normal
15b803	abdo_immunization_date		Abdo U/S for AAA	DEPRECIATED prevention type
15b803	bone_scan_immunization_date		BONE SCAN date	DEPRECIATED prevention type
15b803	cpx_immunization_date		CPX date	DEPRECIATED prevention type
15b803	ct_scan_immunization_date		CT Scan date	DEPRECIATED prevention type
15b803	cxr_immunization_date		CXR	DEPRECIATED prevention type
15b803	chlamydia_immunization_date		chlamydia test date	1997-04-11
15b803	ecg_immunization_date		ECG	DEPRECIATED prevention type
15b803	eeg_immunization_date		EEG	DEPRECIATED prevention type
15b803	ekg_immunization_date		EKG	DEPRECIATED prevention type
15b803	emg_immunization_date		EMG	DEPRECIATED prevention type
15b803	ekg_immunization_date		EKG	DEPRECIATED prevention type
15b803	endoscopy_immunization_date		ENDOSCOPY	DEPRECIATED prevention type
15b803	echo_immunization_date		Echo	DEPRECIATED prevention type
15b803	fobt_immunization_date		fobt date	1997-04-11
15b803	gonorrhea_pcr_immunization_date		Gonorrhea PCR	1997-04-11
15b803	hiv_immunization_date		HIV test date	1997-04-11
15b803	hepa_immunization_date		HepA screen	DEPRECIATED prevention type
15b803	hepb_immunization_date		HepB screen	1997-04-11
15b803	hepc_immunization_date		HepC screen	1997-04-11
15b803	mammogram_immunization_date		mammo date	DEPRECATED see mam tags
15b803	pap_immunization_date		pap date	1997-04-11
15b803	mmse_immunization_date		MMSE	DEPRECIATED prevention type
15b803	mri_immunization_date		MRI	DEPRECIATED prevention type
15b803	moca_immunization_date		MoCA	DEPRECIATED prevention type
15b803	moca_immunization_date		OtherB date	1997-04-11
15b803	pet_scan_immunization_date		PET SCAN	DEPRECIATED prevention type
15b803	sleep_study_immunization_date		Sleep Study	DEPRECIATED prevention type
15b803	stress_test_immunization_date		Stress Test	DEPRECIATED prevention type
15b803	ultrasound_immunization_date		Ultrasound	DEPRECIATED prevention type
15b803	vdrl_immunization_date		VDRL date	1997-04-11
15b803	virtual_colonscopy_immunization_date		VIRTUAL COLONOSCOPY	DEPRECIATED prevention type
15b803	xrays_immunization_date		XRays	DEPRECIATED prevention type
12
12	cytology_no		cytology number	number (from demographicExt table where key = ‘cytolNum’)
12	guardian_label		from new relationships tables first last address city province postal	MIKE MACDONALD 431 Whitewood Ave New Liskeard ON P0J 1P0
12	guardian_label2		Substitute Decision Maker first last address city province postal	MIKE MACDONALD 431 Whitewood Ave New Liskeard ON P0J 1P0
12	email		patient email	my.name@gmail.com
15	urine_tox_test_json		Measurements OPID MAMP BZD CANB Uetc	[{“type”:”BZD”,”dataField”:”pos”,”comments”:””,”dateObserved”:”2016-04-04 00:00:00.0″,”dateEntered”:”2016-04-04 12:34:46.0″},{“type”:”MAMP”,”dataField”:”neg”,”comments”:””,”dateObserved”:”2016-04-04 00:00:00.0″,”dateEntered”:”2016-04-04 12:34:46.0″}]
15	methadone_induction_assessment_json		Measurements RHU ORDU MDD GWS	[{“type”:”RHU”,”dataField”:”Yes”,”comments”:””,”dateObserved”:”2016-04-04 00:00:00.0″,”dateEntered”:”2016-04-04 12:34:46.0″}]