Schema Comparison: V1 vs V2

Side-by-side view of table availability, column changes, and known field renames

8
V1 Tables
11
V2 Tables
6
Shared Tables
4
Known Renames
Known Column Renames (V1 → V2)
TableV1 ColumnV2 Column
av_patient SEX GENDER
av_patient NEWVITALSTATUS VITALSTATUS
sact_regimen MERGED_PATIENT_ID ENCORE_PATIENT_ID
av_tumour QUINTILE_2015 QUINTILE_2019
av_gene V2 onlynew
Columns (29): GENEID TUMOURID PATIENTID GENE_DESC GENE COUNT_TESTS COUNT_RESULTS COUNT_DATE ALL_TESTSTATUSES OVERALL_TS NO_OF_AB_GATS DNASEQ_GAT METHYL_GAT EXP_GAT COPYNO_GAT FUS_TRANS_GAT ABNORMAL_GAT NO_OF_SEQ_VARS ALL_SEQ_VARS SEQ_VAR DATE_OVERALL_TS BEST_DATE_SOURCE_OVERALL_TS MIN_DATE MAX_DATE ALL_PRO_IMPS NO_OF_PRO_IMPS PRO_IMP METHODS LAB_NAME
255,731 rows
av_patient V1V2
V1: 2,200,625 rows, 12 columns
V2: 1,871,604 rows, 12 columns
Shared columns (10): DEATHCAUSECODE_1A DEATHCAUSECODE_1B DEATHCAUSECODE_1C DEATHCAUSECODE_2 DEATHCAUSECODE_UNDERLYING DEATHLOCATIONCODE ETHNICITY LINKNUMBER PATIENTID VITALSTATUSDATE
V1 only (2): NEWVITALSTATUS SEX
V2 only (2): GENDER VITALSTATUS
av_tumour V1V2
V1: 2,371,280 rows, 34 columns
V2: 1,995,569 rows, 37 columns
Shared columns (27): AGE BEHAVIOUR_ICD10_O2 CANCERCAREPLANINTENT CREG_CODE DATE_FIRST_SURGERY DIAGNOSISDATEBEST ER_STATUS GLEASON_COMBINED GLEASON_PRIMARY GLEASON_SECONDARY GLEASON_TERTIARY GRADE HER2_STATUS LATERALITY MORPH_ICD10_O2 M_BEST N_BEST PATIENTID PERFORMANCESTATUS PR_STATUS SCREENINGSTATUSFULL_CODE SITE_ICD10_O2 SITE_ICD10_O2_3CHAR STAGE_BEST STAGE_BEST_SYSTEM TUMOURID T_BEST
V1 only (7): ACE27 CNS ER_SCORE LINKNUMBER PR_SCORE QUINTILE_2015 SEX
V2 only (10): BEHAVIOUR_ICDO3REV2011 CHRL_TOT_27_03 COMORBIDITIES_27_03 GENDER MORPH_ICDO3REV2011 QUINTILE_2019 SITE_ICD10R4_O2_3CHAR_FROM2013 SITE_ICD10R4_O2_FROM2013 SITE_ICDO3REV2011 SITE_ICDO3REV2011_3CHAR
rtds_combined V2 onlynew
Columns (21): PATIENTID PRESCRIPTIONID RTTREATMENTMODALITY RADIOTHERAPYPRIORITY RADIOTHERAPYINTENT RTPRESCRIBEDDOSE RTPRESCRIBEDFRACTIONS RTACTUALDOSE RTACTUALFRACTIONS RTTREATMENTREGION RTTREATMENTANATOMICALSITE DECISIONTOTREATDATE EARLIESTCLINAPPROPDATE RADIOTHERAPYEPISODEID LINKCODE RADIOISOTOPE RADIOTHERAPYBEAMTYPE RADIOTHERAPYBEAMENERGY TIMEOFEXPOSURE APPTDATE ATTENDID
13,201,530 rows
rtds_episode V2 onlynew
Columns (9): PATIENTID RADIOTHERAPYEPISODEID ATTENDID APPTDATE LINKCODE DECISIONTOTREATDATE EARLIESTCLINAPPROPDATE RADIOTHERAPYPRIORITY RADIOTHERAPYINTENT
5,843,641 rows
rtds_exposure V2 onlynew
Columns (10): PRESCRIPTIONID RADIOISOTOPE RADIOTHERAPYBEAMTYPE RADIOTHERAPYBEAMENERGY TIMEOFEXPOSURE APPTDATE ATTENDID PATIENTID RADIOTHERAPYEPISODEID LINKCODE
13,201,530 rows
rtds_prescription V2 onlynew
Columns (13): PATIENTID PRESCRIPTIONID RTTREATMENTMODALITY RTPRESCRIBEDDOSE RTPRESCRIBEDFRACTIONS RTACTUALDOSE RTACTUALFRACTIONS RTTREATMENTREGION RTTREATMENTANATOMICALSITE RADIOTHERAPYEPISODEID LINKCODE ATTENDID APPTDATE
5,843,641 rows
sact_cycle V1V2
V1: 2,442,036 rows, 8 columns
V2: 2,741,673 rows, 6 columns
Shared columns (6): CYCLE_NUMBER MERGED_CYCLE_ID MERGED_REGIMEN_ID OPCS_PROCUREMENT_CODE PERF_STATUS_START_OF_CYCLE START_DATE_OF_CYCLE
V1 only (2): MERGED_PATIENT_ID MERGED_TUMOUR_ID
sact_drug_detail V1V2
V1: 6,385,827 rows, 11 columns
V2: 7,662,029 rows, 7 columns
Shared columns (7): ACTUAL_DOSE_PER_ADMINISTRATION ADMINISTRATION_DATE ADMINISTRATION_ROUTE DRUG_GROUP MERGED_CYCLE_ID MERGED_DRUG_DETAIL_ID OPCS_DELIVERY_CODE
V1 only (4): MERGED_PATIENT_ID MERGED_REGIMEN_ID MERGED_TUMOUR_ID ORG_CODE_OF_DRUG_PROVIDER
sact_outcome V1V2
V1: 601,833 rows, 9 columns
V2: 784,134 rows, 6 columns
Shared columns (6): DATE_OF_FINAL_TREATMENT MERGED_REGIMEN_ID REGIMEN_MOD_DOSE_REDUCTION REGIMEN_MOD_STOPPED_EARLY REGIMEN_MOD_TIME_DELAY REGIMEN_OUTCOME_SUMMARY
V1 only (3): MERGED_OUTCOME_ID MERGED_PATIENT_ID MERGED_TUMOUR_ID
sact_patient V1 onlyremoved in V2
Columns (2): MERGED_PATIENT_ID LINK_NUMBER
366,265 rows
sact_regimen V1V2
V1: 730,471 rows, 12 columns
V2: 781,388 rows, 12 columns
Shared columns (10): BENCHMARK_GROUP CHEMO_RADIATION CLINICAL_TRIAL DATE_DECISION_TO_TREAT HEIGHT_AT_START_OF_REGIMEN INTENT_OF_TREATMENT MAPPED_REGIMEN MERGED_REGIMEN_ID START_DATE_OF_REGIMEN WEIGHT_AT_START_OF_REGIMEN
V1 only (2): MERGED_PATIENT_ID MERGED_TUMOUR_ID
V2 only (2): ENCORE_PATIENT_ID LINK_NUMBER
sact_tumour V1 onlyremoved in V2
Columns (5): MERGED_TUMOUR_ID MERGED_PATIENT_ID CONSULTANT_SPECIALITY_CODE PRIMARY_DIAGNOSIS MORPHOLOGY_CLEAN
450,071 rows