vwNBOCAP_PROFORMA_PATH


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PathologyID int 4 null
CareID int 4 null
Organisation nvarchar 500 null
ReceiptDate varchar 10 null
ResultDate varchar 10 null
Consultant varchar 61 null
ReportStatus varchar 50 null
ReportNumber varchar 50 null
SynchronousTumour varchar 7 null
InvasiveLesion varchar 13 null
GradeOfDifferentiation varchar 105 null
Histology varchar 308 null
NoOfNodes varchar 10 null
NoOfPosNodes varchar 10 null
CancerInvasion varchar 9 null
TStage varchar 5 null
TLetter varchar 3 null
NStage varchar 5 null
NLetter varchar 6 null
MStage varchar 5 null
MLetter varchar 3 null
CutMargins varchar 10 null
Margins varchar 15 null
MarginsCircumf varchar 10 null
MarginDistance varchar 15 null
Perforations varchar 10 null
DentDistance varchar 15 null
ResectionDistance varchar 15 null
Dukes varchar 50 null

View Definition