personccs

The personccs table has one row for each person and a column representing each CCSR condition category. Each column contains the date of the most recent diagnoses (from any care setting, any data source) that rolls up to the specified condition category. This table is a pivoted representation of the ccsprofile table.

If a diagnoses for a specified HCC has never been coded for a person, the column will be NULL.

See also: Condition Profiles and Risk Score

Usage

Use this table for efficient searches to determine all persons that have a coded diagnoses for a given condition category.

Source Concepts

  • claim
  • encounter

Table Schema

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.

BLD001 TIMESTAMP

Date of the most recent Nutritional anemia

BLD002 TIMESTAMP

Date of the most recent Hemolytic anemia

BLD003 TIMESTAMP

Date of the most recent Aplastic anemia

BLD004 TIMESTAMP

Date of the most recent Acute posthemorrhagic anemia

BLD005 TIMESTAMP

Date of the most recent Sickle cell trait/anemia

BLD006 TIMESTAMP

Date of the most recent Coagulation and hemorrhagic disorders

BLD007 TIMESTAMP

Date of the most recent Diseases of white blood cells

BLD008 TIMESTAMP

Date of the most recent Immunity disorders

BLD009 TIMESTAMP

Date of the most recent Postprocedural or postoperative complications of the spleen

BLD010 TIMESTAMP

Date of the most recent Other specified and unspecified hematologic conditions

CIR001 TIMESTAMP

Date of the most recent Chronic rheumatic heart disease

CIR002 TIMESTAMP

Date of the most recent Acute rheumatic heart disease

CIR003 TIMESTAMP

Date of the most recent Nonrheumatic and unspecified valve disorders

CIR004 TIMESTAMP

Date of the most recent Endocarditis and endocardial disease

CIR005 TIMESTAMP

Date of the most recent Myocarditis and cardiomyopathy

CIR006 TIMESTAMP

Date of the most recent Pericarditis and pericardial disease

CIR007 TIMESTAMP

Date of the most recent Essential hypertension

CIR008 TIMESTAMP

Date of the most recent Hypertension with complications and secondary hypertension

CIR009 TIMESTAMP

Date of the most recent Acute myocardial infarction

CIR010 TIMESTAMP

Date of the most recent Complications of acute myocardial infarction

CIR011 TIMESTAMP

Date of the most recent Coronary atherosclerosis and other heart disease

CIR012 TIMESTAMP

Date of the most recent Nonspecific chest pain

CIR013 TIMESTAMP

Date of the most recent Acute pulmonary embolism

CIR014 TIMESTAMP

Date of the most recent Pulmonary heart disease

CIR015 TIMESTAMP

Date of the most recent Other and ill-defined heart disease

CIR016 TIMESTAMP

Date of the most recent Conduction disorders

CIR017 TIMESTAMP

Date of the most recent Cardiac dysrhythmias

CIR018 TIMESTAMP

Date of the most recent Cardiac arrest and ventricular fibrillation

CIR019 TIMESTAMP

Date of the most recent Heart failure

CIR020 TIMESTAMP

Date of the most recent Cerebral infarction

CIR021 TIMESTAMP

Date of the most recent Acute hemorrhagic cerebrovascular disease

CIR022 TIMESTAMP

Date of the most recent Sequela of hemorrhagic cerebrovascular disease

CIR023 TIMESTAMP

Date of the most recent Occlusion or stenosis of precerebral or cerebral arteries without infarction

CIR024 TIMESTAMP

Date of the most recent Other and ill-defined cerebrovascular disease

CIR025 TIMESTAMP

Date of the most recent Sequela of cerebral infarction and other cerebrovascular disease

CIR026 TIMESTAMP

Date of the most recent Peripheral and visceral vascular disease

CIR027 TIMESTAMP

Date of the most recent Arterial dissections

CIR028 TIMESTAMP

Date of the most recent Gangrene

CIR029 TIMESTAMP

Date of the most recent Aortic; peripheral; and visceral artery aneurysms

CIR030 TIMESTAMP

Date of the most recent Aortic and peripheral arterial embolism or thrombosis

CIR031 TIMESTAMP

Date of the most recent Hypotension

CIR032 TIMESTAMP

Date of the most recent Other specified and unspecified circulatory disease

CIR033 TIMESTAMP

Date of the most recent Acute phlebitis; thrombophlebitis and thromboembolism

CIR034 TIMESTAMP

Date of the most recent Chronic phlebitis; thrombophlebitis and thromboembolism

CIR035 TIMESTAMP

Date of the most recent Varicose veins of lower extremity

CIR036 TIMESTAMP

Date of the most recent Postthrombotic syndrome and venous insufficiency/hypertension

CIR037 TIMESTAMP

Date of the most recent Vasculitis

CIR038 TIMESTAMP

Date of the most recent Postprocedural or postoperative circulatory system complication

CIR039 TIMESTAMP

Date of the most recent Other specified diseases of veins and lymphatics

DIG001 TIMESTAMP

Date of the most recent Intestinal infection

DIG002 TIMESTAMP

Date of the most recent Disorders of teeth and gingiva

DIG003 TIMESTAMP

Date of the most recent Diseases of mouth; excluding dental

DIG004 TIMESTAMP

Date of the most recent Esophageal disorders

DIG005 TIMESTAMP

Date of the most recent Gastroduodenal ulcer

DIG006 TIMESTAMP

Date of the most recent Gastrointestinal and biliary perforation

DIG007 TIMESTAMP

Date of the most recent Gastritis and duodenitis

DIG008 TIMESTAMP

Date of the most recent Other specified and unspecified disorders of stomach and duodenum

DIG009 TIMESTAMP

Date of the most recent Appendicitis and other appendiceal conditions

DIG010 TIMESTAMP

Date of the most recent Abdominal hernia

DIG011 TIMESTAMP

Date of the most recent Regional enteritis and ulcerative colitis

DIG012 TIMESTAMP

Date of the most recent Intestinal obstruction and ileus

DIG013 TIMESTAMP

Date of the most recent Diverticulosis and diverticulitis

DIG014 TIMESTAMP

Date of the most recent Hemorrhoids

DIG015 TIMESTAMP

Date of the most recent Anal and rectal conditions

DIG016 TIMESTAMP

Date of the most recent Peritonitis and intra-abdominal abscess

DIG017 TIMESTAMP

Date of the most recent Biliary tract disease

DIG018 TIMESTAMP

Date of the most recent Hepatic failure

DIG019 TIMESTAMP

Date of the most recent Other specified and unspecified liver disease

DIG020 TIMESTAMP

Date of the most recent Pancreatic disorders (excluding diabetes)

DIG021 TIMESTAMP

Date of the most recent Gastrointestinal hemorrhage

DIG022 TIMESTAMP

Date of the most recent Noninfectious gastroenteritis

DIG023 TIMESTAMP

Date of the most recent Noninfectious hepatitis

DIG024 TIMESTAMP

Date of the most recent Postprocedural or postoperative digestive system complication

DIG025 TIMESTAMP

Date of the most recent Other specified and unspecified gastrointestinal disorders

EAR001 TIMESTAMP

Date of the most recent Otitis media

EAR002 TIMESTAMP

Date of the most recent Diseases of middle ear and mastoid (except otitis media)

EAR003 TIMESTAMP

Date of the most recent Diseases of inner ear and related conditions

EAR004 TIMESTAMP

Date of the most recent Hearing loss

EAR005 TIMESTAMP

Date of the most recent Postprocedural or postoperative ear and/or mastoid process complication

EAR006 TIMESTAMP

Date of the most recent Other specified and unspecified disorders of the ear

END001 TIMESTAMP

Date of the most recent Thyroid disorders

END002 TIMESTAMP

Date of the most recent Diabetes mellitus without complication

END003 TIMESTAMP

Date of the most recent Diabetes mellitus with complication

END004 TIMESTAMP

Date of the most recent Diabetes mellitus, Type 1

END005 TIMESTAMP

Date of the most recent Diabetes mellitus, Type 2

END006 TIMESTAMP

Date of the most recent Diabetes mellitus, due to underlying condition, drug or chemical induced, or other specified type

END007 TIMESTAMP

Date of the most recent Nutritional deficiencies

END008 TIMESTAMP

Date of the most recent Malnutrition

END009 TIMESTAMP

Date of the most recent Obesity

END010 TIMESTAMP

Date of the most recent Disorders of lipid metabolism

END011 TIMESTAMP

Date of the most recent Fluid and electrolyte disorders

END012 TIMESTAMP

Date of the most recent Cystic fibrosis

END013 TIMESTAMP

Date of the most recent Pituitary disorders

END014 TIMESTAMP

Date of the most recent Postprocedural or postoperative endocrine or metabolic complication

END015 TIMESTAMP

Date of the most recent Other specified and unspecified endocrine disorders

END016 TIMESTAMP

Date of the most recent Other specified and unspecified nutritional and metabolic disorders

END017 TIMESTAMP

Date of the most recent Sequela of malnutrition and other nutritional deficiencies

EXT001 TIMESTAMP

Date of the most recent External cause codes: cut/pierce; initial encounter

EXT002 TIMESTAMP

Date of the most recent External cause codes: drowning/submersion; initial encounter

EXT003 TIMESTAMP

Date of the most recent External cause codes: fall; initial encounter

EXT004 TIMESTAMP

Date of the most recent External cause codes: fire/burn; initial encounter

EXT005 TIMESTAMP

Date of the most recent External cause codes: firearm; initial encounter

EXT006 TIMESTAMP

Date of the most recent External cause codes: machinery; initial encounter

EXT007 TIMESTAMP

Date of the most recent External cause codes: motor vehicle traffic (MVT); initial encounter

EXT008 TIMESTAMP

Date of the most recent External cause codes: pedal cyclist; not MVT; initial encounter

EXT009 TIMESTAMP

Date of the most recent External cause codes: pedestrian; not MVT; initial encounter

EXT010 TIMESTAMP

Date of the most recent External cause codes: transport; not MVT; initial encounter

EXT011 TIMESTAMP

Date of the most recent External cause codes: natural/environment; initial encounter

EXT012 TIMESTAMP

Date of the most recent External cause codes: bites; initial encounter

EXT013 TIMESTAMP

Date of the most recent External cause codes: overexertion; initial encounter

EXT014 TIMESTAMP

Date of the most recent External cause codes: poisoning by drug

EXT015 TIMESTAMP

Date of the most recent External cause codes: poisoning by non-drug

EXT016 TIMESTAMP

Date of the most recent External cause codes: struck by; against; initial encounter

EXT017 TIMESTAMP

Date of the most recent External cause codes: suffocation/inhalation; initial encounter

EXT018 TIMESTAMP

Date of the most recent External cause codes: other specified, classifiable and NEC; initial encounter

EXT019 TIMESTAMP

Date of the most recent External cause codes: unspecified mechanism

EXT020 TIMESTAMP

Date of the most recent External cause codes: intent of injury, accidental/unintentional

EXT021 TIMESTAMP

Date of the most recent External cause codes: intent of injury, self-harm

EXT022 TIMESTAMP

Date of the most recent External cause codes: intent of injury, assault

EXT023 TIMESTAMP

Date of the most recent External cause codes: intent of injury, undetermined

EXT024 TIMESTAMP

Date of the most recent External cause codes: intent of injury, legal intervention/war

EXT025 TIMESTAMP

Date of the most recent External cause codes: complications of medical and surgical care, initial encounter

EXT026 TIMESTAMP

Date of the most recent External cause codes: activity codes

EXT027 TIMESTAMP

Date of the most recent External cause codes: place of occurrence of the external cause

EXT028 TIMESTAMP

Date of the most recent External cause codes: evidence of alcohol involvement

EXT029 TIMESTAMP

Date of the most recent External cause codes: subsequent encounter

EXT030 TIMESTAMP

Date of the most recent External cause codes: sequela

EYE001 TIMESTAMP

Date of the most recent Cornea and external disease

EYE002 TIMESTAMP

Date of the most recent Cataract and other lens disorders

EYE003 TIMESTAMP

Date of the most recent Glaucoma

EYE004 TIMESTAMP

Date of the most recent Uveitis and ocular inflammation

EYE005 TIMESTAMP

Date of the most recent Retinal and vitreous conditions

EYE006 TIMESTAMP

Date of the most recent Neuro-ophthalmology

EYE007 TIMESTAMP

Date of the most recent Strabismus

EYE008 TIMESTAMP

Date of the most recent Oculofacial plastics and orbital conditions

EYE009 TIMESTAMP

Date of the most recent Refractive error

EYE010 TIMESTAMP

Date of the most recent Blindness and vision defects

EYE011 TIMESTAMP

Date of the most recent Postprocedural or postoperative eye complication

EYE012 TIMESTAMP

Date of the most recent Other specified eye disorders

FAC001 TIMESTAMP

Date of the most recent Encounter for administrative purposes

FAC002 TIMESTAMP

Date of the most recent Encounter for mental health services related to abuse

FAC003 TIMESTAMP

Date of the most recent Encounter for observation and examination for conditions ruled out (excludes infectious disease, neoplasm, mental disorders)

FAC004 TIMESTAMP

Date of the most recent Encounter for prophylactic or other procedures

FAC005 TIMESTAMP

Date of the most recent Encounter for prophylactic measures (excludes immunization)

FAC006 TIMESTAMP

Date of the most recent Encounter for antineoplastic therapies

FAC007 TIMESTAMP

Date of the most recent Encounter for mental health conditions

FAC008 TIMESTAMP

Date of the most recent Neoplasm-related encounters

FAC009 TIMESTAMP

Date of the most recent Implant, device or graft related encounter

FAC010 TIMESTAMP

Date of the most recent Other aftercare encounter

FAC011 TIMESTAMP

Date of the most recent Counseling related to sexual behavior or orientation

FAC012 TIMESTAMP

Date of the most recent Other specified encounters and counseling

FAC013 TIMESTAMP

Date of the most recent Contraceptive and procreative management

FAC014 TIMESTAMP

Date of the most recent Medical examination/evaluation

FAC015 TIMESTAMP

Date of the most recent Resistance to antimicrobial drugs

FAC016 TIMESTAMP

Date of the most recent Exposure, encounters, screening or contact with infectious disease

FAC017 TIMESTAMP

Date of the most recent No immunization or underimmunization

FAC018 TIMESTAMP

Date of the most recent Screening for neurocognitive or neurodevelopmental condition

FAC019 TIMESTAMP

Date of the most recent Socioeconomic/psychosocial factors

FAC020 TIMESTAMP

Date of the most recent Lifestyle/life management factors

FAC021 TIMESTAMP

Date of the most recent Personal/family history of disease

FAC022 TIMESTAMP

Date of the most recent Acquired absence of limb or organ

FAC023 TIMESTAMP

Date of the most recent Organ transplant status

FAC024 TIMESTAMP

Date of the most recent Carrier status

FAC025 TIMESTAMP

Date of the most recent Other specified status

GEN001 TIMESTAMP

Date of the most recent Nephritis; nephrosis; renal sclerosis

GEN002 TIMESTAMP

Date of the most recent Acute and unspecified renal failure

GEN003 TIMESTAMP

Date of the most recent Chronic kidney disease

GEN004 TIMESTAMP

Date of the most recent Urinary tract infections

GEN005 TIMESTAMP

Date of the most recent Calculus of urinary tract

GEN006 TIMESTAMP

Date of the most recent Other specified and unspecified diseases of kidney and ureters

GEN007 TIMESTAMP

Date of the most recent Other specified and unspecified diseases of bladder and urethra

GEN008 TIMESTAMP

Date of the most recent Urinary incontinence

GEN009 TIMESTAMP

Date of the most recent Hematuria

GEN010 TIMESTAMP

Date of the most recent Proteinuria

GEN011 TIMESTAMP

Date of the most recent Vesicoureteral reflux

GEN012 TIMESTAMP

Date of the most recent Hyperplasia of prostate

GEN013 TIMESTAMP

Date of the most recent Inflammatory conditions of male genital organs

GEN014 TIMESTAMP

Date of the most recent Erectile dysfunction

GEN015 TIMESTAMP

Date of the most recent Male infertility

GEN016 TIMESTAMP

Date of the most recent Other specified male genital disorders

GEN017 TIMESTAMP

Date of the most recent Nonmalignant breast conditions

GEN018 TIMESTAMP

Date of the most recent Inflammatory diseases of female pelvic organs

GEN019 TIMESTAMP

Date of the most recent Endometriosis

GEN020 TIMESTAMP

Date of the most recent Prolapse of female genital organs

GEN021 TIMESTAMP

Date of the most recent Menstrual disorders

GEN022 TIMESTAMP

Date of the most recent Benign ovarian cyst

GEN023 TIMESTAMP

Date of the most recent Menopausal disorders

GEN024 TIMESTAMP

Date of the most recent Female infertility

GEN025 TIMESTAMP

Date of the most recent Other specified female genital disorders

GEN026 TIMESTAMP

Date of the most recent Postprocedural or postoperative genitourinary system complication

INF001 TIMESTAMP

Date of the most recent Tuberculosis

INF002 TIMESTAMP

Date of the most recent Septicemia

INF003 TIMESTAMP

Date of the most recent Bacterial infections

INF004 TIMESTAMP

Date of the most recent Fungal infections

INF005 TIMESTAMP

Date of the most recent Foodborne intoxications

INF006 TIMESTAMP

Date of the most recent HIV infection

INF007 TIMESTAMP

Date of the most recent Hepatitis

INF008 TIMESTAMP

Date of the most recent Viral infection

INF009 TIMESTAMP

Date of the most recent Parasitic, other specified and unspecified infections

INF010 TIMESTAMP

Date of the most recent Sexually transmitted infections (excluding HIV and hepatitis)

INF011 TIMESTAMP

Date of the most recent Sequela of specified infectious disease conditions

INF012 TIMESTAMP

Date of the most recent Coronavirus disease – 2019 (COVID-19)

INJ001 TIMESTAMP

Date of the most recent Fracture of head and neck, initial encounter

INJ002 TIMESTAMP

Date of the most recent Fracture of the spine and back, initial encounter

INJ003 TIMESTAMP

Date of the most recent Fracture of torso, initial encounter

INJ004 TIMESTAMP

Date of the most recent Fracture of the upper limb, initial encounter

INJ005 TIMESTAMP

Date of the most recent Fracture of the lower limb (except hip), initial encounter

INJ006 TIMESTAMP

Date of the most recent Fracture of the neck of the femur (hip), initial encounter

INJ007 TIMESTAMP

Date of the most recent Dislocations, initial encounter

INJ008 TIMESTAMP

Date of the most recent Traumatic brain injury (TBI); concussion, initial encounter

INJ009 TIMESTAMP

Date of the most recent Spinal cord injury (SCI), initial encounter

INJ010 TIMESTAMP

Date of the most recent Internal organ injury, initial encounter

INJ011 TIMESTAMP

Date of the most recent Open wounds of head and neck, initial encounter

INJ012 TIMESTAMP

Date of the most recent Open wounds to limbs, initial encounter

INJ013 TIMESTAMP

Date of the most recent Open wounds of trunk, initial encounter

INJ014 TIMESTAMP

Date of the most recent Amputation of a limb, initial encounter

INJ015 TIMESTAMP

Date of the most recent Amputation of other body parts, initial encounter

INJ016 TIMESTAMP

Date of the most recent Injury to blood vessels, initial encounter

INJ017 TIMESTAMP

Date of the most recent Superficial injury; contusion, initial encounter

INJ018 TIMESTAMP

Date of the most recent Crushing injury, initial encounter

INJ019 TIMESTAMP

Date of the most recent Burn and corrosion, initial encounter

INJ020 TIMESTAMP

Date of the most recent Effect of foreign body entering opening, initial encounter

INJ021 TIMESTAMP

Date of the most recent Effect of other external causes, initial encounter

INJ022 TIMESTAMP

Date of the most recent Poisoning by drugs, initial encounter

INJ023 TIMESTAMP

Date of the most recent Toxic effects, initial encounter

INJ024 TIMESTAMP

Date of the most recent Sprains and strains, initial encounter

INJ025 TIMESTAMP

Date of the most recent Injury to nerves, muscles and tendons, initial encounter

INJ026 TIMESTAMP

Date of the most recent Other specified injury

INJ027 TIMESTAMP

Date of the most recent Other unspecified injury

INJ028 TIMESTAMP

Date of the most recent Adverse effects of drugs and medicaments, initial encounter

INJ029 TIMESTAMP

Date of the most recent Underdosing of drugs and medicaments, initial encounter

INJ030 TIMESTAMP

Date of the most recent Drug induced or toxic related condition

INJ031 TIMESTAMP

Date of the most recent Allergic reactions

INJ032 TIMESTAMP

Date of the most recent Maltreatment/abuse

INJ033 TIMESTAMP

Date of the most recent Complication of cardiovascular device, implant or graft, initial encounter

INJ034 TIMESTAMP

Date of the most recent Complication of genitourinary device, implant or graft, initial encounter

INJ035 TIMESTAMP

Date of the most recent Complication of internal orthopedic device or implant, initial encounter

INJ036 TIMESTAMP

Date of the most recent Complication of transplanted organs or tissue, initial encounter

INJ037 TIMESTAMP

Date of the most recent Complication of other surgical or medical care, injury, initial encounter

INJ038 TIMESTAMP

Date of the most recent Fracture of head and neck, subsequent encounter

INJ039 TIMESTAMP

Date of the most recent Fracture of the spine and back, subsequent encounter

INJ040 TIMESTAMP

Date of the most recent Fracture of torso, subsequent encounter

INJ041 TIMESTAMP

Date of the most recent Fracture of the upper limb, subsequent encounter

INJ042 TIMESTAMP

Date of the most recent Fracture of lower limb (except hip), subsequent encounter

INJ043 TIMESTAMP

Date of the most recent Fracture of the neck of the femur (hip), subsequent encounter

INJ044 TIMESTAMP

Date of the most recent Dislocations, subsequent encounter

INJ045 TIMESTAMP

Date of the most recent Traumatic brain injury (TBI); concussion, subsequent encounter

INJ046 TIMESTAMP

Date of the most recent Spinal cord injury (SCI), subsequent encounter

INJ047 TIMESTAMP

Date of the most recent Internal organ injury, subsequent encounter

INJ048 TIMESTAMP

Date of the most recent Open wounds of head and neck, subsequent encounter

INJ049 TIMESTAMP

Date of the most recent Open wounds to limbs, subsequent encounter

INJ050 TIMESTAMP

Date of the most recent Open wounds of trunk, subsequent encounter

INJ051 TIMESTAMP

Date of the most recent Amputation of a limb, subsequent encounter

INJ052 TIMESTAMP

Date of the most recent Amputation of other body parts, subsequent encounter

INJ053 TIMESTAMP

Date of the most recent Injury to blood vessels, subsequent encounter

INJ054 TIMESTAMP

Date of the most recent Superficial injury; contusion, subsequent encounter

INJ055 TIMESTAMP

Date of the most recent Crushing injury, subsequent encounter

INJ056 TIMESTAMP

Date of the most recent Burns and corrosion, subsequent encounter

INJ057 TIMESTAMP

Date of the most recent Effect of foreign body entering opening, subsequent encounter

INJ058 TIMESTAMP

Date of the most recent Effect of other external causes, subsequent encounter

INJ059 TIMESTAMP

Date of the most recent Poisoning by drugs, subsequent encounter

INJ060 TIMESTAMP

Date of the most recent Toxic effects, subsequent encounter

INJ061 TIMESTAMP

Date of the most recent Sprains and strains, subsequent encounter

INJ062 TIMESTAMP

Date of the most recent Injury to nerves, muscles and tendons, subsequent encounter

INJ063 TIMESTAMP

Date of the most recent Other specified injury, subsequent encounter

INJ064 TIMESTAMP

Date of the most recent Other unspecified injuries, subsequent encounter

INJ065 TIMESTAMP

Date of the most recent Adverse effects of drugs and medicaments, subsequent encounter

INJ066 TIMESTAMP

Date of the most recent Underdosing of drugs and medicaments, subsequent encounter

INJ067 TIMESTAMP

Date of the most recent Allergic reactions, subsequent encounter

INJ068 TIMESTAMP

Date of the most recent Maltreatment/abuse, subsequent encounter

INJ069 TIMESTAMP

Date of the most recent Complication of cardiovascular device, implant or graft, subsequent encounter

INJ070 TIMESTAMP

Date of the most recent Complication of genitourinary device, implant or graft, subsequent encounter

INJ071 TIMESTAMP

Date of the most recent Complication of internal orthopedic device or implant, subsequent encounter

INJ072 TIMESTAMP

Date of the most recent Complication of other surgical or medical care, injury, subsequent encounter

INJ073 TIMESTAMP

Date of the most recent Injury, sequela

INJ074 TIMESTAMP

Date of the most recent Effect of other external causes, sequela

INJ075 TIMESTAMP

Date of the most recent Poisoning/toxic effect/adverse effects/underdosing, sequela

INJ076 TIMESTAMP

Date of the most recent Complication, sequela

MAL001 TIMESTAMP

Date of the most recent Cardiac and circulatory congenital anomalies

MAL002 TIMESTAMP

Date of the most recent Digestive congenital anomalies

MAL003 TIMESTAMP

Date of the most recent Genitourinary congenital anomalies

MAL004 TIMESTAMP

Date of the most recent Nervous system congenital anomalies

MAL005 TIMESTAMP

Date of the most recent Congenital malformations of eye, ear, face, neck

MAL006 TIMESTAMP

Date of the most recent Cleft lip or palate

MAL007 TIMESTAMP

Date of the most recent Respiratory congenital malformations

MAL008 TIMESTAMP

Date of the most recent Musculoskeletal congenital conditions

MAL009 TIMESTAMP

Date of the most recent Chromosomal abnormalities

MAL010 TIMESTAMP

Date of the most recent Other specified and unspecified congenital anomalies

MBD001 TIMESTAMP

Date of the most recent Schizophrenia spectrum and other psychotic disorders

MBD002 TIMESTAMP

Date of the most recent Depressive disorders

MBD003 TIMESTAMP

Date of the most recent Bipolar and related disorders

MBD004 TIMESTAMP

Date of the most recent Other specified and unspecified mood disorders

MBD005 TIMESTAMP

Date of the most recent Anxiety and fear-related disorders

MBD006 TIMESTAMP

Date of the most recent Obsessive-compulsive and related disorders

MBD007 TIMESTAMP

Date of the most recent Trauma- and stressor-related disorders

MBD008 TIMESTAMP

Date of the most recent Disruptive, impulse-control and conduct disorders

MBD009 TIMESTAMP

Date of the most recent Personality disorders

MBD010 TIMESTAMP

Date of the most recent Feeding and eating disorders

MBD011 TIMESTAMP

Date of the most recent Somatic disorders

MBD012 TIMESTAMP

Date of the most recent Suicidal ideation/attempt/intentional self-harm

MBD013 TIMESTAMP

Date of the most recent Miscellaneous mental and behavioral disorders/conditions

MBD014 TIMESTAMP

Date of the most recent Neurodevelopmental disorders

MBD017 TIMESTAMP

Date of the most recent Alcohol-related disorders

MBD018 TIMESTAMP

Date of the most recent Opioid-related disorders

MBD019 TIMESTAMP

Date of the most recent Cannabis-related disorders

MBD020 TIMESTAMP

Date of the most recent Sedative-related disorders

MBD021 TIMESTAMP

Date of the most recent Stimulant-related disorders

MBD022 TIMESTAMP

Date of the most recent Hallucinogen-related disorders

MBD023 TIMESTAMP

Date of the most recent Inhalant-related disorders

MBD024 TIMESTAMP

Date of the most recent Tobacco-related disorders

MBD025 TIMESTAMP

Date of the most recent Other specified substance-related disorders

MBD026 TIMESTAMP

Date of the most recent Mental and substance use disorders in remission

MBD027 TIMESTAMP

Date of the most recent Suicide attempt/intentional self-harm; subsequent encounter

MBD028 TIMESTAMP

Date of the most recent Opioid-related disorders; subsequent encounter

MBD029 TIMESTAMP

Date of the most recent Stimulant-related disorders; subsequent encounter

MBD030 TIMESTAMP

Date of the most recent Cannabis-related disorders; subsequent encounter

MBD031 TIMESTAMP

Date of the most recent Hallucinogen-related disorders; subsequent encounter

MBD032 TIMESTAMP

Date of the most recent Sedative-related disorders; subsequent encounter

MBD033 TIMESTAMP

Date of the most recent Inhalant-related disorders; subsequent encounter

MBD034 TIMESTAMP

Date of the most recent Mental and substance use disorders; sequela

MUS001 TIMESTAMP

Date of the most recent Infective arthritis

MUS002 TIMESTAMP

Date of the most recent Osteomyelitis

MUS003 TIMESTAMP

Date of the most recent Rheumatoid arthritis and related disease

MUS004 TIMESTAMP

Date of the most recent Juvenile arthritis

MUS005 TIMESTAMP

Date of the most recent Other specified chronic arthropathy

MUS006 TIMESTAMP

Date of the most recent Osteoarthritis

MUS007 TIMESTAMP

Date of the most recent Other specified joint disorders

MUS008 TIMESTAMP

Date of the most recent Immune-mediated/reactive arthropathies

MUS009 TIMESTAMP

Date of the most recent Tendon and synovial disorders

MUS010 TIMESTAMP

Date of the most recent Musculoskeletal pain, not low back pain

MUS011 TIMESTAMP

Date of the most recent Spondylopathies/spondyloarthropathy (including infective)

MUS012 TIMESTAMP

Date of the most recent Biomechanical lesions

MUS013 TIMESTAMP

Date of the most recent Osteoporosis

MUS014 TIMESTAMP

Date of the most recent Pathological fracture, initial encounter

MUS015 TIMESTAMP

Date of the most recent Pathological fracture, subsequent encounter

MUS016 TIMESTAMP

Date of the most recent Stress fracture, initial encounter

MUS017 TIMESTAMP

Date of the most recent Stress fracture, subsequent encounter

MUS018 TIMESTAMP

Date of the most recent Atypical fracture, initial encounter

MUS019 TIMESTAMP

Date of the most recent Atypical fracture, subsequent encounter

MUS020 TIMESTAMP

Date of the most recent Pathological, stress and atypical fractures, sequela

MUS021 TIMESTAMP

Date of the most recent Acquired foot deformities

MUS022 TIMESTAMP

Date of the most recent Scoliosis and other postural dorsopathic deformities

MUS023 TIMESTAMP

Date of the most recent Acquired deformities (excluding foot)

MUS024 TIMESTAMP

Date of the most recent Systemic lupus erythematosus and connective tissue disorders

MUS025 TIMESTAMP

Date of the most recent Other specified connective tissue disease

MUS026 TIMESTAMP

Date of the most recent Muscle disorders

MUS027 TIMESTAMP

Date of the most recent Musculoskeletal abscess

MUS028 TIMESTAMP

Date of the most recent Other specified bone disease and musculoskeletal deformities

MUS029 TIMESTAMP

Date of the most recent Disorders of jaw

MUS030 TIMESTAMP

Date of the most recent Aseptic necrosis and osteonecrosis

MUS031 TIMESTAMP

Date of the most recent Traumatic arthropathy

MUS032 TIMESTAMP

Date of the most recent Neurogenic/neuropathic arthropathy

MUS033 TIMESTAMP

Date of the most recent Gout

MUS034 TIMESTAMP

Date of the most recent Crystal arthropathies (excluding gout)

MUS035 TIMESTAMP

Date of the most recent Osteomalacia

MUS036 TIMESTAMP

Date of the most recent Autoinflammatory syndromes

MUS037 TIMESTAMP

Date of the most recent Postprocedural or postoperative musculoskeletal system complication

MUS038 TIMESTAMP

Date of the most recent Low back pain

NEO001 TIMESTAMP

Date of the most recent Head and neck cancers - eye

NEO002 TIMESTAMP

Date of the most recent Head and neck cancers - lip and oral cavity

NEO003 TIMESTAMP

Date of the most recent Head and neck cancers - throat

NEO004 TIMESTAMP

Date of the most recent Head and neck cancers - salivary gland

NEO005 TIMESTAMP

Date of the most recent Head and neck cancers - nasopharyngeal

NEO006 TIMESTAMP

Date of the most recent Head and neck cancers - hypopharyngeal

NEO007 TIMESTAMP

Date of the most recent Head and neck cancers - pharyngeal

NEO008 TIMESTAMP

Date of the most recent Head and neck cancers - laryngeal

NEO009 TIMESTAMP

Date of the most recent Head and neck cancers - tonsils

NEO010 TIMESTAMP

Date of the most recent Head and neck cancers - all other types

NEO011 TIMESTAMP

Date of the most recent Cardiac cancers

NEO012 TIMESTAMP

Date of the most recent Gastrointestinal cancers - esophagus

NEO013 TIMESTAMP

Date of the most recent Gastrointestinal cancers - stomach

NEO014 TIMESTAMP

Date of the most recent Gastrointestinal cancers - small intestine

NEO015 TIMESTAMP

Date of the most recent Gastrointestinal cancers - colorectal

NEO016 TIMESTAMP

Date of the most recent Gastrointestinal cancers - anus

NEO017 TIMESTAMP

Date of the most recent Gastrointestinal cancers - liver

NEO018 TIMESTAMP

Date of the most recent Gastrointestinal cancers - bile duct

NEO019 TIMESTAMP

Date of the most recent Gastrointestinal cancers - gallbladder

NEO020 TIMESTAMP

Date of the most recent Gastrointestinal cancers - peritoneum

NEO021 TIMESTAMP

Date of the most recent Gastrointestinal cancers - all other types

NEO022 TIMESTAMP

Date of the most recent Respiratory cancers

NEO023 TIMESTAMP

Date of the most recent Bone cancer

NEO024 TIMESTAMP

Date of the most recent Sarcoma

NEO025 TIMESTAMP

Date of the most recent Skin cancers - melanoma

NEO026 TIMESTAMP

Date of the most recent Skin cancers - basal cell carcinoma

NEO027 TIMESTAMP

Date of the most recent Skin cancers - squamous cell carcinoma

NEO028 TIMESTAMP

Date of the most recent Skin cancers - all other types

NEO029 TIMESTAMP

Date of the most recent Breast cancer - ductal carcinoma in situ (DCIS)

NEO030 TIMESTAMP

Date of the most recent Breast cancer - all other types

NEO031 TIMESTAMP

Date of the most recent Female reproductive system cancers - uterus

NEO032 TIMESTAMP

Date of the most recent Female reproductive system cancers - cervix

NEO033 TIMESTAMP

Date of the most recent Female reproductive system cancers - ovary

NEO034 TIMESTAMP

Date of the most recent Female reproductive system cancers - fallopian tube

NEO035 TIMESTAMP

Date of the most recent Female reproductive system cancers - endometrium

NEO036 TIMESTAMP

Date of the most recent Female reproductive system cancers - vulva

NEO037 TIMESTAMP

Date of the most recent Female reproductive system cancers - vagina

NEO038 TIMESTAMP

Date of the most recent Female reproductive system cancers - all other types

NEO039 TIMESTAMP

Date of the most recent Male reproductive system cancers - prostate

NEO040 TIMESTAMP

Date of the most recent Male reproductive system cancers - testis

NEO041 TIMESTAMP

Date of the most recent Male reproductive system cancers - penis

NEO042 TIMESTAMP

Date of the most recent Male reproductive system cancers - all other types

NEO043 TIMESTAMP

Date of the most recent Urinary system cancers - bladder

NEO044 TIMESTAMP

Date of the most recent Urinary system cancers - ureter and renal pelvis

NEO045 TIMESTAMP

Date of the most recent Urinary system cancers - kidney

NEO046 TIMESTAMP

Date of the most recent Urinary system cancers - urethra

NEO047 TIMESTAMP

Date of the most recent Urinary system cancers - all other types

NEO048 TIMESTAMP

Date of the most recent Nervous system cancers - brain

NEO049 TIMESTAMP

Date of the most recent Nervous system cancers - all other types

NEO050 TIMESTAMP

Date of the most recent Endocrine system cancers - thyroid

NEO051 TIMESTAMP

Date of the most recent Endocrine system cancers - pancreas

NEO052 TIMESTAMP

Date of the most recent Endocrine system cancers - thymus

NEO053 TIMESTAMP

Date of the most recent Endocrine system cancers - adrenocortical

NEO054 TIMESTAMP

Date of the most recent Endocrine system cancers - parathyroid

NEO055 TIMESTAMP

Date of the most recent Endocrine system cancers - pituitary gland

NEO056 TIMESTAMP

Date of the most recent Endocrine system cancers - all other types

NEO057 TIMESTAMP

Date of the most recent Hodgkin lymphoma

NEO058 TIMESTAMP

Date of the most recent Non-Hodgkin lymphoma

NEO059 TIMESTAMP

Date of the most recent Leukemia - acute lymphoblastic leukemia (ALL)

NEO060 TIMESTAMP

Date of the most recent Leukemia - acute myeloid leukemia (AML)

NEO061 TIMESTAMP

Date of the most recent Leukemia - chronic lymphocytic leukemia (CLL)

NEO062 TIMESTAMP

Date of the most recent Leukemia - chronic myeloid leukemia (CML)

NEO063 TIMESTAMP

Date of the most recent Leukemia - hairy cell

NEO064 TIMESTAMP

Date of the most recent Leukemia - all other types

NEO065 TIMESTAMP

Date of the most recent Multiple myeloma

NEO066 TIMESTAMP

Date of the most recent Malignant neuroendocrine tumors

NEO067 TIMESTAMP

Date of the most recent Mesothelioma

NEO068 TIMESTAMP

Date of the most recent Myelodysplastic syndrome (MDS)

NEO069 TIMESTAMP

Date of the most recent Cancer of other sites

NEO070 TIMESTAMP

Date of the most recent Secondary malignancies

NEO071 TIMESTAMP

Date of the most recent Malignant neoplasm, unspecified

NEO072 TIMESTAMP

Date of the most recent Neoplasms of unspecified nature or uncertain behavior

NEO073 TIMESTAMP

Date of the most recent Benign neoplasms

NEO074 TIMESTAMP

Date of the most recent Conditions due to neoplasm or the treatment of neoplasm

NVS001 TIMESTAMP

Date of the most recent Meningitis

NVS002 TIMESTAMP

Date of the most recent Encephalitis

NVS003 TIMESTAMP

Date of the most recent Other specified CNS infection and poliomyelitis

NVS004 TIMESTAMP

Date of the most recent Parkinson`s disease

NVS005 TIMESTAMP

Date of the most recent Multiple sclerosis

NVS006 TIMESTAMP

Date of the most recent Other specified hereditary and degenerative nervous system conditions

NVS007 TIMESTAMP

Date of the most recent Cerebral palsy

NVS008 TIMESTAMP

Date of the most recent Paralysis (other than cerebral palsy)

NVS009 TIMESTAMP

Date of the most recent Epilepsy; convulsions

NVS010 TIMESTAMP

Date of the most recent Headache; including migraine

NVS011 TIMESTAMP

Date of the most recent Neurocognitive disorders

NVS012 TIMESTAMP

Date of the most recent Transient cerebral ischemia

NVS013 TIMESTAMP

Date of the most recent Coma; stupor; and brain damage

NVS014 TIMESTAMP

Date of the most recent CNS abscess

NVS015 TIMESTAMP

Date of the most recent Polyneuropathies

NVS016 TIMESTAMP

Date of the most recent Sleep wake disorders

NVS017 TIMESTAMP

Date of the most recent Nerve and nerve root disorders

NVS018 TIMESTAMP

Date of the most recent Myopathies

NVS019 TIMESTAMP

Date of the most recent Nervous system pain and pain syndromes

NVS020 TIMESTAMP

Date of the most recent Other specified nervous system disorders

NVS021 TIMESTAMP

Date of the most recent Postprocedural or postoperative nervous system complication

NVS022 TIMESTAMP

Date of the most recent Sequela of specified nervous system conditions

PNL001 TIMESTAMP

Date of the most recent Liveborn

PNL002 TIMESTAMP

Date of the most recent Short gestation; low birth weight; and fetal growth retardation

PNL003 TIMESTAMP

Date of the most recent Neonatal acidemia and hypoxia

PNL004 TIMESTAMP

Date of the most recent Neonatal cerebral disorders

PNL005 TIMESTAMP

Date of the most recent Respiratory distress syndrome

PNL006 TIMESTAMP

Date of the most recent Respiratory perinatal condition

PNL007 TIMESTAMP

Date of the most recent Hemolytic jaundice and perinatal jaundice

PNL008 TIMESTAMP

Date of the most recent Birth trauma

PNL009 TIMESTAMP

Date of the most recent Perinatal infections

PNL010 TIMESTAMP

Date of the most recent Newborn affected by maternal conditions or complications of labor/delivery

PNL011 TIMESTAMP

Date of the most recent Hemorrhagic and hematologic disorders of newborn

PNL012 TIMESTAMP

Date of the most recent Neonatal digestive and feeding disorders

PNL013 TIMESTAMP

Date of the most recent Other specified and unspecified perinatal conditions

PNL014 TIMESTAMP

Date of the most recent Neonatal abstinence syndrome

PNL015 TIMESTAMP

Date of the most recent Fetal alcohol syndrome

PRG001 TIMESTAMP

Date of the most recent Antenatal screening

PRG002 TIMESTAMP

Date of the most recent Gestational weeks

PRG003 TIMESTAMP

Date of the most recent Spontaneous abortion and complications of spontaneous abortion

PRG004 TIMESTAMP

Date of the most recent Induced abortion and complications of termination of pregnancy

PRG005 TIMESTAMP

Date of the most recent Ectopic pregnancy and complications of ectopic pregnancy

PRG006 TIMESTAMP

Date of the most recent Molar pregnancy and other abnormal products of conception

PRG007 TIMESTAMP

Date of the most recent Complications following ectopic and/or molar pregnancy

PRG008 TIMESTAMP

Date of the most recent Supervision of high-risk pregnancy

PRG009 TIMESTAMP

Date of the most recent Early, first or unspecified trimester hemorrhage

PRG010 TIMESTAMP

Date of the most recent Hemorrhage after first trimester

PRG011 TIMESTAMP

Date of the most recent Early or threatened labor

PRG012 TIMESTAMP

Date of the most recent Multiple gestation

PRG013 TIMESTAMP

Date of the most recent Maternal care related to fetal conditions

PRG014 TIMESTAMP

Date of the most recent Polyhydramnios and other problems of amniotic cavity

PRG015 TIMESTAMP

Date of the most recent Obstetric history affecting care in pregnancy

PRG016 TIMESTAMP

Date of the most recent Previous C-section

PRG017 TIMESTAMP

Date of the most recent Maternal care for abnormality of pelvic organs

PRG018 TIMESTAMP

Date of the most recent Maternal care related to disorders of the placenta and placental implantation

PRG019 TIMESTAMP

Date of the most recent Diabetes or abnormal glucose tolerance complicating pregnancy; childbirth; or the puerperium

PRG020 TIMESTAMP

Date of the most recent Hypertension and hypertensive-related conditions complicating pregnancy; childbirth; and the puerperium

PRG021 TIMESTAMP

Date of the most recent Maternal intrauterine infection

PRG022 TIMESTAMP

Date of the most recent Prolonged pregnancy

PRG023 TIMESTAMP

Date of the most recent Complications specified during childbirth

PRG024 TIMESTAMP

Date of the most recent Malposition, disproportion or other labor complications

PRG025 TIMESTAMP

Date of the most recent Anesthesia complications during pregnancy

PRG026 TIMESTAMP

Date of the most recent OB-related trauma to perineum and vulva

PRG027 TIMESTAMP

Date of the most recent Complications specified during the puerperium

PRG028 TIMESTAMP

Date of the most recent Other specified complications in pregnancy

PRG029 TIMESTAMP

Date of the most recent Uncomplicated pregnancy, delivery or puerperium

PRG030 TIMESTAMP

Date of the most recent Maternal outcome of delivery

RSP001 TIMESTAMP

Date of the most recent Sinusitis

RSP002 TIMESTAMP

Date of the most recent Pneumonia (except that caused by tuberculosis)

RSP003 TIMESTAMP

Date of the most recent Influenza

RSP004 TIMESTAMP

Date of the most recent Acute and chronic tonsillitis

RSP005 TIMESTAMP

Date of the most recent Acute bronchitis

RSP006 TIMESTAMP

Date of the most recent Other specified upper respiratory infections

RSP007 TIMESTAMP

Date of the most recent Other specified and unspecified upper respiratory disease

RSP008 TIMESTAMP

Date of the most recent Chronic obstructive pulmonary disease and bronchiectasis

RSP009 TIMESTAMP

Date of the most recent Asthma

RSP010 TIMESTAMP

Date of the most recent Aspiration pneumonitis

RSP011 TIMESTAMP

Date of the most recent Pleurisy, pleural effusion and pulmonary collapse

RSP012 TIMESTAMP

Date of the most recent Respiratory failure; insufficiency; arrest

RSP013 TIMESTAMP

Date of the most recent Lung disease due to external agents

RSP014 TIMESTAMP

Date of the most recent Pneumothorax

RSP015 TIMESTAMP

Date of the most recent Mediastinal disorders

RSP016 TIMESTAMP

Date of the most recent Other specified and unspecified lower respiratory disease

RSP017 TIMESTAMP

Date of the most recent Postprocedural or postoperative respiratory system complication

SKN001 TIMESTAMP

Date of the most recent Skin and subcutaneous tissue infections

SKN002 TIMESTAMP

Date of the most recent Other specified inflammatory condition of skin

SKN003 TIMESTAMP

Date of the most recent Pressure ulcer of skin

SKN004 TIMESTAMP

Date of the most recent Non-pressure ulcer of skin

SKN005 TIMESTAMP

Date of the most recent Contact dermatitis

SKN006 TIMESTAMP

Date of the most recent Postprocedural or postoperative skin complication

SKN007 TIMESTAMP

Date of the most recent Other specified and unspecified skin disorders

SYM001 TIMESTAMP

Date of the most recent Syncope

SYM002 TIMESTAMP

Date of the most recent Fever

SYM003 TIMESTAMP

Date of the most recent Shock

SYM004 TIMESTAMP

Date of the most recent Nausea and vomiting

SYM005 TIMESTAMP

Date of the most recent Dysphagia

SYM006 TIMESTAMP

Date of the most recent Abdominal pain and other digestive/abdomen signs and symptoms

SYM007 TIMESTAMP

Date of the most recent Malaise and fatigue

SYM008 TIMESTAMP

Date of the most recent Symptoms of mental and substance use conditions

SYM009 TIMESTAMP

Date of the most recent Abnormal findings related to substance use

SYM010 TIMESTAMP

Date of the most recent Nervous system signs and symptoms

SYM011 TIMESTAMP

Date of the most recent Genitourinary signs and symptoms

SYM012 TIMESTAMP

Date of the most recent Circulatory signs and symptoms

SYM013 TIMESTAMP

Date of the most recent Respiratory signs and symptoms

SYM014 TIMESTAMP

Date of the most recent Skin/Subcutaneous signs and symptoms

SYM015 TIMESTAMP

Date of the most recent General sensation/perception signs and symptoms

SYM016 TIMESTAMP

Date of the most recent Other general signs and symptoms

SYM017 TIMESTAMP

Date of the most recent Abnormal findings without diagnosis

XXX000 TIMESTAMP

Date of the most recent Code is unacceptable as a principal diagnosis PDX (only used for the inpatient default CCSR)

XXX111 TIMESTAMP

Date of the most recent Code is unacceptable as a first-listed diagnosis DX1 (only used for the outpatient default CCSR)


Back to Tables