|
|
| (42 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| == what is this? ==
| | This page generates an automatically updated list of '''data fields''' in the Critical Care and Medicine Database based on contents of this wiki. For a more general overview see [[Data User Portal for the Manitoba Critical Care and Medicine Databases]]. For information on the general data structure, see [[CCMDB Data Structure]]. For information on data encoded in the [[Entity–attribute–value model of the L_Tmp_V2 table]], see [[Projects]]. For details on information derived from this data, see [[Indicators]]. |
| This article transcludes the articles for our data fields, or ideally their <nowiki><onlyinclude></nowiki> sections. | |
|
| |
|
| Work in progress, all articles need to be updated for this to work.
| | == data fields == |
| == L_Log ==
| | We collect a total of '''{{#ask: [[Category:Data structure]] [[FieldName::>""]] |
| ===Pat_ID ===
| | | limit=1000 |
| {{:Pat_ID}}
| | | format=count |
| === LastName ===
| | }}''' fields, but since much of our data is relational this doesn't really give an indication of how many things we collect. |
| {{:Last Name}}
| | |
| === FirstName ===
| | === Currently collected === |
| {{:First Name}}
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate::1 January 2100]] |
| === PHIN ===
| | | ?InTable = Table |
| {{:PHIN}}
| | | ?FieldCCMDBTab= Tab |
| === Birth ===
| | | ?FieldDataType= Data type |
| {{:Date of Birth}}
| | | ?FieldLength= length |
| === Chart ===
| | | ?DataElementDescription=Description |
| {{:Chart}} | | | ?DataElementStartDate=Start date |
| === start_Time ===
| | | ?FieldCreatedRaw=Created vs raw |
| {{:Start time}}
| | | limit=1000 |
| === start_Date ===
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| {{:Start date}}
| | | format=table |
| === Notes ===
| | }} |
| {{:Notes field}}
| | |
| ==todo== | | === Legacy data === |
| === FinalCheck === | | {{Collapsable |
| {{: FinalCheck}}
| | | always= Click to see legacy data only |
| === R_Location ===
| | | full= |
| {{: R_Location}}
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]] |
| === R_dc_treat === | | | ?InTable = Table |
| {{: R_dc_treat}} | | | ?FieldCCMDBTab= Tab |
| === R_AdmitFrom ===
| | | ?FieldDataType= Data type |
| {{: R_AdmitFrom}}
| | | ?FieldLength= length |
| === R_DischargedTo ===
| | | ?DataElementDescription=Description |
| {{: R_DischargedTo}}
| | | ?DataElementStartDate=Start date |
| === R_HospitalPrevious ===
| | | ?DataElementEndDate=End date |
| {{: R_HospitalPrevious}}
| | | ?FieldCreatedRaw=Created vs raw |
| === R_Province ===
| | | limit=1000 |
| {{: R_Province}}
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| === R_Sex ===
| | | format=table |
| {{: R_Sex}}
| | }} |
| === R_Type === | | }} |
| {{: R_Type}}
| | |
| === R_SurviveExpire === | | === Full list === |
| {{: R_SurviveExpire}}
| | {{Collapsable |
| === R_AdmDate === | | | always= Click to see full list |
| {{: R_AdmDate}}
| | | full= |
| === R_AdmTime ===
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] | |
| {{: R_AdmTime}}
| | | ?InTable = Table |
| === R_TRDate === | | | ?FieldCCMDBTab= Tab |
| {{: R_TRDate}}
| | | ?FieldDataType= Data type |
| === R_TRTime === | | | ?FieldLength= length |
| {{: R_TRTime}}
| | | ?DataElementDescription=Description |
| === R_DisDate === | | | ?DataElementStartDate=Start date |
| {{: R_DisDate}}
| | | ?DataElementEndDate=End date |
| === R_DisTime ===
| | | ?FieldCreatedRaw=Created vs raw |
| {{: R_DisTime}}
| | | limit=1000 |
| === R_Filter === | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| {{: R_Filter}}
| | | format=table |
| === Var1 === | | }} |
| {{: Var1}}
| | }} |
| === Var2 ===
| | |
| {{: Var2}}
| | == Background / Implementation of this page == |
| === Var3 === | | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| {{: Var3}} | | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| === Var4 === | | |
| {{: Var4}}
| | == Related articles == |
| === Var5 ===
| | {{Related Articles}} |
| {{: Var5}} | | |
| === Var6 ===
| | |
| {{: Var6}}
| | [[Category:Data structure]] |
| === PostalCode === {{: PostalCode}}
| |
| === LastOpened_DtTm === {{: LastOpened_DtTm}}
| |
| === Pre_Acute_Living_Situation === {{: Pre_Acute_Living_Situation}}
| |
| === Pre_admit_Inpatient_Institution === {{: Pre_admit_Inpatient_Institution}} | |
| === Previous_Location === {{: Previous_Location}} | |
| === Previous_Service === {{: Previous_Service}} | |
| === off_ward === {{: off_ward}} | |
| === Service_Location === {{: Service_Location}} | |
| === Dispo === {{: Dispo}} | |
| === Visit_Admit_DtTm === {{: Visit_Admit_DtTm}} | |
| === Accept_DtTm === | |
| {{:Accept_DtTm Field}}
| |
| === Arrive_DtTm === | |
| {{:Arrive_DtTm Field}}
| |
| === Dispo_DtTm === | |
| {{: Dispo_DtTm Field}}
| |
| === Transfer_Ready_DtTm === {{: Transfer_Ready_DtTm}}
| |
| === TR_info_status === {{: TR_info_status}}
| |
| === ADL_Bathing === {{: ADL_Bathing}}
| |
| === ADL_Dressing === {{: ADL_Dressing}}
| |
| === ADL_Toileting === {{: ADL_Toileting}} | |
| === ADL_Transfering === {{: ADL_Transfering}}
| |
| === ADL_Continence === {{: ADL_Continence}} | |
| === ADL_Feeding === {{: ADL_Feeding}} | |
| === Ap_AdmitType === {{: Ap_AdmitType}}
| |
| === Ap_Chronic === {{: Ap_Chronic}}
| |
| === Ap_Temp === {{: Ap_Temp}}
| |
| === Ap_SapsSysBP === {{: Ap_SapsSysBP}}
| |
| === Ap_APSysBP === {{: Ap_APSysBP}} | |
| === Ap_APDiasBP === {{: Ap_APDiasBP}} | |
| === Ap_HeartRate === {{: Ap_HeartRate}} | |
| === Ap_RespRate === {{: Ap_RespRate}} | |
| === Ap_Eye === {{: Ap_Eye}} | |
| === Ap_Motor === {{: Ap_Motor}} | |
| === Ap_Verbal === {{: Ap_Verbal}} | |
| === Ap_FIO2 === {{: Ap_FIO2}} | |
| === Ap_PO2 === {{: Ap_PO2}} | |
| === Ap_CO2 === {{: Ap_CO2}} | |
| === Ap_pH === {{: Ap_pH}} | |
| === Ap_SerCO2 === {{: Ap_SerCO2}}
| |
| === Ap_Na === {{: Ap_Na}}
| |
| === Ap_K === {{: Ap_K}}
| |
| === Ap_Hemat === {{: Ap_Hemat}} | |
| === Ap_WBC === {{: Ap_WBC}}
| |
| === Ap_Creat === {{: Ap_Creat}}
| |
| === Ap_ARF === {{: Ap_ARF}}
| |
| === R_Complete === {{: R_Complete}}
| |
| === ADL_Complete === {{: ADL_Complete}}
| |
| === Ap_Complete === {{: Ap_Complete}}
| |
| === ApLab_Complete === {{: ApLab_Complete}}
| |
| === Labs_Complete === {{: Labs_Complete}}
| |
| === Tmp_Complete === {{: Tmp_Complete}}
| |
| === Como_Complete === {{: Como_Complete}}
| |
| === Diag_Complete === {{: Diag_Complete}}
| |
| === Pharm_Complete === {{: Pharm_Complete}}
| |
| === Pharm_Flow_Complete === {{: Pharm_Flow_Complete}}
| |
| === Record === {{: Record}}
| |
| === Room_nr === {{: Room_nr}}
| |
| === RecordStatus === {{: RecordStatus}}
| |
| === LastChanged_DtTm === {{: LastChanged_DtTm}}
| |
| === [pharm_Vitamin K antagonists] === {{: [pharm_Vitamin K antagonists]}}
| |
| === [pharm_Heparin cont inf] === {{: [pharm_Heparin cont inf]}}
| |
| === [pharm_Direct thrombin inhibitors] === {{: [pharm_Direct thrombin inhibitors]}}
| |
| === pharm_Heparinoids === {{: pharm_Heparinoids}}
| |
| === [pharm_Factor Xa inhibitors] === {{: [pharm_Factor Xa inhibitors]}}
| |
| === [pharm_Dopamine cont inf] === {{: [pharm_Dopamine cont inf]}}
| |
| === [pharm_Dobutamine cont inf] === {{: [pharm_Dobutamine cont inf]}}
| |
| === [pharm_Norepinephrine cont inf] === {{: [pharm_Norepinephrine cont inf]}}
| |
| === [pharm_Epinephrine cont inf] === {{: [pharm_Epinephrine cont inf]}}
| |
| === [pharm_Phenylephrine cont inf] === {{: [pharm_Phenylephrine cont inf]}}
| |
| === [pharm_Vasopressin cont inf] === {{: [pharm_Vasopressin cont inf]}}
| |
| === [pharm_Milrinone cont inf] === {{: [pharm_Milrinone cont inf]}}
| |
| === [pharm_Paralytics cont inf] === {{: [pharm_Paralytics cont inf]}} | |
| === pharm_corticosteroids === {{: pharm_corticosteroids}}
| |
| === [pharm_amphotericin B] === {{: [pharm_amphotericin B]}}
| |
| === pharm_macrolides === {{: pharm_macrolides}}
| |
| === [pharm_1st or 2nd generation cephalosporins] === {{: [pharm_1st or 2nd generation cephalosporins]}}
| |
| === [pharm_4th generation cephalosporins] === {{: [pharm_4th generation cephalosporins]}}
| |
| === [pharm_antistaph penicillins] === {{: [pharm_antistaph penicillins]}}
| |
| === pharm_aminoglycosides === {{: pharm_aminoglycosides}}
| |
| === [pharm_influenza drugs] === {{: [pharm_influenza drugs]}}
| |
| === pharm_bosentan === {{: pharm_bosentan}}
| |
| === [pharm_viagra-type vasodilators] === {{: [pharm_viagra-type vasodilators]}}
| |
| === [pharm_special upper GI bleeding agents] === {{: [pharm_special upper GI bleeding agents]}}
| |
| === pharm_amiodarones === {{: pharm_amiodarones}}
| |
| === [pharm_anti-TB drugs] === {{: [pharm_anti-TB drugs]}}
| |
| === pharm_statins === {{: pharm_statins}}
| |
| === pharm_PPI === {{: pharm_PPI}}
| |
| === pharm_H2_blockers === {{: pharm_H2_blockers}}
| |
| === pharm_furosemide === {{: pharm_furosemide}}
| |
| === pharm_heparin_sq === {{: pharm_heparin_sq}}
| |
| === pharm_LMWH === {{: pharm_LMWH}}
| |
| === pharm_benzodiazepines === {{: pharm_benzodiazepines}}
| |
| === pharm_opioids === {{: pharm_opioids}}
| |
| === pharm_propofol === {{: pharm_propofol}}
| |
| === pharm_insulin === {{: pharm_insulin}}
| |