rptNOGCA_PATIENT_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NOGCA_ID int identity 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
NSTS_Status int 4 √ null
NHSNumber varchar 10 null
SubmittingOrg varchar 10 null
ContactOrg varchar 10 √ null
HospitalNumber varchar 10 √ null
Surname varchar 60 √ null
Forename varchar 50 √ null
Postcode varchar 10 √ null
Sex int 4 √ null
DateBirth datetime 16,3 √ null
Username varchar 50 √ null
Err1 int 4 √ null
Err2 int 4 √ null
Err3 int 4 √ null
Err4 int 4 √ null
Err5 int 4 √ null
Err6 int 4 √ null
Err7 int 4 √ null
Err8 int 4 √ null
Err9 int 4 √ null
Err10 int 4 √ null
Err11 int 4 √ null
Err12 int 4 √ null
Err13 int 4 √ null
Err14 int 4 √ null
Err15 int 4 √ null
Err16 int 4 √ null
Err17 int 4 √ null
Err18 int 4 √ null
Err19 int 4 √ null
Err20 int 4 √ null
Err21 int 4 √ null
Err22 int 4 √ null
Err23 int 4 √ null
Err24 int 4 √ null
Err25 int 4 √ null
Err26 int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_rptNOGCA_PATIENT_TEMP Primary key Asc NOGCA_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors