DBT Schemes
Data Integration Approach
------
Contents
1. Scheme Data Format 3
2. Method to share the data with DBT Bharat Portal 4
3. Integration Approach – Web Services 5
4. Integration Approach – Manual File Upload 8
In this document, we are explaining the approach to integrate the Scheme related data (till village level, as aggregated number) with DBT Bharat Portal for DBT on boarded schemes.
1. Scheme Data Format
a. Below table is depicting all the fields related to Cash Benefit Type Schemes.
SNO / Field name / Format / Type / Description1 / StateCode / String / Beneficiary State Code
2 / StateName / String / Beneficiary State Name
3 / Amount / String / Beneficiary transfer amount
4 / FundTransferMethod / String / Fund Transfer Method
(
· Electronic Payment (APB, NEFT, RTGS etc.)
· Other Mode (Cash, Cheque, DD, MO etc.)
)
5 / TransactionDate / String / Transaction Date
6 / NoOfBeneficiaries_Transacations / String / Number of Transactions against which amount has been disbursed
7 / AadharSeededBeneficiariesTransactions / String / Number of Aadhaar Seeded transactions against which amount has been disbursed
8 / TotalBeneficiary / String / Total Number of cumulative Beneficiaries (Active as of now)
9 / TotalBeneficiaryAadhaarSeeding / String / Total Number of Aadhaar Seeded Beneficiary (Cumulative Active as of now)
10 / TotalBeneficiarywithBankAccount / String / Total Number of Beneficiary with Bank A/C (Cumulative, Active as of now)
11 / TotalBeneficiarywithAadhaarSeededwithBankAccount / String / Total Number of Beneficiary with Aadhaar Seeded with Bank A/C
(Cumulative, Active as of now)
b. Below table is depicting all the fields related to In Kind Benefit Type Schemes.
SNO / Field name / Format / Type / Description1 / StateCode / String / Beneficiary State Code (Preferably LGD Code)
2 / StateName / String / Beneficiary State Name
3 / Amount / String / Incremental Expenditure Amount (in Rs) incurred to provide In Kind Benefits
4 / BenefitTransferMethod / String / Fund Transfer Method
(
· Aadhaar Authentication
· Manual Verification
)
5 / TransactionDate / String / Transaction Date
6 / NoOfBeneficiaries_Transacations / String / Number of Transactions against which benefit has been transferred or provided
7 / AadharSeededBeneficiariesTransactions / String / Number of Aadhaar Seeded transactions which benefit has been transferred or provided
8 / TotalBeneficiary / String / Total Number of cumulative Beneficiaries (Active as of now)
9 / TotalBeneficiaryAadhaarSeeding / String / Total Number of Aadhaar Seeded Beneficiary (Cumulative Active as of now)
10 / TotalBeneficiarywithBankAccount / String / Total Number of Beneficiary with Bank A/C (Cumulative, Active as of now)
11 / TotalBeneficiarywithAadhaarSeededwithBankAccount / String / Total Number of Beneficiary with Aadhaar Seeded with Bank A/C
(Cumulative, Active as of now)
2. Method to share the data with DBT Bharat Portal
a. Ministry / Department will have to share information using the location code (State, District). To make it standardized in all schemes across all Ministries / Departments, it is recommended to use the Local Government Directory (http://lgdirectory.gov.in/ -> Download Directory Section).
b. Above shown fields are non-mandatory and uniform against all schemes. Ministry / Department has to provide all relevant information available to share with DBT Bharat Portal.
c. Before sharing the data with DBT Bharat Portal, Ministry / Department has to ensure following points.
i. Please send a communication to onboard a scheme on DBT Bharat Portal when Ministry / Department is ready to provide data to share with PMO on monthly basis. This will be analyzed by DBT Mission Officials.
ii. DBT Cell coordinator has to generate the Scheme code and should meet the minimum criteria provided by DBT Mission.
iii. Once Scheme is on-boarded on DBT Bharat Portal, Ministry DBT Cell Coordinator has to update the scheme data regularly which will generate the Monthly Progress Report (MPR) for PMO.
d. Approach to Update scheme data on DBT Bharat Portal
iv. Web Service Based Integration: This is automated process to share the data with DBT Bharat Portal. In this approach, Ministry has to generate the webservice in defined signature and share with DBT Bharat Team. Detail information provided in section 3.
v. Pre-defined csv file upload: If Scheme data is not available in webservices, Ministry / Department DBT Cell coordinator can prepare the data in csv (comma separated value format) file in pre-defined format provided by DBT Bharat Portal and upload into DBT Bharat Portal any moment of time. Detail information is provided in section 4.
e. Data uploaded should be incremental.
f. Data ownership lies with Ministry / Department, DBT Portal is just an aggregator to show the data in MPR which will be used in multiple review meetings.
g. Scheme specific location code used by Ministry/ Department should be provided to DBT Mission Technical team to map with DBT Bharat Portal for before exchanging data with DBT Bharat Portal as mentioned approach in point c.
3. Integration Approach – Web Services
Process of Interaction: Interaction of DBT Portal with Schemes is depicted below.
DBT Portal will call a Web service exposed by the scheme by passing Scheme Code (5 digit alphanumeric number - generated through DBT Bharat Portal), State Code and Date as request parameters. Scheme will send back the following details in Response:
1) Complete Dataset OR
2) No Data if No Records are found OR
3) Error Message if there was some issue.
Technology Details
Technology: Restful web service / SOAP
Response: XML
Usage: This web service will push/insert beneficiary data to DBT Portal database for specific scheme.
Limitation: It only appends beneficiaries’ data into existing data.
Server: DBT Portal
Every time, system will publish the incremental data to DBT Portal.
To use this Service follow steps are needed:
ü Ministry / Department need to ensure that scheme location master should be mapped with DBT Portal Location master (States and Districts) before using web services.
ü Data should be prepared in discussed XML format before pushing it to DBT Portal.
Response: XML will be taken by DBT Portal in response and need to grab response and update accordingly. Please note that all the fields in the response are null able fields i.e. data in any of these fields can be null.
Fields in XML given below:
Sample Xml and xsd
A sample xml and xsd have been attached for reference
XSD file:
XML files:
How webservice will work:
1. Ministry needs to publish the scheme wise webservices which must consume 3 parameters
a. Scheme Code – 5 digit alphanumeric number generated through DBT Bharat Portal by Ministry / Department DBT Cell coordinator.
b. StateCode – two digit integer code (this code will be LGD standard code, which need to be verified and mapped with DBT portal. This is one time activity during configuration. Any change in code by ministry need to be informed prior so that DBT portal can update mapping of location code into the system for smooth update / changes)
c. Date in dd/mm/yyyy (assumed incremental data will be provided by ministry against the scheme; if not need to decide the update frequency based on scheme MIS update)
2. Once DBT Mission will receive the xml response, portal will be updated. For that period webservice will not be available to consume again by ministry.
3. If DBT Portal gets error response, DBT portal will try to consume again. Still it fails, we will inform Ministry DBT Cell to correct the issue and inform via mail to pull the data for defined date and statecode. DBT Portal will fetch (invoke the webservice) that information after getting ministry confirmation.
4. If DBT Portal gets no record, DBT portal will inform to ministry DBT cell on this as record. If any correction need to be done, ministry DBT cell needs to be confirmed to fetch data if required.
4. Integration Approach – Manual File Upload
1. Ministry / Department has to download the csv file format from DBT Bharat Portal.
2. To Download the latest sample file, Ministry / Department DBT Cell Coordinator has to login with provided credentials and go to Administrator -> Manage Scheme Data -> Against the assigned scheme, choose File Upload option -> File Upload Button -> Click Here. This will provide the sample file attached.
3. Once Ministry / Department is ready to upload the data, Ministry / Department has to share Location code which needs to be mapped with DBT Bharat Portal (LGD standard)
4. After step 3 completed, Ministry / Department will able to upload the data themselves.
7 | Page