ContinuumPatients_PreMatch

195775 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
RecordID int identity 4 √ null
source_system varchar 20 null
source_system_id varchar 50 null
ssn varchar 20 √ null
medicare_num varchar 50 √ null
dob date 6 √ null
last_name varchar 100 √ null
first_name varchar 100 √ null
middle_initial varchar 5 √ null
address_1 varchar 200 √ null
address_2 varchar 200 √ null
city varchar 100 √ null
state varchar 100 √ null
zip varchar 20 √ null
phone_1 varchar 50 √ null
phone_2 varchar 50 √ null
phone_3 varchar 50 √ null
email varchar 100 √ null
gender varchar 50 √ null
race varchar 200 √ null
marital_status varchar 100 √ null
created_date datetime2 16,3 √ null
revision_date datetime2 16,3 √ null
AVA_insdate datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_ContinuumPatients_PreMatch Primary key Asc RecordID
UIX_ConitinuumPatients_PreMatch Must be unique Asc/Asc source_system + source_system_id

Diagram producer might be missing

No diagrams were produced please see application output for any errors