Appointment Slots Fact

The Appointment Slots Fact table includes columns related to the facts on appointment slots used in Oracle Health Immunization Management schedules.

Details

Module: Oracle Health Immunization Management

Table 3-7 Appointment Slots Fact Columns

Name	Description
# of Slots Created	Number of slots created
# of Appointments	Number of appointments by the appointment date
# of Scheduled Appointments	Number of scheduled appointments by the appointment date
# Future Appointments	Number of future appointments from the current day
# Past Appointments	Number of past appointments from the current day
# Assigned	Number of slots by assigned date
# Checked In	Number of slots by checked in date
# Confirmed	Number of slots by confirmation date
# Followed up	Number of slots by followed up date
# Vaccinated	Number of slots by vaccination date
# of No Shows	Number of people who did not check in on appointment date (for example, null check-in date)
% No Shows of Processed	Percentage of no shows by processed appointments
# Not Vaccinated	Total number of No Shows appointments and Unable to Administered procedures