Overview:
The Remote Order Entry process allows a third-party program to create an ASCII file for Rx-Universe, containing information necessary to order an Rx from the lab. This file uses the VCA convention for data transfers, with additional labels defined by Rx-Universe for fields not directly supported by the VCA device standard. These additional labels will have a suffix of an underscore “_”; for example “_FIRSTNAME”.
Rx-Universe can also create a status file which the third-party software can retrieve to obtain the status of each of the site’s job in the lab. The lab would need the Rx-Tracker module installed to accomplish this task. Figure I-1 shows this process.
This document will explain what codes you need to send to Rx-Universe, the format in which the request/orders will need to be sent to Rx-Universe and how to interpret the information that Rx-Universe sends back.
Figure 1-1
Rx-Universe Inbox (for incoming orders into the lab)
Information (RAW files) coming from the retail site will be stored in a folder determined by the lab which is located on the lab’s server. The most common method of file transfer from a retail site to the lab is via ftp, where the default folder for the ftp transfer will point to the appropriate folder. By default the folder is “OMICSTX” a subfolder of the “RXUNIVERSE” folder on the lab’s server. For example “C:\RXUNIVERSE\OMICSTX”.
Rx-Universe Outbox (for outgoing status results)
Information that is sent back from Rx-Universe will be located in this directory, which is usually called “OMICSRX” – this is usually a subfolder below the default “RXUNIVERSE” folder on the lab’s server. For example “C:\RXUNIVERSE\OMICSRX”. Under this folder there is a folder for each customer, the folder name will be the account number, this is where the retail site will have to pick up the status files.
- For example “C:\RXUNIVERSE\OMICSRX\acount_number”:
- “C:\RXUNIVERSE\OMICSRX\1”.
- “C:\RXUNIVERSE\OMICSRX\0025”.
- “C:\RXUNIVERSE\OMICSRX\1234”.
Naming Conventions
There are naming conventions that are used for every document Rx-Universe either sends or receives and the directories they are stored in. Each of these naming conventions will be explained as we get into detail about each document.
Sending Orders from a Third-Party Software
File Name:
The naming convention that is used for the order file is very important. The retailer will need to get their account number from the lab and store it somewhere in their system, since it is used in the flat file (RAW File) name.
The format of the filename is Account Number.V + sequence number (2 to 4 digits)
Example:
If the account number is “002” and this is the first order that they are sending, the text file name would be “002.V01” or “002.V0001”
The second file would be “002.V02” or “002.V0002” ... and so on. Once the sequence number reaches its upper limit, the sequence number should restart from the beginning; for example, after “002.V9999” it should be “002.V0001”.
Steps in sending an Order to the lab:
Generate ASCII text file (RAW File) for every order that has not been sent.
Send the ASCII text file(s) (RAW File) to the lab.
ASCII File Format (RAW File):
Each line in the ASCII file must have at least two parameters, the first parameter being the field name (label), the second parameter the field value. These parameters must be separated by an equal sign “=”. Each field must go on a different line. Field names with no underscore “_” at the beginning of its name are VCA Labels. For more detail information on VCA Labels, reference the VCA Data Communication Standard documentation.
Some fields you have to send a right value and a left value, separated by a semi-colon. These fields are indicated by an eyeglass symbol ($), see the legend (these are known as chiral fields in VCA convention). Here is an example:
FIELDNAME=RightData;LeftData
SPH=-1.25;-0.75
If you are only sending Left eye information, you still have to include the semi-colon before the field value:
FIELDNAME=;LeftData
SPH=;-0.75
General Information
Field Name | Reqd | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|
_CUSTNO | O | String | 09 | Account Number |
|
JOB | R | String | 21 | Job number from retail | This information is saved in the “PO#” field. |
_INV | O | String | 08 | Invoice number | Use this field if you want to keep the same Invoice Number as |
_OMICS_TRAY_NUM | O | String | 06 | Tray Number | Use this field if you want to keep the same Tray Number as
|
_JTYPE | R | String | 01 | Job Type | Valid Values: |
PATIENT | R | String | 21 | Patient Name | This field is not needed if you are using the “_FIRSTNAME” and |
_FIRSTNAME | R | String | 21 | First name of patient | Use either PATIENT or combination of first and last name |
_LASTNAME | R | String | 21 | Last name of patient | Use either PATIENT or combination of first and last name |
_RDATE | O | String | 08 | Date Ordered | YYYYMMDD |
_WDATE | O | String | 08 | Date Wanted | YYYYMMDD |
_OPT_WDATE | O | String | 8 | Optional date wanted | YYYYMMDD |
REF | O | String | 18 | Release Number |
|
SHIPTO | O | String | 10 | Ship to Number | Each part separated by a comma. |
REM | O | String | 30 | Remarks or Special Instructions.
| Can have up to 11 comment lines. |
_CALLFST
| O | String | 01 | Call first before processing. | Valid Entries are: |
_REMAKECODE | O | String | 04 | Remake code | An entry in this field sets the REDO flag on the order and |
_RUSH_JOB | O | String | 01 | Set Rush indicator on order | Valid Entries are: |
_DOCTOR_ID | O | String | 30 | Doctor’s name | |
_ORD-ORIG_INVOICE | O | String | 08 | Used to send the original invoice number when sending a remake job | |
_REMAKE_CAT | O | String | 04 | Used to send the remake category | |
_PRLIST | O | String | 03 | Price list number. | Specify to force pricing to a certain lab price list. |
_TRAY_COLOR | O | String | 03 | Used to override the tray color that would normally be associated |
|
_LAYOUT | O | String | 01 | Indicates whether frame measurements should be considered exact, | Valid Entries are: |
_UNCUTDIAM | O | Numeric | 05 | Diameter to use for thickness for uncut job | Value >= 0 and <= 99.9 |
_USER_DEF_JF | C | String | 10 | User Define Job Flow Labels. |
|
Rx And Lens Information
Field Name | Reqd | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|
DO | R | String | 01 | Which eye | Valid Values: |
_LSTYLE | C | String | 06 | If _LCODE not specified, this field specifies the lab code for the lens style being ordered |
|
_MATERIAL | C | String | 02 | If _LCODE not specified, this field specifies the lab code for the lens material being ordered |
|
_TREAT | C | String | 03 | If _LCODE not specified, this field specifies the lab code for the treatment of the lens | This is the Pretreatment that comes already on the lens from the manufacturer. |
_TINT | C | String | 03 | If _LCODE not specified, this field specifies the lab code for the tint of the lens | This is the Tint (Color) that comes already on the lens from the manufacturer |
_LCODE | C | String | 02 | Lens Material | Refer to catalogue reference, under the lens section. This is the code from the catalogue |
SPH +/- | R | Numeric | 05 | Rx Sphere Power | 99.99 |
CYL +/- | O | Numeric | 05 | Rx Cylinder Power | 99.99 |
AX | C | Integer | 03 | Prescribed Cylinder Axis. | 999 |
IPD | R | Numeric | 03 | Far PD: The far interpupillary distance for Multifocals and can be entered as
| Valid range values: |
NPD | C | Numeric | 03 | Near PD or Vertical Decentration:
| Valid range values: For SV-Style lenses, this field represents the distance above or below the datum of the OC. |
OCHT | O | Numeric | 04 | Vertical O.C. height measured from the lower boxes tangent of the frame. |
|
ADD | C | Numeric | 04 | The add power of the multifocal segment | 99.99 |
ADD2 | C | Numeric | 04 | The add power of the upper segment in an occupational lens | 99.99 |
SEGHT | C | Numeric | 03 | Segment Height | Ex: SEGHT=19;19 |
PRVM +/- | O | Numeric | 04 | Rx Prism in diopters | 99.99 |
PRVA | C | String | 03 | Rx Prism direction | Ex: |
ELLH | O | Numeric | 02 | Elliptical Cribbing | Ex: ELLH=62;62 |
_SUPELLH | O | String | 01 | Suppress Elliptical Cribbing | Valid Values are: |
THNP | O | Numeric | 03 | Requested Thickness | Ex: THNP=1.5;1.5 |
_PRTHIN | O | String | 01 | Prism Thinning | Valid Entries Are: |
_ADDON | O | String | 06 | Add-on Codes | Codes specified by receiving lab or from catalogue. |
CLASS | O | String String | 03 03 | To force Finished (Stock) or Semi-Finish lenses per eye | Valid Values |
_FORCESF_F | O | String | 01 | To force Semi-Finish or Finished (Stock) lenses on your job | Valid Values: |
_RFRONT | O | String | 04 | Requested Nominal Front Curve | Ex: _RFRONT=0400;0400 |
_RDIA | O | Numeric | 02 | Requested Blank (Lens) Diameter | Ex: _RDIA=76;76 |
_LMFRID | O | String | 04 | Lens Manufacturer | If you want to force Rx-Universe to select a lens from a certain manufacturer |
OPC | O | Numeric | 10 | Lens OPC Code | Select lenses by OPC codes |
SWIDTH | C | Numeric | 02 | Segment Width | Ex:_SWIDTH=28;28 |
SDEPTH | C | Numeric | 02 | Segment Depth of the Intermediate Segment. Required only for Trifocal lenses | Ex:SDEPTH=08;08 |
LNAM | O | String | 23 | VCA Label Translation |
|
LTYP | O | String | 23 | VCA Label Translation |
|
LMATTYPE | O | String | 23 | VCA Label Translation |
|
HBOX | C | Numeric | 03 | Horizontal box lens size of the frame. This is the “A” measurement | Valid range of values is from 30.0 to 80.0 mm |
VBOX | C | Numeric | 03 | Vertical boxes lens size of the frame. This is the “B” measurement. | Valid range of values is from 15.0 to 60.0 mm |
_EDBOX | C | Numeric | 03 | “ED” measurement of the box measurement system. The widest possible | Valid range of values is from 30.0 to 80.0 mm |
DBL | R | Numeric | 03 | Distance Between Lenses | Valid range of values is from 7.0 to 30.0 mm |
ETYP | O | String | 01 | Type of edge to cut on lens. | Valid Entries are: |
SFTHK | O | String | 01 | This field needs to be placed after the “ETYP” field | Y = Safety Thickness |
FTYP | O | String | 01 | Frame Type | Valid Entries are: |
_TRACE | O | String | 12 | Trace Number | Rx-Universe will look into the Pattern Database for a Frame Name matching |
_CCIRC | O | Numeric | 04 | You can specify the actual circumference of the customer’s frame. | Ex: CIRC=138.4
|
_WRAP | O | String | 01 | To take advantage of the Wrap Frame Calculation. | Valid Entries are: |
ZTILT | O | Numeric | 03 | Panoramic (Wrap) Angle | Valid range of values is from 0 to 30.0 degrees |
PANTO | O | Numeric | 03 | Pantoscopic (Angle) Tilt | Valid range of values is from 0 to 30.0 degrees |
BVD | O | Numeric | 03 | Vertex Fitting. Back vertex distance, as worn (mm) | Valid range of values is from 5 to 30 mm |
RVD | O | Numeric | 03 | Refracted Vertex Distance - Back vertex distance, as refracted (mm) | Valid range of values is from 5 to 30 mm
|
TRCFMT | O | Numeric | 01 | Format of frame trace data | Valid Entries are: |
|
| Number | 04 | Number of radii in the trace |
|
|
| String | 01 | Radius mode identifier | Valid Entries are: |
|
| String | 01 | Which eyes are included | Valid Entries are: |
ZFMT | O | Numeric | 01 | Format of vertical height frame trace data | Valid Entries are: |
|
| Number | 04 | Number of radii in the trace |
|
|
| String | 01 | Radius mode identifier | E – the radii are evenly spaced |
|
| String | 01 | Which eyes are included | R – Right |
R | C | Numeric | 05 | Radius Data | Separate values for this field by a semi-colon “;” such as: |
A
| C | Numeric | 05 | Angle data for radius data (angular locations of trace radii expressed | Separate values for this field by a semi-colon “;” such as: |
Z | C | Numeric | 05 | Radius Data | Separate values for this field by a semi-colon “;” such as: |
Optional Fields
Field Name | Reqd | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|---|
CLINIT |
| String |
| Wearer’s Initials |
|
CLHT |
| Numeric |
| Client Height in meters |
|
HEADK |
| Numeric |
| Head Eye Coefficient |
|
HEADS |
| Numeric |
| Stability Coefficient |
|
_NVI |
|
|
| Near Vision Inset |
|
NWD |
| Numeric |
| Near Working Distance |
|
ERCD |
| Numeric |
| Eye Rotation Center Distance |
|
CAPE |
| Numeric |
| Cape Head Angle |
|
_LP |
|
|
| Progression Length |
|
DMNTEYE |
|
|
| Dominant Eye |
|
_CLLAT |
|
|
| Laterality (Dominant Head) | Valid Entries are: |
NOD |
| Numeric |
| Refracted object distance at near viewing point (meters) |
|
This ASCII text file will be generated at the retail site and be sent to the lab from which they are placing their order. The following is an example of items you can find in an order file (RAW file):
PATIENT="JOHNNY WISHBONE"
_RDATE=20150120
_WDATE=20150125JOB="7430004"
_INV="7430004"
REM="PLEASE SHIP UPS"
DO=B
_JTYPE=1
_LSTYLE=SV;SV
_MATERIAL=P;P
SPH=+01.00;+02.25
CYL=-01.00;-01.00
AX=88;159
IPD=30.0;29.0
HBOX=62.5
VBOX=39.4
DBL=16.0
FTYP=2
ETYP=1
TRCFMT=1;400;E;R;F
R=2559;2567;2575;2584;2593;2601;2611;2620;2628;2638;2646;2655;2664;2672;2681
R=2690;2699;2707;2715;2723;2730;2736;2743;2747;2751;2753;2755;2756;2755;2755
R=2754;2753;2750;2746;2741;2737;2732;2726;2718;2711;2703;2694;2685;2675;2666
R=2656;2645;2634;2623;2611;2599;2587;2575;2563;2552;2539;2527;2514;2502;2490
R=2479;2468;2455;2443;2431;2419;2408;2396;2386;2375;2365;2355;2345;2336;2329
R=2321;2312;2304;2297;2292;2285;2279;2274;2269;2264;2260;2257;2253;2250;2247
R=2245;2243;2242;2241;2240;2240;2239;2239;2239;2241;2243;2245;2248;2251;2255
R=2258;2263;2268;2273;2278;2284;2290;2296;2303;2311;2318;2326;2334;2343;2353
R=2363;2374;2384;2395;2405;2417;2429;2441;2454;2468;2480;2493;2506;2516;2526
R=2547;2556;2571;2585;2598;2611;2625;2637;2650;2662;2671;2684;2693;2703;2711
R=2720;2726;2732;2735;2739;2741;2745;2746;2749;2750;2750;2750;2750;2749;2746
R=2743;2739;2734;2729;2723;2719;2712;2706;2701;2697;2692;2688;2682;2676;2671
R=2666;2660;2656;2652;2648;2644;2642;2639;2637;2635;2633;2630;2628;2626;2624
R=2622;2620;2619;2618;2617;2617;2617;2617;2618;2618;2619;2621;2622;2625;2627
R=2629;2632;2636;2639;2643;2646;2650;2654;2658;2661;2665;2668;2672;2675;2678
R=2680;2682;2683;2684;2686;2690;2693;2696;2698;2700;2701;2701;2701;2702;2702
R=2700;2697;2694;2690;2686;2682;2677;2671;2666;2659;2652;2644;2635;2625;2615
R=2605;2595;2583;2572;2561;2549;2539;2528;2516;2503;2491;2481;2471;2458;2447
R=2436;2425;2414;2405;2395;2386;2378;2370;2362;2355;2347;2340;2331;2324;2317
R=2310;2303;2298;2293;2288;2283;2278;2274;2269;2265;2262;2260;2257;2254;2251
R=2248;2245;2243;2242;2240;2239;2238;2238;2237;2237;2237;2237;2237;2237;2237
R=2237;2237;2238;2238;2239;2239;2240;2242;2243;2244;2246;2249;2251;2253;2255
R=2258;2260;2263;2265;2268;2271;2273;2276;2278;2281;2283;2284;2286;2288;2291
R=2292;2295;2296;2299;2300;2302;2304;2305;2307;2310;2312;2313;2315;2317;2319
R=2321;2324;2325;2328;2331;2335;2337;2340;2343;2347;2350;2355;2359;2363;2370
R=2375;2379;2385;2391;2397;2403;2409;2414;2421;2429;2435;2443;2449;2457;2464
R=2472;2481;2489;2498;2506;2516;2525;2533;2542;2550
TRCFMT=1;400;E;L;F
R=2547;2547;2548;2548;2549;2550;2550;2551;2552;2553;2553;2554;2556;2557;2557
R=2559;2560;2561;2562;2564;2565;2566;2567;2569;2570;2572;2574;2576;2578;2580
R=2582;2584;2586;2588;2590;2591;2593;2595;2597;2599;2602;2604;2606;2608;2610
R=2612;2614;2616;2618;2619;2620;2623;2625;2628;2631;2634;2637;2639;2637;2630
R=2619;2605;2590;2575;2558;2543;2530;2517;2503;2489;2475;2462;2447;2435;2424
R=2410;2399;2386;2375;2363;2352;2342;2333;2323;2314;2307;2299;2291;2284;2277
R=2272;2266;2261;2255;2250;2246;2242;2239;2236;2233;2233;2230;2229;2229;2229
R=2229;2229;2231;2232;2234;2236;2238;2242;2246;2249;2254;2259;2264;2269;2274
R=2280;2286;2292;2299;2307;2315;2323;2332;2342;2351;2361;2369;2379;2388;2398
R=2408;2417;2428;2439;2450;2460;2471;2482;2493;2505;2516;2527;2538;2549;2560
R=2570;2580;2591;2601;2610;2619;2627;2636;2644;2651;2658;2665;2672;2679;2684
R=2689;2692;2695;2697;2697;2698;2697;2696;2695;2692;2689;2685;2680;2674;2668
R=2660;2653;2643;2635;2627;2618;2610;2601;2593;2584;2575;2566;2557;2546;2537
R=2528;2518;2509;2499;2490;2480;2471;2462;2452;2444;2435;2426;2417;2409;2400
R=2392;2384;2377;2370;2363;2357;2351;2345;2340;2336;2331;2326;2322;2316;2312
R=2306;2302;2297;2293;2290;2286;2283;2280;2277;2274;2272;2268;2266;2263;2261
R=2258;2256;2253;2250;2248;2246;2243;2242;2240;2237;2236;2233;2232;2230;2227
R=2226;2224;2222;2221;2219;2217;2215;2215;2214;2212;2212;2210;2208;2207;2205
R=2205;2203;2201;2200;2198;2196;2194;2194;2192;2191;2191;2190;2191;2190;2191
R=2191;2191;2193;2194;2195;2197;2198;2198;2202;2204;2208;2209;2213;2215;2218
R=2222;2226;2230;2235;2239;2244;2249;2254;2260;2266;2272;2277;2284;2291;2298
R=2306;2314;2323;2332;2340;2348;2357;2368;2377;2387;2394;2405;2414;2424;2434
R=2444;2456;2468;2477;2490;2501;2511;2525;2536;2548;2559;2569;2580;2593;2603
R=2614;2617;2615;2611;2607;2604;2602;2599;2597;2594;2592;2590;2588;2586;2584
R=2581;2579;2578;2576;2574;2572;2570;2568;2566;2564;2562;2561;2560;2558;2557
R=2556;2555;2554;2553;2552;2551;2550;2549;2548;2548;2547;2547;2547;2546;2546
R=2546;2545;2545;2546;2545;2545;2546;2546;2546;2547
EOJ=END OF JOB
Sending Status Requests / Other
You can make requests from the lab through Rx-Universe; the types of requests that you can make are as follows:
Request quote (Rx-Invoice Module Required at the Lab)
Request order status (Rx-Tracker Module Required at the Lab)
Request to cancel the order
Request to hold the order
Request to ship the order
To do this, you basically have to send the ASCII order file again, with only these fields:
JOB=12345
_ACTION=3
Field Name | Data Type | Length | Description | Format / Valid Values |
---|---|---|---|---|
JOB | String | 07 | The original Job or PO number of the job that you are inquiring about. |
|
_ACTION | Numeric | 01 | The type of request you are making. | Valid Entries are: |