Include Age in longitudinal export

[mahalakshme]

https://avni.freshdesk.com/a/tickets/3272

Need:

User request for easier consumption of data.

AC:

• Include Age in the Longitudinal export data of both versions.

• Make age in decimals(with 2 digit precision) - decimal points will be based on months alone. Eg: if someone if 6 years 2 months old then age will be 6.17

• Currently we are exporting date_of_birth column for all subject types like Household even when not applicable. The same behavior can be retained for age.

• For the old longitudinal export, we are exporting basic individual fields like date_of_birth and gender for all report types like Registeration, Enrolment, Encounter, etc., Hence export age column as well wherever we are exporting date_of_birth.

• For the new longitudinal export, include age column when present as part of fields of the 'Request body'.

  

• Include age as one of the default fields in the request body template above.

Analysis reasons:

• Both old and new needs to be supported because from the DB found that old is used lot more than new one. Support needs to continue until we add UI to new longitudinal export.

Inputs

• support in new LE
• 2 columns for years and months
• taqi to try to handle on field

[mahalakshme]

not needed by the user who raised the issue, since they would calculate it from dob in excel