Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| S | char | 1 | null |
|
|
|||
| SPECVERSION | varchar | 5 | null |
|
|
|||
| SUBMITCODE | varchar | 5 | null |
|
|
|||
| DEMOGID | int | 4 | null |
|
|
|||
| IMPORTLINKID | int | 4 | null |
|
|
|||
| PARENTDBID | int | 4 | null |
|
|
|||
| RECORDOWNER | int | 4 | √ | null |
|
|
||
| WHEREWASTHESURGERYPERFORMED | nchar | 10 | √ | null |
|
|
||
| CONSULTANTWITHOVERALLRESPONSIBILITYFORTHEPROCEDURE | nchar | 16 | √ | null |
|
|
||
| MAINSPECIALTYOFCONSULTANT | int | 4 | √ | null |
|
|
||
| PLANNEDPROCEDUREDATE | date | 20 | √ | null |
|
|
||
| DATEOFADMISSION | date | 20 | √ | null |
|
|
||
| DATEOFOPERATION | date | 20 | √ | null |
|
|
||
| OPERATIONTYPE | char | 1 | √ | null |
|
|
||
| VARIANCEBETWEENPLANNEDANDACTUALPROCEDUREDATE | int | 4 | √ | null |
|
|
||
| REASONFORDISCREPANCYBETWEENPLANNEDDATEANDPROCEDURE | int | 4 | √ | null |
|
|
||
| CANCERTREATMENTTYPESURGERY | nvarchar | 62 | √ | null |
|
|
||
| CANCERTREATMENTEVENTTYPE | int | 4 | √ | null |
|
|
||
| CANCERTREATMENTINTENTSURGERY | int | 4 | √ | null |
|
|
||
| CANCERTREATMENTMODALITY | nvarchar | 38 | √ | null |
|
|
||
| COMPLICATIONSOFSURGERYDURINGHOSPITALSTAY | nvarchar | 176 | √ | null |
|
|
||
| DIDANYOFTHESECOMPLICATIONSNEEDFURTHERSURGICALTREAT | int | 4 | √ | null |
|
|
||
| Username | nvarchar | 100 | √ | null |
|
|
||
| ERR_MissingSurgeryDate | bit | 1 | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors