BIvwTreatmentSurgery


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
Consultant varchar 59 √ null
Urgency of Surgery varchar 50 √ null
Treatment Intent varchar 50 √ null
Adjunctive Therapy varchar 50 √ null
Date of Decision to Operate smalldatetime 16 √ null
Organisation DTT nvarchar 500 √ null
Date of Admission datetime 16,3 √ null
Organisation (Treatment) Site Code varchar 5 √ null
Organisation (Treatment) Name nvarchar 500 √ null
Treatment Event Type varchar 100 √ null
Treatment Setting varchar 50 √ null
Clinical Trial varchar 7 √ null
Date of Surgery datetime 16,3 √ null
Primary Procedure varchar 255 √ null
Sub Procedure 1 varchar 255 √ null
Sub Procedure 2 varchar 255 √ null
Sub Procedure 3 varchar 255 √ null
Operation Not Performed varchar 3 √ null
Reason Operation Not Performed varchar 255 √ null
Surgeon varchar 59 √ null
Grade of Surgeon varchar 50 √ null
Assistant varchar 59 √ null
Grade of Assistant varchar 50 √ null
Name of Anaesthetist varchar 50 √ null
Grade of Anaesthetist varchar 50 √ null
ASA Grade varchar 100 √ null
Start Time varchar 30 √ null
End Time (Wound Closure) varchar 30 √ null
Procedure Comments text 2147483647 √ null
Indication for Surgery text 2147483647 √ null
Incision varchar 255 √ null
Findings text 2147483647 √ null
Specimens text 2147483647 √ null
Drains text 2147483647 √ null
Closure varchar 255 √ null
Post-Op Instructions text 2147483647 √ null
Complications varchar 255 √ null
Complication 1 varchar 100 √ null
Complication 2 varchar 100 √ null
Complication 3 varchar 100 √ null
Complication Details varchar 255 √ null
Transferred To varchar 20 √ null
No of Days int 4 √ null
Transfer Comments text 2147483647 √ null
Patient Return to ITU varchar 50 √ null
No of Days back in ITU int 4 √ null
Date of Discharge smalldatetime 16 √ null
Discharge Destination varchar 150 √ null
Length of Stay int 4 √ null
Stem Cell Infusion Source ID1 varchar 50 √ null
Stem Cell Infusion Source ID2 varchar 50 √ null
Stem Cell Infusion Source ID3 varchar 50 √ null
Stem Cell Infusion Donor ID1 varchar 50 √ null
Stem Cell Infusion Donor ID2 varchar 50 √ null
Stem Cell Infusion Donor ID3 varchar 50 √ null
Postoperative Complications (1) varchar 50 √ null
Postoperative Complications (2) varchar 50 √ null
Postoperative Complications (3) varchar 50 √ null
Surgical Procedure 1 varchar 255 √ null
Surgical Procedure 2 varchar 255 √ null
Surgical Procedure 3 varchar 255 √ null
Surgical Procedure 4 varchar 255 √ null

View Definition

Possibly Referenced Tables/Views