vwTertiaryReferralsDemographics


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PatientID int 4 √ null
DemographicsCareID int 4 null
NHSNumber varchar 10 √ null
NHSNumberStatus varchar 3 √ null
NHSNumberStatusDesc varchar 70 √ null
NstsStatus int 4 √ null
HospitalNumber varchar 20 √ null
Title int 4 √ null
TitleDesc varchar 50 √ null
GivenName varchar 50 √ null
FamilyName varchar 60 √ null
Dob date 20 √ null
GenderCode char 1 √ null
GenderDesc varchar 50 √ null
Address1 varchar 150 √ null
Address2 varchar 150 √ null
Address3 varchar 150 √ null
Address4 varchar 150 √ null
Address5 varchar 150 √ null
Postcode varchar 10 √ null
GpName varchar 100 √ null
GpCode varchar 8 √ null
GpPracticeCode varchar 20 √ null
GpPracticeName varchar 250 √ null
GpPracticeAddress1 varchar 250 √ null
GpPracticeAddress2 varchar 250 √ null
GpPracticeAddress3 varchar 250 √ null
GpPracticeAddress4 varchar 250 √ null
GpPostCode varchar 20 √ null
Ccg varchar 100 √ null
CcgCode varchar 5 √ null
DateOfDeath date 20 √ null
HomePhone varchar 50 √ null
WorkPhone varchar 50 √ null
PatientDeathStatus int 4 √ null
FamilyNameAtBirth varchar 60 √ null
Ethnicity varchar 50 √ null
EthnicityDesc varchar 60 √ null
PersonStatedGenderCode varchar 2 √ null
PersonStatedGenderDesc varchar 75 √ null

View Definition

Possibly Referenced Tables/Views