rptNBOCAP_TREATMENT_TEMP


Columns

Column Type Size Nulls Auto Default Children Parents Comments
NBOCAP_ID int identity 4 √ null
TREATMENT_ID int 4 √ null
CARE_ID int 4 √ null
PATIENT_ID int 4 √ null
RecordType int 4 null
NHSNumber varchar 10 null
CareSpellNumber varchar 22 null
TreatmentID varchar 38 √ null
OriginatingOrgCode varchar 10 null
SurgeryOrgCode varchar 5 √ null
DateFirstDefTreatment datetime 16,3 √ null
SurgeryNotPerformed varchar 3 √ null
ReasonNoSurgery varchar 2 √ null
ASAGrade varchar 3 √ null
Thromboembolism varchar 1 √ null
Antibiotic varchar 1 √ null
NurseSeen varchar 1 √ null
DateNurseSeen datetime 16,3 √ null
TreatmentIntent varchar 1 √ null
DateSurgery datetime 16,3 √ null
TheatreStartTime varchar 4 √ null
SurgicalUrgency varchar 2 √ null
PrimaryProcedure varchar 5 √ null
ComplicationsCancer int 4 √ null
SurgeonCode varchar 8 √ null
GradeSurgeon int 4 √ null
GradeAnaesthetist int 4 √ null
Anastomosis varchar 1 √ null
Stoma int 4 √ null
DateStomaClosed datetime 16,3 √ null
SurgicalAccess int 4 √ null
TypeBowelDivision int 4 √ null
TypeAnastomosis int 4 √ null
DateDischarge datetime 16,3 √ null
ComplicationsPostOp varchar 5 √ null
ComplicationsLaparoscopic int 4 √ null
ComplicationsPortSite varchar 2 √ null
PathologyOrgCode varchar 5 √ null
DateSpecimenReceived datetime 16,3 √ null
DateResult datetime 16,3 √ null
PathologistCode varchar 8 √ null
ReportStatus int 4 √ null
ReportNumber varchar 20 √ null
SynchronousCancer varchar 1 √ null
InvasiveLesionSize int 4 √ null
ExcisionMarginsCutEnd varchar 2 √ null
DistanceCutEnd int 4 √ null
ExcisionMarginsCircumferential varchar 2 √ null
DistanceCircumferential int 4 √ null
GradeDifferentiation varchar 2 √ null
Histology varchar 7 √ null
NoNodesExamined int 4 √ null
NoNodesPositive int 4 √ null
VascularLymphInvasion varchar 1 √ null
PerforationSerosal varchar 1 √ null
DistanceResection int 4 √ null
DistanceDentate int 4 √ null
TStage varchar 3 √ null
NStage varchar 3 √ null
MStage varchar 2 √ null
DukesStage varchar 2 √ null
TeletherapyOrgCode varchar 5 √ null
TeletherapyConsultantCode varchar 8 √ null
TeletherapyTypeGiven int 4 √ null
DateStartTeletherapy datetime 16,3 √ null
TeletherapyTrial varchar 1 √ null
AntiCancerOrgCode varchar 5 √ null
AntiCancerConsultantCode varchar 8 √ null
DrugTreatmentIntent varchar 2 √ null
DateStartAntiCancer datetime 16,3 √ null
ChemotherapyTrial varchar 1 √ null
Username varchar 50 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_rptNBOCAP_TREATMENT_TEMP Primary key Asc NBOCAP_ID
IX_rptNBOCAP_TREATMENT_TEMP Performance Asc Username

Diagram producer might be missing

No diagrams were produced please see application output for any errors