Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CARE_ID | int | 4 | null |
|
|
Referral Record ID |
||||||
| N_U1_PSA | varchar | 50 | √ | null |
|
|
||||||
| N_U2_PRE_S_STAGE | varchar | 50 | √ | null |
|
|
||||||
| R_OTHER_SOURCE | int | 4 | √ | null |
|
|
||||||
| R_BIOPSY_SCORE_1 | int | 4 | √ | null |
|
|
||||||
| R_BIOPSY_SCORE_2 | int | 4 | √ | null |
|
|
||||||
| R_GLEASON_SCORE_1 | int | 4 | √ | null |
|
|
||||||
| R_GLEASON_SCORE_2 | int | 4 | √ | null |
|
|
||||||
| R_DELAY_DIAGNOSIS | varchar | 50 | √ | null |
|
|
||||||
| R_OTHER_DELAY | varchar | 255 | √ | null |
|
|
||||||
| R_N_SIZE | real | 4 | √ | null |
|
|
||||||
| L_METHOD_DIAG | varchar | 50 | √ | null |
|
|
||||||
| L_PROSTATE_VOL | varchar | 50 | √ | null |
|
|
||||||
| R_BIOPSY_TERT_SCORE | int | 4 | √ | null |
|
|
||||||
| R_GLEASON_TERT_SCORE | int | 4 | √ | null |
|
|
||||||
| R_STAGING_INVESTIGATIONS_NONE | bit | 1 | ((0)) |
|
|
|||||||
| R_STAGING_INVESTIGATIONS_MRI | bit | 1 | ((0)) |
|
|
|||||||
| R_STAGING_INVESTIGATIONS_BONESCAN | bit | 1 | ((0)) |
|
|
|||||||
| R_STAGING_INVESTIGATIONS_CT | bit | 1 | ((0)) |
|
|
|||||||
| RMH_STAGE | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_METS | varchar | 50 | √ | null |
|
|
||||||
| LUNG_METS_SUB_STAGE | int | 4 | √ | null |
|
|
||||||
| WILMS_RENAL_ID | int | 4 | √ | null |
|
|
||||||
| N_U2_PRE_S_STAGE_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_METS_PATH | int | 4 | √ | null |
|
|
||||||
| LUNG_METS_SUB_STAGE_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_LIVER_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_BRAIN_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_MEDIASTINAL_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_NECK_PATH | int | 4 | √ | null |
|
|
||||||
| EXTRA_NODAL_LUNG_PATH | int | 4 | √ | null |
|
|
||||||
| EGFR | int | 4 | √ | null |
|
|
||||||
| HYDRONEPHROSIS | char | 1 | √ | null |
|
|
||||||
| SCATEGORY_AFP | int | 4 | √ | null |
|
|
||||||
| SCATEGORY_HCG | int | 4 | √ | null |
|
|
||||||
| SCATEGORY_LDH | int | 4 | √ | null |
|
|
||||||
| RISK_CLASS_PATH_NEPHRECTOMY_ID | int | 4 | √ | null |
|
|
||||||
| RISK_CLASS_PATH_CHEMOTHERAPY_ID | int | 4 | √ | null |
|
|
||||||
| RISK_CATAGORY | int | 4 | √ | null |
|
|
||||||
| LDHNormal | int | 4 | √ | null |
|
|
||||||
| LabReportDate | smalldatetime | 16 | √ | null |
|
|
||||||
| LabReportOrgID | int | 4 | √ | null |
|
|
||||||
| StageTesticularReportDate | smalldatetime | 16 | √ | null |
|
|
||||||
| StageTesticularReportOrgID | int | 4 | √ | null |
|
|
||||||
| StageRenalReportDate | smalldatetime | 16 | √ | null |
|
|
||||||
| StageRenalReportOrgID | int | 4 | √ | null |
|
|
||||||
| MultiparametricMRI | int | 4 | √ | null |
|
|
||||||
| MRIFusionBiopsy | int | 4 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tblREFERRAL_UROLOGY_1 | Primary key | Asc | CARE_ID |
| IX_tblREFERRAL_UROLOGY | Performance | Asc | CARE_ID |