vwBAUS_NEPHRECTOMY_PATHOLOGY


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATHOLOGY_ID int 4 null
CARE_ID int 4 null
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 3 √ 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 8000 √ null
L_PATHOLOGY_TOPOGRAPHY varchar 18 √ null
L_TNM_STAGE_GROUPING varchar 20 √ null
GERM_CELL_NON_CNS_ID int 4 √ null
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
R_NECROSIS varchar 3 √ null
R_VENOUS varchar 50 √ null
R_ADRENAL varchar 3 √ null
R_SEMINAL varchar 3 √ null
R_WEIGHT real 4 √ null
R_SIZE_W real 4 √ null
R_SIZE_D real 4 √ null
R_SIZE_H real 4 √ null
R_TESTIS_W real 4 √ null
R_TESTIS_D real 4 √ null
R_TESTIS_H real 4 √ null
R_TUMOUR_W real 4 √ null
R_TUMOUR_D real 4 √ null
R_TUMOUR_H real 4 √ null
R_POS_APEX varchar 3 √ null
R_POS_BLADDER varchar 3 √ null
R_POS_POST varchar 3 √ null
R_POS_ANT varchar 3 √ null
R_POS_OTHER varchar 3 √ null
R_POS_RADIAL varchar 3 √ null
R_POS_SITE varchar 255 √ null
R_GROWTH int 4 √ null
R_HISTOLOGY int 4 √ null
R_OTHER_HISTOLOGY varchar 255 √ null
R_TUMOUR varchar 50 √ null
R_NUCLEAR varchar 255 √ null
R_NO_TUMOURS int 4 √ null
R_CIS varchar 3 √ null
R_NO_CORES varchar 50 √ null
R_SPECIMEN_TYPE int 4 √ null
R_ABOVE_DIAPHRAM varchar 15 √ null
R_BELOW_DIAPHRAM varchar 15 √ null
R_ORGANS varchar 3 √ null
R_NODAL varchar 3 √ null
R_NODE_SITE varchar 255 √ null
R_ECS varchar 3 √ null
R_BX_SITE varchar 255 √ null
R_LOCATION_PENILE int 4 √ null
R_LOCATION_RENAL int 4 √ null
R_TESTIS_FEATURE int 4 √ null
R_TESTIS_INVASION int 4 √ null
R_BLOCKS int 4 √ null
R_R1 varchar 3 √ null
R_R2 varchar 3 √ null
R_R3 varchar 3 √ null
R_L1 varchar 3 √ null
R_L2 varchar 3 √ null
R_L3 varchar 3 √ null
R_CIRCUMFERENTIAL varchar 3 √ null
R_APICAL varchar 3 √ null
R_BASE varchar 3 √ null
R_GLEASON_SCORE_1 int 4 √ null
R_GLEASON_SCORE_2 int 4 √ null
R_SCARRING varchar 3 √ null
R_TESTIS varchar 3 √ null
R_ITGCN varchar 3 √ null
R_PELVIC_NODE_L int 4 √ null
R_PELVIC_NODE_R int 4 √ null
R_PELVIC_TUMOUR_L int 4 √ null
R_PELVIC_TUMOUR_R int 4 √ null
R_OBTURATOR_NODE_L int 4 √ null
R_OBTURATOR_NODE_R int 4 √ null
R_OBTURATOR_TUMOUR_L int 4 √ null
R_OBTURATOR_TUMOUR_R int 4 √ null
R_SENTINEL_NODE_L int 4 √ null
R_SENTINEL_NODE_R int 4 √ null
R_SENTINEL_TUMOUR_L int 4 √ null
R_SENTINEL_TUMOUR_R int 4 √ null
R_SUPERFICIAL_NODE_L int 4 √ null
R_SUPERFICIAL_NODE_R int 4 √ null
R_SUPERFICIAL_TUMOUR_L int 4 √ null
R_SUPERFICIAL_TUMOUR_R int 4 √ null
R_DEEP_NODE_L int 4 √ null
R_DEEP_NODE_R int 4 √ null
R_DEEP_TUMOUR_L int 4 √ null
R_DEEP_TUMOUR_R int 4 √ null
R_OTHER_NODE_L int 4 √ null
R_OTHER_NODE_R int 4 √ null
R_OTHER_TUMOUR_L int 4 √ null
R_OTHER_TUMOUR_R int 4 √ null
R_SIZE_TUMOUR_RCC real 4 √ null
R_TUMOUR_GRADE char 2 √ null
RMH_ID int 4 √ null
WILMS_RENAL_ID int 4 √ null
S_CATEGORY_ID int 4 √ null
EXTRA_NODAL_METS_ID int 4 √ null
SUB_STAGE_ID int 4 √ null
EXTRA_NODAL_LIVER int 4 √ null
EXTRA_NODAL_BRAIN int 4 √ null
EXTRA_NODAL_MEDIASTINAL int 4 √ null
EXTRA_NODAL_NECK int 4 √ null
EXTRA_NODAL_LUNG int 4 √ null
PROST_CORES_POSITIVE int 4 √ null
PROST_PERINEURAL_INV varchar 1 √ null
PROST_GREATEST_PERC_CANCER int 4 √ null
PROST_ORGAN_CONFINED varchar 1 √ null
PROST_EXCISION_MARGINS int 4 √ null
MARGIN_SITE int 4 √ null
BIOPSY_RESULT int 4 √ null
POST_OP_HIST_DIAGNOSIS int 4 √ null
MULTI_TUMOUR_COMMENTS varchar 2147483647 √ null

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views