Jersey Effective Rate Wizard Import File Fields Guide
This guide explains the fields, accepted formats, and allowed values required for the Effective Rate Wizard import file.
This guide provides you with a detailed description of all of the fields within the effective rate tax wizard import file exported from the Jersey government empret portal.
| Schema Field | Value and Description |
| ExportedOn |
YYYY-MM-DDTHH:MM:SS The date and time at which the file was downloaded from the wizard. |
| EmployerTinRef |
NNN-NNN-NNNN-NN The Employer’s Tax Identification Number and Business Reference. The first ten digits make up the TIN; the remaining two digits make up the Business Reference. N = digit (0–9). |
| EmployerName |
<CompanyName> The employer’s name. |
| empeLasNam |
<LastName> The Employee’s last name. |
| empeFirNam |
<FirstName> The Employee’s first name.
|
| empeTinRef |
NNN-NNN-NNNN The Employee’s Tax Identification Number. N = digit (0–9).
|
| empeSocSec |
LLNNNNNNL The Employee’s Social Security Number. L = letter (A–Z); N = digit (0–9); always 9 characters.
|
| EffectiveRate |
<number> The current ITIS Effective Rate value (%) for the employee. |
| Card / CardStatusCode |
Blue (FR1) / Blue -Employee holds a blue card (FR1): both primary and secondary contributions are payable.
-Employee holds a red card (XR1): only the secondary contribution is payable.
-Employee has no contribution liability because they are under school leaving age.
-Employee is the owner or director of the business, and the class 1 deductible is not applicable to them. |
| Changed / ChangedStatusCode |
<blank> / 0 -No changes to the Effective Rate or the Registration Card since the previous CER submission.
-Only the Effective Rate value has changed since the previous CER submission.
-Only the Registration Card status has changed since the previous CER submission.
-Both the Effective Rate and the Registration Card have changed since the previous CER submission. |
To find out how to use the guide, see the import user guide here.