3 Tables

This chapter contains the following topics:

• Tables overview
  The Oracle Health Immunization Management tables provide columns with details on patients, locations, schedules, and appointments. The tables categorize the information you can analyze when you build reports from real data in Oracle Analytics. The fact tables include the numeric data on specific types of columns.
• Administrative - IDCS Login
  The Administrative - IDCS (Identity Cloud Service) Login table includes columns related to the account information that users entered to log in to Oracle Health Immunization Management.
• Administrative - IDCS Login Fact
  The Administrative - IDCS (Identity Cloud Service) Login Fact table includes columns related to the facts on the login process in Oracle Health Immunization Management.
• Administrative - IDCS Users
  The Administrative - IDCS (Identity Cloud Service) Users table includes columns related to the user account information that patients or Oracle Health Immunization Management users entered.
• Appointment History
  The Appointment History table includes columns related to the reserved appointment information in Oracle Health Immunization Management.
• Appointment History Fact
  The Appointment History Fact table includes a column related to the facts on the reserved appointments in Oracle Health Immunization Management.
• Appointment Slots
  The Appointment Slots table includes columns related to the appointment slots used in Oracle Health Immunization Management schedules.
• Appointment Slots Fact
  The Appointment Slots Fact table includes columns related to the facts on appointment slots used in Oracle Health Immunization Management schedules.
• Appointment Types
  The Appointment Types table includes columns related to the appointment booked in Oracle Health Immunization Management.
• Calendar Date
  The Calendar Date table includes columns related to the calendar used in Oracle Health Immunization Management to book appointments.
• Locations
  The Locations table includes columns related to the locations created in Oracle Health Immunization Management.
• Manufacturers
  The Manufacturers table includes columns related to the vaccine manufacturers used for appointments booked in Oracle Health Immunization Management.
• Notification Log
  The Notification Log table includes columns related to the notifications sent from Oracle Health Immunization Management.
• Notification Log Fact
  The Notification Log Fact table includes a column related to the facts on notification log in Oracle Health Immunization Management.
• Notification Service Usage
  The Notification Service Usage table includes columns related to the account and subscription for Oracle Healthcare Notifications Cloud Services used to send SMS messages to patients related to vaccine appointments in Oracle Health Immunization Management.
• Notification Service Usage Fact
  The Notification Service Usage Fact table includes columns related to the facts on the number of notification messages sent for appointments in Oracle Health Immunization Management.
• Notification Service Subscription
  The Notification Service Subscription table includes columns related to the account and subscription for Oracle Healthcare Notifications Cloud Services used to send SMS messages to patients related to vaccine appointments in Oracle Health Immunization Management. For example, it provides details on when subscription ends and starts again.
• Patient
  The Patient table includes columns related to the patient account information that patients or Oracle Health Immunization Management users entered.
• Patient Fact
  The Patient Fact table includes a column related to a fact about patients in Oracle Health Immunization Management.
• Patient Group
  The Patient Group table includes columns related to the patient group information that a Oracle Health Immunization Management user entered.
• Patient Notes
  The Patients Notes table includes columns related to notes about the patient in Oracle Health Immunization Management.
• Patient Procedures
  The Patient Procedures table includes columns related to the procedures performed on patients in Oracle Health Immunization Management.
• Patient Procedures Fact
  The Patient Procedures Fact table includes columns related to the facts on the procedures performed in Oracle Health Immunization Management.
• Procedures Summary
  The Procedures Summary table includes columns related to the summary information on procedures performed in Oracle Health Immunization Management.
• Procedures Summary Fact
  The Procedures Summary Fact table includes columns related to the facts on the procedure summary information in Oracle Health Immunization Management.
• Products
  The Products table includes columns related to the product used for appointments in Oracle Health Immunization Management.
• Schedule Details
  The Schedule Details table includes columns related to the schedules created in Oracle Health Immunization Management.
• Subscription
  The Subscription table includes columns related to the subscription dates to use Oracle Healthcare Notifications Cloud Services to send SMS messages to patients related to vaccine appointments in Oracle Health Immunization Management.
• Tenants
  The Tenants table includes columns related to tenants who use Oracle Health Immunization Management.
• Users
  The Users table includes columns related to the user account information that Oracle Health Immunization Management administrators or users entered.
• User Login HMS
  The User Login HMS table includes columns related to the user account information that patients or Oracle Health Immunization Management users entered.
• User Login HMS Fact
  The User Login HMS Fact table includes columns related to the facts on the number of user or patient logins to Oracle Health Immunization Management.