EWExamTran

The <EWExamTran> element contains data related to exam transactions. There may be multiple <EWExamTran> elements nested within an <ExamTrans> element.

Element	Description	Type	Notes
RecId	transaction record number	int
ExamNo	Exam number	int
RecType	Record type	nvarchar	For example, impression, ROS, social history.
RecText	Record text	nvarchar	If populated, will contain eRx medication name, A1c result, CD ratio, smoking SNOMED, confrontation field results, field studies results. Multiple values will be seperated by a pipe.
RecDate	Date stamp of entry	datetime
Category	Activity category	nvarchar	CPT code if RecType is procedure. ICD-10 or ICD-9 if rRecType is diagnosis. Diagnosis includes laterality.
RecMemo	Exam notes	nvarchar	Manually typed notes
Diag	Diagnosis code	nvarchar	ICD-10 or ICD-9, depending on date of service. Multiple values will be seperated by a pipe.
ProdNo	Type of exam performed	nvarchar	No medical value.
PQRICodes	Level II CPT codes	nvarchar	Dilate will be in this field, if patient was dilated. Multiple values will be seperated by a pipe.
SNOMED	SNOMED code	nvarchar	Associated with RecType. Multiple values will be seperated by a pipe.
RxNormId	Medication RxNorm ID	nvarchar	Associated with prescribed medication.
LOINC	LOINC code	nvarchar	Associated with RecType.
LOINC_RT	LOINC (right side/eye) code	nvarchar	Associated with RecType.
LOINC_LT	LOINC (left side/eye) code	nvarchar	Associated with RecType.