Table Detail Report

MLLD_RXB_CALC_DUR_RULE_ORD_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_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 - MLLD_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 MLTM_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 - MLLD_RXB_CALC_DUR_RULE_ORD_MAP


Child Column in MLLD_RXB_CALC_DUR_RULE_ORD_MAP(FK) Parent Table Name Parent Column Name
Parents: DOSE_DISPENSE_RULE_ID MLLD_RXB_CALC_DOSE_DISP_RULE DOSE_DISPENSE_RULE_ID
FREQUENCY_DURATION_RULE_ID MLLD_RXB_CALC_FREQ_DUR_RULE FREQUENCY_DURATION_RULE_ID
ROUNDING_MASK_ID MLLD_RXB_CALC_RND_MASK ROUNDING_MASK_ID


MLLD_RXB_CALC_FREQ_DUR_RULE



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - MLLD_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 - MLLD_RXB_CALC_FREQ_DUR_RULE




Parent Column in MLLD_RXB_CALC_FREQ_DUR_RULE (PK) Child Table Name Child Column Name
Children: FREQUENCY_DURATION_RULE_ID MLLD_RXB_CALC_DISP_RULE_ORDMAP FREQUENCY_DURATION_RULE_ID
MLLD_RXB_CALC_DUR_RULE_ORD_MAP FREQUENCY_DURATION_RULE_ID


MLLD_RXB_CALC_RND_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_RXB_CALC_RND_FORMAT
Definition: Table used to store the possible rounding formats used by RxBuilder
Table Type: REFERENCE





Column Detail - MLLD_RXB_CALC_RND_FORMAT


Column Name Type Null? Definition
FORMAT_CODE VARCHAR(1) N Alpha code to define format
FORMAT_DESCRIPTION VARCHAR(50) N Description of format
FORMAT_ID DOUBLE N Externally generated sequence 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 - MLLD_RXB_CALC_RND_FORMAT




Parent Column in MLLD_RXB_CALC_RND_FORMAT (PK) Child Table Name Child Column Name
Children: FORMAT_ID MLLD_RXB_CALC_RND_MASK ROUNDING_FORMAT_ID


MLLD_RXB_CALC_RND_MASK



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_RXB_CALC_RND_MASK
Definition: Table used to store calculated rounding mask for RxBuilder
Table Type: REFERENCE





Column Detail - MLLD_RXB_CALC_RND_MASK


Column Name Type Null? Definition
DECIMAL_PRECISION DOUBLE N Identifies decimal precision to be used
ROUNDING_FORMAT_ID DOUBLE N Identifies the rounding format ID
ROUNDING_MASK_ID DOUBLE N Primary key for table. Externally generated ID
SIGNIFICANT_DIGIT DOUBLE N Identifies the significant digit for rounding
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 - MLLD_RXB_CALC_RND_MASK


Child Column in MLLD_RXB_CALC_RND_MASK(FK) Parent Table Name Parent Column Name
Parents: ROUNDING_FORMAT_ID MLLD_RXB_CALC_RND_FORMAT FORMAT_ID




Parent Column in MLLD_RXB_CALC_RND_MASK (PK) Child Table Name Child Column Name
Children: ROUNDING_MASK_ID MLLD_RXB_CALC_DISP_RULE_ORDMAP ROUNDING_MASK_ID
MLLD_RXB_CALC_DUR_RULE_ORD_MAP ROUNDING_MASK_ID


MLLD_RXB_DICTIONARY



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_RXB_DICTIONARY


Column Name Type Null? Definition
ABBREVIATION VARCHAR(30) Y Dictionary AbbreviationColumn
DESCRIPTION VARCHAR(255) Y This field contains a textual description of each dictionary ID used in Multum's RxBuilder databases
DICTIONARY_ID DOUBLE N This field contains a unique identifier for each dictionary_id used in Multum's RxBuilder tables.
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.