Service Permitted Values

Print this Page	2.2 Service Level 13. Service Permitted Values	Close this Page

2.2.13 Service Permitted Values:

* Options are the permitted values and label for a specific field in any record.

* Options are encoded for internal performance and security reasons to provide a degree of language translation.

* Options are provided in English and may be replicated to support any other language.

* Options have a life span with a first and last applicable date.

* Options may be colour coded with a foreground and background colour.

* Options may carry amounts and percentages that are used in pricing calculations.

* Options may be for ALL sites (schemes) or just one selected site (scheme).

DDL:

03 site code implies scheme or ALL.

23 record code.

24 field number.

25 sequence number.

26 field code.

27 colour.

28 background.

29 first date.

30 last date.

31 language code.

32 description (64 UTF-8).

33 premium amount.

34 premium percent.

35 deductible amount.

36 deductible percent.

37 extra amount.

38 extra percent.

39 other amount.

40 other percent.

1. Option Identification:

An option has a record code and field number as the data dictionary placeholder. An option has an internal code and a sequence number that the options are shown in a drop down list. An option with a site code as ALL will be reused for all sites or a specific site code may be assigned so the option is only used for one scheme.

2. Option Dates:

Each option has the first date that the option may be used. Each option has the last date that the option may be used.

3. Option Language Description:

Each option has a language code and a description of up to 64 UTF-8 characters. The English option is mandatory and any number of other language option descriptions may be added. Where a user selected language description has not been provided, then the English description will be used - this will overcome any runtime errors.

4. Option Colour Theme:

Every option has a foreground and background colour assigned that may be black on white. Where an option needs to stand out in a drop down list, then it can be colour coded as applicable. A modest number of colour options have been pre-defined for each application.

5. Option Factors:

Any option may be assigned a (1) premium amount in base currency and a (2) premium percentage. Any option may be assigned a (3) deductible amount in base currency and a (4) premium percentage. Any option may be assigned (5) extra and (6) other (7) amounts and (8) percentages.

Only the mandatory English language option can be assigned scheme factors - other language options do not hold any factors.

Label Options:

Every English language field label is replicated as an option with a sequence number as zero. A special editor is provided so a user may add replacement label options for a selected language. Only one language at a time may be added, but any number of languages can be supported for each field label.

Option Languages:

Every English language option may be replicated as an option with a different language code and description. A special editor is provided so a user may add a description for a selected other language alongside the English description. Only one language at a time may be added, but any number of languages can be supported for each option.

Extended Usage:

Options are employed to support country taxation rules, cruising zones, risk zones, use of asset, minimum and maximum limits and all data that may need to be presented in more than one language. Reference data replaces options where the reference data is fixed and reusable such as the days of a month.

Multi-Currency:

Option factors should be used as a percentage change to the calculated or lookup price. Where the option factor is stored as an amount in the base currency, it is converted to the users currency using the exchange rate applicable on the date of the calculation. Currency is only correct on the date that the calculation is performed.

Data Integrity:

Options may be added with a first date as today and existing options may be assigned a last date, but data cannot be deleted. Factors should not be changed, but a new option added with any new factors that will apply from today.

A double audit trail is maintained to record every field value change and to record who changed what data on any specific date. The double audit trail is replicated to several data centers to eliminate fraud.