Table Design

CSM/QT/12/06
Version:3.0

Revision History
Rev Descripton of Changes Author Effective Date

Project
Project #
Name
Project
NIRAKAR MALLICK Date
Manager
 Table Design
CSM/QT/12/06
Version:3.0

Effective Date
 SPDPENROLL

Project Name SPDP

Data Base Version ORACLE 19C

Table Name TBL_ENROLLMENT

Sl.No Column Name Data Type
1 ENROLL_ROWID NUMBER(10,0)
2 ENROLL_ACK_NO VARCHAR2(15 BYTE)
3 LANDLINE_NO NUMBER(14,0)
4 ELECTRICITY_BILL_NO VARCHAR2(15 BYTE)
5 WATER_BILL_NO VARCHAR2(16 BYTE)
6 GAS_CON_NO VARCHAR2(10 BYTE)
7 IS_FAMILY_COMPLETED CHAR(1 BYTE)
8 RATION_CARD_NUMBER VARCHAR2(11 BYTE)
9 STATE_BPL_NO VARCHAR2(15 BYTE)
10 TOTAL_FAMILY_MEMBER NUMBER(10,0)
11 CREATED_BY VARCHAR2(50 BYTE)
12 CREATED_ON DATE
13 APPROVE_STATUS VARCHAR2(4 BYTE)
14 CARD_ACT_DT DATE
15 CARD_STS NUMBER
16 KALIANO VARCHAR2(10 BYTE)
17 PMAYNO VARCHAR2(40 BYTE)
18 HOLDINGTANNO VARCHAR2(16 BYTE)
19 MNAREGA_NO VARCHAR2(26 BYTE)
20 HOUSE_HOLD_ID NUMBER
21 UPDATED_BY VARCHAR2(100 BYTE)
22 UPDATED_ON DATE
23 RATION_CARD_TYPEID VARCHAR2(20 BYTE)
24 OTHER_STATE_ID VARCHAR2(20 BYTE)
25 IS_FROM_OTHER_STATE VARCHAR2(20 BYTE)
26 GAS_AGENCY_CODE VARCHAR2(20 BYTE)
27 IS_BSKY_FLAG VARCHAR2(1 BYTE)

Table Name TBL_ENROLLMENT_MEMBERS

Sl.No Column Name Data Type
1 MEMBER_ROWID NUMBER(20,0)
2 ENROLL_ROWID NUMBER(20,0)
3 MEMBER_ID NUMBER(30,0)

Page 3
 SPDPENROLL
4 AADHAAR_NO NUMBER(15,0)
5 AADHAAR_ACK_NO VARCHAR2(30 BYTE)
6 IS_ORPHAN VARCHAR2(1 BYTE)
7 GARDIAN_NAME_ENG VARCHAR2(200 BYTE)
8 GARDIAN_SNL VARCHAR2(250 BYTE)
9 FIRST_NAME_ENG VARCHAR2(100 BYTE)
10 MIDDLE_NAME_ENG VARCHAR2(100 BYTE)
11 LAST_NAME_ENG VARCHAR2(100 BYTE)
12 FIRST_NAME_SNL NVARCHAR2(400 CHAR)
13 MIDDLE_NAME_SNL NVARCHAR2(400 CHAR)
14 LAST_NAME_SNL NVARCHAR2(400 CHAR)
15 GENDER_ID NUMBER(1,0)
16 DOB DATE
17 AGE NUMBER(5,0)
18 IS_MINORITY VARCHAR2(1 BYTE)
19 MINORITY_COMMUNITY_TYPEID NUMBER(1,0)
20 FATHER_NAME_ENG VARCHAR2(100 BYTE)
21 FATHER_NAME_SNL NVARCHAR2(400 CHAR)
22 MOTHER_NAME_ENG VARCHAR2(100 BYTE)
23 MOTHER_NAME_SNL NVARCHAR2(400 CHAR)
24 CATEGROY_OF_FAMILYID NUMBER(1,0)
25 CASTE_ID NUMBER(3,0)
26 IS_DISABLE NUMBER(1,0)
27 RELATION_WITH_HOF NUMBER(2,0)
28 MARITAL_STAUS_ID NUMBER(1,0)
29 RESIDENT_CATEGORYID NUMBER(1,0)
30 MOBILE_NO NUMBER(10,0)
31 EMAIL VARCHAR2(100 BYTE)
32 EDUCATION_LEVEL_ID NUMBER(3,0)
33 OCCUPATION_ID NUMBER(3,0)
34 ANNUAL_INCOME NUMBER(12,0)
35 LANDOWNER_CATEGORY_ID NUMBER(2,0)
36 LAND_TYPE_ID NUMBER(1,0)
37 ENROLL_ACK_NO NVARCHAR2(15 CHAR)
38 SOCIAL_SECURITY_PPONO VARCHAR2(30 BYTE)
39 ANNUAL_INCOME_CERTF_NO VARCHAR2(30 BYTE)
40 APPROVAL_LEVEL VARCHAR2(4 BYTE)
41 APPROVAL_STATUS_ID NUMBER(1,0)
42 MEMBERS_DTS_STATUS_ID NUMBER(1,0)
43 DISABLED_CERITF_NO VARCHAR2(40 BYTE)

Page 4
 SPDPENROLL
44 DISABLED_PERCENTAGE NUMBER
45 DISABLE_CATEGORY_TYPE VARCHAR2(200 BYTE)
46 CREATED_BY VARCHAR2(20 BYTE)
47 CREATED_DATE DATE
48 FIRST_LEVEL_VERIFIED_BY VARCHAR2(20 BYTE)
49 FIRST_LEVEL_VERIFIED_DATE DATE
50 SECOND_LEVEL_VERIFIED_BY VARCHAR2(20 BYTE)
51 SECOND_LEVEL_VERIFIED_DATE DATE
52 FIRST_LEVEL_VERIFIED_REMARK VARCHAR2(2000 BYTE)
53 SECOND_LEVEL_VERIFIED_REMARK VARCHAR2(2000 BYTE)
54 IS_HOF VARCHAR2(1 BYTE)
55 SPOUSE_NAME_ENG VARCHAR2(200 BYTE)
56 SPOUSE_NAME_SNL NVARCHAR2(400 CHAR)
57 OPERATION_TYPE VARCHAR2(5 BYTE)
58 REAL_INCOME NUMBER
59 RATIONCARD_ISSUE_DATE DATE
60 MEMBER_ACTIVE_STATUS NUMBER(1,0)
61 REASON VARCHAR2(4000 BYTE)
62 HOF_STATUS_CHANGE CHAR(5 BYTE)
63 LAND_AREA NUMBER
64 MEMBER_NAME_ENG VARCHAR2(200 BYTE)
65 MEMBER_NAME_SNL NVARCHAR2(500 CHAR)
66 OLD_ENROLL_ACK_NO VARCHAR2(15 BYTE)
67 SIPF_NO VARCHAR2(50 BYTE)
68 RATION_CARD_NUMBER VARCHAR2(16 BYTE)
69 DOC_UPLOAD_STATUS VARCHAR2(1 BYTE)
70 RATION_CARD_TYPEID NUMBER(1,0)
71 WIP_MEMBER_REF NUMBER(11,0)
72 BLOOD_GROUP NUMBER(3,0)
73 RELIGION NUMBER(3,0)
74 FARMER_ID VARCHAR2(12 BYTE)
75 AADHAAR_REFERENCE_NO NUMBER(30,0)
76 SPDP_MEMBER_ID NUMBER
77 NFSA VARCHAR2(1 BYTE)
78 UPDATED_BY VARCHAR2(100 BYTE)
79 UPDATED_ON DATE
80 KRUSHAKODISHAFARMER_ID VARCHAR2(20 BYTE)
81 REASON_ID NUMBER(3,0)
82 REASON_REMARK VARCHAR2(2000 BYTE)
83 KYCUPDATE VARCHAR2(20 BYTE)

Page 5
 SPDPENROLL
84 DEDUP_OPERATION_TYPE VARCHAR2(5 BYTE)
85 THIRD_LEVEL_VERIFIED_BY VARCHAR2(20 BYTE)
86 THIRD_LEVEL_VERIFIED_DATE DATE
87 THIRD_LEVEL_VERIFIED_REMARK VARCHAR2(2000 BYTE)
88 FINAL_VERIFIED_BY VARCHAR2(20 BYTE)
89 FINAL_VERIFIED_ON DATE
90 FINAL_VERIFIED_REMARK VARCHAR2(200 BYTE)

Table Name TBL_HOF_ADDRESS

Sl.No Column Name Data Type
1 HOF_ADDRESS_ROWID NUMBER(10,0)
2 ENROLL_ACK_NO VARCHAR2(15 BYTE)
3 STATE_ID NUMBER(2,0)
4 HOUSE_CATEGORY_ID NUMBER(10,0)
5 HOUSE_TYPE NUMBER(2,0)
6 HOUSE_NO_ENG VARCHAR2(100 BYTE)
7 PLACE_ENG VARCHAR2(100 BYTE)
8 PLACE_SNL NVARCHAR2(100 CHAR)
9 LAND_MARK_ENG VARCHAR2(100 BYTE)
10 LAND_MARK_SNL NVARCHAR2(200 CHAR)
11 PIN_CODE NUMBER(7,0)
12 DURATION_OF_STAY NUMBER(2,0)
13 ADDRESS_ENG VARCHAR2(500 BYTE)
14 ADDRESS_SNL NVARCHAR2(250 CHAR)
15 STREET_NAME_ENG VARCHAR2(100 BYTE)
16 STREET_NAME_SNL NVARCHAR2(200 CHAR)
17 IS_RURAL VARCHAR2(1 BYTE)
18 LGD_CONFIG_ID NUMBER(10,0)
19 DISTRICT_ID NUMBER(4,0)
20 CITY_ID NUMBER(10,0)
21 WARD_ID NUMBER(15,0)
22 BLOCK_ID NUMBER(10,0)
23 GP_ID NUMBER(15,0)
24 VILLAGE_ID NUMBER(20,0)
25 ENROLL_ROWID NUMBER(10,0)

Page 6
 SPDPENROLL
26 CREATED_BY VARCHAR2(100 BYTE)
27 CREATED_DATE DATE
28 UPDATED_BY VARCHAR2(100 BYTE)
29 UPDATED_ON DATE

Table Name TBL_MEMBER_BANKS

Sl.No Column Name Data Type
1 MEMBER_BANK_ROWID NUMBER(10,0)
2 MEMBER_ROWID NUMBER(10,0)
3 BANK_ID NUMBER
4 BANK_BRANCH_ID NUMBER
5 ACCOUNT_NUMBER VARCHAR2(30 BYTE)
6 IFSC_CODE VARCHAR2(11 BYTE)
7 MICR_CODE VARCHAR2(15 BYTE)
8 MEMBER_ID NUMBER(11,0)
9 MEMER_HOF_ID NUMBER(10,0)
10 CREATED_BY VARCHAR2(100 BYTE)
11 CREATED_DATE DATE
12 UPDATED_BY VARCHAR2(100 BYTE)
13 UPDATED_ON DATE

Table Name TBL_MEMBER_DOCUMENTS

Sl.No Column Name Data Type
1 ID NUMBER(10,0)
2 MEMBERID NUMBER(12,0)
3 DOCID NUMBER
4 SUBDOCID NUMBER
5 FILENAME VARCHAR2(200 BYTE)
6 CREATED_ON DATE
7 OPERATION_TYPE VARCHAR2(15 BYTE)
8 CREATED_BY VARCHAR2(20 BYTE)
9 UPDATED_BY VARCHAR2(50 BYTE)
10 UPDATED_ON DATE
11 STATUS VARCHAR2(20 BYTE)
12 FAMILY_DOC_FLAG VARCHAR2(1 BYTE)
13 ENROLL_ACK_NO VARCHAR2(20 BYTE)

Table Name TBL_ENROLLMENT_MEMBERS_INFO

Sl.No Column Name Data Type
1 MEMBER_INFO_ROWID NUMBER(20,0)

Page 7
 SPDPENROLL
2 MEMBER_ROWID NUMBER(20,0)
3 MNAREGA_NO VARCHAR2(100 BYTE)
4 LABOURCARD_NO VARCHAR2(16 BYTE)
5 LABOURCARD_EXP_DATE DATE
6 VOTER_ID_NO VARCHAR2(20 BYTE)
7 PASSPORT_NO VARCHAR2(12 BYTE)
8 PAN_CARD VARCHAR2(10 BYTE)
9 DRIVING_LICENSE_NO VARCHAR2(20 BYTE)
10 DDO_NO VARCHAR2(50 BYTE)
11 GOVT_ID VARCHAR2(50 BYTE)
12 MEMBER_ID NUMBER(20,0)
13 BIRTH_CERTIFICATE_NO VARCHAR2(30 BYTE)
14 DATE_OF_DEATH DATE
15 DEATH_CERTIFICATE_NO VARCHAR2(100 BYTE)
16 MARRIAGE_CERTIFICATE_NO VARCHAR2(50 BYTE)
17 CASTE_CERTIFICATE_NO VARCHAR2(100 BYTE)
18 BONAFIED_CERT_NO VARCHAR2(50 BYTE)
19 IS_HIV NUMBER(1,0)
20 GREENCARD_NO VARCHAR2(50 BYTE)
21 CREATED_BY VARCHAR2(100 BYTE)
22 CREATED_DATE DATE
23 UPDATED_BY VARCHAR2(100 BYTE)
24 UPDATED_ON DATE
25 ADDRESS_ENG VARCHAR2(500 BYTE)
26 BLOCK_ID NUMBER(10,0)
27 CITY_ID NUMBER(10,0)
28 DISTRICT_ID NUMBER(4,0)
29 GP_ID NUMBER(15,0)
30 HOUSE_NO_ENG VARCHAR2(100 BYTE)
31 IS_RURAL VARCHAR2(1 BYTE)
32 LAND_MARK_ENG VARCHAR2(100 BYTE)
33 LGD_CONFIG_ID NUMBER(10,0)
34 PIN_CODE NUMBER(7,0)
35 PLACE_ENG VARCHAR2(100 BYTE)
36 STREET_NAME_ENG VARCHAR2(100 BYTE)
37 VILLAGE_ID NUMBER(20,0)
38 WARD_ID NUMBER(15,0)
39 IS_COMMON_ADDRESS VARCHAR2(1 BYTE)
40 DATE_OF_MARRIAGE DATE
41 ADOPTION_REG_NO VARCHAR2(100 BYTE)

Page 8
 SPDPENROLL
42 PLACE_OF_BIRTH VARCHAR2(100 BYTE)
43 HOSPITAL_ID NUMBER
44 STATE_ID NUMBER
45 IS_MEMBER_AGE VARCHAR2(20 BYTE)
46 HOSPITAL_UNIT_ID VARCHAR2(20 BYTE)
47 BIRTH_DISTRICT_ID NUMBER

Table Name TBL_ENROLLMENT_PENDING_COUNT

Sl.No Column Name Data Type
1 MEMBER_ID NUMBER
2 ENROLL_ROW_ID NUMBER
3 APPROVAL_LEVEL VARCHAR2(20 BYTE)
4 APPROVAL_STATUS_ID NUMBER
5 LGD_ID NUMBER
6 FLV_DATE DATE
7 FLV_BY VARCHAR2(255 BYTE)
8 SLV_DATE DATE
9 SLV_BY VARCHAR2(255 BYTE)
10 OPERATION_TYPE VARCHAR2(20 BYTE)
11 MEMBER_ACTIVE_STATUS VARCHAR2(20 BYTE)
12 CREATED_DATE DATE
13 HOF_NAME VARCHAR2(255 BYTE)
14 HOF_NAME_SNL VARCHAR2(255 BYTE)
15 HOF_AADHAAR_NO NUMBER
16 ENROLL_ACK_NO VARCHAR2(255 BYTE)
17 HOF_MOTHER_NAME_ENG VARCHAR2(255 BYTE)
18 HOF_MOTHER_NAME_SNL VARCHAR2(255 BYTE)
19 HOF_FATHER_NAME_ENG VARCHAR2(255 BYTE)
20 HOF_FATHER_NAME_SNL VARCHAR2(255 BYTE)
21 HOF_AGE NUMBER
22 HOF_MOBILE_NO NUMBER
23 HOF_GENDER_ENG VARCHAR2(50 BYTE)
24 HOF_GENDER_SNL VARCHAR2(50 BYTE)
25 PENDING_ID NUMBER(15,0)
26 TLV_DATE DATE
27 TLV_BY VARCHAR2(255 BYTE)

Table Name TBL_LGD_CONFIG_MAP

Page 9
 SPDPENROLL
Sl.No Column Name Data Type
1 LGD_CONFIG_ID NUMBER
2 VILG_WARD_ID NUMBER
3 VILG_WARD_CODE VARCHAR2(255 CHAR)
4 VILG_WARD_NAME VARCHAR2(1020 CHAR)
5 GP_ID NUMBER
6 GP_CODE VARCHAR2(40 BYTE)
7 GP_NAME VARCHAR2(1020 CHAR)
8 BLOCK_CITY_ID NUMBER
9 BLOCK_CITY_CODE VARCHAR2(50 CHAR)
10 BLOCK_CITY_NAME VARCHAR2(1020 CHAR)
11 ZONE_ID NUMBER
12 ZODE_CODE VARCHAR2(40 BYTE)
13 ZONE_NAME VARCHAR2(1020 BYTE)
14 DISTRICT_ID NUMBER
15 DISTRICT_CODE VARCHAR2(40 BYTE)
16 DISTRICT_NAME VARCHAR2(1020 CHAR)
17 STATE_ID NUMBER
18 STATE_CODE VARCHAR2(40 BYTE)
19 STATE_NAME VARCHAR2(40 BYTE)
20 IS_RURAL CHAR(1 BYTE)
21 IS_ACTIVE CHAR(1 BYTE)

Table Name TBL_MEMBER_ARTIST

Sl.No Column Name Data Type
1 MEMBER_ROWID NUMBER
2 ARTIST_TYPE NUMBER
3 ARTIST_DESCRIPTION VARCHAR2
4 IS_ACTIVE CHAR
5 CREATED_ON DATE
6 CREATED_BY VARCHAR2

Table Name TBL_MEMBER_PHOTO

Sl.No Column Name Data Type
1 MEMBER_PHOTOID NUMBER
2 PHOTO CLOB
3 IS_PHOTO_CHANGED VARCHAR2(1 BYTE)
4 IS_HOF NUMBER
5 MEMBER_ID NUMBER

Page 10
 SPDPENROLL

Table Name TBL_OTP_AUTH

Sl.No Column Name Data Type
1 ID NUMBER
2 MOBILE_NUM NUMBER
3 OTP NUMBER
4 TIME TIMESTAMP
5 VERIFICATION VARCHAR2

Table Name TBL_RE_VERIFICATION_STATUS

Sl.No Column Name Data Type
1 VERIFICATION_ID NUMBER
2 HOF_ID NUMBER
3 MEMBER_ID NUMBER
4 ELECTRICITY_BILL_NO VARCHAR2(1 BYTE)
5 GAS_AGENCY_CODE VARCHAR2(1 BYTE)
6 GAS_CON_NO VARCHAR2(1 BYTE)
7 HOLDING_TAX_NO VARCHAR2(1 BYTE)
8 KALIANO VARCHAR2(1 BYTE)
9 LANDLINE_NO VARCHAR2(1 BYTE)
10 MNAREGA_NO VARCHAR2(1 BYTE)
11 PMAYNO VARCHAR2(1 BYTE)
12 RATION_CARD_NUMBER VARCHAR2(1 BYTE)
13 RATION_CARD_TYPEID VARCHAR2(1 BYTE)
14 STATE_BPL_NO VARCHAR2(1 BYTE)
15 WATER_BILL_NO VARCHAR2(1 BYTE)
16 AADHAAR_NO VARCHAR2(1 BYTE)
17 AGE VARCHAR2(1 BYTE)
18 ANNUAL_INCOME VARCHAR2(1 BYTE)
19 BLOOD_GROUP VARCHAR2(1 BYTE)
20 CATEGROY_OF_FAMILYID VARCHAR2(1 BYTE)
21 DISABLED_CERITF_NO VARCHAR2(1 BYTE)
22 DISABLED_PERCENTAGE VARCHAR2(1 BYTE)
23 DISABLE_CATEGORY_TYPE VARCHAR2(1 BYTE)
24 DOB VARCHAR2(1 BYTE)
25 EDUCATION_LEVEL_ID VARCHAR2(1 BYTE)
26 EMAIL VARCHAR2(1 BYTE)
27 FATHER_NAME_ENG VARCHAR2(1 BYTE)
28 FIRST_NAME_ENG VARCHAR2(1 BYTE)
29 GARDIAN_NAME_ENG VARCHAR2(1 BYTE)

Page 11
 SPDPENROLL
30 GENDER_ID VARCHAR2(1 BYTE)
31 IS_DISABLE VARCHAR2(1 BYTE)
32 IS_MINORITY VARCHAR2(1 BYTE)
33 IS_ORPHAN VARCHAR2(1 BYTE)
34 KRUSHAKODISHAFARMER_ID VARCHAR2(1 BYTE)
35 LANDOWNER_CATEGORY_ID VARCHAR2(1 BYTE)
36 MARITAL_STAUS_ID VARCHAR2(1 BYTE)
37 MOBILE_NO VARCHAR2(1 BYTE)
38 MOTHER_NAME_ENG VARCHAR2(1 BYTE)
39 OCCUPATION_ID VARCHAR2(1 BYTE)
40 RELATION_WITH_HOF VARCHAR2(1 BYTE)
41 RELIGION VARCHAR2(1 BYTE)
42 SOCIAL_SECURITY_PPONO VARCHAR2(1 BYTE)
43 SPOUSE_NAME_ENG VARCHAR2(1 BYTE)
44 DRIVING_LICENSE_NO VARCHAR2(1 BYTE)
45 LABOURCARD_EXP_DATE VARCHAR2(1 BYTE)
46 LABOURCARD_NO VARCHAR2(1 BYTE)
47 PAN_CARD VARCHAR2(1 BYTE)
48 PASSPORT_NO VARCHAR2(1 BYTE)
49 VOTER_ID_NO VARCHAR2(1 BYTE)
50 ADDRESS_ENG VARCHAR2(1 BYTE)
51 BLOCK_ID VARCHAR2(1 BYTE)
52 CITY_ID VARCHAR2(1 BYTE)
53 DISTRICT_ID VARCHAR2(1 BYTE)
54 DURATION_OF_STAY VARCHAR2(1 BYTE)
55 GP_ID VARCHAR2(1 BYTE)
56 HOUSE_CATEGORY_ID VARCHAR2(1 BYTE)
57 HOUSE_NO_ENG VARCHAR2(1 BYTE)
58 IS_RURAL VARCHAR2(1 BYTE)
59 LAND_MARK_ENG VARCHAR2(1 BYTE)
60 PIN_CODE VARCHAR2(1 BYTE)
61 PLACE_ENG VARCHAR2(1 BYTE)
62 STREET_NAME_ENG VARCHAR2(1 BYTE)
63 VILLAGE_ID VARCHAR2(1 BYTE)
64 WARD_ID VARCHAR2(1 BYTE)
65 ARTIST_TYPE VARCHAR2(1 BYTE)
66 ARTIST_DESCRIPTION VARCHAR2(1 BYTE)
67 ACCOUNT_NUMBER VARCHAR2(1 BYTE)
68 BANK_BRANCH_ID VARCHAR2(1 BYTE)
69 BANK_ID VARCHAR2(1 BYTE)

Page 12
 SPDPENROLL
70 IFSC_CODE VARCHAR2(1 BYTE)
71 MICR_CODE VARCHAR2(1 BYTE)
72 PROFILE_PHOTO VARCHAR2(1 BYTE)
73 FARMER_ID VARCHAR2(1 BYTE)
74 CREATED_ON DATE
75 UPDATED_ON DATE
76 BIRTH_CERTIFICATE_NO VARCHAR2(1 BYTE)
77 B_STATE_ID VARCHAR2(1 BYTE)
78 BIRTH_DISTRICT_ID VARCHAR2(1 BYTE)
79 PLACE_OF_BIRTH VARCHAR2(1 BYTE)
80 HOSPITAL_ID VARCHAR2(1 BYTE)
81 HOSPITAL_UNIT_CODE VARCHAR2(1 BYTE)
82 IS_MEMBER_AGE VARCHAR2(1 BYTE)

Table Name TBL_SPDP_AUDIT_TRAIL

Sl.No Column Name Data Type
1 ENROLL_ACK_NO VARCHAR2
2 MEMBER_ID NUMBER
3 SR_NO NUMBER
4 STATUS_DESCRIPTION VARCHAR2
5 STATUS_DT DATE
6 STATUS_BY VARCHAR2
7 MODULE_NAME VARCHAR2
8 OPERATION_TYPE VARCHAR2
9 TRAN_ID VARCHAR2

Table Name TBL_SPDP_OPERATION

Sl.No Column Name Data Type
1 OPERATION_SLNO NUMBER
2 ENROLL_ACK_NO VARCHAR2
3 MEMBER_ID VARCHAR2

Page 13
 SPDPENROLL
4 OPERATION_TYPE VARCHAR2
5 OPERATION_DATE DATE
6 OPERATION_BY VARCHAR2

Table Name TBL_TRANSFER_FAMILYDTL

Sl.No Column Name Data Type
1 FROM_ENROLL_ACK_NO VARCHAR2
2 TO_ENROLL_ACK_NO VARCHAR2
3 MEMBER_ID NUMBER
4 TOKENNO VARCHAR2
5 TRANDT DATE
6 CUG_CODE VARCHAR2
7 REASON_ID NUMBER
8 S_ID VARCHAR2
9 KIOSKID VARCHAR2
10 IS_HOF CHAR
11 RELATION_WITH_HOF NUMBER
12 CREATED_BY VARCHAR2
13 CREATED_DATE DATE
14 IS_FINAL_TRANSFER NUMBER
15 FINAL_TRANSFER_BY VARCHAR2
16 FINAL_TRANSFER_DT DATE
17 FLV_STATUS NUMBER
18 FLV_DT DATE
19 FLV_BY VARCHAR2
20 SLV_STATUS NUMBER
21 SLV_DT DATE
22 SLV_BY VARCHAR2
23 ACTION_REMARKS VARCHAR2

Table Name WIP_ENROLL_HOF

Sl.No Column Name Data Type
1 HEAD_OF_FAMILY_ID NUMBER
2 LANDLINE_NUMBER NUMBER
3 ELECTRICITYBILL_NUMBER VARCHAR2
4 WATER_CONSUMTION_UNITBILL VARCHAR2
5 GAS_CONNECTION_NUMBER VARCHAR2
6 TOTAL_FAMILY_MEMBER NUMBER

Page 14
 SPDPENROLL
7 RATION_CARD_NUMBER VARCHAR2
8 STATE_BPL_NO VARCHAR2
9 WIP_FSS VARCHAR2
10 CREATED_BY VARCHAR2
11 CREATED_ON DATE
12 KALIANO VARCHAR2
13 PMAYNO VARCHAR2
14 HOLDINGTAXNO VARCHAR2
15 COMPLETED_PAGE_NO NUMBER
16 MNAREGA_NO VARCHAR2
17 HOUSE_HOLD_ID NUMBER
18 UPDATED_BY VARCHAR2
19 UPDATED_ON DATE

Table Name WIP_ENROLLMENT_MEMBER

Sl.No Column Name Data Type
1 WIP_MEMBER_ROWID NUMBER
2 HEAD_OF_FAMILY_ID NUMBER
3 AADHAAR_NO NUMBER(15,0)
4 ADDHAR_ACK_NO VARCHAR2(30 BYTE)
5 IS_MEMBER_ORPHAN VARCHAR2(1 BYTE)
6 GARDIAN_NAME VARCHAR2(200 BYTE)
7 GARDIAN_SNL VARCHAR2(500 BYTE)
8 FIRST_NAME_ENG VARCHAR2(100 BYTE)
9 MIDDLE_NAME_ENG VARCHAR2(100 BYTE)
10 LAST_NAME_ENG VARCHAR2(100 BYTE)
11 FIRST_NAME_SNL NVARCHAR2(500 CHAR)
12 MIDDLE_NAME_SNL NVARCHAR2(500 CHAR)
13 LAST_NAME_SNL NVARCHAR2(500 CHAR)
14 GENDER NUMBER(4,0)
15 DOB DATE
16 AGE NUMBER(5,0)
17 IS_MINORITY VARCHAR2(1 BYTE)
18 FATHER_NAME_ENG VARCHAR2(100 BYTE)
19 FATHER_NAME_SNL NVARCHAR2(500 CHAR)
20 MOTHER_NAME_ENG VARCHAR2(100 BYTE)
21 MOTHER_NAME_SNL NVARCHAR2(500 CHAR)
22 CATEGROY_OF_FAMILY NUMBER(2,0)
23 CASTE NUMBER(4,0)
24 SPECIAL_ABLED_CATE_TYPE NUMBER(2,0)

Page 15
 SPDPENROLL
25 RELATION_WITH_HOF NUMBER(2,0)
26 MARITAL_STAUS NUMBER(2,0)
27 RESIDENT_CATEGORY NUMBER(2,0)
28 MOBILE_NO NUMBER(10,0)
29 EMAIL VARCHAR2(100 BYTE)
30 EDUCATION_LEVEL NUMBER(10,0)
31 OCCUPATION NUMBER(10,0)
32 ANNUAL_INCOME NUMBER(12,0)
33 PAN_CARD_NO VARCHAR2(10 BYTE)
34 DRIVING_LICENSE_NO VARCHAR2(20 BYTE)
35 PASSPORT_NO VARCHAR2(12 BYTE)
36 VOTER_ID_NO VARCHAR2(20 BYTE)
37 EMPLOYEE_REIGSTRION_NO VARCHAR2(30 BYTE)
38 LABOUR_CARD_NO VARCHAR2(16 BYTE)
39 IS_HOF NUMBER(1,0)
40 SOCIAL_SECURITY_PPONO VARCHAR2(30 BYTE)
41 LANDOWNER_CATEGORY_ID NUMBER(2,0)
42 ANNUAL_INCOME_CERTF_NO VARCHAR2(30 BYTE)
43 GOVT_ID VARCHAR2(30 BYTE)
44 DDO_NO VARCHAR2(30 BYTE)
45 WIP_FSS VARCHAR2(1 BYTE)
46 SPOUSE_NAME_ENG VARCHAR2(200 BYTE)
47 SPOUSE_NAME_SNL NVARCHAR2(400 CHAR)
48 DISABLED_CERITF_NO VARCHAR2(40 BYTE)
49 DISABLED_PERCENTAGE NUMBER
50 DISABLE_CATEGORY_TYPE VARCHAR2(200 BYTE)
51 REAL_INCOME NUMBER
52 DOC_UPLOAD_STATUS VARCHAR2(1 BYTE)
53 SIPF_NO VARCHAR2(50 BYTE)
54 BLOOD_GROUP NUMBER(3,0)
55 RELIGION NUMBER(3,0)
56 FARMER_ID VARCHAR2(20 BYTE)
57 AADHAAR_REFERENCE_NO NUMBER(20,0)
58 SPDP_MEMBER_ID NUMBER
59 BIRTH_CERTIFICATE_NO VARCHAR2(30 BYTE)
60 DATE_OF_DEATH DATE
61 DEATH_CERTIFICATE_NO VARCHAR2(100 BYTE)
62 MARRIAGE_CERTIFICATE_NO VARCHAR2(50 BYTE)
63 CASTE_CERTIFICATE_NO VARCHAR2(100 BYTE)
64 BONAFIED_CERT_NO VARCHAR2(50 BYTE)

Page 16
 SPDPENROLL
65 IS_HIV NUMBER(1,0)
66 GREENCARD_NO VARCHAR2(50 BYTE)
67 CREATED_BY VARCHAR2(100 BYTE)
68 CREATED_ON DATE
69 UPDATED_BY VARCHAR2(100 BYTE)
70 UPDATED_ON DATE
71 KRUSHAKODISHAFARMER_ID VARCHAR2(20 BYTE)
72 ADDRESS_ENG VARCHAR2(500 BYTE)
73 BLOCK_ID NUMBER(10,0)
74 CITY_ID NUMBER(10,0)
75 DISTRICT_ID VARCHAR2(4 BYTE)
76 GP_ID NUMBER(15,0)
77 HOUSE_NO_ENG VARCHAR2(100 BYTE)
78 IS_RURAL VARCHAR2(1 BYTE)
79 LAND_MARK_ENG VARCHAR2(100 BYTE)
80 LGD_CONFIG_ID NUMBER(10,0)
81 PIN_CODE NUMBER(7,0)
82 PLACE_ENG VARCHAR2(100 BYTE)
83 STREET_NAME_ENG VARCHAR2(100 BYTE)
84 VILLAGE_ID NUMBER(20,0)
85 WARD_ID NUMBER(15,0)
86 IS_COMMON_ADDRESS VARCHAR2(1 BYTE)
87 DATE_OF_MARRIAGE DATE
88 ADOPTION_REG_NO VARCHAR2(100 BYTE)
89 PLACE_OF_BIRTH VARCHAR2(100 BYTE)
90 HOSPITAL_ID NUMBER
91 STATE_ID NUMBER
92 ISMEMBERAGE VARCHAR2(20 BYTE)
93 HOSPITAL_UNITID VARCHAR2(20 BYTE)
94 BIRTHDISTRICTID NUMBER
95 KYCUPDATE VARCHAR2(20 BYTE)

Table Name TBL_DOCUMENT_VERIFICATION

Sl.No Column Name Data Type
1 VERIFICATION_ID NUMBER
2 HOF_ID NUMBER
3 MEMBER_ID NUMBER
4 IS_VERIFIED_AADHAR VARCHAR2(1 BYTE)
5 IS_VERIFIED_DOB VARCHAR2(1 BYTE)

Page 17
 SPDPENROLL
6 IS_VERIFY_GENDER VARCHAR2(1 BYTE)
7 IS_VERIFY_AGE VARCHAR2(1 BYTE)
8 IS_VERIFIED_SPECIAL_CAT VARCHAR2(1 BYTE)
9 IS_VERIFIED_EDUCATION VARCHAR2(1 BYTE)
10 IS_VERIFIED_OCCUPATION VARCHAR2(1 BYTE)
11 IS_VERIFIED_ANNUAL_INCOME VARCHAR2(1 BYTE)
12 IS_VERIFIED_BANK VARCHAR2(1 BYTE)
13 IS_VERIFIED_BRANCH VARCHAR2(1 BYTE)
14 IS_VERIFIED_BANK_ACCOUNT VARCHAR2(1 BYTE)
15 IS_VERIFIED_PAN VARCHAR2(1 BYTE)
16 IS_VERIFIED_DL VARCHAR2(1 BYTE)
17 IS_VERIFIED_PASSPORT VARCHAR2(1 BYTE)
18 IS_VERIFIED_NPR VARCHAR2(1 BYTE)
19 IS_VERIFIED_LABOURCARD VARCHAR2(1 BYTE)
20 IS_VERIFIED_GOVT_ID VARCHAR2(1 BYTE)
21 IS_VERIFIED_PPO VARCHAR2(1 BYTE)
22 IS_VERIFIED_VOTER VARCHAR2(1 BYTE)
23 IS_VERIFIED_MOBILE VARCHAR2(1 BYTE)
24 IS_VERIFIED_MANREGA VARCHAR2(1 BYTE)
25 IS_VERIFIED_PHOTO VARCHAR2(1 BYTE)
26 IS_VERIFIED_DISTRICT VARCHAR2(1 BYTE)
27 IS_VERIFIED_BLOCK VARCHAR2(1 BYTE)
28 IS_VERIFIED_GP VARCHAR2(1 BYTE)
29 IS_VERIFIED_VILLAGE VARCHAR2(1 BYTE)
30 IS_VERIFIED_CITY VARCHAR2(1 BYTE)
31 IS_VERIFIED_WARD VARCHAR2(1 BYTE)
32 IS_VERIFIED_HOUSE VARCHAR2(1 BYTE)
33 IS_VERIFIED_PINCODE VARCHAR2(1 BYTE)
34 IS_VERIFIED_ADDRESS VARCHAR2(1 BYTE)
35 IS_VERIFIED_LAST_NAME VARCHAR2(1 BYTE)
36 IS_VERIFIED_MINORITY VARCHAR2(1 BYTE)
37 IS_VERIFIED_CASTE VARCHAR2(1 BYTE)
38 IS_VERIFED_LANDOWNER VARCHAR2(1 BYTE)
39 IS_VERIFICATION_LANDTYPE VARCHAR2(1 BYTE)
40 ISVERIFIED_DISTRICT VARCHAR2(1 BYTE)
41 IS_VERIFIED_CATEGORY_HOUSE VARCHAR2(1 BYTE)
42 IS_VERIFIED_CONDITION_HOUSE VARCHAR2(1 BYTE)
43 IS_VERIFIED_STREET VARCHAR2(1 BYTE)
44 IS_VERIFIED_LANDMARK VARCHAR2(1 BYTE)
45 IS_VERIFIED_PLACE VARCHAR2(1 BYTE)

Page 18
 SPDPENROLL
46 IS_VERIFIED_MARITIAL_STATUS VARCHAR2(1 BYTE)
47 IS_VERIFIED_RATIONCARD_TYPE VARCHAR2(1 BYTE)
48 IS_VERIFIED_RATIONCARD_NUMBER VARCHAR2(1 BYTE)
49 IS_VERIFIED_BILL_NO VARCHAR2(1 BYTE)
50 IS_VERIFIED_WATER_BILLNO VARCHAR2(1 BYTE)
51 IS_VERIFIED_GAS_AGENCY VARCHAR2(1 BYTE)
52 IS_VERIFIED_GAS_CONN VARCHAR2(1 BYTE)
53 IS_VERIFIED_BPL_NO VARCHAR2(1 BYTE)
54 IS_VERIFIED_TOT_FAMILY VARCHAR2(1 BYTE)
55 IS_VERIFIED_LAND VARCHAR2(1 BYTE)
56 IS_VERIFIED_BANKDOC VARCHAR2(1 BYTE)
57 IS_VERIFIED_AADHAR_DOC VARCHAR2(1 BYTE)
58 IS_VERIFIED_INCOME_DOC VARCHAR2(1 BYTE)
59 IS_VERIFIED_BIRTH_DOC VARCHAR2(1 BYTE)
60 IS_VERIFIED_CATEGORY VARCHAR2(1 BYTE)
61 IS_VERIFIED_LAND_OWNER VARCHAR2(1 BYTE)
62 IS_VERIFIED_LAND_TYPE VARCHAR2(1 BYTE)
63 IS_VERIFIED_RESIDENTAL VARCHAR2(1 BYTE)
64 IS_VERIFIED_FIRST_NAME VARCHAR2(1 BYTE)
65 IS_VERIFIED_MOTHER VARCHAR2(1 BYTE)
66 IS_VERIFIED_FATHER VARCHAR2(1 BYTE)
67 IS_VERIFIED_RELETION VARCHAR2(1 BYTE)
68 IS_VERIFIED_HOF_NAME VARCHAR2(1 BYTE)
69 IS_VERIFIED_ORPHAN VARCHAR2(1 BYTE)
70 IS_VERIFIED_EMAIL VARCHAR2(1 BYTE)
71 IS_VERIFIED_IFSC VARCHAR2(1 BYTE)
72 IS_VERIFIED_SPOUSE_ENG VARCHAR2(1 BYTE)
73 IS_VERIFIED_SPOUSE_HINDI VARCHAR2(1 BYTE)
74 IS_VERIFIED_DDO_NO VARCHAR2(1 BYTE)
75 IS_VERIFIED_SPL_ABLE_CATEGORY VARCHAR2(1 BYTE)
76 IS_VERIFIED_LABOUR_EXP_DT VARCHAR2(1 BYTE)
77 IS_VERIFIED_MIDDLE_NAME VARCHAR2(1 BYTE)
78 IS_VERIFIED_FIRST_NAME_HINDI VARCHAR2(1 BYTE)
79 IS_VERIFIED_MIDDLE_NAME_HINDI VARCHAR2(1 BYTE)
80 IS_VERIFIED_LAST_NAME_HINDI VARCHAR2(1 BYTE)
81 IS_VERIFIED_HOUSE_NO_HINDI VARCHAR2(1 BYTE)
82 IS_VERIFIED_STREET_HINDI VARCHAR2(1 BYTE)
83 IS_VERIFIED_PLACE_HINDI VARCHAR2(1 BYTE)
84 IS_VERIFIED_ADDRESS_ENG VARCHAR2(1 BYTE)
85 IS_VERIFIED_ADDRESS_HINDI VARCHAR2(1 BYTE)

Page 19
 SPDPENROLL
86 IS_VERIFIED_LANDMARK_HINDI VARCHAR2(1 BYTE)
87 IS_VERIFIED_DURATION_STAY VARCHAR2(1 BYTE)
88 IS_VERIFIED_RESIDENT_ADDRESS VARCHAR2(1 BYTE)
89 IS_VERIFIED_FATHER_HINDI VARCHAR2(1 BYTE)
90 IS_VERIFIED_MOTHER_HINDI VARCHAR2(1 BYTE)
91 IS_VERIFIED_RATIONCARD_DT VARCHAR2(1 BYTE)
92 IS_VERIFIED_LABOUR_CARD_DT VARCHAR2(1 BYTE)
93 IS_VERIFIED_REAL_INCOME VARCHAR2(1 BYTE)
94 IS_VERIFIED_GARDIAN_ENG VARCHAR2(1 BYTE)
95 IS_VERIFIED_GARDIAN_HND VARCHAR2(1 BYTE)
96 IS_VERIFIED_TELEPHONE_NO VARCHAR2(1 BYTE)
97 IS_VERIFIED_STATE VARCHAR2(1 BYTE)
98 IS_VERIFIED_OTHER_STATE VARCHAR2(1 BYTE)
99 IS_VERIFIED_BELONGS_TO_RURAL VARCHAR2(1 BYTE)
100 IS_VERIFIED_CASTECERT_NO VARCHAR2(20 BYTE)
101 IS_VERIFIED_BONAFIED VARCHAR2(20 BYTE)
102 IS_VERIFIED_GREEN_CARD VARCHAR2(20 BYTE)
103 IS_VERIFIED_HIV VARCHAR2(20 BYTE)
104 IS_VERIFIED_PERCENTAGE VARCHAR2(20 BYTE)
105 IS_VERIFIED_MINORITY_TYPE VARCHAR2(20 BYTE)
106 TBL_DOCUMENT_VERIFICATION VARCHAR2(20 BYTE)
107 IS_VERIFIED_TYPE_OF_DISABILITY VARCHAR2(20 BYTE)
108 IS_VERIFIED_CERTIFICATE VARCHAR2(20 BYTE)
109 IS_VERIFIED_KALIA_NO VARCHAR2(1 BYTE)
110 IS_VERIFIED_PMAY_NO VARCHAR2(1 BYTE)
111 IS_VERIFIED_HOLDING_TAX_NO VARCHAR2(1 BYTE)
112 IS_VERIFIED_KRUSHAK_ODISHA VARCHAR2(1 BYTE)
113 IS_VERIFIED_BLOOD_GROUP VARCHAR2(1 BYTE)
114 IS_VERIFIED_RELIGION VARCHAR2(1 BYTE)
115 IS_VERIFIED_FARMER_ID VARCHAR2(1 BYTE)
116 FARMER_ID VARCHAR2(1 BYTE)
117 VERIFYBIRTHCERTIFICATENO VARCHAR2(1 BYTE)
118 VERIFYPLACEOFBIRTH VARCHAR2(1 BYTE)
119 VERIFYBORNSTATE VARCHAR2(1 BYTE)
120 VERIFYHOSPITALNAME VARCHAR2(1 BYTE)
121 VERIFYHOSPITALUNITNAME VARCHAR2(1 BYTE)
122 VERIFYBORNDISTRICT VARCHAR2(1 BYTE)
123 VERIFYMARRIAGECERTIFICATENO VARCHAR2(1 BYTE)
124 VERIFYDATEOFMARRIAGE VARCHAR2(1 BYTE)
125 VERIFYREASONOFADDING VARCHAR2(1 BYTE)

Page 20
 SPDPENROLL

Table Name ERROR_LOG_SPDP

Sl.No Column Name Data Type
1 ERROR_ROWID NUMBER
2 ORA_ERROR_NUMBER NUMBER(10,0)
3 ORA_ERROR_MESG VARCHAR2(2000 BYTE)
4 PROGRAM_NAME VARCHAR2(32 BYTE)
5 PROGRAM_BLOCK VARCHAR2(100 BYTE)
6 ERROR_DATE TIMESTAMP(6)

Table Name WIP_MEMBER_BANKS

Sl.No Column Name Data Type
1 WIP_MEM_BANK_ROWID NUMBER
2 HEAD_OF_FAMILY_ID NUMBER(10,0)
3 BANK_ID NUMBER
4 BANK_BRANCH_ID NUMBER
5 ACCOUNT_NUMBER VARCHAR2(30 BYTE)
6 CREATED_BY VARCHAR2(20 BYTE)
7 CREATED_ON DATE
8 IS_HOF NUMBER(1,0)
9 IFSCCODE VARCHAR2(11 BYTE)
10 MICR_CODE VARCHAR2(15 BYTE)
11 UPDATED_BY VARCHAR2(100 BYTE)
12 UPDATED_ON DATE
13 SPDP_MEMBER_ID NUMBER(11,0)
14 BANK_ROWID NUMBER(10,0)
15 WIP_FSS VARCHAR2(1 BYTE)

Table Name TBL_UPLOAD_DOC_VERIFICATION

Page 21
 SPDPENROLL
Sl.No Column Name Data Type
1 UPLOAD_DOC_ID NUMBER
2 HOF_ID NUMBER
3 MEMBER_ID NUMBER
4 ENROLL_ACK_NO VARCHAR2
5 FILE_REF_ID VARCHAR2
6 DOC_ID NUMBER
7 SUB_CAT_ID NUMBER
8 IS_VARIFIED VARCHAR2
9 VERIFICATION_LEVEL VARCHAR2
10 ACTIVE_STATUS NUMBER
11 VERIFIED_BY VARCHAR2
12 VERIFIED_DATE DATE

Table Name TBL_FLV_STATUS

Sl.No Column Name Data Type
1 TASK_DETAILS VARCHAR2(100 BYTE)
3 ENROLLMENT_ID VARCHAR2(16 BYTE)
4 APP_STATUS VARCHAR2(10 BYTE)
5 APP_DATE DATE
6 DISTRICT VARCHAR2(100 BYTE)
7 CITY VARCHAR2(100 BYTE)
8 GRAM_PANCHAYAT VARCHAR2(100 BYTE)
9 ZONE_ID VARCHAR2(100 BYTE)
10 IS_RURAL VARCHAR2(10 BYTE)
11 CREATED_ON DATE
12 DISTRICT_ID NUMBER
13 CITY_ID NUMBER
14 BLOCK_ID NUMBER
15 GP_ID NUMBER
16 WARD_ID NUMBER
17 VILLAGE_ID NUMBER

Page 22
 SPDPENROLL

Table Design
Module Name ENROLLEMENT

Length Nullable Constraint Default Value

(10,0) N PK NULL
15 N NULL
(14,0) Y NULL
15 Y NULL
16 Y NULL
10 Y NULL
1 Y NULL
11 Y NULL
15 Y NULL
(10,0) Y NULL
50 Y NULL
Y SYSDATE
4 Y 'N'
Y NULL
Y 0
10 Y NULL
40 Y NULL
16 Y NULL
26 Y NULL
Y NULL
100 Y NULL
Y SYSDATE
20 Y NULL
20 Y NULL
20 Y NULL
20 Y NULL
1 Y NULL

Length Nullable Constraint Default Value

(20,0) N PK NULL
(20,0) Y FK NULL
(30,0) Y UK NULL

Page 23
 SPDPENROLL
(15,0) Y UK NULL
30 Y NULL
1 Y NULL
200 Y NULL
250 Y NULL
100 Y NULL
100 Y NULL
100 Y NULL
400 Y NULL
400 Y NULL
400 Y NULL
(1,0) Y NULL
Y NULL
(5,0) Y NULL
1 Y NULL
(1,0) Y NULL
100 Y NULL
400 Y NULL
100 Y NULL
400 Y NULL
(1,0) Y NULL
(3,0) Y NULL
(1,0) Y NULL
(2,0) Y NULL
(1,0) Y NULL
(1,0) Y NULL
(10,0) Y NULL
100 Y NULL
(3,0) Y NULL
(3,0) Y NULL
(12,0) Y NULL
(2,0) Y NULL
(1,0) Y NULL
15 Y NULL
30 Y NULL
30 Y NULL
4 Y NULL
(1,0) Y NULL
(1,0) Y NULL
40 Y NULL

Page 24
 SPDPENROLL
Y NULL
200 Y NULL
20 Y NULL
Y SYSDATE
20 Y NULL
Y NULL
20 Y NULL
Y NULL
2000 Y NULL
2000 Y NULL
1 Y NULL
200 Y NULL
400 Y NULL
5 Y NULL
Y NULL
Y NULL
(1,0) Y NULL
4000 Y NULL
5 Y NULL
Y NULL
200 Y NULL
500 Y NULL
15 Y NULL
50 Y NULL
16 Y NULL
1 Y 'N'
(1,0) Y NULL
(11,0) Y NULL
(3,0) Y NULL
(3,0) Y NULL
12 Y NULL
(30,0) Y NULL
Y NULL
1 Y NULL
100 Y NULL
Y SYSDATE
20 Y NULL
(3,0) Y NULL
2000 Y NULL
20 Y NULL

Page 25
 SPDPENROLL
5 Y NULL
20 Y NULL
Y NULL
2000 Y NULL
20 Y NULL
Y NULL
200 Y NULL

Length Nullable Constraint Default Value

(10,0) N PK NULL
15 Y NULL
(2,0) Y NULL
(10,0) Y NULL
(2,0) Y NULL
100 Y NULL
100 Y NULL
100 Y NULL
100 Y NULL
200 Y NULL
(7,0) Y NULL
(2,0) Y NULL
500 Y NULL
250 Y NULL
100 Y NULL
200 Y NULL
1 Y NULL
(10,0) Y NULL
(4,0) Y NULL
(10,0) Y NULL
(15,0) Y NULL
(10,0) Y NULL
(15,0) Y NULL
(20,0) Y NULL
(10,0) Y FK NULL

Page 26
 SPDPENROLL
100 Y NULL
Y SYSDATE
100 Y NULL
Y SYSDATE

Length Nullable Constraint type Default Value

(10,0) N PK
(10,0) N FK
Y
Y
30 Y
11 Y
15 Y
(11,0) Y
(10,0) Y
100 Y
Y
100 Y
Y

Length Nullable Constraint type Default Value

(10,0) No PK NULL
(12,0) Yes CHECK NULL
No CHECK NULL
No CHECK NULL
200 Yes NULL
No CHECK SYSDATE
15 Yes NULL
20 Yes NULL
50 Yes NULL
Yes NULL
20 Yes NULL
1 Yes NULL
20 Yes NULL

Length Nullable Constraint type Default Value

(20,0) N Primary Key NULL

Page 27
 SPDPENROLL
(20,0) Y Foreign Key NULL
100 Y NULL
16 Y NULL
Y NULL
20 Y Unique key NULL
12 Y Unique key NULL
10 Y Unique key NULL
20 Y Unique key NULL
50 Y NULL
50 Y Unique key NULL
(20,0) Y NULL
30 Y NULL
Y NULL
100 Y NULL
50 Y NULL
100 Y NULL
50 Y NULL
(1,0) Y NULL
50 Y NULL
100 Y NULL
Y SYSDATE
100 Y NULL
Y SYSDATE
500 Y NULL
(10,0) Y NULL
(10,0) Y NULL
(4,0) Y NULL
(15,0) Y NULL
100 Y NULL
1 Y NULL
100 Y NULL
(10,0) Y NULL
(7,0) Y NULL
100 Y NULL
100 Y NULL
(20,0) Y NULL
(15,0) Y NULL
1 Y 'Y'
Y NULL
100 Y NULL

Page 28
 SPDPENROLL
100 Y NULL
Y NULL
Y NULL
20 Y NULL
20 Y NULL
Y NULL

Length Nullable Constraint type Default Value

Yes NULL
Yes NULL
20 Yes NULL
Yes NULL
Yes NULL
Yes NULL
255 Yes NULL
Yes NULL
255 Yes NULL
20 Yes NULL
20 Yes NULL
Yes NULL
255 Yes NULL
255 Yes NULL
Yes NULL
255 Yes NULL
255 Yes NULL
255 Yes NULL
255 Yes NULL
255 Yes NULL
Yes NULL
Yes NULL
50 Yes NULL
50 Yes NULL
(15,0) Yes NULL
YES NULL
255 YES NULL

Page 29
 SPDPENROLL
Length Nullable Constraint type Default Value
No Primary_Key
Yes Unique Key
255 Yes
1020 Yes
Yes
40 Yes
1020 Yes
Yes
50 Yes
1020 Yes
Yes
40 Yes
1020 Yes
Yes
40 Yes
1020 Yes
Yes
40 Yes
40 Yes
1 Yes Unique Key
1 Yes Y

Length Nullable Constraint type Default Value

Yes
Yes
2000 Yes
1 Yes 'Y'
Yes SYSDATE
100 Yes

Length Nullable Constraint type Default Value

No Check
Yes
1 Yes
(1,0) Yes
(11,0) Yes

Page 30
 SPDPENROLL

Length Nullable Constraint type Default Value

(12,0) No Primary_Key
(10,0) No Check
(10,0) No Check
6 No Check
10 Yes

Length Nullable Constraint type Default Value

Yes NULL
Yes NULL
Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'

Page 31
 SPDPENROLL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'

Page 32
 SPDPENROLL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes NULL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes NULL

Length Nullable Constraint type Default Value

50 Yes
Yes
No Check
250 Yes
Yes
100 Yes
100 Yes
10 Yes
20 Yes

Length Nullable Constraint type Default Value

Yes
50 Yes
50 Yes

Page 33
 SPDPENROLL
600 Yes
Yes
100 Yes

Length Nullable Constraint type Default Value

50 Yes
50 Yes
Yes
5000 Yes
Yes
50 Yes
Yes
50 Yes
50 Yes
1 Yes
(3,0) Yes
50 Yes
Yes
Yes
100 Yes
Yes
(10,0) Yes
Yes
50 Yes
(10,0) Yes
Yes
50 Yes
500 Yes

Length Nullable Constraint type Default Value

(10,0) No Primary_Key
(14,0) Yes
15 Yes
16 Yes
10 Yes
(10,0) Yes

Page 34
 SPDPENROLL
11 Yes
15 Yes
1 Yes
20 Yes
Yes
10 Yes
40 Yes
16 Yes
Yes
26 Yes
Yes
100 Yes
Yes

Length Nullable Constraint Default Value

No Primary_Key
Yes Foreign_Key
Yes Unique key
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

Page 35
 SPDPENROLL
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes N
Yes
Yes
Yes
Yes
Yes
Yes
Yes N
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

Page 36
 SPDPENROLL
Yes
Yes
Yes
Yes SYSDATE
Yes
Yes SYSDATE
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes Y
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes

Length Nullable Constraint Default Value

No PK NULL
Yes NULL
Yes NULL
1 Yes 'N'
1 Yes 'N'

Page 37
 SPDPENROLL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'

Page 38
 SPDPENROLL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'

Page 39
 SPDPENROLL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
20 Yes NULL
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes 'N'
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL
1 Yes NULL

Page 40
 SPDPENROLL

Length Nullable Constraint Default Value

Yes NULL
(10,0) Yes NULL
2000 Yes NULL
32 Yes NULL
100 Yes NULL
6 Yes NULL

Length Nullable Constraint Default Value

No CK , PK NULL
(10,0) Yes FK NULL
Yes NULL
Yes NULL
30 Yes NULL
20 Yes NULL
Yes SYSDATE
(1,0) Yes NULL
11 Yes NULL
15 Yes NULL
100 Yes NULL
Yes SYSDATE
(11,0) Yes NULL
(10,0) Yes NULL
1 Yes 'N'

Page 41
 SPDPENROLL
Length Nullable Constraint Default Value
No PK NULL
Yes NULL
Yes NULL
(15 BYTE) Yes NULL
(100 BYTE) Yes NULL
(10,0) Yes NULL
(10,0) Yes NULL
(1 BYTE) Yes 'N'
(2 BYTE) Yes NULL
(1,0) Yes NULL
(20 BYTE) Yes NULL
Yes

Length Nullable Constraint Default Value

100 Yes NULL
16 Yes NULL
10 Yes NULL
Yes NULL
100 Yes NULL
100 Yes NULL
100 Yes NULL
100 Yes NULL
10 Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
NULL

Page 42
 SPDPENROLL

Description Indexes
TBL_ENROLLMENT_PK TBL_ENROLLMENT_PK

Description Indexes
TBL_ENROLLMENT_MEMBERS_PK TBL_ENROLLMENT_MEMBERS_PK
TBL_ENROLLMENT_MEMBERS_FK
ENROLLMENT_MEMBERS_UK TBL_ENROL_MEMBERS_IDX0003

Page 43
 SPDPENROLL
TBL_ENROLLMENT_MEMBERS_UK TBL_ENROLLMENT_MEMBERS_UK

Page 44
SPDPENROLL

Page 45
 SPDPENROLL

Description Indexes
TBL_HOF_ADDRESS_PK TBL_HOF_ADDRESS_PK
IDX$$_0E8B0006

TBL_HOF_ADDRESS_IDX1

TBL_HOF_ADDRESS_FK

Page 46
 SPDPENROLL

constraint Name Indexes

TBL_MEMBER_BANKS_PK
TBL_MEMBER_BANKS_FK
TBL_MEMBERS_BANK_SEARCH1_I
TBL_MEMBERS_BANK_SEARCH1_I
TBL_MEMBERS_BANK_SEARCH1_I
TBL_MEMBERS_BANK_SEARCH1_I

TBL_MEMBERS_BANK_SEARCH1_I

constraint Name Indexes

DOCUMENT_PK1,SYS_C0044251 DOCUMENT_PK1
SYS_C0044252
SYS_C0044253
SYS_C0044254

SYS_C0044313

constraint Name Indexes

MEMBER_INFO_ROWID_PK MEMBER_INFO_ROWID_PK

Page 47
 SPDPENROLL
MEMBER_INFO_ROWID_FK

MEMBER_INFO_ROWID_UK MEMBER_INFO_ROWID_UK
MEMBER_INFO_ROWID_UK2 MEMBER_INFO_ROWID_UK2
MEMBER_INFO_ROWID_UK1 MEMBER_INFO_ROWID_UK1
MEMBER_INFO_ROWID_UK3 MEMBER_INFO_ROWID_UK3

MEMBER_INFO_ROWID_UK4 MEMBER_INFO_ROWID_UK4

Page 48
 SPDPENROLL

constraint Name Indexes

Page 49
 SPDPENROLL
constraint Name Indexes
TBL_LGD_MAP_PK TBL_LGD_MAP_PK
TBL_LGD_MAP_UK TBL_LGD_MAP_UK

TBL_LGD_MAP_UK

constraint Name Indexes

constraint Name Indexes

SYS_C0023379( IS NOT NULL)

Page 50
 SPDPENROLL

constraint Name Indexes

ID ID
SYS_C0023335
SYS_C0023336
SYS_C0023337

constraint Name Indexes

Page 51
SPDPENROLL

Page 52
 SPDPENROLL

constraint Name Indexes

SYS_C0045607

constraint Name Indexes

Page 53
 SPDPENROLL

constraint Name Indexes

constraint Name Indexes

WIP_ENROLL_HOF_PK WIP_ENROLL_HOF_PK

Page 54
 SPDPENROLL

Description Indexes
WIP_ENROLLMENT_MEMBER_PK WIP_ENROLLMENT_MEMBER_PK
WIP_ENROLLMENT_MEMBER_FK
WIP_ENROLLMENT_MEMBER_UK1

Page 55
SPDPENROLL

Page 56
 SPDPENROLL

Description Indexes
TBL_DOCUMENT_VERIFICATION_PK TBL_DOCUMENT_VERIFICATION_PK

TBL_DOCUMENT_VERIFI_IDX001

Page 57
 SPDPENROLL

Description Indexes

Description Indexes
SYS_C0023349 , WIP_MEMBER_BANKWIP_MEMBER_BANKS_PK
WIP_MEMBER_BANKS_FK

Page 58
 SPDPENROLL
Description Indexes
SYS_C0023395 SYS_C0023395

TBL_UPLOAD_DOC_IDX04062022

TBL_UPLOAD_DOC_IDX04062022

Description Indexes

Page 59
 SPDPENROLL

MEMBERS_PK

Page 60
 SPDPENROLL
MEMBERS_UK

Page 61
 SPDPENROLL

Red marks :85 to 90 are temporary columns

Page 62
 SPDPENROLL

K_SEARCH1_I
K_SEARCH1_I
K_SEARCH1_I
K_SEARCH1_I

K_SEARCH1_I

Page 63
 SPDPENROLL

RIFICATION_PK

Page 64
 SPDPADMINCONSOLE

Project Name SPDP

Data Base Version ORACLE 19C

Table Name TBL_CITIZEN_SIGNUP_MASTER

Sl.No Column Name
1 USER_ID
2 NAME
3 FATHER_NAME
4 ADHAAR_NO
5 DATE_OF_BIRTH
6 MOBILE_NO
7 EMAIL_ID
8 MODIFIED_ON
9 CREATED_ON
10 MODIFIED_BY
11 CREATED_BY
12 USER_NAME
13 PASSWORD
14 RATION_CARD_NO
15 VOTER_ID_NO
16 PASSPORT_NO
17 PAN_CARD_NO
18 DRIVING_LICENSE_NO
19 PHOTO
20 GENDER_ID

Table Name TBL_DESIGNATION

Sl.No Column Name
1 DESIGNATION_ID
2 ALIAS_NAME
3 DESIGNATION_NAME

Page 65
 SPDPADMINCONSOLE
Table Name TBL_DESIGNATION_ROLE_MAP
Sl.No Column Name
1 ID
2 DESIGNATION_ID
3 DESIGNATION_NAME
4 ROLE_MASTER_ID
5 ROLE_NAME
6 UPDATED_ON
7 CREATED_BY
8 CREATED_ON
9 DELETE_STATUS
10 UPDATED_BY
11 USER_TYPE_ID
12 USER_TYPE_NAME

Table Name TBL_DESIGNATION_TYPE_MAST

Sl.No Column Name
1 ID
2 UPDATED_ON
3 CREATED_BY
4 CREATED_ON
5 DESIGNATION_ID
6 DELETE_STATUS
7 TYPE_ID
8 UPDATED_BY
9 TYPE_NAME

Table Name TBL_USER_WORK_LOCATION

Sl.No Column Name
1 USERID_SLNO
2 CITY_ID
3 GP_ID
4 IS_RURAL
5 SCHEMEID
6 BLOCK_ID
7 DISTRICT_ID
8 APPROVE_BY
9 APPROVE_STAUS
10 IS_ACTIVE

Page 66
 SPDPADMINCONSOLE
11 VILLAGE_ID
12 CREATED_ON
13 SSO_USERID_NAME
14 WEAVER_ZONE_ID
15 TAHSIL_ID
16 USERTYPE_ID
17 WARD_ID
18 CREATED_BY
19 APPROVE_DATE
20 DEPTID
21 TYPE_ID
22 SUBSCHEMEID
23 DESIGNATION_ID

Table Name TBL_USER_TYPE_MAST

Sl.No Column Name
1 USER_TYPE_ID
2 CREATED_BY
3 CREATED_DATE
4 MODIFIED_BY
5 MODIFIED_DATE
6 IS_ACTIVE
7 USER_TYPE_NAME
8 USER_TYPE_NAME_HIN
9 FLAG

Table Name TBL_USER_ROLE_MAST

Sl.No Column Name
1 ROLE_ID
2 ROLE_NAME
3 IS_ACTIVE
4 CREATED_DATE
5 CREATED_BY
6 MODIFIED_DATE
7 MODIFIED_BY
8 ROLE_NAME_HIN
9 ROLE_LEVEL
10 ALIAS_NAME
11 DESCRIPTION

Page 67
 SPDPADMINCONSOLE
Table Name TBL_USER_REGISTRATION
Sl.No Column Name
1 USER_ID
2 DATE_OF_BIRTH
3 CREATED_DATE
4 AADHAR_NO
5 BLOCK_ID
6 IMAGE_NAME
7 UPDATED_BY
8 DISTRICT_ID
9 LOCATION_TYPE_ID
10 PHOTO
11 MOBILE_NO
12 DESIGNATION
13 RESET_PWD_STATUS
14 SCHEME_ID
15 QUALIFICATION
16 ROLE
17 ADDRESS
18 USER_TYPE
19 HEADQUARTER
20 SUB_DIVISION_ID
21 VILLAGE_ID
22 FULL_NAME
23 EMAIL
24 SUB_DEPARTMENT_ID
25 USER_NAME
26 WEAVER_ZONE_ID
27 PASSWORD
28 GENDER
29 UPDATED_DATE
30 DEPARTMENT_ID
31 STATE_DEPARTMENT
32 CREATED_BY
33 GPID
34 ULB_ID

Table Name TBL_SECONDARY_LINK

Page 68
 SPDPADMINCONSOLE
Sl.No Column Name
1 SECONDARY_LINK_ID
2 UPDATED_ON
3 CREATED_BY
4 CREATED_ON
5 FUNCTION_ID
6 GLOBAL_LINK_ID
7 PRIMARY_LINK_ID
8 SECONDARY_LINK_NAME
9 SL_NO
10 DELETE_STATUS
11 UPDATED_BY

Table Name TBL_SCHEME_APPROVAL

Sl.No Column Name
1 SCHEME_APPROVAL_ID
2 AUTHORITY_ID
3 APPROVAL_STATUS
4 REMARK
5 ACTION_TAKEN_TIME
6 DEPT_ID
7 SCHEME_ID
8 PROCESS_ID

Table Name TBL_PRIMARY_LINK

Sl.No Column Name
1 PRIMARY_LINK_ID
2 UPDATED_ON
3 CREATED_BY
4 CREATED_ON
5 FUNCTION_ID
6 GLOBAL_LINK_ID
7 PRIMARY_LINK_NAME
8 SL_NO
9 DELETE_STATUS
10 UPDATED_BY

Table Name TBL_ADMIN_PROCESS

Sl.No Column Name
1 PROCESS_ID

Page 69
 SPDPADMINCONSOLE
2 PROCESS_NAME
3 CREATED_BY
4 ACTIVE_STATUS

Table Name TBL_ADMIN_AUTHORITY_CONFIG

Sl.No Column Name
1 AUTH_CONFIG_ID
2 DIPARTMENT_ID
3 SCHEME_ID
4 PROCESS_ID
5 ROLE_ID
6 AUTHORITY_ID
7 TIME_LINE
8 AUTHORITY_LEVEL

Table Name TBL_APITRANSATION_LOG

Sl.No Column Name
1 API_TRANSATIONID
2 API_PURPOSE
3 API_TRANSATION_TIME
4 USERNAME
5 JWT_GENERATION_TIME
6 AADHAARNO
7 SPDPID
8 IP_ADDRESS
9 JWT_TOKEN
10 SCHEME_ID
11 STATUS

Table Name ERROR_LOG_SPDP

Sl.No Column Name
1 ERROR_ROWID
2 ORA_ERROR_NUMBER
3 ORA_ERROR_MESG
4 PROGRAM_NAME
5 PROGRAM_BLOCK
6 ERROR_DATE

Page 70
 SPDPADMINCONSOLE

Table Name TBL_ADMIN_PROCESS

Sl.No Column Name
1 PROCESS_ID
2 PROCESS_NAME
3 CREATED_BY
4 ACTIVE_STATUS

Table Name TBL_CITIZEN_AUDIT_TRAIL

Sl.No Column Name
1 AADHAAR_NO
2 SPDP_ID
3 CREATED_ON
4 LOG_IN_TIME
5 LOG_OUT_TIME
6 ACTIVITY_NAME
7 URL
8 IP_ADDRESS
9 EXECUTOR
10 ID

Table Name TBL_IPTRACKINGS

Sl.No Column Name
1 IPID
2 USERID
3 USERTYPE
4 DEPARTMENT
5 IPADDRESS
6 LOGINDATETIME
7 LOGOUTDATETIME
8 LOGINSUCCESS
9 USERNAME

Table Name TBL_ODISHA_ONE_ENC_DETAILS

Sl.No Column Name
1 ID
2 DEPARTEMENTID
3 SERVICEID
4 SUBSERVICEID
5 REQUESTID
6 REQTIMESTAMP
7 REQUESTTYPE
8 OLDREQUESTID

Page 71
 SPDPADMINCONSOLE
9 OOUSERTOKEN
10 OOUSERCODE
11 OOUSERFULLNAME
12 OOUSERMOBILENO
13 OOUSEREMAIL
14 OOUSERGENDER
15 SUCCESSURL
16 CANCELURL
17 PAYMENTURL
18 IFMSPAYMENTURL
19 ADDITIONALPARA1
20 ADDITIONALPARA2
21 CHECKSUM
22 CREATED_ON
23 ENCDATA_ID
24 AADHAAR_NO

Table Name TBL_ODISHA_ONE_ENCDATA

Sl.No Column Name
1 ENROLL_FLAG
2 ENCDATA_ID
3 CREATED_DATE
4 USERTYPE
5 OLDREQUEST_ID
6 VCH_UUID
7 VCH_ENCDATA
8 FLAG
9 UPDATED_DATE
10 REQUESTID
11 STATUS

Table Name TBL_SESSION_TRACKING

Sl.No Column Name
1 SESSIONID
2 CLIENT_INFO
3 CLENT_IDENTIFIER
4 SESSION_INTIME
5 SESSION_OUTTIME

Table Name TBL_USER_LOGIN_DETAILS

Sl.No Column Name
1 SLNO
2 IPADDRESS

Page 72
 SPDPADMINCONSOLE
3 DEVICEID
4 BROWSERDETAILS
5 USERNAME
6 LOGINTIME
7 LOGOUTTIME
8 LOGOUTFLAG
9 SESSIONID
10 DEPTID
11 ROLENAME
12 CURRENTLOGINTIME

Table Name TBL_USER_TYPE_ROLE_MAST

Sl.No Column Name
1 ID
2 UPDATED_ON
3 CREATED_BY
4 CREATED_ON
5 ROLE_MASTER_ID
6 ROLE_NAME
7 DELETE_STATUS
8 UPDATED_BY
9 USER_TYPE_ID
10 USER_TYPE_NAME

Table Name TBL_USERWISE_PERMISSION

Sl.No Column Name
1 PERMISSION_ID
2 UPDATED_ON
3 PERMISSION_ACTION
4 CREATED_BY
5 CREATED_ON
6 FUNCTION_ID
7 GLOBAL_LINK_ID
8 PRIMARY_LINK_ID
9 ROLE_PERMISSION_ID
10 SECONDARY_LINK_ID
11 DELETE_STATUS
12 UPDATED_BY
13 USER_WORK_LOCATION_ID

Table Name TBL_USER_PERMISSION

Page 73
 SPDPADMINCONSOLE
Sl.No Column Name
1 FUNCTION_ID
2 USER_WORK_LOCATION_ID
3 SECONDARY_LINK_ID
4 DESIGNATION_ID
5 SSO_USER_ID
6 USER_TYPE_ID
7 PERMISSION_ACTION
8 ROLE_MASTER_ID
9 PRIMARY_LINK_ID
10 GLOBAL_LINK_ID
11 PERMISSION_ID

Table Name TBL_FUNCTION_MASTER

Sl.No Column Name
1 CREATED_ON
2 DESCRIPTION
3 UPDATED_BY
4 FUNCTION_NAME
5 FILE_NAME
6 ACTION
7 DELETE_STATUS
8 UPDATED_ON
9 CREATED_BY
10 FUNCTION_ID

Table Name TBL_LOCATION_TYPE

Sl.No Column Name
1 TYPE_ID
2 TYPE_NAME

Table Name TBL_ROLE_PERMISSION

Sl.No Column Name
1 FUNCTION_ID
2 CREATED_BY
3 UPDATED_ON
4 PERMISSION_ID
5 DESIGNATION_ROLE_MAP_ID
6 DESIGNATION_ID
7 UPDATED_BY
8 USER_TYPE_ID
9 CREATED_ON
10 PERMISSION_ACTION
11 SECONDARY_LINK_ID
12 DELETE_STATUS
13 PRIMARY_LINK_ID
14 GLOBAL_LINK_ID

Page 74
 SPDPADMINCONSOLE

Table Name TBL_GLOBAL_LINK

Sl.No Column Name
1 CREATED_ON
2 GLOBAL_LINK_ID
3 GLOBAL_LINK_NAME
4 UPDATED_BY
5 FUNCTION_ID
6 ICON_NAME
7 DELETE_STATUS
8 UPDATED_ON
9 CREATED_BY
10 SL_NO

Table Name TBL_GLOBAL_LINK

Sl.No Column Name
1 CREATED_ON
2 GLOBAL_LINK_ID
3 GLOBAL_LINK_NAME
4 UPDATED_BY
5 FUNCTION_ID
6 ICON_NAME
7 DELETE_STATUS
8 UPDATED_ON
9 CREATED_BY
10 SL_NO

Table Name TBL_OTP_AUTH

Sl.No Column Name
1 ID
2 OTP
3 TIME
4 MOBILE_NUM
5 VERIFICATION

Table Name TBL_ADMIN_AUTHORITY_MAPPING

Sl.No Column Name
1 PROCESS_ID
2 DEPT_ID
3 SCHEME_ID
4 STAGE_NO
5 STATUS_DATE
6 SENT_FROM
7 AUTH_MAP_ID
8 PENDING_AT

Page 75
 SPDPADMINCONSOLE

Table Name TEMP_IPTRACKING_SUMMARY

Sl.No Column Name
1 COL1
2 COL18
3 COL20
4 COL8
5 COL11
6 COL15
7 COL19
8 COL9
9 COL14
10 COLUMN_TYPE
11 COL6
12 COL16
13 DATA_TYPE
14 COL3
15 COL4
16 COL7
17 COL12
18 COL17
19 COL10
20 COL5
21 COL13
22 COL2

Table Name TBL_EKYC_LOG_TRAN

Sl.No Column Name
1 AUDIT_ID
2 RESPONSE_CODE
3 RESPONSE_STATUS
4 RESPONSE_DATE
5 MODULE_FLAG
6 SUB_AUA_CODE
7 TRACK_TIME
8 IS_HSM
9 TRANSACTION_ID
10 DC
11 REQUEST_DATE
12 IP_ADDRESS
13 FAILURE_CODE
14 AUTH_TYPE
15 UID_TOKEN

Table Name TBL_SCHEME_HEADER_DATA_LOG

Sl.No Column Name

Page 76
 SPDPADMINCONSOLE
1 TOTALRECORDCOUNT
2 HEADER_ID
3 FROM_DATE
4 STATUS
5 TODATE
6 UPDATED_DT
7 CREATED_DT
8 API_ID

Page 77
 SPDPADMINCONSOLE

Table Design
Module Name ADMINCONSOLE

Data Type Length Nullable Constraint

NUMBER No Primary_Key
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
NUMBER Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(13 BYTE) 13 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
DATE Yes
DATE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(10 BYTE) 10 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(16 BYTE) 16 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
CLOB Yes
NUMBER Yes

Data Type Length Nullable Constraint

NUMBER (10,0) No Primary_Key
VARCHAR2 20 No check
VARCHAR2 20 No check

Page 78
 SPDPADMINCONSOLE

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No Primary_Key
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes
TIMESTAMP(6) 6 Yes
VARCHAR2(255 CHAR) 255 Yes
TIMESTAMP(6) 6 Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(255 CHAR) 255 Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No Primary_Key
TIMESTAMP(6) 6 Yes
VARCHAR2(255 CHAR) 255 Yes
TIMESTAMP(6) 6 Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(255 BYTE) 255 Yes

Data Type Length Nullable Constraint

NUMBER(10,0) Primary Key No
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(1,0) Yes
NUMBER Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 200 BYTE Yes
VARCHAR2 10 BYTE Yes
CHAR 1 BYTE Yes

Page 79
 SPDPADMINCONSOLE
NUMBER Yes
DATE Yes
VARCHAR2 200 BYTE Yes
NUMBER Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 200 BYTE Yes
DATE Yes
NUMBER Yes
NUMBER(10,0) Yes
NUMBER Yes
NUMBER(10,0) Yes

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No Primary_Key
NUMBER(10,0) (10,0) Yes
TIMESTAMP(6) 6 Yes
NUMBER(10,0) (10,0) Yes
TIMESTAMP(6) 6 Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(255 CHAR) 255 Yes
NUMBER Yes

Data Type Length Nullable Constraint

NUMBER No check
VARCHAR2(30 BYTE) 30 Yes
CHAR(1 BYTE) 1 Yes
DATE Yes
NUMBER Yes
DATE Yes
NUMBER Yes
NVARCHAR2(150 CHAR) 150 Yes
NUMBER Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(300 CHAR) 300 Yes

Page 80
 SPDPADMINCONSOLE

Data Type Length Nullable Constraint

NUMBER Primary Key No
DATE Yes
DATE Yes
NUMBER Yes
NUMBER(10,0) Yes
VARCHAR2 50 BYTE Yes
NUMBER Yes
NUMBER(10,0) Yes
VARCHAR2 10 BYTE Yes
BLOB Yes
VARCHAR2 10 BYTE Yes
NUMBER Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 50 BYTE Yes
NUMBER Yes
VARCHAR2 500 BYTE Yes
NUMBER Yes
VARCHAR2 32 BYTE Yes
NUMBER(10,0) Yes
NUMBER Yes
VARCHAR2 100 BYTE Yes
VARCHAR2 100 BYTE Yes
NUMBER(10,0) Yes
VARCHAR2 100 BYTE Yes
NUMBER Yes
VARCHAR2 100 BYTE Yes
NUMBER Yes
DATE Yes
NUMBER(10,0) Yes
VARCHAR2 32 BYTE Yes
NUMBER Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes

Page 81
 SPDPADMINCONSOLE
Data Type Length Nullable Constraint
NUMBER(10,0) (10,0) No Primary_Key
TIMESTAMP(6) 6 Yes
VARCHAR2(255 CHAR) 255 Yes
TIMESTAMP(6) 6 Yes
NUMBER(10,0) (10,0) Yes
NUMBER(10,0) (10,0) Yes
NUMBER(10,0) (10,0) Yes Foreign_Key
VARCHAR2(255 CHAR) 255 Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 Yes
VARCHAR2(255 CHAR) 255 Yes

Data Type Length Nullable Constraint

NUMBER Yes
NUMBER Yes
VARCHAR2 20 Yes
VARCHAR2 500 Yes
DATE Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes

Data Type Length Nullable Constraint

NUMBER (10,0) No Primary_Key
TIMESTAMP 6 Yes
VARCHAR2 255 Yes
TIMESTAMP 6 Yes
NUMBER (10,0) Yes
NUMBER (10,0) Yes Foreign_Key
VARCHAR2 255 Yes
NUMBER (10,0) Yes
VARCHAR2 255 Yes
VARCHAR2 255 Yes

Data Type Length Nullable Constraint

NUMBER No Primary_Key

Page 82
 SPDPADMINCONSOLE
VARCHAR2 100 Yes
VARCHAR2 50 Yes
VARCHAR2 1 Yes

Data Type Length Nullable Constraint

NUMBER No Primary_Key
NUMBER Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes
VARCHAR2 20 Yes

Data Type Length Nullable Constraint

NUMBER No Primary_Key
VARCHAR2 50 Yes
TIMESTAMP 6 Yes
VARCHAR2 20 Yes
TIMESTAMP 6 Yes
VARCHAR2 20 Yes
VARCHAR2 20 Yes
VARCHAR2 20 Yes
VARCHAR2 500 Yes
NUMBER Yes
VARCHAR2 20 Yes

Data Type Length Nullable Constraint

NUMBER Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(2000 BYTE) 2000 BYTE Yes
VARCHAR2(32 BYTE) 32 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
TIMESTAMP(6) Yes

Page 83
 SPDPADMINCONSOLE

Data Type Length Nullable Constraint

NUMBER No CK , PK
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(1 BYTE) 1 BYTE Yes

Data Type Length Nullable Constraint

VARCHAR2(100 BYTE) 100 BYTE Yes
NUMBER Yes
DATE Yes
TIMESTAMP(6) Yes
TIMESTAMP(6) Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(10 BYTE) 10 BYTE Yes
NUMBER Yes

Data Type Length Nullable Constraint

NUMBER No PK
VARCHAR2(50 BYTE) 50 BYTE Yes
VARCHAR2(45 BYTE) 45 BYTE Yes
VARCHAR2(45 BYTE) 45 BYTE Yes
VARCHAR2(45 BYTE) 45 BYTE Yes
DATE Yes
DATE Yes
VARCHAR2(1 BYTE) 1 BYTE Yes
VARCHAR2(45 BYTE) 45 BYTE Yes

Data Type Length Nullable Constraint

NUMBER Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes

Page 84
 SPDPADMINCONSOLE
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(20 BYTE) 20Yes
VARCHAR2(1000 BYTE) 1000Yes
VARCHAR2(1000 BYTE) 1000Yes
VARCHAR2(1000 BYTE) 1000Yes
VARCHAR2(1000 BYTE) 1000Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(500 BYTE) 500Yes
VARCHAR2(1000 BYTE) 1000Yes
TIMESTAMP(6) Yes
NUMBER No FK ,PK
VARCHAR2(100 BYTE) 100 Yes

Data Type Length Nullable Constraint

VARCHAR2 100 BYTE Yes
NUMBER Primary Key No
DATE Yes
VARCHAR2 40 BYTE Yes
VARCHAR2 100 BYTE Yes
VARCHAR2 40 BYTE Yes
VARCHAR2 2000 BYTE Yes
VARCHAR2 20 BYTE Yes
DATE Yes
VARCHAR2 100 BYTE Yes
VARCHAR2 100 BYTE Yes

Data Type Length Nullable Constraint

VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
VARCHAR2(500 BYTE) 500 Yes
TIMESTAMP(6) Yes
TIMESTAMP(6) Yes

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No PK
VARCHAR2(60 BYTE) 60 Yes

Page 85
 SPDPADMINCONSOLE
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
TIMESTAMP(6) Yes
TIMESTAMP(6) Yes
VARCHAR2(10 BYTE) 10 BYTE Yes
VARCHAR2(100 BYTE) 100 BYTE Yes
VARCHAR2(45 BYTE) 45 BYTE Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
TIMESTAMP(6) Yes

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No CK , PK
TIMESTAMP(6) Yes
VARCHAR2(255 CHAR) 255 CHAR Yes
TIMESTAMP(6) Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 CHAR Yes
VARCHAR2(255 CHAR) 255 CHAR Yes
VARCHAR2(255 CHAR) 255 CHAR Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 CHAR Yes

Data Type Length Nullable Constraint

NUMBER(10,0) (10,0) No CK , PK
TIMESTAMP(6) Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
TIMESTAMP(6) Yes
NUMBER(10,0) (10,0) Yes
NUMBER(10,0) (10,0) No CK
NUMBER(10,0) (10,0) No CK
NUMBER(10,0) (10,0) Yes
NUMBER(10,0) (10,0) Yes
VARCHAR2(255 CHAR) 255 CHAR Yes
VARCHAR2(50 BYTE) 50 BYTE Yes
NUMBER(10,0) (10,0) Yes

Page 86
 SPDPADMINCONSOLE
Data Type Length Nullable Constraint
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Check Yes
NUMBER(10,0) Check Yes
NUMBER(10,0) Check Yes

Data Type Length Nullable Constraint

TIMESTAMP(6) Yes
VARCHAR2 1020 BYTE Yes
VARCHAR2 1020 BYTE Yes
VARCHAR2 1020 BYTE Yes
VARCHAR2 1020 BYTE Yes
VARCHAR2 1020 BYTE Yes
VARCHAR2 1020 BYTE Yes
TIMESTAMP(6) Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Check Yes

Data Type Length Nullable Constraint

NUMBER(10,0) Primary Key No
VARCHAR2 1020 BYTE Yes

Data Type Length Nullable Constraint

NUMBER(10,0) Yes
VARCHAR2 50 BYTE Yes
TIMESTAMP(6) Yes
NUMBER(10,0) Primary Key No
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 50 BYTE Yes
NUMBER(10,0) Yes
TIMESTAMP(6) Yes
NUMBER(10,0) Yes
NUMBER(10,0) Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Check Yes
NUMBER(10,0) Check Yes

Page 87
 SPDPADMINCONSOLE

Data Type Length Nullable Constraint

DATE Yes
NUMBER(10,0) Primary Key No
VARCHAR2 1020 BYTE Unique Key Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Yes
VARCHAR2 100 BYTE Yes
VARCHAR2 1020 BYTE Yes
DATE Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Yes

Data Type Length Nullable Constraint

DATE Yes
NUMBER(10,0) Primary Key No
VARCHAR2 1020 BYTE Unique Key Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Yes
VARCHAR2 100 BYTE Yes
VARCHAR2 1020 BYTE Yes
DATE Yes
VARCHAR2 1020 BYTE Yes
NUMBER(10,0) Yes

Data Type Length Nullable Constraint

NUMBER(12,0) Yes
NUMBER(10,0) Yes
TIMESTAMP(6) Yes
VARCHAR2 13 BYTE Yes
VARCHAR2 20 BYTE Yes

Data Type Length Nullable Constraint

NUMBER Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes
DATE Yes
NUMBER Yes
NUMBER Yes
NUMBER Yes

Page 88
 SPDPADMINCONSOLE

Data Type Length Nullable Constraint

VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes
VARCHAR2 4000 BYTE Yes

Data Type Length Nullable Constraint

NUMBER(38,0) Primary Key No
VARCHAR2 400 BYTE Yes
VARCHAR2 100 BYTE Yes
DATE Yes
VARCHAR2 20 BYTE Yes
VARCHAR2 200 BYTE Yes
TIMESTAMP(6) Yes
CHAR 4 BYTE Yes
VARCHAR2 400 BYTE Yes
VARCHAR2 208 BYTE Yes
TIMESTAMP(6) Yes
VARCHAR2 120 BYTE Yes
VARCHAR2 80 BYTE Yes
VARCHAR2 4 BYTE Yes
VARCHAR2 288 BYTE Yes

Data Type Length Nullable Constraint

Page 89
 SPDPADMINCONSOLE
NUMBER Yes
NUMBER Primary Key No
DATE Yes
VARCHAR2 20 BYTE Yes
DATE Yes
DATE Yes
DATE Yes
NUMBER Check Yes

Page 90
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL CITIZEN_SIGNUP_MASTER_PK CITIZEN_SIGNUP_MASTER_PK
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL SYS_C0020448 SYS_C0020448
NULL
NULL

Page 91
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL SYS_C0020449 SYS_C0020449
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

Primary_Key SYS_C0020454 SYS_C0020454

Default Value Description Indexes

NULL TBL_USER_WORK_LOCATION_PK TBL_USER_WORK_LOCATION_PK
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Page 92
 SPDPADMINCONSOLE
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

Primary_Key SYS_C0020462 SYS_C0020462

Default Value Description Indexes

SYS_C0020407

Page 93
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL TBL_USER_REGISTRATION_PK TBL_USER_REGISTRATION_PK
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Page 94
 SPDPADMINCONSOLE
Default Value Description Indexes
Primary_Key SYS_C0020461 SYS_C0020461

Default Value Description Indexes

Default Value Description Indexes

Primary_Key SYS_C0020460 SYS_C0020460

Default Value Description Indexes

Primary_Key TBLADMIN_PROCESS_PK TBLADMIN_PROCESS_PK

Page 95
 SPDPADMINCONSOLE

Default Value Description Indexes

Primary_Key BIN$GA3pF6OeSwWHWNWd3Miv8Q==$0Primary_Key

Default Value Description Indexes

Primary_Key TBL_APITRANSATION_LOG_PK TBL_APITRANSATION_LOG_PK

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL

Page 96
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL SYS_C009061 , TBLADMIN_PROCESS_PK TBLADMIN_PROCESS_PK
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL PK_TBL_IPTRACKING_IPID PK_TBL_IPTRACKING_IPID
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Page 97
 SPDPADMINCONSOLE
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL FK_ENCDATA_ID , TBL_ODISHA_ONE_ENC TBL_ODISHA_ONE_ENC_DETAILS_PK
NULL

Default Value Description Indexes

NULL
NULL TBL_ODISA_ONE_ENCDATA_PK TBL_ODISA_ONE_ENCDATA_PK
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL
NULL
systimestamp
NULL

Default Value Description Indexes

NULL PK_LOGIN_DETAILS_SLNO PK_LOGIN_DETAILS_SLNO
NULL

Page 98
 SPDPADMINCONSOLE
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL SYS_C009048 , SYS_C009070 SYS_C009070
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL SYS_C009052 , SYS_C009072 SYS_C009072
NULL
NULL
NULL
NULL
NULL
NULL SYS_C009053
NULL SYS_C009054
NULL
NULL
NULL
NULL
NULL

Page 99
 SPDPADMINCONSOLE
Default Value Description Indexes
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL SYS_C009029
NULL SYS_C009028
NULL SYS_C009027

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL SYS_C009039

Default Value Description Indexes

NULL SYS_C009069 SYS_C009069
NULL

Default Value Description Indexes

NULL
NULL
NULL
NULL SYS_C009071 SYS_C009071
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL SYS_C009051
NULL SYS_C009050

Page 100
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL
NULL SYS_C009075 SYS_C009075
NULL UK_GYD2BOV2C3922KJD9IKBI7OR3
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL SYS_C009075 SYS_C009075
NULL UK_GYD2BOV2C3922KJD9IKBI7OR3
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Page 101
 SPDPADMINCONSOLE

Default Value Description Indexes

NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

NULL TBL_EKYC_LOG_TRAN_PK TBL_EKYC_LOG_TRAN_PK
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL
NULL

Default Value Description Indexes

Page 102
 SPDPADMINCONSOLE
NULL
NULL SYS_C0021725 SYS_C0021725
NULL
NULL
NULL
NULL
NULL
NULL SYS_C0021726

Page 103
 SPDPEDIT

Table Name TBL_CVP_TRAINING

Sl.No Column Name Data Type
1 INTID NUMBER
2 MCP_IFSC_CODE VARCHAR2
3 ADDRESS_HEADING VARCHAR2
4 POLICE_STATIONID NUMBER
5 DESIGNATIONID NUMBER
6 MCP_FAT_SPO_NAME VARCHAR2
7 DESIGNATION_ID NUMBER
8 INTCREATEDBY NUMBER(11,0)
9 FULLNAME VARCHAR2
10 LOACTION_HEADING VARCHAR2
11 DISTRICT_ID_LOC NUMBER
12 APPL_NAME VARCHAR2
13 BLOCK_ID NUMBER
14 BITDELETEDFLAG NUMBER(3,0)
15 PER_HEADING VARCHAR2
16 BANK_HEADING VARCHAR2
17 DISTRICT_ID NUMBER
18 DTMCREATEDON TIMESTAMP(6)
19 MCP_CRAFT_ID NUMBER
20 MCP_MARITAL_ID NUMBER
21 MCP_EDUCATION_ID NUMBER
22 MCP_SOCIAL_ID NUMBER
23 MCP_BRANCH_NAME VARCHAR2
24 SECRETARY_NAME VARCHAR2
25 MCP_DOB DATE
26 MCP_ACCOUNT VARCHAR2
27 MCP_AADHARNO VARCHAR2
28 EDUCATION_COPY VARCHAR2
29 VILLAGE_ID NUMBER
30 INTUPDATEDBY NUMBER(11,0)
31 PRESIDENT_NAME VARCHAR2
32 APPL_AADHAR_NO VARCHAR2
33 EMAIL VARCHAR2
34 MCP_MOBILE_NO VARCHAR2
35 TRAINING_COPY VARCHAR2
36 APPL_DOB VARCHAR2
37 INTONLINESERVICEID NUMBER(11,0)

Page 104
 SPDPEDIT
38 APPLMOB VARCHAR2
39 CRAFT_HEADING VARCHAR2
40 CRAFT_ID NUMBER
41 MCP_GENDER_ID NUMBER
42 FULL_ADDRESS_MCP VARCHAR2
43 MCP_TARINING_ID NUMBER
44 GP_WARD_ID NUMBER
45 SPDPMEMBERID VARCHAR2
46 BLOCK_ID_LOC NUMBER
47 SHG_NAME VARCHAR2
48 APPL_MOB VARCHAR2
49 STMUPDATEDON TIMESTAMP(6)
50 CREATEDBY VARCHAR2
51 BANK_COPY VARCHAR2
52 ADDRERSS_HEADING VARCHAR2
53 MCP_BANK_NAME VARCHAR2
54 JSONOPTTXTDETAILS CLOB
55 APP_FULL_ADDRESS VARCHAR2
56 MCP_NAME VARCHAR2
57 MCP_YEAR VARCHAR2
58 LOCATION_NAME VARCHAR2
59 GENDER_ID VARCHAR2
60 PIN_CODE VARCHAR2

Table Name TBL_GURU_SISHYA_DB

Sl.No Column Name Data Type
1 INTID NUMBER
2 POLICESTATION_ID NUMBER
3 ADDRESS_HEADING VARCHAR2
4 APPL_NAME VARCHAR2
5 LOACTION_HEADING VARCHAR2
6 INTCREATEDBY NUMBER(11,0)
7 FULLNAME VARCHAR2
8 QULIFICATION_COP VARCHAR2
9 BLOCK_ID NUMBER
10 APPL_PINCODE VARCHAR2
11 LOC_DISTRICT_ID NUMBER
12 LOCATION VARCHAR2

Page 105
 SPDPEDIT
13 BANK_HEADING VARCHAR2
14 GURU_DATE DATE
15 BITDELETEDFLAG NUMBER(3,0)
16 DIBYANG_COPY VARCHAR2
17 APPL_GENDERNEW VARCHAR2
18 DISTRICT_ID NUMBER
19 LOC_BLOCK_ID NUMBER
20 DTMCREATEDON TIMESTAMP(6)
21 APPL_MARITALID NUMBER
22 APPL_SPOUSE VARCHAR2
23 GURU_PARAM_ID NUMBER
24 ACCOUNT_NO VARCHAR2
25 BANK_NAME VARCHAR2
26 GURU_SISHYA_ID NUMBER
27 GURU_DATE_NEW VARCHAR2
28 BASIC_DETAILS_HD VARCHAR2
29 APPL_AADHAAR VARCHAR2
30 CASTECATID NUMBER
31 VILLAGE_ID NUMBER
32 CRAFT_ID_PRATICE NUMBER
33 INTUPDATEDBY NUMBER(11,0)
34 APPL_DOB VARCHAR2
35 APPLMOB VARCHAR2
36 CRAFT_ID NUMBER
37 INTONLINESERVICEID NUMBER(11,0)
38 DIBYANG_ID NUMBER
39 IFSC_CODE VARCHAR2
40 GP_WARD_ID NUMBER
41 BRANCH_NAME VARCHAR2
42 SPDPMEMBERID VARCHAR2
43 APPL_PHOTO VARCHAR2
44 STMUPDATEDON TIMESTAMP(6)
45 CREATEDBY VARCHAR2
46 BANK_COPY VARCHAR2
47 EDUCATION_ID NUMBER
48 IMP_TRAIRING_ID NUMBER
49 JSONOPTTXTDETAILS CLOB
50 APPL_MOTHER VARCHAR2
51 APP_FULL_ADDRESS VARCHAR2
52 APPL_AGE VARCHAR2

Page 106
 SPDPEDIT
53 APPL_FATHER VARCHAR2
54 DIBYANG_CERT_NO VARCHAR2

Table Name TBL_MCP_TRAINING

Sl.No Column Name Data Type
1 INTID NUMBER
2 POLICESTATION_ID NUMBER
3 ADDRESS_HEADING VARCHAR2
4 LOACTION_HEADING VARCHAR2
5 ACCOUNT_NUMBER VARCHAR2
6 INTCREATEDBY NUMBER(11,0)
7 FULLNAME VARCHAR2
8 APPL_NAME VARCHAR2
9 APPL_PINCODE VARCHAR2
10 IMP_TRAINING_ID NUMBER
11 LOC_DISTRICT_ID NUMBER
12 BANK_HEADING VARCHAR2
13 BITDELETEDFLAG NUMBER(3,0)
14 DIBYANG_COPY VARCHAR2
15 BLOCK_ID NUMBER
16 LOC_BLOCK_ID NUMBER
17 BASIC_HEADING VARCHAR2
18 DTMCREATEDON TIMESTAMP(6)
19 APPL_GENDERNEW VARCHAR2
20 DISTRICT_ID NUMBER
21 AWARD_DOCUMENT VARCHAR2
22 SUPPORTING_COPY VARCHAR2
23 APPL_MARITALID NUMBER
24 APPL_SPOUSE VARCHAR2
25 AWARD_NAME VARCHAR2
26 BANK_NAME VARCHAR2
27 TRAIN_PROG_ID NUMBER
28 TRAINING_ID NUMBER
29 EDUCATION_COPY VARCHAR2
30 INTUPDATEDBY NUMBER(11,0)
31 APPL_AADHAAR VARCHAR2
32 CASTECATID NUMBER
33 VILLAGE_ID NUMBER

Page 107
 SPDPEDIT
34 AWARD_ID NUMBER
35 TRAINING_NAMEE VARCHAR2
36 CRAFT_ID NUMBER
37 INTONLINESERVICEID NUMBER(11,0)
38 TRAINING_COPY VARCHAR2
39 APPL_DOB VARCHAR2
40 APPLMOB VARCHAR2
41 IFSC_CODE VARCHAR2
42 DIBYANG_ID NUMBER
43 BRANCH_NAME VARCHAR2
44 SPDPMEMBERID VARCHAR2
45 GP_WARD_ID NUMBER
46 MCP_DATE VARCHAR2
47 DIDBYANG_CERT_NO VARCHAR2
48 STMUPDATEDON TIMESTAMP(6)
49 CREATEDBY VARCHAR2
50 APPL_PHOTO VARCHAR2
51 IMP_TRAIRING_ID NUMBER
52 TRAININGID VARCHAR2
53 JSONOPTTXTDETAILS CLOB
54 EDUCATION_ID NUMBER
55 LOCATION_NAME VARCHAR2
56 APPL_MOTHER VARCHAR2
57 APP_FULL_ADDRESS VARCHAR2
58 MCP_ID NUMBER
59 PRODU_HANDI_NAME VARCHAR2
60 APPL_AGE VARCHAR2
61 APPL_FATHER VARCHAR2

Table Name TBL_TRAINING_INT

Sl.No Column Name Data Type
1 INTID NUMBER
2 POLICESTATION_ID NUMBER
3 GP_ID NUMBER
4 DIBYANG_CET_COPY VARCHAR2
5 APPL_NAME VARCHAR2
6 APPL_IFSCCODE VARCHAR2

Page 108
 SPDPEDIT
7 INTCREATEDBY NUMBER(11,0)
8 FULLNAME VARCHAR2
9 ADDRESS_DETAILS VARCHAR2
10 BLOCK_ID NUMBER
11 APPL_PINCODE VARCHAR2
12 BITDELETEDFLAG NUMBER(3,0)
13 BASIC_HEADING VARCHAR2
14 APPL_GENDERNEW VARCHAR2
15 DISTRICT_ID NUMBER
16 DTMCREATEDON TIMESTAMP(6)
17 DISABILITY_CAT_I NUMBER
18 APPL_MARITALID NUMBER
19 HIGHER_CERT_COPY VARCHAR2
20 APPL_AADHAAR VARCHAR2
21 CASTECATID NUMBER
22 VILLAGE_ID NUMBER
23 APPLBANK_NAME VARCHAR2
24 INTUPDATEDBY NUMBER(11,0)
25 INSTITUTE_ID NUMBER
26 APPLMOB_NEW VARCHAR2
27 COUSE_LEV_ID NUMBER
28 APPL_DOB VARCHAR2
29 MASTER_CERT_COPY VARCHAR2
30 INTONLINESERVICEID NUMBER(11,0)
31 TRAINING_COPY VARCHAR2
32 APPLMOB VARCHAR2
33 DIBYANG_ID NUMBER
34 SPOUSE_NAME VARCHAR2
35 EDU_CERT_COPY VARCHAR2
36 SPDPMEMBERID VARCHAR2
37 APPL_GP_WARD NUMBER
38 COUSE_ID NUMBER
39 APPL_PHOTO VARCHAR2
40 BANK_COPY VARCHAR2
41 STMUPDATEDON TIMESTAMP(6)
42 CREATEDBY VARCHAR2
43 EDUCATION_ID NUMBER
44 APPL_BRANCH_NAME VARCHAR2
45 APPL_ACCOUNT_NO VARCHAR2
46 JSONOPTTXTDETAILS CLOB

Page 109
 SPDPEDIT
47 EXPR_COPY VARCHAR2
48 APPL_MOTHER VARCHAR2
49 APP_FULL_ADDRESS VARCHAR2
50 BASICLEVELHEADIN VARCHAR2
51 APPL_AGE VARCHAR2
52 APPL_FATHER VARCHAR2

Table Name TBL_SPDP_SUY

Sl.No Column Name Data Type
1 INTID NUMBER
2 APPL_CASTEID NUMBER
3 APPL_PLACE VARCHAR2
4 APPL_NAME VARCHAR2
5 INTCREATEDBY NUMBER(11,0)
6 FULLNAME VARCHAR2
7 BANK_DST_ID NUMBER
8 OWNERSHIP_ID NUMBER
9 BANK_HEADING VARCHAR2
10 AADHAAR_NO VARCHAR2
11 DTMCREATEDON TIMESTAMP(6)
12 TRADING_ID NUMBER
13 BITDELETEDFLAG NUMBER(3,0)
14 BLOCK_ID NUMBER
15 APPL_PINCODE VARCHAR2
16 BHULEKH_F_H_NAME VARCHAR2
17 APPMOB VARCHAR2
18 MARKET_DETAILS VARCHAR2
19 DISTRICT_ID NUMBER
20 BHK_PLOT_NO VARCHAR2
21 OWN_AMT_PEC VARCHAR2
22 ACCOUNT_NO VARCHAR2
23 TREADING_YEAR VARCHAR2
24 C_E_LOAN_AMT VARCHAR2
25 BHULEKH_RELATION VARCHAR2
26 TAHSIL_CODE_BHK NUMBER
27 BANK_NAME VARCHAR2
28 MARITAL_STS_ID NUMBER

Page 110
 SPDPEDIT
29 INTUPDATEDBY NUMBER(11,0)
30 VILLAGE_ID NUMBER
31 WC_AMOUNT VARCHAR2
32 PROJECT_COPY VARCHAR2
33 BHULEKH_ACRE VARCHAR2
34 APPL_AADHAAR VARCHAR2
35 SMCOST_HEADING VARCHAR2
36 APPLMOB VARCHAR2
37 CRAFT_ID NUMBER
38 KHATANO VARCHAR2
39 APP_TYPE NUMBER
40 BANK_BRANCH_ID NUMBER
41 MARGIN_MON_PET VARCHAR2
42 TOTAL_AMOUNT VARCHAR2
43 BHULEKH_OWNER VARCHAR2
44 APPL_DOB VARCHAR2
45 INTONLINESERVICEID NUMBER(11,0)
46 BANK_ID NUMBER
47 IFSC_CODE VARCHAR2
48 BHULEKH_BTN VARCHAR2
49 LAND_BENEF_HEAD VARCHAR2
50 SPOUSE_NAME VARCHAR2
51 OSCHC_ID NUMBER
52 BRANCH_NAME VARCHAR2
53 SPDPMEMBERID VARCHAR2
54 ANNUAL_INCOME VARCHAR2
55 GP_WARD_ID NUMBER
56 LAND_COPY VARCHAR2
57 APPL_GENDER VARCHAR2
58 CREATEDBY VARCHAR2
59 EDUCATION_ID NUMBER
60 JSONOPTTXTDETAILS CLOB
61 RELIGIONID NUMBER
62 STMUPDATEDON TIMESTAMP(6)
63 ADDRESSHEADING VARCHAR2
64 INDUSTRY_NAME VARCHAR2
65 RI_CIRCLE_CODE NUMBER
66 APP_FULL_ADDRESS VARCHAR2
67 VILLAGE_CODE_BHK NUMBER
68 APPL_AGE VARCHAR2

Page 111
 SPDPEDIT
69 APPL_FATHER VARCHAR2
70 MOTHER_NAME VARCHAR2
71 DECLATAION VARCHAR2
72 DISTRICT_CODE_BH NUMBER
73 LOAN_BANK VARCHAR2

Table Name TBL_SPDPWORKSHED

Sl.No Column Name Data Type
1 INTID NUMBER
2 INCOME_FILE VARCHAR2
3 HCS_ID NUMBER
4 APPL_NAME VARCHAR2
5 APPL_CASTEID NUMBER
6 HOUSING_ID NUMBER
7 BANKHEADING VARCHAR2
8 APP_IFSC VARCHAR2
9 APP_BANK_NAME VARCHAR2
10 INTCREATEDBY NUMBER(11,0)
11 FULLNAME VARCHAR2
12 BANK_FILE VARCHAR2
13 HCS_NAME VARCHAR2
14 APPL_PINCODE VARCHAR2
15 RELATION_OWNERID NUMBER
16 APP_ACC_N VARCHAR2
17 BITDELETEDFLAG NUMBER(3,0)
18 OWNER_FILE VARCHAR2
19 APPL_GENDERNEW VARCHAR2
20 APPMOB VARCHAR2
21 DTMCREATEDON TIMESTAMP(6)
22 LAND_DOC VARCHAR2
23 APPL_MARITALID NUMBER
24 BHK_PLOT_NO VARCHAR2
25 TAHSIL_CODE_BHK NUMBER
26 BLOCK NUMBER
27 POLICE_STA_ID NUMBER
28 ACTIVE_STATUS_NE VARCHAR2
29 BASIC_DETAILS_HD VARCHAR2

Page 112
 SPDPEDIT
30 APPL_AADHAAR VARCHAR2
31 VILLAGE_ID NUMBER
32 BHULEKH_LAND_DD VARCHAR2
33 BANKACTIVESTATUS VARCHAR2
34 INTUPDATEDBY NUMBER(11,0)
35 HOUSEHOLD_WORK VARCHAR2
36 KHATANO VARCHAR2
37 BHULEKH_ID VARCHAR2
38 BHULEKH_F_H_DD VARCHAR2
39 APPL_DOB VARCHAR2
40 APPL_RELIGIONID NUMBER
41 CRAFT_ID NUMBER
42 NO_YEAR_CARFT NUMBER
43 DISTRICT NUMBER
44 APP_BRANCH_NAME VARCHAR2
45 INTONLINESERVICEID NUMBER(11,0)
46 APPLMOB VARCHAR2
47 BHULEKH_OWNER_DD VARCHAR2
48 SPOUSE_NAME VARCHAR2
49 GP_WARD_ID NUMBER
50 RI_CIRCLE_BHK NUMBER
51 LAND_BENEF_HEAD VARCHAR2
52 SPDPMEMBERID VARCHAR2
53 APPL_PHOTO VARCHAR2
54 ADDRESSHEADING VARCHAR2
55 BHULEKH_RELA_DD VARCHAR2
56 STMUPDATEDON TIMESTAMP(6)
57 CREATEDBY VARCHAR2
58 EDUCATION_ID NUMBER
59 JSONOPTTXTDETAILS CLOB
60 APP_FULL_ADDRESS VARCHAR2
61 DISTRICT_CODE_BH NUMBER
62 ZBHULEKH_RELA_DD VARCHAR2
63 APPL_AGE VARCHAR2
64 APPL_FATHER VARCHAR2
65 MOTHER_NAME VARCHAR2
66 VILLAGE_CODE_BHK NUMBER

Page 113
 SPDPEDIT

Table Name TBL_EXH_PART

Sl.No Column Name Data Type
1 INTID NUMBER
2 MOTHER_NAME VARCHAR2
3 DECLARATION_HED VARCHAR2
4 DECL_DETALIS NUMBER
5 INTCREATEDBY NUMBER(11,0)
6 FULLNAME VARCHAR2
7 APPL_NAME VARCHAR2
8 BLOCK_ID NUMBER
9 BITDELETEDFLAG NUMBER(3,0)
10 DISTRICT_ID NUMBER
11 DTMCREATEDON TIMESTAMP(6)
12 BASIC_HEADING VARCHAR2
13 FATHE_NAME VARCHAR2
14 APPL_ADDRESS_HEA VARCHAR2
15 GSTNO VARCHAR2
16 DOC_EXHIBITION VARCHAR2
17 SPDP_GP_ID NUMBER
18 VILLAGE_ID NUMBER
19 INTUPDATEDBY NUMBER(11,0)
20 CASTECATID NUMBER
21 ADDRESS_NAME VARCHAR2
22 SOLD_VALUE VARCHAR2
23 INTONLINESERVICEID NUMBER(11,0)
24 APPLMOB VARCHAR2
25 APPL_AADHAAR_NO VARCHAR2
26 APPL_DOB VARCHAR2
27 CRAFT_ID NUMBER
28 MARITAL_STATU_ID NUMBER
29 SPDPMEMBERID VARCHAR2
30 SPOUSE_NAME VARCHAR2
31 APPL_MOB VARCHAR2
32 GST_ID NUMBER
33 STMUPDATEDON TIMESTAMP(6)
34 CREATEDBY VARCHAR2
35 APPL_PHOTO VARCHAR2
36 APPL_GENDER VARCHAR2
37 JSONOPTTXTDETAILS CLOB

Page 114
 SPDPEDIT
38 PHYSICALLLY_ID NUMBER
39 PARTICIPANT_TYPE VARCHAR2
40 PIN_CODE VARCHAR2

Page 115
 SPDPEDIT

Length Constraint Nullable Default Value

Primary Key No NULL
255 BYTE Yes NULL
200 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
500 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
255 BYTE Yes NULL
500 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL

Page 116
 SPDPEDIT
15 BYTE Yes NULL
200 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
688 BYTE Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
4000 BYTE Yes NULL
2551 BYTE Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL
255 BYTE Yes NULL

Length Constraint Nullable Default Value

Primary Key No NULL
Yes NULL
150 BYTE Yes NULL
100 BYTE Yes NULL
200 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
10 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL

Page 117
 SPDPEDIT
255 BYTE Yes NULL
Yes NULL
Yes NULL
400 BYTE Yes NULL
10 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
200 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
20 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
50 BYTE Yes NULL
Yes NULL
150 BYTE Yes NULL
255 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
Yes NULL
4000 BYTE Yes NULL
100 BYTE Yes NULL
300 BYTE Yes NULL
10 BYTE Yes NULL

Page 118
 SPDPEDIT
100 BYTE Yes NULL
255 BYTE Yes NULL

Length Constraint Nullable Default Value

Primary Key No NULL
Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
10 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
400 BYTE Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
Yes NULL
10 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
400 BYTE Yes NULL
Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL

Page 119
 SPDPEDIT
Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
400 BYTE Yes NULL
30 BYTE Yes NULL
20 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
20 BYTE Yes NULL
4000 BYTE Yes NULL
Yes NULL
200 BYTE Yes NULL
100 BYTE Yes NULL
300 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
10 BYTE Yes NULL
100 BYTE Yes NULL

Length Constraint Nullable Default Value

Primary Key No NULL
Yes NULL
Yes NULL
400 BYTE Yes NULL
100 BYTE Yes NULL
30 BYTE Yes NULL

Page 120
 SPDPEDIT
Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
10 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
400 BYTE Yes NULL
25 BYTE Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
20 BYTE Yes NULL
Yes NULL
30 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
400 BYTE Yes NULL
40 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
400 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
500 BYTE Yes NULL
400 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
50 BYTE Yes NULL
4000 BYTE Yes NULL

Page 121
 SPDPEDIT
400 BYTE Yes NULL
100 BYTE Yes NULL
300 BYTE Yes NULL
400 BYTE Yes NULL
20 BYTE Yes NULL
100 BYTE Yes NULL

Length Constraint Nullable Default Value

Primary Key No NULL
Yes NULL
120 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
10 BYTE Yes NULL
100 BYTE Yes NULL
15 BYTE Yes NULL
300 BYTE Yes NULL
Yes NULL
20 BYTE Yes NULL
50 BYTE Yes NULL
50 BYTE Yes NULL
10 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
Yes NULL

Page 122
 SPDPEDIT
Yes NULL
Yes NULL
50 BYTE Yes NULL
500 BYTE Yes NULL
100 BYTE Yes NULL
400 BYTE Yes NULL
100 BYTE Yes NULL
15 BYTE Yes NULL
Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
50 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
20 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
500 BYTE Yes NULL
10 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
4000 BYTE Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
250 BYTE Yes NULL
Yes NULL
10 BYTE Yes NULL

Page 123
 SPDPEDIT
100 BYTE Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL

Length Constraint Nullable Default Value

Primary Key No NULL
400 BYTE Yes NULL
Yes NULL
50 BYTE Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
20 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
500 BYTE Yes NULL
100 BYTE Yes NULL
15 BYTE Yes NULL
Yes NULL
30 BYTE Yes NULL
Yes NULL
500 BYTE Yes NULL
10 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
400 BYTE Yes NULL
Yes NULL
50 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
45 BYTE Yes NULL
1000 BYTE Yes NULL

Page 124
 SPDPEDIT
20 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
50 BYTE Yes NULL
Yes NULL
100 BYTE Yes NULL
50 BYTE Yes NULL
100 BYTE Yes NULL
255 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
Yes NULL
30 BYTE Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
200 BYTE Yes NULL
255 BYTE Yes NULL
200 BYTE Yes NULL
200 BYTE Yes NULL
255 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
Yes NULL
4000 BYTE Yes NULL
250 BYTE Yes NULL
Yes NULL
255 BYTE Yes NULL
10 BYTE Yes NULL
50 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL

Page 125
 SPDPEDIT

Length Constraint Nullable Default Value

Primary Key No NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
100 BYTE Yes NULL
100 BYTE Yes NULL
200 BYTE Yes NULL
20 BYTE Yes NULL
500 BYTE Yes NULL
Yes NULL
Yes NULL
Yes NULL
Yes NULL
140 BYTE Yes NULL
100 BYTE Yes NULL
Yes NULL
30 BYTE Yes NULL
20 BYTE Yes NULL
50 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
100 BYTE Yes NULL
20 BYTE Yes NULL
Yes NULL
Yes NULL
255 BYTE Yes NULL
500 BYTE Yes NULL
10 BYTE Yes NULL
4000 BYTE Yes NULL

Page 126
 SPDPEDIT
Yes NULL
100 BYTE Yes NULL
10 BYTE Yes NULL

Page 127
 SPDPEDIT

Description Indexes
SYS_C0019060 SYS_C0019060

Page 128
 SPDPEDIT

Description Indexes
SYS_C0019022 SYS_C0019022

Page 129
 SPDPEDIT

Description Indexes
SYS_C0017528 SYS_C0017528

Page 130
 SPDPEDIT

Description Indexes
SYS_C0018047 SYS_C0018047

Page 131
 SPDPEDIT

Description Indexes
SYS_C0015920 SYS_C0015920

Page 132
 SPDPEDIT

Description Indexes
SYS_C0018256 SYS_C0018256

Page 133
SPDPEDIT

Page 134
 SPDPEDIT

Description Indexes
SYS_C0018218 SYS_C0018218

Page 135
SPDPEDIT

Page 136