vwSUMMARY_PATHOLOGY_PREV


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATIENT_ID int 4 null
CARE_ID int 4 null
L_CANCER_SITE varchar 50 null
L_NEW_CA_SITE varchar 20 null
N8_2_RECEIPT_DATE smalldatetime 16 null
N8_3_RESULT_DATE smalldatetime 16 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
L_PATH_T_LETTER char 1 null
L_PATH_N_LETTER char 1 null
L_PATH_M_LETTER char 1 null
M_DESC varchar 255 null
GRADE_DESC varchar 100 null
L_DUKES varchar 50 null
TYPE_DESC varchar 50 null
L_COMMENTS text 2147483647 null

View Definition