Skip to main content

CMS' RDS Center will be performing system maintenance on the RDS Secure Website on Friday, April 19, 2024 beginning at 9:00PM ET and concluding Saturday, April 20, 2024 at 10:00AM ET. The Secure Website will be available, but file processing will be impacted. Refer to this Announcement for details.

Formatting And Importing Quick Access Reports Files

User Roles:

AM

AR

D

V

Quick Access Report (QAR) files are in a comma separated value (.csv) format and may be imported into a spreadsheet or database application.

If QAR data is imported into a spreadsheet program like Microsoft Excel, certain fields must be imported with specific formatting to display correctly. All other fields, not specified below, should be imported as text.

The following Cost Reporting Summary Report fields must be imported numerically as “General” fields (rather than text) to display correctly:

  • Cost Reporting Alert (Field #4)
  • Plan Sponsor ID (Field #6)
  • Application ID (Field #11)
  • Total Paid To Date (Field #18)
  • UBOI Eligible Retiree Count (Field #33)
  • Last Cost Report Accepted Allowable Retiree Cost (Field #42)
  • Last Cost Report Rejected Allowable Retiree Cost (Field #47)

The following Cost Reporting Summary Report fields must be imported as “Date” fields (rather than text) to display correctly:

  • Plan Year Start Date (Field #13)
  • Plan Year End Date (Field #14)
  • Application Status Date (Field #16)
  • Last Covered Retiree List Created Date (Field #25)
  • Reconciliation Deadline Date (Field #28)
  • Recon Step Date/Time (Field #30)
  • Last Cost Report Accepted File Receipt Date/Time (Field #37)
  • Last Cost Report Accepted Processed Date (Field #38)
  • Last Cost Report Accepted Status Date (Field #40)
  • Last Cost Report Rejected File Receipt Date/Time (Field #43)
  • Last Cost Report Rejected Processed Date (Field #44)

The following Cost Reporting Exception Detail Report fields must be imported numerically as “General” fields (rather than text) to display correctly:

  • Plan Sponsor ID (Field #4)
  • Application ID (Field #6)
  • UBOI Eligible Retiree Count (Field #8)
  • UBOI Monthly Eligible Retiree Count (Field #9)
  • Exception Code (Field #15)

The following Cost Reporting Exception Detail Report fields must be imported as “Date” fields (rather than text) to display correctly:

  • File Receipt Date/Time (Field #11)
  • File Processed Date (Field #12)

Return to top

Page last updated: