Table Detail Report
MLLD_FTD_MULTUM_CONDITION
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_FTD_MULTUM_CONDITION
Column Name | Type | Null? | Definition |
---|---|---|---|
CONDITION_DESCRIPTION | VARCHAR(255) | Y | a medical condition used in the dosing text. |
CONDITION_ID | DOUBLE | N | The PK for rows in this table. This table assigns a common name to a medical condition used in the dosing text. |
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_FTD_TEXT
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_FTD_TEXT
Column Name | Type | Null? | Definition |
---|---|---|---|
DISPLAY_ORDER | DOUBLE | N | Order of the display |
DRUG_IDENTIFIER | VARCHAR(6) | N | This field contains Multum's identification codes for generic drugs. |
HEADING_ID | DOUBLE | N | FK from FTD_HEADING |
SEQUENCE_NUMBER | DOUBLE | N | The sequence of the assembly |
TEXT_ID | DOUBLE | N | value from the Multum FTD_TEXT ID column |
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_FTD_TEXT_CONDITION
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_FTD_TEXT_CONDITION
Column Name | Type | Null? | Definition |
---|---|---|---|
CONDITION_ID | DOUBLE | N | A value from MULTUM CONDITION table |
DRUG_IDENTIFIER | VARCHAR(6) | N | This field contains Multum's identification codes for generic drugs. |
HEADING_ID | DOUBLE | N | Value from FTD_HEADING |
SEQUENCE_NUMBER | DOUBLE | N | The sequence |
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_FTD_TEXT_TYPE
Column Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_FTD_TEXT_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
TEXT_TYPE_DESCRIPTION | VARCHAR(30) | Y | additional dosage text that may be based on patient attributes. |
TEXT_TYPE_DISPLAY_ORDER | DOUBLE | Y | display order |
TEXT_TYPE_ID | DOUBLE | N | The PK for 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. |
MLLD_FUNCTION_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | D |
Definition: | DD |
Table Type: | REFERENCE |
Column Detail - MLLD_FUNCTION_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
FUNCTION_DESCRIPTION | VARCHAR(60) | Y | textual description that identifies the topic of the information stored in other tables. |
FUNCTION_ID | DOUBLE | N | Function ID. The PK 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 - MLLD_FUNCTION_TYPE
Parent Column in MLLD_FUNCTION_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | FUNCTION_ID | MLLD_DMD_NAME_MAP | FUNCTION_ID |