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 |