Backend Write-up: Attendance Rate Added into Schemas

[izzyconner]

Description

Determine the best way to store attendance rate for a user and add in any necessary fields to the database schemas. Write up the proposed method for attendance rate calculation, including calls and coalescing needed on the backend.

Attendance rate can be calculated for:

• Shifts where reports were filed
• Shifts where the associate didn't show up
• Shifts where the associate was late/early

Attendance rates should be able to be calculated for a given associate:

• Per week
• Per month
• Total

Conditions of Satisfaction

• Any fields necessary to add into TimesheetEntry schema have been added to the Lucidchart schema diagram
• Any fields necessary to add into TimesheetEntry schema have been added to the Dynamo schemas in the backend
• Any fields necessary to add into TimesheetEntry schema have been added to the shared schemas
• A one-page write-up is available to describe the proposed method for calculating various attendance rates

[neetidesai]

Don't have a ton to say so I'll put my writeup here.

I wanted to introduce attendance tracking with minimal backend changes. So, I propose adding an list of Attendance enums to the TimesheetEntry schema, which would be a list containing any of ABSENT, ON_TIME, LATE, or EARLY. Then, to find shifts where reports were filed, comments were left, etc. etc. you would filter shifts by 1.) If the attendance list exists and does not only contain ABSENT, and then 2.) If a report was filed, if the employee left late, came early, both, etc. etc. Let me know if I approached this the wrong way or more needs to be done! Link to the branch with the modified schemas here: https://github.com/Code-4-Community/breaktime/tree/22-attendance-rate-ND