Search the OSCAR Documentation
< All Topics
Print

eForm Magic Part A – Standard Tags

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″}]
Table of Contents