HMIS_Types.sql

DROP TABLE IF EXISTS "v2016".hmis_type;
CREATE TABLE "v2016".hmis_type
(
  "id" serial NOT NULL ,
  "name" character(50) NOT NULL,
  "value" character(50) NOT NULL,
  "description" text,
  "year" bigint,
  "status" character(10),
  "expiration_date" timestamp,
  "date_created" timestamp,
  "date_updated" timestamp,
  "user_id" uuid,
  CONSTRAINT hmis_type_pk PRIMARY KEY ("id")
);
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('literalHomelessHistory','0','4 or more times or total of at least 12 months in past three years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('literalHomelessHistory','1','2-3 times in past three years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('literalHomelessHistory','2','1 time in past three years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('literalHomelessHistory','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('annualpercentami','0','0-14% of AMI for household size','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('annualpercentami','1','15-30% of AMI for household size','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('annualpercentami','2','More than 30% of AMI for household size (0 points)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('annualpercentami','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timeToHousingLoss','0','0-6 days','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timeToHousingLoss','1','7-13 days','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timeToHousingLoss','2','14-21 days','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timeToHousingLoss','3','More than 21 days (0 points)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timeToHousingLoss','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('zeroincome','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('zeroincome','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('zeroincome','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('financialchange','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('financialchange','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('financialchange','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('evictionhistory','0','4 or more prior rental evictions','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('evictionhistory','1','2-3 prior rental evictions','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('evictionhistory','2','1 prior rental eviction','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('evictionhistory','3','No prior rental evictions (0 points)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('evictionhistory','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdchange','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdchange','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdchange','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyatrisk','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyatrisk','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyatrisk','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disablehoh','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disablehoh','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disablehoh','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('criminalrecord','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('criminalrecord','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('criminalrecord','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexoffender','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexoffender','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexoffender','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dependendunder6','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dependendunder6','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dependendunder6','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('singleparent','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('singleparent','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('singleparent','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hh5plus','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hh5plus','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hh5plus','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraqafghanistan','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraqafghanistan','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraqafghanistan','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('femvet','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('femvet','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('femvet','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('losunderthreshold','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('losunderthreshold','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('losunderthreshold','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('previousStreetESSH','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('previousStreetESSH','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('previousStreetESSH','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','0','0','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','1','1-2','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','2','3-5','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','3','6-10','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','4','11-20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','5','More than 20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ervisits','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','0','0','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','1','1-2','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','2','3-5','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','3','6-10','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','4','11-20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','5','More than 20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('jailnights','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','0','0','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','1','1-2','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','2','3-5','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','3','6-10','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','4','11-20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','5','More than 20','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('hospitalnights','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('world_war_2','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('world_war_2','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('world_war_2','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('world_war_2','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('world_war_2','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('korean_war','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('korean_war','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('korean_war','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('korean_war','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('korean_war','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('vietnam_war','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('vietnam_war','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('vietnam_war','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('vietnam_war','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('vietnam_war','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('desertstorm','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('desertstorm','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('desertstorm','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('desertstorm','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('desertstorm','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_oif','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_oif','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_oif','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_oif','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_oif','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_ond','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_ond','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_ond','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_ond','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('iraq_ond','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_theater','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_theater','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_theater','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_theater','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_theater','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employed','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employed','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employed','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employed','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employed','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('address_data_quality','1','Full address reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('address_data_quality','2','Incomplete or estimated address reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('address_data_quality','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('address_data_quality','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('address_data_quality','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('askedorforcedtoexchangeforsex','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('askedorforcedtoexchangeforsex','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('askedorforcedtoexchangeforsex','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('askedorforcedtoexchangeforsex','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('askedorforcedtoexchangeforsex','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','1', 'Referred to emergency shelter/safe haven','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','2', 'Referred to transitional housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','3', 'Referred to rapid re-housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','4', 'Referred to permanent supportive housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','5', 'Referred to homelessness prevention','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','6', 'Referred to street outreach','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','7', 'Referred to other continuum project type','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','8', 'Referred to a homelessness diversion program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','9', 'Unable to refer/accept within continuum; ineligible for continuum projects','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','10','Unable to refer/accept within continuum; continuum services unavailable','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','11','Referred to other community project (non-continuum)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','12','Applicant declined referral/acceptance','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','13','Applicant terminated assessment prior to completion','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assessmentdisposition','14','Other/specify','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('availabilty','1','Year-round','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('availabilty','2','Seasonal','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('availabilty','3','Overflow','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('bedtype','1','Facility-based','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('bedtype','2','Voucher','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('bedtype','3','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','1','1-3','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','2','4-7','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','3','8-30','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','4','More than 30','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('countofexchangeforsex','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','5','Physical Disability','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','6','Developmental Disability','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','7','Chronic Health Condition','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','8','HIV/AIDS','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','9','Mental Health Problem','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('disabilitytype','10','Substance Abuse','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','1','Honorable','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','2','General under honorable conditions','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','4','Bad conduct','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','5','Dishonorable','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','6','Under other than honorable conditions (OTH)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','7','Uncharacterized','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('discharge_status','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dob_data_quality','1','Full DOB reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dob_data_quality','2','Approximate or partial DOB reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dob_data_quality','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dob_data_quality','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('dob_data_quality','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','1','Left for other opportunities – Independent living','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','2','Left for other opportunities - Education','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','3','Left for other opportunities - Military','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','4','Left for other opportunities - Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','5','Needs could not be met by project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('earlyexitreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employment_type','1','Full-time','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employment_type','2','Part-time','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employment_type','3','Seasonal / sporadic (including day labor)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('employment_type','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ethnicity','0','Non-Hispanic/Non-Latino','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ethnicity','1','Hispanic/Latino','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ethnicity','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ethnicity','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ethnicity','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','24','Deceased','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','1','Emergency shelter, including hotel or motel paid for with emergency shelter voucher','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','15','Foster care home or foster care group home','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','6','Hospital or other residential non-psychiatric medical facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','14','Hotel or motel paid for without emergency shelter voucher','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','7','Jail, prison or juvenile detention facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','25','Long-term care facility or nursing home','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','26','Moved from one HOPWA funded project to HOPWA PH ','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','27','Moved from one HOPWA funded project to HOPWA TH','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','11','Owned by client, no ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','21','Owned by client, with ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','3','Permanent housing for formerly homeless persons (such as: CoC project; or HUD legacy programs; or HOPWA PH)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','16','Place not meant for habitation (e.g., a vehicle, an abandoned building, bus/train/subway station/airport or anywhere outside)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','4','Psychiatric hospital or other psychiatric facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','10','Rental by client, no ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','19','Rental by client, with VASH housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','28','Rental by client, with GPD TIP housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','20','Rental by client, with other ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','29','Residential project or halfway house with no homeless criteria','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','18','Safe Haven','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','22','Staying or living with family, permanent tenure','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','12','Staying or living with family, temporary tenure (e.g., room, apartment or house)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','23','Staying or living with friends, permanent tenure','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','13','Staying or living with friends, temporary tenure (e.g., room apartment or house)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','5','Substance abuse treatment facility or detox center ','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','2','Transitional housing for homeless persons (including homeless youth)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','17','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','30','No exit interview completed','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('destination','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','1','HUD:CoC – Homelessness Prevention (High Performing Comm. Only)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','2','HUD:CoC – Permanent Supportive Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','3','HUD:CoC – Rapid Re-Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','4','HUD:CoC – Supportive Services Only','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','5','HUD:CoC – Transitional Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','6','HUD:CoC – Safe Haven','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','7','HUD:CoC – Single Room Occupancy (SRO)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','8','HUD:ESG – Emergency Shelter (operating and/or essential services)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','9','HUD:ESG – Homelessness Prevention','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','10','HUD:ESG – Rapid Rehousing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','11','HUD:ESG – Street Outreach','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','12','HUD:Rural Housing Stability Assistance Program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','13','HUD:HOPWA – Hotel/Motel Vouchers','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','14','HUD:HOPWA – Housing Information','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','15','HUD:HOPWA – Permanent Housing (facility based or TBRA)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','16','HUD:HOPWA – Permanent Housing Placement','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','17','HUD:HOPWA – Short-Term Rent, Mortgage, Utility assistance','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','18','HUD:HOPWA – Short-Term Supportive Facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','19','HUD:HOPWA – Transitional Housing (facility based or TBRA)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','20','HUD:HUD/VASH','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','21','HHS:PATH – Street Outreach and Supportive Services Only','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','22','HHS:RHY – Basic Center Program (prevention and shelter)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','23','HHS:RHY – Maternity Group Home for Pregnant and Parenting Youth','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','24','HHS:RHY – Transitional Living Program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','25','HHS:RHY – Street Outreach Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','26','HHS:RHY – Demonstration Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','27','VA: Community Contract Emergency Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','28','VA: Community Contract Residential Treatment Program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','29','VA:Domiciliary Care','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','30','VA:Community Contract Safe Haven Program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','31','VA:Grant and Per Diem Program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','32','VA:Compensated Work Therapy Transitional Residence','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','33','VA:Supportive Services for Veteran Families','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('funder','34','N/A','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_no_services','1','Out of age range','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_no_services','2','Ward of the State – Immediate Reunification','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_no_services','3','Ward of the Criminal Justice System – Immediate Reunification','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_no_services','4','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_no_services','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','0','Female','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','1','Male','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','2','Transgender male to female','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','3','Transgender female to male','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','4','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('gender','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_category','27','General Health Status','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_category','28','Dental Health Status','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_category','29','Mental Health Status','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','1','Excellent','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','2','Very good','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','3','Good','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','4','Fair','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','5','Poor','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_status','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdtype','1','Households without children','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdtype','3','Households with at least one adult and one child','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('householdtype','4','Households with only children','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','1','Able to maintain the housing they had at project entry','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','2','Moved to new housing unit','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','3','Moved in with family/friends on a temporary basis','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','4','Moved in with family/friends on a permanent basis ','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','5','Moved to a transitional or temporary housing facility or program','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','6','Client became homeless – moving to a shelter or other place unfit for human habitation','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','7','Client went to jail/prison','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','10','Client died ','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingassessment','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarceratedparentstatus','1','One parent / legal guardian is incarcerated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarceratedparentstatus','2','One parent / legal guardian is incarcerated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarceratedparentstatus','3','The only parent / legal guardian is incarcerated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarceratedparentstatus','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('juvenilejusticeyears','1','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('juvenilejusticeyears','2','1 to 2 years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('juvenilejusticeyears','3','3 to 5 or more years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('childwelfareyears','1','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('childwelfareyears','2','1 to 2 years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('childwelfareyears','3','3 to 5 or more years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','1','Army','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','2','Air Force','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','3','Navy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','4','Marines','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','6','Coast Guard','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('military_branch','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','100','0 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','101','1 month','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','102','2 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','103','3 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','104','4 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','105','5 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','106','6 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','107','7 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','108','8 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','109','9 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','110','10 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','111','11 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','112','12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','7','More than 12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','1','More than 12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessPastThreeYears','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','100','0 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','101','1 month','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','102','2 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','103','3 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','104','4 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','105','5 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','106','6 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','107','7 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','108','8 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','109','9 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','110','10 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','111','11 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','112','12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','7','More than 12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','1','More than 12 months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('monthsHomelessThisTime','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('name_data_quality','1','Full name reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('name_data_quality','2','Partial, street name, or code name reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('name_data_quality','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('name_data_quality','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('name_data_quality','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noadapreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nocobrareason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noemployerprovidedreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicaidreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nomedicarereason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noprivatepayreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('noschipreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nostatehealthinsreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('novamedreason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','1','Applied; decision pending','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','2','Applied; client not eligible','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','3','Client did not apply','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','4','Insurance type N/A for this client','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('nohivaidsassistancereason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('not_employed_reason','1','Looking for work','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('not_employed_reason','2','Unable to work','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('not_employed_reason','3','Not looking for work','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('not_employed_reason','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathhowconfirmed','1','Unconfirmed; presumptive or self-report','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathhowconfirmed','2','Confirmed through assessment and clinical evaluation','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathhowconfirmed','3','Confirmed by prior evaluation or clinical records','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathhowconfirmed','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','1','Unconfirmed; presumptive or self-report','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','2','Confirmed through assessment and clinical evaluation','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','3','Confirmed by prior evaluation or clinical records','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('pathsmiinformation','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projectcompletionstatus','1','Completed project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projectcompletionstatus','2','Youth voluntarily left early','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projectcompletionstatus','3','Youth was expelled or otherwise involuntarily discharged from project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projectcompletionstatus','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','1','American Indian or Alaska Native','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','2','Asian','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','3','Black or African American','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','4','Native Hawaiian or Other Pacific Islander','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','5','White','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('race','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','1','Emergency Shelter','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','2','Transitional Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','3','PH - Permanent Supportive Housing (disability required for entry)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','4','Street Outreach','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','6','Services Only','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','7','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','8','Safe Haven','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','9','PH – Housing Only','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','10','PH – Housing with Services (no disability required for entry)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','11','Day Shelter','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','12','Homelessness Prevention','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','13','PH - Rapid Re-Housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','14','Coordinated Assessment','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_not_enrolled','1','Client was found ineligible for PATH','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_not_enrolled','2','Client was not enrolled for other reason(s)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('reason_not_enrolled','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','12','Contact','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','14','Services Provided','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','15','Financial Assistance','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','16','Referrals Provided','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','141','PATH service','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','142','RHY service','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','143','HOPWA service','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','144','SSVF service','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','151','HOPWA financial assistance','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','152','SSVF financial assistance','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','161','PATH referral','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','162','RHY referral','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('projecttype','200','Bed night','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referraloutcome','1','Attained','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referraloutcome','2','Not Attained','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referraloutcome','3','Unkown','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','1','Self-Referral','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','2','Individual: Parent/Guardian','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','3','Individual: Relative or Friend','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','4','Individual: Other Adult or Youth','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','5','Individual: Partner/Spouse','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','6','Individual: Foster Parent','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','7','Outreach Project: FYSB','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','10','Outreach Project: Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','11','Temporary Shelter: FYSB Basic Center Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','12','Temporary Shelter: Other Youth Only Emergency Shelter','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','13','Temporary Shelter: Emergency Shelter for Families','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','14','Temporary Shelter: Emergency Shelter for Individuals','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','15','Temporary Shelter: Domestic Violence Shelter','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','16','Temporary Shelter: Safe Place','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','17','Temporary Shelter: Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','18','Residential Project: FYSB Transitional Living Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','19','Residential Project: Other Transitional Living Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','20','Residential Project: Group Home','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','21','Residential Project: Independent Living Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','22','Residential Project: Job Corps','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','23','Residential Project: Drug Treatment Center','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','24','Residential Project: Treatment Center','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','25','Residential Project: Educational Institute','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','26','Residential Project: Other Agency project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','27','Residential Project: Other Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','28','Hotline: National Runaway Switchboard','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','29','Hotline: Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','30','Other Agency: Child Welfare/CPS','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','31','Other Agency: Non-Residential Independent Living Project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','32','Other Project Operated by your Agency','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','33','Other Youth Services Agency','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','34','Juvenile Justice','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','35','Law Enforcement/ Police','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','36','Religious Organization','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','37','Mental Hospital','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','38','School','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','39','Other Organization','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('relationshiptohoh','1','Self (head of household)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('relationshiptohoh','2','Head of household’s child','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('relationshiptohoh','3','Head of household’s spouse or partner','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('relationshiptohoh','4','Head of household’s other relation member (other relation to head of household)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('relationshiptohoh','5','Other: non-relation member','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','1','Emergency shelter, including hotel or motel paid for with emergency shelter voucher','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','2','Transitional housing for homeless persons (including homeless youth)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','3','Permanent housing for formerly homeless persons (such as: CoC project; HUD legacy programs; or HOPWA PH)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','4','Psychiatric hospital or other psychiatric facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','5','Substance abuse treatment facility or detox center','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','6','Hospital or other residential non-psychiatric medical facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','7','Jail, prison or juvenile detention facility','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePrior','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','12','Staying or living in a family member’s room, apartment or house','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','13','Staying or living in a friend’s room, apartment or house','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','14','Hotel or motel paid for without emergency shelter voucher','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','15','Foster care home or foster care group home','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','16','Place not meant for habitation (e.g. a vehicle, an abandoned building, bus/train/subway station/airport or anywhere outside)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','17','Other','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','18','Safe Haven','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','19','Rental by client, with VASH subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','20','Rental by client, with other ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','21','Owned by client, with ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','22','Rental by client, no ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','23','Owned by client, no ongoing housing subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','24','Long-term care facility or nursing home','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','25','Rental by client, with GPD TIP subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','26','Residential project or halfway house with no homeless criteria','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('referralsource','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','2','More than one week, but less than one month','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','3','One to three months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','4','More than three months, but less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','5','One year or longer','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','8','Client doesn''t know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','10','One day or less','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','11','Two days to one week','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('residencePriorlengthofstay','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ssn_data_quality','1','Full SSN reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ssn_data_quality','2','Approximate or partial SSN reported','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ssn_data_quality','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ssn_data_quality','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('ssn_data_quality','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyinformation','1','Without a subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyinformation','2','With the subsidy they had at project entry','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyinformation','3','With an on-going subsidy acquired since project entry','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('subsidyinformation','4','Only with financial assistance other than a subsidy','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('targetpopulation','1','DV Domestic Violence victims','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('targetpopulation','3','HIV Persons with HIV/AIDS','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('targetpopulation','4','NA Not Applicable','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','0','0 (not homeless - Prevention only)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','1','1 (homeless only this time)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','2','2','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','3','3','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','4','4 or more','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('timesHomelesspastthreeyears','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('trackingmethod','0','Entry/Exit Date','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('trackingmethod','3','Night-by-Night','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','1','Within the past three months','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','2','Three to six months ago (excluding six months exactly)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','3','Six months to one year ago (excluding one year exactly)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','4','One year ago or more','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('whenoccurred','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','1','Category 1 - Homeless','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','2','Category 2 - At imminent risk of losing housing','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','3','At-risk of homelessness','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','4','Stably Housed','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','5','Category 3 - Homeless only under other federal statutes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','6','Category 4 - Fleeing domestic violence','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housingstatus','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('youth_age_group','1','Only under age 18','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('youth_age_group','2','Only ages 18 to 24','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('youth_age_group','3','Only youth under age 24 (both of the above)','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('veteran_status','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('veteran_status','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('veteran_status','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('veteran_status','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('veteran_status','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('afghanistan_oef','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('afghanistan_oef','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('afghanistan_oef','8','Client does not know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('afghanistan_oef','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('afghanistan_oef','99','Data not collected')-- New ENUMSINSERT Starts
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('percentami','1','Less than 30%','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('percentami','2','30% to 50%','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('percentami','3','Greater than 50%','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('percentami','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('connection_with_soar','0','No%','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('connection_with_soar','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('connection_with_soar','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('connection_with_soar','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('connection_with_soar','99','Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('contact_location','1','Place not meant for habitation','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('contact_location','2','Service setting, non-residential','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('contact_location','3','Service setting, residential','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('written_after_care_plan','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('written_after_care_plan','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('written_after_care_plan','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('written_after_care_plan','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assistance_main_stream_benefits','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assistance_main_stream_benefits','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assistance_main_stream_benefits','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('assistance_main_stream_benefits','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('permanent_housing_placement','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('permanent_housing_placement','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('permanent_housing_placement','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('permanent_housing_placement','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('temp_shelter_placement','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('temp_shelter_placement','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('temp_shelter_placement','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('temp_shelter_placement','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exit_counseling','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exit_counseling','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exit_counseling','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exit_counseling','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('further_followup_services','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('further_followup_services','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('further_followup_services','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('further_followup_services','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('scheduled_followup_contacts','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('scheduled_followup_contacts','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('scheduled_followup_contacts','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('scheduled_followup_contacts','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('resource_package','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('resource_package','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('resource_package','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('resource_package','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_aftercare_plan_or_action','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_aftercare_plan_or_action','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_aftercare_plan_or_action','2','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('other_aftercare_plan_or_action','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('family_reunification_achieved','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('family_reunification_achieved','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('family_reunification_achieved','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('family_reunification_achieved','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('family_reunification_achieved','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('project_completion_status','1','Completed project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('project_completion_status','2','Youth voluntarily left early','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('project_completion_status','3','Youth was expelled or otherwise involuntarily discharged from project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('project_completion_status','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','1','if 4.37A: Left for other opportunities – Independent living *OR* if 4.37B: Criminal activity/destruction of property/violence','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','2','if 4.37A: Left for other opportunities - Education *OR* if 4.37B: Non-compliance with project rules','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','3','if 4.37A: Left for other opportunities - Military *OR* if 4.37B: Non-payment of rent/occupancy charge','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','4','if 4.37A: Left for other opportunities - Other *OR* if 4.37B: Reached maximum time allowed by project','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','5','if 4.37A: Needs could not be met by project *OR* if 4.37B: Project terminated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','6','4.37B only: Unknown/disappeared','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('early_exit_reason','99','both 4.37A and 4.37B: Data not collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('active_military_parent','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('active_military_parent','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('active_military_parent','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('house_hold_dynamics','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('house_hold_dynamics','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('house_hold_dynamics','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('insufficient_income_to_support_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('insufficient_income_to_support_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('insufficient_income_to_support_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('alcohol_drug_abuse_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('abuse_and_neglect_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_disability_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('physical_disability_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('health_issues_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_family_mbrily_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_family_mbrily_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_family_mbrily_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('mental_health_issues_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployement_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployement_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployement_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_educational_issues_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_educational_issues_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_educational_issues_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_education_issues_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_education_issues_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('school_education_issues_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployment_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployment_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('unemployment_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('housing_issues_youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientation_gender_identity_Youth','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientation_gender_identity_Youth','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientation_gender_identity_Youth','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientatiion_gender_identity_family_mbr','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientatiion_gender_identity_family_mbr','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('sexual_orientatiion_gender_identity_family_mbr','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_child_welfr_forest_care','1','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_child_welfr_forest_care','2','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_child_welfr_forest_care','3','3 to 5 or more years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_juvenile_justice','1','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_juvenile_justice','2','Less than one year','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('years_juvenile_justice','3','3 to 5 or more years','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_child_welfr_forest_care','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_child_welfr_forest_care','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_child_welfr_forest_care','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_child_welfr_forest_care','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_child_welfr_forest_care','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_of_juvenile_justice','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_of_juvenile_justice','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_of_juvenile_justice','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_of_juvenile_justice','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('formerly_ward_of_juvenile_justice','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex_past_3_months','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex_past_3_months','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex_past_3_months','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex_past_3_months','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex_past_3_months','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exchange_for_sex_past_three_months','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exchange_for_sex_past_three_months','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exchange_for_sex_past_three_months','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exchange_for_sex_past_three_months','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('exchange_for_sex_past_three_months','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('coerced_to_continue_work','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('coerced_to_continue_work','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('coerced_to_continue_work','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('coerced_to_continue_work','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('coerced_to_continue_work','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_promise_difference','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_promise_difference','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_promise_difference','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_promise_difference','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_promise_difference','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_violence_threats','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_violence_threats','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_violence_threats','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_violence_threats','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('work_place_violence_threats','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent_status','1','One parent / legal guardian is incarcerated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent_status','2','One parent / legal guardian is incarcerated','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent_status','3','The only parent / legal guardian is incarceratedt','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('incarcerated_parent_status','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','1','1-3','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','2','4-7','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','3','8-11','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','4','12 or more','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('count_of_exchange_for_sex','99','Data Not Collected','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex','0','No','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex','1','Yes','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex','8','Client doesnt know','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex','9','Client refused','ACTIVE');
INSERT INTO "v2016".hmis_type (name,value,description,status) values ('asked_of_forced_to_exchange_for_sex','99','Data Not Collected','ACTIVE');