PAT_MYC_HX_QTNRS
Description:
The PAT_MYC_HX_QTNRS table contains the history questionnaire templates associated with this encounter.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
A unique serial number for this encounter. This number is unique across all patients and encounters in the system.
2 LINE INTEGER No
The line count used to identify different lines of history questionnaires for each encounter.
3 PAT_ENC_DATE_REAL FLOAT No
This is a numeric representation of the date of this encounter in your system. The integer portion of the number specifies the date of the encounter. The digits after the decimal point indicate multiple visits on one day.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 HX_QTNRS_ID VARCHAR No
The unique IDs of the history questionnaire template records associated with this encounter.
6 HX_QTNRS_ID_RECORD_NAME VARCHAR No
The name of the Visit Navigator (VN) History Template Definition (LQH) record.
7 CM_CT_OWNER_ID VARCHAR No
ID of the deployment owner for this contact.