BI014 Unallocated Usage Subscriber Due To Bill

Report ID

BI014

Report Name

Unallocated Usage Subscriber Due To Bill

Objective

This report shows the unallocated usage assigned to subscriptions that will be billed within 7 days of the report date. This allows the unallocated usage to be managed correctly prior to billing, but can only be performed on usage records with valid subscription details.

Expected Frequency

Daily

Period

Snapshot

Queries

  • BI014AV1
  • BI014BV1
  • BI014CV1

Temp Files

As per Queries

Programs

CL_ BI014

Parameters

  • Query Library
  • IFS Output Directory
  • CMP Data Library
  • CMP Call Data Library

Output File(s)

<YYYY-MM-DD> BI014 Unallocated Usage Sub Due to Bill.csv

Output Fields

  • Network Serial Number (MSISDN)
  • Subscription
  • Call Date
  • Call Time
  • Dialled Number
  • Call Classification
  • Network Wholesale Price

IFS Information

Output directory defined in the parameters

Job Schedule Information

Example Program to Call:

CALL PGM(STDREPORTS/CL_BI014) PARM('STDREPORTS' '/Standard Reports/' 'D' 'DISEDATA' ‘CALLDATA’)

Schedule:

Daily