DisSurgeryImport


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ProcID int identity 4 √ null
ProcedureID varchar 50 null
ProcedureDate datetime 16,3 (getdate())
OrganisationDTT varchar 5 √ null
OrganisationTreat varchar 5 √ null
PatientSurname varchar 60 √ null
PatientDOB datetime 16,3 √ null
PatientHospitalID varchar 20 √ null
NhsNumber varchar 10 √ null
AdmissionDate datetime 16,3 √ (getdate()-(1))
SurgeryType varchar 20 √ null
SurgeonName varchar 50 √ null
SurgeonCode varchar 12 √ null
ConsultantCode varchar 12 √ null
DischargeDate datetime 16,3 √ null
DischargeDestination int 4 √ null
ProcedureType varchar 12 √ null
OperativePriority varchar 12 √ null
AsaGrade varchar 1 √ null
OpNoteIndication varchar 255 √ null
OpNoteIncision varchar 255 √ null
OpNoteFinding varchar 4000 √ null
OpNoteCodedProcedure varchar 4000 √ null
OpNoteClosure varchar 255 √ null
OpNotePostOp varchar 4000 √ null
OpNoteProcedureText varchar 4000 √ null
OpNoteFollowUp varchar 4000 √ null
Proc1Desc varchar 100 √ null
Proc1Lat varchar 1 √ null
Proc1OPCS1 varchar 5 √ null
Proc1OPCS2 varchar 5 √ null
Proc1OPCS3 varchar 5 √ null
Proc2Desc varchar 100 √ null
Proc2Lat varchar 1 √ null
Proc2OPCS1 varchar 5 √ null
Proc2OPCS2 varchar 5 √ null
Proc2OPCS3 varchar 5 √ null
Proc3Desc varchar 100 √ null
Proc3Lat varchar 1 √ null
Proc3OPCS1 varchar 5 √ null
Proc3OPCS2 varchar 5 √ null
Proc3OPCS3 varchar 5 √ null
OperationStartTime datetime 16,3 √ null
OperationFinishTime datetime 16,3 √ null
UnitsTransfused int 4 √ null
BloodLoss int 4 √ null
DateToBeDelete datetime 16,3 √ null
LinkedCareID varchar 100 √ null
ReceivedOn datetime2 46 (getdate())

Indexes

Constraint Name Type Sort Column(s)
PK_DisSurgeryImport Primary key Asc ProcID

Diagram producer might be missing

No diagrams were produced please see application output for any errors