Pattern: Time pattern (/ = 5 min work, X = 5 min break). E.g., "//XXXXXX//" = 10min work, 30min break, 10min work
PatternSecondary: Secondary provider pattern (optional, same format as Pattern)
Confirmed: Confirmation type number (varies by practice setup)
Note: Appointment notes/description
ProvNum: Provider (dentist) number
ProvHyg: Hygienist number (0 if not applicable)
ClinicNum: Clinic number (for multi-clinic practices)
IsHygiene: "true" or "false" - is this a hygiene appointment
IsNewPatient: "true" or "false" - is this a new patient
Priority: "Normal", "ASAP", "Low", etc.
AppointmentTypeNum: Appointment type ID from practice settings
SecUserNumEntry: Security user number (who created it)
colorOverride: Custom color in RGB format "R,G,B" (e.g., "180,30,150")
DateTimeArrived: When patient arrived (optional, usually set later)
DateTimeSeated: When patient was seated (optional, usually set later)
DateTimeDismissed: When patient left (optional, usually set later)
Key Response Fields:
AptNum: Unique appointment ID (assigned by OpenDental)
AptStatus: Status as string ("Scheduled", "Planned", "Complete", etc.)
confirmed: Human-readable confirmation status
provAbbr: Provider abbreviation/name
ProcDescript: Procedure descriptions for appointment
InsPlan1, InsPlan2: Insurance plan IDs
DateTStamp: Last modified timestamp
TimeLocked: Whether appointment time is locked from changes
Usage Notes:
• Start with minimal required fields (PatNum, Op, AptDateTime) for basic appointments
• Add optional fields as needed for more detailed scheduling
• Boolean fields should be strings: "true" or "false", not native booleans
• Date/time fields use format: "yyyy-MM-dd HH:mm:ss"
• colorOverride uses RGB values separated by commas (no spaces)
• Pattern defines duration: each character = 5 minutes