EPR


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
DocumentID uniqueidentifier 16 null
CreateDateTime datetime 16,3 null
ProcessDateTime datetime 16,3 √ null
TriggerTypeID int 4 null
EPRCheck.TriggerTypeID FK_EPR_EPRCheckR
MessageStatus int 4 null
DocumentExportMessageStatus.ID FK_EPR_DocumentExportMessageStatusR
Response varchar 2 √ null
PPI varchar 20 √ null
VisitID varchar 50 √ null
CareID int 4 null
CancerSiteID int 4 null
ltblCANCER_SITES.CA_ID FK_EPR_ltblCANCER_SITESR
HospitalNumber varchar 20 √ null
NHSNumber varchar 10 √ null
NHSNumberStatus varchar 2 √ null
Surname varchar 60 √ null
Forename varchar 50 √ null
DateOfBirth date 20 √ null
PatientStatusCode varchar 2 √ null
ltblSTATUS.STATUS_CODE FK_EPR_ltblSTATUSR
PatientStatusDesc varchar 75 √ null
DateOfReceipt date 20 √ null
DateOfDiagnosis date 20 √ null
PrimaryDiagnosisCode1 varchar 50 √ null
ltblDIAGNOSIS.DIAG_CODE FK_EPR_ltblDIAGNOSIS_1R
PrimaryDiagnosisDesc1 varchar 150 √ null
PrimaryDiagnosisCode2 varchar 50 √ null
ltblDIAGNOSIS.DIAG_CODE FK_EPR_ltblDIAGNOSIS_2R
PrimaryDiagnosisDesc2 varchar 150 √ null

Indexes

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

Relationships

Close relationships within degrees of separation