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 Code | Country Decode |
|
1 |
North America |
|
61 |
Australia |
|
44 |
Great Britain |
|
31 |
Netherlands |
|
64 |
New Zealand |
|
65 |
Singapore |
|
81 |
Japan |
| Currency Code | Country Decode |
|
USD |
US Dollar |
|
GBP |
Great Britain Pound |
|
AUD |
Australia Dollar |
|
JPY |
Japanese Yen |
| Sex Code | Sex Decode |
|
M |
Male |
|
F |
Female |
|
U |
Unspecified |
| Document Code | Document 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.