Report requirements

Last updated
Save as PDF

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
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	Required
*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.