BadPatientID


Description

Patient ID correction tracking managing the correction of invalid or duplicate patient identifiers in the system. This data quality table tracks problematic patient IDs that need correction, mapping bad IDs to correct ones with patient identification information to support data cleanup and patient record consolidation efforts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
BadEIID varchar 10 √ null

Bad Early Intervention ID - The incorrect or problematic Early Intervention ID that needs to be corrected
GoodEIID varchar 10 √ null

Correct Early Intervention ID - The correct Early Intervention ID that should replace the bad ID
FirstName varchar 20 √ null

Patient first name - First name of the patient for identification verification
LastName varchar 20 √ null

Patient last name - Last name of the patient for identification verification
Fixed char 5 √ null

Fix status - Status indicating whether the ID correction has been completed

Relationships

Close relationships within degrees of separation