Table Detail Report

MLLD_RXB_ORD_DOSE_AMOUNT



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_RXB_ORD_DOSE_AMOUNT


Column Name Type Null? Definition
DOSE_AMOUNT DOUBLE N This field contains a numeric amount that represents the amount of drug to prescribe.
DOSE_QTY_AMOUNT DOUBLE N Dose Quantity
DOSE_QTY_UNIT_DICTIONARY_CKI VARCHAR(255) Y CKI Code
DOSE_QTY_UNIT_DICTIONARY_ID DOUBLE N Value from Multum RXB Dictionary
DOSE_UNIT_DICTIONARY_CKI VARCHAR(255) Y CKI code
DOSE_UNIT_DICTIONARY_ID DOUBLE N This field contains an identifier that represents a dosage unit description.
DRUG_IDENTIFIER VARCHAR(6) N Drug IdentifierColumn
MOST_COMMON_IND DOUBLE N Designates the data as the most common for the drug_id, order_id combination.
ORDER_ID_NBR DOUBLE N This field contains an identifier that provides uniqueness to a record and along with the drug_id associates a record with a main_Multum_drug_code.
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_ORD_DOSE_RATE



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_RXB_ORD_DOSE_RATE


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N Drug IdentifierColumn
MOST_COMMON_IND DOUBLE Y Designates the data as the most common for the drug_id, order_id combination.
ORDER_ID_NBR DOUBLE N This field contains an identifier that provides uniqueness to a record and along with the drug_id associates a record with a main_Multum_drug_code.
RATE_AMOUNT DOUBLE N This field contains a numeric amount that represents the rate at which a prescription is given.
RATE_UNIT_DICTIONARY_CKI VARCHAR(255) Y CKI Code
RATE_UNIT_DICTIONARY_ID DOUBLE N This field contains an identifier that represents the rate amount for a prescription.
TIME_UNIT_DICTIONARY_CKI VARCHAR(255) Y CKI code
TIME_UNIT_DICTIONARY_ID DOUBLE N This field contains an identifier that represents the description for a time unit.
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_RXN_MAP



Column Section Relationship Section Top of Page


Table-level Detail

Description: MLLD RXN MAP
Definition: Table used to Facilitate loading - store mappings between Multum identifiers and RxNorm identifiers
Table Type: REFERENCE





Column Detail - MLLD_RXN_MAP


Column Name Type Null? Definition
DRUG_SYNONYM_ID DOUBLE N The Multum drug synonym id
MAIN_MULTUM_DRUG_CODE DOUBLE N The Multum main drug code
RXCUI VARCHAR(60) N Identifier from RxNorm terminology.
RXN_DESCRIPTION VARCHAR(3000) Y The descriptor for the RxNorm translation
TERM_TYPE_MEANING VARCHAR(20) N Defines the type of term
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_RXN_MAP


Child Column in MLLD_RXN_MAP(FK) Parent Table Name Parent Column Name
Parents: DRUG_SYNONYM_ID MLLD_DRUG_NAME DRUG_SYNONYM_ID


MLLD_SCRIPT_CATEGORY



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_SCRIPT_CATEGORY


Column Name Type Null? Definition
CATEGORY_CODE DOUBLE N Assigns a category code to a prescription
SCRIPT_CATEGORY VARCHAR(255) Y assigns a category to a prescription.
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_SCRIPT_COMMON



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_SCRIPT_COMMON


Column Name Type Null? Definition
CATEGORY_CODE DOUBLE Y This field contains a unique identifier for each common script category.
DOSE_AMOUNT DOUBLE Y Dose Amount in specified units
DOSE_TO_AMOUNT DOUBLE Y Dose to Amount in specified quantity
DOSE_TO_UNIT DOUBLE N This field contains a unique code for each unit of measurement used in Multum's databases.
DOSE_UNIT DOUBLE N This field contains a unique code for each unit of measurement used in Multum's databases.
DURATION_AMOUNT DOUBLE Y Duration Amount - in specified units
DURATION_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
FREQUENCY_CODE DOUBLE N This field contains a numeric identifier assigned to a frequency of administration.
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code (MMDC) is Multum's designator for groups of similar drug products. This is an extremely important code for developers who are using Multum's database products because it serves as the primary link to all of Multum's tables containing drug product information. An MMDC is assigned to each unique combination of the following fields: active ingredient(s), strength, route of administration, and dosage form. As a result, the MMDC is a very useful field for identifying dru
QUANTITY_AMOUNT DOUBLE Y Quantity Amount - in specified units
QUANTITY_TO_AMOUNT DOUBLE Y Quantity to Amount in specified units
QUANTITY_TO_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
QUANTITY_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
RATE_AMOUNT DOUBLE Y Rate Amount - in specified units
RATE_AMOUNT_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
RATE_TIME DOUBLE Y Rate Time -in specified units
RATE_TIME_UNIT DOUBLE Y This field contains a unique code for each unit of measurement used in Multum's databases.
ROUTE_CODE DOUBLE N This field contains a unique code for each route of administration.
SCRIPT_ID DOUBLE N Prescription Category Identifier. This field contains a unique identifier for each prescription.
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.