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 |