|
|
| (46 intermediate revisions by the same user not shown) |
| Line 1: |
Line 1: |
| This article transcludes the articles for our data fields, or ideally their <nowiki><onlyinclude></nowiki> sections. | | 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]]. |
|
| |
|
| == L_Log == | | == data fields == |
| ===Pat_ID === {{:Pat_ID}}
| | We collect a total of '''{{#ask: [[Category:Data structure]] [[FieldName::>""]] |
| === LastName === {{: LastName}}
| | | limit=1000 |
| === FirstName === {{: FirstName}}
| | | format=count |
| === PHIN === {{: PHIN}}
| | }}''' fields, but since much of our data is relational this doesn't really give an indication of how many things we collect. |
| === Birth === {{: Birth}} | | |
| === Chart === {{: Chart}} | | === Currently collected === |
| === start_Time === {{: start_Time}}
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate::1 January 2100]] |
| === start_Date === {{: start_Date}}
| | | ?InTable = Table |
| === Notes === {{: Notes}} | | | ?FieldCCMDBTab= Tab |
| === FinalCheck === {{: FinalCheck}}
| | | ?FieldDataType= Data type |
| === R_Location === {{: R_Location}}
| | | ?FieldLength= length |
| === R_dc_treat === {{: R_dc_treat}}
| | | ?DataElementDescription=Description |
| === R_AdmitFrom === {{: R_AdmitFrom}}
| | | ?DataElementStartDate=Start date |
| === R_DischargedTo === {{: R_DischargedTo}}
| | | ?FieldCreatedRaw=Created vs raw |
| === R_HospitalPrevious === {{: R_HospitalPrevious}}
| | | limit=1000 |
| === R_Province === {{: R_Province}} | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| === R_Sex === {{: R_Sex}} | | | format=table |
| === R_Type === {{: R_Type}} | | }} |
| === R_SurviveExpire === {{: R_SurviveExpire}} | | |
| === R_AdmDate === {{: R_AdmDate}} | | === Legacy data === |
| === R_AdmTime === {{: R_AdmTime}} | | {{Collapsable |
| === R_TRDate === {{: R_TRDate}} | | | always= Click to see legacy data only |
| === R_TRTime === {{: R_TRTime}} | | | full= |
| === R_DisDate === {{: R_DisDate}} | | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]] |
| === R_DisTime === {{: R_DisTime}} | | | ?InTable = Table |
| === R_Filter === {{: R_Filter}}
| | | ?FieldCCMDBTab= Tab |
| === Var1 === {{: Var1}}
| | | ?FieldDataType= Data type |
| === Var2 === {{: Var2}} | | | ?FieldLength= length |
| === Var3 === {{: Var3}}
| | | ?DataElementDescription=Description |
| === Var4 === {{: Var4}} | | | ?DataElementStartDate=Start date |
| === Var5 === {{: Var5}} | | | ?DataElementEndDate=End date |
| === Var6 === {{: Var6}}
| | | ?FieldCreatedRaw=Created vs raw |
| === PostalCode === {{: PostalCode}}
| | | limit=1000 |
| === LastOpened_DtTm === {{: LastOpened_DtTm}}
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| === Pre_Acute_Living_Situation === {{: Pre_Acute_Living_Situation}}
| | | format=table |
| === Pre_admit_Inpatient_Institution === {{: Pre_admit_Inpatient_Institution}}
| | }} |
| === Previous_Location === {{: Previous_Location}} | | }} |
| === Previous_Service === {{: Previous_Service}} | | |
| === off_ward === {{: off_ward}} | | === Full list === |
| === Service_Location === {{: Service_Location}} | | {{Collapsable |
| === Dispo === {{: Dispo}} | | | always= Click to see full list |
| === Visit_Admit_DtTm === {{: Visit_Admit_DtTm}} | | | full= |
| === Accept_DtTm === {{: Accept_DtTm}} | | {{#ask: [[Category:Data structure]] [[FieldName::>""]] | |
| === Arrive_DtTm === {{: Arrive_DtTm}} | | | ?InTable = Table |
| === Dispo_DtTm === {{: Dispo_DtTm}} | | | ?FieldCCMDBTab= Tab |
| === Transfer_Ready_DtTm === {{: Transfer_Ready_DtTm}} | | | ?FieldDataType= Data type |
| === TR_info_status === {{: TR_info_status}} | | | ?FieldLength= length |
| === ADL_Bathing === {{: ADL_Bathing}}
| | | ?DataElementDescription=Description |
| === ADL_Dressing === {{: ADL_Dressing}}
| | | ?DataElementStartDate=Start date |
| === ADL_Toileting === {{: ADL_Toileting}}
| | | ?DataElementEndDate=End date |
| === ADL_Transfering === {{: ADL_Transfering}} | | | ?FieldCreatedRaw=Created vs raw |
| === ADL_Continence === {{: ADL_Continence}}
| | | limit=1000 |
| === ADL_Feeding === {{: ADL_Feeding}} | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| === Ap_AdmitType === {{: Ap_AdmitType}} | | | format=table |
| === Ap_Chronic === {{: Ap_Chronic}}
| | }} |
| === Ap_Temp === {{: Ap_Temp}}
| | }} |
| === Ap_SapsSysBP === {{: Ap_SapsSysBP}}
| | |
| === Ap_APSysBP === {{: Ap_APSysBP}}
| | == Background / Implementation of this page == |
| === Ap_APDiasBP === {{: Ap_APDiasBP}} | | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| === Ap_HeartRate === {{: Ap_HeartRate}} | | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| === Ap_RespRate === {{: Ap_RespRate}} | | |
| === Ap_Eye === {{: Ap_Eye}} | | == Related articles == |
| === Ap_Motor === {{: Ap_Motor}} | | {{Related Articles}} |
| === Ap_Verbal === {{: Ap_Verbal}} | | |
| === Ap_FIO2 === {{: Ap_FIO2}} | | |
| === Ap_PO2 === {{: Ap_PO2}} | | [[Category:Data structure]] |
| === 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}}
| |