Project

General

Profile

Support #851

Components of net monthly income

Added by Oliver Southwick about 3 years ago. Updated almost 3 years ago.

Status:
Closed
Priority:
Normal
Category:
Income
Target version:
-
Start date:
09/18/2017
Due date:
% Done:

100%

Estimated time:

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

History

#1 Updated by Stephanie Auty about 3 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

#2 Updated by Stephanie Auty almost 3 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

#3 Updated by Stephanie Auty almost 3 years ago

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

#4 Updated by Stephanie Auty almost 3 years ago

  • Status changed from Feedback to Resolved
  • % Done changed from 80 to 100

#5 Updated by Stephanie Auty almost 3 years ago

  • Status changed from Resolved to Closed

Also available in: Atom PDF