V_OrdersRXDetail

The V_OrdersRXDetail view displays data for all orders that contain prescription information. Each row describes the lab order and prescription for an individual eye. Since the view includes lab orders by date, expired orders and prescriptions may be displayed. You can filter the data by the order date.

The view contains the following data:

Column Heading	Unique to SQL Database	Description
OrderNum		The lab order number.
OrderDate		The date of the lab order.
CustomerID	Y	Unique ID for the customer.
LastName		Patient’s last name.
FirstName		Patient’s first name
MedicalRecordNum		The Patient ID number displayed on the patient profile.
Age		Patient’s age.
Sphere Cylinder Axis		Patient’s Rx for the eye identified in the Eye column.
Eye		1 = right eye 2 = left eye
OrderType		E = eyeglasses S = soft contact lenses H = hard contact lenses
DiagCode1 DiagCode2 DiagCode3 DiagCode4		Diagnosis codes recorded on the Rx.
CompanyID		Company ID of the company that created the lab order.
Officenum		Office number of the office where the lab order was created.

Here is an example of the V_OrdersRXDetail view imported into a spreadsheet:

Related Topics

• Reporting Views of the AcuityLogic SQL Database
• AcuityLogic Admin