If a diagnoses for a specified HCC has never been coded for a person, the column will be NULL.
Use this table for efficient searches to determine all persons that have a coded diagnoses for a given HCC.
| Name |
Type
|
Description |
| personid |
VARCHAR (GUID) |
Unique identifier representing a unique person that may include data from several sources that have been linked. This identifier is the person_id of a HIEBus recordgroup.
|
| hcc1 |
TIMESTAMP |
Date of the most recent diagnosis associated with HIV/AIDS
|
| hcc2 |
TIMESTAMP |
Date of the most recent diagnosis associated with Septicemia, Sepsis, Systemic Inflammatory Response Syndrome/Shock
|
| hcc6 |
TIMESTAMP |
Date of the most recent diagnosis associated with Opportunistic Infections
|
| hcc8 |
TIMESTAMP |
Date of the most recent diagnosis associated with Metastatic Cancer and Acute Leukemia
|
| hcc9 |
TIMESTAMP |
Date of the most recent diagnosis associated with Lung and Other Severe Cancers
|
| hcc10 |
TIMESTAMP |
Date of the most recent diagnosis associated with Lymphoma and Other Cancers
|
| hcc11 |
TIMESTAMP |
Date of the most recent diagnosis associated with Colorectal, Bladder, and Other Cancers
|
| hcc12 |
TIMESTAMP |
Date of the most recent diagnosis associated with Breast, Prostate, and Other Cancers and Tumors
|
| hcc17 |
TIMESTAMP |
Date of the most recent diagnosis associated with Diabetes with Acute Complications
|
| hcc18 |
TIMESTAMP |
Date of the most recent diagnosis associated with Diabetes with Chronic Complications
|
| hcc19 |
TIMESTAMP |
Date of the most recent diagnosis associated with Diabetes without Complication
|
| hcc21 |
TIMESTAMP |
Date of the most recent diagnosis associated with Protein-Calorie Malnutrition
|
| hcc22 |
TIMESTAMP |
Date of the most recent diagnosis associated with Morbid Obesity
|
| hcc23 |
TIMESTAMP |
Date of the most recent diagnosis associated with Other Significant Endocrine and Metabolic Disorders
|
| hcc27 |
TIMESTAMP |
Date of the most recent diagnosis associated with End-Stage Liver Disease
|
| hcc28 |
TIMESTAMP |
Date of the most recent diagnosis associated with Cirrhosis of Liver
|
| hcc29 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Hepatitis
|
| hcc33 |
TIMESTAMP |
Date of the most recent diagnosis associated with Intestinal Obstruction/Perforation
|
| hcc34 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Pancreatitis
|
| hcc35 |
TIMESTAMP |
Date of the most recent diagnosis associated with Inflammatory Bowel Disease
|
| hcc39 |
TIMESTAMP |
Date of the most recent diagnosis associated with Bone/Joint/Muscle Infections/Necrosis
|
| hcc40 |
TIMESTAMP |
Date of the most recent diagnosis associated with Rheumatoid Arthritis and Inflammatory Connective Tissue Disease
|
| hcc46 |
TIMESTAMP |
Date of the most recent diagnosis associated with Severe Hematological Disorders
|
| hcc47 |
TIMESTAMP |
Date of the most recent diagnosis associated with Disorders of Immunity
|
| hcc48 |
TIMESTAMP |
Date of the most recent diagnosis associated with Coagulation Defects and Other Specified Hematological Disorders
|
| hcc54 |
TIMESTAMP |
Date of the most recent diagnosis associated with Drug/Alcohol Psychosis
|
| hcc55 |
TIMESTAMP |
Date of the most recent diagnosis associated with Drug/Alcohol Dependence
|
| hcc57 |
TIMESTAMP |
Date of the most recent diagnosis associated with Schizophrenia
|
| hcc58 |
TIMESTAMP |
Date of the most recent diagnosis associated with Major Depressive, Bipolar, and Paranoid Disorders
|
| hcc70 |
TIMESTAMP |
Date of the most recent diagnosis associated with Quadriplegia
|
| hcc71 |
TIMESTAMP |
Date of the most recent diagnosis associated with Paraplegia
|
| hcc72 |
TIMESTAMP |
Date of the most recent diagnosis associated with Spinal Cord Disorders/Injuries
|
| hcc73 |
TIMESTAMP |
Date of the most recent diagnosis associated with Amyotrophic Lateral Sclerosis and Other Motor Neuron Disease
|
| hcc74 |
TIMESTAMP |
Date of the most recent diagnosis associated with Cerebral Palsy
|
| hcc75 |
TIMESTAMP |
Date of the most recent diagnosis associated with Myasthenia Gravis/Myoneural Disorders, Inflammatory and Toxic Neuropathy
|
| hcc76 |
TIMESTAMP |
Date of the most recent diagnosis associated with Muscular Dystrophy
|
| hcc77 |
TIMESTAMP |
Date of the most recent diagnosis associated with Multiple Sclerosis
|
| hcc78 |
TIMESTAMP |
Date of the most recent diagnosis associated with Parkinsons and Huntingtons Diseases
|
| hcc79 |
TIMESTAMP |
Date of the most recent diagnosis associated with Seizure Disorders and Convulsions
|
| hcc80 |
TIMESTAMP |
Date of the most recent diagnosis associated with Coma, Brain Compression/Anoxic Damage
|
| hcc82 |
TIMESTAMP |
Date of the most recent diagnosis associated with Respirator Dependence/Tracheostomy Status
|
| hcc83 |
TIMESTAMP |
Date of the most recent diagnosis associated with Respiratory Arrest
|
| hcc84 |
TIMESTAMP |
Date of the most recent diagnosis associated with Cardio-Respiratory Failure and Shock
|
| hcc85 |
TIMESTAMP |
Date of the most recent diagnosis associated with Congestive Heart Failure
|
| hcc86 |
TIMESTAMP |
Date of the most recent diagnosis associated with Acute Myocardial Infarction
|
| hcc87 |
TIMESTAMP |
Date of the most recent diagnosis associated with Unstable Angina and Other Acute Ischemic Heart Disease
|
| hcc88 |
TIMESTAMP |
Date of the most recent diagnosis associated with Angina Pectoris
|
| hcc96 |
TIMESTAMP |
Date of the most recent diagnosis associated with Specified Heart Arrhythmias
|
| hcc99 |
TIMESTAMP |
Date of the most recent diagnosis associated with Cerebral Hemorrhage
|
| hcc100 |
TIMESTAMP |
Date of the most recent diagnosis associated with Ischemic or Unspecified Stroke
|
| hcc103 |
TIMESTAMP |
Date of the most recent diagnosis associated with Hemiplegia/Hemiparesis
|
| hcc104 |
TIMESTAMP |
Date of the most recent diagnosis associated with Monoplegia, Other Paralytic Syndromes
|
| hcc106 |
TIMESTAMP |
Date of the most recent diagnosis associated with Atherosclerosis of the Extremities with Ulceration or Gangrene
|
| hcc107 |
TIMESTAMP |
Date of the most recent diagnosis associated with Vascular Disease with Complications”
|
| hcc108 |
TIMESTAMP |
Date of the most recent diagnosis associated with Vascular Disease
|
| hcc110 |
TIMESTAMP |
Date of the most recent diagnosis associated with Cystic Fibrosis
|
| hcc111 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Obstructive Pulmonary Disease
|
| hcc112 |
TIMESTAMP |
Date of the most recent diagnosis associated with Fibrosis of Lung and Other Chronic Lung Disorders
|
| hcc114 |
TIMESTAMP |
Date of the most recent diagnosis associated with Aspiration and Specified Bacterial Pneumonias
|
| hcc115 |
TIMESTAMP |
Date of the most recent diagnosis associated with Pneumococcal Pneumonia, Empyema, Lung Abscess
|
| hcc122 |
TIMESTAMP |
Date of the most recent diagnosis associated with Proliferative Diabetic Retinopathy and Vitreous Hemorrhage
|
| hcc124 |
TIMESTAMP |
Date of the most recent diagnosis associated with Exudative Macular Degeneration
|
| hcc134 |
TIMESTAMP |
Date of the most recent diagnosis associated with Dialysis Status
|
| hcc135 |
TIMESTAMP |
Date of the most recent diagnosis associated with Acute Renal Failure
|
| hcc136 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Kidney Disease, Stage 5
|
| hcc137 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Kidney Disease, Severe (Stage 4)
|
| hcc157 |
TIMESTAMP |
Date of the most recent diagnosis associated with Pressure Ulcer of Skin with Necrosis Through to Muscle, Tendon, or Bone
|
| hcc158 |
TIMESTAMP |
Date of the most recent diagnosis associated with Pressure Ulcer of Skin with Full Thickness Skin Loss
|
| hcc161 |
TIMESTAMP |
Date of the most recent diagnosis associated with Chronic Ulcer of Skin, Except Pressure
|
| hcc162 |
TIMESTAMP |
Date of the most recent diagnosis associated with Severe Skin Burn or Condition
|
| hcc166 |
TIMESTAMP |
Date of the most recent diagnosis associated with Severe Head Injury
|
| hcc167 |
TIMESTAMP |
Date of the most recent diagnosis associated with Major Head Injury
|
| hcc169 |
TIMESTAMP |
Date of the most recent diagnosis associated with Vertebral Fractures without Spinal Cord Injury
|
| hcc170 |
TIMESTAMP |
Date of the most recent diagnosis associated with Hip Fracture/Dislocation
|
| hcc173 |
TIMESTAMP |
Date of the most recent diagnosis associated with Traumatic Amputations and Complications
|
| hcc176 |
TIMESTAMP |
Date of the most recent diagnosis associated with Complications of Specified Implanted Device or Graft
|
| hcc186 |
TIMESTAMP |
Date of the most recent diagnosis associated with Major Organ Transplant or Replacement Status
|
| hcc188 |
TIMESTAMP |
Date of the most recent diagnosis associated with Artificial Openings for Feeding or Elimination
|
| hcc189 |
TIMESTAMP |
Date of the most recent diagnosis associated with Amputation Status, Lower Limb/Amputation Complications
|
