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