2.1.6 Tax Aggregation Interface Format
This topic explains the information on Tax Aggregation Interface Format.
The formats for export and import of files for transfer of tax information are given below. This is applicable to annuity taxes only.
The Record Specifications for the export file containing tax is as follows:
Table 2-29 Record Specifications for the Export File
| Field Name | Description | Data Type | Remarks |
|---|---|---|---|
| Tax Year | The tax year applicable –format – ddmmccyy | Number (8) | This will be set to the last day of the fiscal year in he required format. |
| LOB | Line of Business code – ‘GAL’ | String (3) | Will be set as ‘GAL’. |
| Agreement_Code | Contract number | Char (12) | Policy number |
| Product_Code | Product Code | Char (10) | Product code. |
| Sequence | Numeric Count | Number (4) | Record number, incremented sequentially. |
| Owner_Client_Id | Client Number or owner of the contract | Char (9) | The unitholder id. |
| Title | Null | Char (12) | This will be set to null. |
| Initials | Null | Char (15) | This will be set to null. |
| Surname | Null | Char (64) | This will be set to null. |
| IDNumber | Null | Char (15) | This will be set to null. |
| IDType | Null | Char (2) | This will be set to null. |
| DOB | Nulls | Char (10) | This will be set to null. |
| ClientType | ‘N’ for naturals | Char (1) | This will be set to null. |
| Tax_Number | Nulls | Char (12) | This will be set to null. |
| TRUSTNUMBER | Nulls | Char (12) | This will be set to null. |
| AnnuType | ‘C’ for compulsory, ‘V’ for voluntary | Char (1) | This will be set to ‘C’. |
| GN18 | ‘Y’ or ‘N’ | Char (1) | This will be set to ‘N’. |
| Fund Name | The pension Fund Name | Char (70) | Fund Name |
| Frequency | Frequency of the annuity income | Char (1) | The frequency of the annuity. |
| Payments_left | Number of payments left within the tax year | Number (2) | The remaining number of annuities to be executed. |
| TaxEarnings_YTD | The taxable earning to date for the tax year. | Number (8,2) | The total annuity till date, including the tax already applied. |
| TaxDeducted_YTD | Tax deducted for the tax year | Number (8,2) | The tax deducted for the current fiscal year. |
| TaxEarnings | Taxable earnings for this annuity income | Number (8,2) | Taxable earnings for this annuity income |
| TaxDeducted | Tax to be deducted for that annuity income | Number (8,2) | Tax to be deducted for that annuity income |
| SystemId | The system ID as defined by the tax aggregation module. | Char (10) | This will be set to ‘FCIS’. |
| Scheme | Nulls | Char (30) | This will be set to null. |
The control record for the export of information relating to tax has the following format:
Table 2-30 Control Record for the Export of Information
| Field Name | Description | Data Type | Remarks |
|---|---|---|---|
| Record | ‘CONTROL’ | Char (7) | This field will be set as ‘CONTROL’ |
| SystemId | The system ID as defined by the tax aggregation module. | Char (10) | Will be set as ‘FCIS’. |
| Entries | Numberof entries on the file | Number (8) | The number of entries in the file. |
| TaxEarnings_YTD | The taxable earning to date for the tax year. | Number (13,2) | Thesum of all the TaxEarnings_YTD in the file. |
| TaxDeducted_YTD | The tax deducted for that tax year. | Number (13,2) | Thesum of all the TaxDeducted_YTD in the file. |
| TaxEarnings | The taxable earnings for this annuity income | Number (13,2) | The sum of all the TaxEarn- ings in the file. |
| TaxDeducted | The tax to be deducted for that annuity income. | Number (13,2) | The sum of all the TaxDe- ducted in the file. |
| Tax_Recalc | Thetax amount that should be deducted | Number (13,2) | This will be set to null. |
| Tax_Differ | The difference between what should be deducted and what was calculated by the product admin system. | Number (13,2) | This will be set to null. |
| Monthly_Adjust | Not applicable | - | This will be set to null. |
The Record Specifications for the import of tax aggregation information into FCIS is as indicated below. The import will only log the data in the designated tables of FCIS. There is no processing carried out on the data imported.
Table 2-31 Tax Aggregation Interface Format - Record Specifications for the import of tax aggregation
| Field Name | Description | Data Type | Remarks |
|---|---|---|---|
| GCS_CLNO | The group client id | Char (20) | This field will be ignored |
| TaxYear | The tax year applicable in dd/ mm/ccyy format | Char (8) | - |
| TaxMonth | Month of the year | Char (2) | - |
| PARM | ProductCode | Char (8) | - |
| Agreement_Code | Contract Number | Char (12) | The policy number |
| Sequence | Numeric Count | Char (4) | This fiekld will be ignored |
| LOB | Line of Business – ‘GAL’ | Char (3) | This field will be ignored |
| Owner_Client_Id | Client Number or Owner of the contract | Char (9) | The unitholder id in FCIS |
| Tax_Number | Nulls | Char (12) | - |
| TrustNumber | Nulls | Char (16) | - |
| AnnuType | ‘C’ for compulsory, ‘V’ for voluntary | Char (1) | - |
| GN18 | ‘Y’ or ‘N’ | Char (1) | - |
| FundName | Nulls | Char (30) | - |
| Frequency | Frequency of the annuity income | Char (1) | - |
| Payments_Left | No of payments left within the tax year | Char (2) | - |
| TaxEarnings_YTD | The taxable earning to date for the tax year | Char (16) | - |
| TAXDEDUCTED_YTD | The tax deducted for that tax year | Char (16) | - |
| TaxEarnings | Taxable earnings for this annuity income | Char (16) | - |
| TaxDeducted | Tax to be deducted for that annuity income | Char (16) | - |
| Scheme | Nulls | Char (10) | - |
| Tax_Recalc | Tax amount that should be deducted | Char (16) | - |
| Tax_Deffer | The difference between what should be deducted and what was calculated by the product admin system | Char (16) | - |
| Monthly_Adjust | Not applicable | Char (16) | - |
| SystemId | The system ID as defined by the tax aggregation module | Char (10) | - |
| Tax_Remuneration | The total taxable income across the Old Mutual group | Char (16) | - |
The Control Record for the import of information pertaining to tax aggregation should be in the following format:
Table 2-32 Tax Aggregation - Control Record for the Import of Information
| Field Name | Description | Data Type | Remarks |
|---|---|---|---|
| Record | CONTROL | Char (7) | This field will be ignored |
| SystemId | The system ID as defined by the tax aggregation module | Char (10) | This field will be ignored |
| Entries | Number of entries on the file | Number (8) | This field will be ignored |
| TaxEarnings_YTD | The taxable earning to date for the tax year | Number (13,2) | This field will be ignored |
| TaxDeducted_YTD | The tax deducted for that tax year | Number (13,2) | This field will be ignored |
| TaxEarnings | The taxable earnings for this annuity income | Number (13,2) | This field will be ignored |
| TaxDeducted | The tax to be deducted for that annuity income | Number (13,2) | This field will be ignored |
| Tax_Recalc | The tax amount that should be deducted | Number (13,2) | This field will be ignored |
| Tax_Differ | The difference between what should be deducted and what was calculated by the product admin system | Number (13,2) | This field will be ignored |
| Monthly_Adjust | Not applicable | - | This will be set to null |
Parent topic: Fund Rules Upload Formats