When the Benefit Tax Directive Request record is created in the Benefit Payment process, the system will read the Scheme Parameter with a Parameter Type of TAX INTERFACE for the Scheme and update the TAX INTERFACE field with the value for the Parameter Sub-Type.
If a Scheme Parameter is not found, the system will read the Territory Parameter with a Parameter Type of TAX INTERFACE and update the TAX INTERFACE field with the value for the Parameter Sub-Type.
When the BJU3AL batch job is run, the system will extract the data from the Benefit Tax Directive records for which the Request Status is C. If the country on the JU1BK Nature of Scheme screen for a member is not SOUTH AFRICA, the member will be excluded from the tax directive file.
When the data has been extracted successfully, the Request Status will be updated to A.
The system will read the Territory Parameter Type TAX INTERFACE for the Territory equal to the Country for the Scheme to which the Membership is linked.
If the value is iTax, the data will be extracted and the following files will be created as per the file layouts in the sections below.
The system will read the value for Form Type and extract the data from the Tax Directive table per Form Type. A txt file will be created for each section below and per Form Type with the columns populated as per the tables below depending on the Form Type.
The Request Status will be updated to indicate that the record has been extracted.
The file will be moved to the directory defined for the Batch Parameter ITAXDIRREQ.
The tables below show the iTax column name and the equivalent system field name on the Benefit Tax Directive record or the default value.
Tax Payer Information File
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
CoCode |
7 |
A |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Individual Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Branch Code |
30 |
A |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of TEAM and Target System Attribute of BRANCH CODE where the Source System value is equal to the Team to which the Scheme is linked |
Code assigned by iTax to a branch or cost centre of a company. Mandatory |
Taxpayer unique number |
25 |
A/N |
TAXPAYER_MEMBER_NUMBER |
Membership Reference Number. Mandatory |
Nature of person |
1 |
A |
If an ID Number is found for the Member then set to A. If not then set to B |
Mandatory |
Surname/trading name |
120 |
A |
TAXPAYER_SURNAME |
Mandatory |
First name |
45 |
A |
TAXPAYER_FIRSTNAME_1 |
Mandatory |
Second name |
45 |
A |
TAXPAYER_FIRSTNAME_2 |
Optional |
Initials |
5 |
A |
TAXPAYER_INITIALS |
Mandatory |
Identity number |
13 |
N |
TAXPAYER_IDENTITY_ NUMBER |
Mandatory if Nature of Person is A and no Passport number is provided |
Passport number |
16 |
A/N |
TAXPAYER_OTHER_IDENTITY_NUMBER |
Mandatory if Nature of Person is A and no Identity number is provided |
Country of issue |
3 |
A |
|
Mandatory if Passport number provided. If Nature of Person is B then set this to ZNC |
Date of birth |
8 |
N |
TAXPAYER_DATE_OF_BIRTH |
Mandatory |
Income tax ref nr |
10 |
N |
INCOME_TAX_REFERENCE_ NUMBER |
Mandatory |
Employee nr |
13 |
A |
TAXPAYER_EMPLOYEE_ NUMBER |
Mandatory |
Estate indicator |
1 |
A |
Set to Y is the Date of Death on the Natural Person record for the Membership is not null. Set to blank if Date of death is null |
Optional |
Deceased date |
8 |
N |
Date of Death on Natural Person record for the Membership in format ccyymmdd |
Optional |
Email address |
70 |
FF |
TAXPAYER_EMAIL_ADDRESS |
Optional |
Home tel no |
11 |
N |
TAXPAYER_HOME_TEL_NO |
Optional |
Bus tel no |
11 |
N |
TAXPAYER_BUS_TEL_NO |
Mandatory |
Fax no |
11 |
N |
TAXPAYER_FAX_NO |
Optional |
Cell no |
10 |
N |
TAXPAYER_CELL_NO |
Optional |
Unit number |
5 |
A/N |
Blank |
Optional |
Complex |
25 |
FF |
Blank |
Optional |
Street number |
5 |
A/N |
Blank |
Optional |
Street or farm name |
25 |
FF |
LINE_1 of Client Address for the Participating Employer to which the Membership is linked and for which the Type of Address is BUSINESS. |
Mandatory |
Suburb or district |
34 |
FF |
LINE_2 of Client Address for the Participating Employer to which the Membership is linked and for which the Type of Address is BUSINESS. |
Mandatory |
City or town |
23 |
FF |
LINE_3 of Client Address for the Participating Employer to which the Membership is linked and for which the Type of Address is BUSINESS. |
Mandatory |
Postal code |
4 |
N |
POSTAL CODE of Client Address for the Participating Employer to which the Membership is linked and for which the Type of Address is BUSINESS. |
Mandatory |
Employee number |
25 |
A/N |
TAXPAYER_EMPLOYEE_ NUMBER |
Mandatory |
Unit number |
5 |
A/N |
Blank |
Optional |
Complex |
25 |
FF |
Blank |
Optional |
Street number |
5 |
A/N |
Blank |
Optional |
Street or farm name |
25 |
FF |
TAXPAYER_RES_ADDRESS_ LINE_1 |
Mandatory |
Suburb or district |
34 |
FF |
TAXPAYER_RES_ADDRESS_ LINE_2 |
Mandatory |
City or town |
23 |
FF |
TAXPAYER_RES_ADDRESS_ LINE_3 |
Mandatory |
Postal code |
4 |
N |
TAXPAYER_RES_POSTAL_ CODE |
Mandatory |
Address line 1 |
35 |
FF |
TAXPAYER_POST_ADDRESS_ LINE_1 |
Blank if same as residential address |
Address line 2 |
35 |
FF |
TAXPAYER_POST_ADDRESS_ LINE_2 |
Blank if same as residential address |
Address line 3 |
35 |
FF |
TAXPAYER_POST_ADDRESS_ LINE_3 |
Blank if same as residential address |
Postal code |
9 |
A/N |
TAXPAYER_POST_ADDRESS_POSTAL_CODE |
Blank if same as residential address |
Bank account type |
1 |
N |
0 |
Mandatory |
Bank account number |
17 |
N |
Blank |
Mandatory if Bank account type is not 0 |
Bank branch code |
6 |
A |
Blank |
Mandatory if Bank account type is not 0 |
Account holder name |
50 |
FT |
Blank |
Mandatory if Bank account type is not 0 |
Account Holder relationship |
1 |
N |
Blank |
Mandatory if Bank account type is not 0 |
Company or Trust Registration number |
16 |
A |
Blank |
Optional |
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Number of records |
8 |
N |
Number of records in the file |
Excluding the header and trailer records |
Fund Membership File
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
File Type |
20 |
C |
F0U1N2D3M4E5M6B7E8R9S |
|
Contact name |
40 |
C |
FUND_CONTACT_PERSON on tax directive record |
|
E-mail address |
80 |
C |
EMPLOYER_EMAIL_ADDRESS on tax directive record |
|
Telephone number |
20 |
N |
Client address telephone |
|
Time created |
10 |
N |
Time File was created |
|
User ID |
20 |
C |
R |
|
Company Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
CoCode |
7 |
C |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Member Detail Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
CoCode |
7 |
C |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Branch Code |
30 |
C |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of TEAM and Target System Attribute of BRANCH CODE where the Source System value is equal to the Team to which the Scheme is linked |
Code assigned by iTax to a branch or cost centre of a company. Mandatory |
Person number |
25 |
C |
TAXPAYER_MEMBER_NUMBER |
Membership Reference Number. Mandatory |
ITAX Fund number |
20 |
N |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of SCHEME CODE and Target System Attribute of FUND NUMBER where the Source System value is equal to the Scheme Code |
|
Funds type indicator |
2 |
N |
FUND_TYPE |
|
Member number |
15 |
C |
TAXPAYER_MEMBER_NUMBER |
Optional |
Join date |
8 |
N |
DATE_JOIN |
|
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Trailer |
11 |
C |
TRAILER |
Name of trailer type |
Number of records |
8 |
N |
Number of membership records in the file |
|
Form Type A or D (Retirement or Death – Pension/Provident Fund)
If the value for FORM_TYPE is equal to A or D extract the following information:
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
File type |
20 |
C |
D0I1R2E3C4T516V7E8S9 |
|
Contact name |
40 |
C |
FUND_CONTACT_PERSON on tax directive record |
|
E-mail address |
80 |
C |
EMPLOYER_EMAIL_ADDRESS on tax directive record |
|
Telephone number |
20 |
N |
Client address telephone |
|
Time created |
10 |
N |
Time file was created |
|
Company Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Company Code |
7 |
C |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Detail Record
Column Heading |
Size |
Format |
System value/ Default |
Comment |
Company Code |
7 |
C |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Company branch Code |
30 |
C |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of TEAM and Target System Attribute of BRANCH CODE where the Source System value is equal to the Team to which the Scheme is linked |
Code assigned by iTax to a branch or cost centre of a company. Mandatory |
Directive type |
8 |
C |
FORM_TYPE |
Where the value for Form Type is A or D the value for this column must be FORMAD Left justified & blank padded. |
Directive sub-type |
8 |
C |
Blank |
|
Fund type |
2 |
N |
FUND_TYPE |
Compulsory |
Fund create reason |
2 |
N |
FUND_CREATE_REASON |
Compulsory |
ITAX fund number |
20 |
N |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of SCHEME CODE and Target System Attribute of FUND NUMBER where the Source System value is equal to the Scheme Code |
Compulsory |
Contact person |
120 |
C |
FUND_CONTACT_PERSON |
|
Response destination |
10 |
C |
Blank |
|
Response format |
10 |
C |
Blank |
|
Response user name |
20 |
C |
Blank |
|
Electronic response |
1 |
C |
Y |
|
Paper response |
1 |
C |
N |
|
e-mail address |
80 |
C |
|
|
Income tax number |
10 |
N |
INCOME_TAX_REFERENCE_ NUMBER |
|
No-IT reason code |
2 |
N |
NO_INCOME_TAX_NUMBER_ REASON |
Compulsory if the member’s tax number is not supplied |
No IT reason text |
60 |
C |
NO_INCOME_TAX_NUMBER_ REASON_TEXT |
Compulsory if the NO-IT-REF-REASON value is 99 |
Taxpayer Unique Number/Person Nr |
25 |
C |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
Fund Membership Number |
15 |
C |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
Employee number |
13 |
C |
TAXPAYER_EMPLOYEE_ NUMBER |
|
Taxpayer SA ID nr |
13 |
N |
TAXPAYER_IDENTITY_ NUMBER |
Compulsory if TP-OTHER-ID is not provided |
Taxpayer Other ID nr |
13 |
C |
TAXPAYER_OTHER_IDENTITY_NUMBER |
Compulsory if TP_ID is not provided |
Reason for directive |
2 |
N |
DIRECTIVE_REASON |
Compulsory |
Annual income |
13 |
N |
TAXPAYER_ANNUAL_SALARY |
Compulsory |
Accrual date |
8 |
N |
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
Gross amount |
15 |
N |
GROSS_LUMPSUM |
Compulsory. No decimals. Last two digits denote the cents |
Member contributions |
15 |
N |
MEMBER_CONTRIBUTION CONTRIB_TO_PREVIOUS_ PROV_FUND |
No decimals. Last two digits denote the cents |
Member excess contributions |
15 |
N |
MEMBER_EXCESS_PENSION_CONTRIB |
No decimals. Last two digits denote the cents |
Annual salary number |
2 |
N |
ANNUAL_SALARY_NUMBER |
Rounded to cents |
Annual salary year |
4 |
|
ANNUAL_SALARY_YEAR_1 |
CCYY |
Annual salary amount |
13 |
N |
ANNUAL_SALARY_AMOUNT_1 |
Rounded to cents |
Annual salary year |
4 |
|
ANNUAL_SALARY_YEAR_2 |
CCYY |
Annual salary amount |
13 |
N |
ANNUAL_SALARY_AMOUNT_2 |
Rounded to cents |
Annual salary year |
4 |
|
ANNUAL_SALARY_YEAR_3 |
CCYY |
Annual salary amount |
13 |
N |
ANNUAL_SALARY_AMOUNT_3 |
Rounded to cents |
Annual salary year |
4 |
|
ANNUAL_SALARY_YEAR_4 |
CCYY |
Annual salary amount |
13 |
N |
ANNUAL_SALARY_AMOUNT_4 |
Rounded to cents |
Annual salary year |
4 |
N |
ANNUAL_SALARY_YEAR_5 |
CCYY |
Annual salary amount |
13 |
N |
ANNUAL_SALARY_AMOUNT_5 |
Rounded to cents |
Salary previous 12 months |
13 |
N |
SALARY_12_MONTH_ PRECEDING |
|
Employer PAYE nr |
10 |
N |
EMPLOYER_PAYE_ REFERENCE_NUMBER |
|
Employer name |
120 |
C |
EMPLOYER_NAME |
|
Employer business address lines 1 |
35 |
C |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_1 |
|
Employer business address lines 2 |
35 |
C |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_2 |
|
Employer business address lines 3 |
35 |
C |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_3 |
|
Employer business address lines 4 |
35 |
C |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_4 |
|
Employer business postal code |
10 |
C |
EMPLOYER_PHYSICAL_ADDR_POST_CODE |
|
Employer postal address lines 1 |
35 |
C |
EMPLOYER_POSTAL_ ADDRESS_LINE_1 |
Compulsory |
Employer postal address lines 2 |
35 |
C |
EMPLOYER_POSTAL_ ADDRESS_LINE_2 |
Compulsory |
Employer postal address lines 3 |
35 |
C |
EMPLOYER_POSTAL_ ADDRESS_LINE_3 |
|
Employer postal address lines 4 |
35 |
C |
EMPLOYER_POSTAL_ ADDRESS_LINE_4 |
|
Employer postal code |
10 |
C |
EMPLOYER_POSTAL_ADDR_ POSTAL_CODE |
Compulsory |
Employer dialing code |
10 |
C |
EMPLOYER_DIALING_CODE |
|
Employer telephone nr |
10 |
C |
EMPLOYER_TELEPHONE_ NUMBER |
|
Employer contact name |
120 |
C |
EMPLOYER_CONTACT_ PERSON |
|
Tax year |
4 |
N |
TAX_YEAR |
CCYY Compulsory |
Total Benefit Amt |
15 |
N |
GROSS_AMOUNT_TOTAL_ BENEFIT |
No decimals. Last two digits denote the cents |
Divorce Spouse Amt |
15 |
N |
|
No decimals. Last two digits denote the cents |
Benefit Calculate Ind |
1 |
C |
BENEFIT_CALCULATED_ INDICATOR |
Y or N |
Benefit Calc Start Date |
8 |
N |
DATE_START |
CCYYMMDD Compulsory |
Benefit Calc End Date |
8 |
N |
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
Purchased/ Transferred Annuity Indicator |
1 |
A |
TRANSFER_TO_FUND_ INDICATOR |
Y or N |
Purchased/ Transferred Annuity Amount |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is not TRN PROV – PUBL or TRN PEN – PUBL then populate this with the TRANSFER_AMOUNT. If it is TRN PROV – PUBL or TRN PEN – PUBL then make this blanks. |
|
Name of Registered Insurer |
120 |
A |
TRANSFER_FUND_NAME |
|
Annuity Policy Nr |
20 |
A |
ANNUITY_POLICY_NUMBER |
|
Fund Paying Annuity Indicator |
1 |
A |
FUND_PAYING_ANNUITY_ INDICATOR |
Y or N |
Remaining Annuity Amt |
15 |
N |
REMAINING_ANNUITY_ AMOUNT |
|
Public Sector Calculation Start Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the PUBLIC_SECTOR_FUND_DATE_FROM. Update the PUBLIC_SECTOR_ FUND_DATE_FROM field on the Benefit Tax Directive table. |
CCYYMMDD |
Public Sector Calculation End Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the PUBLIC_SECTOR_FUND_DATE_TO. Update the PUBLIC_SECTOR_ FUND_DATE_TO field on the Benefit Tax Directive table. |
CCYYMMDD |
Public Sector Amount |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the AMOUNT_PUBLIC_SECTOR_FUND. Update the AMOUNT_PUBLIC_ SECTOR_FUND field on the Benefit Tax Directive table. |
No decimals. Last two digits denote the cents |
Public Sector Transfer to Approved Fund Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the DATE_AMOUNT_TRANSFER_PUBLIC_SECTOR_FUND. Update the DATE_AMOUNT_ TRANSFER_PUBLIC_SECTOR_ FUND field on the Benefit Tax Directive table. |
CCYYMMDD |
Unclaimed Benefit Previously Taxed |
15 |
N |
|
No decimals. Last two digits denote the cents |
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Trailer |
11 |
C |
TRAILER |
|
Total directives |
9 |
N |
Number of directive requests in the file |
|
Form Type B (Resignation or Transfer – Pension/Provident Fund)
If the value for FORM_TYPE is equal to B extract the following information:
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
File type |
20 |
C |
D0I1R2E3C4T516V7E8S9 |
|
Contact name |
40 |
C |
FUND_CONTACT_PERSON on tax directive record |
|
E-mail address |
80 |
C |
EMPLOYER_EMAIL_ADDRESS on tax directive record |
|
Telephone number |
20 |
N |
Client address telephone |
|
Time created |
10 |
N |
Time file was created |
|
Company Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Company Code |
7 |
C |
Description for Global Parameter ITAX CO CODE |
Code assigned by iTax to a company. Mandatory |
Detail Record
Column Heading |
Size |
Format |
System value/ Default |
Comment |
Company Code |
7 |
C |
Absa1 |
Code assigned by iTax to a company. Mandatory |
Company branch Code |
30 |
C |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of TEAM and Target System Attribute of BRANCH CODE where the Source System value is equal to the Team to which the Scheme is linked |
Code assigned by iTax to a branch or cost centre of a company. Mandatory |
Directive type |
8 |
C |
FORM_TYPE |
Where the value for Form Type is B the value for this column must be FORMB Left justified & blank padded. |
Directive sub-type |
8 |
C |
Blank |
|
Fund type |
2 |
N |
FUND_TYPE |
Compulsory |
Fund create reason |
2 |
N |
FUND_CREATE_REASON |
Compulsory |
ITAX fund number |
20 |
N |
Target System value for the Translation value with a Translation Type of ITAX and Source System Attribute of SCHEME CODE and Target System Attribute of FUND NUMBER where the Source System value is equal to the Scheme Code |
Compulsory |
Contact person |
120 |
C |
FUND_CONTACT_PERSON |
|
Response destination |
10 |
C |
Blank |
|
Response format |
10 |
C |
Blank |
|
Response user name |
20 |
C |
Blank |
|
Electronic response |
1 |
C |
Y |
|
Paper response |
1 |
C |
N |
|
e-mail address |
80 |
C |
|
|
Income tax ref number |
10 |
N |
INCOME_TAX_REFERENCE_ NUMBER |
|
No-IT reason code |
2 |
N |
NO_INCOME_TAX_NUMBER_ REASON |
Compulsory if the member’s tax number is not supplied |
No IT reason text |
60 |
C |
NO_INCOME_TAX_NUMBER_ REASON_TEXT |
Compulsory if the NO-IT-REF-REASON value is 99 |
Person number |
25 |
C |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
Fund Membership Number |
15 |
C |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
Employee number |
13 |
C |
TAXPAYER_EMPLOYEE_ NUMBER |
|
Taxpayer SA ID nr |
13 |
N |
TAXPAYER_IDENTITY_ NUMBER |
Compulsory if TP-OTHER-ID is not provided |
Taxpayer ID nr other |
13 |
C |
TAXPAYER_OTHER_IDENTITY_NUMBER |
Compulsory if TP_ID is not provided |
Reason for directive |
2 |
N |
DIRECTIVE_REASON |
Compulsory |
Annual income |
13 |
N |
TAXPAYER_ANNUAL_SALARY |
Compulsory |
Accrual date |
8 |
N |
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
Gross amount |
15 |
N |
GROSS_LUMPSUM |
Compulsory. No decimals. Last two digits denote the cents |
Member contributions |
15 |
N |
MEMBER_CONTRIBUTION CONTRIB_TO_PREVIOUS_ PROV_FUND |
No decimals. Last two digits denote the cents |
Member excess contributions |
15 |
N |
MEMBER_EXCESS_PENSION_CONTRIB |
No decimals. Last two digits denote the cents |
Previous fund contribution |
15 |
N |
MEMBER_CONTRIB_TO_ PREVIOUS_PROV_FUND |
|
Actual join date |
8 |
N |
DATE_JOIN |
|
Previous start date |
8 |
N |
PREVIOUS_START_DATE |
|
Previous end date |
8 |
N |
PREVIOUS_END_DATE |
|
Is transfer fund a public sector fund |
1 |
C |
TRANSFER_TO_FUND_ INDICATOR |
Y or N |
Transfer fund type |
2 |
N |
TRANSFER_FUND_TYPE |
Compulsory if DIR-REASON is 05 |
iTAX transfer fund number |
20 |
N |
TRANSFER_FUND_NUMBER |
Compulsory if DIR-REASON is 05 |
Transfer amount |
15 |
N |
TRANSFER_AMOUNT |
No decimals. Last two digits denote the cents |
Surrender value |
15 |
N |
|
No decimals. Last two digits denote the cents |
Tax year |
4 |
N |
TAX_YEAR |
CCYY Compulsory |
Employment Start Date |
8 |
|
EMPLOYMENT_START_DATE |
CCYYMMDD |
Employment End Date |
8 |
|
EMPLOYMENT_END_DATE |
CCYYMMDD |
Public Sector Calculation Start Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the PUBLIC_SECTOR_FUND_DATE_FROM. Update the PUBLIC_SECTOR_ FUND_DATE_FROM field on the Benefit Tax Directive table. |
CCYYMMDD |
Public Sector Calculation End Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the PUBLIC_SECTOR_FUND_DATE_TO. Update the PUBLIC_SECTOR_ FUND_DATE_TO field on the Benefit Tax Directive table. |
CCYYMMDD |
Public Sector Amount |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the AMOUNT_PUBLIC_SECTOR_FUND. Update the AMOUNT_PUBLIC_ SECTOR_FUND field on the Benefit Tax Directive table. |
No decimals. Last two digits denote the cents |
Public Sector Transfer to Approved Fund Date |
8 |
Date |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the DATE_AMOUNT_TRANSFER_PUBLIC_SECTOR_FUND. Update the DATE_AMOUNT_ TRANSFER_PUBLIC_SECTOR_ FUND field on the Benefit Tax Directive table. |
CCYYMMDD |
Unclaimed Benefit Previously Taxed |
15 |
N |
|
No decimals. Last two digits denote the cents |
Non Member Previously Taxed |
15 |
N |
|
|
Date Divorce Order |
8 |
|
|
CCYYMMDD |
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
Trailer |
11 |
C |
TRAILER |
|
Total directives |
9 |
N |
Number of directive requests in the file |
|
When the BJU3AL batch job is run, the system will extract the data from the Benefit Tax Directive records for which the Request Status is C.
When the data has been extracted successfully, the Request Status will be updated to A.
The system will read the Territory Parameter Type TAX INTERFACE for the Territory equal to the Country for the Scheme to which the Membership is linked.
If the value is EASYTAX, the file will be extracted as per the EASYTAX file format.
If the value is SARS, the data will be extracted and the file will be created as per the file layouts in the sections below.
The system will read the value for Form Type and extract the data from the Tax Directive table per Form Type. A delimited file will be created per Form Type with the following columns populated as per the tables below depending on the Form Type.
The Request Status will be updated to indicate that the record has been extracted.
The file will be moved to the directory defined for the Batch Parameter SARSTAXDIRREQ.
The tables below show the SARS column name and the equivalent system field name on the Benefit Tax Directive record or the default value.
Form Type A or D
(Retirement or Death – Pension/Provident Fund).
If the value for FORM_TYPE is equal to A or D, the following information will be extracted:
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
SEC-ID |
1 |
|
H |
|
INFO-TYPE |
8 |
N |
FORM_TYPE |
Where the value for Form Type is A or D the value for this column must be FORMAD Left justified & blank padded. |
INFO-SUBTYPE |
8 |
|
Blanks |
|
TEST-DATA |
1 |
|
Y or N |
Y if it is a test file. N if it is a production file. |
FILE-SERIES-CTL |
1 |
|
S |
|
EXT-SYS |
8 |
|
Value for Batch Parameter ISP0901 |
Left justified & blank padded. |
VER-NO |
8 |
|
8 |
|
OWN-FILE-ID |
14 |
A/N |
Value for Batch Parameter TAXDIRREQIDNO |
When the file is created increment the value for the Batch Parameter by 1. |
GEN-TIME |
14 |
|
CCYYMMDDhhmmss |
Date and time file is created |
Data Record
Column Heading |
Size |
Format |
System value/ Default |
Comment |
SEC-ID |
1 |
|
R |
|
REQ-SEQ-NUM |
20 |
A/N |
R_SEQUENCE |
Compulsory |
FUND-NUMBER |
11 |
N |
FUND_NUMBER |
Compulsory |
FUND-PAYE-NO |
10 |
N |
EMPLOYER_PAYE_ REFERENCE_NUMBER |
Compulsory |
FUND-TYPE |
2 |
A/N |
FUND_TYPE |
Compulsory |
FUND-CREATE-REASON |
2 |
A/N |
FUND_CREATE_REASON |
Compulsory |
FUND-NAME |
120 |
A/N |
FUND_NAME |
Compulsory |
FUND-POST-ADDRESS |
35 |
A/N |
LINE_1 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_3 |
Compulsory if Employer postal address not supplied |
FUND-POST-ADDRESS |
35 |
A/N |
LINE_2 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_4 |
Compulsory if Employer postal address not supplied |
FUND-POST-ADDRESS |
35 |
A/N |
LINE_3 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_5 |
|
FUND-POST-ADDRESS |
35 |
A/N |
LINE_4 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_6 |
|
FUND-POST-CODE |
10 |
A/N |
POSTAL_CODE on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of SARS POST BOX, SARS PRIVATEBAG or SARS POST STR |
Compulsory if Employer postal address not supplied |
FUND-DIAL-CODE |
10 |
A/N |
TELEPHONE_AREA_CODE_1 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of BUSINESS, POSTAL, SARS POST BOX, SARS PRIVATEBAG or SARS POST STR |
|
FUND-TEL-NO |
10 |
A/N |
TELEPHONE_NUMBER_1 on CLIENT ADDRESS linked to Scheme Contact Person with a Role of TAX CONTACT with an Address Type of BUSINESS, POSTAL, SARS POST BOX, SARS PRIVATEBAG or SARS POST STR |
|
FUND-CONTACT-PERSON |
120 |
A/N |
INITIALS AND SURNAME of Scheme Contact Person with a Role of TAX CONTACT |
|
IT-REF-NO |
10 |
N |
INCOME_TAX_REFERENCE_ NUMBER |
|
NO-IT-REF-REASON |
2 |
A/N |
NO_INCOME_TAX_NUMBER_ REASON |
Compulsory if the member’s tax number is not supplied |
NO-IT-REF-REASON-TEXT |
65 |
Free Text |
NO_INCOME_TAX_NUMBER_ REASON_TEXT |
Compulsory if the NO-IT-REF-REASON value is 99 |
TP-ID |
13 |
N |
TAXPAYER_IDENTITY_ NUMBER |
Compulsory if TP-OTHER-ID is not provided |
TP-OTHER-ID |
15 |
A/N |
TAXPAYER_OTHER_IDENTITY_NUMBER |
Compulsory if TP_ID is not provided |
TP-MEMBER-NO |
15 |
A/N |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
TP-EMPLOYEE-NO |
13 |
A/N |
TAXPAYER_EMPLOYEE_ NUMBER |
|
TP-DOB |
8 |
N |
TAXPAYER_DATE_OF_BIRTH |
CCYYMMDD Compulsory |
TP-SURNAME |
120 |
A/N |
TAXPAYER_SURNAME |
Compulsory |
TP-INITS |
5 |
A/N |
TAXPAYER_INITIALS |
Compulsory |
TP-FIRSTNAMES |
90 |
A/N |
TAXPAYER_FIRSTNAME_1 TAXPAYER_FIRSTNAME_2 TAXPAYER_FIRSTNAME_3 |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
LINE_3 on CLIENT ADDRESS record for the Membership with an Address Type of SARS RESIDENTIAL |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
LINE_4 on CLIENT ADDRESS record for the Membership with an Address Type of SARS RESIDENTIAL |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
LINE_5 on CLIENT ADDRESS record for the Membership with an Address Type of SARS RESIDENTIAL |
|
TP-RES-ADDRESS |
35 |
A/N |
LINE_6 on CLIENT ADDRESS record for the Membership with an Address Type of SARS RESIDENTIAL |
|
TP-RES-CODE |
10 |
A/N |
POSTAL_CODE on CLIENT ADDRESS record for the Membership with an Address Type of SARS RESIDENTIAL |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
LINE_1 on CLIENT ADDRESS record for the Membership with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_3 |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
LINE_2 on CLIENT ADDRESS record for the Membership with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_4 |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
LINE_3 on CLIENT ADDRESS record for the Membership with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_5 |
|
TP-POST-ADDRESS |
35 |
A/N |
LINE_4 on CLIENT ADDRESS record for the Membership with an Address Type of SARS POST BOX, SARS PRIVATEBAG or if the Address Type is SARS POST STR then LINE_6 |
|
TP-POST-CODE |
10 |
A/N |
POSTAL_CODE on CLIENT ADDRESS record for the Membership with an Address Type of SARS POST BOX, SARS PRIVATEBAG or SARS POST STR |
Compulsory |
TAX-YEAR |
4 |
|
TAX_YEAR |
CCYY Compulsory |
DIR-REASON |
2 |
A/N |
DIRECTIVE_REASON |
Compulsory |
DATE-OF-ACCRUAL |
8 |
|
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
GROSS-LUMP-SUM |
15 |
N |
GROSS_LUMPSUM |
Compulsory |
GROSS-AMOUNT-TOTAL-BENEFIT |
15 |
N |
GROSS_AMOUNT_TOTAL_ BENEFIT |
|
DIVORCE-SPOUSE-AMOUNT |
15 |
N |
DIVORCE_SPOUSE_AMOUNT |
|
MEMBER-OWN-CONTRIB |
15 |
N |
MEMBER_CONTRIBUTION CONTRIB_TO_PREVIOUS_ PROV_FUND |
|
MEMBER-EXCESS-PENSION-CONTRIB |
15 |
N |
MEMBER_EXCESS_PENSION_CONTRIB |
|
BENEFIT-CALCULATED-INDICATOR |
1 |
A/N |
BENEFIT_CALCULATED_ INDICATOR |
Y or N |
DATE-JOIN |
8 |
|
DATE_JOIN |
CCYYMMDD Compulsory |
BENEFIT-CALC-START-DATE |
8 |
|
DATE_START |
CCYYMMDD Compulsory |
BENEFIT-CALC-END-DATE |
8 |
|
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
PURCHASED-TRANSFERRED-ANNUITY-INDICATOR |
1 |
A/N |
TRANSFER_TO_FUND_ INDICATOR |
Y or N |
PURCHASED-TRANSFERRED-ANNUITY-AMOUNT |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is not TRN PROV – PUBL or TRN PEN – PUBL then populate this with the TRANSFER_AMOUNT. If it is TRN PROV – PUBL or TRN PEN – PUBL then make this blanks. |
|
NAME-REGISTERED-INSURER |
120 |
A/N |
TRANSFER_FUND_NAME |
|
ANNUITY-POLICY-NO |
20 |
A/N |
ANNUITY_POLICY_NUMBER |
|
FUND-PAYING-ANNUITY-INDICATOR |
1 |
A/N |
FUND_PAYING_ANNUITY_ INDICATOR |
Y or N |
REMAINING-ANNUITY-AMOUNT |
15 |
N |
REMAINING_ANNUITY_ AMOUNT |
|
PUBLIC-SECTOR- FUND-DATE-FROM |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the PUBLIC_SECTOR_ FUND_DATE_FROM field on the Benefit Tax Directive table. |
CCYYMMDD |
PUBLIC-SECTOR- FUND-DATE-TO |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the PUBLIC_SECTOR_ FUND_DATE_TO field on the Benefit Tax Directive table. |
CCYYMMDD |
AMOUNT-PUBLIC-SECTOR-FUND |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the TRANSFER_AMOUNT. Update the AMOUNT_PUBLIC_ SECTOR_FUND field on the Benefit Tax Directive table. |
|
DATE-AMOUNT-TRANSFER-PUBLIC-SECTOR-FUND |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the DATE_AMOUNT_ TRANSFER_PUBLIC_SECTOR_ FUND field on the Benefit Tax Directive table. |
CCYYMMDD |
ANNUAL-SALARY-NUMBER |
2 |
N |
ANNUAL_SALARY_NUMBER |
|
ANNUAL-SALARY-YEAR |
4 |
|
ANNUAL_SALARY_YEAR_1 |
CCYY |
ANNUAL-SALARY-YEAR |
4 |
|
ANNUAL_SALARY_YEAR_2 |
CCYY |
ANNUAL-SALARY-YEAR |
4 |
|
ANNUAL_SALARY_YEAR_3 |
CCYY |
ANNUAL-SALARY-YEAR |
4 |
|
ANNUAL_SALARY_YEAR_4 |
CCYY |
ANNUAL-SALARY-YEAR5 |
4 |
N |
ANNUAL_SALARY_YEAR_5 |
CCYY |
ANNUAL-SALARY-AMOUNT |
13 |
N |
ANNUAL_SALARY_AMOUNT_1 |
|
ANNUAL-SALARY-AMOUNT |
13 |
N |
ANNUAL_SALARY_AMOUNT_2 |
|
ANNUAL-SALARY-AMOUNT |
13 |
N |
ANNUAL_SALARY_AMOUNT_3 |
|
ANNUAL-SALARY-AMOUNT |
13 |
N |
ANNUAL_SALARY_AMOUNT_4 |
|
ANNUAL-SALARY-AMOUNT |
13 |
N |
ANNUAL_SALARY_AMOUNT_5 |
|
TP-ANNUAL-INCOME |
13 |
N |
TAXPAYER_ANNUAL_SALARY |
Compulsory |
SALARY-12-MTHS-PRECEDING |
13 |
N |
SALARY_12_MONTH_ PRECEDING |
|
PAYE-REF-NO |
10 |
N |
EMPLOYER_PAYEE_ REFERENCE_NUMBER |
|
EMP-NAME |
120 |
A/N |
EMPLOYER_NAME |
|
EMP-PHY-ADDRESS |
35 |
A/N |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_1 |
|
EMP-PHY-ADDRESS |
35 |
A/N |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_2 |
|
EMP-PHY-ADDRESS |
35 |
A/N |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_3 |
|
EMP-PHY-ADDRESS |
35 |
A/N |
EMPLOYER_PHYSICAL_ ADDRESS_LINE_4 |
|
EMP-PHY-POST-CODE |
10 |
A/N |
EMPLOYER_PHYSICAL_ ADDR_POST_ CODE |
|
EMP-POST-ADDRESS |
35 |
A/N |
EMPLOYER_POSTAL_ ADDRESS_LINE_1 |
Compulsory |
EMP-POST-ADDRESS |
35 |
A/N |
EMPLOYER_POSTAL_ ADDRESS_LINE_2 |
Compulsory |
EMP-POST-ADDRESS |
35 |
A/N |
EMPLOYER_POSTAL_ ADDRESS_LINE_3 |
|
EMP-POST-ADDRESS |
35 |
A/N |
EMPLOYER_POSTAL_ ADDRESS_LINE_4 |
|
EMP-POST-CODE |
10 |
A/N |
EMPLOYER_POSTAL_ADDR_ POSTAL_CODE |
Compulsory |
EMP-DIAL-CODE |
10 |
A/N |
EMPLOYER_DIALING_CODE |
|
EMP-TEL-NO |
10 |
A/N |
EMPLOYER_TELEPHONE_NUMBER |
|
EMP-CONTACT-PERSON |
120 |
A/N |
EMPLOYER_CONTACT_PERSON |
|
UNCLAIMED-BENEF-PREV-TAXED |
15 |
N |
|
|
EMAIL-ADDRESS-ADMINISTRATOR |
50 |
A/N |
Read ELECTRONIC_ADDRESS_ IDENTIFIER on the Client Address record linked to the Administrator. Update the EMAIL_ADDRESS_ ADMINISTRATOR field on the Benefit Tax Directive table with the value. |
|
TAXED-TRANSF-NON-MEMB-SPOUSE |
15 |
N |
|
|
PAPER-RESP |
1 |
|
N |
Default this value to N |
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
SEC-ID |
1 |
|
T |
|
REC-NO |
8 |
N |
Number of directive requests in the file |
Zero filled, right-justified. |
MEMBER-CONTRIB-SUM |
20 |
N |
Aggregate of MEMBER-OWN-CONTRIB fields in the file |
|
MEMBER-EXCESS-SUM |
20 |
N |
Aggregate of MEMBER-EXCESS-PENSION-CONTRIB in the file |
|
ANNUAL-SALARY-NUMBER-SUM |
8 |
N |
Aggregate of ANNUAL-SALARY-NUMBER in the file |
|
ANNUAL-SALARY-AMOUNT-SUM |
16 |
N |
Aggregate of ANNUAL-SALARY-AMOUNT fields (including all repetitions within each record) in the file |
|
GROSS-LS-SUM |
20 |
N |
Aggregate of GROSS-LUMP-SUM fields in the file |
|
GROSS-AMOUNT-TOT-BENEFIT-SUM |
20 |
N |
Aggregate of GROSS-AMOUNT-TOTAL-BENEFIT fields in the file |
|
DIVORCE-SPOUSE-AMOUNT-SUM |
20 |
N |
Aggregate of DIVORCE-SPOUSE-AMOUNT fields in the file |
|
PURCHASED-TRANSF-ANNUITY-AMT-SUM |
20 |
N |
Aggregate of PURCHASED-TRANSFERRED-ANNUITY-AMOUNT fields in the file |
|
REMAINING-ANNUITY-AMOUNT-SUM |
20 |
N |
Aggregate of REMAINING-ANNUITY-AMOUNT fields in the file |
|
AMOUNT-PUBLIC-SECTOR-FUND-SUM |
20 |
N |
Aggregate of AMOUNT-PUBLIC-SECTOR-FUND fields in the file |
|
Form Type B
(Resignation or Transfer – Pension/Provident Fund)
If the value for FORM_TYPE is equal to B, the following information will be extracted:
Header Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
SEC-ID |
1 |
|
H |
|
INFO-TYPE |
8 |
N |
FORM_TYPE |
Where the value for Form Type is B the value for this column must be FORMB Left justified & blank padded. |
INFO-SUBTYPE |
8 |
|
Blanks |
|
TEST-DATA |
1 |
|
Y or N |
Y if it is a test file. N if it is a production file. |
FILE-SERIES-CTL |
1 |
|
S |
|
EXT-SYS |
8 |
|
Value for Batch Parameter ISP0901 |
Left justified & blank padded. |
VER-NO |
8 |
|
8 |
|
OWN-FILE-ID |
14 |
|
Value for Batch Parameter TAXDIRREQFILENO |
When the file is created increment the value for the Batch Parameter by 1. |
GEN-TIME |
14 |
|
CCYYMMDDhhmmss |
Date and time file is created |
Data Record
Column Name |
Size |
Format |
System value / Default |
Comment |
SEC-ID |
1 |
|
R |
|
REQ-SEQ-NUM |
20 |
A/N |
R_SEQUENCE |
Compulsory |
FUND-NUMBER |
11 |
N |
FUND_NUMBER |
Compulsory |
FUND-PAYE-NO |
10 |
N |
INCOME_TAX_REFERENCE_NUMBER |
Compulsory |
FUND-TYPE |
2 |
A/N |
FUND_TYPE |
Compulsory |
FUND-CREATE-REASON |
2 |
A/N |
FUND_CREATE_REASON |
Compulsory |
FUND-NAME |
120 |
A/N |
FUND_NAME |
Compulsory |
FUND-POST-ADDRESS |
35 |
A/N |
FUND_POSTAL_ADDRESS_ LINE_1 |
Compulsory if Employer postal address not supplied |
FUND-POST-ADDRESS |
35 |
A/N |
FUND_POSTAL_ADDRESS_ LINE_2 |
Compulsory if Employer postal address not supplied |
FUND-POST-ADDRESS |
35 |
A/N |
FUND_POSTAL_ADDRESS_ LINE_3 |
|
FUND-POST-ADDRESS |
35 |
A/N |
FUND_POSTAL_ADDRESS_ LINE_4 |
|
FUND-POST-CODE |
10 |
A/N |
FUND_POSTAL_CODE |
Compulsory if Employer postal address not supplied |
FUND-DIAL-CODE |
10 |
A/N |
FUND_DIAL_CODE |
|
FUND-TEL-NO |
10 |
A/N |
FUND_TELEPHONE_NUMBER |
|
FUND-CONTACT-PERSON |
120 |
A/N |
FUND_CONTACT_PERSON |
|
IT-REF-NO |
10 |
N |
INCOME_TAX_REFERENCE_ NUMBER |
|
NO-IT-REF-REASON |
2 |
A/N |
NO_INCOME_TAX_NUMBER_ REASON |
Compulsory if the member’s tax number is not supplied |
NO-IT-REF-REASON-TEXT |
65 |
Free Text |
NO_INCOME_TAX_NUMBER_ REASON_TEXT |
Compulsory if the NO-IT-REF-REASON value is 99 |
TP-ID |
13 |
N |
TAXPAYER_IDENTITY_ NUMBER |
Compulsory if TP-OTHER-ID is not provided |
TP-OTHER-ID |
15 |
A/N |
TAXPAYER_OTHER_IDENTITY_NUMBER |
Compulsory if TP_ID is not provided |
TP-MEMBER-NO |
15 |
A/N |
TAXPAYER_MEMBER_NUMBER |
Compulsory |
TP-EMPLOYEE-NO |
13 |
A/N |
TAXPAYER_EMPLOYEE_ NUMBER |
|
TP-DOB |
8 |
N |
TAXPAYER_DATE_OF_BIRTH |
Compulsory |
TP-SURNAME |
120 |
A/N |
TAXPAYER_SURNAME |
Compulsory |
TP-INITS |
5 |
A/N |
TAXPAYER_INITIALS |
Compulsory |
TP-FIRST-NAMES |
90 |
A/N |
TAXPAYER_FIRSTNAME_1 TAXPAYER_FIRSTNAME_2 TAXPAYER_FIRSTNAME_3 |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
TAXPAYER_RES_ADDRESS_ LINE_1 |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
TAXPAYER_RES_ADDRESS_ LINE_2 |
Compulsory |
TP-RES-ADDRESS |
35 |
A/N |
TAXPAYER_RES_ADDRESS_ LINE_3 |
|
TP-RES-ADDRESS |
35 |
A/N |
TAXPAYER_RES_ADDRESS_ LINE_4 |
|
TP-RES-CODE |
10 |
A/N |
TAXPAYER_RES_POSTAL_ CODE |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
TAXPAYER_POST_ADDRESS_ LINE_1 |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
TAXPAYER_POST_ADDRESS_ LINE_2 |
Compulsory |
TP-POST-ADDRESS |
35 |
A/N |
TAXPAYER_POST_ADDRESS_ LINE_3 |
|
TP-POST-ADDRESS |
35 |
A/N |
TAXPAYER_POST_ADDRESS_ LINE_4 |
|
TP-POST-CODE |
10 |
A/N |
TAXPAYER_POST_ADDRESS_POSTAL_CODE |
Compulsory |
TAX-YEAR |
4 |
|
TAX_YEAR |
CCYY Compulsory |
DIR-REASON |
2 |
A/N |
DIRECTIVE_REASON |
Compulsory |
TP-ANNUAL-INCOME |
13 |
N |
TAXPAYER_ANNUAL_SALARY |
Compulsory |
GROSS-LUMP-SUM |
15 |
N |
GROSS_LUMPSUM |
Compulsory |
LUMP-SUM-ACCRUAL-DATE |
8 |
|
LUMPSUM_ACCRUAL_DATE |
CCYYMMDD Compulsory |
MEMBER-CONTRIB |
15 |
N |
MEMBER_CONTRIBUTION |
|
MEMBER-EXCESS-PENSION-CONTRIB |
15 |
N |
MEMBER_EXCESS_PENSION_CONTRIB |
|
CONTRIB-TO-PREV-PROV-FUND |
15 |
N |
MEMBER_CONTRIB_TO_ PREVIOUS_PROV_FUND |
|
DATE-JOIN |
8 |
|
DATE_JOIN |
CCYYMMDD
Compulsory |
PREVOIUS-START-DATE |
8 |
|
PREVIOUS_START_DATE |
CCYYMMDD |
PREVIOUS-END-DATE |
8 |
|
PREVIOUS_END_DATE |
CCYYMMDD |
EMPLOYMENT-START-DATE |
8 |
|
EMPLOYMENT_START_DATE |
CCYYMMDD |
EMPLOYMENT-END-DATE |
8 |
|
EMPLOYMENT_END_DATE |
CCYYMMDD |
XFER-TO-FUND |
1 |
|
TRANSFER_TO_FUND_ INDICATOR |
Y or N |
XFER-FUND-TYPE |
2 |
A/N |
TRANSFER_FUND_TYPE |
Compulsory if DIR-REASON is 05 |
TRANSFER-FUND-NO |
11 |
N |
TRANSFER_FUND_NUMBER |
Compulsory if DIR-REASON is 05 |
TRANSFER-FUND |
120 |
A/N |
TRANSFER_FUND_NAME |
Compulsory if DIR-REASON is 05 |
TRANSFER-AMOUNT |
15 |
N |
TRANSFER_AMOUNT |
Compulsory if DIR-REASON is 05 |
SURRENDER-VALUE |
15 |
N |
|
|
PUBLIC-SECTOR-FUND-DATE-FROM |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the PUBLIC_SECTOR_ FUND_DATE_FROM field on the Benefit Tax Directive table. |
CCYYMMDD |
PUBLIC-SECTOR-FUND-DATE-TO |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the PUBLIC_SECTOR_ FUND_DATE_TO field on the Benefit Tax Directive table. |
CCYYMMDD |
AMOUNT-PUBLIC-SECTOR-FUND |
15 |
N |
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the TRANSFER_AMOUNT. Update the AMOUNT_PUBLIC_ SECTOR_FUND field on the Benefit Tax Directive table. |
|
DATE-AMOUNT-TRANSFER-PUBLIC-SECTOR-FUND |
8 |
|
Read the Type of Transfer on the Benefit Request and if it is TRN PROV – PUBL or TRN PEN – PUBL then populate this with the LUMPSUM_ACCRUAL_DATE. Update the DATE_AMOUNT_ TRANSFER_PUBLIC_SECTOR_ FUND field on the Benefit Tax Directive table. |
CCYYMMDD |
UNCLAIMED-BENEF-PREV-TAXED |
15 |
N |
|
|
EMAIL-ADDRESS-ADMINISTRATOR |
50 |
A/N |
Read ELECTRONIC_ADDRESS_ IDENTIFIER on the Client Address record linked to the Administrator. Update the EMAIL_ADDRESS_ ADMINISTRATOR field on the Benefit Tax Directive table with the value. |
|
TAXED-TRANSF-NON-MEMB-SPOUSE |
15 |
A/N |
|
|
DATE-DIVORCE-ORDER |
8 |
|
|
CCYYMMDD |
PAPER-RESP |
1 |
|
N |
Default this value to N |
Trailer Record
Column Heading |
Size |
Format |
System value / Default value |
Comment |
SEC-ID |
1 |
|
T |
|
REC-NO |
8 |
N |
Number of directive requests in the file |
Zero filled, right-justified. |
ANNUAL-INCOME-SUM |
16 |
N |
Aggregate of TP_ANNUAL_ INCOME fields in the file |
|
GROSS-LS-SUM |
20 |
N |
Aggregate of GROSS-LUMP-SUM fields in the file |
|
MEMBER-CONTRIB-SUM |
20 |
N |
Aggregate of MEMBER-OWN-CONTRIB fields in the file |
|
MEMBER-EXCESS-SUM |
20 |
N |
Aggregate of MEMBER-EXCESS-PENSION-CONTRIB in the file |
|
CONTRIB-TO-PREV-PROV-FUND-SUM |
20 |
N |
Aggregate of CONTRIB-TO-PREV-PROV-FUND fields in the file |
|
TRANSFER-AMOUNT-SUM |
20 |
N |
Aggregate of TRANSFER-AMOUNT fields in the file |
|
SURRENDER-VALUE-SUM |
20 |
N |
Aggregate of SURRENDER-VALUE fields in the file |
|
AMOUNT-PUBLIC-SECTOR-FUND-SUM |
20 |
N |
Aggregate of AMOUNT-PUBLIC-SECTOR-FUND fields in the file |
|