BIvwLungPathology


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PATHOLOGY_ID int 4 null
CARE_ID int 4 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
Laterality varchar 50 √ null
Specimen Type varchar 50 √ null
Diagnosis Site (ICD) varchar 203 √ null
Diagnosis Site (SNOMED) nvarchar 566 √ null
Topography (SNOMed) varchar 18 √ null
Max Tumour Diameter (mm) real 4 √ null
Distance from Bronchial/Medial Resection Margin real 4 √ null
Extent of Atelectasis/Obstructive Pneumonitis varchar 50 √ null
Location of Tumour varchar 8000 √ null
Type (SNOMed) varchar 133 √ null
No of Nodes Examined int 4 √ null
No of Positive Nodes int 4 √ null
Grade of Differentiation varchar 105 √ null
Excision Margins varchar 100 √ null
Vascular/Lymphatic Invasion varchar 9 √ null
Synchronous Tumour varchar 9 √ null
Local Invasion varchar 8000 √ null
Lymph Node Spread - Ipsilateral Hilar/Intrapulmonary varchar 10 √ null
Lymph Node Spread - Ipsilateral Medastinal varchar 10 √ null
Lymph Node Spread - Other varchar 10 √ null
Margins/Bronchial varchar 10 √ null
Margins/Mediastinal varchar 10 √ null
Margins/Vascular varchar 10 √ null
Margins/Chest Wall varchar 10 √ null
Complete Resection at all Margins varchar 3 √ null
Staging varchar 41 √ null
Excision Margins – R Classification varchar 55 √ null
Other Pathology varchar 50 √ null
TNM Stage Grouping (Pathological) varchar 20 √ null
Comments text 2147483647 √ null

View Definition

Possibly Referenced Tables/Views