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