service_requests_v1

service_request_id

Unique database ID

Primary key of a service request

reference

Internal request number

subject

Subject

external_reference

External request number

For 3rd party integrations

priority_name

Name (label) of priority

e.g. “Normal”, “High”

priority_number

Number of priority

Integer values

received_datetime

Date and time when received

In local time zone (by location)

due_datetime

Date and time when due

In local time zone (by location)

closed_datetime

Date and time when closed

In local time zone (by location)

service_type_name

Name of service type

service_type_reference

Reference of service type

service_type_l1

Level 1 service type name

Highest level in a hierarchy of service types.
Cannot be NULL.

service_type_l2

Level 2 service type name

2nd level in a hierarchy of service types.
Can be NULL.

service_type_l3

Level 3 service type name

3rd level in a hierarchy of service types.
Can be NULL.

requester_organization_name

Name of the Organization of the Requester

requester_organization_reference

Reference of the Organization of the Requester

assigned_organization_name

Name of the Organization of the Assigned Person

assigned_organization_reference

Reference of the Organization of the Assigned Person

status_name

Name of the current status

Status names are configurable

status_class

Class of the current status

OPEN / CLOSED

elapsed_days

nr of calendar days between closed_datetime and received_datetime +1

location_class

Class of location

REGION / SITE / BUILDING / FLOOR / ROOM

region_code

Code of Region

region_name

Name of Region

site_code

Code of Site

site_name

Name of Site

building_code

Code of Building

building_name

Name of Building

floor_code

Code of Floor

floor_name

Name of Floor

room_code

Code of Room

room_name

Name of Room

service_type_id

Database id of service_type

foreign key

requester_organization_id

Database id of requester organization

foreign key

assigned_organization_id

Database id of assigned organization

foreign key

location_id

Database id of location

foreign key