The 'DETRET' file contains posting requests, as sent by the 'DEMDET' file, with the addition of a rejection code.
| code |
description |
|---|---|
| 99 | File format no longer supported, please use XML format (from 2 april 2024) |
| 1 | The employer registration number is incomplete or incorrect. |
| 2 | The insured's social security number is incomplete or incorrect. |
| 3 | The insured's postcode is missing. |
| 4 | The insured's town/city is missing. |
| 5 | The insured's country code is incorrect or missing. |
| 6 | The statement start date is incorrect or missing. |
| 7 | The statement end date is incorrect or missing. |
| 8 | The end date is before the start date. |
| 9 | The only 1 country pointer is invalid or missing. |
| 10 | The no fixed address pointer is invalid or missing. |
| 11 | The ship pointer is invalid or missing. |
| 12 | Activity normally pursued in 2 or more EU Member States pointer is incorrect or missing. |
| 13 | If occupation in country of residence pointer is incorrect or missing. |
| 14 | Activity in Switzerland pointer is incorrect or missing. |
| 15 | Activity in Liechtenstein pointer is incorrect or missing. |
| 16 | Activity in Norway pointer is incorrect or missing. |
| 17 | Activity in Iceland pointer is incorrect or missing. |
| 18 | Activity in one or more third party states pointer is incorrect or missing. |
| 19 | |
| 20 | Ship country code is incorrect or missing. |
| 21 | Ship name is missing. |
| 22 | Ship pointer = Y and ship name and flag country code (fields 20 and 21) are not given. |
| 23 | The ship name and maritime flag country code are given, but the ship pointer = N. |
| 24 | The ship name has been provided, the flag country code is not given and the ship pointer = N. |
| 25 | The flag country code is given. The ship pointer = N and the ship name is not given. |
| 26 | The third party state pointer = Y, but no country is given (field 29 is empty). |
| 27 | The third party country field has been filled in, but the third party state pointer = N. |
| 28 | The activity in Switzerland field = Y. If Switzerland is the only country, fields 11 to 18 should be used. |
| 29 | The activity in Liechtenstein field = Y. If Liechtenstein is the only country, fields 11 to 18 should be used. |
| 30 | The activity in Norway field = Y. If Norway is the only country, fields 11 to 18 should be used. |
| 31 | The activity in Iceland field = Y. If Iceland is the only country, fields 11 to 18 should be used. |
| 32 | No data for posting/activity in several states are given or all pointers = N (fields 11,18,19,22,23,24,25,26,27,28). |
| 33 | Inconsistency between ship data (fields 19 to 21) and activity normally pursued in 2 or more states data (fields 22 to 29). |
| 34 | Inconsistency between posting to a country data (fields 11 to 18) and activity normally pursued in 2 or more states data (fields 22 to 29). |
| 35 | Inconsistency between posting to a country data (fields 11 to 18) and ship data (fields 19 to 21). |
| 36 | Inconsistency between posting to a country data (fields 11 to 18), ship data (fields 19 to 21) and activity normally pursued in 2 or more states data (fields 22 to 29). |
| 37 | The workplace postcode (field 15) is missing or invalid. |
| 38 | The workplace town/city (field 16) is missing or invalid. |
| 39 | The workplace country code (field 17) is incorrect or missing. |
| 40 | The workplace postcode (field 15) and the workplace town/city (field 16) are not given. |
| 41 | The workplace postcode (field 15) and workplace country code (field 17) are not given. |
| 42 | The workplace town/city (field 16) and the workplace country code (field 17) are not given. |
| 43 | Inconsistency between 'pas d'adresse fixe' pointer (field 18) and workplace data (fields 12 to 17). |
| 44 | The workplace postcode (field 15), town/city (field 16) and country code (field 17) are not given. |
| 45 | The workplace postcode (field 15) is not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 46 | The workplace town/city (field 16) is not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 47 | The workplace country code (field 17) is not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 48 | The workplace postcode (field 15) and the workplace town/city (field 16) are not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 49 | The workplace postcode (field 15) and the workplace country code (field 17) are not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 50 | The workplace town/city (field 16) and the workplace country code (field 17) are not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 51 | The workplace postcode (field 15), town/city (field 16) and country code (field 17) are not given. There is also an inconsistency between the 'pas d'adresse fixe' pointer (field 18) and the address data (fields 12 to 17). |
| 52 | Inconsistency between only 1 country pointer and 'lieu de travail' data (fields 12 to 18). |
DETRET file specifications
- The file is an uncompressed, ASCII-coded text file;
- Fields are separated by a semicolon (;);
- Each record ends with a carriage-return (0D hex) and a line-feed (0A hex).
File name on receipt by SOFiE
DETRET.xxxx_yyyy_zzzz.dta
xxxx = employer registration number of the SECUline member
yyyy = SECUline number
zzzz = time stamp