Table Detail Report
DRC_FORM_RELTN_VER
Column Section | Top of Page |
Table-level Detail
Description: | DRC FORM RELTN VER |
Definition: | Provides History of the DRC_FORM_RELTN table. |
Table Type: | REFERENCE |
Column Detail - DRC_FORM_RELTN_VER
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. |
BUILD_FLAG | DOUBLE | Y | A flag showing the how the relationship between MMDC's and Premise groups was built: |
DOSE_RANGE_CHECK_ID | DOUBLE | N | The id of the premise group/ dose ranges to be used in to DRC the order. |
DRC_FORM_RELTN_ID | DOUBLE | N | Unique Identifier with ver_seq |
DRC_GROUP_ID | DOUBLE | N | The DRC grouping number that this set of dose range rules relates to |
FORMULATION_CODE | DOUBLE | Y | In the Multum world the MMDC id of the drug to be checked. |
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. |
VER_SEQ | DOUBLE | N | History of the DRC_FORM_RELTN table |
DRC_GROUP_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | Stores the relationship between a DRC Group number and a list of similar MMDC |
Definition: | Stores the relationship between a DRC Group and a list of similar MMDC and CNUM numbers. This table is built by Multum and is not currently modified by the client. |
Table Type: | REFERENCE |
Column Detail - DRC_GROUP_RELTN
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. |
DRC_GROUP_ID | DOUBLE | N | The DRC grouping number for the list of similar MMDC and CNUM numbers |
DRC_GROUP_RELTN_ID | DOUBLE | N | Unique Identifier |
DRUG_SYNONYM_ID | DOUBLE | N | The CNUM ID of the drug to be checked |
FORMULATION_ID | DOUBLE | N | The MMDC ID of the drug to be checked |
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. |
DRC_GROUP_RELTN_VER
Column Section | Top of Page |
Table-level Detail
Description: | Stores the historical relationships between DRC Groups and MMDC/CNUM numbers |
Definition: | Stores past versions relationships between DRC Group number and the list of similar MMDC(products) and CNUM numbers. |
Table Type: | REFERENCE |
Column Detail - DRC_GROUP_RELTN_VER
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. |
DRC_GROUP_ID | DOUBLE | N | The DRC grouping number for the list of similar MMDC and CNUM numbers |
DRC_GROUP_RELTN_ID | DOUBLE | N | Unique Identifier |
DRUG_SYNONYM_ID | DOUBLE | N | The CNUM ID of the drug to be checked |
FORMULATION_ID | DOUBLE | N | The MMDC ID of the drug to be checked |
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. |
VER_SEQ | DOUBLE | N | Sequence number to keep versions in synch |
DRC_PREMISE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Dose Range Checking Premise |
Definition: | Table stores the premises to be used to see if a patient qualifies to be checked for dose ranges. These premises could range from age, route, patient condition, etc? The table is initially populated with Multum content but a user has the ability to modify the content. |
Table Type: | REFERENCE |
Column Detail - DRC_PREMISE
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. |
CONCEPT_CKI | VARCHAR(255) | Y | Parent CKI to CMT_CONCEPT table. CKI stands for Cerner Knowledge Index. |
DOSE_RANGE_CHECK_ID | DOUBLE | N | The high level grouping id of all the premise groups/dose ranges that should be applied to this order. |
DRC_IDENTIFIER | VARCHAR(50) | Y | Unique identifier for dose range from Multum. Combination of |
DRC_PREMISE_ID | DOUBLE | N | Unique Identifier |
MULTUM_CASE_ID | DOUBLE | N | The actual identifier for a premise from Multum. |
PARENT_IND | DOUBLE | Y | Notes whether this premise is a parent or not. |
PARENT_PREMISE_ID | DOUBLE | N | If the premise is part of a premise group this will be the id of the premise group level. |
PREMISE_TYPE_FLAG | DOUBLE | Y | Identifies what type of premise this is |
RELATIONAL_OPERATOR_FLAG | DOUBLE | Y | Controls the comparison against the premise value . |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
VALUE1 | DOUBLE | Y | Holds any numeric or code value premise values. |
VALUE1_STRING | VARCHAR(255) | Y | Holds any textual premise values |
VALUE2 | DOUBLE | Y | Holds any numeric or code value premise values. |
VALUE2_STRING | VARCHAR(255) | Y | Holds any textual premise values |
VALUE_TYPE_FLAG | DOUBLE | Y | Controls the type of data that is stored for the premise |
VALUE_UNIT_CD | DOUBLE | N | Contains the codified units of measure for the premise |
Relationship Detail - DRC_PREMISE
Parent Column in DRC_PREMISE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DRC_PREMISE_ID | DRC_DOSE_RANGE_VER | DRC_PREMISE_ID |
DRC_PREMISE_LIST
Column Section | Top of Page |
Table-level Detail
Description: | It is used to store a list of values for a premise. |
Definition: | Table is used to store a list of values for a premise if more than one value is valid in a premise. This could include route groups where multiple routes are applicable. The table is initially populated with Multum content but a user has the ability to m |
Table Type: | REFERENCE |
Column Detail - DRC_PREMISE_LIST
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. |
DRC_PREMISE_ID | DOUBLE | N | The premise this list is getting built for. |
DRC_PREMISE_LIST_ID | DOUBLE | N | Unique Identifier. |
PARENT_ENTITY_ID | DOUBLE | N | Represents the value of the date you are building the list for. (i.e. NOMENCLATURE ID) |
PARENT_ENTITY_NAME | VARCHAR(50) | Y | Represents the data you are building the list for. (i.e. NOMENCLATURE) |
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. |