Data model for denormalized tables in Field Service Management

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • Use the table below to reference the Field Service Management weekly resource span denormalized table.

    Table 1. Weekly resource span table
    wm_weekly_resource_span
    Resource type Choice User/Crew/Equipmen/Schedule
    Resource id String (size of 40)
    Weekly start Date/Time Week starts at 12:00AM UTC
    Weekly end Date/Time Week ends at Saturday 23:59:59PM UTC
    Span Time zone String (size of 40)
    Spans JSON List of weekly schedule and event spans
    Domain Domain id