Skip to main content
ResMed Help Center

Report requirements

The report should contain all new and existing sleep apnea patients with order history and demographic data for selected period.

  • Microsoft Excel file is saved with .xlsx extension
  • Microsoft Excel file is less than 20 MB in size
  • Column headings must be an exact match (case-sensitive)
  • Column headings must be listed in the order below

Column requirements

Required Column Heading

Description

Character or Field Limitations

 

Patient ID

Patient ID / MRN

Max 50 characters

Required

Last Name

Patient Last Name

Max 100 characters

Required

First Name

Patient First Name

Max 100 characters

Required

D.O.B

Patient Date of Birth

MM/DD/YYYY

Required

Payor

Patient Primary Payor Name

Max 100 characters

Required

Member ID

Patient Primary Payor Member ID

Policy # - Max 20 characters

Optional*

Phone Number

Preferred Patient Phone Number

xxx-xxx-xxxx

Required

Phone Number Type

Phone Number Type

Home, Office or Mobile

Optional

Phone Number 2

Patient Phone Number 2

xxx-xxx-xxxx

Optional

Phone Number 2 Type

Phone Number Type 2

Home, Office or Mobile

Optional

Email

Patient Email

Max 100 characters, must contain @ and “.” In email

Required

Address 1

Patient Address 1

Max 100 characters

Required

Address 2

Patient Address 2

Max 100 characters

Optional

City

Patient City

Max 100 characters

Required

State

Patient State

Max 100 characters

Required

Zip

Patient Zip

xxxxx or xxxxx-xxxx

Required

External Order ID

Order Number

 

Optional

Quantity

Quantity

 

Required

HCPCS

HCPC

 

Required

Prod ID

Manufacturer Product ID/SKU

 

Required

Serial Number

Serial Number

 

Optional

Last Supplied Date

Last Supplied Date

MM/DD/YYYY

Required

Status

Patient Status

Active or Inactive

Recommended

Secondary Payor

Patient Secondary Payor

Max 100 characters

Optional

Secondary Member ID

Patient Secondary Payor Member ID

Policy # - Max 20 characters

Optional

Location

Location

Branch/Provider Name

Recommended

Gender

Gender

Male/Female

Optional

*If insurance verification is not being used

Required HCPCS

  • A7030
  • A7027
  • A7034
  • A7044
  • A7028
  • A7029
  • A7031
  • A7032
  • A7033
  • A7035
  • A7036
  • A4604
  • A7037
  • A7038
  • A7039
  • A7046
  • E0561
  • E0562
  • A7045
  • E0471
  • E0472
  • E0601
  • A9279
  • E0470

Report Filter Parameters

  • Last Supplied Date range – From last supplied date and Through last supplied date - Required
  • Status – Active, Inactive, Both - Recommended
  • HCPC – ‘All’ = Will return all orders with the above HCPC codes. Alternatively, users can enter the HCPCs manually. For example, ‘A9279’, ‘E0470’ will output a report for patients with just these two HCPCs - Recommended
  • Location/Branch – Filter the report by a specific location/branch or ALL - Recommended
  • Payor – Filter to select payor(s) to exclude from export - Recommended

 

 

 

 

 

 

Additional detail

Patient ID

An external reference ID that uniquely identifies a patient in another system. ResMed ReSupply combines this field with the billing system and location to ensure a patient is not imported twice.

Last name

Patient’s last name.

First name

Patient’s first name. 

D.O.B

Patient’s date of birth. Formatted as MM/DD/YYYY.

Payor

Patient's payor (primary insurance provider). The system will assign a default payor for unknown and empty values.

Member ID

Patient’s member ID from their insurance provider. Used for insurance verification purposes (if the functionality is turned on).

Phone number

Patient’s phone number. Formatted as xxx-xxx-xxxx.

Phone number type

Patient’s phone number type (home, office, mobile).

Phone number 2

Patient's secondary phone number. Formatted as xxx-xxx-xxxx.

Phone number type 2

Patient’s secondary phone number type (home, office, mobile).

Email

Patient’s email address. This field is optional if the patient’s phone number is provided.

Address 1

Patient’s first address line. This appears on supply requests.

Address 2

Patient’s second address line. This appears on supply requests.

City

Patient’s city of residence. This appears on supply requests.

State

Patient’s state of residence. This appears on supply requests.

Zip

Patient’s zip code. This appears on supply requests.

External order ID

External order ID from the source billing system.

Quantity

Number of items for this product shipped in this supply request. 

HCPCS

A product’s code according to the Healthcare Common Procedure Coding System (HCPCS). Each patient has a row for each HCPCS item that can be resupplied. Only one HCPCS code is allowed per row. This field is required to import the patient. Each patient must have a mask HCPCS code.

Prod ID

A product’s ID based on the manufacturer’s stock keeping unit (SKU) number. Only one product ID is allowed per row.

Serial number

A serial number is based on a manufacturer's system for identifying specific medical devices.

Last supplied date

Date the patient last received an HCPCS item. Formatted as: MM/DD/YYYY. This date is part of the criteria that determines when the patient is contacted for resupply.

Status

Patient's status can only be "Active" or "Inactive."

Secondary Payor

Patient's secondary payor.

Secondary Member ID

Patient’s member ID from their secondary insurance provider.

Location

Patient’s branch/location used at HME.

Gender

Patient’s Gender.

 

  • Was this article helpful?