Table Detail Report
MLTM_DUPLICATION_SUB_XREF
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum Duplication Sub Cross-Reference |
Definition: | Therapeutic duplication categories. It allows assignment of one or more (sub) categories to a more general category. |
Table Type: | REFERENCE |
Column Detail - MLTM_DUPLICATION_SUB_XREF
Column Name | Type | Null? | Definition |
---|---|---|---|
MULTUM_CATEGORY_ID | DOUBLE | N | Used to assign a therapeutic/chemical category to a specific drug. |
SUB_CATEGORY_ID | DOUBLE | N | This field is used to assign a therapeutic/chemical sub-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. |
Relationship Detail - MLTM_DUPLICATION_SUB_XREF
Child Column in MLTM_DUPLICATION_SUB_XREF(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | MULTUM_CATEGORY_ID | MLTM_DUPLICATION_CATEGORIES | MULTUM_CATEGORY_ID |
SUB_CATEGORY_ID | MLTM_DUPLICATION_CATEGORIES | MULTUM_CATEGORY_ID |
MLTM_FLAVOR
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | MLTM FLAVOR |
Definition: | Multum Flavors for drug products |
Table Type: | REFERENCE |
Column Detail - MLTM_FLAVOR
Column Name | Type | Null? | Definition |
---|---|---|---|
FLAVOR_DESCRIPTION | VARCHAR(255) | N | Flavor Description for MULTUM drug product |
FLAVOR_ID | DOUBLE | N | Primary Key. This value comes from an outside source. No Sequence is used. |
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 - MLTM_FLAVOR
Parent Column in MLTM_FLAVOR (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FLAVOR_ID | MLTM_NDC_IMAGE | FLAVOR_ID |
MLTM_FREQUENCY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum frequency |
Definition: | This table contains a listing of Multum's frequency of administration terms, along with an abbreviation and a unique identifier for each term. |
Table Type: | REFERENCE |
Column Detail - MLTM_FREQUENCY
Column Name | Type | Null? | Definition |
---|---|---|---|
FREQUENCY_ABBR | VARCHAR(10) | Y | This field contains an abbreviation for the frequency of administration. For example, the frequency abbreviation for the frequency description every 4 hours is Q4H. This field is most appropriate for applications where such terms are commonly used by healthcare professionals. |
FREQUENCY_CODE | DOUBLE | N | This field contains a numeric identifier assigned to a frequency of administration. A unique identifier for rows in this table. |
FREQUENCY_DESCRIPTION | VARCHAR(255) | Y | This field contains a full text description of the frequency of administration for a drug and includes specific terms such as every 4 hours or 4 times daily. This field is most appropriate for applications that use full text descriptions for clarity or for presentation to non-professional personnel. |
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 - MLTM_FREQUENCY
Parent Column in MLTM_FREQUENCY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FREQUENCY_CODE | MLTM_SCRIPT_COMMON | FREQUENCY_CODE |
MLTM_FREQUENCY_MULTIPLIER
Column Section | Top of Page |
Table-level Detail
Description: | Multum Frequency Multiplier |
Definition: | This table assigns a multiplier defining the number of doses per day to a frequency. |
Table Type: | REFERENCE |
Column Detail - MLTM_FREQUENCY_MULTIPLIER
Column Name | Type | Null? | Definition |
---|---|---|---|
FREQUENCY_ID | DOUBLE | N | The PK column for this table. |
MULTIPLIER | DOUBLE | Y | multiplier defining the number of doses per day to a frequency. |
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. |
MLTM_FTD_HEADING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Multum FTD Heading |
Definition: | This table provides an identifier and a text description for the dosing text. |
Table Type: | REFERENCE |
Column Detail - MLTM_FTD_HEADING
Column Name | Type | Null? | Definition |
---|---|---|---|
HEADING_DESCRIPTION | VARCHAR(255) | Y | a text description for the dosing text. |
HEADING_ID | DOUBLE | N | The PK identifier for rows in this 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. |
Relationship Detail - MLTM_FTD_HEADING
Parent Column in MLTM_FTD_HEADING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | HEADING_ID | MLTM_FTD_TEXT | HEADING_ID |
MLTM_FTD_TEXT_CONDITION | HEADING_ID |