Table Detail Report

MLLD_MS_CATEGORIES



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_MS_CATEGORIES


Column Name Type Null? Definition
MS_CATEGORY_ID DOUBLE N This field assigns a more specific category to a medical supply.
MS_CATEGORY_NAME VARCHAR(100) N This field provides a more specific textual description of the medical supply type.
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_MS_CORE_DESCRIPTION



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_MS_CORE_DESCRIPTION


Column Name Type Null? Definition
MS_BRAND_DESCRIPTION VARCHAR(45) N This field contains drug names as they appear on the label of a medical supply.
MS_CATEGORY VARCHAR(50) N This field provides a general textual description of the medical supply type: Medical Supplies, Diagnostic Supplies, Nutritional Supplements
MS_CATEGORY_ID DOUBLE N This field assigns a more specific category to a medical supply.
MS_INNER_PACKAGE_DESCRIPTION VARCHAR(30) Y This field contains a textual description of the packaging units.
MS_INNER_PACKAGE_SIZE DOUBLE N This field represents the number of individual units present in the innermost packaging of a drug.
MS_NDC_CODE VARCHAR(11) N The National Drug Code is the standard 11 digit identifier for each drug product, as recognized by HCFA, other federal and state agencies, and many commercial enterprises. It is unique to each specific product. The first 5 numbers identify the manufacturer of a product. The second 4 numbers identify the product, and the last 2 numbers identify the package size of that product.
MS_OUTER_PACKAGE_SIZE DOUBLE Y This field designates the total number of inner packages present in the final packaged product. Not all products require an outer package size for a complete representation of the packaging. (The package unit may suffice.)
MS_SOURCE_DESCRIPTION VARCHAR(120) N This field contains the names of manufacturers, redistributors, and repackagers of the medical product.
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_MS_NDC_COST



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_MS_NDC_COST


Column Name Type Null? Definition
MS_COST DOUBLE N A specific cost for a medical supply. There is one cost stored for each inventory type, so it is possible to maintain separate price information for each inventory type.
MS_INVENTORY_TYPE VARCHAR(5) N This field designates the pricing description for the product: A - Average Wholesale Price, F - Federal Upper Limit Cost, M - Manufacturer Direct Price, W - Average Wholesale Cost
MS_NDC_CODE VARCHAR(11) N The National Drug Code is the standard 11 digit identifier for each drug product, as recognized by HCFA, other federal and state agencies, and many commercial enterprises. It is unique to each specific product. The first 5 numbers identify the manufacturer of a product. The second 4 numbers identify the product, and the last 2 numbers identify the package size of that product.
TIME_STAMP DATETIME N This field contains the Time/Date when each cost record was added to Multum's databases. If the record was added at 12:00 am, the time stamp will be blank and only the date stamp will appear.
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_NDC_ACTIVE_INGRED



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_NDC_ACTIVE_INGRED


Column Name Type Null? Definition
ACTIVE_INGREDIENT_CODE DOUBLE N This field contains a unique code for each active ingredient
ACTIVE_INGREDIENT_TXT VARCHAR(255) N This field contains textual descriptions of active drug ingredients; it contains complete salt/chemical/ester names and is therefore ideally suited for many applications desighed for pharmacist end users. In general, the drug_name field, may be more appropriate for use in applications designed for clinical or consumer end users.
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_NDC_ACT_INGRED_LIST



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_NDC_ACT_INGRED_LIST


Column Name Type Null? Definition
ACTIVE_INGREDIENT_CODE DOUBLE N This field contains the code from the active ingredient table (Foreign Key)
INGREDIENT_STRENGTH_CODE DOUBLE N This field contains a unique code for each ingredient strength
MAIN_MULTUM_DRUG_CODE DOUBLE N The Main Multum Drug Code is Multum's designator for groups of similar drug products.
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.