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. |