expGP_REF_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
GP_ID int identity 4 √ null
NHSNumber varchar 10 √ null
HospitalNumber varchar 20 √ null
PatientSurname varchar 60 √ null
PatientForename varchar 50 √ null
PatientDOB datetime 16,3 √ null
RegisteredGP varchar 50 √ null
RegisteredGPCode varchar 8 √ null
RegisteredPractice varchar 200 √ null
RegisteredPracticeCode varchar 15 √ null
CCG varchar 100 √ null
CCGCode varchar 5 √ null
Referrer varchar 50 √ null
ReferrerCode varchar 8 √ null
DecisionReferDate datetime 16,3 √ null
DecisionDay varchar 50 √ null
DecisionReceipt int 4 √ null
ReceiptReferralDate datetime 16,3 √ null
ReceiptDay varchar 50 √ null
DateCancelledAppointment datetime 16,3 √ null
AdjustmentTime int 4 √ null
FirstAppointmentDate datetime 16,3 √ null
FirstAppointmentDay varchar 50 √ null
DecisionSeen int 4 √ null
ReferralAppropriateness varchar 50 √ null
ReasonInappropriate varchar 255 √ null
TwoWeekWaitComments varchar 500 √ null
SuspectedCancerType varchar 100 √ null
CancerStatus varchar 100 √ null
DiagnosisDate datetime 16,3 √ null
PatientInformedDate datetime 16,3 √ null
GPInformedDate datetime 16,3 √ null
GPInformedNextWorkingDay varchar 5 √ null
ReasonNotInformed varchar 255 √ null
Comments varchar 500 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expGP_REF_TEMP Primary key Asc GP_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors