Project

General

Profile

Actions

Support #851

closed

Components of net monthly income

Added by Oliver Southwick over 7 years ago. Updated about 7 years ago.

Status:
Closed
Priority:
Normal
Category:
Income
Start date:
09/18/2017
% Done:

100%


Description

Hi,

I have noticed some cases of individuals where the components of net monthly income (e.g. labour income, social benefits etc.) sum to less than the total net monthly income. Is this a known data issue? In some cases for example the individual is employed but no labour income is recorded which suggests it may be a reporting error in the components?

Thanks very much,
Olly

Actions #1

Updated by Stephanie Auty over 7 years ago

  • Category changed from Data inconsistency to Income
  • Status changed from New to In Progress
  • Assignee changed from Alita Nandi to Stephanie Auty
  • % Done changed from 0 to 10
  • Private changed from Yes to No

Many thanks for your enquiry. The Understanding Society team is looking into it and we will get back to you as soon as we can.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer

Actions #2

Updated by Stephanie Auty about 7 years ago

  • Assignee changed from Stephanie Auty to Oliver Southwick
  • % Done changed from 10 to 50

Dear Olly,

The values should add up correctly subject to a bit of rounding error (maximum value 1.25p), but it does depend a bit what exactly you have done.

In principle fimngrs_dv=fimnlabgrs_dv+fibenothr_dv+(fiyrinvinc/12) and this seems to work.

There is a slight glitch at wave 6 since there are numbers of cases of fiyrinvinc missing (-9). Setting these to zero, the above formula works.

If this does not resolve your issue it would be helpful if you could send some examples of the problem. Please email directly if you are identifying individuals for data security reasons.

Best wishes,
Stephanie Auty - Understanding Society User Support Officer

Actions #3

Updated by Stephanie Auty about 7 years ago

  • Status changed from In Progress to Feedback
  • % Done changed from 50 to 80
Actions #4

Updated by Stephanie Auty about 7 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100
Actions #5

Updated by Stephanie Auty about 7 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF