CBN Circular No. 1, Dated 17-6-2010

DOWNLOADING PAN DATA FROM COMMON BUSINESS NUMBER (CBN) SERVER – REG.

CBN Circular No. 1 [F. No. SW/3/3/96/01-DIT(S)/Vol IX]-2901-02, Dated :17-6-2010

Tel. No. : 011-23676480

Fax : 011-23676480

To,

1. Shri Hiten Mehta, Vice President,

M/s National Securities Depositories Ltd.,

Trade World, 4th Floor, ‘A’ Wing, Kamala Mills Compound,

Senapati Bapat Marg, Lower Parel,

Mumbai-400013.

2. Ms. Daksha Thakur, Asstt. Vice President,

M/s UTI Technology Services Ltd.,

Plot No. 3, Sector 11, CBD Belapur,

Navi Mumbai – 400614.

Sir/Madam,

A new facility is developed to download data through CBN module in text files to enable Service Providers to update their PAN database. The details are as follows:

1. Service Providers are made application users of CBN Application Software. Service Providers will access CBN database of Income Tax Department through Personal Computer (PC) installed in their premises and connected to Bharti network.

2. Service Providers will connect CBN Application as application users by running appropriate link in Internet Explorer. Details are given inAnnexure A. One user is created for each Service Provideri.e. UTSL0001 and NSDL0001 with default password. The password must be changed through Action→Change Password option immediately on first login.

3. (i) Data will be downloaded in the form of fixed width text files (no delimiter). Downloading of files is available through Query→Download Data. Service Provider will download data for following tables from CBN database one by one :

CSS_ALL_AREA_NCC CSS_ALL_CCIT_NCC

CSS_ALL_CIT_NCC CSS_ALL_RANGE_NCC

CSS_ALL_AO_NCC

CSS_NCBN_AIS

CSS_NCBNJPAN

CSS_ALL_EVENT

CSS_ALL_EVENT_LINK

CSS_ALL_PAN_DEL_LIST

CSS_DELETED_ASSESSEE_NCC

CSS IPAN_DELETED_PAN_RQST_NCC

CSS_GB_CODES

CSS_REJECT_REASON

CSS_ALLOWED_INITIALS

(ii) Destination file name will be shown in ‘Download File Name’ field. Naming convention of the files downloaded, File format and other details for updating PAN database at Service Provider site are enclosed herewith as Annexure-B.

(iii) Entire data in a table will be downloaded in the file where ‘Download duration’ is set as 9999 days. No entry is needed in ‘From Date’ and ‘To Date’ fields.

(iv) Entry in ‘From Date’ and ‘To Date’ field is needed in case of tables where ‘Download duration’ is set as 5 days. ‘From date’ can not be earlier than number of days mentioned in ‘Download duration’ field from the current date including the current date. The Date time format DDMMYYYY HH:MI:SS is in 24Hours time format ( i.e HH is in 24Hrs format). The range will be HH24 Hour of day (0-23), MI Minute (0-59) and SS Second (0-59).

(v) Sequence number of database column, Database column name, Database Column size in downloadable file is also shown on the screen. This is set by the CBN Administrator which can not be changed by the user.

(vi) Users should make sure that the required columns are ticked and their order is in conformity of the upload software of Service Provider before downloading the file.

(vii) On pressing ‘Download Data’ button file will be created in /dit/<SP>/cbn directory of Data Exchange Server installed in PDC and already in use for PAN process. Service Provider can download these files from Data Exchange Server as they are doing for other files of PAN process.

(vi) Hierarchy tables, CSS_ALL_AO_NCC, CSS_ALL_RANGE_NCC, CSS_ALL_CIT_NCC,           CSS_ALL_CCIT_NCC          and CSS_ALL_AREA_NCC will be downloaded together whenever any out of five tables is downloaded. Likewise, both the event related tables i.e. CSS_ALL_EVENT and CSS_ALL_EVENT_LINK will also be downloaded together. Therefore, only one table should be chosen for downloading from hierarchy and event tables to avoid generation of unnecessary files.

4. The export dump of required table will be provided by the Directorate for creating PAN database by the Service Provider. The files downloaded through CBN module will contain changed/incremental/full table data and will be used to update/append/replace data in tables of PAN database created by Service Provider.

5. The tables which have lesser data will be set ‘Download duration’ as 9999 and will be downloaded entirely. The Service Provider has to delete existing data in such tables from his database before uploading of data from the file downloaded from CBN thus creating the table entirely afresh. Tables which have large volume of data will be updated/appended from the incremental text files downloaded.

6. Service Provider should not download data from CBN more than once in a day. As per current schedule of refreshing of CBN from NCC, which is 1200 hrs., it is suggested that UTI will start downloading of data from CBN starting from 1400 hrs. and NSDL will start downloading of data after 1530 hrs. No download is permissible after 1900 hrs. in the evening. UTI will start downloading tables having large data first and NSDL will start downloading tables having small data first. However, if download is not completed due to any reason during above period Service Providers can download files starting 0930 hrs. in the next morning. The work of download in morning session should be managed so that it is finished before 1200 hrs. not causing any disruption in refreshing of CBN database from NCC.

7. Following directories have been created on Data Exchange Server which is already in use for PAN process and UTI and NSDL have access :

For UTI/dit/uti/cbn

For NSDL/dit/nsdl/cbn

Service Providers have been provided read only access on the files generated in above directories.

8. The existing facility for refreshing PAN database through leased line connection will not available after 30th June, 2010. Hence, from 1^stJuly, 2010 onwards Service Providers will refresh their PAN data through above facility.

Yours faithfully,

(Neeraj Kumar)

Joint Director of Income-tax (Systems)

Annexure-A

Accessing Common Business Server(CBN) Application Software

Pre-requisite

1. To run CBN Application requires following software/batch files to install/run on client PC :

Copy ITD XP with all the contents in local PC from where CBN has to be accessed; and

For Windows PC(2000 and XP): Run following

(i) Run jinit l3122.exe fromJINITIATOR directory

(ii) Run ITDAPP.exe.

(iii) Copy orarrp.exe fromORARRP directory to C:Program files directory and Run orarrp.exe from their.

Above files will be provided through eMail.

2. Following DNS server addresses should be entered in ‘Internet Protocol (TCP/IP) Properties’ of Local Area Connection properties of the PC:

Preferred DNS server 10.152.39.11

Alternate DNS server 10.152.39.12

Accessing CBN Application Software

1. Start Internet Explorer software in PC having Windows environment (Windows 2000 or XP).

2. Run following link by typing in Internet Explorer’s Address tab: https://itdapp.incometax.net/forms/frmservlet?config=CBN

3. On clicking ‘Go’ button next to Address tab in Internet Explorer RSA Authentication screen will open. In RSA Authentication screen user has to give User Id provided with RSA tokens and password from RSA token screen.

4. On successful RSA authentication CBN Application User Logon screen will open. User has to enter CBN user i.e. UTSL0001 for UTITSL and NSDL0001 for NSDL and password to use file download screen through Query→Download Data. Default password is set as User id itself. Password must be changed immediately on first logon.

Annexure-B

Naming convention, Structure of Output files downloaded from CBN and updation of PAN database at Service Provider site

A. Naming convention for file downloaded from CBN will be as follows:

<USER><DATABASE TABLE><DDMMYYYYHHMMSS>.txt

On 1-7-2010 for user UTSL0001 and Database Table CSS_ALL_AREA_NCC, the file generated will be:

UTSL0001 CSS_ALL_AREA_NCC01072010112209.txt

Similarly, on 2-7-2010 for user NSDL0001 and Database Table CSS_NCBN_AIS, the file generated will be:

NSDLO001 CSS_NCBN_AIS02072010102219.txt

B. Structure of the Output file downloaded from CBN

Structure of the file for CSS_ALL_AREA_NCC

Structure of the file for CSS_ALL_AO_NCC

Structure of the file for CSS_ALL_RANGE_NCC

Structure of the file for CSS_ALL_CIT_NCC

Structure of the file for CSS_ALL_CCIT_NCC

Structure of the file for CSS_NCBN_AIS

Structure of the file for CSS_ALL_PAN_DEL_LIST

Structure of the file for CSS_ALLOWED_INITIALS

Structure of the file for CSS_ALL_EVENT

Structure of the file for CSS_ALL_EVENT_LINK

Structure of the file for CSS_DELETED_ASSESSEE_NCC

Structure of the file for CSS_GB_CODES

Structure of the file for CSS_REJECT_REASON

Structure of the file for CSS_NCBN_IPAN

Structure of the file for CSS IPAN_DELETED_PAN_RQST_NCC

NOTE : The Date time format DDMMYYYY HH:MI:SS is in 24 Hours time format (HH is in 24Hrs format). The range will be HH24 Hour of day (0-23), MI Minute (0-59) and SS Second (0-59).

C. Updating tables in PAN database at Service Provider site

Where ‘Download duration’ is set to other than 9999, files downloaded will be generated on the basis of Timestamp. Where Timestamp is not available files will be generated on the basis of Date of Allotment of PAN i.e. ALLOT_DT or DT_PAN_GEN fields.

Service Provider will update their database on following basis: