Table: Orders
Order details for Eyeglass, Contact Lens, Exam, and Miscellaneous orders
| Name | Type | Description | Remarks |
|---|---|---|---|
| ORDER_STATUS_CANCELED | |||
| ORDER_STATUS_DELAYED | |||
| ORDER_STATUS_DELIVERED | |||
| ORDER_STATUS_HOLD | |||
| ORDER_STATUS_HOLDFROMLAB | |||
| ORDER_STATUS_INVOICED | |||
| ORDER_STATUS_NOTIFIED | |||
| ORDER_STATUS_PRICED | |||
| ORDER_STATUS_READY | |||
| ORDER_STATUS_RECEIVED | |||
| ORDER_STATUS_REMADE | |||
| ORDER_STATUS_RETURNED | |||
| ORDER_STATUS_VOIDED | |||
| ORDER_STATUSCODE | |||
| ORDER_TYPE_EXAM | |||
| ORDER_TYPE_EYEGLASS | |||
| ORDER_TYPE_HARD_CONTACT | |||
| ORDER_TYPE_MISCELLANEOUS | |||
| ORDER_TYPE_SOFT_CONTACT |
| Name | Type | Description | Remarks |
|---|---|---|---|
| Associate |
int |
The Sales Associate for the order. This is a key to the Employee table. |
|
| ClaimBilled |
bool |
Indicates whether this order has had its insurance claim created |
If the insurance claim has been created for this order, this will be true |
| CustomerID |
int |
The Patient for the order. This is a key to the Patient table. |
|
| DCLabOfficeNum |
varchar(8) |
Indicates the Office Number providing the frame when the Frame Status is set to Provided By |
|
| DeliveryDate |
datetime |
Date and time the order was set to Delivered |
|
| DiagCode1 |
int |
Diagnosis Code 1 |
This is a foreign key to the DiagCode table |
| DiagCode10 |
int |
Diagnosis Code 10 |
This is a foreign key to the DiagCode table |
| DiagCode11 |
int |
Diagnosis Code 11 |
This is a foreign key to the DiagCode table |
| DiagCode12 |
int |
Diagnosis Code 12 |
This is a foreign key to the DiagCode table |
| DiagCode2 |
int |
Diagnosis Code 2 |
This is a foreign key to the DiagCode table |
| DiagCode3 |
int |
Diagnosis Code 3 |
This is a foreign key to the DiagCode table |
| DiagCode4 |
int |
Diagnosis Code 4 |
This is a foreign key to the DiagCode table |
| DiagCode5 |
int |
Diagnosis Code 5 |
This is a foreign key to the DiagCode table |
| DiagCode6 |
int |
Diagnosis Code 6 |
This is a foreign key to the DiagCode table |
| DiagCode7 |
int |
Diagnosis Code 7 |
This is a foreign key to the DiagCode table |
| DiagCode8 |
int |
Diagnosis Code 8 |
This is a foreign key to the DiagCode table |
| DiagCode9 |
int |
Diagnosis Code 9 |
This is a foreign key to the DiagCode table |
| ExpectDate |
datetime |
Order promise by date |
|
| InvoiceStatus |
varchar(1) |
This field is no longer used |
|
| Is_Abnormal_Pupil |
bit |
True if exam attached to order has Abnormal Pupil set to Yes |
|
| Is_ARCUS |
bit |
True if exam attached to order has ARCUS set to Yes |
|
| Is_ARMD |
bit |
True if exam attached to order has ARMD set to Yes |
|
| Is_Cataract |
bit |
True if exam attached to order has Cataract set to Yes |
|
| Is_Diabetes |
bit |
True if exam attached to order has Diabetes set to Yes |
|
| Is_Diabetic_Retinopathy |
bit |
True if exam attached to order has Diabetic Retinopathy set to Yes |
|
| Is_Glaucoma |
bit |
True if exam attached to order has Glaucoma set to Yes |
|
| Is_Hypercholesterol |
bit |
True if exam attached to order has Hypercholesterol set to Yes |
|
| Is_Hypertension |
bit |
True if exam attached to order has Hypertension set to Yes |
|
| Is_PCPForm |
bit |
True if exam attached to order has PCP Form set to Yes |
|
| IsDilationPerformed |
bit |
True if exam attached to order has Dilation Performed set to Yes |
|
| Lab |
varchar(8) |
The Lab for the order. This is a key to the Labs table. |
This field will be set only for Eyeglass orders. |
| LabInstructions |
varchar(200) |
Lab Instructions |
|
| LabJobID |
varchar(20) |
The Lab ID of the order sent from the remote Lab Management System |
This field is updated by the Update Order Status integration for certain lab system integrations |
| LabOrderWorkflowID |
int |
This is a foreign key to WFInstance table |
This is a pointer to the Workflow data for the order |
|
Lenspkg |
int |
Package used on the order |
This is a foreign key to the Package table |
| MakeTypeID |
int |
This field is not used |
|
| MiscOrderWorkflowID |
int |
This is a foreign key to WFInstance table |
This is a pointer to the Workflow data for the order |
| NumberOfRemakes |
int |
This field is no longer used |
|
| OfficeNumber |
varchar(8) |
The Office Number for the order. This is a key to the Office table. |
|
| OldSystemReturn |
bit |
Indicates if the order is an Old System Return |
Old System Return is entered under the Transactions tab. These orders will have this flag set to True. |
| OrderAttributes | |||
| OrderDate |
datetime |
Date and time the order was created |
|
| OrderTime | Obsolete field - see OrderDate |
||
| OrderType |
varchar(1) |
The Order Type: "E" for Eyeglass, "S" for Soft Contacts, "H" for Hard Contacts, "M" for Miscellaneous, "X" for Exam |
|
| PatientEhrExamOnlyId |
int |
This field is no longer used |
|
| PhoneOrder |
bit |
This field is no longer used |
|
| PreliminaryEligibilityId |
int |
This field is no longer used |
|
| ProcessDate |
datetime |
Date and time the order was set to ready for processing |
|
| ReceiptComments |
varchar(200) |
The receipt comments entered on the Order Pricing screen |
|
| Remake |
bool |
Flag indicating if this order is a remake of another order |
This will be true if the order is a remake of another order. The RemakeOrder column will contain the original order number. |
| RemakeOrder |
int |
The original order number if this order is a remake |
This field will be populated only for remake orders |
| RemakeTypeID |
int |
The Remake reason code if the order is a remake |
This is a foreign key to RemakeType table |
| ServiceLocationID |
int |
Service Location for the order if service location functionality is being used |
Foreign key to the ServiceLocation table |
| ShipTo |
int |
Ship To Address for order |
This is a foreign key to the Address table |
| ShipToType |
int |
Designates where the order will be shipped to: 1=This Office, 2=Another Office, 3=Mail to Patient |
This is a foreign key to ShipToType table |
| StatusCode |
varchar(3) |
The current status of the order |
"H" - Hold |
| StatusCodeChangedDate |
datetime |
The date and time the status was changed |
|
| VendorOrderStatus |
int |
The Vendor Order status for this order when auto replenishment is being used |
1 = Open 2 = Printed 3 = Canceled 4 = Re-opened 5 = Partially received 6 = Fully received 7 = Ready to send 8 = Sent 9 = Error |