- Days between signature and approval tab - What's included in this report?
- Days between placement and approval tab - What's included in this report?
- What are some possible causes for discrepancies to be aware of?
Purpose of report
The Time to Approval report is a visual summary of the number of days between an application being signed (or the most recent date that the application status was changed to applying) and being approved, to assist workers and supervisors to understand time to approval.
There are 2 tabs showing days between signature and approval, and days between placement and approval. Both tabs consist of a plot graph and a data table summarizing various metrics. Each dot in the plot graph represents a data point, while the blue line represents the average of data in each month. The table below shows numerically the average, minimum, median, and maximum number of days for each month.
Notice the second tab “Days between placement and approval”; this shows data only for families with a child already placed in the home prior to approval.
- Date Application Signed: This is the date the form designated as the “initial application” is signed. You can see this date for any given application by either
- Going to Applicant Data, then Documents, and viewing when the ‘Initial Application’ form was signed by the applicant
- Going to Applicant Data, then scrolling down to Application History and see what date the application’s status was changed to ‘Applying’
- Date of Approval: This is the date that an application’s status is changed to ‘Approved’. This is also referred to as the ‘status date’. You can see this date for any given application by either:
- Viewing the Approval Date in the ‘Approved’ tag on the Applications dashboard
- Viewing the Initial Approval Date in the ‘In Renewal’ tab on the Applications dashboard
- Going to Applicant Data, scrolling down to “Other applications for this family”, and looking at the date the Initial Application was approved
- Date of Placement: This is the start date of the applicant’s oldest ongoing placement. This date only populates while the child is in the applicant’s home.
- You can see this date for any given application by going to Applicant Data, then scroll down to “Historical Child Placements Provided”, and date of placement will correspond to “Date Child Joined Placement”.
- As long as the child has not left the placement and there is no “Date Child Left Placement”, the Date of Placement will be populated with the “Date Child Joined Placement”.
- What is included in this report? Days between signature and approval tab
- Initial Applications where:
- The date the application was signed also corresponds to the most recent date and application’s status was changed to ‘applying’, for applications that changed status before approval
- the status date (aka date of approval) is not null
- the date the application was signed is not null
- the status was not updated on the same date the application was created in Binti
- the status was ‘approved’ before being changed to ‘closed’ (if the application status is closed)
- If using date filters, the status date is after the filter’s start date, and status date is before the filter’s end date
- Historical/imported applications are included
What is included: Days between placement and approval tab
- Of the applications included in the above tab, the applicants that have an ongoing placement where the placement started before the applicant was approved (date_of_placement < status_date)
- What is excluded in this report?
- All Renewal Applications
- Applications with statuses that are Recruiting, Applying, Closed (pre Approval), Denied, or Withdrawn
- Applications with no status date (as in no date of approval)
Data points/calculations: Days Between Signature and Approval Tab
- The graph and table show time to approval based on the month that an application’s status was changed to ‘approved’
- The plot graph shows the monthly distribution of applications, with the y axis being the days to approval and each dot representing one or more applications that have a time to approval of y number of days
- When you hover over a dot in the graph, a tooltip will show the number of applications and how many days it took to approve them
- In the legend above the graph, clicking either of the colored rectangles will exclude that group of data from the graph. For example, clicking the gray rectangle that represents ‘Days between signature and approval’ will exclude the gray dots from the graph and leave only the blue line for Monthly Averages. This is especially helpful when the scale for one group of data (Monthly Averages) is smaller than the other (Days between signature and approval), allowing better visibility when viewing the graph on a smaller scale.
- The table below this chart shows various statistical summaries of the time to approval each month, including
- The average number of days to approve an application
- The minimum number of days to approve an application
- The 25% percentile, meaning 25% of applications approved that month took that many days or less to approve
- The median, or 50% percentile, meaning half of applications approved that month took that many days or less to approve
- The 75% percentile meaning 75% of applications approved that month took that many days or less to approve
- The maximum number of days to approve an application
- The count of applications approved that month
Data points/calculations: Days Between Placement and Approval Tab
- The Days between Placement and Approval tab has the same graph and table as the Days between Signature and Approval tab, except instead of calculating days from application signature, this tab calculates from the Date of Placement to the Date of Approval.
- This tab is primarily for agencies that place families with children prior to licensure, and not all agencies will have data populated in this tab.
- The above filters will filter the applications counted in the report
- ‘Worker assigned’ will filter for initial applications that are still assigned to any listed worker’s name
- ‘Supervisor’ will filter for initial applications assigned to workers that currently set as reporting to the listed supervisor
- ‘Manager of supervisors’ will filter for initial applications assigned to workers that are directly under supervisors that are managed by any listed manager’s name
- ‘Family type’ will filter for initial applications where the family type is Relative, Fictive Kin, Community, Guardian, and/or Unknown
- ‘Time to approval’ filters for initial applications where the days to approve are within the listed ranges
- ‘Approval Date’ will filter for initial applications where the Date of Approval is between the chosen start and end dates
- ‘Offices’ will filter for initial applications assigned to workers that are associated with a listed Office, if it applies
Possible causes for discrepancies
- In cases where application dates need to be changed, an application’s status will need to be changed in order to edit the date so this can cause applying/approval dates to be different that what they should be
- The report also counts status changes, not necessarily distinct applications, so in cases where an application’s status is changed multiple times, each instance of a status change to approval will be counted
What can I do if I have questions that weren't addressed in this help article?
If you have any other questions, please feel free to email us at firstname.lastname@example.org, send us a chat using the chat icon (bottom right hand corner), or give us a call at 1-844-424-6844.