EWSpecRx

The <EWSpecRx> element contains eyewear prescription information. There may be multiple <EWSpecRx> elements nested within an <EWSpecRxs> element.

Element	Description	Type	Notes
ExamRec	Exam number	int
Rx_Type	Prescription type	int	Spectacle prescription types 1 = Presenting 2 = Autorefraction 3 = Objective retin. 5 = Subjective manifest 6 = Cycloplegic 8 = Alternate prescription 9 = Final specticle prescription Contact lens prescription types 10 = Presenting 11 = Trial 15 = Sphere cyl O 16 = Shere O 19 = Final contact lens prescription
Rx_no	Rx number	int	Populated only for trials, final contact lens, and alternate spectacle prescriptions. There can be up to 10 each.
sphereOD	Sphere value (right eye)	nvarchar	Diopter
cylinderOD	Cylinder value (right eye)	nvarchar	Diopter
axisOD	Axis value for cylinder (right eye)	nvarchar
add_diopterOD	Add value (right eye)	nvarchar	Diopter
h_prismOD	Horizonatal prism value (right eye)	nvarchar	Diopter
h_BaseOD	Horizontal base (right eye)	nvarchar	I = In O = Out
v_prismOD	Vertical prism value (right eye)	Diopter
v_baseOD	Vertical base (right eye)	nvarchar	D = Down U = Up
DVAOD	Distance visual acuity (right eye)	nvarchar
NVAOD	Near visual acuity (right eye)	nvarchar
PhOD	Pin hole visual acuity (right eye)	nvarchar
OtherOD	Other notes (right eye)	nvarchar	May be blank.
sphereOS	Sphere value (left eye)	nvarchar	Diopter
cylinderOS	Cylinder value (left eye)	nvarchar	Diopter
axisOS	axis value for cylinder for left eye	nvarchar
add_diopterOS	Add value for left eye	nvarchar	Diopter
h_prismOS	horizonatal prism value for left eye	nvarchar	Diopter
h_baseOS	Horizontal base (left eye)	nvarchar	I = In O = Out
v_prismOS	Vertical prism value for left eye	nvarchar	Diopter
v_baseOS	Vertical base (left eye)	nvarchar	D = Down U = Up
DVAOS	Distance visual acuity (left eye)	nvarchar
NVAOS	Near visual acuity (left eye)	nvarchar
PhOS	Pin hole visual acuity (left eye)	nvarchar
OtherOS	Other notes (left eye)	nvarchar	May be blank.
DVAOU	Distance visual acuity both eyes	nvarchar
NVAOU	Near visual acuity (both eyes)	nvarchar
PHOU	Pin hole visual acuity (both eyes)	nvarchar
OMRxId	OfficeMate Rx ID	int	May be blank.
Exam_Date	Exam date	datetime
MonoVision	Eye dominance	real	0 = blank 1 = OD dist 2 = OD near 3 = OS dist 4 = OS near
BrandOD	Contact lens product name (right eye)	nvarchar
BrandOS	Contact lens product name (left eye)	nvarchar
ColorOD	Contact lens color (right eye)	nvarchar
ColorOS	Contact lens color (left eye)	nvarchar
BaseCurveOD	Contact lens base curve (right eye)	nvarchar
BaseCurveOS	Contact lens base curve (left eye)	nvarchar
DiameterOD	Contact lens diameter size (right eye)	nvarchar
DiameterOS	Contact lens diameter size (left eye)	nvarchar
SoftOMRxId	Soft lens OfficeMate Rx ID	int
RigidOMRxId	Rigid lens OfficeMate Rx ID	int
PrescriptionDate	Prescription date	nvarchar
ExpirationDate	Prescription expiration date	nvarchar
LensTypeOD	Contact lens type (right eye)	nvarchar	For example, rigid bitoric, soft sphere, etc.
LensTypeOS	Contact lens type (left eye)	nvarchar	For example, rigid bitoric, soft sphere, etc.
notes	Prescription notes	ntext	Manually entered text.
UsageCode	Usage code	int	For example, driving, distance, etc.
QtyOD	Quantity of lenses (right eye)	int
QtyOS	Quantity of lenses (left eye)	int
SegHtOD	Seg height for contact lens (right eye)	nvarchar
SegHtOS	Seg height for contact lens (left eye)	nvarchar
BaseCurve2OD	Second base curve for hard lens (right eye)	nvarchar
BaseCurve2OS	Second base curve for hard lens (left eye)	nvarchar
Sphere2OD	Secondary sphere value for hard lens (right eye)	nvarchar
Sphere2OS	Secondary sphere value for hard lens (left eye)	nvarchar
CenterThicknessOD	Hard lens center thickeness (right eye)	nvarchar
CenterThicknessOS	Hard lens center thickeness (left eye)	nvarchar
OpticZoneOD	Hard lens optical zone (right eye)	nvarchar
OpticZoneOS	Hard lens optical zone (left eye)	nvarchar
Radius2OD	Hard lens second radius (right eye)	nvarchar
Radius2OS	Hard lens second radius (left eye)	nvarchar
Width2OD	Hard lens second width (right eye)	nvarchar
Width2OS	Hard lens second width (left eye)	nvarchar
Radius3OD	Hard lens third radius (right eye)	nvarchar
Radius3OS	Hard lens third radius (left eye)	nvarchar
Width3OD	Hard lens third width (right eye)	nvarchar
Width3OS	Hard lens third width (left eye)	nvarchar
lens_SKU_numOD	Soft lens SKU (right eye)	nvarchar
lens_SKU_numOS	Soft lens SKU (left eye)	nvarchar
labSpecialInstr	Lab instructions	ntext
Diameter2OD	Hard lens diameter 2 (right eye)	nvarchar
Diameter2OS	Hard lens diameter 2 (left eye)	nvarchar
Cylinder2OD	Hard lens cylinder 2 (right eye)	nvarchar
Cylinder2OS	Hard lens cylinder 2 (left eye)	nvarchar
Axis2OD	Axis value 2 for cylinder 2 for (right eye)	nvarchar
Axis2OS	Axis value 2 for cylinder 2 for (left eye)	nvarchar
PCRadiusOD	Hard lens Peripheral Curve radius (right eye)	nvarchar
PCRadiusOS	Hard lens Peripheral Curve radius (left eye)	nvarchar
PCWidthOD	Hard lens Peripheral Curve width (right eye)	nvarchar
PCWidthOS	Hard lens Peripheral Curve width (left eye)	nvarchar
Radius2OD2	Hard lens radius 2 for (right eye) 2	nvarchar
Radius2OS2	Hard lens radius 2 for (left eye) 2	nvarchar
Width2OD2	Hard lens width 2 for (right eye) 2	nvarchar
Width2OS2	Hard lens width 2 for (left eye) 2	nvarchar
Radius3OD2	Hard lens radius 3 for (right eye) 2	nvarchar
Radius3OS2	Hard lens radius 3 for (left eye) 2	nvarchar
Width3OD2	Hard lens width 3 for (right eye) 2	nvarchar
Width3OS2	Hard lens width 3 for (left eye) 2	nvarchar
PCRadiusOD2	Hard lens peripheral curve radius (right eye) 2	nvarchar
PCRadiusOS2	Hard lens Peripheral Curve radius (left eye) 2	nvarchar
PCWidthOD2	Hard lens peripheral curve width (right eye) 2	nvarchar
PCWidthOS2	Hard lens peripheral curve width (left eye) 2	nvarchar
BlendCdOD	Blend code (right eye)	int	270 = light 271 = medium 272 = heavy
BlendCdOS	Blend coe (left eye)	int	270 = light 271 = medium 272 = heavy
DOT	Lens dot	smallint	1 = right eye 2 = left eye 3 = no selection or no dot
EdgeThicknessOD	Hard lens edge thickness (right eye)	nvarchar
EdgeThicknessOS	Hard lens edge thickness (left eye)	nvarchar
Rx_Notes	Rx notes	ntext
RecordedDate	Date entry was made in exam	datetime