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 |