This documentation is not relevant to VLF-ONE applications.

Most commercial applications involve the use of codes and their decodes in many situations. For example:

Country CodeCountry Decode

1

North America

61

Australia

44

Great Britain

31

Netherlands

64

New Zealand

65

Singapore

81

Japan

Currency CodeCountry Decode

USD

US Dollar

GBP

Great Britain Pound

AUD

Australia Dollar

JPY

Japanese Yen

Sex CodeSex Decode

M

Male

F

Female

U

Unspecified

Document CodeDocument Decode

DOC

MS-Word Document

PPT

MS-PowerPoint Document

RTF

Rich Text Document

TXT

Text Document


Application end-users need to be able to select a code from a displayed list of decodes, validate it using a referential integrity check, and decode it to present the decode on a form or in a report.

Typically, codes come in relatively short lists of less than 100 items, and thus, end-users can select the one that they want from, for example, a group or radio buttons or a drop-down combo box.

However, some code tables are large. For example, a customer code table could store 10,000 customers. To handle large code tables, you need to provide the end-user with intelligent prompting capability that allows them to quickly locate the customer they are interested in.