Table Detail Report

MLLD_DRC_GROUP_RELTN



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRC_GROUP_RELTN


Column Name Type Null? Definition
GROUPER_ID DOUBLE N Externally assigned identifier for dose range check group
GROUPER_NAME VARCHAR(250) Y Name assigned to Multum Dose Range check grouper
MAIN_MULTUM_DRUG_CODE DOUBLE N Multum's designator for groups of similar drug products.
SYNONYM_ID DOUBLE N Multum's identifier for a unique drug name.
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.
VERSION VARCHAR(25) Y VersionColumn


MLLD_DRC_PREMISE



Column Section Top of Page


Table-level Detail

Description: MLLD DRC PREMISE
Definition: Multum Load Table DRC_PREMISE
Table Type: REFERENCE





Column Detail - MLLD_DRC_PREMISE


Column Name Type Null? Definition
AGE_HIGH_NBR DOUBLE N AGE HIGH NUMBER
AGE_LOW_NBR DOUBLE N AGE LOW NUMBER
AGE_OPERATOR_TXT VARCHAR(25) N AGE OPERATOR TEXT
AGE_UNIT_CKI VARCHAR(50) N AGE UNIT CKI COLUMN
AGE_UNIT_DISP VARCHAR(40) N AGE UNIT DISPLAY
COMMENT_TXT VARCHAR(255) Y COMMENT TEXT
CONDITION1_DESC VARCHAR(50) Y FIRST CONDITION DESCRIPTION
CONDITION1_ID DOUBLE N FIRST CONDITION ID
CONDITION2_DESC VARCHAR(50) Y SECOND CONDITION DESCRIPTION
CONDITION2_ID DOUBLE N SECOND CONDITION ID
CORRECTED_GEST_AGE_CKI VARCHAR(50) N CORRECTED GESTATION AGE CKI
CORRECTED_GEST_AGE_HIGH_NBR DOUBLE N CORRECTED GEST AGE HIGH NUMBER
CORRECTED_GEST_AGE_LOW_NBR DOUBLE N CORRECTED GEST AG LOW NUMBER
CORRECTED_GEST_AGE_OPER_TXT VARCHAR(25) N CORRECTED GEST AGE OPER TEXT
CORRECTED_GEST_AGE_UNIT_DISP VARCHAR(40) N CORRECTED GEST AGE UNIT DISPLAY
CORRECTED_GEST_AGE_UNIT_ID DOUBLE N CORRECTED GESTATION AGE UNIT ID
DOSE_RANGE_CHECK_ID DOUBLE N DOSE RANGE CHECK IDENTIFIER
DOSE_RANGE_TYPE VARCHAR(100) N DOSE RANGE TYPE COLUMN
DOSE_RANGE_TYPE_ID DOUBLE N DOSE RANGE TYPE IDENTIFIER
DOSE_UNIT_CD DOUBLE N DOSE UNIT CODE
DOSE_UNIT_CKI VARCHAR(50) N DOSE UNIT CKI
DOSE_UNIT_DISP VARCHAR(40) N DOSE UNIT DISPLAY
DOSE_UNIT_ID DOUBLE N DOSE UNIT IDENTIFIER
DRC_CKI VARCHAR(100) N DRC CKI COLUMN
DRC_DOSE_RANGE_ID DOUBLE N DRC DOSE RANGE IDENTIFIER
DRC_IDENTIFIER VARCHAR(45) N DRC IDENTIFIER
DRC_PREMISE_ID DOUBLE N DRC PREMISE IDENTIFIER
GENDER_FLAG DOUBLE N GENDER FLAG VALUES
GROUPER_ID DOUBLE N GROUPER IDENTIFIER
GROUPER_NAME VARCHAR(100) N GROUPER NAME
HIGH_DOSE_VALUE DOUBLE N HIGH DOSE VALUE COL
LIVER_DESC VARCHAR(50) N LIVER DISCRIPTION
LOW_DOSE_VALUE DOUBLE N LOW DOSE VALUE
MULTUM_CASE_ID DOUBLE N MULTUM CASE IDENTIFIER
PARENT_PREMISE_ID DOUBLE N PARENT PREMISE IDENTIFIER
PEDS_IND DOUBLE N PEDS INDICATOR
RENAL_CONDITION_TXT VARCHAR(40) N RENAL CONDITION TEXT
RENAL_HIGH_VALUE DOUBLE N RENAL HIGH VALUE AMT
RENAL_LOW_VALUE DOUBLE N RENAL LOW VALUE AMT
RENAL_OPERATOR_TXT VARCHAR(25) N RENAL OPERATOR TEXT
RENAL_UNIT_CKI VARCHAR(50) N RENAL UNIT CKI
RENAL_UNIT_DISP VARCHAR(40) N RENAL UNIT DISPLAY
RENAL_UNIT_ID DOUBLE N RENAL UNIT IDENTIFIER
ROUTE_DISP VARCHAR(40) N ROUTE DISPLAY
ROUTE_ID DOUBLE N ROUTE IDENTIFIER
SMOKER_FLAG DOUBLE N SMOKER FLAG
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.
WEIGHT_HIGH_VALUE DOUBLE N WEIGHT HIGH VALUE AMT
WEIGHT_LOW_VALUE DOUBLE N WEIGHT LOW VALUE AMT
WEIGHT_OPERATOR_TXT VARCHAR(25) N WEIGHT OPERATOR TEXT
WEIGHT_UNIT_CKI VARCHAR(50) N WEIGHT UNIT CKI COL
WEIGHT_UNIT_DISP VARCHAR(40) N WEIGHT UNIT DISPLAY
WEIGHT_UNIT_ID DOUBLE N WEIGHT UNIT IDENTIFIER


MLLD_DRC_ROUTE



Column Section Top of Page


Table-level Detail

Description: MLLD_DRC_ROUTE
Definition: This table contains a listing of routes of administration (orally, topically, rectally, etc.) and a unique identifier for each route. These routes are presented as phrases and abbreviations that are clinically appropriate for describing a route of administration.
Table Type: REFERENCE





Column Detail - MLLD_DRC_ROUTE


Column Name Type Null? Definition
ROUTE_ABBR VARCHAR(30) Y This field contains abbreviations for the various routes of administration.
ROUTE_CODE DOUBLE N This field contains a unique code for each route of administration.
ROUTE_DESCRIPTION VARCHAR(255) Y This field contains textual descriptions of the various routes of administration.
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_DRUG_CATEGORIES



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_CATEGORIES


Column Name Type Null? Definition
CATEGORY_ATC_CODE VARCHAR(20) N The code which denotes the appropriate alternative therapeutic class.
CATEGORY_NAME VARCHAR(255) Y This field contains a textual description of the therapeutic/chemical category referenced by Multum_category_id.
MULTUM_CATEGORY_ID DOUBLE N This field is used to assign a therapeutic/chemical category to a specific drug.
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_DRUG_ID



Column Section Top of Page


Table-level Detail

Description: D
Definition: DD
Table Type: REFERENCE





Column Detail - MLLD_DRUG_ID


Column Name Type Null? Definition
DRUG_IDENTIFIER VARCHAR(6) N This field contains Multum's identification codes for generic drugs. These are extremely important codes for developers who are using Multum's database products because they serve as the primary link to all of Multum's advanced clinical services. Multum's drug_id is always of the form "d#####".
DRUG_SYNONYM_ID DOUBLE N This field contains a unique numeric identifier for a description of a drug.
EMPIRICALLY VARCHAR(1) Y This field indicates whether drug half-life information is available for the drug.
HALF_LIFE DOUBLE Y This field contains an estimate of the amount of time necessary for a drug to be eliminated from the body. This estimate may be used to determine the length of time to continue checking for a drug interaction after use of a drug is discontinued. The length of time is reported as a half-life measured in hours.
IS_SINGLE_INGREDIENT VARCHAR(1) Y This field indicates whether a drug is available as a single product or if it is only available in combination with other drugs.
MAX_THERAPEUTIC_DUPLICATION DOUBLE Y This field contains a number representing how many orders for a specified drug may be prescribed before therapeutic duplication warnings should be generated.
PREGNANCY_ABBR VARCHAR(1) Y This is a one-character field that represents the FDA's pregnancy hazard classification scheme.
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.