just primary key index only.
moreover, sharing the schema with you for 02 tables where issue being occurring. kindly need your assistance in this regards. thank you once again.
-- ----------------------------
-- Table structure for NDEP_HOUSEHOLD_ROSTER
-- ----------------------------
DROP TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER";
CREATE TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER" (
"UNIQUE_HH_ID" NUMBER VISIBLE,
"UNIQUE_R_ID" NUMBER VISIBLE,
"ENUMERATOR_SURVEY_ID" NUMBER VISIBLE,
"R_ID" NUMBER VISIBLE,
"CNIC_ENC" VARCHAR2(250 BYTE) VISIBLE,
"CNIC" VARCHAR2(150 BYTE) VISIBLE,
"HOUSEHOLD_MEMBER_NAMES_ENC" VARCHAR2(250 BYTE) VISIBLE,
"HOUSEHOLD_MEMBER_NAMES" VARCHAR2(250 BYTE) VISIBLE,
"HOUSEHOLD_HEAD_NAME_ENC" VARCHAR2(128 BYTE) VISIBLE,
"HOUSEHOLD_HEAD_NAME" VARCHAR2(128 BYTE) VISIBLE,
"RELATION_TO_HOUSEHOLD_HEAD" NUMBER VISIBLE,
"SPOUSE_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"SPOUSE_NAME" VARCHAR2(250 BYTE) VISIBLE,
"SPOUSE_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
"SPOUSE_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"FATHER_ROSTER_ID" NUMBER VISIBLE,
"FATHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"FATHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
"FATHER_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
"FATHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"MOTHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"MOTHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
"MOTHER_ROSTER_ID" NUMBER VISIBLE,
"MOTHER_CNIC_ENC" VARCHAR2(30 BYTE) VISIBLE,
"MOTHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"RELATION_TO_HOUSEHOLD_HEAD_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"GENDER" VARCHAR2(100 BYTE) VISIBLE,
"DOB" VARCHAR2(100 BYTE) VISIBLE,
"DOB_DATE" DATE VISIBLE,
"AGE" NUMBER VISIBLE,
"AGE_CALCULATION_TIMESTAMP" DATE VISIBLE,
"MARITAL_STATUS_CODE" NUMBER VISIBLE,
"MARITAL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"SPOUSE_CODE" VARCHAR2(200 BYTE) VISIBLE,
"MOTHER_CODE" NUMBER VISIBLE,
"FATHER_CODE" NUMBER VISIBLE,
"CNIC_OPTION" VARCHAR2(2 BYTE) VISIBLE,
"ROSTER_RELATIONAL_ID" NUMBER VISIBLE,
"DISABILITY_CODE" NUMBER VISIBLE,
"DISABILITY_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"HAVING_CHRONIC_DISEASE_CODE" NUMBER VISIBLE,
"HAVING_CHRONIC_DISEASE_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"IS_LITERATE" VARCHAR2(3 BYTE) VISIBLE,
"GONE_TO_SCHOOL_CODE" NUMBER VISIBLE,
"GONE_TO_SCHOOL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"EDUCATION_LEVEL_CODE" NUMBER VISIBLE,
"EDUCATION_LEVEL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"WORK_STATUS_CODE" NUMBER VISIBLE,
"WORK_STATUS" VARCHAR2(200 BYTE) VISIBLE,
"LAST_WEEK_WORKING_HOURS" NUMBER VISIBLE,
"EMPLOYMENT_CODE" NUMBER VISIBLE,
"EMPLOYMENT_STATUS" VARCHAR2(200 BYTE) VISIBLE,
"SURVEY_DATA_SOURCE" VARCHAR2(100 BYTE) VISIBLE,
"INSERTION_TIMESTAMP" DATE VISIBLE,
"FORM_NO" VARCHAR2(500 BYTE) VISIBLE,
"UUID" VARCHAR2(200 BYTE) VISIBLE,
"NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"SPOUSE_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"FATHER_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"MARITAL_STATUS_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"GENDER_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"DOB_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"IS_DUP" VARCHAR2(20 BYTE) VISIBLE,
"NADRA_UPDATED" VARCHAR2(20 BYTE) VISIBLE
)
LOGGING
ROW STORE COMPRESS BASIC
PCTFREE 10
INITRANS 1
STORAGE (
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
ENABLE ROW MOVEMENT
;
-- ----------------------------
-- Records of NDEP_HOUSEHOLD_ROSTER
-- ----------------------------
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580722', '3794103', '19580722', ' ', NULL, 'Manisha bibi', 'Manisha bibi', NULL, NULL, '187', NULL, 'shakir amin', NULL, '4250112313841', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Dec 1, 1995', NULL, '22', NULL, '201', 'married', '1', '-3', '-3', '1', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580723', '3794103', '19580723', ' ', NULL, 'Abhia bibi', 'Abhia bibi', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'shakir amin', NULL, '4250112313841', NULL, 'nadia', NULL, NULL, NULL, NULL, 'female', 'Dec 1, 2015', NULL, '2', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '3', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794103', '30000019580724', '3794103', '19580724', ' ', NULL, 'Noor bibi', 'Noor bibi', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'shakir amin', NULL, '4250112313841', NULL, 'nadia', NULL, NULL, NULL, NULL, 'female', 'Jun 1, 2017', NULL, '0', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '4', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:50', 'SYYYY-MM-DD HH24:MI:SS'), '13932267', '1bbf596a-10f2-4326-94af-df6a843ef9cf', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794107', '30000019580736', '3794107', '19580736', ' ', NULL, 'Muhammad jawaid', 'Muhammad jawaid', NULL, NULL, '186', NULL, 'kawita', NULL, '4420686044084', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Dec 1, 1992', NULL, '25', NULL, '201', 'married', '2', '-2', '-2', '1', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:43:51', 'SYYYY-MM-DD HH24:MI:SS'), '13932299', 'e84e182b-29b9-4b77-ac13-ee940e4228c1', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794107', '30000019580738', '3794107', '19580738', ' ', NULL, 'Muhammad ayan ', 'Muhammad ayan', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'ashok kumar', NULL, '4420622309489', NULL, 'kawita', NULL, NULL, '4420686044084', NULL, 'male', 'Jul 1, 2017', NULL, '0', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '3', '6', 'no disability', '15', 'no', ' ', '0', NULL, '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:43:51', 'SYYYY-MM-DD HH24:MI:SS'), '13932299', 'e84e182b-29b9-4b77-ac13-ee940e4228c1', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794208', '30000019581288', '3794208', '19581288', ' ', NULL, 'Muhammad Sajid', 'Muhammad Sajid', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'Muhammad slaeem', NULL, '3110179846641', NULL, 'Bushra bibi', NULL, NULL, NULL, NULL, 'male', 'Dec 1, 2010', NULL, '7', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '5', '6', 'no disability', '16', 'heart disease', ' ', '27', 'currently going (from people aged four years or older)', '28', 'less than first class', '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:46:55', 'SYYYY-MM-DD HH24:MI:SS'), '13561781', '22ae6d57-01aa-48d5-b422-92192b03571a', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794208', '30000019581289', '3794208', '19581289', ' ', NULL, 'Muhammad Rashid', 'Muhammad Rashid', NULL, NULL, '188', NULL, NULL, NULL, NULL, NULL, NULL, 'Muhammad slaeem', NULL, '3110179846641', NULL, 'Bushra bibi', NULL, NULL, NULL, NULL, 'male', 'Dec 1, 2012', NULL, '5', NULL, '200', 'unmarried', '-1', '2', '1', '-1', '6', '6', 'no disability', '15', 'no', ' ', '25', 'never', '0', NULL, '0', NULL, '0', '0', NULL, 'pilot', TO_DATE('2017-12-07 20:46:55', 'SYYYY-MM-DD HH24:MI:SS'), '13561781', '22ae6d57-01aa-48d5-b422-92192b03571a', NULL, NULL, NULL, NULL, NULL, NULL, 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794216', '30000019581326', '3794216', '19581326', '31201-0347703-7', '3120103477037', 'Muhammad Ishaque', 'Muhammad Ishaque', NULL, NULL, '186', NULL, 'asifa', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1968', NULL, '49', NULL, '201', 'married', '2', '-3', '-2', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '36', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13561381', 'e2cb40d7-09f6-4d27-ba08-771622bd7e1f', 'muhammad ishaq', 'shabiran', 'manzoor ahmad', 'married', 'male', '00-00-1968', 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794216', '30000019581327', '3794216', '19581327', '31201-8867606-6', '3120188676066', 'Samira Bibi', 'Samira Bibi', NULL, NULL, '187', NULL, 'Muhammad ali', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jul 1, 1980', NULL, '37', NULL, '201', 'married', '1', '-3', '-3', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13561381', 'e2cb40d7-09f6-4d27-ba08-771622bd7e1f', 'sumairan bibi', 'muhammad ishaq', 'lalo khan', 'married', 'female', '01-01-1981', 'no', NULL);
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER" VALUES ('30000003794225', '30000019581371', '3794225', '19581371', '31201-2863055-8', '3120128630558', 'Momina bibi', 'Momina bibi', NULL, NULL, '193', NULL, 'Hurmi', NULL, '4410386977168', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'son-in-law', 'female', 'Jan 1, 1975', NULL, '42', NULL, '201', 'married', '2', '-3', '-2', '2', '3', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-12-07 20:46:56', 'SYYYY-MM-DD HH24:MI:SS'), '13805398', '0efcd3c6-0f42-4fa6-a158-ee2938cf8184', 'momina bibi', 'muhammad akmal', 'kalo khan', 'married', 'female', '01-01-1975', 'no', NULL);
-- ----------------------------
-- Table structure for NDEP_HOUSEHOLD_ROSTER_HIS
-- ----------------------------
DROP TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS";
CREATE TABLE "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" (
"UNIQUE_HH_ID" NUMBER VISIBLE,
"UNIQUE_R_ID" NUMBER VISIBLE,
"ENUMERATOR_SURVEY_ID" NUMBER VISIBLE,
"R_ID" NUMBER VISIBLE,
"CNIC_ENC" VARCHAR2(250 BYTE) VISIBLE,
"CNIC" VARCHAR2(150 BYTE) VISIBLE,
"HOUSEHOLD_MEMBER_NAMES_ENC" VARCHAR2(250 BYTE) VISIBLE,
"HOUSEHOLD_MEMBER_NAMES" VARCHAR2(250 BYTE) VISIBLE,
"HOUSEHOLD_HEAD_NAME_ENC" VARCHAR2(128 BYTE) VISIBLE,
"HOUSEHOLD_HEAD_NAME" VARCHAR2(128 BYTE) VISIBLE,
"RELATION_TO_HOUSEHOLD_HEAD" NUMBER VISIBLE,
"SPOUSE_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"SPOUSE_NAME" VARCHAR2(250 BYTE) VISIBLE,
"SPOUSE_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
"SPOUSE_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"FATHER_ROSTER_ID" NUMBER VISIBLE,
"FATHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"FATHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
"FATHER_CNIC_ENC" VARCHAR2(40 BYTE) VISIBLE,
"FATHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"MOTHER_NAME_ENC" VARCHAR2(250 BYTE) VISIBLE,
"MOTHER_NAME" VARCHAR2(250 BYTE) VISIBLE,
"MOTHER_ROSTER_ID" NUMBER VISIBLE,
"MOTHER_CNIC_ENC" VARCHAR2(30 BYTE) VISIBLE,
"MOTHER_CNIC" VARCHAR2(100 BYTE) VISIBLE,
"RELATION_TO_HOUSEHOLD_HEAD_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"GENDER" VARCHAR2(100 BYTE) VISIBLE,
"DOB" VARCHAR2(100 BYTE) VISIBLE,
"DOB_DATE" DATE VISIBLE,
"AGE" NUMBER VISIBLE,
"AGE_CALCULATION_TIMESTAMP" DATE VISIBLE,
"MARITAL_STATUS_CODE" NUMBER VISIBLE,
"MARITAL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"SPOUSE_CODE" VARCHAR2(200 BYTE) VISIBLE,
"MOTHER_CODE" NUMBER VISIBLE,
"FATHER_CODE" NUMBER VISIBLE,
"CNIC_OPTION" VARCHAR2(2 BYTE) VISIBLE,
"ROSTER_RELATIONAL_ID" NUMBER VISIBLE,
"DISABILITY_CODE" NUMBER VISIBLE,
"DISABILITY_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"HAVING_CHRONIC_DISEASE_CODE" NUMBER VISIBLE,
"HAVING_CHRONIC_DISEASE_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"IS_LITERATE" VARCHAR2(3 BYTE) VISIBLE,
"GONE_TO_SCHOOL_CODE" NUMBER VISIBLE,
"GONE_TO_SCHOOL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"EDUCATION_LEVEL_CODE" NUMBER VISIBLE,
"EDUCATION_LEVEL_STATUS" VARCHAR2(100 BYTE) VISIBLE,
"WORK_STATUS_CODE" NUMBER VISIBLE,
"WORK_STATUS" VARCHAR2(200 BYTE) VISIBLE,
"LAST_WEEK_WORKING_HOURS" NUMBER VISIBLE,
"EMPLOYMENT_CODE" NUMBER VISIBLE,
"EMPLOYMENT_STATUS" VARCHAR2(200 BYTE) VISIBLE,
"SURVEY_DATA_SOURCE" VARCHAR2(100 BYTE) VISIBLE,
"INSERTION_TIMESTAMP" DATE VISIBLE,
"FORM_NO" VARCHAR2(500 BYTE) VISIBLE,
"UUID" VARCHAR2(200 BYTE) VISIBLE,
"NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"SPOUSE_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"FATHER_NAME_NADRA" VARCHAR2(400 BYTE) VISIBLE,
"MARITAL_STATUS_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"GENDER_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"DOB_NADRA" VARCHAR2(100 BYTE) VISIBLE,
"IS_DUP" VARCHAR2(20 BYTE) VISIBLE
)
LOGGING
ROW STORE COMPRESS BASIC
PCTFREE 10
INITRANS 1
STORAGE (
INITIAL 65536
NEXT 1048576
MINEXTENTS 1
MAXEXTENTS 2147483645
BUFFER_POOL DEFAULT
)
PARALLEL 1
NOCACHE
ENABLE ROW MOVEMENT
;
-- ----------------------------
-- Records of NDEP_HOUSEHOLD_ROSTER_HIS
-- ----------------------------
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000001673486', '30000008708330', '1673486', '8708330', '32202-4968821-5', '3220249688215', 'Zulafqar', 'Zulafqar', NULL, NULL, '186', NULL, 'zuhra', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', '1 Jan 1970', NULL, '47', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-05-26 21:02:19', 'SYYYY-MM-DD HH24:MI:SS'), '11812654', '2d96259d-bea6-4220-8117-49a7991734f6', 'zulfiqar', 'sharifan mai', 'allah wasaya', 'married', 'male', '01-01-1970', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002391612', '30000012290821', '2391612', '12290821', '32203-1938854-0', '3220319388540', 'Fatima Bibi', 'Fatima Bibi', NULL, NULL, '190', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'father', 'female', '1 Jan 1958', NULL, '59', NULL, '202', 'widow', '-1', '-3', '-2', '2', '4', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '61', 'other', 'pilot', TO_DATE('2017-07-13 18:09:20', 'SYYYY-MM-DD HH24:MI:SS'), '13248869', 'fac3c877-69bc-47c9-ae65-5e1f301b78fa', 'fatima bibi', 'imam bux', 'faiz ahmad', 'married', 'female', '00-00-1958', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002408915', '30000012378281', '2408915', '12378281', '21406-9515390-3', '2140695153903', 'Muhammad Khan', 'Muhammad Khan', NULL, NULL, '186', NULL, 'Shereen', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1990', NULL, '27', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-14 15:56:55', 'SYYYY-MM-DD HH24:MI:SS'), '11160918', '87b5d31c-fb26-4c11-9102-24b95b6b4c9f', 'muhammad khan', 'saeeda', 'gul jan', 'married', 'male', '01-01-1990', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002408919', '30000012378306', '2408919', '12378306', '21406-7793939-2', '2140677939392', 'Fashmina Bibi', 'Fashmina Bibi', NULL, NULL, '187', NULL, 'Parwiz Ail', NULL, '5210310607803', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jan 1, 1974', NULL, '43', NULL, '201', 'married', '1', '-3', '-3', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '59', 'co-worker / helper in unpaid family profession)', 'pilot', TO_DATE('2017-07-14 15:56:56', 'SYYYY-MM-DD HH24:MI:SS'), '11160923', 'a19f2d02-3454-440f-95b3-4d73ef8504fc', 'pashmina bibi', 'ajmal khan', 'muhammad aziz', 'married', 'female', '00-00-1974', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002418861', '30000012428654', '2418861', '12428654', '41407-5523777-9', '4140755237779', 'Qasim Chandyo ', 'Qasim Chandyo', NULL, NULL, '186', NULL, 'parie', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jan 1, 1994', NULL, '23', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-14 22:26:39', 'SYYYY-MM-DD HH24:MI:SS'), '14163854', '24d9674e-4832-416c-8cea-6d1de554831f', NULL, NULL, NULL, NULL, NULL, NULL, 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000049289', '30000000227569', '49289', '227569', '17101-0331575-9', '1710103315759', 'fazlerahman', 'fazlerahman', NULL, NULL, '186', NULL, 'Tahir Abbas', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Apr 4, 1980', NULL, '37', NULL, '201', 'married', '2', '-1', '-2', '2', '1', '6', 'no disability', '15', 'no', 'yes', '26', 'has been in the past', '38', 'tenth', '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-02 09:16:51', 'SYYYY-MM-DD HH24:MI:SS'), '11137009', 'c2271b0c-2085-49c2-a358-49a04930a7eb', 'fazal rehman', NULL, 'abdul karim', 'married', 'male', '01-04-1980', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000049289', '30000000227570', '49289', '227570', '17101-7603158-0', '1710176031580', 'Abida', 'Abida', NULL, NULL, '187', NULL, 'Shehnaz Tahir', NULL, '3130281673584', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', 'Jan 1, 1987', NULL, '30', NULL, '201', 'married', '1', '-3', '-2', '2', '2', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-02 09:16:51', 'SYYYY-MM-DD HH24:MI:SS'), '11137009', 'c2271b0c-2085-49c2-a358-49a04930a7eb', 'abida', 'fazal rehman', 'bahadar khan', 'married', 'female', '01-01-1987', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000170954', '30000000843702', '170954', '843702', '32202-2440992-6', '3220224409926', 'Banaizeer ', 'Banaizeer', NULL, NULL, '187', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'female', '1 Jan 1960', NULL, '57', NULL, '201', 'married', '-1', '-1', '-2', '2', '2', '6', 'no disability', '18', 'asthma', 'no', '25', 'never', '0', NULL, '50', 'unemployed but looking for a job', '0', '217', 'unemployed', 'pilot', TO_DATE('2017-03-14 09:10:20', 'SYYYY-MM-DD HH24:MI:SS'), '13105026', 'fff4a097-7f96-47fd-8bf0-fa67f6cc9f30', 'benazir', 'haq nawaz', NULL, 'married', 'female', '00-00-1960', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000000174199', '30000000860786', '174199', '860786', '43102-8336297-3', '4310283362973', 'akbar ali', 'akbar ali', NULL, NULL, '186', NULL, 'Shezana Munir', NULL, '3420160232222', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', 'Jun 29, 1984', NULL, '33', NULL, '201', 'married', '2', '-1', '-2', '2', '1', '6', 'no disability', '15', 'no', 'yes', '27', 'currently going (from people aged four years or older)', '40', 'fa / fsc / icom', '51', 'neither employment nor job seeker burden retired minutes, student, housewife, disability etc.', '0', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-03-14 18:46:00', 'SYYYY-MM-DD HH24:MI:SS'), '14336219', 'ee1d97e7-003a-4e96-ab4c-03fa8ecd2615', 'akbar ali', NULL, 'jamal khan', 'unmarried', 'male', '29-06-1984', 'no');
INSERT INTO "MNASIR"."NDEP_HOUSEHOLD_ROSTER_HIS" VALUES ('30000002351064', '30000012082710', '2351064', '12082710', '32203-1784560-3', '3220317845603', 'Muhammad Aziz ', 'Muhammad Aziz', NULL, NULL, '186', NULL, 'Ghulam batola', NULL, '4120561529630', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'head', 'male', '1 Jan 1973', NULL, '44', NULL, '201', 'married', '2', '-3', '-3', '2', '1', '6', 'no disability', '15', 'no', 'no', '25', 'never', '0', NULL, '49', 'employers', '48', '56', 'seasonal wage employment / wage (non-agricultural)', 'pilot', TO_DATE('2017-07-11 10:23:51', 'SYYYY-MM-DD HH24:MI:SS'), '13195340', '892dbe84-9bb6-4a6b-b767-012e1156b84e', 'muhammad aziz', 'uzma bibi', 'abdul rehman', 'married', 'male', '00-00-1973', 'no');