tblMAIN_PATHOLOGY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATHOLOGY_ID int identity 4 √ null
lnkPathologySynchronousTumour.PathologyID FK_lnkPathologySynchronousTumour_tblMAIN_PATHOLOGYR
tblPATHOLOGY_BRAIN.PATHOLOGY_ID FK_tblPATHOLOGY_BRAIN_tblMAIN_PATHOLOGYC
tblPATHOLOGY_BREAST.PATHOLOGY_ID FK_tblPATHOLOGY_BREAST_tblMAIN_PATHOLOGYC
tblPATHOLOGY_COLORECTAL.PATHOLOGY_ID FK_tblPATHOLOGY_COLORECTAL_tblMAIN_PATHOLOGYC
tblPATHOLOGY_DERMATOLOGY.PATHOLOGY_ID FK_tblPATHOLOGY_DERMATOLOGY_tblMAIN_PATHOLOGYC
tblPATHOLOGY_GYNAECOLOGY.PATHOLOGY_ID FK_tblPATHOLOGY_GYNAECOLOGY_tblMAIN_PATHOLOGYC
tblPATHOLOGY_HAEMATOLOGY.PATHOLOGY_ID FK_tblPATHOLOGY_HAEMATOLOGY_tblMAIN_PATHOLOGYC
tblPATHOLOGY_HEAD_NECK.PATHOLOGY_ID FK_tblPATHOLOGY_HEAD_NECK_tblMAIN_PATHOLOGYC
tblPATHOLOGY_LUNG.PATHOLOGY_ID FK_tblPATHOLOGY_LUNG_tblMAIN_PATHOLOGYC
tblPATHOLOGY_PAEDIATRIC.PATHOLOGY_ID FK_tblPATHOLOGY_PAEDIATRIC_tblMAIN_PATHOLOGYC
tblPATHOLOGY_SARCOMA.PATHOLOGY_ID FK_tblPATHOLOGY_SARCOMA_tblMAIN_PATHOLOGYC
tblPATHOLOGY_UPPER_GI.PATHOLOGY_ID FK_tblPATHOLOGY_UPPER_GI_tblMAIN_PATHOLOGYC
tblPATHOLOGY_UROLOGY.PATHOLOGY_ID FK_tblPATHOLOGY_UROLOGY_tblMAIN_PATHOLOGYC
CARE_ID int 4 null
tblMAIN_REFERRALS.CARE_ID FK_tblMAIN_PATHOLOGY_tblMAIN_REFERRALSC

Referral Record ID
TEMP_ID varchar 255 √ null
ltblTEMP_NHS_NUMBERS.TEMP_ID Implied ConstraintR
N8_1_PATHOLOGY_TYPE varchar 2 √ null
N8_2_RECEIPT_DATE smalldatetime 16 √ null
N8_3_RESULT_DATE smalldatetime 16 √ null
N8_4_PATHOLOGIST varchar 8 √ null
N8_5_ORG_CODE varchar 5 √ null
L_NEOADJUVANT_THERAPY varchar 1 √ null
N8_6_DIAGNOSIS varchar 5 √ null
N8_7_TUMOUR_LATERALITY varchar 1 √ null
N8_8_INVASIVE_LESION real 4 √ null
N8_9_SYNC_TUMOUR varchar 1 √ null
L_HISTOLOGY_GROUP int 4 √ null
N8_10_HISTOLOGY varchar 10 √ null
N8_11_GRADE_DIFF varchar 2 √ null
N8_12_CANCER_INVASION varchar 2 √ null
N8_13_EXCISION_MARGINS varchar 2 √ null
N8_14_NODES int 4 √ null
N8_15_POSITIVE_NODES int 4 √ null
N8_16_PATH_T_STAGE varchar 5 √ null
N8_17_PATH_N_STAGE varchar 5 √ null
N8_18_PATH_M_STAGE varchar 5 √ null
N8_20_REPORT_NUMBER varchar 50 √ null
N8_21_REPORT_STATUS int 4 √ null
N8_22_SPECIMEN_NATURE int 4 √ null
N8_23_REQUEST_ORG varchar 5 √ null
N8_24_REQUEST_BY varchar 8 √ null
L_PATH_T_LETTER varchar 3 √ null
L_PATH_N_LETTER varchar 6 √ null
L_PATH_M_LETTER varchar 3 √ null
L_ADEQUACY_MARGINS int 4 √ null
L_COMMENTS text 2147483647 √ null
SAMPLE_DATE smalldatetime 16 √ null
L_PATHOLOGY_TEXT varchar 2147483647 √ null

Pathology Report Text
L_PATHOLOGY_TOPOGRAPHY varchar 18 √ null
L_TNM_STAGE_GROUPING varchar 20 √ null
GERM_CELL_NON_CNS_ID int 4 √ null

TNM Stage Grouping for Non-CNS Germ Cell Tumours
INPC_ID int 4 √ null
CRCN_ID int 4 √ null
ROOT_SAMPLE_DATE_COMMENTS text 2147483647 √ null
ROOT_RECEIPT_DATE_COMMENTS text 2147483647 √ null
ROOT_RESULT_DATE_COMMENTS text 2147483647 √ null
ACTION_ID int 4 √ null
PATH_TNM_UNKNOWN bit 1 √ ((0))
SNOMedCT int 4 √ null
SNOMEDDiagnosisID int 4 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_tblMAIN_PATHOLOGY Primary key Asc PATHOLOGY_ID
IX_tblMAIN_PATHOLOGY Performance Asc CARE_ID

Relationships

Close relationships within degrees of separation