CWTAllReceivedTertiary


Columns

Column Type Size Nulls Auto Default Children Parents Comments
TertiaryReferralID int 4 null
CareID int 4 null
NHSNumber varchar 10 null
NHSNumberStatusIndicator varchar 3 √ null
PatientPathwayID varchar 20 √ null
PatientPathwayIDIssuer varchar 3 √ null
CancerSite varchar 50 √ null
IsTemporaryNHSNumber int 4 null
ReferralReceivedDate smalldatetime 16 √ null
PatientStatus varchar 2 √ null
PriorityTypeCode varchar 2 √ null
DateOfBirth date 20 √ null
DiagnosisDate smalldatetime 16 √ null
ReferralType varchar 2 √ null
SourceOfReferral varchar 2 √ null
Forename varchar 50 √ null
Surname varchar 60 √ null
HospitalNumber varchar 20 √ null
DateSent int 4 √ null
DateReceived datetime 16,3 √ null
ReferringOrgID int 4 √ null
ReferringOrg varchar 5 √ null
ReceivingOrgID int 4 √ null
ReceivingOrg varchar 5 √ null
TertiarySendReason int 4 √ null
TertiaryReceivingReason char 2 √ null
TertiarySendReasonID int 4 √ null
TertiaryReceivingReasonID int 4 √ null
IsSent int 4 null
UpgradeDate int 4 √ null
UpgradeOrganisation int 4 √ null
DateFirstSeen smalldatetime 16 √ null
OrgFirstSeen varchar 5 √ null
FirstSeenWaitingTimeAdjustment int 4 √ null
FirstSeenWaitingTimeAdjustmentReason int 4 √ null
TertiaryReferralComments varchar 2147483647 √ null
PathwayStartDate smalldatetime 16 √ null
Consultant varchar 59 √ null

View Definition

Possibly Referenced Tables/Views