![Page 1: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/1.jpg)
MEDIATION REVIEWVince Kocher
![Page 2: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/2.jpg)
2www.cdg.ws
System Modifications
Usage Warehousing
Number Portability Administration Center (NPAC)
MEDIATION ENHANCEMENTS
![Page 3: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/3.jpg)
3www.cdg.ws
File handling options
Special Processing tab
Attachment button for business rule processing
Reports / Warehousing Totals button on reformatting GUI
Reports / Warehousing Totals button on merge GUIs
SYSTEM MODIFICATIONS
![Page 4: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/4.jpg)
4www.cdg.ws
SYSTEM MODIFICATIONS (FILE HANDLING)
![Page 5: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/5.jpg)
5www.cdg.ws
SYSTEM MODIFICATIONS (FILE HANDLING)
![Page 6: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/6.jpg)
6www.cdg.ws
SYSTEM MODIFICATIONS (SPECIAL OPS)
![Page 7: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/7.jpg)
7www.cdg.ws
SYSTEM MODIFICATIONS (SPECIAL OPS)
![Page 8: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/8.jpg)
8www.cdg.ws
SYSTEM MODIFICATIONS (ATTACHMENTS)
![Page 9: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/9.jpg)
9www.cdg.ws
SYSTEM MODIFICATIONS (ATTACHMENTS)
![Page 10: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/10.jpg)
10www.cdg.ws
SYSTEM MODIFICATIONS (ATTACHMENTS)
![Page 11: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/11.jpg)
11www.cdg.ws
SYSTEM MODIFICATIONS (RPTS / WHS)
![Page 12: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/12.jpg)
12www.cdg.ws
SYSTEM MODIFICATIONS (RPTS / WHS)
![Page 13: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/13.jpg)
13www.cdg.ws
Available options to select data to warehouse
Warehouse “only” entire file
CABS usage (Category 11 detail)
Only billable CABS usage
Only billable international
All CABS usage
End user usage
Only billable usage
Only billable international
All billable usage
USAGE WAREHOUSING
![Page 14: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/14.jpg)
14www.cdg.ws
Select specific data by individual feed or all feeds
Warehousing tables updated once a day
Available through QRT for notifications /reporting
Available through Dashboards for visual displays
USAGE WAREHOUSING
![Page 15: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/15.jpg)
15www.cdg.ws
USAGE WAREHOUSING (QRT)
Identify business rules
Usage patterns
Usage volumes
Trunk groups / carriers / etc.
Types of drops
Timeframe to execute business rules
Dependent on how often data is delivered to CDG
During every usage load
Once a day (early morning / late evening)
![Page 16: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/16.jpg)
16www.cdg.ws
Distribution of information
Text
Distribution list (group)
Format of information
Basic in email / text
Detail report
USAGE WAREHOUSING (QRT)
![Page 17: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/17.jpg)
17www.cdg.ws
USAGE WAREHOUSING (DASHBOARDS)
![Page 18: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/18.jpg)
18www.cdg.ws
CDG has entered into an agreement for ported number information
File would contain information for the US
Tables updated once a day
Information at the line level
Identifies service provider (ownership)
Identifies line type (wireless or wireline)
Routing code (LRN)
Logic is controlled at individual feed level
Projected release date is April 2015
NPAC
![Page 19: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/19.jpg)
19www.cdg.ws
NPAC
![Page 20: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/20.jpg)
20www.cdg.ws
For additional information, please contact your Sales representative
NPAC
![Page 21: MEDIATION REVIEW Vince Kocher. System Modifications Usage Warehousing Number Portability Administration Center (NPAC) MEDIATION ENHANCEMENTS 2](https://reader038.vdocuments.us/reader038/viewer/2022103123/56649d8c5503460f94a74578/html5/thumbnails/21.jpg)
www.cdg.ws 21