tblTERTIARY_REFERRALS_ELECTRONIC


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
tblTERTIARY_REFERRALS.PayloadID FK_tblTERTIARY_REFERRALS_PayloadIDR
tblTERTIARY_REFERRALS_ELECTRONIC_MESSAGES.PayloadID FK_tblTERTIARY_REFERRALS_ELECTRONIC_MESSAGES_PayloadIDR
tblTERTIARY_REFERRALS_ELECTRONIC_VALIDATION.PayloadID FK_tblTERTIARY_REFERRALS_ELECTRONIC_VALIDATION_PayloadIDR
TertiaryReferralReturns.PayloadID FK_TertiaryReferralReturns_PayloadIDR
Status int 4 null
ltblTERTIARY_REFERRALS_STATUS.StatusID FK_tblTERTIARY_REFERRALS_ELECTRONIC_ltblTERTIARY_REFERRALS_STATUSR
ReferralTrackingID uniqueidentifier 16 √ null
AcceptTrackingID uniqueidentifier 16 √ null
ReferralTrackingSetID uniqueidentifier 16 √ null
RecallReason varchar 2147483647 √ null
RecallUserID uniqueidentifier 16 √ null
DateSentFlagged datetime 16,3 √ null
DateRecalledFlagged datetime 16,3 √ null
DateAcceptedFlagged datetime 16,3 √ null
RecallTrackingID uniqueidentifier 16 √ null
TertiaryReferralMessage xml 1073741823 √ null
CancerSiteID int 4 null
DemographicChanges xml 1073741823 √ null
ClosedReason varchar 2147483647 √ null
ClosedUserID uniqueidentifier 16 √ null
DateClosed datetime 16,3 √ null
CwtTargetDate datetime 16,3 √ null
TertiaryReferralMessageValidated xml 1073741823 √ null
NameFromMessage varchar 150 √ null
NHSFromMessage varchar 10 √ null
MessageVersion int 4 null
MessageType varchar 30 null
MessageKey uniqueidentifier 16 √ null
TargetKey uniqueidentifier 16 √ null
DEPRECATED_20_01_DemographicsChanges_backup xml 1073741823 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblTERTIARY_REFERRALS_ELECTRONIC Primary key Asc ID

Relationships

Close relationships within degrees of separation