Skip to content

Class: SACTResearchView

Flat research view combining patient, regimen, cycle, and drug administration data. Corresponds to RVW.SACT_RESEARCH_VIEW in the source database. Each row represents a single drug administration event, with regimen and patient context repeated per row.

URI: sact:SACTResearchView

 classDiagram
    class SACTResearchView
    click SACTResearchView href "../SACTResearchView/"
      SACTResearchView : actual_dose_per_admin

      SACTResearchView : adjunctive_therapy





        SACTResearchView --> "0..1" AdjunctiveTherapyType : adjunctive_therapy
        click AdjunctiveTherapyType href "../AdjunctiveTherapyType/"



      SACTResearchView : admin_meas_per_actual_dose





        SACTResearchView --> "0..1" AdministrationMeasurementCode : admin_meas_per_actual_dose
        click AdministrationMeasurementCode href "../AdministrationMeasurementCode/"



      SACTResearchView : administration_date

      SACTResearchView : clinical_trial





        SACTResearchView --> "0..1" ClinicalTrialIndicator : clinical_trial
        click ClinicalTrialIndicator href "../ClinicalTrialIndicator/"



      SACTResearchView : co_morbidity_adjustment





        SACTResearchView --> "0..1" YesNoIndicator : co_morbidity_adjustment
        click YesNoIndicator href "../YesNoIndicator/"



      SACTResearchView : consultant_gmc_code

      SACTResearchView : consultant_spec_code

      SACTResearchView : cycle_number

      SACTResearchView : dataset_name

      SACTResearchView : date_decision_to_treat

      SACTResearchView : date_of_birth_mid_month

      SACTResearchView : date_of_birth_month

      SACTResearchView : date_of_birth_year

      SACTResearchView : diagnosis_code_snomed

      SACTResearchView : direct_care_published_runid

      SACTResearchView : dm_d

      SACTResearchView : drug_name

      SACTResearchView : etl_date

      SACTResearchView : etl_id

      SACTResearchView : file_name

      SACTResearchView : file_period_end

      SACTResearchView : file_period_start

      SACTResearchView : height_start_reg

      SACTResearchView : intent_of_treatment





        SACTResearchView --> "0..1" IntentOfTreatment : intent_of_treatment
        click IntentOfTreatment href "../IntentOfTreatment/"



      SACTResearchView : llsoa

      SACTResearchView : morphology_icd_o

      SACTResearchView : ndo_run_date

      SACTResearchView : nhs_number_status





        SACTResearchView --> "0..1" NHSNumberStatusCode : nhs_number_status
        click NHSNumberStatusCode href "../NHSNumberStatusCode/"



      SACTResearchView : org_id_code_provider

      SACTResearchView : org_identifier_sact_admin

      SACTResearchView : ot_admin_meas_per_actual_dose

      SACTResearchView : perf_stat_start_cycle_ad





        SACTResearchView --> "0..1" PerformanceStatusAdult : perf_stat_start_cycle_ad
        click PerformanceStatusAdult href "../PerformanceStatusAdult/"



      SACTResearchView : perf_status_start_reg_ad





        SACTResearchView --> "0..1" PerformanceStatusAdult : perf_status_start_reg_ad
        click PerformanceStatusAdult href "../PerformanceStatusAdult/"



      SACTResearchView : person_stated_gender_code





        SACTResearchView --> "0..1" PersonStatedGenderCode : person_stated_gender_code
        click PersonStatedGenderCode href "../PersonStatedGenderCode/"



      SACTResearchView : primary_diagnosis

      SACTResearchView : pseudo_nhs_number

      SACTResearchView : regimen

      SACTResearchView : route_admin_snomed_ct_dm_d

      SACTResearchView : sact_administration_route





        SACTResearchView --> "0..1" SACTAdministrationRouteCode : sact_administration_route
        click SACTAdministrationRouteCode href "../SACTAdministrationRouteCode/"



      SACTResearchView : start_date_cycle

      SACTResearchView : start_date_regimen

      SACTResearchView : unit_meas_snomed_ct_dm_d

      SACTResearchView : weight_start_cycle

      SACTResearchView : weight_start_of_reg

Class Properties

Property Value
Tree Root Yes

Slots

Name Cardinality and Range Description Inheritance
etl_id 0..1
Integer		 direct
etl_date 0..1
Datetime		 direct
direct_care_published_runid 0..1
Integer		 direct
dataset_name 0..1
String		 direct
ndo_run_date 0..1
Date		 direct
file_name 0..1
String		 direct
file_period_start 0..1
String		 direct
file_period_end 0..1
String		 direct
pseudo_nhs_number 0..1
String		 The NHS NUMBER, the primary identifier of a PERSON, is a unique identifier fo... direct
nhs_number_status 0..1
NHSNumberStatusCode		 The NHS NUMBER STATUS INDICATOR CODE indicates the verification status of the... direct
date_of_birth_year 0..1
String		 Year component of the patient's date of birth, extracted from DATE OF BIRTH f... direct
date_of_birth_month 0..1
String		 Month component of the patient's date of birth, extracted from DATE OF BIRTH ... direct
date_of_birth_mid_month 0..1
Date		 Approximate date of birth using the 15th of the birth month, for use in age c... direct
person_stated_gender_code 0..1
PersonStatedGenderCode		 Person's gender as self-declared (or inferred by observation for those unable... direct
llsoa 0..1
String		 Lower Layer Super Output Area, derived from PATIENT POSTCODE for geographic a... direct
consultant_gmc_code 0..1
String		 Code of the consultant who initiated the SACT treatment direct
consultant_spec_code 0..1
String		 Specialty code of the consultant who initiated the SACT treatment direct
org_id_code_provider 0..1
String		 The ORGANISATION IDENTIFIER of the Organisation acting as a Health Care Provi... direct
primary_diagnosis 0..1
String		 Primary diagnosis at time of decision to treat, coded using ICD direct
morphology_icd_o 0..1
String		 Morphology coded using ICD-O at time of decision to treat direct
diagnosis_code_snomed 0..1
String		 SNOMED CT concept ID identifying the clinical diagnosis given to the patient direct
adjunctive_therapy 0..1
AdjunctiveTherapyType		 Adjunctive therapy is therapy given in addition to the main therapy to maximi... direct
intent_of_treatment 0..1
IntentOfTreatment		 Intent of the SACT regimen direct
regimen 0..1
String		 The acronym derived from the drugs used in the Anti-Cancer Drug Regimen, used... direct
height_start_reg 0..1
Float		 Height in metres at start of SACT regimen direct
weight_start_of_reg 0..1
Float		 Weight in kilogrammes at start of SACT regimen direct
perf_status_start_reg_ad 0..1
PerformanceStatusAdult		 WHO performance status at start of the regimen, for patients aged 19 years an... direct
co_morbidity_adjustment 0..1
YesNoIndicator		 Whether the patient's overall physical state (other diseases and conditions) ... direct
date_decision_to_treat 0..1
Date		 The date on which the consultation between the PATIENT and the clinician took... direct
start_date_regimen 0..1
Date		 The first administration date of the first cycle of a regimen direct
clinical_trial 0..1
ClinicalTrialIndicator		 Records whether the patient is currently in an active Systemic Anti-Cancer Th... direct
cycle_number 0..1
Integer		 Cycle number, numbered sequentially within each regimen direct
start_date_cycle 0..1
Date		 Date of first drug administration in each cycle direct
weight_start_cycle 0..1
Float		 Weight in kilogrammes at start of the cycle direct
perf_stat_start_cycle_ad 0..1
PerformanceStatusAdult		 WHO performance status at start of the cycle, for patients aged 19 years and ... direct
drug_name 0..1
String		 The name of the anti-cancer drug, taken from the British National Formulary direct
dm_d 0..1
String		 The unique ID from the dm+d (Dictionary of Medicines and Devices) database, b... direct
actual_dose_per_admin 0..1
String		 Dose in mg or other applicable unit for each administration in a SACT cycle direct
admin_meas_per_actual_dose 0..1
AdministrationMeasurementCode		 Units of measurement used for each administration in a SACT cycle direct
ot_admin_meas_per_actual_dose 0..1
String		 Free-text description of a unit of measurement not available within the coded... direct
unit_meas_snomed_ct_dm_d 0..1
String		 The SNOMED CT concept ID from the NHS Dictionary of Medicines and Devices ide... direct
sact_administration_route 0..1
SACTAdministrationRouteCode		 The prescribed method of delivery for each administration in a SACT cycle direct
route_admin_snomed_ct_dm_d 0..1
String		 The SNOMED CT concept ID from the NHS Dictionary of Medicines and Devices ide... direct
administration_date 0..1
Date		 The date on which the anti-cancer drug was administered to a patient, an infu... direct
org_identifier_sact_admin 0..1
String		 Organisation Identifier of the organisation responsible for each administrati... direct

Identifier and Mapping Information

Schema Source

  • from schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact

Mappings

Mapping Type Mapped Value
self sact:SACTResearchView
native sact:SACTResearchView

LinkML Source

Direct

name: SACTResearchView
description: Flat research view combining patient, regimen, cycle, and drug administration
  data. Corresponds to RVW.SACT_RESEARCH_VIEW in the source database. Each row represents
  a single drug administration event, with regimen and patient context repeated per
  row.
from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
slots:
- etl_id
- etl_date
- direct_care_published_runid
- dataset_name
- ndo_run_date
- file_name
- file_period_start
- file_period_end
- pseudo_nhs_number
- nhs_number_status
- date_of_birth_year
- date_of_birth_month
- date_of_birth_mid_month
- person_stated_gender_code
- llsoa
- consultant_gmc_code
- consultant_spec_code
- org_id_code_provider
- primary_diagnosis
- morphology_icd_o
- diagnosis_code_snomed
- adjunctive_therapy
- intent_of_treatment
- regimen
- height_start_reg
- weight_start_of_reg
- perf_status_start_reg_ad
- co_morbidity_adjustment
- date_decision_to_treat
- start_date_regimen
- clinical_trial
- cycle_number
- start_date_cycle
- weight_start_cycle
- perf_stat_start_cycle_ad
- drug_name
- dm_d
- actual_dose_per_admin
- admin_meas_per_actual_dose
- ot_admin_meas_per_actual_dose
- unit_meas_snomed_ct_dm_d
- sact_administration_route
- route_admin_snomed_ct_dm_d
- administration_date
- org_identifier_sact_admin
tree_root: true

Induced

name: SACTResearchView
description: Flat research view combining patient, regimen, cycle, and drug administration
  data. Corresponds to RVW.SACT_RESEARCH_VIEW in the source database. Each row represents
  a single drug administration event, with regimen and patient context repeated per
  row.
from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
attributes:
  etl_id:
    name: etl_id
    annotations:
      sql_column:
        tag: sql_column
        value: ETL_ID
      sql_type:
        tag: sql_type
        value: INT
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: integer
    required: false
  etl_date:
    name: etl_date
    annotations:
      sql_column:
        tag: sql_column
        value: ETL_DATE
      sql_type:
        tag: sql_type
        value: DATETIME
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: datetime
    required: false
  direct_care_published_runid:
    name: direct_care_published_runid
    annotations:
      sql_column:
        tag: sql_column
        value: DIRECT_CARE_PUBLISHED_RUNID
      sql_type:
        tag: sql_type
        value: INT
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: integer
    required: false
  dataset_name:
    name: dataset_name
    annotations:
      sql_column:
        tag: sql_column
        value: DATASET_NAME
      sql_type:
        tag: sql_type
        value: NVARCHAR(300)
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  ndo_run_date:
    name: ndo_run_date
    annotations:
      sql_column:
        tag: sql_column
        value: NDO_RUN_DATE
      sql_type:
        tag: sql_type
        value: DATE
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  file_name:
    name: file_name
    annotations:
      sql_column:
        tag: sql_column
        value: FILE_NAME
      sql_type:
        tag: sql_type
        value: NVARCHAR(150)
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  file_period_start:
    name: file_period_start
    annotations:
      sql_column:
        tag: sql_column
        value: FILE_PERIOD_START
      sql_type:
        tag: sql_type
        value: NVARCHAR(20)
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  file_period_end:
    name: file_period_end
    annotations:
      sql_column:
        tag: sql_column
        value: FILE_PERIOD_END
      sql_type:
        tag: sql_type
        value: NVARCHAR(20)
    description: ''
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  pseudo_nhs_number:
    name: pseudo_nhs_number
    annotations:
      sql_column:
        tag: sql_column
        value: PSEUDO_NHS_NUMBER
      sql_type:
        tag: sql_type
        value: VARBINARY(100)
      sensitivity:
        tag: sensitivity
        value: pseudonymised
    description: The NHS NUMBER, the primary identifier of a PERSON, is a unique identifier
      for a PATIENT within the NHS in England and Wales. Pseudonymised for research
      use.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  nhs_number_status:
    name: nhs_number_status
    annotations:
      sql_column:
        tag: sql_column
        value: NHS_NUMBER_STATUS
      sql_type:
        tag: sql_type
        value: NVARCHAR(4)
    description: The NHS NUMBER STATUS INDICATOR CODE indicates the verification status
      of the NHS number provided.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: NHSNumberStatusCode
    required: false
  date_of_birth_year:
    name: date_of_birth_year
    annotations:
      sql_column:
        tag: sql_column
        value: DATE_OF_BIRTH_YEAR
      sql_type:
        tag: sql_type
        value: NVARCHAR(8)
    description: Year component of the patient's date of birth, extracted from DATE
      OF BIRTH for privacy preservation.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  date_of_birth_month:
    name: date_of_birth_month
    annotations:
      sql_column:
        tag: sql_column
        value: DATE_OF_BIRTH_MONTH
      sql_type:
        tag: sql_type
        value: NVARCHAR(4)
    description: Month component of the patient's date of birth, extracted from DATE
      OF BIRTH for privacy preservation.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  date_of_birth_mid_month:
    name: date_of_birth_mid_month
    annotations:
      sql_column:
        tag: sql_column
        value: DATE_OF_BIRTH_MID_MONTH
      sql_type:
        tag: sql_type
        value: DATE
    description: Approximate date of birth using the 15th of the birth month, for
      use in age calculations while preserving patient privacy.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  person_stated_gender_code:
    name: person_stated_gender_code
    annotations:
      sql_column:
        tag: sql_column
        value: PERSON_STATED_GENDER_CODE
      sql_type:
        tag: sql_type
        value: NVARCHAR(2)
    description: Person's gender as self-declared (or inferred by observation for
      those unable to declare their PERSON STATED GENDER).
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: PersonStatedGenderCode
    required: false
  llsoa:
    name: llsoa
    annotations:
      sql_column:
        tag: sql_column
        value: LLSOA
      sql_type:
        tag: sql_type
        value: NVARCHAR(18)
    description: Lower Layer Super Output Area, derived from PATIENT POSTCODE for
      geographic analysis while preserving patient privacy.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  consultant_gmc_code:
    name: consultant_gmc_code
    annotations:
      sql_column:
        tag: sql_column
        value: CONSULTANT_GMC_CODE
      sql_type:
        tag: sql_type
        value: NVARCHAR(16)
    description: Code of the consultant who initiated the SACT treatment. Derived
      from the GENERAL MEDICAL COUNCIL REFERENCE NUMBER.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  consultant_spec_code:
    name: consultant_spec_code
    annotations:
      sql_column:
        tag: sql_column
        value: CONSULTANT_SPEC_CODE
      sql_type:
        tag: sql_type
        value: NVARCHAR(16)
    description: Specialty code of the consultant who initiated the SACT treatment.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  org_id_code_provider:
    name: org_id_code_provider
    annotations:
      sql_column:
        tag: sql_column
        value: ORG_ID_CODE_PROVIDER
      sql_type:
        tag: sql_type
        value: NVARCHAR(10)
    description: The ORGANISATION IDENTIFIER of the Organisation acting as a Health
      Care Provider. Complies with ANANA standard DCB0090.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  primary_diagnosis:
    name: primary_diagnosis
    annotations:
      sql_column:
        tag: sql_column
        value: PRIMARY_DIAGNOSIS
      sql_type:
        tag: sql_type
        value: NVARCHAR(12)
    description: Primary diagnosis at time of decision to treat, coded using ICD.
      This is the PRIMARY DIAGNOSIS (ICD) at the start of the Systemic Anti-Cancer
      Therapy.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  morphology_icd_o:
    name: morphology_icd_o
    annotations:
      sql_column:
        tag: sql_column
        value: MORPHOLOGY_ICD_O
      sql_type:
        tag: sql_type
        value: NVARCHAR(14)
    description: Morphology coded using ICD-O at time of decision to treat. This is
      the Morphology ICD-O at the start of the Systemic Anti-Cancer Therapy. Required
      for Haematology cases.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  diagnosis_code_snomed:
    name: diagnosis_code_snomed
    annotations:
      sql_column:
        tag: sql_column
        value: DIAGNOSIS_CODE_SNOMED
      sql_type:
        tag: sql_type
        value: NVARCHAR(36)
      vocabulary:
        tag: vocabulary
        value: SNOMED CT
    description: SNOMED CT concept ID identifying the clinical diagnosis given to
      the patient.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  adjunctive_therapy:
    name: adjunctive_therapy
    annotations:
      sql_column:
        tag: sql_column
        value: ADJUNCTIVE_THERAPY
      sql_type:
        tag: sql_type
        value: NVARCHAR(2)
    description: Adjunctive therapy is therapy given in addition to the main therapy
      to maximise its effectiveness. Records whether the therapy was Adjuvant (after
      the main therapy), Neo-Adjuvant (before the main therapy), or not applicable.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: AdjunctiveTherapyType
    required: false
  intent_of_treatment:
    name: intent_of_treatment
    annotations:
      sql_column:
        tag: sql_column
        value: INTENT_OF_TREATMENT
      sql_type:
        tag: sql_type
        value: NVARCHAR(4)
    description: Intent of the SACT regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: IntentOfTreatment
    required: false
  regimen:
    name: regimen
    annotations:
      sql_column:
        tag: sql_column
        value: REGIMEN
      sql_type:
        tag: sql_type
        value: NVARCHAR(300)
    description: The acronym derived from the drugs used in the Anti-Cancer Drug Regimen,
      used to identify the drugs used in the regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  height_start_reg:
    name: height_start_reg
    annotations:
      sql_column:
        tag: sql_column
        value: HEIGHT_START_REG
      sql_type:
        tag: sql_type
        value: FLOAT
    description: Height in metres at start of SACT regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: float
    required: false
    unit:
      ucum_code: m
  weight_start_of_reg:
    name: weight_start_of_reg
    annotations:
      sql_column:
        tag: sql_column
        value: WEIGHT_START_OF_REG
      sql_type:
        tag: sql_type
        value: FLOAT
    description: Weight in kilogrammes at start of SACT regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: float
    required: false
    unit:
      ucum_code: kg
  perf_status_start_reg_ad:
    name: perf_status_start_reg_ad
    annotations:
      sql_column:
        tag: sql_column
        value: PERF_STATUS_START_REG_AD
      sql_type:
        tag: sql_type
        value: NVARCHAR(2)
    description: WHO performance status at start of the regimen, for patients aged
      19 years and above.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: PerformanceStatusAdult
    required: false
  co_morbidity_adjustment:
    name: co_morbidity_adjustment
    annotations:
      sql_column:
        tag: sql_column
        value: CO_MORBIDITY_ADJUSTMENT
      sql_type:
        tag: sql_type
        value: NVARCHAR(2)
    description: Whether the patient's overall physical state (other diseases and
      conditions) was a significant factor in deciding on the regimen, or in varying
      the dose or treatment interval.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: YesNoIndicator
    required: false
  date_decision_to_treat:
    name: date_decision_to_treat
    annotations:
      sql_column:
        tag: sql_column
        value: DATE_DECISION_TO_TREAT
      sql_type:
        tag: sql_type
        value: DATE
    description: The date on which the consultation between the PATIENT and the clinician
      took place and a Planned Cancer Treatment was agreed.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  start_date_regimen:
    name: start_date_regimen
    annotations:
      sql_column:
        tag: sql_column
        value: START_DATE_REGIMEN
      sql_type:
        tag: sql_type
        value: DATE
    description: The first administration date of the first cycle of a regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  clinical_trial:
    name: clinical_trial
    annotations:
      sql_column:
        tag: sql_column
        value: CLINICAL_TRIAL
      sql_type:
        tag: sql_type
        value: NVARCHAR(4)
    description: Records whether the patient is currently in an active Systemic Anti-Cancer
      Therapy trial.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: ClinicalTrialIndicator
    required: false
  cycle_number:
    name: cycle_number
    annotations:
      sql_column:
        tag: sql_column
        value: CYCLE_NUMBER
      sql_type:
        tag: sql_type
        value: INT
    description: Cycle number, numbered sequentially within each regimen.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: integer
    required: false
  start_date_cycle:
    name: start_date_cycle
    annotations:
      sql_column:
        tag: sql_column
        value: START_DATE_CYCLE
      sql_type:
        tag: sql_type
        value: DATE
    description: Date of first drug administration in each cycle.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  weight_start_cycle:
    name: weight_start_cycle
    annotations:
      sql_column:
        tag: sql_column
        value: WEIGHT_START_CYCLE
      sql_type:
        tag: sql_type
        value: FLOAT
    description: Weight in kilogrammes at start of the cycle.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: float
    required: false
    unit:
      ucum_code: kg
  perf_stat_start_cycle_ad:
    name: perf_stat_start_cycle_ad
    annotations:
      sql_column:
        tag: sql_column
        value: PERF_STAT_START_CYCLE_AD
      sql_type:
        tag: sql_type
        value: NVARCHAR(2)
    description: WHO performance status at start of the cycle, for patients aged 19
      years and above.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: PerformanceStatusAdult
    required: false
  drug_name:
    name: drug_name
    annotations:
      sql_column:
        tag: sql_column
        value: DRUG_NAME
      sql_type:
        tag: sql_type
        value: NVARCHAR(110)
    description: The name of the anti-cancer drug, taken from the British National
      Formulary.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  dm_d:
    name: dm_d
    annotations:
      sql_column:
        tag: sql_column
        value: DM_D
      sql_type:
        tag: sql_type
        value: NVARCHAR(36)
      vocabulary:
        tag: vocabulary
        value: NHS Dictionary of Medicines and Devices (dm+d)
    description: The unique ID from the dm+d (Dictionary of Medicines and Devices)
      database, based around the drug name and manufacturer. Pilot item for v3.0,
      required only for official Pilot sites.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  actual_dose_per_admin:
    name: actual_dose_per_admin
    annotations:
      sql_column:
        tag: sql_column
        value: ACTUAL_DOSE_PER_ADMIN
      sql_type:
        tag: sql_type
        value: NVARCHAR(100)
    description: Dose in mg or other applicable unit for each administration in a
      SACT cycle.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  admin_meas_per_actual_dose:
    name: admin_meas_per_actual_dose
    annotations:
      sql_column:
        tag: sql_column
        value: ADMIN_MEAS_PER_ACTUAL_DOSE
      sql_type:
        tag: sql_type
        value: NVARCHAR(16)
    description: Units of measurement used for each administration in a SACT cycle.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: AdministrationMeasurementCode
    required: false
  ot_admin_meas_per_actual_dose:
    name: ot_admin_meas_per_actual_dose
    annotations:
      sql_column:
        tag: sql_column
        value: OT_ADMIN_MEAS_PER_ACTUAL_DOSE
      sql_type:
        tag: sql_type
        value: NVARCHAR(30)
    description: Free-text description of a unit of measurement not available within
      the coded [admin_meas_per_actual_dose] field. Only populated when code 98 (Other)
      is selected.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  unit_meas_snomed_ct_dm_d:
    name: unit_meas_snomed_ct_dm_d
    annotations:
      sql_column:
        tag: sql_column
        value: UNIT_MEAS_SNOMED_CT_DM_D
      sql_type:
        tag: sql_type
        value: NVARCHAR(36)
      vocabulary:
        tag: vocabulary
        value: SNOMED CT / dm+d
    description: The SNOMED CT concept ID from the NHS Dictionary of Medicines and
      Devices identifying the unit of measurement.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  sact_administration_route:
    name: sact_administration_route
    annotations:
      sql_column:
        tag: sql_column
        value: SACT_ADMINISTRATION_ROUTE
      sql_type:
        tag: sql_type
        value: NVARCHAR(4)
    description: The prescribed method of delivery for each administration in a SACT
      cycle.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: SACTAdministrationRouteCode
    required: false
  route_admin_snomed_ct_dm_d:
    name: route_admin_snomed_ct_dm_d
    annotations:
      sql_column:
        tag: sql_column
        value: ROUTE_ADMIN_SNOMED_CT_DM_D
      sql_type:
        tag: sql_type
        value: NVARCHAR(36)
      vocabulary:
        tag: vocabulary
        value: SNOMED CT / dm+d
    description: The SNOMED CT concept ID from the NHS Dictionary of Medicines and
      Devices identifying the route of administration.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
  administration_date:
    name: administration_date
    annotations:
      sql_column:
        tag: sql_column
        value: ADMINISTRATION_DATE
      sql_type:
        tag: sql_type
        value: DATE
    description: The date on which the anti-cancer drug was administered to a patient,
      an infusion commenced, or an oral drug initially dispensed to the patient.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: date
    required: false
  org_identifier_sact_admin:
    name: org_identifier_sact_admin
    annotations:
      sql_column:
        tag: sql_column
        value: ORG_IDENTIFIER_SACT_ADMIN
      sql_type:
        tag: sql_type
        value: NVARCHAR(10)
    description: Organisation Identifier of the organisation responsible for each
      administration in a SACT cycle. Complies with ANANA standard DCB0090.
    from_schema: https://health-informatics-uon.github.io/nuh-data/datasets/sact
    rank: 1000
    owner: SACTResearchView
    domain_of:
    - SACTResearchView
    range: string
    required: false
tree_root: true