Tax Directive Request File Extract (Benefit Payments)

Processing

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.

 

iTax

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

 

 

Easytax

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