MYC_MESG_TOPC_DATA

Description: |
This table contains information about the topics answered by the patient in a history questionnaire submission.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
MESSAGE_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | MESSAGE_ID | VARCHAR | No |
The unique identifier for the message record.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | TOPIC_TYP_C_NAME | VARCHAR | No |
The topic type of the history questionnaire topic answered by the patient.
May contain organization-specific values: No
Category Entries:
Medical
Surgical
ADL
Substance & Sexual Activity
Tobacco
Alcohol
Drug Use
Sexual Activity
Family
Custom
Pediatric
Obstetric
Social Documentation
Socioeconomic
Dialysis
Gynecology
Lifestyle
Relationships
BH Substance Use
Vaping
Mammography
4 | TOPIC_ID | VARCHAR | No |
The ID of the history questionnaire topic answered by the patient.
5 | TOPIC_ID_RECORD_NAME | VARCHAR | No |
The name of the Visit Navigator (VN) History Template Definition (LQH) record.
6 | NUM_QUESN | INTEGER | No |
The number of questions in the history questionnaire topic answered by the patient.