These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- Retail ITSM
- Data model
The tables behind Retail ITSM
Retail ITSM ships with 12 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 12
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Incident response
Incidents link to Services, Assets and People through assignment; incident updates retain dated author contributions.
Store context
Register outages and store trading windows each reference the incident they describe.
Planned and requested work
Changes and service requests link to Services; requests also link to their Requester in People.
Reference and follow-up
Services link to an Owner in People; Assets link to Services; Problems link to Services and an Owner; integration receipts stand as provider event records.
Every table, by feature
- Incidents7
- Store Evidence3
- Service Requests3
- Changes2
- Services and Assets7
- Problems and Receipts6
- Shared and settings1
- Incidents
Store incidents affecting POS terminals, registers and site IT services.
Linked to Services, Assets, People - Incident updates
Chronological technician updates recorded against a store incident.
Linked to Incidents, People - Services
IT services delivered to Northstar Retail stores and distribution sites.
Linked to People - Assets
Store POS terminals, registers, scanners and site IT assets.
Linked to Services - People
Retail IT service desk people for Northstar Retail locations.
Linked to Users - Register outages
Register and POS outage captures linked to a store incident.
Linked to Incidents - Store trading windows
Store trading window captures linked to a store incident.
Linked to Incidents
- Register outages
Register and POS outage captures linked to a store incident.
Linked to Incidents - Store trading windows
Store trading window captures linked to a store incident.
Linked to Incidents - Incidents
Store incidents affecting POS terminals, registers and site IT services.
Linked to Services, Assets, People
- Service requests
Store and corporate requests for IT service delivery.
Linked to People, Services - People
Retail IT service desk people for Northstar Retail locations.
Linked to Users - Services
IT services delivered to Northstar Retail stores and distribution sites.
Linked to People
- Changes
Planned changes to retail IT services and store infrastructure.
Linked to Services - Services
IT services delivered to Northstar Retail stores and distribution sites.
Linked to People
- Services
IT services delivered to Northstar Retail stores and distribution sites.
Linked to People - Assets
Store POS terminals, registers, scanners and site IT assets.
Linked to Services - Incidents
Store incidents affecting POS terminals, registers and site IT services.
Linked to Services, Assets, People - Changes
Planned changes to retail IT services and store infrastructure.
Linked to Services - Problems
Root-cause problems behind recurring store IT incidents.
Linked to Services, People - Service requests
Store and corporate requests for IT service delivery.
Linked to People, Services - People
Retail IT service desk people for Northstar Retail locations.
Linked to Users
- Problems
Root-cause problems behind recurring store IT incidents.
Linked to Services, People - Incident updates
Chronological technician updates recorded against a store incident.
Linked to Incidents, People - Incidents
Store incidents affecting POS terminals, registers and site IT services.
Linked to Services, Assets, People - Services
IT services delivered to Northstar Retail stores and distribution sites.
Linked to People - People
Retail IT service desk people for Northstar Retail locations.
Linked to Users - Integration receipts
Monitoring and provider event receipts deduplicated by external event id.
Keys and references
Use the record references rather than matching only free-text descriptions. An incident’s Service and Asset are separate selections. Register outages.Incident and store trading windows.operational record both point to Incidents, while the two capture records have their own store code values. People.User connects a person record to Users. Integration receipts.external event ID identifies the provider event for deduplication.
Migration order
- Load Users and People so ownership and requesters can be selected.
- Load Services, then Assets with their service links and locations.
- Load Incidents, service requests, Changes and Problems against the reference records.
- Load incident updates, register outages and store trading windows against their incidents.
- Load integration receipts with their provider event IDs and processing states.
Set up Retail ITSM your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.