vwSWCIS_SURGERY_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NHSNumber varchar 10 √ null
OrgCodeSubmitting varchar 5 √ null
CareSpellID varchar 50 √ null
SiteCode varchar 5 √ null
Consultant varchar 8 √ null
Specialty int 4 √ null
TreatmentIntent varchar 1 √ null
DecisionTreatDate datetime 16,3 √ null
AdmissionDate datetime 16,3 √ null
SurgeryDate datetime 16,3 √ null
PrimaryProcedure varchar 50 √ null
SubProcedure1 varchar 50 √ null
SubProcedure2 varchar 50 √ null
SubProcedure3 varchar 50 √ null
SubProcedure4 varchar 50 √ null
SubProcedure5 varchar 50 √ null
SubProcedure6 varchar 50 √ null
SubProcedure7 varchar 50 √ null
SubProcedure8 varchar 50 √ null
DischargeDate datetime 16,3 √ null
DischargeDestnation int 4 √ null
ASA int 4 √ null
GradeSurgeon varchar 50 √ null
SpRegYear int 4 √ null
SupervisedOp varchar 3 √ null
IVU varchar 50 √ null
CXR varchar 50 √ null
Incision varchar 50 √ null
LeftLateral int 4 √ null
RightLateral int 4 √ null
CentralAnterior int 4 √ null
CentralPosterior int 4 √ null
IpsilateralNode varchar 50 √ null
ContralateralNode varchar 50 √ null
TumourSize varchar 50 √ null
WoundClosure varchar 50 √ null
ResidualMass varchar 50 √ null
OvarianOpNo int 4 √ null
Ascites int 4 √ null
Washings int 4 √ null
NodesPalpated varchar 50 √ null
Cervix int 4 √ null
Ovaries varchar 1 √ null
Tubes int 4 √ null
Uterus int 4 √ null
Vaginal int 4 √ null
Vulva int 4 √ null
Uretra int 4 √ null
Bladder int 4 √ null
SmallBowel int 4 √ null
Appendix int 4 √ null
AscColon int 4 √ null
TransColon int 4 √ null
DescColon int 4 √ null
Rectum int 4 √ null
Anus int 4 √ null
Omentum int 4 √ null
Peritoneum int 4 √ null
AbdoPeritoneum int 4 √ null
PelvicPeritoneum int 4 √ null
SubDiaphramPeritoneum int 4 √ null
LiverSurface int 4 √ null
LiverParenchyma int 4 √ null
PelvicBone int 4 √ null
OtherOrgan varchar 255 √ null
Username varchar 50 √ null

View Definition

Possibly Referenced Tables/Views