iZySolutions - Documentation

IWICATALOG - Lenses and options: OCAM (Health insurance)

The OCAM module is specific to the French market and is optional. It is used to manage the data required by mutual insurance companies. In order to benefit from it, you will have to ask us for it beforehand. An invoice will be sent to you before activating this module.

Today the following formats are available:

  • Kalixia

  • Sévéane

  • Itelis

The data to be entered in the OCAMs are also available for modification for groupments thanks to the list above the tabs of the different OCAMs. Please make sure that you are on the wanted groupment. If the field is empty, it means that you are modifying the public values.

How to access the module?

This module is accessible in the lenses and options on the OCAM tab.

Kalixia

The file below is the template of the Excel file that is generated.

This file contains the expected information as well as a description of the Kalixia standard.

Sévéane

The file in Word format below describes the standard of the file expected by Sévéane.

We generate the CSV file as expected by this Health insurance.

Itelis

The file in PDF format below describes the standard of the file expected by Itelis.

We generate the Excel file as expected by this Health insurance.

Kalixia

The file below is the template of the Excel file that is generated.

This file contains the expected information as well as a description of the Kalixia standard.

Sévéane

The file in Word format below describes the standard of the file expected by Sévéane.

We generate the CSV file as expected by this Health insurance.

Itelis

The file in PDF format below describes the standard of the file expected by Itelis.

We generate the Excel file as expected by this Health insurance.

Interfaces Excel

For all three formats, there are Excel Interfaces allowing Health insurance data to be updated more easily. If life data is expected, it is important to note one of them. For example, if 0 or 1 then indicate one of them.

For Kalixia: Interface Kalixia (lenses and options) and Interface Kalixia range (lenses and integrated lenses).

For Sévéane : Interface Sévéane (lenses and options)

For Itelis: Itelis interface (lenses and options) or the lists of Tint Type, Tint Level and Photochromic Intensity at brightest leave the fields empty if you want to force a value on the lens.

Kalixia

All the data expected by Kalixia are specific and are not all data related to EDI catalog formats.

Lenses

In the following table, the label of the lens range must be unique. When entering it in iWiCatalog, make sure that this wording is always named in the same way. Therefore, make sure that the case (upper - lower case) is respected. All "double" scales will be reported in the Lens Ranges tab.

 

 

 

 

In iWiCatalog

LENS-TREATMENT TAB

Lenses authentication

Lens EDI code

Mandatory

 

Label lens

Mandatory

 

Label lens range

Mandatory

 

OFG classified lens

Yes/No

The OFG (Origin France Guaranteed) classified lens data can be found in the Technical lens tab. If France is the country selected for the Origin Guaranteed drop-down box then the data will be YES, otherwise NO.

100% santé lens class

A or B

Marketing tab

Lens dedicated to children

Yes/No

Lens/Health insurance tab/Kalixia authentication frame

Indicative lens classification

PROG1/PROG2/PROG3/PROG4/PROG5
UNIF1/UNIF2/UNIF3
MID1

Lens/Health insurance tab/Kalixia authentication frame

Treatment authentication

Label treatment range

Label of the commercial range of the treatment

Option/Health insurance tab/authentication frame

Indicative classification of SAR treatment

SAR1/SAR2/SAR3

Option/Health insurance tab/authentication frame

Indicative hard classification

DUR1/DUR2/DUR3

Option/Health insurance tab/authentication frame

UV property

 

UV cut-off at least 380 nm

1 : Yes/0 : Non

The data must be entered in the Alpha cut field of the lens (Technical tab/Measurement frame).

  • 1 if the lens contains alpha cut data > or equal to 380

  • 1 if the associated option contains a UV cut-off value > or equal to 380

  • Otherwise 0

The following table has been split in two in order to have a better visibility while reading. The headers of the table are on the same line when the export of the Excel file.

This file summarizes all ranges present on all lenses. Make sure that for the same range all data are uniformly filled in. Otherwise, for each exception a new line of products will be generated. (e.g.: A line for a range with the curvature of the face set to YES while on another glass with the same range the curvature of the face is set to NO).

 

 

 

 

In iWiCatalog

 

Lens authentication

Label lens range

Name of the lens range

Lens/Health insurance tab/Kalixia authentication frame

INFORMATION COMMON TO ALL TYPES OF LENSES

Manufacturing

Digital surfacing

Lens/Health insurance tab/Kalixia information frame

Recalculated power

Lens for "restricted use" thanks to an adapted design, treatment and/or specific tint(s)

Parameters

Average measurement pupillary distance

Curve of the face

Back vertex distance

Pantoscopic angle

Mounting height

Shape of the frame

Wearer profile

Requiers a measuring device

PROGRESSIVES & MULTI-FOCAL

Manufacturing

Value of the lightening prism

Lens/Health insurance tab/Kalixia progressives & multi-focal frame

Optimized VP position

Binocular optimization

Parameters

Reading distance

Progress corridor

SINGLE VISION & PROXIMITY

Manufacturing

Correction overlay in the lower part

Lens/Health insurance tab/Kalixia single vision & proximity frame

DONNEES D'INDIVIDUALISATION

Parameters

Minimum value of the curve

Lens/Health insurance tab/Kalixia individualization frame

Maximum value of the curve

Minimum lens-eye distance

Maximum lens-eye distance

Minimum pantoscopic angle

Maximum pantoscopic angle

Minimum VL/VP

Maximum VL/VP

Options

 

 

In iWiCatalog

Treatments authentication

Label treatment range

Option/Health insurance tab/Kalixia authentication frame

Manufacturing

Angle de contact (result of the measurement of the effectiveness of the hydrophobic treatment)

Option/Health insurance tab/Kalixia manufacturing frame

Antistatic properties

Nombre de couches d’antireflet (number of antireflective layers)

% of residual reflection

% of visible light transmission

% of UV protection on the front

% of UV protection on the back

Achromatique treatment

Meilleur % de coupure lumière bleue entre 415 à 455

For the options to be present on the Range Treatments tab, the label range treatment as well as the indicative classification must be filled in.

Sévéna

Lenses

Fields

Type

Format

Values/Comments

Status

OPTIMEYES

In iWiCatalog

RECORD TYPE

A2

 

Values: 11 for lens record

Mandatory

Yes

 

MANUFACTURER CODE

A15

 

Manufacturer EDI code

Mandatory

Yes

 

PROVIDER CODE

A15

 

Provider EDI code of the manufacturer

Mandatory

Yes

 

LENS CODE

A6

 

Lens EDI code

Mandatory

Yes

 

LENS NAME

A50

 

Lens name

Mandatory

Yes

 

GEOMETRY

A1

 

0 = afocal,1 = single vision , 2 = bi-focal, 3 = tri-focal, 4 = progressive, 5 = intermediate

Mandatory

Yes

 

MATERIAL

A1

 

0=mineral, 1 =organic, 2=polycarbonate 4= trivex

Mandatory

Yes

 

INDEX

A4

 

Lens index

Mandatory

Yes

 

ASPHERIC INDICATOR

A1

 

Y ou N  (indicates if the lens is aspheric or not)

Mandatory (only for single vision)

Yes

 

HARD INDICATOR

A1

 

Y ou N (indicates if the lens is hard or not)

Mandatory

Yes

  • "Y" if there is a "Mandatory" combination on the lens with a "Surfacing treatment" type option

    • of "Hard or varnish" subtype

    • of “Anti-reflective" type with the "Anti-scratch" indicator checked

  • Otherwise "N"

PHOTOCHROMIC INDICATOR

A1

 

Y ou N  (indicates if the lens is photochromic or not)

Mandatory

Yes

  • "Y" if there is a "Mandatory" combination on the lens with a "Tint" option with the "Photochromic" indicator ticked OR if "Photochromic" is ticked on the lens (Technical tab)

  • Otherwise "N"

PS: a lens indicated as photochromic will not be indicated as tinted in the Sévéane file

ANTIREFLECTIVE INDICATOR

A1

 

Y ou N (indicates if the lens is antireflective or not)

Mandatory

No

  • "Y" if there is a "Mandatory" combination on the lens with an "Anti-reflective", "Surface treatment" option OR if the "Anti-reflective name" of the lens is indicated.

  • Otherwise "N"

ANTIREFLECTIVE NAME

A12

uppercase without accents

Commercial name of the antireflective treatment

Mandatory if ANTIREFLECTIVE INDICATOR = Y

No

  • “Anti-reflective name" data of the "Mandatory", "Surfacing treatment", "Anti-reflective" type option on the lens OR "Anti-reflective name" data of the lens if filled out

  • Otherwise empty

TINT INDICATOR

A1

 

Y or N  (indicates if the lens is polarized or not)

Mandatory

Yes

  • "Y" if there is a "Mandatory" combination on the lens with an additional "Tint" OR "Surface treatment" "Polarized" OR if "Tinted" (Technical tab) is checked

  • Otherwise "N"

TINT TYPE

A3

 

POL : polarized tint, DEG : gradient tint, UNI : unified tint

Mandatory if TINT INDICATOR = Y

No

  • "POL" if there is a "Mandatory" combination on the lens with a "Polarized" "Surface Treatment" option

  • "DEG" if there is a "Mandatory" combination on the lens with a "Tint", "Unique gradient", "Bi-gradient" or "Tri-gradient” option

  • "UNI" if there is a "Mandatory" combination on the lens with a "Tint", "Filter <15 % absorption", "Standard" option or if "Special" OR if "Tint" is ticked

  • Otherwise empty

PRECAL INDICATOR

A1

 

Y or N  indicates if the lens contains one or not)

Mandatory

No

  • "Y" if there is an "Obligatory" association on the lens with a "Special Manufacturing", "Thickness optimization", "Manufacturer's calculation (Precal)" option OR whose "Nature of control" is "Precalibration".

  • Otherwise "N"

LENS RACINE

A10

uppercase without accents

Lens name without mentioning the index and options treatment allowing to identify with precision the lenses range**

Mandatory

No

  • "Racine progressif" if filled in

  • Otherwise empty

GEN 0 INDICATOR (Offre ECO)

A1

 

Y or N (indicates if the lens in a GEN0 or not)

Lenses eligible for the ECO offer

Optional

 

No

  • "GEN 0 (Offre ECO)" if filled in

  • Otherwise empty

LABEL MATERIAL OPTION (example blue light)

A10

uppercase without accents

Commercial name of the material (for example EPS, BLUEZERO,  BLUESHOCK CLEAR , XBLUE , BLUESECURE, UVPROTECT,)

 

No

  • "Material" if filled in on the lens

  • Otherwise empty

CATALOG STATE

A1

 

C : Creation, M = Modified, S = Deleted

Mandatory

Yes

 

LAST VALIDITY DATE

A8

AAAAMMJJ

Last date of validity of the lens

If "void" considered as forever

Optional

Yes

 

Options

 

© 2018 iZySolutions