|
|
| (22 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 generates a list of data fields in the critical care and medicine database using the [[:Template:Data element]] and [[Semantic Mediawiki]]. | |
|
| |
|
| Work in progress, all articles need to be updated for this to work. See [[#field list]]
| | == data fields == |
| | We collect a total of '''{{#ask: [[Category:Data structure]] [[FieldName::>""]] |
| | | limit=1000 |
| | | format=count |
| | }}''' fields, but since much of our data is relational this doesn't really give an indication of how many things we collect. |
|
| |
|
| == data fields ==
| | === Currently collected === |
| === by link === | | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate::1 January 2100]] |
| <!-- As generated by [[Semantic Mediawiki]] -->
| | | ?InTable = Table |
| {{#ask: [[Category:Data structure]] [[FieldName::>""]] | | | ?FieldCCMDBTab= Tab |
| | limit=0 | | | ?FieldDataType= Data type |
| | searchlabel=Data fields | | | ?FieldLength= length |
| | ?InTable
| | | ?DataElementDescription=Description |
| | ?FieldDataType | | | ?DataElementStartDate=Start date |
| | ?FieldLength | | | ?FieldCreatedRaw=Created vs raw |
| | ?ElementDescription | | | limit=1000 |
| | ?DataElementStartDate | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| | ?DataElementEndDate
| | | format=table |
| | ?FieldCreatedRaw | |
| | format=broadtable
| |
| |link=all | |
| |headers=show
| |
| |intro=This is a list of fields in the Critical Care and Medicine Database | |
| |class=sortable wikitable smwtable | |
| }} | | }} |
| === by list === | | |
| <!-- As generated by [[Semantic Mediawiki]] -->
| | === Legacy data === |
| {{#ask: [[Category:Data structure]] [[FieldName::>""]] | | {{Collapsable |
| | searchlabel=Data fields | | | always= Click to see legacy data only |
| | ?InTable | | | full= |
| | ?FieldDataType | | {{#ask: [[Category:Data structure]] [[FieldName::>""]] [[DataElementEndDate:!1 January 2100]] |
| | ?FieldLength | | | ?InTable = Table |
| | ?ElementDescription | | | ?FieldCCMDBTab= Tab |
| | ?DataElementStartDate | | | ?FieldDataType= Data type |
| | ?DataElementEndDate | | | ?FieldLength= length |
| | ?FieldCreatedRaw | | | ?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 | | | intro=This is a list of fields in the Critical Care and Medicine Database |
| | format=table | | | 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 |
| | }} |
| | }} |
|
| |
|
| == field list == | | == Background / Implementation of this page == |
| == L_Log ==
| | This page aggregates data from other pages that use the [[:Template:Data element]] using [[Semantic Mediawiki]]. |
| === [[Pat_ID]]]] ===
| | If a field is not listed, check that a corresponding article exists and [[:Template:Data element]] is used correctly. |
| Pat_ID
| |
| === [[Last Name]] (LastName) ===
| |
| Last Name
| |
| === [[First Name]](FirstName) ===
| |
| First Name
| |
| === [[PHIN]] ===
| |
| PHIN
| |
| === [[Date of Birth]](Birth) ===
| |
| Date of Birth
| |
| === [[Chart]] ===
| |
| Chart
| |
| === [[Start time]](start_Time) ===
| |
| Start time
| |
| === [[Start date]](start_Date) ===
| |
| Start date
| |
| === [[Notes field]](Notes) ===
| |
| Notes field
| |
| === [[DC Treatment]] (R_dc_treat) ===
| |
| DC Treatment
| |
| === [[Province Field]] (R_Province) ===
| |
| Province Field
| |
| === [[Sex field]] (R_Sex) ===
| |
| Sex field
| |
| === [[Registry Patient Type]] (R_Type) ===
| |
| Registry Patient Type
| |
| === [[Last Opened field]] (LastOpened_DtTm) ===
| |
| Last Opened field
| |
| === [[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:
| |
| *ADL_Bathing
| |
| *ADL_Dressing
| |
| *ADL_Toileting
| |
| *ADL_Transfering
| |
| *ADL_Continence
| |
| *ADL_Feeding
| |
| | |
| == [[:Category:APACHE II|Apache fields]] ==
| |
|
| |
|
| === [[Admit Type for APACHE II]] (Ap_AdmitType) === | | == Related articles == |
| Admit Type for APACHE II
| | {{Related Articles}} |
| === [[Chronic Health APACHE]] (Ap_Chronic) ===
| |
| 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:
| |
| * Ap_Eye
| |
| * 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)
| |
| == Administrative fields ==
| |
| === [[Final Check]] ===
| |
| Final Check
| |
| === [[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 ==
| | [[Category:Data structure]] |
| === [[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
| |
| === [[Postal Code field]] ===
| |
| Postal Code field
| |