Appointments Dataset

This view contains the following columns, pulling data from all Appointments:

• AppointmentID
  
• AppointmentType
  
• OrganizationID
  
• ServiceProvider
  
• ClientID
  
• ClientName
  
• WithName
  
• StartDateTime
  
• EndDateTime
  
• DurationMins
  
• DurationHrs
  
• Description
  
• Comments
  
• FollowThroughYN
  
• From the "Location" field:
  • LocationPlaceID
    
  • Location
    
  • PlaceType
    
  • Address
    
  • Unit
    
  • AddressLn1
    
  • AddressLn2
    
  • City
    
  • Province
    
  • Country
    
• ViewVersion

Documentation

• vw_ACRE_Appointments - Sample Output.csv
• vw_ACRE_Appointments - Schema.csv