Table Detail Report

MLLD_PRODUCT_STRENGTH



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_PRODUCT_STRENGTH


Column Name Type Null? Definition
PRODUCT_STRENGTH_CODE DOUBLE N This field contains a unique code for each product strength description.
PRODUCT_STRENGTH_DESCRIPTION VARCHAR(255) Y This field contains full textual descriptions of drug product strengths.
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.


MLLD_REF_DETAIL



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_REF_DETAIL


Column Name Type Null? Definition
AUTHORS VARCHAR(255) Y source informatin author
JOURNAL_ABBREV VARCHAR(100) Y Journal AbbreviationColumn
PAGES VARCHAR(64) Y Number of Pages in text format
REF_ID DOUBLE N textual description of source information referenced by ref_id.
TITLE VARCHAR(255) Y The reference title
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.
VOLUMN_ISSUE VARCHAR(20) Y The issue volume indentifer
YEAR_COMPLETE VARCHAR(15) Y Year Complete - text format


MLLD_REF_DRUG



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





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


MLLD_RXB_CALC_DISP_RULE_ORDMAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_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 - MLLD_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 - MLLD_RXB_CALC_DISP_RULE_ORDMAP


Child Column in MLLD_RXB_CALC_DISP_RULE_ORDMAP(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_DOSE_DISP_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD_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 - MLLD_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 - MLLD_RXB_CALC_DOSE_DISP_RULE




Parent Column in MLLD_RXB_CALC_DOSE_DISP_RULE (PK) Child Table Name Child Column Name
Children: DOSE_DISPENSE_RULE_ID MLLD_RXB_CALC_DISP_RULE_ORDMAP DOSE_DISPENSE_RULE_ID
MLLD_RXB_CALC_DUR_RULE_ORD_MAP DOSE_DISPENSE_RULE_ID