Auto Data Dictionary: Difference between revisions

From CCMDB Wiki
Jump to navigation Jump to search
← Older editNewer edit →
m m
m m
Line 22: Line 22:
=== Notes ===  
=== Notes ===  
{{:Notes field}}
{{:Notes field}}
==todo==
 
== To do ==
=== R_dc_treat ===
{{: R_dc_treat}}
=== R_Province ===
{{: R_Province}}
=== R_Sex ===
{{: R_Sex}}
=== R_Type ===
{{: R_Type}}
=== FinalCheck ===  
=== FinalCheck ===  
{{: FinalCheck}}
{{: FinalCheck}}
=== LastOpened_DtTm ===
{{: LastOpened_DtTm}}
=== Pre_Acute_Living_Situation ===
{{: Pre_Acute_Living_Situation}}
=== Pre_admit_Inpatient_Institution ===
{{: Pre_admit_Inpatient_Institution}}
=== Previous_Location ===
{{: Previous_Location}}
=== Previous_Service ===
{{: Previous_Service}}
=== off_ward ===
{{: off_ward}}
=== Service_Location ===
{{: Service_Location}}
=== Dispo === {{: Dispo}}
=== Visit_Admit_DtTm ===
{{: 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 ==
=== R_Location ===  
=== R_Location ===  
{{: R_Location}}
{{: R_Location}}
=== R_dc_treat ===
{{: R_dc_treat}}
=== R_AdmitFrom ===  
=== R_AdmitFrom ===  
{{: R_AdmitFrom}}
{{: R_AdmitFrom}}
Line 35: Line 196:
=== R_HospitalPrevious ===  
=== R_HospitalPrevious ===  
{{: R_HospitalPrevious}}
{{: R_HospitalPrevious}}
=== R_Province ===
{{: R_Province}}
=== R_Sex ===
{{: R_Sex}}
=== R_Type ===
{{: R_Type}}
=== R_SurviveExpire ===  
=== R_SurviveExpire ===  
{{: R_SurviveExpire}}
{{: R_SurviveExpire}}
Line 69: Line 224:
=== Var6 ===  
=== Var6 ===  
{{: Var6}}
{{: Var6}}
=== PostalCode === {{: PostalCode}}
=== PostalCode ===  
=== LastOpened_DtTm === {{: LastOpened_DtTm}}
{{: PostalCode}}
=== Pre_Acute_Living_Situation === {{: Pre_Acute_Living_Situation}}
=== Pre_admit_Inpatient_Institution === {{: Pre_admit_Inpatient_Institution}}
=== Previous_Location === {{: Previous_Location}}
=== Previous_Service === {{: Previous_Service}}
=== off_ward === {{: off_ward}}
=== Service_Location === {{: Service_Location}}
=== Dispo === {{: Dispo}}
=== Visit_Admit_DtTm === {{: 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_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}}

Revision as of 16:01, 15 August 2016

what is this?

This article transcludes the articles for our data fields, or ideally their <onlyinclude> sections.

Work in progress, all articles need to be updated for this to work.

L_Log

Pat_ID

Data Element (edit)
Field Name: Pat_ID
CCMDB Label: Serial
CCMDB tab: Top Row
Table: L_CCI_Picklist table, L_CCI_Component table, L Como table, L Dxs table, L ICD10 table, L_Labs_Flowsheet table, L Log table, L PCH table, L_PHI table, L_Pharm_Flowsheet table, L TISS Form table, L TISS Item table, L TmpV2 table
Data type: number
Length: Long Integer
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 1

The Pat_ID field contains a unique-per-laptop identifying number for patient ward admissions. See Serial number.

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


Pat_ID is used in CCMDB.accdb. In CFE / Centralized_data.mdb, D_ID is the equivalent. D_ID is the combination of the Service/Location and the Pat_ID.

Tables

Related Articles

Related articles:

LastName

Data Element (edit)
Field Name: LastName
CCMDB Label: Last Name
CCMDB tab: Top Row
Table: L_Log table, L_PHI table
Data type: string
Length: 40
Program: Med and CC
Created/Raw: Raw
Start Date: 1988-07-11
End Date: 2300-01-01
Sort Index: 2

Last Name of patient

  • SMW

Legacy implementation right in the table

  • Cargo


  • Categories
  • Forms


See also FirstName field.

Enter the patient name as in EPR.

Data Processing at main office

Name changes over time

If an inconsistency is found between old and current records,

  • edit only if there is something incorrect, e.g. a typo
  • use the value in the EPR for the correction
  • we change the old entries to be consistent with the most current entry

Information about other names for the patient may be available in Alias ID collection.

See also: Crosschecking data with Manitoba Health

Minimal Data Set

This entry is part of the Minimal Data Set. Special collection instructions apply, see that page for more info.

L_PHI vs L_Log

This field is stored in the L_PHI table in CFE but in the L_Log table in CCMDB.accdb. See L_PHI table for details why.

Data Integrity Checks (automatic list)

none found

Legacy info

Legacy Content

This page contains Legacy Content.

  • Explanation: we used to change names around for consistency but stopped doing this.
  • Successor: use rules above

Click Expand to show legacy content.

Retrieved from "https://ccmdb.kuality.ca/index.php?title=Auto_Data_Dictionary&oldid=49538"