BIvwUrologyPathology


Columns

Column Type Size Nulls Auto Default Children Parents Comments
CARE_ID int 4 null
Cancer Site varchar 50 √ null
NHS Number varchar 10 null
Hospital Number varchar 20 √ null
Full Name varchar 111 √ null
Date of Receipt smalldatetime 16 √ null
Date of Reporting smalldatetime 16 √ null
Report No varchar 50 √ null
Investigation Type varchar 50 √ null
Nature of Specimen varchar 50 √ null
Report Status varchar 50 √ null
Care Professional varchar 59 √ null
Requesting Organisation nvarchar 500 √ null
Reporting Organisation nvarchar 500 √ null
Pathologist varchar 59 √ null
Diagnosis Site (ICD) varchar 203 √ null
Diagnosis Site (SNOMED) nvarchar 566 √ null
Topography (SNOMed) varchar 18 √ null
Tumour Laterality varchar 50 √ null
Max Tumour Diameter (mm) real 4 √ null
Size of Tumour (cm) real 4 √ null
Specimen Type varchar 50 √ null
Weight of TURBT/Prostrate varchar 29 √ null
Site of Biopsy varchar 255 √ null
Size of Prostate varchar 8000 √ null
Size of Testis varchar 8000 √ null
Size of Tumour (mm) varchar 8000 √ null
Features varchar 50 √ null
No of Blocks Taken int 4 √ null
Nodal Dissection varchar 3 √ null
Adjacent Organs Present varchar 3 √ null
Site of Nodes varchar 255 √ null
No of Nodes Examined int 4 √ null
No of Positive Nodes int 4 √ null
Extracapsular Spread varchar 3 √ null
No Nodes Examined (Pelvic) Left int 4 √ null
No of Positive Nodes (Pelvic) Left int 4 √ null
No Nodes Examined (Pelvic) Right int 4 √ null
No of Positive Nodes (Pelvic) Right int 4 √ null
No Nodes Examined (Sentinel) Left int 4 √ null
No of Positive Nodes (Sentinel) Left int 4 √ null
No Nodes Examined (Sentinel) Right int 4 √ null
No of Positive Nodes (Sentinel) Right int 4 √ null
No Nodes Examined (Superficial Inguinal) Left int 4 √ null
No of Positive Nodes (Superficial Inguinal) Left int 4 √ null
No Nodes Examined (Superficial Inguinal) Right int 4 √ null
No of Positive Nodes (Superficial Inguinal) Right int 4 √ null
No Nodes Examined (Deep Inguinal) Left int 4 √ null
No of Positive Nodes (Deep Inguinal) Left int 4 √ null
No Nodes Examined (Deep Inguinal) Right int 4 √ null
No of Positive Nodes (Deep Inguinal) Right int 4 √ null
No Nodes Examined (Obturator) Left int 4 √ null
No of Positive Nodes (Obturator) Left int 4 √ null
No Nodes Examined (Obturator) Right int 4 √ null
No of Positive Nodes (Obturator) Right int 4 √ null
No Nodes Examined (Other) Left int 4 √ null
No of Positive Nodes (Other) Left int 4 √ null
No Nodes Examined (Other) Right int 4 √ null
No of Positive Nodes (Other) Right int 4 √ null
Type (SNOMed) varchar 133 √ null
Grade of Differentiation varchar 105 √ null
Excision Margins varchar 100 √ null
Vascular/Lymphatic Invasion varchar 9 √ null
Synchronous Tumour varchar 9 √ null
No of Tumours int 4 √ null
No of Cores Involved varchar 50 √ null
Needle Biopsy Right 1 varchar 3 √ null
Needle Biopsy Right 2 varchar 3 √ null
Needle Biopsy Right 3 varchar 3 √ null
Needle Biopsy Left 1 varchar 3 √ null
Needle Biopsy Left 2 varchar 3 √ null
Needle Biopsy Left 3 varchar 3 √ null
No of Positive Cores int 4 √ null
Perineural Invasion varchar 14 √ null
Biopsy Result varchar 100 √ null
Associated CIS varchar 3 √ null
Seminal Vesicles Invasion varchar 3 √ null
Greatest % of Cancer (single most involved core) int 4 √ null
Post-operative (Final) Histological Diagnosis varchar 255 √ null
Tumour Type varchar 50 √ null
Presence of Necrosis varchar 3 √ null
Nuclear Grade varchar 255 √ null
Adrenal Invasion varchar 3 √ null
Tumour in Renal Veins varchar 50 √ null
Invasion Below The Diaphragm varchar 15 √ null
Invasion Above The Diaphragm varchar 15 √ null
Tumour Growth Pattern varchar 50 √ null
Grade of Tumour char 2 √ null
Operative Histology varchar 50 √ null
Gleason Score varchar 8000 √ null
Staging varchar 41 √ null
TNM Stage Grouping (Pathological) varchar 20 √ null
RMH Stage Grouping varchar 5 √ null
S Category varchar 5 √ null
Extra Nodal Metastases varchar 8000 √ null
Lung Metastases Sub-Stage Group varchar 5 √ null
Comments text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views