Table Detail Report

MLTM_REF_DRUG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Reference Drug
Definition: This table contains the links between clinical content in VantageRx Database and the specific medical articles and references from which the content is derived.
Table Type: REFERENCE





Column Detail - MLTM_REF_DRUG


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs.
FUNCTION_ID DOUBLE N FK from Functin_Type table
KEYWORD VARCHAR(45) Y Drug Reference Keyword
REF_ID DOUBLE N FK from Multum REF_DETAIL table.
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 - MLTM_REF_DRUG


Child Column in MLTM_REF_DRUG(FK) Parent Table Name Parent Column Name
Parents: DRUG_IDENTIFIER MLTM_DRUG_ID DRUG_IDENTIFIER
REF_ID MLTM_REF_DETAIL REF_ID


MLTM_RXB_CALC_DISP_RULE_ORDMAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_RXB_CALC_DISP_RULE_ORDMAP
Definition: Table used to store relationships between a drug, an order, and a dispense amount.
Table Type: REFERENCE





Column Detail - MLTM_RXB_CALC_DISP_RULE_ORDMAP


Column Name Type Null? Definition
DISPENSE_FACTOR VARCHAR(30) N Factor to be used in RXB calculation rule.
DOSE_DISPENSE_RULE_ID DOUBLE N FK to MLLD_RXB_CALC_DOSE_DISP_RULE
DRUG_IDENTIFIER VARCHAR(15) N Multum Drug ID
FREQUENCY_DURATION_RULE_ID DOUBLE N FK to MLLD_RXB_CALC_FREQ_DUR_RULE
ORDER_ID DOUBLE N RxBuilder Order ID
ROUNDING_MASK_ID DOUBLE N FK to MLLD_RXB_CALC_RND_MASK
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 - MLTM_RXB_CALC_DISP_RULE_ORDMAP


Child Column in MLTM_RXB_CALC_DISP_RULE_ORDMAP(FK) Parent Table Name Parent Column Name
Parents: DOSE_DISPENSE_RULE_ID MLTM_RXB_CALC_DOSE_DISP_RULE DOSE_DISPENSE_RULE_ID
FREQUENCY_DURATION_RULE_ID MLTM_RXB_CALC_FREQ_DUR_RULE FREQUENCY_DURATION_RULE_ID
ROUNDING_MASK_ID MLTM_RXB_CALC_RND_MASK ROUNDING_MASK_ID


MLTM_RXB_CALC_DOSE_DISP_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_RXB_CALC_DOSE_DISP_RULE
Definition: Table used to store relationships between France's UCD code and Multum Drug Identifier's for use with Millennium's order catalog
Table Type: REFERENCE





Column Detail - MLTM_RXB_CALC_DOSE_DISP_RULE


Column Name Type Null? Definition
DISPENSE_UNIT_ID DOUBLE N RxBuilder Dispense Unit ID
DOSE_DISPENSE_RULE_ID DOUBLE N Externally generated sequence
DOSE_UNIT_ID DOUBLE N RxBuilder Dose Unit ID
RATE_UNIT_ID DOUBLE N RxBuilder Rate Unit ID
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 - MLTM_RXB_CALC_DOSE_DISP_RULE




Parent Column in MLTM_RXB_CALC_DOSE_DISP_RULE (PK) Child Table Name Child Column Name
Children: DOSE_DISPENSE_RULE_ID MLTM_RXB_CALC_DISP_RULE_ORDMAP DOSE_DISPENSE_RULE_ID
MLTM_RXB_CALC_DUR_RULE_ORD_MAP DOSE_DISPENSE_RULE_ID


MLTM_RXB_CALC_DUR_RULE_ORD_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_RXB_CALC_DUR_RULE_ORD_MAP
Definition: Table used to store relationships between a drug, an order, and a dispense amount.
Table Type: REFERENCE





Column Detail - MLTM_RXB_CALC_DUR_RULE_ORD_MAP


Column Name Type Null? Definition
DOSE_DISPENSE_RULE_ID DOUBLE N FK to MLLD_RXB_CALC_DOSE_DISP_RULE
DRUG_IDENTIFIER VARCHAR(15) N Multum Drug ID
DURATION_FACTOR VARCHAR(30) N Duration factor to be used in RXB calculation rule.
FREQUENCY_DURATION_RULE_ID DOUBLE N FK to MLLD_RXB_CALC_FREQ_DUR_RULE
ORDER_ID DOUBLE N RxBuilder Order ID
ROUNDING_MASK_ID DOUBLE N FK to MLLD_RXB_CALC_RND_MASK
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 - MLTM_RXB_CALC_DUR_RULE_ORD_MAP


Child Column in MLTM_RXB_CALC_DUR_RULE_ORD_MAP(FK) Parent Table Name Parent Column Name
Parents: DOSE_DISPENSE_RULE_ID MLTM_RXB_CALC_DOSE_DISP_RULE DOSE_DISPENSE_RULE_ID
FREQUENCY_DURATION_RULE_ID MLTM_RXB_CALC_FREQ_DUR_RULE FREQUENCY_DURATION_RULE_ID
ROUNDING_MASK_ID MLTM_RXB_CALC_RND_MASK ROUNDING_MASK_ID


MLTM_RXB_CALC_FREQ_DUR_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLTM_RXB_CALC_FREQ_DUR_RULE
Definition: Table used to store RxBuilder information for a frequency and duration factor.
Table Type: REFERENCE





Column Detail - MLTM_RXB_CALC_FREQ_DUR_RULE


Column Name Type Null? Definition
DURATION_UNIT_ID DOUBLE N RxBuilder Duration Unit Identifier
FREQUENCY_DURATION_FACTOR VARCHAR(30) N Factor text to be used for the Frequency Duration Rule
FREQUENCY_DURATION_RULE_ID DOUBLE N Externally generated sequence
FREQUENCY_ID DOUBLE N RxBuilder Frequency Identifier
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 - MLTM_RXB_CALC_FREQ_DUR_RULE




Parent Column in MLTM_RXB_CALC_FREQ_DUR_RULE (PK) Child Table Name Child Column Name
Children: FREQUENCY_DURATION_RULE_ID MLTM_RXB_CALC_DISP_RULE_ORDMAP FREQUENCY_DURATION_RULE_ID
MLTM_RXB_CALC_DUR_RULE_ORD_MAP FREQUENCY_DURATION_RULE_ID