expLOCAL


Columns

Column Type Size Nulls Auto Default Children Parents Comments
LOCAL_ID int identity 4 √ null
HOSPITAL_NUMBER varchar 10 √ null
NHS_NUMBER varchar 10 √ null
SURNAME varchar 60 √ null
FORENAME varchar 50 √ null
DATE_OF_BIRTH datetime 16,3 √ null
SEX varchar 10 √ null
GP_CODE varchar 8 √ null
GP_PRACTICE_CODE varchar 15 √ null
DATE_OF_DEATH datetime 16,3 √ null
CANCER_SITE varchar 50 √ null
REFERRAL_SOURCE varchar 150 √ null
REFERRING_ORG_CODE varchar 50 √ null
REFERRER_CODE varchar 50 √ null
PRIORITY_TYPE varchar 100 √ null
DATE_DECISION_REFER datetime 16,3 √ null
DATE_RECEIPT_REFERRAL datetime 16,3 √ null
SYMPTOMS varchar 225 √ null
SYMPTOMS2 varchar 225 √ null
SYMPTOMS3 varchar 225 √ null
CONSULTANT varchar 100 √ null
SPECIALTY varchar 225 √ null
DATE_FIRST_SEEN datetime 16,3 √ null
FIRST_SEEN_ORG_CODE varchar 5 √ null
APPOINTMENT_TYPE varchar 50 √ null
NO_APPOINTMENT_REASON varchar 50 √ null
CANCER_STATUS varchar 100 √ null
CANCER_TYPE varchar 100 √ null
FIRST_APPOINTMENT varchar 10 √ null
DATE_CANCELLED_APPOINTMENT datetime 16,3 √ null
FIRST_SEEN_ADJUSTMENT_TIME int 4 √ null
FIRST_SEEN_ADJUSTMENT_REASON varchar 100 √ null
FIRST_SEEN_DELAY_REASON varchar 255 √ null
FIRST_SEEN_DELAY_COMMENTS text 2147483647 √ null
REFERRAL_METHOD varchar 50 √ null
WAITING_TIME int 4 √ null
DATE_REFERRED_SPECIALIST datetime 16,3 √ null
DATE_SEEN_SPECIALIST datetime 16,3 √ null
SEEN_SPECIALIST_ORG_CODE varchar 50 √ null
DATE_DIAGNOSIS datetime 16,3 √ null
DIAGNOSIS_CODE varchar 150 √ null
DIAGNOSIS_ORG_CODE varchar 50 √ null
DATE_PATIENT_INFORMED datetime 16,3 √ null
LATERALITY varchar 50 √ null
BASIS_DIAGNOSIS varchar 50 √ null
GP_INFORMED_24H varchar 50 √ null
DATE_REFERRED_SPECIALIST_NURSE datetime 16,3 √ null
DATE_SEEN_SPECIALIST_NURSE datetime 16,3 √ null
NURSE_PRESENT_DIAGNOSIS varchar 50 √ null
PATH_T_STAGE varchar 5 √ null
PATH_N_STAGE varchar 5 √ null
PATH_M_STAGE varchar 5 √ null
PATH_TNM varchar 50 √ null
ADMISSION_DATE datetime 16,3 √ null
SURGERY_DATE datetime 16,3 √ null
DECISION_DATE datetime 16,3 √ null
START_DATE datetime 16,3 √ null
TREATMENT varchar 50 √ null
ORG_CODE varchar 5 √ null
ADJ_DAYS1 int 4 √ null
ADJ_DAYS2 int 4 √ null
ADJ_CODE3 int 4 √ null
ADJ_CODE4 int 4 √ null
TREATING_CONSULTANT varchar 100 √ null
MDT_DATE datetime 16,3 √ null
ADDRESS_1 varchar 150 √ null
ADDRESS_2 varchar 150 √ null
ADDRESS_3 varchar 150 √ null
ADDRESS_4 varchar 150 √ null
ADDRESS_5 varchar 150 √ null
POSTCODE varchar 10 √ null
TUMOR_STATUS_DESC varchar 100 √ null
SURGICAL_PROCEDURE_1 varchar 255 √ null
SURGICAL_PROCEDURE_2 varchar 255 √ null
SURGICAL_PROCEDURE_3 varchar 255 √ null
SURGICAL_PROCEDURE_4 varchar 255 √ null
DIAGNOSIS_HISTOLOGY_CODE varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_expLOCAL Primary key Asc LOCAL_ID

Diagram producer might be missing

No diagrams were produced please see application output for any errors