All Collections
Reporting with Birdie Analytics
Birdie Raw Data
List of data points available from Birdie Raw Data - Tables available
List of data points available from Birdie Raw Data - Tables available

An overview of the data points available via Birdie Raw Data.

Sabrina Treitz avatar
Written by Sabrina Treitz
Updated this week

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_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

Did this answer your question?