Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| PATHOLOGY_ID | int | 4 | null |
|
|
|||
| CARE_ID | int | 4 | null |
|
|
|||
| N8_3_RESULT_DATE | smalldatetime | 16 | √ | null |
|
|
||
| N8_2_RECEIPT_DATE | smalldatetime | 16 | √ | null |
|
|
||
| SAMPLE_DATE | smalldatetime | 16 | √ | null |
|
|
||
| N8_20_REPORT_NUMBER | varchar | 50 | √ | null |
|
|
||
| L_NEOADJUVANT_THERAPY | varchar | 1 | √ | null |
|
|
||
| ReportStatus | varchar | 50 | √ | null |
|
|
||
| PathologyType | varchar | 50 | √ | null |
|
|
||
| SpecimenCode | varchar | 50 | √ | null |
|
|
||
| N8_24_REQUEST_BY | varchar | 8 | √ | null |
|
|
||
| N8_23_REQUEST_ORG | varchar | 5 | √ | null |
|
|
||
| N8_4_PATHOLOGIST | varchar | 8 | √ | null |
|
|
||
| N8_5_ORG_CODE | varchar | 5 | √ | null |
|
|
||
| N8_8_INVASIVE_LESION | real | 4 | √ | null |
|
|
||
| L_COMMENTS | text | 2147483647 | √ | null |
|
|
||
| SNOMedCT | int | 4 | √ | null |
|
|
||
| L_PATHOLOGY_TOPOGRAPHY | varchar | 18 | √ | null |
|
|
||
| N8_14_NODES | int | 4 | √ | null |
|
|
||
| N8_15_POSITIVE_NODES | int | 4 | √ | null |
|
|
||
| N8_12_CANCER_INVASION | varchar | 2 | √ | null |
|
|
||
| N8_9_SYNC_TUMOUR | varchar | 1 | √ | null |
|
|
||
| L_PATHOLOGY_TEXT | varchar | 2147483647 | √ | null |
|
|
||
| L_TNM_STAGE_GROUPING | varchar | 20 | √ | null |
|
|
||
| TumourLaterality | varchar | 50 | √ | null |
|
|
||
| L_ADEQUACY_MARGINS | int | 4 | √ | null |
|
|
||
| CRCN | varchar | 50 | √ | null |
|
|
||
| INPC | varchar | 50 | √ | null |
|
|
||
| N8_6_DIAGNOSIS | varchar | 5 | √ | null |
|
|
||
| ExcisionMargins | varchar | 100 | √ | null |
|
|
||
| Diagnosis | varchar | 203 | √ | null |
|
|
||
| TNMNonCNSGermCell | varchar | 5 | √ | null |
|
|
||
| GradeDifferentation | varchar | 105 | √ | null |
|
|
||
| VascLymphInvasion | varchar | 100 | √ | null |
|
|
||
| SnomedDiagnosis | nvarchar | 546 | √ | null |
|
|