CMed_Stage_EDObsIPVisits_Outbound

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ResidentNumberMRN varchar 50 null
VW_CMed_Stage_EDObsIPVisits_Outbound.ResidentNumberMRN Implied ConstraintR
FirstName varchar 100 √ null
MiddleName varchar 50 √ null
LastName varchar 100 √ null
DateOfBirth date 6 √ null
Gender varchar 50 √ null
Address1 varchar 200 √ null
City varchar 100 √ null
State varchar 50 √ null
ZipCode varchar 50 √ null
Phone varchar 50 √ null
AVA_insdate datetime2 16,3 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_CMed_Stage_EDObsIPVisits_Outbound Primary key Asc ResidentNumberMRN

Relationships

Close relationships within degrees of separation