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.

Note: 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 fields in the Cost Reporting Summary Report 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 fields in the Cost Reporting Summary Report 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 fields in the Cost Reporting Exception Detail Report 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 fields in the Cost Reporting Exception Detail Report must be imported as “Date” fields (rather than text) to display correctly:

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