National Social Assistance Programme
(NSAP-MIS)
Document for Bridge/Interface software for States
(Ver 1.1)
This document is intended to develop the bridge/interface application for online data auto updation pensioners of NSAP scheme on NSAP-MIS for states they are using their own state MIS portal. The following upgraded guideline is described in detail for the development of Interface/Bridge software by the states.
STEP1: Completion of Masters on NSAP-MIS by Districts Rural
1. State will ensure that all villages and habitations coming under each Blocks is covered in NSAP-MIS. If any village or habitation is not available then state will ensure that missing villages/habitations are created by districts and sub districts on NSAP-MIS. User id and password has already provided to each districts and sub districts.
Alert: As and when a new village and habitation is added in state MIS portal then the same entry is also to be added in NSAP-MIS immediately and code generated under NSAP-MIS, Will have to maintain in state local database master.
2. Mapping module is also provided in NSAP-MIS to shift a sub district, Gram Panchayat, Village and habitations from one location to another location for maintaining the masters easily.
Urban
3. State will ensure that all municipalities and wards coming user each municipality is covered in NSAP-MIS.
Option1 - If it does not match, then state will request us to remove all municipality and wards and send us the list of municipality and wards to us in MDB file structure. We will process it and generate the municipality code and ward code as per NSAP Standard. (This is one time exercise so states has to ensure that urban master is complete and up to date)
Option2 - On request of state, all municipalities and wards will be get deleted and state will create municipality and wards, district wise online under masters on NSAP-MIS.
Once this job is over then location master as per NSAP-MIS standard will be provided to states to further map NSAP-MIS location codes such as district code, state code, sub district code, gram Panchayat code, village code and habitation code in their own MIS portal in order to meet out compatibility between NSAP-MIS and states own MIS.
Alert: As and when a new ward is being added then the same will also be created in NSAP-MIS immediately and code generated under NSAP-MIS shall also have to maintain in state own MIS masters.
4. Mapping module is also provided in NSAP-MIS to shift a Municipality, wards from one location to another location for maintaining the masters easily.
NOTE: Once this exercise will be complete districts can download the NSAP location master mentioned below. District IT nodal officers login to NSAP-MIS and Click Reports/Utility-Download Data. Entire pensioner’s data along with following master will be downloaded in MDB format. Please ensure that masters are completed before downlading.
(i) State master (ii) District master
(iii) Sub district / municipal master (iv) Gram Panchayat/ ward master (v) Village master
(vi) Habitation master (vii) Disability Master (viii) Category Master (ix) Pensioner Master
STEP2 : Mapping of NSAP locations code with State MIS database.
Once master data completed by states on NSAP-MIS, the same may be downloaded by the concern districts to do the following activities as
- In state MIS database, they will also maintain the location code of NSAP as district code, sub district code, GP,Ward, Village and habitations.
- Disability code as per NSAP master laso need to maintain for each pensioner in case of IGNDPS scheme.
- Category code is also to be maintain for each pensioner as per NSAP code for category master.
- State will maintain one additional field in their pensioner master to maintain the status of pensioner record that whether pensioner record has been uploaded on NSAP-MIS earlier or not. A field namely “NSAP-MIS-Uploaded” value as Y/N is to be maintained.
- On first instance, all pensioner record will have “N” ie. No.
- Once records push on NSAP-MIS successfully then status will be updated as “Y” i.e Yes.
- On next cycle of pushing data on NSAP-MIS, only pensioner records will be get uploaded which having as status “N” only.
STEP3 : Preparation of Pensioner Master as per format provided.
1. States has to prepare pensioner master as per the format given below and make the data ready to push on NSAP-MIS. The sequence, field name and data type of each field in pensioner master is to be ensured that it has not been changed and data as per the sequence and format with exact data type described below in table in point no 5.
2. All mandatory fields in pensioner master should must have the correct data value. 3. The pensioner master is to be created as per the NSAP code standard only. Local
code will be not acceptable.
4. Date fields will be having dates in yyyy-mm-dd format only.
5. All created pensioners record will be having status field as “SO_SAVED” Structure of NSAP Pensioner master with detailed field description as
Field Name Data Type Field description
Sample data value Mandatory beneficiary_no character varying Beneficiary Number of your state 1234XY Yes state_code
varying(40) digit) as per NSAP district_code
character varying(40),
District code (four
digit) as per NSAP 3401
yes
rural_urban_area character(1),
Rural/ Urban area (R for rural and U for Urban) as per NSAP R Yes sub_district_munic ipal_area_code character varying(40),
Sub district code in case of Rural and Municipality code in case of Urban as per NSAP 3401001 in case of rural 34010001 &in case of urban Yes gram_panchayat_ ward_code character varying(40), Gram panchayat code in case of rural and ward code in case of Urban as per NSAP 34010010 01 in case of rural & in cas of urban 34010001 0001 yes village_code character varying(40),
Village code only in rural case as per NSAP 34010010 0101 in case of rural and 0 in case of urban yes habitation_code character varying(100), Habitation code only in rural case as per NSAP 34010010 010101 In case of urban it is yes
0 first_name
character
varying(100), First Name RAMAN
yes
middle_name
character
varying(100), Middle name Mohan
No
last_name
character
varying(100), Last name Sharma
No. father_husband_n ame character varying(100), Father/husband name RAM Yes nominee_name character
varying(100), Nominee Name Shyam
No address1 character varying(100), Address 1 Yes address2 character varying(100), Address 2 Yes address3 character varying(100), Address 3 Yes pincode numeric, Pincode Yes beat_code numeric, Beat code No bpl_year numeric, BPL Year Yes bpl_location
character
varying(40), BPL location
No bpl_member_id numeric, BPL Member Id 1 Yes bpl_family_id character varying(12), BPL Family ID 12 Yes gender character(1), Gender , F for female and M for Male only F
age numeric(4,0),
Age ( as per scheme criteria) 65
Yes
date_of_birth date, Date of birth
1945-07-01 yyyy-mm-dd No category_code character varying(40), Category code: ST ,SC, OBC,
GEN,MIN , OTH OBC
Yes
annual_income numeric, Annual Income 1000 No
widows character(1),
Widows Y for yes and N for No Y Yes in case of IGNWPS scheme disability_status character(1), Disability Status Y for yes N for No only Y Yes in case of IGNDPS scheme disability_code character varying(40), Disability code as per NSAP disability code master MD/CP/M I/HS/LC/V I Yes in case of IGNDPS scheme disability_percent numeric(3,0), Disability Percent in scheme IGNDPS only 80 Yes in case of IGNDPS scheme epic_no character
varying, Epic No. V654664 No
rationcard_no
character
varying(15), Ration Card no. R756765 No disbursement_cod e character varying(3), Disbursement code 1 for bank 1 yes
2 for post office account
3 for money order 4 for cash only.
bank_po_account_ no
character varying,
Bank or Post office account no. 15869316 5744 Yes in case of Bank And PO only disbursement_upt o_state date, Disbursement upto date for state
2012-03-31
No
sanction_auth
character
varying(60), Sanction authority
Name of authority No sanction_order_no character
varying(100), Sanction Order no
Will be generated at run time when pushing data to NSAP-MIS server No sanction_date date, Date of sanction of application 2012-12-27 No scheme_code character varying(40), Scheme code as per NSAP IGNOAP S/ IGNDPS/I GNWPS Yes age_cert_issue_au th character varying(100), Age certifying authority name No
inc_cert_issue_aut h character varying(100), Income certifying authority name No res_cert_issue_aut h character varying(100), Resident certifying authority name No dis_cert_issue_aut h character varying(100), Disability certifying authority name No death_cert_issue_ auth character varying(100), Death certifying authority name No
status character(20), Status
SO_SAV ED (Fixed as per NSAP) Yes ver_lev1_id character
varying(40), Verification Level 1
No ver_lev1_remarks character varying(250), Remarks No ver_lev2_id character
varying(40), Verification Level 2
No ver_lev2_remarks character varying(250), Remarks No ver_lev3_id character
varying(40), Verification Level 3
No ver_lev3_remarks character varying(250), Remarks No user_created character
varying(40), User Created
AS-ITNO (user id of State
ITNO as per NSAP) creation_date date, Entry date of application 2012-01-28 No
application_date date, Application Date
2011-12-31 No age_cert_issue_da te date, Yyyy-mm-dd No inc_cert_issue_dat e date, Yyyy-mm-dd No res_cert_issue_dat e date, Yyyy-mm-dd No dis_cert_issue_dat e date, Yyyy-mm-dd No death_cert_issue_ date date, Yyyy-mm-dd No
ver_lev1_date date, Yyyy-mm-dd No ver_lev2_date date, Yyyy-mm-dd No ver_lev3_date date, Yyyy-mm-dd No
applicant_name character varying(250), Applicant Name (First name+Middle Name+Last name) Raman Mohan Sharma Yes disability_code1 character
varying(40), Disability code 1 as per NSAP for
Yes for IGNDPS and
IGNDPS Scheme only No for other scheme disability_code2 character varying(40), Disability code 2 as per NSAP for IGNDPS Scheme only Yes for IGNDPS and No for other scheme application_no character(13)
NOT NULL, Application No
Will be generated at the time pushing data on NSAP-MIS No pension_effective_ from_date date, Pension effective from date 2001-07-01 Yes remark character varying(100), Remark No transfer_order_no character
varying(20), Transfer order no
No dis_transaction_id character(11), Disbursement transaction id No pda_code character varying,
PDA code (Bank branch code) Null
No
reinstate_date date, Reinstate date
2011-07-01
No image_name bytea, Image Null
minority_status character varying, Minority status(Y/N) N No
numeric(3,0), Disability percent 80
Yes for IGNDPS and
disability_percent1 No for other scheme flag_for_print boolean, Printing flag Null No contact_person_m obile character varying(10), Contact person mobile 94508568 79 No
flag_for_image boolean, Image Null No uid_no character varying(20), Unique id of applicant No select_value character varying, Null No status_of_benefici ary character varying, Status of beneficiary LEGACY _SO_SA VED (Fixed value) Yes plan_code character
varying(5), Plan code Null
No disbursement_upt o_center date Disbursement up to date at center 2012-03-31 No Id_mode Character varying UID generation mode UIDAI/NP R No Eid_no Character varying Enrollment identification number allotted by UIDAI Eid no No Tin_no Character varying If uid_no generated based on National Population Tin_no No
Register based
Freeze_ac
Character varying
Value “Yes” if bank account no verified
from Banks Yes/No
No
STEP4 : Preparation of disbursement abstract summary by states
As far as to view the disbursement abstract summary on NSAP-MIS, following has been decided in order to view the disbursement abstract summary as
1. State will be updating the monthly total pensioners, total amount in Lakhs scheme wise for state and it is to be updated on NSAP-MIS so that total pensioner and total amount can be reflected against the state. The table on NSAP MIS available as
Field Name Mandatory Data Type
state_short_name WB/RJ/KN/UK/HP character varying(10) scheme_code Yes character varying(40) Year Yes character varying(10) january_total_pensioners Yes character varying(10) january_amount Yes character varying(10) february_total_pensioners Yes character varying(10) february_amount Yes character varying(10) march_total_pensioners Yes character varying(10) march_amount Yes character varying(10) april_total_pensioners Yes character varying(10) april_amount Yes character varying(10) may_total_pensioners Yes character varying(10) may_amount Yes character varying(10) june_total_pensioners Yes character varying(10) june_amount Yes character varying(10) july_total_pensioners Yes character varying(10) july_amount Yes character varying(10) august_total_pensioners Yes character varying(10) august_amount Yes character varying(10) september_total_pensioners Yes character varying(10) september_amount Yes character varying(10) october_total_pensioners Yes character varying(10)
Table Name on NSAP-MIS as “disbursement_abstract_report_state”
2. State has to develop a module which will be showing the disbursement summary in the format given below and url/link has to be provided to NSAP-MIS (NIC) to put the url on state name under Reoprt “Disbursement Abstract”. This link will be taking to the state local MIS to review the disbursement in following format. 3. The url/link will be taking it to state MIS portal to select the scheme and year. On
submit it will be showing the web page in following format showing all districts at left column and monthly total pensioners and total amount in lakh of selected year. There will be a link on district as well on total pensioner both.
november_total_pensioners Yes character varying(10) november_amount Yes character varying(10) december_total_pensioners Yes character varying(10) december_amount Yes character varying(10)
Scheme Name: Year: District Name Jan P A Feb P A ……. D1 244 2.92 124 1.02 D2 .. .. .. .. D3 .. .. .. .. ….. .. .. .. .. Total
• P= Total Pensioners A=Total Amount in lakhs
On clicking of H1 link, it will drill down to further sub districts aggregating sub district wise total pensioners and total pension amount in lakh. The format is given as Scheme Name: Year: SubDistrict/ Municplality Name Jan P A Feb P A ……. S1 100 1.01 111 1.02 S2 50 1.05 .. .. S3 .. .. .. .. ….. .. .. .. .. Total
• P= Total Pensioners A=Total Amount in lakhs
On clicking of H2 link, it will be showing another web page showing the details bank branches, post office/branch post office wise and cash authority wise total pensions and total pension amount with their sub total and grand total. The format of report is given as
H1
H2
District Name: --- Scheme Name:--- Month ---
Year:--- (Amount in lakhs)
Bank Branch Name Total Pensioners Amount
Branch 1 123 (DBT) / 323(Non DBT) 12.12
Branch2 244 …..
…. …. …
Sub total H3
Post Office Name Total Pensioners Amount
PO 1 455 45.45
PO 2 ….. …..
…. …. …
Sub total H4
Cash Aunthourity Name Total Pensioners Amount
Cash 1 34 5.8 Cash 2 ….. ….. …. …. … Sub total Grand Total(bank+PO+cash) … .. H5
On clicking link H3, it will be generating the list of pensioner where payment has been made through bank branch in the prescribed format given below.
Download excel sheet facility is also to be given so that list of beneficiaries against each transactions can also be seen at national level.
As monitoring will be done for DBT and non DBT both, pensioners list should also be there for DBT scroll and non DBT scroll both.
On clicking link H4 or H5 the pensioners list where payment has been made through Post offices and Cash disbursing agencies is also to be shown in a suitable format shown above. Bank name, Bank account no is to be replaced with Post office name/Cash disbursing agency list and PO account no. In case of cash (H5) this field may be blank. IFSC code and Aadhar no also may be blank in case of post office/cash disbursing mode.
STEP5 : Pushing pensioner master data by states to NSAP-MIS server
Once the pensioner master data and disbursement_abstract_report_state is ready by the state, the same is required to push on NSAP-MIS server on weekly/fortnightly/monthly basis using web services developed by states. The web service will push all data to NSAP-MIS server where NSAP_MIS_uploaded field value is “N”.
For each pensioner record while pushing, application no and sanctioned order no will be get generated at run time as per the format adopted in NSAP-MIS server.
The format of application no is “<State_Short_Name>-A-<Last running serial no+1> for every pensioner record. E.g AP-A-00000009
The format of sanction order no is “<State_Short_Name>-S-<Last running serial no+1> for every pensioner record. E.g AP-S-00000009
Application no and sanction order no will be of same serial no.
Once the pensioner record successfully uploaded on NSAP-MIS, state MIS database will update the field “NSAP-MIS-Uploaded” as “Y” i.e yes.
Data Pushing by states to NSAP-MIS
State need to create service provider using web services which will update data for various schemes(IGNOAPS, IGNDPS and IGNWPS) in to NSAP MIS.