|
|
| (39 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 ===
| |
| {{:First Name}}
| |
| === PHIN ===
| |
| {{:PHIN}}
| |
| === Birth ===
| |
| {{:Date of Birth}}
| |
| === Chart ===
| |
| {{:Chart}}
| |
| === start_Time ===
| |
| {{:Start time}}
| |
| === start_Date === | |
| {{:Start date}}
| |
| === Notes === | |
| {{:Notes field}}
| |
|
| |
|
| == To do == | | === Currently collected === |
| === R_dc_treat ===
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate::1 January 2100]] |
| {{: R_dc_treat}} | | | ?InTable = Table |
| === R_Province === | | | ?FieldCCMDBTab= Tab |
| {{: R_Province}}
| | | ?FieldDataType= Data type |
| === R_Sex === | | | ?FieldLength= length |
| {{: R_Sex}}
| | | ?DataElementDescription=Description |
| === R_Type === | | | ?DataElementStartDate=Start date |
| {{: R_Type}}
| | | ?FieldCreatedRaw=Created vs raw |
| === FinalCheck === | | | limit=1000 |
| {{: FinalCheck}}
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| | | format=table |
| | }} |
|
| |
|
| | === Legacy data === |
| | {{Collapsable |
| | | always= Click to see legacy data only |
| | | full= |
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]] |
| | | ?InTable = Table |
| | | ?FieldCCMDBTab= Tab |
| | | ?FieldDataType= Data type |
| | | ?FieldLength= length |
| | | ?DataElementDescription=Description |
| | | ?DataElementStartDate=Start date |
| | | ?DataElementEndDate=End date |
| | | ?FieldCreatedRaw=Created vs raw |
| | | limit=1000 |
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| | | format=table |
| | }} |
| | }} |
|
| |
|
| === LastOpened_DtTm === | | === Full list === |
| {{: LastOpened_DtTm}} | | {{Collapsable |
| === Pre_Acute_Living_Situation === | | | always= Click to see full list |
| {{: Pre_Acute_Living_Situation}}
| | | full= |
| === Pre_admit_Inpatient_Institution ===
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] | |
| {{: Pre_admit_Inpatient_Institution}} | | | ?InTable = Table |
| === Previous_Location ===
| | | ?FieldCCMDBTab= Tab |
| {{: Previous_Location}}
| | | ?FieldDataType= Data type |
| === Previous_Service ===
| | | ?FieldLength= length |
| {{: Previous_Service}}
| | | ?DataElementDescription=Description |
| === off_ward ===
| | | ?DataElementStartDate=Start date |
| {{: off_ward}}
| | | ?DataElementEndDate=End date |
| === Service_Location === | | | ?FieldCreatedRaw=Created vs raw |
| {{: Service_Location}}
| | | limit=1000 |
| === Dispo === {{: Dispo}} | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| === Visit_Admit_DtTm === | | | format=table |
| {{: 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_* entries ===
| |
| For the following fields see [[:Category:Pharmacy]]:
| |
| * pharm_Vitamin K antagonists
| |
| * pharm_Heparin cont inf
| |
| * pharm_Direct thrombin inhibitors
| |
| * pharm_Heparinoids
| |
| * pharm_Factor Xa inhibitors
| |
| * pharm_Dopamine cont inf
| |
| * pharm_Dobutamine cont inf
| |
| * pharm_Norepinephrine cont inf
| |
| * pharm_Epinephrine cont inf
| |
| * pharm_Phenylephrine cont inf
| |
| * pharm_Vasopressin cont inf
| |
| * pharm_Milrinone cont inf
| |
| * pharm_Paralytics cont inf
| |
| * pharm_corticosteroids
| |
| * pharm_amphotericin B
| |
| * pharm_macrolides
| |
| * pharm_1st or 2nd generation cephalosporins
| |
| * pharm_4th generation cephalosporins
| |
| * pharm_antistaph penicillins
| |
| * pharm_aminoglycosides
| |
| * pharm_influenza drugs
| |
| * pharm_bosentan
| |
| * pharm_viagra-type vasodilators
| |
| * pharm_special upper GI bleeding agents
| |
| * pharm_amiodarones
| |
| * pharm_anti-TB drugs
| |
| * pharm_statins
| |
| * pharm_PPI
| |
| * pharm_H2_blockers
| |
| * pharm_furosemide
| |
| * pharm_heparin_sq
| |
| * pharm_LMWH
| |
| * pharm_benzodiazepines
| |
| * pharm_opioids
| |
| * pharm_propofol
| |
| * pharm_insulin
| |
|
| |
|
| == pre-[[2016 Time and Place changes]] fields == | | == Background / Implementation of this page == |
| === R_Location ===
| | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| {{: R_Location}}
| | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| === R_AdmitFrom ===
| | |
| {{: R_AdmitFrom}}
| | == Related articles == |
| === R_DischargedTo ===
| | {{Related Articles}} |
| {{: R_DischargedTo}}
| | |
| === R_HospitalPrevious ===
| | |
| {{: R_HospitalPrevious}}
| | [[Category: Data structure]] |
| === R_SurviveExpire ===
| |
| {{: R_SurviveExpire}}
| |
| === R_AdmDate === | |
| {{: R_AdmDate}} | |
| === R_AdmTime ===
| |
| {{: R_AdmTime}}
| |
| === R_TRDate ===
| |
| {{: R_TRDate}}
| |
| === R_TRTime ===
| |
| {{: R_TRTime}}
| |
| === R_DisDate ===
| |
| {{: R_DisDate}}
| |
| === R_DisTime ===
| |
| {{: R_DisTime}}
| |
| === R_Filter ===
| |
| {{: R_Filter}}
| |
| === Var1 ===
| |
| {{: Var1}}
| |
| === Var2 ===
| |
| {{: Var2}}
| |
| === Var3 ===
| |
| {{: Var3}}
| |
| === Var4 ===
| |
| {{: Var4}}
| |
| === Var5 ===
| |
| {{: Var5}}
| |
| === Var6 ===
| |
| {{: Var6}}
| |
| === PostalCode ===
| |
| {{: PostalCode}}
| |