TeamDME Data Exchange Tables

Updated by Steven Garand

New Order Window - TeamDME to ARTSCO (From)

Item
Add
Update

Order

Yes

No

No

Other App Window - Main Grid - ARTSCO to TeamDME (To)

Item
Add
Update

Company Office

No

Yes

No

Customer Service

No

Yes

No

Facility

Yes

Yes

Yes

Ordering Physician

Yes

Yes

Yes

PCP Physician

Yes

Yes

Yes

Referring Physician

Yes

Yes

Yes

Referral Source

Yes

Yes

Yes

Salesperson

No

Yes

No

Therapist

Yes

Yes

Yes

Patient (Customer)*

Yes

Yes

Yes

Order (Medical)**

Yes

Yes

Yes

*Includes Referral Source reference, Therapist reference, Facility reference, patient height, and patient weight. Note: customer physician, diagnosis, and policy are updated/created using the Order item, not using the Patient item.

**Includes medical note type, medical notes (short notes, long notes, and task notes), medical item, item, and item manufacturer. ARTSCO line item with multiple codes are broken out into multiple medical items, each with a single code. The medical item values are calculated based on the percent Medicare fee for each code. A match is attempted on items with a corresponding part number. If no part number is found a corresponding item is generated for the medical item. Any medical item description is truncated to 50 characters. The full description is added to the corresponding item. Note: Line Items (Medical Items) are only created if ARTSCO has line items and TeamDME has no Medical Items for the order. Changes to ARTSCO line items after the Order is created or updated to TeamDME will not be updated in TeamDME. All TeamDME Medical Items must first be manually deleted in TeamDME which will allow the creation of all Medical Items from a subsequent Order Update.

Other App Window - Main Grid - ARTSCO to TeamDME (To) - Order Details

Order Detail Item
Notes

Ordering Physician Reference

Referring Physician Reference

Referral Source Reference

Facility Reference

Customer Service Reference

Salesperson Reference

Taxtable Reference

Company Office Reference

Location in TeamDME

Payor References

Customer Policy in TeamDME

PCP Physician Reference

Customer Physician in TeamDME

Diagnosis Codes

Customer Diagnosis in TeamDME. If any code not matched, all Customer Diagnosis codes deleted for the order and re-created from ARTSCO diagnosis codes.

Short Notes

Medical Note Types created if missing. Medical Notes created if missing, else updated.

Long Notes

Medical Note Types created if missing. Medical Notes created if missing, else updated.

Completed Task Notes

Medical Note Types created if missing. Medical Notes created if missing, else updated.

Line Items *

*ARTSCO line item with multiple codes are broken out into multiple medical items, each with a single code. The medical item values are calculated based on the percent Medicare fee for each code. A match is attempted on items with a corresponding part number. If no part number is found a corresponding item is generated for the medical item. Any medical item description is truncated to 50 characters. The full description is added to the corresponding item. Note: Line Items (Medical Items) are only created if ARTSCO has line items and TeamDME has no Medical Items for the order. Changes to ARTSCO line items after the Order is created or updated to TeamDME will not be updated in TeamDME. All TeamDME Medical Items must first be manually deleted in TeamDME which will allow the creation of all Medical Items from a subsequent Order Update.

Other App Window - Main Grid - ARTSCO to TeamDME (To) - Patient Details

Order Detail Item
Notes

Referral Source Reference

Therapist Reference

Facility Reference

Patient Height

Patient Weight

Other App Window - Main Grid - TeamDME to ARTSCO (From)

Item
Add
Update

Company Office

No

Yes

No

Customer Service

No

Yes

No

Facility

Yes

Yes

Yes

Ordering Physician

Yes

Yes

Yes

PCP Physician

Yes

Yes

Yes

Referring Physician

Yes

Yes

Yes

Referral Source

Yes

Yes

Yes

Salesperson

No

Yes

No

Therapist

Yes

Yes

Yes

Patient (Customer)

Yes

Yes

Yes

Order (Medical)*

No

No

Yes

* Must use New Order page to create a new order from an existing TeamDME order (Medical row). Payors references, subscriber references, and line items are not created or updated from TeamDME

Other App Window - Main Grid - TeamDME to ARTSCO (From) - Order Details

Order Detail Item
Notes

Ordering Physician Reference

Referring Physician Reference

Referral Source Reference

Facility Reference

Customer Service Reference

Salesperson Reference

Company Office Reference

Location in TeamDME

Diagnosis Codes

Customer Diagnosis in TeamDME. If any code not matched, all Customer Diagnosis codes deleted for the order and re-created from ARTSCO diagnosis codes.

Other App Window - Main Grid - TeamDME to ARTSCO (From) - Patient Details

Patient Height

Patient Weight

Other App Window - Set Options

Item
Note

Salesperson

Sets the ARTSCO custom team member type associated with the TeamDME Salesperson type

Customer Service

Sets the ARTSCO custom team member type associated with the TeamDME Customer Service type

Taxtable

Sets the TeamDME Taxtable item used when generating any new medical item

Item
Note

Payor

Links the ARTSCO payors for the order with associated TeamDME payors

Vendor

Links the ARTSCO line item vendors for the order with associated TeamDME item manufacturers


How did we do?