UKR_SACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: UK Reporting Systemic Anti Cancer Therapy
Definition: Contain information required for the Systemic Anti Cancer Therapy dataset
Table Type: ACTIVITY





Column Detail - UKR_SACT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
INTENT_OF_TREATMENT_CD DOUBLE N Intent of treatment of the given Regimen within the SACT data-set
NOMENCLATURE_ID DOUBLE N Links to the diagnosis associated to the given Programme and Regimen within the SACT data-set
PERSON_ID DOUBLE N Identifies the person record related to the given Programme and Regimen within the SACT data-set
PROGRAMME_NUM DOUBLE N Derived integer value to be used as the Programme Number for the given Programme within the SACT data-set
REGIMEN_ID DOUBLE N Links to the Regimen associated to the given Programme and Regimen within the SACT data-set
REGIMEN_NUM DOUBLE N Derived integer value to be used as the Regimen Number for the given Programme and Regimen within the SACT data-set
UKR_SACT_ID DOUBLE N PRIMARY KEY
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - UKR_SACT


Child Column in UKR_SACT(FK) Parent Table Name Parent Column Name
Parents: INTENT_OF_TREATMENT_CD CODE_VALUE CODE_VALUE
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
REGIMEN_ID REGIMEN REGIMEN_ID


WHC_D_ANESTHESIA_BRIDGE



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_ANESTHESIA_BRIDGE
Definition: A Dimension Bridge table to allow the Fact table row to be associated to many Anesthesia Dimensions
Table Type: REFERENCE





Column Detail - WHC_D_ANESTHESIA_BRIDGE


Column Name Type Null? Definition
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WHC_D_ANESTHESIA_BRIDGE_ID DOUBLE N Primary Key
WHC_D_ANESTHESIA_GROUP_ID DOUBLE N Foreign key to WHC_D_ANESTHESIA_GROUP.WHC_D_ANESTHESIA_GROUP_ID.
WHC_D_ANESTHESIA_TYPE_ID DOUBLE N Foreign key to WHC_D_ANESTHESIA_TYPE.WHC_D_ANESTHESIA_TYPE_ID.



Relationship Detail - WHC_D_ANESTHESIA_BRIDGE


Child Column in WHC_D_ANESTHESIA_BRIDGE(FK) Parent Table Name Parent Column Name
Parents: WHC_D_ANESTHESIA_GROUP_ID WHC_D_ANESTHESIA_GROUP WHC_D_ANESTHESIA_GROUP_ID
WHC_D_ANESTHESIA_TYPE_ID WHC_D_ANESTHESIA_TYPE WHC_D_ANESTHESIA_TYPE_ID


WHC_D_ANESTHESIA_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_ANESTHESIA_GROUP
Definition: A Dimension Group table to allow the connection the Fact table row to many Anesthesia Dimensions via the Bridge Table relationship
Table Type: REFERENCE





Column Detail - WHC_D_ANESTHESIA_GROUP


Column Name Type Null? Definition
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WHC_D_ANESTHESIA_GROUP_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_ANESTHESIA_GROUP




Parent Column in WHC_D_ANESTHESIA_GROUP (PK) Child Table Name Child Column Name
Children: WHC_D_ANESTHESIA_GROUP_ID WHC_D_ANESTHESIA_BRIDGE WHC_D_ANESTHESIA_GROUP_ID
WHC_F_CHILD ANESTHESIA_GROUP_ID
WHC_F_DELIVERY ANESTHESIA_GROUP_ID


WHC_D_ANESTHESIA_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_ANESTHESIA_TYPE
Definition: WHC Reporting - Dimension Table identifying Anesthesia Type and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_ANESTHESIA_TYPE


Column Name Type Null? Definition
ANESTHESIA_DESC VARCHAR(255) Y User-readable description of 'Anesthesia type' value, taken from the clinical result recorded against CKI CERNER!ASYr9AEYvUr1YoPECqIGfQ.
MILL_NOMENCLATURE_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Anesthesia type' value in Millennium.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WHC_D_ANESTHESIA_TYPE_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_ANESTHESIA_TYPE




Parent Column in WHC_D_ANESTHESIA_TYPE (PK) Child Table Name Child Column Name
Children: WHC_D_ANESTHESIA_TYPE_ID WHC_D_ANESTHESIA_BRIDGE WHC_D_ANESTHESIA_TYPE_ID


WHC_D_AUGMENT_METHOD



Column Section Relationship Section Top of Page


Table-level Detail

Description: WHC_D_AUGMENT_METHOD
Definition: WHC Reporting - Dimension Table identifying Augmentation Method and associated Nomenclature
Table Type: REFERENCE





Column Detail - WHC_D_AUGMENT_METHOD


Column Name Type Null? Definition
AUGMENT_DESC VARCHAR(255) Y User-readable description of 'Augmentation method' value, taken from the clinical result recorded against CKI CERNER!6B69F0FC-5514-40A1-BBE4-EF20AAF35BE0.
MILL_NOMENCLATURE_ID DOUBLE Y Foreign key to NOMENCLATURE.NOMENCLATURE_ID, represeting the corresponding 'Augmentation method' value in Millennium.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.
WHC_D_AUGMENT_METHOD_ID DOUBLE N Primary Key



Relationship Detail - WHC_D_AUGMENT_METHOD




Parent Column in WHC_D_AUGMENT_METHOD (PK) Child Table Name Child Column Name
Children: WHC_D_AUGMENT_METHOD_ID WHC_D_AUGMENT_METHOD_BRIDGE WHC_D_AUGMENT_METHOD_ID