Column Descriptions in the PM Template

    PM Template Descriptions

    Following are the descriptions for each column in the PM Template. You will see the name of the column, if the column is required (denoted by an asterisk*), the format the data should be in (text, date/time or numerical), and the maximum number of characters for each field.

    Column Name* (Format, Maximum number of Characters): Description of column

    • Source* (Text, 50 max. characters): Should contain information about the requestor of the change, for example the person’s name or the name of the company and the department.
    • woNumber (Text, 20 max. characters): A number assigned to the work order by the service provider (different than the Tracking Number).
    • Caller (Text, 100 max. characters): Requestor of services. If keywords (ServiceID or revised) are used then caller field is updated with special value that can be reused for provider/trade/location combination (there are no time limits). (Note: ServiceID is standard part of IVR check in/out process and can be used by any provider/subscriber. It is 8 digit number with a leading zero [ex: 01234567].)
    • AutoInvoice (Text, 3 max. characters): Type YES if the work order should be auto-invoiced, or NO if not.
    • Trade* (Text, 50 maximum characters): The trade related to the work order.
    • ProviderID* (Text, 10 max. characters): Each service provider is assigned a Provider ID. You can find the Provider ID for Service Providers in your network on the Providers page in the Admin module.
    • ProviderName (Text, 100 max. characters): The name of the service provider.
    • SubscriberID* (Text, 10 max. characters): Your assigned Subscriber ID. Contact your Account Executive for your Subscriber ID.)
    • StoreID* (Text, 50 max. characters): Store Number assigned to the work order.
    • Tax* (Numeric with 2 decimal places, 10 max. characters): The dollar amount of tax to be charged on the work order. (Note: When the PM Template is uploaded, the system will add Tax + Price to ensure the total cost does not exceed the NTE amount, as configured in Service Automation.)
    • Price* (Numeric with 2 decimal places, 10 max characters): The cost of the work order, before taxes. (Note: When the PM Template is uploaded, the system will add Price + Tax to ensure the total cost does not exceed the NTE amount, as configured in Service Automation.)
    • CallDate* (Date/Time, 20 max. characters): The start date of the service.
    • ScheduledDate* (Date/Time, 20 max. characters): The scheduled time the service provider is expected to be on site. (Note: Either ScheduledDate or ExpirationDate must be present.)
    • Description* (Text, 2000 max. characters): The explanation of the requested service.
    • Status (Text, 50 max. characters): When left blank, the work orders are created with OPEN status. When “COMPLETED” is used, the work orders are created with the COMPLETED status and the completion date of today’s date. When a date is used (mm/dd/yyyy), the work orders are created with the COMPLETED status and the completed date of the date specified.
    • AutoDispatch (Text, 5 max. characters): Enter TRUE (or leave blank) to notify the service provider of the work order. (Note: Work order notifications are dispatched at night; unlike a standard work order, which dispatches immediately).
    • Category (Text, 30 max. characters): The category must be one of the existing categories for the subscriber, otherwise the row will return an error. If left blank, the category “Maintenance” will be used.
    • Priority* (Text, 30 max. characters): The priority must be one of the existing priorities for the subscriber. If left blank, the lowest available priority for the subscriber will be used.
    • Quantity (Integer, 2 max. characters): Number of work orders to be created. If left blank, one work order will be created. Max quantity 30.
    • Currency (Text, 3 max. characters): USD or CAD – for US or Canadian Dollars. If left blank, USD is assumed.
    • Tax2 Type (Text, 3 max. characters): Used for Canadian Taxes. The values can be “PST”, “HST” or “QST”
    • Tax2 (Numeric with 2 decimal places, 10 max. characters): The value for the Canadian Taxes.
    • CallerIDMatch (Text, 5 max. characters): True/False. This flag will override the default for the subscriber. For example, if the subscriber requires caller ID match for all work orders, but for this work order no match is needed.
    • AssetUpdateFlag (Text, 5 max. characters): True/False. When the flag is set to True, the provide will need to update the asset record for the location during the confirmation process.
    • ExpirationDate* (Date/ Time, 20 max. characters): The Expiration Date of the work order. If left blank, the scheduled date becomes the expiration date. The work order must have either a scheduled or an expiration date; otherwise the template returns an error.
    • GracePeriod (Integer, 2 max. characters): Number of days after the expiration date the service provider is allowed to extend the work order
    • AutoComplete (Text, 5 max. characters): True/False. When the flag is set to TRUE, the work order will be autocompleted.
    • PoNumber (Text, 20 max. characters): Work order PO Number.
    • ExtendedStatus (Text, 50 max. characters): Extended Status (it will be verified if it’s valid for main status)
    • AutoApprovedBy (Text, 50 max. characters): If auto invoice flag is set to true/yes, this field can be used to indicate if invoice should auto approved (value of this column: ex Tomasz P will go into approved by field on invoice record.
    • Area (Text, 255 max. characters): Dashboard Area
    • ProblemType (Text, 256 max. characters): Dashboard Problem Type
    • Equipment (Text, 256 max. characters): Dashboard Equipment
    • ProblemCode (Text, 256 max. characters): Dashboard Problem Code
    • MasterTrackingNumber (Integer,     10 max. characters): Master Tracking Number to link/create follow-up work order
    • EquipmentTagID (Text, 50 max. characters): TagID from equipment module for given location and trade. It will also add equipment related info (physical area, tagID, modelNo and serialNo) to problem description
    • ApprovalCode (Text, 40 max. characters): ApprovalCode that will associated with newly created work order.

    PM Template Results and Error Codes

    Five additional columns are returned on the PM Template, so you can see which line item successfully validated and which ones did not. For the line items that have an error, you will see an ErrorCode informing you of the issue so you can fix them and resubmit.

    • Result: For each line item, either Success or Error will appear.
    • ErrorCode: In case of error in the Result, one of the following Error Codes will appear:
      • Subscriber not found
      • Location not found
      • Provider not found
      • Duplicate wo # found
      • Category not found
      • Priority not found
      • Invalid currency
      • Invalid grace period
      • Invalid tax type
      • Scheduled and expiration date missing
      • Call Date exceeds Scheduled Date
      • Expiration date precedes Call or Scheduled Date
      • Problem Description missing
      • Completion date precedes Call Date.
      • Status/Ext. Status not found
      • PO Number Invalid Length
      • Master Tracking Number does not exist
      • Area does not exist
      • EquipmentTagID does not exist
    • ResultTrackingNumber: When result is Success, the tracking number of the newly created work order will list.
    • DateStamp: When ResultTrackingNumber has a tracking number, the date of the new work order will list.
    • TimeStamp: When ResultTrackingNumber has a tracking number, the time of the new work order will list.