Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
S | char | 1 | null |
|
|
|||
SPECVERSION | varchar | 5 | √ | null |
|
|
||
SUBMITCODE | varchar | 5 | √ | null |
|
|
||
IMPORTLINKID | int | 4 | null |
|
|
|||
INVESTIGATIONTYPE | char | 1 | √ | null |
|
|
||
DATEOFCLINICALLYAGREEDDIAGNOSIS | datetime | 16,3 | √ | null |
|
|
||
WHOORDEREDBIOPSY | varchar | 8 | √ | null |
|
|
||
WHEREWASTHEBIOSYTAKENRESECTIONDONE | varchar | 5 | √ | null |
|
|
||
BIOPSYSAMPLECOLLECTIONDATE | datetime | 16,3 | √ | null |
|
|
||
DATESAMPLERECEIVEDINPATH | datetime | 16,3 | √ | null |
|
|
||
WHEREISTHEPATHOLOGISTBASED | varchar | 5 | √ | null |
|
|
||
PATHOLOGIST | varchar | 8 | √ | null |
|
|
||
SPECIMENNATUREBIOPSY | varchar | 25 | √ | null |
|
|
||
PATHOLOGYINVESTIGATIONTYPEBIOPSY | varchar | 2 | √ | null |
|
|
||
HASHPVSTATUSTESTINGBEENDONE | varchar | 25 | √ | null |
|
|
||
HPVTEST | char | 1 | √ | null |
|
|
||
TUMOURSITE | varchar | 5 | √ | null |
|
|
||
DATEOFPATHOLOGYREPORT | datetime | 16,3 | √ | null |
|
|
||
TUMOURLATERALITY | char | 1 | √ | null |
|
|
||
MORPHOLOGYSNOMEDFROMBIOPSY | varchar | 10 | √ | null |
|
|
||
METASTASISFOUNDONIMAGING | char | 1 | √ | null |
|
|
||
METASTASISCONFIRMEDHISTOLOGICALLY | char | 1 | √ | null |
|
|
||
SERVICEREPORTIDENTIFIER | varchar | 50 | √ | null |
|
|
||
SAMPLECOLLECTIONDATEDEFINITIVE | datetime | 16,3 | √ | null |
|
|
||
DATEDEFINITIVESAMPLERECEIVEDINPATH | datetime | 16,3 | √ | null |
|
|
||
ERR_DATEOFCLINICALLYAGREEDDIAGNOSIS | bit | 1 | null |
|
|
|||
Username | varchar | 50 | null |
|
|
Diagram producer might be missing
No diagrams were produced please see application output for any errors