|
|
| (38 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}}
| |
| ==todo==
| |
|
| |
|
| | === 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 |
| | }} |
| | }} |
|
| |
|
| | === 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 |
| | }} |
| | }} |
|
| |
|
| === ADL_Bathing === | | == Background / Implementation of this page == |
| {{: ADL_Bathing}}
| | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| === ADL_Dressing ===
| | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| {{: 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 == | | == Related articles == |
| === R_Location ===
| | {{Related Articles}} |
| {{: R_Location}} | | |
| === R_AdmitFrom ===
| | |
| {{: R_AdmitFrom}}
| | [[Category:Data structure]] |
| === 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}}
| |