Table Detail Report
CONVERT_AUDIT_BEST_MATCH
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Convert Audit Best Match |
Definition: | Stores information about best match choices made for order conversion. |
Table Type: | ACTIVITY |
Column Detail - CONVERT_AUDIT_BEST_MATCH
Column Name | Type | Null? | Definition |
---|---|---|---|
CONVERT_AUDIT_BEST_MATCH_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated sequence number. |
CONVERT_AUDIT_SYNONYM_ID | DOUBLE | N | The primary key of the Convert Audit Synonym table. Associates a row in this table to the CONVERT_AUDIT_SYNONYM table. |
FORM_CD | DOUBLE | N | The code value for the synonym's associated form |
PER_UNIT_STRENGTH | VARCHAR(255) | Y | The value of the synonym's associated strength per unit dose. |
PER_UNIT_STRENGTH_UNIT_CKI | VARCHAR(255) | Y | The unit CKI of the strength per unit dose. |
SYNONYM_ID | DOUBLE | N | The id of the synonym designated as the best match. |
TOTAL_VOLUME_DOSE | VARCHAR(255) | Y | The value of the total volume dose for this best match. |
TOTAL_VOLUME_DOSE_UNIT_CKI | VARCHAR(255) | Y | The unit CKI of the total volume dose. |
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 - CONVERT_AUDIT_BEST_MATCH
Child Column in CONVERT_AUDIT_BEST_MATCH(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONVERT_AUDIT_SYNONYM_ID | CONVERT_AUDIT_SYNONYM | CONVERT_AUDIT_SYNONYM_ID |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
CONVERT_AUDIT_SYNONYM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Convert Audit Synonym |
Definition: | Stores information about requested synonyms for order conversion. |
Table Type: | ACTIVITY |
Column Detail - CONVERT_AUDIT_SYNONYM
Column Name | Type | Null? | Definition |
---|---|---|---|
CONVERT_AUDIT_SYNONYM_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated sequence number. |
CONVERT_AUDIT_TRANSACTION_ID | DOUBLE | N | The primary key of the Convert Audit Transaction table. Associates synonyms to transactions. |
DOSE_VALIDATION_ERROR_IND | DOUBLE | N | Indicates if a dose validation error was encountered. |
FORM_VALIDATION_ERROR_IND | DOUBLE | N | Indicates if a form validation error was encountered. |
FREETEXT_DOSE_IND | DOUBLE | N | Indicates if a free text dose was supplied. |
INFERRED_FORM_CD | DOUBLE | N | The form code inferred from a product synonym. |
ORDER_ID | DOUBLE | N | The id of the order to which the synonym is associated. |
ROUTE_CD | DOUBLE | N | The route code supplied for conversion. |
SUPPLIED_FORM_CD | DOUBLE | N | The form code supplied for conversion. |
SYNONYM_ID | DOUBLE | N | The id of the requested synonym that should be converted. |
TOTAL_STRENGTH_DOSE | VARCHAR(255) | Y | The value of the total strength dose requested. |
TOTAL_STRENGTH_DOSE_UNIT_CKI | VARCHAR(255) | Y | The unit CKI of the total strength dose. |
TOTAL_VOLUME_DOSE | VARCHAR(255) | Y | The value of the total volume dose requested. |
TOTAL_VOLUME_DOSE_UNIT_CKI | VARCHAR(255) | Y | The unit CKI of the total volume dose. |
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 - CONVERT_AUDIT_SYNONYM
Child Column in CONVERT_AUDIT_SYNONYM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CONVERT_AUDIT_TRANSACTION_ID | CONVERT_AUDIT_TRANSACTION | CONVERT_AUDIT_TRANSACTION_ID |
ORDER_ID | ORDERS | ORDER_ID | |
SYNONYM_ID | ORDER_CATALOG_SYNONYM | SYNONYM_ID |
Parent Column in CONVERT_AUDIT_SYNONYM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONVERT_AUDIT_SYNONYM_ID | CONVERT_AUDIT_BEST_MATCH | CONVERT_AUDIT_SYNONYM_ID |
CONVERT_AUDIT_TRANSACTION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Convert Audit Transaction |
Definition: | Stores audit transactions for order conversion. An audit transaction describes all request information during a single transaction for a consumer. |
Table Type: | ACTIVITY |
Column Detail - CONVERT_AUDIT_TRANSACTION
Column Name | Type | Null? | Definition |
---|---|---|---|
CONVERT_AUDIT_TRANSACTION_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated sequence number. |
FACILITY_CD | DOUBLE | N | The facility in which the conversion is taking place. |
PHARMACY_TYPE_BIT | DOUBLE | N | The bitmask defining the pharmacy types requested. |
PPR_CD | DOUBLE | N | The patient-provider relationship of the personnel performing the conversion, if one exists. |
PRSNL_ID | DOUBLE | N | The identifier of the personnel performing the conversion. |
RETRIEVE_NO_RX_MASK_IND | DOUBLE | N | Indicates that synonyms with no pharmacy type were requested. |
RETRIEVE_PRODUCTS_ONLY_IND | DOUBLE | N | Indicates that only product synonyms should be retrieved. |
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. |
VENUE_FLAG | DOUBLE | N | The venue to which the order is being converted. 1 - Prescription, 2 - Inpatient |
Relationship Detail - CONVERT_AUDIT_TRANSACTION
Child Column in CONVERT_AUDIT_TRANSACTION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in CONVERT_AUDIT_TRANSACTION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | CONVERT_AUDIT_TRANSACTION_ID | CONVERT_AUDIT_SYNONYM | CONVERT_AUDIT_TRANSACTION_ID |
DOSE_RANGE_CHECK
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | It is used to hold content updates and versioning of dose range rules. |
Definition: | Table is used as a placeholder for content updates and versioning of dose range rules. The table is initially populated with Multum content but a client has the ability to modify the Multum content and build their own. |
Table Type: | REFERENCE |
Column Detail - DOSE_RANGE_CHECK
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 | This tells us who built the relationship. |
CONTENT_RULE_IDENTIFIER | DOUBLE | Y | If the rule was created by Multum or another content provider an identifier that can be used in handling updates. |
DOSE_RANGE_CHECK_ID | DOUBLE | N | Unique identifier |
DOSE_RANGE_CHECK_NAME | VARCHAR(100) | Y | A textual description of the rule to allow easier viewing and building of DRC functionality. |
LONG_TEXT_ID | DOUBLE | N | A pointer to a set of text that a site could build to display to their users at DRC message time. |
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 - DOSE_RANGE_CHECK
Parent Column in DOSE_RANGE_CHECK (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | DOSE_RANGE_CHECK_ID | DRC_FACILITY_R | DOSE_RANGE_CHECK_ID |
DRC_FACILITY_R_VER | DOSE_RANGE_CHECK_ID |
DOSE_RANGE_CHECK_VER
Column Section | Top of Page |
Table-level Detail
Description: | DOSE RANGE CHECK VER |
Definition: | This is a history table for the Dose_range_check table. |
Table Type: | REFERENCE |
Column Detail - DOSE_RANGE_CHECK_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 |
CONTENT_RULE_IDENTIFIER | DOUBLE | Y | If the rule was created by Multum or another content provider an identifier that can be used in handling updates |
DOSE_RANGE_CHECK_ID | DOUBLE | N | Primary Key with ver_seq |
DOSE_RANGE_CHECK_NAME | VARCHAR(100) | Y | A textual description of the rule to allow easier viewing and building of DRC functionality. |
LONG_TEXT_ID | DOUBLE | N | A pointer to a set of text that a site could build to display to their users at DRC message time. |
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 | This is the version sequence changes made to the rule |