The BSCS database stores a wealth of information about your customers, their use of telecommunication services, and resulting revenues. Accounting data, customer care activities, and availabilty of network resources (SIM cards or directory numbers) are also housed in the database.

The seminar explains the BSCS workflow around customers and its presentation on database level. You will gain a sound understanding of BSCS data and where to find it.

Define BSCS workflow around customers

Find customer and contract properties

Interprete Usage Data Records (UDR) on database level

Find invoice and payment data

Find billing data and posting results

Analysts and Consultants, Development

SQL skills

Technical expertise in data extraction and report generation

BSCS Introduction

Provides an overview of the BSCS components and main workflow

Introduces the schema of the BSCS database

Reference Data

Explains the meaning of the entities networks, resources, services, service packages and rate plans in BSCS

Shows their presentation in BSCS applications and on database level

Provides hands-on exercises on application and database level

Customer and Contract Data

Introduces the main properties of customers, contracts, large accounts, contracted resources, services and service parameters

Provides hands-on exercises on application and database level

CSR Operations

Provides an overview about BSCS user and user rights

Gives an introduction to fees and their meaning in billing

Introduces scheduled jobs; their status, workflow, and meaning

Provides hands-on exercises on database level

Cost Control Balances

Gives a high level business overview

Provides hands-on exercises on application and database level

Free Units and Promotions

Provides an overview of Free Units and Promotions in BSCS

Provides hands-on exercises on application and database level

Usage Data

Provides an overview of the concept of Usage Data Records in BSCS

Provides hands-on exercises on database level

Billing

Gives an overview about the billing process

Investigates billing on database level and explains where to find the billing results

Accounting

Gives an overview about Accounting in BSCS

Provides hands-on exercises on application and database level