Work Order Export Setup - WebTMA 5

Updated March 06, 2023 19:10

Path: Admin > Universal Interface > Universal Interface Setup

Select the Work Order Export Transaction Type to export records using the Universal Interface framework. You have a choice of three export Connection Types: Comma Delimited Text File, Tab Delimited Text File, or Microsoft SQL Server.

The Export Query is used only to determine the records to be exported. Select an existing Browse Query to serve as the Export Query. The selected Export Query has no impact on the data columns that are used in the export process.

ALERT: Each work order can be exported only once. Even if you use a new WebTMA Universal Interface setup, when a work order has been exported previously using the Universal Interface function, it will not export a second time.

Once a record has been exported, the xx_uiExport Boolean field is updated with a value of 'true'. Records with a true xx_uiExport value are excluded from the export query to prevent duplicate data from being exported.

Be sure to select a folder so an error log can be generated.

The WebTMA Integration Client Service Configuration (Stand-alone windows application) Service includes fields to support exporting records.

Remember to add at least one Repair Center to the Repair Center Tab.

When lines are exported, WebTMA marks the read-only Universal Interface Export check box found on the Modification History popup when you click the Last Modified link on the Action Menu of the related record. The Universal Interface Export field is available in the Report Writer.

How to Link Fields for Work Order Export

In order to export your work order records, you must link WebTMA fields with fields within your Universal Interface table. By default, all required fields should already have line entries. Edit those records and then add elective fields.

From your Universal Interface Setup window in Add/Edit mode:

Complete the Required Setup fields defined above.
Click the Add Column link on the grid to open the Column Mapping popup window.
Choose your WebTMA Column.
Select the Remote Column.
Click Save & Add (or Save & Close).
Repeat until all fields in your Universal Interface table have been matched up.
Add the applicable Repair Center(s) to the Repair Center
Click Save on the WebTMA toolbar.

Work Order Export Columns

In logical sequence, the following table lists the Work Order fields available for export.

ColumnName	DataType	MaxLength	DecinalPlaces	IsRequired	AllowDefault	AllowAutoCreate
Primary Key	int	4		No	No	No
Work Order #	nvarchar	20		No	No	No
Facility Code	NULL	NULL	NULL	No	No	No
Building Code	NULL	NULL	NULL	No	No	No
Building Name	NULL	NULL	NULL	No	No	No
Floor Code	NULL	NULL	NULL	No	No	No
Location ID	NULL	NULL	NULL	No	No	No
WebTMA Item Type	int	4		No	No	No
Item Code	NULL	NULL	NULL	No	No	No
Priority Code	NULL	NULL	NULL	No	No	No
Repair Center Code	NULL	NULL	NULL	No	No	No
WO Type Code	NULL	NULL	NULL	No	No	No
Chargeable?	bit	1		No	No	No
Charge Account #	NULL	NULL	NULL	No	No	No
Department Code	NULL	NULL	NULL	No	No	No
Request #	NULL	NULL	NULL	No	No	No
Status	nvarchar	255		No	No	No
Requestor	nvarchar	75		No	No	No
Requestor Phone	nvarchar	25		No	No	No
Requestor Email	nvarchar	200		No	No	No
Request Date	datetime	8		No	No	No
Estimated Start Date	datetime	8		No	No	No
Estimated End Date	datetime	8		No	No	No
Finish Date	datetime	8		No	No	No
Completion Date	datetime	8		No	No	No
Print Date	datetime	8		No	No	No
Action Requested	nvarchar	4000		No	No	No
Supervisor	nvarchar	255		No	No	No
Reference #	nvarchar	20		No	No	No
TQM	bit	1		No	No	No
General Comments	ntext	8		No	No	No
Out Of Service?	bit	1		No	No	No
Warranty Job?	bit	1		No	No	No
Service Job	bit	1		No	No	No
Operator Name	NULL	NULL	NULL	No	No	No
Operator Error?	bit	1		No	No	No
Risk to Operator?	bit	1		No	No	No
Risk to Patient?	bit	1		No	No	No
Action Required by Department	bit	1		No	No	No
Building Services Signoff	datetime	8		No	No	No
Department Signoff	datetime	8		No	No	No
Department Head	nvarchar	50		No	No	No
Department Action	ntext	8		No	No	No
Created Date	datetime	8		No	No	No
Modified Date	datetime	8		No	No	No
Creator	NULL	NULL	NULL	No	No	No
Modifier Name	NULL	NULL	NULL	No	No	No
Project #	NULL	NULL	NULL	No	No	No
Notify Me?	bit	1		No	No	No
Overage Account #	NULL	NULL	NULL	No	No	No
Fixed Cost	bit	1		No	No	No
Estimated Hours	decimal	9	4	No	No	No
Estimated Cost	decimal	9	2	No	No	No
From Device?	bit	1		No	No	No
From Med Tester?	bit	1		No	No	No
Skip Zone Auto Assign?	bit	1		No	No	No
Auto Print?	bit	1		No	No	No
From Service?	bit	1		No	No	No
Start Creation Date	datetime	8		No	No	No
Tax Name	NULL	NULL	NULL	No	No	No
Tax Rate 1	decimal	9	4	No	No	No
Tax Rate 2	decimal	9	4	No	No	No
Tax Compound?	bit	1		No	No	No
Work Not Done?	bit	1		No	No	No
Exclude From Requestor?	bit	1		No	No	No
Fiscal Start	datetime	8		No	No	No
X Coordinate	nvarchar	30		No	No	No
Y Coordinate	nvarchar	30		No	No	No
Additional Reference	nvarchar	20		No	No	No
Account Program Code	NULL	NULL	NULL	No	No	No
Is Ticket?	bit	1		No	No	No
Is Template?	bit	1		No	No	No
Template Name	nvarchar	150		No	No	No
1st Failure Code	NULL	NULL	NULL	No	No	No
1st Failure Sub-Code	NULL	NULL	NULL	No	No	No
1st Contractor Code	NULL	NULL	NULL	No	No	No
1st Contractor Name	NULL	NULL	NULL	No	No	No
1st Scheduled Tech Name	NULL	NULL	NULL	No	No	No
UDF Date 1	datetime	8		No	No	No
UDF Date 2	datetime	8	4	No	No	No
UDF Date 3	datetime	8	4	No	No	No
UDF Date 4	datetime	8		No	No	No
UDF Date 5	datetime	8		No	No	No
UDF Date 6	datetime	8		No	No	No
UDF Int 1	bigint	8		No	No	No
UDF Int 2	bigint	8		No	No	No
UDF 2 DP Num 1	decimal	9	2	No	No	No
UDF 2 DP Num 2	decimal	9	2	No	No	No
UDF 2 DP Num 3	decimal	9	2	No	No	No
UDF 2 DP Num 4	decimal	9	2	No	No	No
UDF 4 DP Num 1	decimal	9	4	No	No	No
UDF 4 DP Num 2	decimal	9	4	No	No	No
UDF 4 DP Num 3	decimal	9	4	No	No	No
UDF 4 DP Num 4	decimal	9	4	No	No	No
UDF 4 DP Num 5	decimal	9	4	No	No	No
UDF 4 DP Num 6	decimal	9	4	No	No	No
UDF Bool 1	bit	1		No	No	No
UDF Bool 2	bit	1		No	No	No
UDF Bool 3	bit	1		No	No	No
UDF Bool 4	bit	1		No	No	No
UDF Bool 5	bit	1		No	No	No
UDF Bool 6	bit	1		No	No	No
UDF 255 Char 1	nvarchar	1000		No	No	No
UDF 255 Char 2	nvarchar	1000		No	No	No
UDF 255 Char 3	nvarchar	1000		No	No	No
UDF 255 Char 4	nvarchar	1000		No	No	No
UDF 255 Char 5	nvarchar	1000		No	No	No
UDF 255 Char 6	nvarchar	1000		No	No	No
UDF 255 Char 7	nvarchar	1000		No	No	No
UDF 30 Char 1	nvarchar	30		No	No	No
UDF 30 Char 2	nvarchar	30		No	No	No
UDF 30 Char 3	nvarchar	30		No	No	No
UDF 30 Char 4	nvarchar	30		No	No	No
UDF 60 Char 1	nvarchar	60		No	No	No
UDF 60 Char 2	nvarchar	60		No	No	No

How to Link Fields for Work Order Export

Work Order Export Columns

Articles in this section