Search "COMMENT" (141 hits in 1 file)
D:\cygwin64\home\asus\data\sum_table.txt (141 hits)
Line 8: COMMENT ON COLUMN "MIMIC2V26"."additives"."SUBJECT_ID" is 'Unique patient identifier.';
Line 9: COMMENT ON COLUMN "MIMIC2V26"."additives"."ICUSTAY_ID" is 'Unique ICU stay identifier.';
Line 10: COMMENT ON COLUMN "MIMIC2V26"."additives"."ITEMID" is 'The medication item which this additive relates to.';
Line 11: COMMENT ON COLUMN "MIMIC2V26"."additives"."IOITEMID" is 'The IO item which this additive relates to.';
Line 12: COMMENT ON COLUMN "MIMIC2V26"."additives"."CHARTTIME" is 'The date/time for the additive.';
Line 13: COMMENT ON COLUMN "MIMIC2V26"."additives"."ELEMID" is 'The element of a combined additive.';
Line 14: COMMENT ON COLUMN "MIMIC2V26"."additives"."CGID" is 'The caregiver ID.';
Line 15: COMMENT ON COLUMN "MIMIC2V26"."additives"."CUID" is 'The careunit ID.';
Line 16: COMMENT ON COLUMN "MIMIC2V26"."additives"."AMOUNT" is 'The amount of additive given.';
Line 17: COMMENT ON COLUMN "MIMIC2V26"."additives"."DOSEUNITS" is 'The units of the additive given.';
Line 18: COMMENT ON COLUMN "MIMIC2V26"."additives"."ROUTE" is 'The route through which the additive is given.'
Line 21: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."CGID" is 'Table record unique identifier, the care giver id.';
Line 22: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."LABEL" is 'Title for care giver, like Nurse, MD.'
Line 25: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.';
Line 26: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.'
Line 29: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.';
Line 30: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.';
Line 31: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.'
Line 34: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.';
Line 35: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.'
Line 38: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.';
Line 39: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.';
Line 40: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.';
Line 41: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.';
Line 42: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.'
Line 51: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."ICUSTAY_ID" is 'Uniquely identifies an ICU Stay.';
Line 52: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."SUBJECT_ID" is 'The patient the ICU Stay refers to.';
Line 53: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."INTIME" is 'The beginning of the ICU Stay.';
Line 54: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."OUTTIME" is 'The end of the ICU Stay.';
Line 55: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LOS" is 'Length of Stay in minutes.';
Line 56: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."FIRST_CAREUNIT" is 'The first careunit the patient was admitted in.';
Line 57: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LAST_CAREUNIT" is 'The last careunit the patient was admitted in.'
Line 64: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SUBJECT_ID" is 'Unique subject identifier.';
Line 65: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HADM_ID" is 'Hospital admission ID.';
Line 66: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CATEGORY" is 'Category of score (e.g. Elixhauser).';
Line 67: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CONGESTIVE_HEART_FAILURE" is 'Score for congestive heart failure.';
Line 68: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CARDIAC_ARRHYTHMIAS" is 'Score for cardiac arrhythmias.';
Line 69: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."VALVULAR_DISEASE" is 'Score for valvular disease.';
Line 70: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PULMONARY_CIRCULATION" is 'Score for pulmonary circulatory disorders.';
Line 71: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PERIPHERAL_VASCULAR" is 'Score for peripheral vascular disorders.';
Line 72: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPERTENSION" is 'Score for hypertension (combined complicated and uncomplicated).';
Line 73: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PARALYSIS" is 'Score for paralysis.';
Line 74: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OTHER_NEUROLOGICAL" is 'Score for other neurological disorders.';
Line 75: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CHRONIC_PULMONARY" is 'Score for chronic pulmonary disease.';
Line 76: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_UNCOMPLICATED" is 'Score for uncomplicated diabetes.';
Line 77: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_COMPLICATED" is 'Score for complicated diabetes.';
Line 78: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPOTHYROIDISM" is 'Score for hyperthyroidism.';
Line 79: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RENAL_FAILURE" is 'Score for renal failure.';
Line 80: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LIVER_DISEASE" is 'Score for liver disease.';
Line 81: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PEPTIC_ULCER" is 'Score for peptic ulcer disease (excluding bleeding).';
Line 82: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."AIDS" is 'Score for AIDS.';
Line 83: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LYMPHOMA" is 'Score for lymphoma.';
Line 84: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."METASTATIC_CANCER" is 'Score for metastatic cancer.';
Line 85: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SOLID_TUMOR" is 'Score for solid tumor without metastasis.';
Line 86: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RHEUMATOID_ARTHRITIS" is 'Score for rheumatoid arthritis/collagen vascular diseases.';
Line 87: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."COAGULOPATHY" is 'Score for coagulopathy.';
Line 88: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OBESITY" is 'Score for obesity.';
Line 89: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."WEIGHT_LOSS" is 'Score for weight loss.';
Line 90: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."FLUID_ELECTROLYTE" is 'Score for fluid and electrolyte disorders.';
Line 91: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."BLOOD_LOSS_ANEMIA" is 'Score for blood loss anemia.';
Line 92: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEFICIENCY_ANEMIAS" is 'Score for deficiency anemias.';
Line 93: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."ALCOHOL_ABUSE" is 'Score for alcohol abuse.';
Line 94: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DRUG_ABUSE" is 'Score for drug abuse.';
Line 95: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PSYCHOSES" is 'Score for phychoses.';
Line 96: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEPRESSION" is 'Score for depression.'
Line 99: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."ITEMID" is 'Table record unique identifier, the lab item ID.';
Line 100: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."TEST_NAME" is 'The name of the lab test performed.';
Line 101: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."FLUID" is 'The fluid on which the test was performed.';
Line 102: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."CATEGORY" is 'Item category.';
Line 103: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."LOINC_CODE" is 'LOINC code for lab item.';
Line 104: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."LOINC_DESCRIPTION" is 'LOINC description for lab item.'
Line 111: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."LABEL" is 'The column that holds the label';
Line 112: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."LABEL_LOWER" is 'The column that holds the label_lower';
Line 113: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."ITEMID" is 'The column that holds the itemid';
Line 114: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CATEGORY" is 'The column that holds the category';
Line 115: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."DESCRIPTION" is 'The column that holds the description';
Line 116: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE_TYPE" is 'The column that holds the value_type';
Line 117: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE_COLUMN" is 'The column that holds the value_column';
Line 118: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."ROWS_NUM" is 'The column that holds the rows_num';
Line 119: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."SUBJECTS_NUM" is 'The column that holds the subjects_num';
Line 120: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CHART_VS_REALTIME_DELAY_MEAN" is 'The column that holds the chart_vs_realtime_delay_mean';
Line 121: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CHART_VS_REALTIME_DELAY_STDDEV" is 'The column that holds the chart_vs_realtime_delay_stddev';
Line 122: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_NUM" is 'The column that holds the value1_uom_num';
Line 123: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_HAS_NULLS" is 'The column that holds the value1_uom_has_nulls';
Line 124: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_SAMPLE1" is 'The column that holds the value1_uom_sample1';
Line 125: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_SAMPLE2" is 'The column that holds the value1_uom_sample2';
Line 126: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_DISTINCT_NUM" is 'The column that holds the value1_distinct_num';
Line 127: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_HAS_NULLS" is 'The column that holds the value1_has_nulls';
Line 128: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_SAMPLE1" is 'The column that holds the value1_sample1';
Line 129: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_SAMPLE2" is 'The column that holds the value1_sample2';
Line 130: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MIN" is 'The column that holds the value1_length_min';
Line 131: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MAX" is 'The column that holds the value1_length_max';
Line 132: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MEAN" is 'The column that holds the value1_length_mean';
Line 133: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MIN" is 'The column that holds the value1num_min';
Line 134: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MAX" is 'The column that holds the value1num_max';
Line 135: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MEAN" is 'The column that holds the value1num_mean';
Line 136: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_STDDEV" is 'The column that holds the value1num_stddev';
Line 137: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_NUM" is 'The column that holds the value2_uom_num';
Line 138: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_HAS_NULLS" is 'The column that holds the value2_uom_has_nulls';
Line 139: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_SAMPLE1" is 'The column that holds the value2_uom_sample1';
Line 140: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_SAMPLE2" is 'The column that holds the value2_uom_sample2';
Line 141: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_DISTINCT_NUM" is 'The column that holds the value2_distinct_num';
Line 142: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_HAS_NULLS" is 'The column that holds the value2_has_nulls';
Line 143: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_SAMPLE1" is 'The column that holds the value2_sample1';
Line 144: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_dCREATE COLUMN TABLE "MIMIC2V26"."d_demographicitems" ("ITEMID" INTEGER CS_INT NOT NULL , "LABEL" VARCHAR(50), "CATEGORY" VARCHAR(19), PRIMARY KEY ("ITEMID")) UNLOAD PRIORITY 5 AUTO MERGE ;
Line 145: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."ITEMID" is 'Table-unique identifier: the item ID.';
Line 146: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."LABEL" is 'The name of the item (a short description).';
Line 147: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."CATEGORY" is 'The type of the demographic of the item.'etail"."VALUE2_SAMPLE2" is 'The column that holds the value2_sample2';
Line 148: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MIN" is 'The column that holds the value2_length_min';
Line 149: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MAX" is 'The column that holds the value2_length_max';
Line 150: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MEAN" is 'The column that holds the value2_length_mean';
Line 151: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MIN" is 'The column that holds the value2num_min';
Line 152: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MAX" is 'The column that holds the value2num_max';
Line 153: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MEAN" is 'The column that holds the value2num_mean';
Line 154: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_STDDEV" is 'The column that holds the value2num_stddev'
Line 157: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.';
Line 158: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.'
Line 161: COMMENT ON COLUMN "MIMIC2V26"."d_parammap_items"."CATEGORY" is 'The unique identifier indicating the type of mapping given by a row in
Line 163: COMMENT ON COLUMN "MIMIC2V26"."d_parammap_items"."DESCRIPTION" is 'A description of the category.'
Line 166: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.';
Line 167: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.';
Line 168: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.';
Line 169: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.';
Line 170: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.'
Line 173: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.';
Line 174: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.'
Line 177: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."ITEMID" is 'Table unique identifier, the chart item id.';
Line 178: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."LABEL" is 'The name of the parameter.';
Line 179: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."CATEGORY" is 'The chart item category.';
Line 180: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."DESCRIPTION" is 'Comments or description about the parameter.'
Line 180: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."DESCRIPTION" is 'Comments or description about the parameter.'
Line 182: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.';
Line 183: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.';
Line 184: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.'
Line 187: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."ITEMID" is 'Table-unique identifier: the item ID.';
Line 188: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."CODE" is 'Code for the item; meaning and interpretation depend on the category; not necessarily unique.';
Line 189: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."TYPE" is 'The type of the item; indicates whether it appears in DRGEVENTS, MICROBIOLOGYEVENTS, or PROCEDUREEVENTS.';
Line 190: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."CATEGORY" is 'A broad grouping of the items within a type.';
Line 191: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."LABEL" is 'The name of the item (a short description).';
Line 192: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."DESCRIPTION" is 'Comments/description about the item.'
Line 192: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."DESCRIPTION" is 'Comments/description about the item.'
Search "COMMENT" (65 hits in 1 file)
D:\cygwin64\home\asus\data\sum_table.txt (65 hits)
Line 8: COMMENT ON COLUMN "MIMIC2V26"."additives"."SUBJECT_ID" is 'Unique patient identifier.';
Line 9: COMMENT ON COLUMN "MIMIC2V26"."additives"."ICUSTAY_ID" is 'Unique ICU stay identifier.';
Line 10: COMMENT ON COLUMN "MIMIC2V26"."additives"."ITEMID" is 'The medication item which this additive relates to.';
Line 11: COMMENT ON COLUMN "MIMIC2V26"."additives"."IOITEMID" is 'The IO item which this additive relates to.';
Line 12: COMMENT ON COLUMN "MIMIC2V26"."additives"."CHARTTIME" is 'The date/time for the additive.';
Line 13: COMMENT ON COLUMN "MIMIC2V26"."additives"."ELEMID" is 'The element of a combined additive.';
Line 14: COMMENT ON COLUMN "MIMIC2V26"."additives"."CGID" is 'The caregiver ID.';
Line 15: COMMENT ON COLUMN "MIMIC2V26"."additives"."CUID" is 'The careunit ID.';
Line 16: COMMENT ON COLUMN "MIMIC2V26"."additives"."AMOUNT" is 'The amount of additive given.';
Line 17: COMMENT ON COLUMN "MIMIC2V26"."additives"."DOSEUNITS" is 'The units of the additive given.';
Line 18: COMMENT ON COLUMN "MIMIC2V26"."additives"."ROUTE" is 'The route through which the additive is given.'
Line 21: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."CGID" is 'Table record unique identifier, the care giver id.';
Line 22: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."LABEL" is 'Title for care giver, like Nurse, MD.'
Line 25: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.';
Line 26: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.'
Line 29: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.';
Line 30: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.';
Line 31: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.'
Line 34: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.';
Line 35: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.'
Line 38: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.';
Line 39: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.';
Line 40: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.';
Line 41: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.';
Line 42: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.'
Line 51: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."ICUSTAY_ID" is 'Uniquely identifies an ICU Stay.';
Line 52: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."SUBJECT_ID" is 'The patient the ICU Stay refers to.';
Line 53: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."INTIME" is 'The beginning of the ICU Stay.';
Line 54: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."OUTTIME" is 'The end of the ICU Stay.';
Line 55: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LOS" is 'Length of Stay in minutes.';
Line 56: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."FIRST_CAREUNIT" is 'The first careunit the patient was admitted in.';
Line 57: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LAST_CAREUNIT" is 'The last careunit the patient was admitted in.'
Line 64: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SUBJECT_ID" is 'Unique subject identifier.';
Line 65: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HADM_ID" is 'Hospital admission ID.';
Line 66: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CATEGORY" is 'Category of score (e.g. Elixhauser).';
Line 67: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CONGESTIVE_HEART_FAILURE" is 'Score for congestive heart failure.';
Line 68: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CARDIAC_ARRHYTHMIAS" is 'Score for cardiac arrhythmias.';
Line 69: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."VALVULAR_DISEASE" is 'Score for valvular disease.';
Line 70: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PULMONARY_CIRCULATION" is 'Score for pulmonary circulatory disorders.';
Line 71: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PERIPHERAL_VASCULAR" is 'Score for peripheral vascular disorders.';
Line 72: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPERTENSION" is 'Score for hypertension (combined complicated and uncomplicated).';
Line 73: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PARALYSIS" is 'Score for paralysis.';
Line 74: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OTHER_NEUROLOGICAL" is 'Score for other neurological disorders.';
Line 75: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CHRONIC_PULMONARY" is 'Score for chronic pulmonary disease.';
Line 76: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_UNCOMPLICATED" is 'Score for uncomplicated diabetes.';
Line 77: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_COMPLICATED" is 'Score for complicated diabetes.';
Line 78: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPOTHYROIDISM" is 'Score for hyperthyroidism.';
Line 79: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RENAL_FAILURE" is 'Score for renal failure.';
Line 80: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LIVER_DISEASE" is 'Score for liver disease.';
Line 81: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PEPTIC_ULCER" is 'Score for peptic ulcer disease (excluding bleeding).';
Line 82: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."AIDS" is 'Score for AIDS.';
Line 83: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LYMPHOMA" is 'Score for lymphoma.';
Line 84: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."METASTATIC_CANCER" is 'Score for metastatic cancer.';
Line 85: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SOLID_TUMOR" is 'Score for solid tumor without metastasis.';
Line 86: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RHEUMATOID_ARTHRITIS" is 'Score for rheumatoid arthritis/collagen vascular diseases.';
Line 87: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."COAGULOPATHY" is 'Score for coagulopathy.';
Line 88: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OBESITY" is 'Score for obesity.';
Line 89: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."WEIGHT_LOSS" is 'Score for weight loss.';
Line 90: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."FLUID_ELECTROLYTE" is 'Score for fluid and electrolyte disorders.';
Line 91: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."BLOOD_LOSS_ANEMIA" is 'Score for blood loss anemia.';
Line 92: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEFICIENCY_ANEMIAS" is 'Score for deficiency anemias.';
Line 93: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."ALCOHOL_ABUSE" is 'Score for alcohol abuse.';
Line 94: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DRUG_ABUSE" is 'Score for drug abuse.';
Line 95: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PSYCHOSES" is 'Score for phychoses.';
Line 96: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEPRESSION" is 'Score for depression.'
Search "COMMENT" (141 hits in 1 file) D:\cygwin64\home\asus\data\sum_table.txt (141 hits) Line 8: COMMENT ON COLUMN "MIMIC2V26"."additives"."SUBJECT_ID" is 'Unique patient identifier.'; Line 9: COMMENT ON COLUMN "MIMIC2V26"."additives"."ICUSTAY_ID" is 'Unique ICU stay identifier.'; Line 10: COMMENT ON COLUMN "MIMIC2V26"."additives"."ITEMID" is 'The medication item which this additive relates to.'; Line 11: COMMENT ON COLUMN "MIMIC2V26"."additives"."IOITEMID" is 'The IO item which this additive relates to.'; Line 12: COMMENT ON COLUMN "MIMIC2V26"."additives"."CHARTTIME" is 'The date/time for the additive.'; Line 13: COMMENT ON COLUMN "MIMIC2V26"."additives"."ELEMID" is 'The element of a combined additive.'; Line 14: COMMENT ON COLUMN "MIMIC2V26"."additives"."CGID" is 'The caregiver ID.'; Line 15: COMMENT ON COLUMN "MIMIC2V26"."additives"."CUID" is 'The careunit ID.'; Line 16: COMMENT ON COLUMN "MIMIC2V26"."additives"."AMOUNT" is 'The amount of additive given.'; Line 17: COMMENT ON COLUMN "MIMIC2V26"."additives"."DOSEUNITS" is 'The units of the additive given.'; Line 18: COMMENT ON COLUMN "MIMIC2V26"."additives"."ROUTE" is 'The route through which the additive is given.' Line 21: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."CGID" is 'Table record unique identifier, the care giver id.'; Line 22: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."LABEL" is 'Title for care giver, like Nurse, MD.' Line 25: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.'; Line 26: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.' Line 29: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.'; Line 30: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.'; Line 31: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.' Line 34: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.'; Line 35: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.' Line 38: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.'; Line 39: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.'; Line 40: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.'; Line 41: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.'; Line 42: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.' Line 51: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."ICUSTAY_ID" is 'Uniquely identifies an ICU Stay.'; Line 52: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."SUBJECT_ID" is 'The patient the ICU Stay refers to.'; Line 53: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."INTIME" is 'The beginning of the ICU Stay.'; Line 54: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."OUTTIME" is 'The end of the ICU Stay.'; Line 55: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LOS" is 'Length of Stay in minutes.'; Line 56: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."FIRST_CAREUNIT" is 'The first careunit the patient was admitted in.'; Line 57: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LAST_CAREUNIT" is 'The last careunit the patient was admitted in.' Line 64: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SUBJECT_ID" is 'Unique subject identifier.'; Line 65: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HADM_ID" is 'Hospital admission ID.'; Line 66: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CATEGORY" is 'Category of score (e.g. Elixhauser).'; Line 67: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CONGESTIVE_HEART_FAILURE" is 'Score for congestive heart failure.'; Line 68: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CARDIAC_ARRHYTHMIAS" is 'Score for cardiac arrhythmias.'; Line 69: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."VALVULAR_DISEASE" is 'Score for valvular disease.'; Line 70: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PULMONARY_CIRCULATION" is 'Score for pulmonary circulatory disorders.'; Line 71: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PERIPHERAL_VASCULAR" is 'Score for peripheral vascular disorders.'; Line 72: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPERTENSION" is 'Score for hypertension (combined complicated and uncomplicated).'; Line 73: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PARALYSIS" is 'Score for paralysis.'; Line 74: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OTHER_NEUROLOGICAL" is 'Score for other neurological disorders.'; Line 75: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CHRONIC_PULMONARY" is 'Score for chronic pulmonary disease.'; Line 76: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_UNCOMPLICATED" is 'Score for uncomplicated diabetes.'; Line 77: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_COMPLICATED" is 'Score for complicated diabetes.'; Line 78: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPOTHYROIDISM" is 'Score for hyperthyroidism.'; Line 79: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RENAL_FAILURE" is 'Score for renal failure.'; Line 80: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LIVER_DISEASE" is 'Score for liver disease.'; Line 81: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PEPTIC_ULCER" is 'Score for peptic ulcer disease (excluding bleeding).'; Line 82: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."AIDS" is 'Score for AIDS.'; Line 83: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LYMPHOMA" is 'Score for lymphoma.'; Line 84: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."METASTATIC_CANCER" is 'Score for metastatic cancer.'; Line 85: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SOLID_TUMOR" is 'Score for solid tumor without metastasis.'; Line 86: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RHEUMATOID_ARTHRITIS" is 'Score for rheumatoid arthritis/collagen vascular diseases.'; Line 87: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."COAGULOPATHY" is 'Score for coagulopathy.'; Line 88: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OBESITY" is 'Score for obesity.'; Line 89: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."WEIGHT_LOSS" is 'Score for weight loss.'; Line 90: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."FLUID_ELECTROLYTE" is 'Score for fluid and electrolyte disorders.'; Line 91: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."BLOOD_LOSS_ANEMIA" is 'Score for blood loss anemia.'; Line 92: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEFICIENCY_ANEMIAS" is 'Score for deficiency anemias.'; Line 93: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."ALCOHOL_ABUSE" is 'Score for alcohol abuse.'; Line 94: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DRUG_ABUSE" is 'Score for drug abuse.'; Line 95: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PSYCHOSES" is 'Score for phychoses.'; Line 96: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEPRESSION" is 'Score for depression.' Line 99: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."ITEMID" is 'Table record unique identifier, the lab item ID.'; Line 100: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."TEST_NAME" is 'The name of the lab test performed.'; Line 101: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."FLUID" is 'The fluid on which the test was performed.'; Line 102: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."CATEGORY" is 'Item category.'; Line 103: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."LOINC_CODE" is 'LOINC code for lab item.'; Line 104: COMMENT ON COLUMN "MIMIC2V26"."d_labitems"."LOINC_DESCRIPTION" is 'LOINC description for lab item.' Line 111: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."LABEL" is 'The column that holds the label'; Line 112: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."LABEL_LOWER" is 'The column that holds the label_lower'; Line 113: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."ITEMID" is 'The column that holds the itemid'; Line 114: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CATEGORY" is 'The column that holds the category'; Line 115: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."DESCRIPTION" is 'The column that holds the description'; Line 116: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE_TYPE" is 'The column that holds the value_type'; Line 117: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE_COLUMN" is 'The column that holds the value_column'; Line 118: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."ROWS_NUM" is 'The column that holds the rows_num'; Line 119: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."SUBJECTS_NUM" is 'The column that holds the subjects_num'; Line 120: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CHART_VS_REALTIME_DELAY_MEAN" is 'The column that holds the chart_vs_realtime_delay_mean'; Line 121: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."CHART_VS_REALTIME_DELAY_STDDEV" is 'The column that holds the chart_vs_realtime_delay_stddev'; Line 122: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_NUM" is 'The column that holds the value1_uom_num'; Line 123: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_HAS_NULLS" is 'The column that holds the value1_uom_has_nulls'; Line 124: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_SAMPLE1" is 'The column that holds the value1_uom_sample1'; Line 125: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_UOM_SAMPLE2" is 'The column that holds the value1_uom_sample2'; Line 126: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_DISTINCT_NUM" is 'The column that holds the value1_distinct_num'; Line 127: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_HAS_NULLS" is 'The column that holds the value1_has_nulls'; Line 128: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_SAMPLE1" is 'The column that holds the value1_sample1'; Line 129: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_SAMPLE2" is 'The column that holds the value1_sample2'; Line 130: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MIN" is 'The column that holds the value1_length_min'; Line 131: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MAX" is 'The column that holds the value1_length_max'; Line 132: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1_LENGTH_MEAN" is 'The column that holds the value1_length_mean'; Line 133: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MIN" is 'The column that holds the value1num_min'; Line 134: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MAX" is 'The column that holds the value1num_max'; Line 135: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_MEAN" is 'The column that holds the value1num_mean'; Line 136: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE1NUM_STDDEV" is 'The column that holds the value1num_stddev'; Line 137: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_NUM" is 'The column that holds the value2_uom_num'; Line 138: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_HAS_NULLS" is 'The column that holds the value2_uom_has_nulls'; Line 139: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_SAMPLE1" is 'The column that holds the value2_uom_sample1'; Line 140: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_UOM_SAMPLE2" is 'The column that holds the value2_uom_sample2'; Line 141: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_DISTINCT_NUM" is 'The column that holds the value2_distinct_num'; Line 142: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_HAS_NULLS" is 'The column that holds the value2_has_nulls'; Line 143: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_SAMPLE1" is 'The column that holds the value2_sample1'; Line 144: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_dCREATE COLUMN TABLE "MIMIC2V26"."d_demographicitems" ("ITEMID" INTEGER CS_INT NOT NULL , "LABEL" VARCHAR(50), "CATEGORY" VARCHAR(19), PRIMARY KEY ("ITEMID")) UNLOAD PRIORITY 5 AUTO MERGE ; Line 145: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."ITEMID" is 'Table-unique identifier: the item ID.'; Line 146: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."LABEL" is 'The name of the item (a short description).'; Line 147: COMMENT ON COLUMN "MIMIC2V26"."d_demographicitems"."CATEGORY" is 'The type of the demographic of the item.'etail"."VALUE2_SAMPLE2" is 'The column that holds the value2_sample2'; Line 148: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MIN" is 'The column that holds the value2_length_min'; Line 149: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MAX" is 'The column that holds the value2_length_max'; Line 150: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2_LENGTH_MEAN" is 'The column that holds the value2_length_mean'; Line 151: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MIN" is 'The column that holds the value2num_min'; Line 152: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MAX" is 'The column that holds the value2num_max'; Line 153: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_MEAN" is 'The column that holds the value2num_mean'; Line 154: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems_detail"."VALUE2NUM_STDDEV" is 'The column that holds the value2num_stddev' Line 157: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.'; Line 158: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.' Line 161: COMMENT ON COLUMN "MIMIC2V26"."d_parammap_items"."CATEGORY" is 'The unique identifier indicating the type of mapping given by a row in Line 163: COMMENT ON COLUMN "MIMIC2V26"."d_parammap_items"."DESCRIPTION" is 'A description of the category.' Line 166: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.'; Line 167: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.'; Line 168: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.'; Line 169: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.'; Line 170: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.' Line 173: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.'; Line 174: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.' Line 177: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."ITEMID" is 'Table unique identifier, the chart item id.'; Line 178: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."LABEL" is 'The name of the parameter.'; Line 179: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."CATEGORY" is 'The chart item category.'; Line 180: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."DESCRIPTION" is 'Comments or description about the parameter.' Line 180: COMMENT ON COLUMN "MIMIC2V26"."d_chartitems"."DESCRIPTION" is 'Comments or description about the parameter.' Line 182: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.'; Line 183: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.'; Line 184: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.' Line 187: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."ITEMID" is 'Table-unique identifier: the item ID.'; Line 188: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."CODE" is 'Code for the item; meaning and interpretation depend on the category; not necessarily unique.'; Line 189: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."TYPE" is 'The type of the item; indicates whether it appears in DRGEVENTS, MICROBIOLOGYEVENTS, or PROCEDUREEVENTS.'; Line 190: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."CATEGORY" is 'A broad grouping of the items within a type.'; Line 191: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."LABEL" is 'The name of the item (a short description).'; Line 192: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."DESCRIPTION" is 'Comments/description about the item.' Line 192: COMMENT ON COLUMN "MIMIC2V26"."d_codeditems"."DESCRIPTION" is 'Comments/description about the item.' Search "COMMENT" (65 hits in 1 file) D:\cygwin64\home\asus\data\sum_table.txt (65 hits) Line 8: COMMENT ON COLUMN "MIMIC2V26"."additives"."SUBJECT_ID" is 'Unique patient identifier.'; Line 9: COMMENT ON COLUMN "MIMIC2V26"."additives"."ICUSTAY_ID" is 'Unique ICU stay identifier.'; Line 10: COMMENT ON COLUMN "MIMIC2V26"."additives"."ITEMID" is 'The medication item which this additive relates to.'; Line 11: COMMENT ON COLUMN "MIMIC2V26"."additives"."IOITEMID" is 'The IO item which this additive relates to.'; Line 12: COMMENT ON COLUMN "MIMIC2V26"."additives"."CHARTTIME" is 'The date/time for the additive.'; Line 13: COMMENT ON COLUMN "MIMIC2V26"."additives"."ELEMID" is 'The element of a combined additive.'; Line 14: COMMENT ON COLUMN "MIMIC2V26"."additives"."CGID" is 'The caregiver ID.'; Line 15: COMMENT ON COLUMN "MIMIC2V26"."additives"."CUID" is 'The careunit ID.'; Line 16: COMMENT ON COLUMN "MIMIC2V26"."additives"."AMOUNT" is 'The amount of additive given.'; Line 17: COMMENT ON COLUMN "MIMIC2V26"."additives"."DOSEUNITS" is 'The units of the additive given.'; Line 18: COMMENT ON COLUMN "MIMIC2V26"."additives"."ROUTE" is 'The route through which the additive is given.' Line 21: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."CGID" is 'Table record unique identifier, the care giver id.'; Line 22: COMMENT ON COLUMN "MIMIC2V26"."d_caregivers"."LABEL" is 'Title for care giver, like Nurse, MD.' Line 25: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."CUID" is 'Table record unique identifier, the care unit id.'; Line 26: COMMENT ON COLUMN "MIMIC2V26"."d_careunits"."LABEL" is 'Name of the unit, like MICU, CCU.' Line 29: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."ITEMID" is 'Table record unique identifier, the IO item ID.'; Line 30: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."LABEL" is 'Name of the IO item.'; Line 31: COMMENT ON COLUMN "MIMIC2V26"."d_ioitems"."CATEGORY" is 'The IO item category.' Line 34: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."ITEMID" is 'Table record unique identifier, the medication item id.'; Line 35: COMMENT ON COLUMN "MIMIC2V26"."d_meditems"."LABEL" is 'Name of the medication item.' Line 38: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SUBJECT_ID" is 'Table record unique identifier, the subject id.'; Line 39: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."SEX" is 'The patient gender.'; Line 40: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOB" is 'Date of birth for the patient.'; Line 41: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."DOD" is 'Date of death for the patient. Null if still alive as of March 2009.'; Line 42: COMMENT ON COLUMN "MIMIC2V26"."d_patients"."HOSPITAL_EXPIRE_FLG" is 'Whether or not the patient died in the hospital.' Line 51: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."ICUSTAY_ID" is 'Uniquely identifies an ICU Stay.'; Line 52: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."SUBJECT_ID" is 'The patient the ICU Stay refers to.'; Line 53: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."INTIME" is 'The beginning of the ICU Stay.'; Line 54: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."OUTTIME" is 'The end of the ICU Stay.'; Line 55: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LOS" is 'Length of Stay in minutes.'; Line 56: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."FIRST_CAREUNIT" is 'The first careunit the patient was admitted in.'; Line 57: COMMENT ON COLUMN "MIMIC2V26"."icustayevents"."LAST_CAREUNIT" is 'The last careunit the patient was admitted in.' Line 64: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SUBJECT_ID" is 'Unique subject identifier.'; Line 65: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HADM_ID" is 'Hospital admission ID.'; Line 66: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CATEGORY" is 'Category of score (e.g. Elixhauser).'; Line 67: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CONGESTIVE_HEART_FAILURE" is 'Score for congestive heart failure.'; Line 68: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CARDIAC_ARRHYTHMIAS" is 'Score for cardiac arrhythmias.'; Line 69: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."VALVULAR_DISEASE" is 'Score for valvular disease.'; Line 70: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PULMONARY_CIRCULATION" is 'Score for pulmonary circulatory disorders.'; Line 71: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PERIPHERAL_VASCULAR" is 'Score for peripheral vascular disorders.'; Line 72: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPERTENSION" is 'Score for hypertension (combined complicated and uncomplicated).'; Line 73: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PARALYSIS" is 'Score for paralysis.'; Line 74: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OTHER_NEUROLOGICAL" is 'Score for other neurological disorders.'; Line 75: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."CHRONIC_PULMONARY" is 'Score for chronic pulmonary disease.'; Line 76: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_UNCOMPLICATED" is 'Score for uncomplicated diabetes.'; Line 77: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DIABETES_COMPLICATED" is 'Score for complicated diabetes.'; Line 78: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."HYPOTHYROIDISM" is 'Score for hyperthyroidism.'; Line 79: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RENAL_FAILURE" is 'Score for renal failure.'; Line 80: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LIVER_DISEASE" is 'Score for liver disease.'; Line 81: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PEPTIC_ULCER" is 'Score for peptic ulcer disease (excluding bleeding).'; Line 82: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."AIDS" is 'Score for AIDS.'; Line 83: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."LYMPHOMA" is 'Score for lymphoma.'; Line 84: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."METASTATIC_CANCER" is 'Score for metastatic cancer.'; Line 85: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."SOLID_TUMOR" is 'Score for solid tumor without metastasis.'; Line 86: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."RHEUMATOID_ARTHRITIS" is 'Score for rheumatoid arthritis/collagen vascular diseases.'; Line 87: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."COAGULOPATHY" is 'Score for coagulopathy.'; Line 88: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."OBESITY" is 'Score for obesity.'; Line 89: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."WEIGHT_LOSS" is 'Score for weight loss.'; Line 90: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."FLUID_ELECTROLYTE" is 'Score for fluid and electrolyte disorders.'; Line 91: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."BLOOD_LOSS_ANEMIA" is 'Score for blood loss anemia.'; Line 92: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEFICIENCY_ANEMIAS" is 'Score for deficiency anemias.'; Line 93: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."ALCOHOL_ABUSE" is 'Score for alcohol abuse.'; Line 94: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DRUG_ABUSE" is 'Score for drug abuse.'; Line 95: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."PSYCHOSES" is 'Score for phychoses.'; Line 96: COMMENT ON COLUMN "MIMIC2V26"."comorbidity_scores"."DEPRESSION" is 'Score for depression.'