GSM ?

Global System for Mobile Communication
//
Groupe Speciale Mobile

a committee under the
Conférence Européenne des Postes et Télécommunications (CEPT).

Mobile Number Portability

Mobile Number Portability
===================

Enables a subscriber of a telecommunication provider to port his/her service to another telecommunication provider
in that country, but retain his/her telephone number.

Mobile number portability (MNP) is the implementation in the GSM network of the NP concept.
MNP is introduced in GSM Release R98.

NP or MNP mean that a subscriber has a telephone number belonging to one operator
(number range holder network), while that subscriber is a subscriber of another operator (subscription network).

At least the following NP cases may be defined:

The terms ‘number range holder network’ and ‘subscription network’ are defined for MNP, but also apply
functionally to NP.

• number portability between two GSM networks;
• number portability between two PSTNs;
• number portability between GSM and PSTN.

NP between GSM and PSTN is less common than NP between homogeneous networks.
Denmark is one example of a European country that uses mobile-fixed NP.

One aspect of many telecommunications networks is that a subscriber is identified with a number,
whereby the number is part of a number range.

The number by means of which a subscriber is identified has various purposes, including:

• routing – when a call is established, the routing of that call through the network is based on the
number that is used to identify that subscriber, e.g. a call to +31 65 . . . is routed to the network
from KPN Mobile (‘65’) in The Netherlands (‘+31’).27

• network identification – the number indicates the network that a subscriber belongs to, e.g. a
subscriber with number +31 13 . . . is associated with a local exchange in a particular region of
the PSTN from KPN Netherlands.

• tariff – a subscriber from T-Mobile Netherlands may be charged a lower rate for calls to other
T-Mobile Netherlands subscribers than for calls to Orange Netherlands subscribers.
The introduction of NP affects the above associations of a telephone number.

Explanation of Transit Call

The Transit MSC simplifies the task of configuring a large network containing many interconnected switching elements, such as mobile switching centers and home location registers. By routing all inter-element signalling through the Transit MSC, operators are able to rationalize signalling routing and reduce time and money spent configuring new elements into the network.

But the Transit MSC goes beyond what conventional transit switches can do. Due to built-in mobile application part functionality, the Transit MSC is able to route incoming calls from a fixed network directly to the right MSC in the GSM network. Normally, such a call is routed from the fixed network to an MSC at random, even if the call is intended for a part of the network handled by a different MSC. This results in extra processing load on this "gateway" MSC, since it must forward the call to the correct one. The Transit MSC acts as a one-point gateway for the entire network, reducing the routing load on all the other MSCs and saving the operator the additional transmission costs. Moreover, the Transit MSC features full support for the state-of-the-art Intelligent Networks.

What is an MSISDN ?

Mobile Station Integrated Services Digital Network Number (MSISDN)
-------------------------------------------------------------------
Used to identify a subscriber, below mentioned the structure of the MSISDN.

Country Code (CC)||National Destination Code (NDC)||Subscriber Number (SN)

<--1,2or3 digits-->

<--------------------------Maximum 15 Digits ---------------------------->


Country Code --> Country or group of countries of the subscriber.

National Destination Code --> each PLMN in a country has one or more NDCs allocated to it.

NDC may used to route a call to the appropriate network.

Subscriber Number -->identifies the subscriber within the number plan of a PLMN.

Whats an IMSI?

International Mobile Subscriber Identity (IMSI) is embedded on SIM card and is used to identify a subscriber. 15 digits normally , Initial 3 digits stand for MCC , next 2 or 3 digits stands for MNC,
last digits stands for MSIN.

MCC--> Mobile Country Code identifies country for mobile networks. The MCC values are allocated and published by the ITU-T.

MNC--> Mobile Network Code identifies mobile network within a mobile country(as identified by MCC). MCC and MNC together identify a PLMN.

MSIN--> Mobile subscriber Identification Number (MSIN) - the MSIN is the subscriber identifier within a PLMN (Public Land Mobile Network).

Easy Decode for Data Validation

The following nesting of Oracle functions can be used for validating two different columns between source and target tables.

decode(replace(trim(nvl(a.STREET_NAME,0)),trim(nvl(b.STREET_NAME,0)),'Y'),'Y','Y','N')

Will return 'Y' if the value matches between two columns and 'N' otherwise.

Please put some comments in my blog for any doubts regarding the same.

Formatting SQL*PLUS output

SQL> select max(account_code_n) from mastertable;

account_code_n
-----------------
2.000E+09

SQL> column account_code_n format 9999999999999

SQL> select max(account_code_n) from mastertable;

account_code_n
-----------------
2908006098712

First_Date function like Last_Day function in Oracle

create or replace FUNCTION first_day(value_in DATE)
RETURN DATE IS
vMo VARCHAR2(2);
vYr VARCHAR2(4);
BEGIN
vMo := TO_CHAR(value_in, 'MM');
vYr := TO_CHAR(value_in, 'YYYY');
RETURN TO_DATE(vMo || '-01-' || vYr, 'MM-DD-YYYY');
EXCEPTION
WHEN OTHERS THEN
RETURN TO_DATE('01-01-1900', 'MM-DD-YYYY');
END first_day;

Query to check Date against null date columns

nvl(trunc(gsm.ACTIVE_DATE_D),to_char(to_date('01/01/1900','DD/MM/YYYY'))) <= '01-Nov-2009'

Query to add 2 new columns to a table

alter table recon.BR_Target_Invoice_Data add (DB_ADJUSTMENTS_N NUMBER(15,2) ,cr_ADJUSTMENTS_N NUMBER(15,2) )

Query to alter a column in Oracle SQL

alter table recon.BR_Source_Invoice_Data modify(db_inv_rnd_off_n number(15,2))

BPMN

Business Process Modeling Notation (BPMN) is a standard method of representing business processes as graphical Models. It is widely adopted by Business Process Management. BPMN is a standard for Business Process Modeling (BPM).