Floppy Structure for AABY and SHG Schemes :
(Please note that the SHG Account Number is a compulsory field for all SHG policies, To be entered in the column ‘BPL or SHG Account Number’ )
Servicing P&GS Unit Code |
|
Char(4) |
Policy No |
|
Number (10) |
Member Id |
|
Char (30) |
Member Name |
|
Char (50) |
Father OR Husband’s Name |
|
Char(50) |
Whether Father or Husband |
|
Char(1)(F for Father and H for Husband) |
Sex |
|
Char(1)(M for Male , F for Female, T for Transgender) |
Date Of Birth |
|
Date |
Caste Code |
|
Number(2) |
House OR Street Name |
|
Char(50) |
Village Name |
|
Char(50) |
Taluka Name |
|
Char(50) |
District Code |
|
Number(2) |
State Code |
|
Number(2) |
Pin Code |
|
Number(6) |
Member’s Occupation |
|
Char(25) |
Nominee’s Name |
|
Char(40) |
Nominee’s Relation Code |
|
Number(2) |
Nominee’s Dob |
|
Date |
Nominee’s Occupation |
|
Char(25) |
Appointee’s Name |
|
Char(40) ( Only If nominee is minor) |
Appointee’s Relation Code |
|
Number(2) |
Number of Children |
|
Number(2) |
Identification Mark of Member |
|
Char(50) |
State of Health of Member (CODE) |
|
Number(2) |
BPL or SHG Account Number |
|
Char(20) |
Language Code |
|
Number(2) |
UIDAI NO |
|
Number(12) |
Ration Card Type |
|
Number(2) |
Ration Card No |
|
Char(25) |
Unique Registration No |
|
Char(25) |
The Member Id should be a unique number constituted as follows :
The first 2 digits will be the District Code
The next 3 digits will be of the Taluka Code
The next 4 digits for Village Code
And the remaining 11 digits will be a running number for the member ids