PatientCustom

Primary key - Unique identifier for each custom patient record

Patient reference - Links to Patient table for the associated patient

Creation date - Timestamp when the custom record was created

Created by user - UserID of the person who created this record

Last update date - Timestamp of the most recent record update

Updated by user - UserID of the person who last modified this record

Deletion date - Soft delete timestamp for audit trail purposes

Allergies - Patient’s known allergies and adverse reactions

Birth location - Location where patient was born

Birth weight - Patient’s weight at birth

Current medications - List of medications patient is currently taking

Additional comments - Clinical or administrative notes

Birth county - County where patient was born

NICU days - Number of days spent in Neonatal Intensive Care Unit

Client description - Detailed description of the patient/client

Daily difficulties - Description of challenges patient faces on most days

Detailed ethnicity - More detailed ethnic background information

Findings and plan - Clinical findings and treatment plan

Daily strengths - Description of what goes well for patient on most days

Birth hospital - Hospital where patient was born

Discharge hospital - Hospital from which patient was discharged

Last checkup date - Date of most recent medical checkup

Lead date - Date related to lead exposure screening

Market area - Geographic market or service area

Medical diagnosis - Primary medical diagnoses

Medical history - Comprehensive medical history

Clinical notes - Additional clinical observations and notes

Number of users - Number of people involved in patient’s care

Race - Patient’s racial background

Regular checkups - Frequency of regular medical checkups

School district - School district for educational coordination

Test signature - Digital signature for testing purposes

Gestational age - Gestational age at birth in weeks

Life improvements - What would make patient’s life easier

Orders received date - Date when medical orders were received

Orders sent date - Date when orders were sent

Designated physician - Primary physician assigned to patient