SALRET

Reports unprocessable records in the DECSAL.dta file

The Social Security Centre (Centre commun de la sécurité sociale - CCSS) sends the 'SALRET' file with the wage records marked with a rejection code. Rejection corresponds to an erroneous record.

The file contains the wage records as sent by the 'DECSAL' file, with the addition of a rejection code.

 

List of rejection codes
code
description
1 There are 2 records for the same affiliate, the same employer and the same period
2 The employer registration number is incomplete or incorrect, or the employer uses the simplified procedure for households
3 The insured's social security number is incomplete or incorrect. (see DENMAT documentation)
4 There is non-numerical data in the hours and/or amounts
5 The period is not in YYYYMM format where YYYY > 2018 and 0 < MM < 13
6
abolished
7 The 'chômage' amount = 0 but the inactive hours are > 0
8 The 'heures supplémentaires' amount = 0 but the overtime hours > 0
9 Future period (> current month -1)
10 Non-pensionable supplement (amount > 0 in field 13, but the insured in question is not a civil servant)
11 Hours (sum of hours of work and inactive hours) > 372
12 Period < 2019 (records relating to periods prior to 2019 are no longer accepted electronically)
13 Capped wage indicator = Y and salary ≠ 7MW
14 Affiliation does not exist after 1 month of wage statement being put on hold
99
Formatting error, erroneous layout, previous layout, etc.

 

This file is sent automatically if at least one wage record from the 'DECSAL' procedure could not be processed.

 

SALRET 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

SALRET.xxxx_yyyy_zzzz.dta

xxxx = employer registration number of the SECUline member
yyyy = SECUline number
zzzz = time stamp

Last update