DOCS_RCVD_EYE_EXAM_FIELDS
Description:
This table stores external Eye Exam information received from DXR.

Primary Key
Column Name Ordinal Position
DOCUMENT_ID 1
CONTACT_DATE_REAL 2
LINE 3

Column Information
Name Type Discontinued?
1 DOCUMENT_ID NUMERIC No
The unique identifier (.1 item) for the document record.
2 CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3 LINE INTEGER No
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
5 EYE_EXM_FIELD_REF_IDENT VARCHAR No
The unique identifier for an eye exam field.
6 EYE_EXM_FIELD_DOCUMENT_CSN_ID NUMERIC No
The contact serial number (CSN) associated with the source document that contained this eye exam field.
7 EYE_EXM_FIELD_ASSOC_EVNT_IDENT VARCHAR No
Reference ID of the associated event (links to I DXR 8010).
8 EYE_EXM_FIELD_CONCEPT_ID VARCHAR No
The SmartData Identifier (SDI) associated with the eye exam field.
9 EYE_EXM_FIELD_INST_UTC_DTTM DATETIME (UTC) No
The instant that the value of the eye exam field was saved.
10 EYE_EXM_FIELD_FROM_EYE_EXAM_YN_NAME VARCHAR No
Whether or not the value of the eye exam field was recorded in the eye exam.
May contain organization-specific values: No
Category Entries:
No
Yes
11 EYE_EXM_EYE_FLD_VA_SCALE_C_NAME NUMERIC No
Which visual acuity scale should be used to interpret numeric values if this eye exam field represents a visual acuity value.
May contain organization-specific values: No
Category Entries:
Do not convert numeric data
Convert as decimal notation data
Convert as logMAR data
Convert as letter score data
Convert as decimal notation or letter score data
Convert as logMAR or letter score data