1 / 12

End of Quarter (EOQ) Reporting Data

End of Quarter (EOQ) Reporting Data. May 14, 2002. Presentation. Background NPC Solution File Layout. Background. NPC required to comply with FCC 96-128 (Second Order of Reconsideration) released April 5, 2001, on behalf of its clients.

Download Presentation

End of Quarter (EOQ) Reporting Data

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. End of Quarter (EOQ) Reporting Data May 14, 2002

  2. Presentation • Background • NPC Solution • File Layout

  3. Background • NPC required to comply with FCC 96-128 (Second Order of Reconsideration) released April 5, 2001, on behalf of its clients. • The Order’s requirements included providing 800/access code call data in a “computer-readable format”.

  4. NPC Solution • Three core NPC business requirements: • Receiving, analyzing, and staging of clients’ quarterly toll-free/access code call data. • Creation of PSP/AGGR end-of-quarter files--which replaces previously formatted reports. • Creation of a secure website to facilitate PSP/AGGR downloading of the end-of-quarter files or an e-mail push directly to the PSP/AGGR.

  5. NPC Solution (Continued) • “Secure access” means the NPC provides unique Usernames & Passwords to each PSP/AGGR for accessing their end-of-quarter data only. • To make the downloading effort easy and expedient, end-of-quarter files are compressed.

  6. NPC Solution (Continued) • The new, secure NPC website is www.npc.cc • Core functions of this site include: • Log On Page • Data Retrieving Page • Forgot Password Page • Change Password Page • Report Problem Page • Help Page

  7. NPC Solution (Continued) • Plans are underway to integrate the old www.ppoclear.com website contents with that of the new www.npc.cc website--tentative due date is May 17, 2002. The NPC will provide formal communication to the industry when this transition is complete - stay tuned!

  8. EOQ File Layout Contents - Five Data Sections Header (Section 0) FIELD POSITION LENGTH Record ID type 1 1 Production Year 2 – 5 4 Production Quarter 6 1 Recipient ID 7 – 11 5 Recipient Name 12 – 51 40 Total Amount Due 52 – 66 15 Not Enough Comp 67 – 81 15 Total Adjustments 82 – 96 15 Actual Compensation 97 – 111 15 FILLER 112 – 144 33

  9. Claim Status/Compensation Paid • (Section 3) • FIELD POSITION LENGTH • Record ID type 1 1 • PSP ID 2–6 5 • Claim Year 7–10 4 • Claim Quarter 11 1 • Payphone ANI 12–21 10 • State Code 22–23 2 • Load Year 24–27 4 • Load Quarter 28 1 • Status 29 1 • IXC ID 30–34 5 • Payment Type 35–49 15 • Rate Indicator 50 1 • Rate 51–62 12 • Month 1 Traffic 63–75 13 • Month 2 Traffic 76–88 13 • Month 3 Traffic 89–101 13 • Payment Amount 102–115 14 • Disputes Code 116 1 • Inel_Code 117 1 • Invalid_Code 118–125 8 • Special Handling Ind 126 1 • FILLER 127–144 18

  10. Validated and Paid Claims Toll Free Reporting (Section 5) FIELDPOSITIONLENGTH Record ID type 1 1 PSP ID 2–6 5 Claim Year 7–10 4 Claim Quarter 11 1 Payphone ANI 12–21 10 FILLER 22–29 8 IXC ID 30–34 5 Toll-Free ANI 35–44 10 FILLER 45–62 18 Month 1 Call Volume 63–75 13 Month 2 Call Volume 76–88 13 Month 3 Call Volume 89–101 13 FILLER 102–123 22 Special Handling Ind 124 1 FILLER 125–144 20

  11. Adjustment Reporting • (Section 7) • FIELDPOSITIONLENGTH • Record ID Type 1 1 • PSP ID or AGGR ID 2–6 5 • ID Type Code 7 1 • Adjust Type 8–22 15 • Adjust Type Code 23 1 • FILLER 24–29 6 • IXC ID 30–34 5 • FILLER 35–101 67 • Adjust Amount 102–115 14 • FILLER 116–144 29

  12. Trailer • (Section 9) • FIELDPOSITIONLENGTH • Record ID Type 1 1 • Number of records in the file of type ‘0’ 2–12 11 • FILLER 13–34 22 • Number of records in the file of type ‘3’ 35–45 11 • FILLER 46–56 11 • Number of records in the file of type ‘5’ 57–67 11 • FILLER 68–78 11 • Number of records in the file of type ‘7’ 79–89 11 • FILLER 90–100 11 • Number of records in the file of type ‘9’ 101–111 11 • FILLER 112–133 22 • Total number of data records in the file 134–144 11

More Related