|
|
| (34 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}}
| |
|
| |
|
| === [[DC Treatment]] (R_dc_treat) === | | === Currently collected === |
| {{:DC Treatment}} | | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate::1 January 2100]] |
| === [[Province Field]] (R_Province) ===
| | | ?InTable = Table |
| {{:Province Field}}
| | | ?FieldCCMDBTab= Tab |
| === [[Sex field]] (R_Sex) ===
| | | ?FieldDataType= Data type |
| {{:Sex field}}
| | | ?FieldLength= length |
| === [[Registry Patient Type]] (R_Type) ===
| | | ?DataElementDescription=Description |
| {{:Registry Patient Type}}
| | | ?DataElementStartDate=Start date |
| === FinalCheck ===
| | | ?FieldCreatedRaw=Created vs raw |
| {{: FinalCheck}}
| | | limit=1000 |
| === [[Last Opened field]] (LastOpened_DtTm) ===
| | | intro=This is a list of fields in the Critical Care and Medicine Database |
| {{:Last Opened field}}
| | | format=table |
| === [[Pre acute living situation field]] ===
| | }} |
| {{:Pre acute living situation field}}
| |
| === [[Pre-admit Inpatient Institution field]] ===
| |
| {{:Pre-admit Inpatient Institution field}}
| |
| === [[Previous Location field]] ===
| |
| {{:Previous Location field}}
| |
| === [[Previous Service field]] ===
| |
| {{:Previous Service field}}
| |
| === [[Off ward field]] ===
| |
| {{:Off ward field}}
| |
| === [[Service/Location field]] ===
| |
| {{:Service/Location field}}
| |
| === [[Dispo field]] ===
| |
| {{:Dispo field}}
| |
| === [[Visit Admit DtTm field]] ===
| |
| {{:Visit Admit DtTm field}}
| |
| === [[Accept_DtTm field]] ===
| |
| {{:Accept_DtTm field}}
| |
| === [[Arrive_DtTm field]] ===
| |
| {{:Arrive_DtTm field}}
| |
| === [[Dispo_DtTm field]] ===
| |
| {{:Dispo_DtTm field}}
| |
| === [[Transfer_Ready_DtTm field]] ===
| |
| {{:Transfer_Ready_DtTm field}}
| |
| === [[TR_info_status field]] ===
| |
| {{:TR_info_status field}}
| |
| === [[ADL General Collection Information|ADL]] ===
| |
| {{:ADL General Collection Information}}
| |
|
| |
|
| Fields:
| | === Legacy data === |
| *ADL_Bathing
| | {{Collapsable |
| *ADL_Dressing
| | | always= Click to see legacy data only |
| *ADL_Toileting
| | | full= |
| *ADL_Transfering
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]] |
| *ADL_Continence
| | | ?InTable = Table |
| *ADL_Feeding
| | | ?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 |
| | }} |
| | }} |
|
| |
|
| == [[:Category:APACHE II|Apache fields]] == | | === Full list === |
| | {{Collapsable |
| | | always= Click to see full list |
| | | full= |
| | {{#ask: [[Category:Data structure]] [[FieldName::>""]] | |
| | | ?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 |
| | }} |
| | }} |
|
| |
|
| === [[Admit Type for APACHE II]] (Ap_AdmitType) === | | == Background / Implementation of this page == |
| {{:Admit Type for APACHE II}}
| | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| === [[Chronic Health APACHE]] (Ap_Chronic) ===
| | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| {{:Chronic Health APACHE}}
| |
| === [[Temperature]] (Ap_Temp) ===
| |
| {{:Temperature }}
| |
| === [[SAPS BP Field]] (Ap_SapsSysBP) ===
| |
| {{:SAPS BP Field}}
| |
| === [[AP Sys BP Field]] (Ap_APSysBP) ===
| |
| {{:AP Sys BP Field}}
| |
| === [[AP Dias BP Field]] (Ap_APDiasBP) ===
| |
| {{:AP Dias BP Field}}
| |
| === [[HR]] (Ap_HeartRate) ===
| |
| {{:HR}}
| |
| === [[RR]] (Ap_RespRate) ===
| |
| {{:RR}}
| |
| === [[Glasgow Coma Scale]] ===
| |
| {{:Glasgow Coma Scale}}
| |
|
| |
|
| Fields:
| | == Related articles == |
| * Ap_Eye
| | {{Related Articles}} |
| * Ap_Motor
| |
| * Ap_Verbal
| |
| === [[FiO2]] (Ap_FIO2) ===
| |
| {{:FiO2}}
| |
| === [[PO2]] Ap_PO2 ===
| |
| {{:PO2}}
| |
| === [[CO2]] Ap_CO2 ===
| |
| {{:CO2}}
| |
| === [[pH]] (Ap_pH) ===
| |
| {{:pH}}
| |
| === [[Serum CO2]] (Ap_SerCO2) ===
| |
| {{:Serum CO2}}
| |
| === [[Na]] (Ap_Na) ===
| |
| {{:Na}}
| |
| === [[K]] Ap_K ===
| |
| {{:K}}
| |
| === [[HCT]] (Ap_Hemat) ===
| |
| {{:HCT}}
| |
| === [[WBC]] Ap_WBC ===
| |
| {{:WBC}}
| |
| === [[Creatinine]] (Ap_Creat) ===
| |
| {{:Creatinine }}
| |
| === [[ARF (APACHE)]] (Ap_ARF) ===
| |
| {{:ARF (APACHE)}} | |
|
| |
|
| ==TODO==
| |
|
| |
|
| ==todo==
| | [[Category:Data structure]] |
| | |
| | |
| === 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 ==
| |
| === R_Location ===
| |
| {{: R_Location}}
| |
| === R_AdmitFrom ===
| |
| {{: R_AdmitFrom}}
| |
| === R_DischargedTo ===
| |
| {{: R_DischargedTo}}
| |
| === R_HospitalPrevious ===
| |
| {{: R_HospitalPrevious}}
| |
| === 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}}
| |