---
sourceDocument: Yokohama Field Service Management
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/field-service-management

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Field Service Management

ft:clusterId :

    - fsm

bundleId :

    - fsm

workflow :

    - Customer and Industry


---

# Data model for denormalized tables in Field Service Management

# Data model for denormalized tables in Field Service Management {#ariaid-title1}

Release version: Yokohama  
Updated January 30, 2025  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Use the table below to reference the Field Service Management weekly resource span denormalized table.
{#flat-table-model__table_anr_tht_kdc__entry__1}

| 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 |   |
[Table 1. Weekly resource span table]

{#flat-table-model__table_anr_tht_kdc}