FrameRx
The <FrameRx> element contains data relative to glasses, or eyewear, prescriptions. There may be multiple <FrameRx> elements nested within an <RxSection> element.
| Element | Description | Type | Notes |
|---|---|---|---|
| rx_id | rx ID | int | key data |
| patient_id | patient ID | int | |
| rx_usage_cd | usage code | int | |
| frame_sku_cd | frame UPC code | nvarchar | |
| vendor_cd | vendor code | int | |
| color_cd | frame color code | nvarchar | |
| eye_size_mm | eye size | real | Millimeters. Numbers recorded in scientific notation value |
| temple_length_mm | temple length | smallint | Millimeters |
| pantoscopic_angle_deg | pantoscopic angle | smallint | 0–180 degrees |
| dist_pupil_dist_mm | distance pupil distance mm scientific notation | real | scientific notation value |
| near_pupil_dist_mm | near pupil distnace mm scientific notation | real | scientific notation value |
| lens_tint_cd | tint code | int | |
| solid_or_gradient_tint_cd | nvarchar | ||
| lens_notes_mem | special lab instructions - free text | ntext | |
| rx_entry_date | date rx was entered | datetime | |
| designer_cd | designer ID | nvarchar | |
| last_update_ts | date the Rx was last updated | datetime | |
| rx_order_cd | rx order code | int | 447 Dispensed to patient 448 At lab 917 Patient notified awaiting pick up 1531 Lab Received 1653 Product Received |
| Dispensed_By_Date | date product dispensed to patient | datetime | |
| redo_OrigDate | redo product date | datetime | |
| Frame_name | frame name | nvarchar | |
| Rx_Notes | rx notes that print on walk out Rx - free text | ntext | |
| feeslip_no | bill number | int | |
| providerNo | provider ID number | int | |
| examNo | exam number from ExamWriter | int | |
| Redo_Reason | redo reason code | int | |
| Date_of_Service | date of service | datetime | |
| internal_rx_notes | notes internal to office - free text | ntext | |
| head_cape | head size mm or inches | real | scientific notation value |
| he_ratio | head/eye movement ratio | real | scientific notation value |
| wrap | frame wrap measement | real | scientific notation value |
| stability | stability | real | scientific notation value |
| panto | pantoscopic tilt measurement | real | scientific notation value |
| vertex | vertex distance measurement | real | scientific notation value |
| LeftLens | left lens measurements | element | Contains FrameLensRx data |
| RightLens | right lens measurements | element | Contains FrameLensRx data |