Please note: Birdie Raw Data is offered as a separate professional service from Birdie. Please get in touch if interested in more information on this feature!
Birdie Raw Data provides you with flat tables that can be seamlessly imported into your own Business Intelligence tool.
Please note: this solution is different than access to Birdie's API, which requires all of the data modelling to be done by your agency. You can also get in touch if interested in learning more about this.
Tables available in Birdie
Database name | Table Name | Table Description |
BIRDIE_INBOX | ACTIONS | List of actions and their details from the Birdie platform. |
BIRDIE_INBOX | ACTIONS_TO_ CAREGIVER_MAPPING | Mapping between actions and caregivers, where an action has been linked to a specific caregiver. |
BIRDIE_INBOX | ACTIONS_TO_CLIENT_MAPPING | Mapping between actions and clients, where an action has been linked to a specific client. |
BIRDIE_INBOX | ACTIONS_TO_TAGS_MAPPING | Mapping between actions and tags, where an action has been tagged with one or more categories. |
BIRDIE_INBOX | ALERTS | A list of alerts raised to care managers which are then viewed, qualified and actioned in the agency hub. |
BIRDIE_INBOX | ALERT_COMMENTS | A list of comments added to alerts in the Inbox tab. |
BIRDIE_ASSESSMENTS | ASSESSMENTS | List of clients' assessments with timestamps of key actions taken against them (e.g. when created or completed). |
BIRDIE_ASSESSMENTS | ASSESSMENTS_ IGNORED | Details of when a recommended assessment has been ignored by a user, the reason why. |
BIRDIE_CORE_API | BRANCHES | One row per branch. Sourced from Birdie backend system. |
BIRDIE_CAREGIVERS | CAREGIVERS_ ONBOARDING_DOCUMENTS | Details of onboarding documents for caregivers added to the onboarding section of a caregiver's profile. |
BIRDIE_CAREGIVERS | CAREGIVERS_PROFILES | Details from the 'Basic info' section of a caregiver's profile. |
BIRDIE_CAREGIVERS | CAREGIVER_ABSENCES | List of absences recorded for caregivers. |
BIRDIE_CAREGIVERS | CAREGIVER_ AVAILABILITY_INSTANCES_CANCELLED | List of cancelled instances of caregiver availability. This can be used alongside the caregiver_absences model to understand when caregivers are available. |
BIRDIE_CAREGIVERS | CAREGIVER_AVAILABILITY_SCHEDULE | List of availability schedules recorded for caregivers. |
BIRDIE_CAREGIVERS | CAREGIVER_CAPACITY | Calculation of a carer's capacity in 15-minute increments for two weeks from next Monday. |
BIRDIE_CAREGIVERS | CAREGIVER_EMPLOYED_AND_SCHEDULED_HOURS | List of caregivers' current employed (preferred and contracted, where available) and scheduled hours. Scheduled hours are only available if preferred or contract details are provided. |
BIRDIE_CAREGIVERS | CAREGIVER_TO_RATE_CARD_MAPPING | Current mapping between caregivers and rate cards. Caregivers can only be assigned to one rate card at a time. |
BIRDIE_CAREGIVERS | CAREGIVER_VISITS | Visit details that are specific to the caregiver completing the visit, e.g. check-in/out times or payroll amounts. Contains one row per distinct caregiver / visit combination, ie. double-up visits will have a separate row for each caregiver. |
BIRDIE_CORE_API
| CARE_SCHEDULES | List of care schedules created for tasks. |
BIRDIE_CORE_API | CARE_TASK_INSTANCES | Individual instances of tasks planned for clients generated from their task schedules. |
BIRDIE_CORE_API | CLIENTS | Client details with one row per client. |
BIRDIE_CORE_API | CLIENT_ACTIVATION_HISTORY | A list of clients by ID and the periods in which they are active or inactive. |
BIRDIE_CORE_API | CLIENT_OBSERVATIONS | List of observations made by caregivers about clients. |
BIRDIE_CORE_API | CLIENT_RISK_LEVEL_UPDATES | Care recipient risk level (RAG status) history. This includes updates to a risk level and/or the reason for this risk level. |
BIRDIE_CORE_API | CLIENT_WATERLOW_SCORE_UPDATES | The Waterlow Score calculates the risk of pressure ulcers. This model creates a table that shows changes in Waterlow score for clients. |
BIRDIE_CORE_API | CONCERNS | Details of concerns raised by caregivers during visits. |
BIRDIE_CORE_API | CONTRACTS | Details of contracts that have been created in Birdie's finance tab. |
BIRDIE_ANALYTICS | DAILY_CLIENT_QUALITY_SCORE_METRICS | Records quality score metrics for each day that a client is active. Excludes test/demo clients. |
BIRDIE_CORE_API | GROUPS | List of groups used to organise clients and caregivers. |
BIRDIE_CORE_API | GROUPS_TO_CAREGIVERS_MAPPING | Lookup table for mapping caregivers to groups. |
BIRDIE_CORE_API | GROUPS_TO_CLIENTS_MAPPING | Lookup table for mapping clients to groups. |
BIRDIE_BILLING | HOLIDAY_PAY | Summary of holidays taken, pay and projected holidays to be booked for the current week based on an accrual rate of 12.07%. |
BIRDIE_BILLING | HOLIDAY_PAY_DATA_ISSUES | Highlights problems with data imported from the data migration SFTP site for holiday pay calculations. |
BIRDIE_BILLING | HOLIDAY_PAY_TAKEN | Holidays taken per day by caregiver and amount to pay for each day. |
BIRDIE_INBOX | INBOX_RELATIONS | Mappings of relations of actions to other entities (e.g. visits, alerts or notes) logged in Inbox. |
BIRDIE_BILLING | INVOICES | List of invoices that have been generated and their current status. |
BIRDIE_BILLING | INVOICE_ADJUSTMENTS | List of extra charges and deductions on invoices. |
BIRDIE_BILLING | INVOICE_ITEMS | List of invoices and related visits, along with information on amount and value of hours worked, hours travelled and miles traveled. |
BIRDIE_BILLING | INVOICE_SUBSCRIPTION_ITEMS | List of subscription items added to an invoice. |
BIRDIE_CORE_API | MEDICAL_HISTORY | Clients' medical history. |
BIRDIE_CORE_API | MEDICATION_SCHEDULES | List of medication schedules created for clients. |
BIRDIE_CORE_API | MEDICATION_TASK_INSTANCES | Individual instances of medication tasks for clients based on their medication schedules. |
BIRDIE_ANALYTICS | MONTHLY_ACTIVE_CAREGIVERS | List of new, existing and lost caregivers in each month based on the start date and date terminated or made inactive on the Birdie platform. |
BIRDIE_ANALYTICS | MONTHLY_ACTIVE_CLIENTS | List of new, existing and lost clients in each month. New clients are those active for the first time this month. Existing clients are active this month also active in previous months. Lost clients are those in-active this month that were active last month. A client is considered active when they are activated in the Birdie system for 5 or more days in the month. |
BIRDIE_INBOX | NOTES | List of notes logged in Inbox. |
BIRDIE_INBOX | NOTES_TO_CAREGIVER_MAPPING | Mapping between notes and caregivers, where an note has been linked to a specific caregiver. |
BIRDIE_INBOX | NOTES_TO_CLIENT_MAPPING | Mapping between notes and clients, where an note has been linked to a specific client. |
BIRDIE_INBOX | NOTES_TO_TAGS_MAPPING | Mapping between notes and tags, where an note has at least one tag. |
BIRDIE_BILLING | PAYERS | List of payers from the Finance tab. |
BIRDIE_BILLING | PAYRUNS | List of pay runs created in the Finance tab and their current status. |
BIRDIE_BILLING | PURCHASE_ORDERS | List of purchase orders and their current status. |
BIRDIE_MATCHING | QUALIFICATIONS | List of caregivers' skills logged in the skills section of a caregiver's profile. |
BIRDIE_BILLING | RATE_CARDS | List of rate cards from the Finance tab. Includes deleted rate cards. |
BIRDIE_BILLING | RATE_CARD_DETAILS | Details of the most recent Pay and Charge rate cards from the Finance tab. Rate cards can have multiple rate levels within them - this model contains one row per rate card element. |
BIRDIE_BILLING | HOLIDAY_RATES | List of holiday rates from the Finance tab and their respect pay and charge multipliers. |
BIRDIE_VISIT_PLANNING | SCHEDULED_MEDICATION_TASK_INSTANCES_TO_VISIT_MAPPING | List of scheduled medication instances mapped to a scheduled visit. |
BIRDIE_VISIT_PLANNING | SCHEDULED_TASK_INSTANCES_TO_VISIT_MAPPING | List of scheduled tasks mapped to a scheduled visit. |
BIRDIE_VISIT_PLANNING | SCHEDULED_VISITS_LEAN | Lean list of visits and assigned caregivers for visits created on the birdie platform. Updated more frequently than the visits model. |
BIRDIE_VISIT_PLANNING | SERVICE_TYPES | List of service types by ID and name. |
BIRDIE_CORE_API | TASK_SCHEDULES | List of task schedules created for clients. |
BIRDIE_BILLING | TRAVEL_RATE_CARDS | List of travel rate cards and details from the Finance tab along with their status. |
BIRDIE_CORE_API | USERS | One row per user of the Birdie mobile app / agency hub. |
BIRDIE_CORE_API | USERS_TO_BRANCH_ROLE_MAPPING | Mapping of users to branches, as users can have be associated with one or more branches. |
BIRDIE_CAREGIVERS | USER_BRANCH_ATTRIBUTES | List of user details per branch. |
BIRDIE_ANALYTICS | VISITS | List of scheduled and unscheduled visits, with one row per visit. This contains scheduled visits for the upcoming five weeks, or further into the future where they have been viewed on the Agency Hub. |
BIRDIE_VISIT_PLANNING | VISITS_FORECAST | List of vists for a rolling period of 14 weeks into the future and 6 weeks into the past. |
BIRDIE_ANALYTICS | WEEKLY_SUPPORT_CHAT_METRICS | Summaries of support chats by week and branch ID. Users linked to multiple branches will have a null branch ID. |
BIRDIE_ANALYTICS | WEEKLY_SUPPORT_CHAT_PRODUCT_AREA_METRICS | Summaries of support chat conversations per product area and sub-area by week and agency ID. Only includes user-generated chats. |
Common 'Joins' available in Birdie
A ‘join’ is joining tables together based on common field names. Common joins available in Birdie include the following:
Clients table joins by client_id to the Visits table
Visits table joins by visits_id to a table called Caregiver_visits
Caregiver_visits table joins by the caregiver_id of the Users table