Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| SACTID | int identity | 4 | √ | null |
|
|
||||
| CareID | int | 4 | null |
|
|
|||||
| PatientID | int | 4 | null |
|
|
|||||
| ChemoID | int | 4 | √ | null |
|
|
||||
| NSTS_Status | int | 4 | √ | null |
|
|
||||
| NHS_Number | varchar | 10 | √ | null |
|
|
||||
| Local_Patient_Identifier | varchar | 20 | √ | null |
|
|
||||
| NHS_Number_Status_Indicator_Code | char | 2 | √ | null |
|
|
||||
| Person_Family_Name | varchar | 35 | √ | null |
|
|
||||
| Person_Given_Name | varchar | 35 | √ | null |
|
|
||||
| Date_Of_Birth | char | 10 | √ | null |
|
|
||||
| Person_Stated_Gender_Code | char | 1 | √ | null |
|
|
||||
| Patient_Postcode | varchar | 8 | √ | null |
|
|
||||
| Consultant_GMC_Code | varchar | 8 | √ | null |
|
|
||||
| Consultant_Specialty_Code | varchar | 3 | √ | null |
|
|
||||
| Organisation_Identifier_(Code_Of_Provider) | varchar | 5 | √ | null |
|
|
||||
| Primary_Diagnosis | varchar | 6 | √ | null |
|
|
||||
| Morphology_ICD-O | varchar | 7 | √ | null |
|
|
||||
| Diagnosis_Code_(SNOMED_CT) | varchar | 18 | √ | null |
|
|
||||
| Adjunctive_Therapy | int | 4 | √ | null |
|
|
||||
| Intent_Of_Treatment | varchar | 15 | √ | null |
|
|
||||
| Regimen | varchar | 150 | √ | null |
|
|
||||
| Height_At_Start_Of_Regimen | real | 4 | √ | null |
|
|
||||
| Weight_At_Start_Of_Regimen | real | 4 | √ | null |
|
|
||||
| Performance_Status_At_Start_Of_Regimen_-_Adult | int | 4 | √ | null |
|
|
||||
| Comorbidity_Adjustment | char | 1 | √ | null |
|
|
||||
| Date_Decision_To_Treat | char | 10 | √ | null |
|
|
||||
| Start_Date_Of_Regimen | char | 10 | √ | null |
|
|
||||
| Clinical_Trial | varchar | 2 | √ | null |
|
|
||||
| Cycle_Number | int | 4 | √ | null |
|
|
||||
| Start_Date_Of_Cycle | char | 10 | √ | null |
|
|
||||
| Weight_At_Start_Of_Cycle | real | 4 | √ | null |
|
|
||||
| Performance_Status_At_Start_Of_Cycle_-_Adult | int | 4 | √ | null |
|
|
||||
| Drug_Name | varchar | 55 | √ | null |
|
|
||||
| DM+D | varchar | 18 | √ | null |
|
|
||||
| Actual_Dose_Per_Administration | real | 4 | √ | null |
|
|
||||
| Administration_Measurement_Per_Actual_Dose | varchar | 2 | √ | null |
|
|
||||
| Other_-_ Administration_Measurement_Per_Actual_Dose | varchar | 15 | √ | null |
|
|
||||
| Unit_Of_Measurement_(SNOMED_CT_DM+D) | varchar | 18 | √ | null |
|
|
||||
| SACT_Administration_Route | varchar | 2 | √ | null |
|
|
||||
| Route_Of_Administration_(SNOMED_CT_DM+D) | varchar | 18 | √ | null |
|
|
||||
| Administration_Date | char | 10 | √ | null |
|
|
||||
| Organisation_Identifier_Of_SACT_Administration | varchar | 5 | √ | null |
|
|
||||
| Regimen_Modification_-_Dose_Reduction | char | 1 | √ | null |
|
|
||||
| Regimen_Outcome_Summary_-_Curative_(Completed_As_Planned) | char | 1 | √ | null |
|
|
||||
| Regimen_Outcome_Summary_-_Curative_(Not_Completed_As_Planned)_Reason | char | 1 | √ | null |
|
|
||||
| Other_-_Regimen_Outcome_Summary_-_Curative_(Not_Completed_As_Planned)_Reason | varchar | 55 | √ | null |
|
|
||||
| Regimen_Outcome_Summary_Non_Curative | char | 1 | √ | null |
|
|
||||
| Regimen_Outcome_Summary_Toxicity | char | 1 | √ | null |
|
|
||||
| Username | varchar | 50 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_tmpSACT_AUDIT2 | Primary key | Asc | SACTID |