ZCURRENCY_1.1.1
Field description | Field abbreviation | Field version | Field length | Field type |
---|---|---|---|---|
Salary currency | ZCURRENCY | 1.1.1 | 3 | Char |
Valid entries
Dependent fields
- XCURRLOC
Depend upon fields
- EMPCURRENCY
- EMPCURRENCY_OTHER
Additional information
This algorithm cleans up the currency data provided by a graduate responding to the Graduate Outcomes survey question "What currency were you paid in?", combining the data provided in EMPCURRENCY with that from the free text field EMPCURRENCY_OTHER. Where the string provided in EMPCURRENCY_OTHER can't be mapped to a valid entry and EMPCURRENCY does not contain a currency code ZCURRENCY is set to 999.
Technical Specification
1. Convert the string from EMPCURRENCY_OTHER to upper case
2. Trim white space from beginning and end of the string
3. Replace multiple spaces with a single space
4. Carry out the following steps, taking a top down approach stopping when criteria is satisfied:
a. Where the string is contained in one (and only one) of the currency names (taken from the list of currency - country combinations, e.g. USA Dollars), return the corresponding currency code in ZCURRENCY
b. Where the string contains one (and only one) of the country names (taken from the list of country names, e.g. United Kingdom), return the corresponding currency code. Note that individual words must match within the string e.g. "UK" is contained within "Ukraine", but does not match the entire string.
c. Where the string contains both POUND and EURO, return 999
d. Where the string contains BOTH, HALF, TWO or THREE, return 999
e. Where the string equals POUND or POUNDS, return 1
f. Where the string contains any of the following strings, return 1:
- BRITISH
- UK POUND
- IN POUND
- STERLING
- BRITAIN
- UNITED KINGDOM
- GB
- £
g. Where the string contains any of the following strings, return 2:
- EURO
- EUR
- €
h.Where the string contains any of the following strings, return 3:
- AMERICAN DOLLAR
- UNITED STATES DOLLAR
- US DOLLAR
- USD
i. Where the string contains the string CANADIAN, return 30
j. Where the string contains the string CHINESE or CNY, return 34
k. Where the string contains the string DANISH, return 46
l. Where the string contains the string INDIAN, return 70
m. Where the string contains the string INDONESIAN, return 71
n. Where the string contains the string MEXICAN, return 102
o. Where the string contains the string OMANI, return 115
p. Where the string contains the string RUSSIAN, return 126
q. Where the string contains the string SWIS or SWISS, return 147
r. Where the string contains the string TURKISH, return 156
s. Where the string contains the string VIETNAM or VIETNAMESE, return 166
t. Where the string contains the string ZIMBABWEAN, return 169
u. Set any remaining non-valid strings to 999
v. Where EMPCURRENCY is not 999, copy the values from EMPCURRENCY into ZCURRENCY (note: due to routing, only 999 values should be overwritten with values from EMPCURRENCY)
Revision history
Contact Liaison by email or on +44 (0)1242 388 531.