Home > Accounting > Structure > Translation Values

Translation Values (Accounting Structure)

Accessing the translation value tables

Note:

The same menu may also be selected from Infrastructure > System Data > Translation Values or from Products > Formats > Translation Values.

However, the scheme level selection only applies for the Translation Purpose of BENEFIT STATEMENT. When the system processes a Benefit Statement Translation Value, it will first check if anything is defined at a scheme level (Products > Formats > Translation Values). If nothing is defined, the system will use what is defined at an Accounting or an Infrastructure level.

For more information on Translation values at a scheme level refer to

Product Launch Requirements

Additional Menu Options

Formats

Click accounting.

The Welcome screen will be displayed.

From the main menu on top, select Structure. The sub-menu will be displayed on the left.

Select Translation Values. The JU2AU Translation Header List screen will be displayed.

From the TRANSLATION PURPOSE drop-down box, select the required value. The following values are available:

- - ADMINREP BEN ST

- - BATCH JOBS

- - BEN STATEMENT

- - EB2000 TO GL3

- - ENDOWMENT VAL

- - INP TO CPY

- - INP TO CPY PRIV

- - INP TO FINSWITCH

- - INP TO GL3

- - INP TO INV SOLUTIONS

- - INP TO METEB

- - ITAX

- - LANGUAGE

- - LETTER TYPES

- - MI BATCH JOBS

- - NEWENTRCERT

- - PAYMENT ADVICE

- - RA VALUATION

- - SAL SACRIFICE

- - SERVICE

- - TAG NAMES

The JU2AU Translation Header List screen will display headers for all the values currently available for translation. In the example below, LANGUAGE has been selected.

Add new translation header

To add a new translation header, select Add New Translation Header from the sub-menu.

The JU2AU New Translation Header List screen will be displayed.

Note:

The version of the screen displayed depends on the Translation Purpose selected. For example:

Language

Descriptions of the input fields on this screen appear below.

Source System
System Id	The identifier of the Source System
Attribute	Text to uniquely identify the value to be translated.
Maximum Size	The maximum size of the attribute.
Target System
System Id	The identifier of the Target System
Attribute	Text to uniquely identify the value to be translated.
Maximum Size	The maximum size of the attribute.

Benefit Statement

Descriptions of the input fields on this screen appear below.

Source System
Language	Defaults to the source system ID shown on the previous screen.
Attribute	Text to uniquely identify the value to be translated.
Target System
Language	The language into which the English words or phrases are to be translated

Enter the relevant information, then click OK. Repeat this process for each value to be translated.

Once all values have been added, click CANCEL. The JU2AU Translation Header List screen will be re-displayed, and will show the header values that you have just captured. For each of these headers, the actual translation values must now be captured.

Open translation header

To open an existing translation header, highlight a Header on the JU2AU Translation Header List screen and select Open Translation Header from the sub-menu.

The JU2AU Translation Header List screen will be displayed.

Delete translation header

Note:

Translation headers can only be deleted if they don't contain translation values.

To delete a translation header, highlight the relevant header on the JU2AU Translation Header List, then select Delete Translation Header from the sub-menu on the left.

The JU2AU Delete Translation Header List screen will be displayed.

ClickOK. You will be asked to confirm the deletion.

The JU2AU Translation Header List screen will be re-displayed, and the deleted header will no longer appear.

Translation values

On the JU2AU Translation Header List screen, select a Translation Purpose from the drop-down list and highlight the relevant header value, then select Translation Values from the sub-menu on the left.

The JU2AV Translation Value List screen will be displayed.

Finding translation values

To find a specific value, select SEARCH on the JU2AV Translation Value List screen. TheJU2AV Translation Values Search screen will be displayed

Enter a source value or a target value, then click OK. The JU2AV Translation Value List screen will be re-displayed, and translation values commencing with the selected value will be displayed.

Add new translation values

To add a new translation value, select Add New Translation Header from the sub-menu on the left. JU2AU New Translation Header List screen will be displayed.

Descriptions of the input fields on this screen appear below.

Detail
Source Value	The value to be translated from.
Target Value	The value to be translated to.

Capture the relevant information, then click OK. The JU2AU Translation Header List screen will be re-displayed.

The Translation Value List screen will show the values that you have just captured.

Retirement annuity valuation

When launching a Retirement Annuity Fund, Translation values with a Translation Purpose of RA VALUATION and with Source System ID’s, Source System Attributes, Target System ID’s and Target System Attributes must be set up as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
INSURABLE EVENT	SCHEME CODE	INSURABLE EVENT	INSURABLE EVENT
POLSTATREASON	SCHEME CODE	POLSTATREASON	POLSTATREASON
SMOKER CODE	SCHEME CODE	SMOKER CODE	SMOKER CODE
GLACCOUNTCODE	SCHEME CODE	GLACCOUNTCODE	GLACCOUNTCODE
MOVEMENT CODE	MOVEMENT CODE	MOVEMENT CODE	MOVEMENT CODE
STATUS	SCHEME CODE	STATUS	STATUS
TAX STATUS	SCHEME CODE	TAX STATUS	TAX STATUS
FOUR FUND	SCHEME CODE	FOUR FUND	FOUR FUND

Translation values must be set up as per the following table:

Source System ID	Source System Attribute	Translation Value	Target System Attribute	Translation Value
INSURABLE EVENT	SCHEME CODE	HLRAF	INSURABLE EVENT	1
POLSTATREASON	POLSTATREASON	LIVE	POLSTATREASON	1
POLSTATREASON	POLSTATREASON	DEFERRED	POLSTATREASON	2
POLSTATREASON	POLSTATREASON	LIVE SINGLE PRM	POLSTATREASON	3
POLSTATREASON	POLSTATREASON	LIVE OPEN ENDED	POLSTATREASON	4
POLSTATREASON	POLSTATREASON	DEFERRED OPEN	POLSTATREASON	5
POLSTATREASON	POLSTATREASON	EXITED	POLSTATREASON	6
SMOKER CODE	SMOKER CODE	SMOKER	SMOKER CODE	1
SMOKER CODE	SMOKER CODE	NON SMOKER	SMOKER CODE	0
GLACCOUNTCODE	SCHEME CODE	HLRAF	GLACCOUNTCODE	DIR
STATUS	STATUS	LIVE	STATUS	IN FORCE
STATUS	STATUS	DEFERRED	STATUS	IN FORCE
STATUS	STATUS	EXIT FINALISED	STATUS	OUT OF FORCE
STATUS	STATUS	EXIT IN PROCESS	STATUS	OUT OF FORCE
MOVEMENT CODE	MOVEMENT CODE	TAKE-ON	MOVEMENT CODE	0
MOVEMENT CODE	MOVEMENT CODE	NEW	MOVEMENT CODE	1
MOVEMENT CODE	MOVEMENT CODE	TRANSFER IN	MOVEMENT CODE	6
MOVEMENT CODE	MOVEMENT CODE	TRANSFER OUT	MOVEMENT CODE	7
MOVEMENT CODE	MOVEMENT CODE	PAID-UP	MOVEMENT CODE	8
MOVEMENT CODE	MOVEMENT CODE	RETIREMENT	MOVEMENT CODE	3
MOVEMENT CODE	MOVEMENT CODE	WITHDRAWAL	MOVEMENT CODE	4
MOVEMENT CODE	MOVEMENT CODE	DEATH	MOVEMENT CODE	5
MOVEMENT CODE	MOVEMENT CODE	REINSTATED	MOVEMENT CODE	9
TAX STATUS	SCHEME CODE	HLRAF	TAX STATUS	4
FOUR FUND	SCHEME CODE	HLRAF	FOUR FUND	4

Endowment valuation

For Endowment Products, set up Translation values with a Translation Purpose of ENDOWMENT VAL and with Source System ID’s, Source System Attributes, Target System ID’s and Target System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
MOVEMENT	STATUS/DECISION	MOVEMENT TYPE	MOVEMENT TYPE
SMOKER CODE	SCHEME CODE	SMOKER CODE	SMOKER CODE
MEMBER STATUS	STATUS/CATEGORY	POLICY STATUS	POLICY STATUS
POLICY CATEGORY	POLICY CATEGORY	POLICY CATEGORY	POLICY CATEGORY
PMT FREQUENCY	PMT FREQUENCY	PMT FREQUENCY	PMT FREQUENCY
CAUSE OF CLAIM	BENEFIT EVENT	CLAIM TYPE	CLAIM TYPE
CLAIM STATUS	CLAIM STATUS	CLAIM STATUS	CLAIM STATUS
REQUEST STATUS	REQUEST STATUS	CLAIM MOVEMENT	CLAIM MOVEMENT

Translation values must be set up as per the following table:

Source System ID	Source System Attribute	Translation Value	Target System Attribute	Translation Value
MOVEMENT	STATUS/DECISION	LIVE	MOVEMENT TYPE	NEW BUSINESS
MOVEMENT	STATUS/DECISION	ENDED/LAPSED	MOVEMENT TYPE	LAPSE
MOVEMENT	STATUS/DECISION	ENDED/NOT TAKEN UP	MOVEMENT TYPE	NTU
MOVEMENT	STATUS/DECISION	EXIT FINALISED	MOVEMENT TYPE	CLAIM
MOVEMENT	STATUS/DECISION	ENDED/DECLINED	MOVEMENT TYPE	NTU
MEMBER STATUS	STATUS/CATEGORY	LIVE/N	POLICY STATUS	N
MEMBER STATUS	STATUS/CATEGORY	LIVE	POLICY STATUS	A
MEMBER STATUS	STATUS/CATEGORY	PENDING	POLICY STATUS	U
MEMBER STATUS	STATUS/CATEGORY	PAID UP	POLICY STATUS	A
MEMBER STATUS	STATUS/CATEGORY	ENDED	POLICY STATUS	I
SMOKER CODE	SMOKER CODE	NOT A SMOKER	SMOKER CODE	NS
SMOKER CODE	SMOKER CODE	1-5	SMOKER CODE	S
SMOKER CODE	SMOKER CODE	6-10	SMOKER CODE	S
SMOKER CODE	SMOKER CODE	11-20	SMOKER CODE	S
SMOKER CODE	SMOKER CODE	21-30	SMOKER CODE	S
SMOKER CODE	SMOKER CODE	>30	SMOKER CODE	S
POLICY CATEGORY	POLICY CATEGORY	A	POLICY CATEGORY	KAT 5
POLICY CATEGORY	POLICY CATEGORY	N	POLICY CATEGORY	KAT 7
POLICY CATEGORY	POLICY CATEGORY	E	POLICY CATEGORY	KAT 6
POLICY CATEGORY	POLICY CATEGORY	NE	POLICY CATEGORY	KAT 8
PMT FREQENCY	PMT FREQENCY	ANNUAL	PMT FREQENCY	A
PMT FREQENCY	PMT FREQENCY	MONTHLY	PMT FREQENCY	M
CAUSE OF CLAIM	BENEFIT EVENT	DEATH BY ACCIDENT/UNNATURAL CAUSES	CLAIM TYPE	NATURAL
CAUSE OF CLAIM	BENEFIT EVENT	DEATH BY NATURAL CAUSES	CLAIM TYPE	UNNATURAL
CAUSE OF CLAIM	BENEFIT EVENT	DISABILITY BY ACCIDENT/UNNATURAL CAUSES	CLAIM TYPE	NATURAL
CAUSE OF CLAIM	BENEFIT EVENT	DISABILITY BY NATURAL CAUSES	CLAIM TYPE	UNNATURAL
CLAIM DECISION	BENEFIT PRODUCT	DEATH BY ACCIDENT/UNNATURAL CAUSES	CLAIM STATUS	ACCEPT
CLAIM DECISION	BENEFIT PRODUCT	DEATH BY NATURAL CAUSES	CLAIM STATUS	ACCEPT
CLAIM DECISION	BENEFIT PRODUCT	DISABILITY BY ACCIDENT/UNNATURAL CAUSES	CLAIM STATUS	ACCEPT
CLAIM DECISION	BENEFIT PRODUCT	DISABILITY BY NATURAL CAUSES	CLAIM STATUS	ACCEPT
CLAIM DECISION	BENEFIT PRODUCT	REPUDIATE EX GRATIA EVENT	CLAIM STATUS	REPUDIATE
CLAIM DECISION	BENEFIT PRODUCT	REPUDIATE LOSS EVENT	CLAIM STATUS	REPUDIATE
CLAIM DECISION	BENEFIT PRODUCT	REPUDIATE SURRENDER VALUE	CLAIM STATUS	REPUDIATE
REQUEST STATUS	REQUEST STATUS	CLIENT AUTH	CLAIM MOVEMENT	IN PROGRESS
REQUEST STATUS	REQUEST STATUS	PMT CHECKED	CLAIM MOVEENT	IN PROGRESS
REQUEST STATUS	REQUEST STATUS		CLAIM MOVEMENT	CONFIRMED
REQUEST STATUS	REQUEST STATUS		CLAIM MOVEMENT	AUTHORISED
REQUEST STATUS	REQUEST STATUS	FINALISED	CLAIM MOVEMENT	FINALISED

FinSwitch

Set up Translation values with a Translation Purpose of INP TO FINSWITCH and with Source System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
IN.PENSIONS	PROCESS/BUYSELL	FINSWITCH	TRANSACTION TYPE
IN.PENSIONS	ADMINISTRATOR	FINSWITCH	INVESTOR CODE
IN.PENSIONS	INVESTMENT MEDIUM	FINSWITCH	FUND CODE
IN.PENSIONS	CURRENCY	FINSWITCH	CURRENCY

Where the Source System Attribute is defined as PROCESS/BUYSELL this refers to the combination of the value for ORIGINATIN PROCESS and the value for BUY SELL INDICATOR on the Portfolio Advice Detail.

The Source System Attribute INVESTMENT MEDIUM will be used in cases where the FinSwitch Code is longer than the Investment Medium Code of 8 characters.

Set up Translation values as per the following table:

Source System Attribute	Translation Value	Target System Attribute	Translation Value
PROCESS/BUYSELL	INCOME/B	TRANSACTION TYPE	P
PROCESS/BUYSELL	REALISATION/S	TRANSACTION TYPE	R
PROCESS/BUYSELL	SWITCHING/S	TRANSACTION TYPE	SO
PROCESS/BUYSELL	SWITCHING/B	TRANSACTION TYPE	SI
PROCESS/BUYSELL	MANUAL INITIATE/B	TRANSACTION TYPE	P
PROCESS/BUYSELL	MANUAL INITIATE/S	TRANSACTION TYPE	R
PROCESS/BUYSELL	EXPENSES/S	TRANSACTION TYPE	R
PROCESS/BUYSELL	DISTRIBUTION/S	TRANSACTION TYPE	R
PROCESS/BUYSELL	DISTRIBUTION/B	TRANSACTION TYPE	P
PROCESS/BUYSELL	PRE-AUTH/S	TRANSACTION TYPE	R
PROCESS/BUYSELL		TRANSACTION TYPE	TO
PROCESS/BUYSELL		TRANSACTION TYPE	TI
PROCESS/BUYSELL		TRANSACTION TYPE	PB
ADMINISTRATOR
INVESTMENT MEDIUM	As required
CURRENCY	ZAR	CURRENCY	R

Asset manager

Set up Translation values with a Translation Purpose of INP TO INV SOLUTIONS and with Source System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
IN.PENSIONS	PROCESS/BUYSELL	INV SOLUTIONS	TRANSACTION TYPE
IN.PENSIONS	PROCESS/BUYSELL	INV SOLUTIONS	TRANSACTION ID
IN.PENSIONS	ADMINISTRATOR	INV SOLUTIONS	CLIENT
IN.PENSIONS	INVESTMENT MEDIUM	INV SOLUTIONS	FUND CODE

Where the Source System Attribute is defined as PROCESS/BUYSELL this refers to the combination of the value for ORIGINATING PROCESS and the value for BUY SELL INDICATOR on the Portfolio Advice Detail.

The Source System Attribute INVESTMENT MEDIUM will be used in cases where the IS Code is longer than the Investment Medium Code of 8 characters.

Set up Translation values as per the following table:

Source System Attribute	Translation Value	Target System Attribute	Translation Value
PROCESS/BUYSELL	INCOME/B	TRANSACTION TYPE	CONTRIBUTION
PROCESS/BUYSELL	REALISATION/S	TRANSACTION TYPE	BENEFIT PAYMENTS
PROCESS/BUYSELL	SWITCHING/S	TRANSACTION TYPE	SWITCH FROM
PROCESS/BUYSELL	SWITCHING/B	TRANSACTION TYPE	SWITCH TO
PROCESS/BUYSELL	MANUAL INITIATE/B	TRANSACTION TYPE	SWITCH TO
PROCESS/BUYSELL	MANUAL INITIATE/S	TRANSACTION TYPE	SWITCH FROM
PROCESS/BUYSELL	EXPENSES/S	TRANSACTION TYPE	TRANSFER FROM
PROCESS/BUYSELL	DISTRIBUTION/S	TRANSACTION TYPE	TRANSFERS FROM
PROCESS/BUYSELL	DISTRIBUTION/B	TRANSACTION TYPE	TRANSFERS TO
PROCESS/BUYSELL	PRE-AUTH/S	TRANSACTION TYPE
PROCESS/BUYSELL	INCOME/B	TRANSACTION ID	1
PROCESS/BUYSELL	REALISATION/S	TRANSACTION ID	6
PROCESS/BUYSELL	SWITCHING/S	TRANSACTION ID	12
PROCESS/BUYSELL	SWITCHING/B	TRANSACTION ID	13
PROCESS/BUYSELL	MANUAL INITIATE/B	TRANSACTION ID	13
PROCESS/BUYSELL	MANUAL INITIATE/S	TRANSACTION ID	12
PROCESS/BUYSELL	EXPENSES/S	TRANSACTION ID E	18
PROCESS/BUYSELL	DISTRIBUTION/S	TRANSACTION ID	18
PROCESS/BUYSELL	DISTRIBUTION/B	TRANSACTION ID	19
PROCESS/BUYSELL	PRE-AUTH/S	TRANSACTION ID E

Type of exit

Set up Translation values with a Translation Purpose of TYPE OF EXIT with Source System Attributes and Target System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
PAYROLL	TERMINATION ID	IN.PENSIONS	BENEFIT EVENT

Set up Translation Values with a Source System ID and Source System Attribute of PAYROLL and TERM REASON ID respectively and Target System ID and Target System Attribute of IN.PENSIONS and BENEFIT EVENT as per the table below:

Source System Value	Target System Value
4	RESIGNATION
7	DISMISSAL INCAPACITY
8	DISMISSAL MISCONDUCT
9	NORMAL RETIREMENT
10	RESIGNATION PRIOR TO ENQUIRY
12	NORMAL RETIREMENT
13	RETRENCHMENT
21	DEATH OF MEMBER
22	RESIGNATION
24	DISMISSAL POOR PERFORMANCE
25	DISMISSAL POOR HEALTH
28	ABSCONDED
30	RESIGNATION
40	RESIGNATION

Admin report

Overview

The Admin Report is catered for by a generic flexible report catering for all schemes.

A new report format must be set up to define the items for inclusion with the administration report per scheme to be extracted when the administration report batch job is run.

For information on the Admin Report refer to

System Reports

Admin

For information on Tags for the Admin Report refer to

Supplements

Tags

Admin Report

The targeted translation values are used to bring business context to what Clients understand instead of the system references.

Translation

Set up Translation values with a Translation Purpose of ADMINREP BENEFIT STATUS and with Source System Attributes and Target System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
REQUEST STATUS	REQUEST STATUS	BENEFIT STATUS	BENEFIT STATUS
REQUEST STATUS	REQUEST STATUS/SCHEME	BENEFIT STATUS	BENEFIT STATUS
BENEFIT UPDATE	BENEFIT UPDATE	BENEFIT STATUS	BENEFIT STATUS
BENEFIT UPDATE	BENEFIT UPDATE/SCHEME	BENEFIT STATUS	BENEFIT STATUS

When the Translation Values are read, the Source System Value for the Source System Attribute REQUEST STATUS/SCHEME will be read and the Translation Value for the Source System Value followed by the Scheme Code of the Scheme being processed will be read first and if not found the Source System Value for the Source System Attribute Value REQUEST STATUS will be read.

For the Source System Attribute REQUEST STATUS set up Translation Values as per the following table:

Source System Value	Target System Value
NEW CLAIM	CLAIM INITIATED
CLIENT INPUT	CLAIM FORM CAPTURED
CLIENT AUTH	CLAIM FORM CAPTURE AUTHORISED

For the Source System Attribute REQUEST STATUS/SCHEME set up values for the Benefit Request Statuses followed by Scheme Code in the table below, if different descriptions are required for a Scheme (See table below).

Source System Value	Target System Value
NEW CLAIM/1234567	CLAIM INITIATED
CLIENT INPUT/1234567	CLAIM FORM CAPTURED
CLIENT AUTH/1234567	CLAIM FORM CAPTURE AUTHORISED

Note:

1234567 is an example Scheme Code.

For the Source System Attribute BENEFIT UPDATE set up Translation Values as per the following table:

Source System Value	Target System Value
PAYMENT DETAILS	MEMBER INSTRUCTION CHECKED
REALISATION	MONIES DISINVESTED
DB CALC	DB BENEFIT CALCULATED
DEATH	UNDERWRITTEN AMOUNT APPLIED FOR
DISABILITY	UNDERWRITTEN AMOUNT APPLIED FOR
CALC BENEFIT	BENEFIT AMOUNT CALCULATED
TAX DIR REQUEST	TAX DIRECTIVE APPLIED FOR
TAX DIRECTIVE	TAX DIRECTIVE RECEIVED
BENEFIT PAYABLE	BENEFIT DISBURSEMENT DONE
ANNUITY	ANNUITY DETAILS CAPTURED
PRIOR CLAIMS	PRIOR CLAIM DETAILS CAPTURED
BENEFICIARIES	BENEFICIARY ALLOCATIONS CAPTURED

For the Source System Attribute BENEFIT UPDATE/SCHEME set up values for the Benefit Request Statuses followed by Scheme Code in the table below, if different descriptions are required for a Scheme (See table below).

Source System Value	Target System Value
PAYMENT DETAILS/1234567	MEMBER INSTRUCTION CHECKED
REALISATION/1234567	MONIES DISINVESTED
DB CALC/1234567	DB BENEFIT CALCULATED
DEATH/1234567	UNDERWRITTEN AMOUNT APPLIED FOR
DISABILITY/1234567	UNDERWRITTEN AMOUNT APPLIED FOR
CALC BENEFIT/1234567	BENEFIT AMOUNT FINALISED
TAX DIR REQUEST/1234567	TAX DIRECTIVE APPLIED FOR
TAX DIRECTIVE/1234567	TAX DIRECTIVE RECEIVED
BENEFIT PAYABLE/1234567	BENEFIT DISBURSEMENT DONE
ANNUITY/1234567	ANNUITY DETAILS CAPTURED
PRIOR CLAIMS/1234567	PRIOR CLAIM DETILS CAPTURED
BENEFICIARIES/1234567	BENEFICIARY ALLOCATIONS CAPTURED

Note:

The Target System Translation Values are only suggested values and can be set up per Administrator or per Scheme as required with the desired values.

The current coding for these values used in the Claims Tracking reporting must be changed to use these Translation Values.

Web Registration

Set up Translation values with a Translation Purpose of WEB REGISTRATION with Source System Attributes and Target System Attributes as per the following table:

Source System ID	Source System Attribute	Target System ID	Target System Attribute
IN.PENSIONS	REGISTER ANSWER	IN.PENSIONS	SECURITY QUESTION

Set up Translation Values as per the table below:

Source System	Translation Value	Target System	Translation Value
REGISTER ANSWER	1	SECURITY QUESTION	MOTHER’S MAIDEN NAME
REGISTER ANSWER	2	SECURITY QUESTION	PLACE OF BIRTH
REGISTER ANSWER	3	SECURITY QUESTION	MONTH OF BIRTH
REGISTER ANSWER	4	SECURITY QUESTION	NAME OF FIRST SCHOOL
REGISTER ANSWER	5	SECURITY QUESTION	NAME OF FIRST EMPLOYER

Additional reading

For details of TRANSLATION PURPOSES of LANGUAGE and BENEFIT STATEMENT, refer to

Auxiliary Activities

Language Translation