Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from this space and version 2024.1

...

Conditionally Required IF the Import is trying to INSERT a new record.

Datatype is Hierarchical String.

NOT Required if the Import File is trying to UPDATE an existing record.

...

Dept. Hierarchy Owner

Datatype is Hierarchical String. or String

This Import expects the Dept. Department Hierarchy code, not the Description.

Location

Datatype is Hierarchical String.

Conditionally Required if Status is Active AND if the Service Catalog flag Location Required is set.

The full Location Path is expected.

Location Type

...

Name.

The value for this field can be the full Hierarachial Path, or it can be just the last part of the Path. If you provide only the last part, then there is a chance that there could be duplicate values in the database. If duplicate values are found, then you will get an error.

Location

Datatype is Hierarchical String.

Conditionally Required if the provided Location Name exists with multiple Types.Permitted Status is Active AND if the Service Catalog flag Location Required is set.

The full Location Path is expected.

Location Type

Datatype is String.

Conditionally Required if the provided Location Name exists with multiple Types.

Permitted values are from the LOCATION_TYPE List Values.

This field is used for the Location lookup if provided.

Location 911

Datatype is Boolean.

Defaults to False
 
This is only used if the Service has the Multi-Location flag set. This determines which Location will be reported for the 911 Report.

Location Status

Datatype is Boolean.

Defaults to Active

This is only used if the Service has the Multi-Location flag set. This determines if an individual Service Location is Active.

...

The USE_RATING_GROUP Configuration flag is set to True.

SLA Catalog

Datatype is Hierarchical String.

Reference

Datatype is String.

...

Datatype is String.

This is an override of the Owner Billing Group.

Multiple Locations

Datatype is Boolean.

Defaults to False [0].

Permitted Values are 1, True, or Yes, and set the Flag to True [1].

All other values enter as False [0].

Essential

Datatype is Boolean.

Defaults to False [0].

Permitted Values are 1, True, or Yes, and set the Flag to True [1].

All other values enter as the Owner Billing Group.

Multiple Locations

Datatype is Boolean.

Defaults to False [0].

...

Essential

Datatype is Boolean.

Defaults to False [0].

Permitted Values are 1, True, or Yes, and set the Flag to True [1].

All other values enter as

Billable

Datatype is Boolean.

Defaults to False [0].

Directory

Datatype is Boolean.

Defaults to True [1].

Permitted Values are 1, True, or Yes and set the Flag to True.

All other values enter as False [0].

Report 911

Datatype is Boolean.

Defaults to False [0].Permitted Values are 1, True, or Yes set the Flag to True [1].All other values enter as False [0].

Company ID

Datatype is String.

...

GLAs added to a Service with the Service Import ONLY adds an association between the existing GLAs and the selected Service in the Import File. The Service Import cannot INSERT or UPDATE GLA records.

GLA

Datatype is Hierarchical String.

GLA Expense Type

Conditionally Required if GLA is provided.

...

Equipment Location

Datatype is Hierarchical String.

The Equipment Location value is used only with a non-blank Equipment ID. If a non-blank Equipment ID is not provided, then the Location value is ignored. You cannot lookup an Equipment with just a Location.

...