Square PEG Data
CREATE TABLE [dbo].[hmis_List](
[id] [int] IDENTITY(1,1) NOT NULL,
[ListNumber] [varchar](12) NULL,
[ListName] [varchar](100) NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[hmis_Values](
[id] [int] IDENTITY(1,1) NOT NULL,
[ListID] [int] NOT NULL,
[HMISValue] [int] NOT NULL,
[HMISText] [varchar](256) NULL
) ON [PRIMARY]
GO
SET IDENTITY_INSERT [dbo].[hmis_List] ON
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (1, N'1.1', N'ExportPeriodType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (2, N'1.2', N'ExportDirective')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (3, N'1.3', N'DisabilityType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (4, N'1.4', N'RecordType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (5, N'1.5', N'HashStatus')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (6, N'1.6', N'RaceNone')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (7, N'1.7', N'No/Yes/Missing')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (8, N'1.8', N'No/Yes/ReasonsForMissingData')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (9, N'1.9', N'SourceType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (10, N'2.4.2', N'ProjectType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (11, N'2.5.1', N'TrackingMethod')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (12, N'2.6.1', N'FundingSource')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (13, N'2.7.5', N'HouseholdType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (14, N'2.7.8', N'BedType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (15, N'2.7.9', N'Availability')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (16, N'2.8.4', N'TargetPopulation')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (17, N'2.8.7', N'GeographyType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (18, N'2.8.8', N'HousingType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (19, N'3.1.5', N'NameDataQuality')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (20, N'3.2.2', N'SSNDataQuality')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (21, N'3.3.2', N'DOBDataQuality')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (22, N'3.5.1', N'Ethnicity')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (23, N'3.6.1', N'Gender')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (24, N'3.12.1', N'Destination')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (25, N'3.15.1', N'RelationshipToHoH')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (26, N'3.917.1', N'LivingSituation')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (27, N'3.917.2', N'LengthOfStay')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (28, N'3.917.4', N'TimesHomelessPastThreeYears')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (29, N'3.917.5', N'MonthsHomelessPastThreeYears')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (30, N'4.4.A', N'ReasonNotInsured')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (31, N'4.10.2', N'DisabilityResponse')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (32, N'4.11.A', N'WhenDVOccurred')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (33, N'4.12.2A', N'ContactLocation')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (34, N'4.12.2B', N'CurrentStreetESSH')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (35, N'4.14', N'BedNight')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (36, N'4.18.1', N'HousingAssessmentDisposition')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (37, N'5.3.1', N'DataCollectionStage')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (38, N'P1.2', N'PATHServices')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (39, N'P2.2', N'PATHReferral')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (40, N'P2.A', N'PATHReferralOutcome')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (41, N'P3.A', N'ReasonNotEnrolled')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (42, N'R1.1', N'ReferralSource')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (43, N'R2.A', N'ReasonNoServices')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (44, N'R3.1', N'SexualOrientation')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (45, N'R4.1', N'LastGradeCompleted')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (46, N'R5.1', N'SchoolStatus')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (47, N'R6.A', N'EmploymentType')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (48, N'R6.B', N'NotEmployedReason')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (49, N'R7.1', N'HealthStatus')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (50, N'R11.A', N'RHYNumberofYears')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (51, N'R14.2', N'RHYServices')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (52, N'R15.B', N'CountExchangeForSex')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (53, N'R17.1', N'ProjectCompletionStatus')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (54, N'R17.A', N'ExpelledReason')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (55, N'R19.A', N'WorkerResponse')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (56, N'R20.2', N'AftercareProvided')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (57, N'V1.11', N'MilitaryBranch')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (58, N'V1.12', N'DischargeStatus')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (59, N'V2.2', N'SSVFServices')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (60, N'V2.A', N'SSVFSubType3')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (61, N'V2.4', N'SSVFSubType4')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (62, N'V2.5', N'SSVFSubType5')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (63, N'V3.3', N'SSVFFinancialAssistance')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (64, N'V4.1', N'PercentAMI')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (65, N'V5.5', N'AddressDataQuality')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (66, N'V7.1', N'NoPointsYes')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (67, N'V7.2', N'TimeToHousingLoss')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (68, N'V7.4', N'AnnualPercentAMI')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (69, N'V7.7', N'EvictionHistory')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (70, N'V7.9', N'LiteralHomelessHistory')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (71, N'V8.1', N'VoucherTracking')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (72, N'V9.1', N'CMExitReason')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (73, N'W1.2', N'HOPWAServices')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (74, N'W2.3', N'HOPWAFinancialAssistance')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (75, N'W3', N'NoAssistanceReason')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (76, N'W4.3', N'ViralLoadAvailable')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (77, N'W4.B', N'TCellSource/ViralLoadSource')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (78, N'W5.1', N'HousingAssessmentAtExit')
INSERT [dbo].[hmis_List] ([id], [ListNumber], [ListName]) VALUES (79, N'W5.A', N'SubsidyInformation')
SET IDENTITY_INSERT [dbo].[hmis_List] OFF
SET IDENTITY_INSERT [dbo].[hmis_Values] ON
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (1, 1, 1, N'Updated')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (2, 1, 2, N'Effective')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (3, 1, 3, N'Reporting period')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (4, 1, 4, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (5, 2, 1, N'Delta refresh')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (6, 2, 2, N'Full refresh')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (7, 2, 3, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (8, 4, 141, N'PATH service')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (9, 4, 142, N'RHY service')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (10, 4, 143, N'HOPWA service')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (11, 4, 144, N'SSVF service')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (12, 4, 151, N'HOPWA financial assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (13, 4, 152, N'SSVF financial assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (14, 4, 161, N'PATH referral')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (15, 4, 162, N'RHY referral')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (16, 4, 200, N'Bed night')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (17, 4, 210, N'HUD-VASH OTH voucher tracking')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (18, 5, 1, N'Unhashed')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (19, 5, 2, N'SHA-1 (no longer used for federal purposes)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (20, 5, 3, N'Hashed – other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (21, 5, 4, N'SHA-256 (RHY)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (22, 6, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (23, 6, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (24, 6, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (25, 7, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (26, 7, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (27, 7, 99, N'Data not collected*')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (28, 8, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (29, 8, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (30, 8, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (31, 8, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (32, 8, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (33, 9, 1, N'CoC HMIS')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (34, 9, 2, N'Standalone/agency-specific application')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (35, 9, 3, N'Data warehouse')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (36, 9, 4, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (37, 10, 1, N'Emergency Shelter')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (38, 10, 2, N'Transitional Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (39, 10, 3, N'PH - Permanent Supportive Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (40, 10, 4, N'Street Outreach')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (41, 10, 6, N'Services Only')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (42, 10, 7, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (43, 10, 8, N'Safe Haven')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (44, 10, 9, N'PH – Housing Only')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (45, 10, 10, N'PH – Housing with Services (no disability required for entry)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (46, 10, 11, N'Day Shelter')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (47, 10, 12, N'Homelessness Prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (48, 10, 13, N'PH - Rapid Re-Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (49, 10, 14, N'Coordinated Assessment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (50, 11, 0, N'Entry/Exit Date')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (51, 11, 3, N'Night-by-Night')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (52, 12, 1, N'HUD: CoC – Homelessness Prevention (High Performing Comm. Only)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (53, 12, 2, N'HUD: CoC – Permanent Supportive Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (54, 12, 3, N'HUD: CoC – Rapid Re-Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (55, 12, 4, N'HUD: CoC – Supportive Services Only')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (56, 12, 5, N'HUD: CoC – Transitional Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (57, 12, 6, N'HUD: CoC – Safe Haven')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (58, 12, 7, N'HUD: CoC – Single Room Occupancy (SRO)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (59, 12, 8, N'HUD: ESG – Emergency Shelter (operating and/or essential services)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (60, 12, 9, N'HUD: ESG – Homelessness Prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (61, 12, 10, N'HUD: ESG – Rapid Rehousing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (62, 12, 11, N'HUD: ESG – Street Outreach')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (63, 12, 12, N'HUD: Rural Housing Stability Assistance Program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (64, 12, 13, N'HUD: HOPWA – Hotel/Motel Vouchers')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (65, 12, 14, N'HUD: HOPWA – Housing Information')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (66, 12, 15, N'HUD: HOPWA – Permanent Housing (facility based or TBRA)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (67, 12, 16, N'HUD: HOPWA – Permanent Housing Placement ')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (68, 12, 17, N'HUD: HOPWA – Short-Term Rent, Mortgage, Utility assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (69, 12, 18, N'HUD: HOPWA – Short-Term Supportive Facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (70, 12, 19, N'HUD: HOPWA – Transitional Housing (facility based or TBRA)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (71, 12, 20, N'HUD: HUD/VASH')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (72, 12, 21, N'HHS: PATH – Street Outreach & Supportive Services Only')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (73, 12, 22, N'HHS: RHY – Basic Center Program (prevention and shelter)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (74, 12, 23, N'HHS: RHY – Maternity Group Home for Pregnant and Parenting Youth')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (75, 12, 24, N'HHS: RHY – Transitional Living Program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (76, 12, 25, N'HHS: RHY – Street Outreach Project')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (77, 12, 26, N'HHS: RHY – Demonstration Project**')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (78, 12, 27, N'VA: CRS Contract Residential Services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (79, 12, 29, N'VA: Domiciliary Care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (80, 12, 30, N'VA: Community Contract Safe Haven Program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (81, 12, 32, N'VA: Compensated Work Therapy Transitional Residence')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (82, 12, 33, N'VA: Supportive Services for Veteran Families')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (83, 12, 34, N'N/A')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (84, 12, 35, N'HUD: Pay for Success')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (85, 12, 36, N'HUD: Public and Indian Housing (PIH) Programs')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (86, 12, 37, N'VA: Grant Per Diem – Bridge Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (87, 12, 38, N'VA: Grant Per Diem – Low Demand')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (88, 12, 39, N'VA: Grant Per Diem – Hospital to Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (89, 12, 40, N'VA: Grant Per Diem – Clinical Treatment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (90, 12, 41, N'VA: Grant Per Diem – Service Intensive Transitional Housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (91, 12, 42, N'VA: Grant Per Diem – Transition in Place')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (92, 13, 1, N'Households without children')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (93, 13, 3, N'Households with at least one adult and one child')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (94, 13, 4, N'Households with only children')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (95, 14, 1, N'Facility-based')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (96, 14, 2, N'Voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (97, 14, 3, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (98, 15, 1, N'Year-round')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (99, 15, 2, N'Seasonal')
GO
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (100, 15, 3, N'Overflow')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (101, 16, 1, N'Domestic violence victims')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (102, 16, 3, N'Persons with HIV/AIDS')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (103, 16, 4, N'Not applicable')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (104, 17, 1, N'Urban')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (105, 17, 2, N'Suburban')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (106, 17, 3, N'Rural')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (107, 18, 1, N'Site-based – single site')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (108, 18, 2, N'Site-based – clustered / multiple sites')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (109, 18, 3, N'Tenant-based - scattered site')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (110, 19, 1, N'Full name reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (111, 19, 2, N'Partial, street name, or code name reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (112, 19, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (113, 19, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (114, 19, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (115, 20, 1, N'Full SSN reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (116, 20, 2, N'Approximate or partial SSN reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (117, 20, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (118, 20, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (119, 20, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (120, 21, 1, N'Full DOB reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (121, 21, 2, N'Approximate or partial DOB reported')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (122, 21, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (123, 21, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (124, 21, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (125, 22, 0, N'Non-Hispanic/Non-Latino')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (126, 22, 1, N'Hispanic/Latino')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (127, 22, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (128, 22, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (129, 22, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (130, 23, 0, N'Female')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (131, 23, 1, N'Male')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (132, 23, 2, N'Trans Female (MTF or Male to Female)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (133, 23, 3, N'Trans Male (FTM or Female to Male)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (134, 23, 4, N'Gender non-conforming (i.e. not exclusively male or female)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (135, 23, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (136, 23, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (137, 23, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (138, 24, 1, N'Emergency shelter, including hotel or motel paid for with emergency shelter voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (139, 24, 2, N'Transitional housing for homeless persons')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (140, 24, 3, N'Permanent housing (other than RRH) for formerly homeless persons')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (141, 24, 4, N'Psychiatric hospital or other psychiatric facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (142, 24, 5, N'Substance abuse treatment facility or detox center')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (143, 24, 6, N'Hospital or other residential non-psychiatric medical facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (144, 24, 7, N'Jail, prison or juvenile detention facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (145, 24, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (146, 24, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (147, 24, 10, N'Rental by client, no ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (148, 24, 11, N'Owned by client, no ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (149, 24, 12, N'Staying or living with family, temporary')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (150, 24, 13, N'Staying or living with friends, temporary')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (151, 24, 14, N'Hotel or motel paid for without emergency shelter voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (152, 24, 15, N'Foster care home or foster care group home')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (153, 24, 16, N'Place not meant for habitation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (154, 24, 17, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (155, 24, 18, N'Safe Haven')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (156, 24, 19, N'Rental by client, with VASH housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (157, 24, 20, N'Rental by client, with other ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (158, 24, 21, N'Owned by client, with ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (159, 24, 22, N'Staying or living with family, permanent tenure')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (160, 24, 23, N'Staying or living with friends, permanent tenure')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (161, 24, 24, N'Deceased')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (162, 24, 25, N'Long-term care facility or nursing home')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (163, 24, 26, N'Moved from one HOPWA funded project to HOPWA PH')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (164, 24, 27, N'Moved from one HOPWA funded project to HOPWA TH')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (165, 24, 28, N'Rental by client, with GPD TIP housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (166, 24, 29, N'Residential project or halfway house with no homeless criteria')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (167, 24, 30, N'No exit interview completed')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (168, 24, 31, N'Rental by client, with RRH or equivalent subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (169, 24, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (170, 25, 1, N'Self (head of household)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (171, 25, 2, N'Child')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (172, 25, 3, N'Spouse or partner')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (173, 25, 4, N'Other relative')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (174, 25, 5, N'Unrelated household member')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (175, 25, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (176, 26, 1, N'Emergency shelter, including hotel or motel paid for with emergency shelter voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (177, 26, 2, N'Transitional housing for homeless persons')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (178, 26, 3, N'Permanent housing (other than RRH) for formerly homeless persons')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (179, 26, 4, N'Psychiatric hospital or other psychiatric facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (180, 26, 5, N'Substance abuse treatment facility or detox center')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (181, 26, 6, N'Hospital or other residential non-psychiatric medical facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (182, 26, 7, N'Jail, prison or juvenile detention facility')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (183, 26, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (184, 26, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (185, 26, 12, N'Staying or living in a family member''s room, apartment or house')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (186, 26, 13, N'Staying or living in a friend''s room, apartment or house')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (187, 26, 14, N'Hotel or motel paid for without emergency shelter voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (188, 26, 15, N'Foster care home or foster care group home')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (189, 26, 16, N'Place not meant for habitation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (190, 26, 18, N'Safe Haven')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (191, 26, 19, N'Rental by client, with VASH subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (192, 26, 20, N'Rental by client, with other housing subsidy (including RRH)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (193, 26, 21, N'Owned by client, with ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (194, 26, 22, N'Rental by client, no ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (195, 26, 23, N'Owned by client, no ongoing housing subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (196, 26, 24, N'Long-term care facility or nursing home')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (197, 26, 25, N'Rental by client, with GPD TIP subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (198, 26, 26, N'Residential project or halfway house with no homeless criteria')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (199, 26, 27, N'Interim housing')
GO
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (200, 26, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (201, 27, 2, N'One week or more, but less than one month')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (202, 27, 3, N'One month or more, but less than 90 days')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (203, 27, 4, N'90 days or more but less than one year')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (204, 27, 5, N'One year or longer')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (205, 27, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (206, 27, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (207, 27, 10, N'One night or less')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (208, 27, 11, N'Two to six nights')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (209, 27, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (210, 28, 1, N'One time')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (211, 28, 2, N'Two times')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (212, 28, 3, N'Three times')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (213, 28, 4, N'Four or more times')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (214, 28, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (215, 28, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (216, 28, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (217, 29, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (218, 29, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (219, 29, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (220, 29, 101, N'1')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (221, 29, 102, N'2')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (222, 29, 103, N'3')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (223, 29, 104, N'4')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (224, 29, 105, N'5')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (225, 29, 106, N'6')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (226, 29, 107, N'7')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (227, 29, 108, N'8')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (228, 29, 109, N'9')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (229, 29, 110, N'10')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (230, 29, 111, N'11')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (231, 29, 112, N'12')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (232, 29, 113, N'More than 12 months')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (233, 30, 1, N'Applied; decision pending')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (234, 30, 2, N'Applied; client not eligible')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (235, 30, 3, N'Client did not apply')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (236, 30, 4, N'Insurance type n/a for this client')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (237, 30, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (238, 30, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (239, 30, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (240, 31, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (241, 31, 1, N'Alcohol abuse')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (242, 31, 2, N'Drug abuse')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (243, 31, 3, N'Both alcohol and drug abuse')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (244, 31, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (245, 31, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (246, 31, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (247, 32, 1, N'Within the past three months')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (248, 32, 2, N'Three to six months ago (excluding six months exactly)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (249, 32, 3, N'Six months to one year ago (excluding one year exactly)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (250, 32, 4, N'One year or more')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (251, 32, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (252, 32, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (253, 32, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (254, 33, 1, N'Place not meant for habitation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (255, 33, 2, N'Service setting, non-residential')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (256, 33, 3, N'Service setting, residential')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (257, 34, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (258, 34, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (259, 34, 2, N'Worker unable to determine')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (260, 35, 200, N'BedNight')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (261, 36, 1, N'Referred to emergency shelter/safe haven')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (262, 36, 2, N'Referred to transitional housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (263, 36, 3, N'Referred to rapid re-housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (264, 36, 4, N'Referred to permanent supportive housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (265, 36, 5, N'Referred to homelessness prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (266, 36, 6, N'Referred to street outreach')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (267, 36, 7, N'Referred to other continuum project type')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (268, 36, 8, N'Referred to a homelessness diversion program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (269, 36, 9, N'Unable to refer/accept within continuum; ineligible for continuum projects')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (270, 36, 10, N'Unable to refer/accept within continuum; continuum services unavailable')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (271, 36, 11, N'Referred to other community project (non-continuum)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (272, 36, 12, N'Applicant declined referral/acceptance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (273, 36, 13, N'Applicant terminated assessment prior to completion')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (274, 36, 14, N'Other/specify')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (275, 37, 1, N'Project entry')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (276, 37, 2, N'Update')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (277, 37, 3, N'Project exit')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (278, 37, 5, N'Annual assessment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (279, 38, 1, N'Re-engagement')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (280, 38, 2, N'Screening')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (281, 38, 3, N'Habilitation/rehabilitation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (282, 38, 4, N'Community mental health')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (283, 38, 5, N'Substance use treatment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (284, 38, 6, N'Case management')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (285, 38, 7, N'Residential supportive services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (286, 38, 8, N'Housing minor renovation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (287, 38, 9, N'Housing moving assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (288, 38, 10, N'Housing eligibility determination')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (289, 38, 11, N'Security deposits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (290, 38, 12, N'One-time rent for eviction prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (291, 38, 14, N'Clinical assessment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (292, 39, 1, N'Community mental health')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (293, 39, 2, N'Substance use treatment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (294, 39, 3, N'Primary health/dental care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (295, 39, 4, N'Job training')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (296, 39, 5, N'Educational services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (297, 39, 6, N'Housing services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (298, 39, 7, N'Permanent housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (299, 39, 8, N'Income assistance')
GO
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (300, 39, 9, N'Employment assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (301, 39, 10, N'Medical insurance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (302, 39, 11, N'Temporary housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (303, 40, 1, N'Attained')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (304, 40, 2, N'Not attained')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (305, 40, 3, N'Unknown')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (306, 41, 1, N'Client was found ineligible for PATH')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (307, 41, 2, N'Client was not enrolled for other reason(s)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (308, 42, 1, N'Self-Referral')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (309, 42, 2, N'Individual: Parent/Guardian/Relative/Friend/Foster Parent/Other Individual')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (310, 42, 7, N'Outreach Project')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (311, 42, 11, N'Temporary Shelter')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (312, 42, 18, N'Residential Project:')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (313, 42, 28, N'Hotline:')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (314, 42, 30, N'Child Welfare/CPS')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (315, 42, 34, N'Juvenile Justice')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (316, 42, 35, N'Law Enforcement/ Police')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (317, 42, 37, N'Mental Hospital')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (318, 42, 38, N'School')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (319, 42, 39, N'Other Organization')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (320, 42, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (321, 42, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (322, 42, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (323, 43, 1, N'Out of age range')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (324, 43, 2, N'Ward of the state')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (325, 43, 3, N'Ward of the criminal justice system')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (326, 43, 4, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (327, 44, 1, N'Heterosexual')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (328, 44, 2, N'Gay')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (329, 44, 3, N'Lesbian')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (330, 44, 4, N'Bisexual')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (331, 44, 5, N'Questioning / unsure')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (332, 44, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (333, 44, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (334, 44, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (335, 45, 1, N'Less than grade 5')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (336, 45, 2, N'Grades 5-6')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (337, 45, 3, N'Grades 7-8')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (338, 45, 4, N'Grades 9-11')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (339, 45, 5, N'Grade 12')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (340, 45, 6, N'School program does not have grade levels')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (341, 45, 7, N'GED')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (342, 45, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (343, 45, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (344, 45, 10, N'Some college')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (345, 45, 11, N'Associate''s degree')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (346, 45, 12, N'Bachelor''s degree')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (347, 45, 13, N'Graduate degree')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (348, 45, 14, N'Vocational certification')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (349, 45, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (350, 46, 1, N'Attending school regularly')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (351, 46, 2, N'Attending school irregularly')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (352, 46, 3, N'Graduated from high school')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (353, 46, 4, N'Obtained GED')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (354, 46, 5, N'Dropped out')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (355, 46, 6, N'Suspended')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (356, 46, 7, N'Expelled')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (357, 46, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (358, 46, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (359, 46, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (360, 47, 1, N'Full-time')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (361, 47, 2, N'Part-time')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (362, 47, 3, N'Seasonal / sporadic (including day labor)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (363, 47, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (364, 48, 1, N'Looking for work')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (365, 48, 2, N'Unable to work')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (366, 48, 3, N'Not looking for work')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (367, 48, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (368, 49, 1, N'Excellent')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (369, 49, 2, N'Very good')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (370, 49, 3, N'Good')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (371, 49, 4, N'Fair')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (372, 49, 5, N'Poor')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (373, 49, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (374, 49, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (375, 49, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (376, 50, 1, N'Less than one year')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (377, 50, 2, N'1 to 2 years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (378, 50, 3, N'3 to 5 or more years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (379, 50, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (380, 51, 2, N'Community service/service learning (CSL)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (381, 51, 5, N'Education')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (382, 51, 6, N'Employment and/or training services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (383, 51, 7, N'Criminal justice /legal services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (384, 51, 8, N'Life skills training')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (385, 51, 10, N'Parenting education for youth with children')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (386, 51, 12, N'Post-natal care for mother')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (387, 51, 13, N'Pre-natal care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (388, 51, 14, N'Health/medical care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (389, 51, 17, N'Substance abuse treatment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (390, 51, 18, N'Substance Abuse Ed/Prevention Services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (391, 51, 26, N'Home-based Services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (392, 51, 27, N'Post-natal newborn care (wellness exams; immunizations)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (393, 51, 28, N'STD Testing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (394, 51, 29, N'Street-based Services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (395, 52, 1, N'1 to 3')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (396, 52, 2, N'4 to 7')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (397, 52, 3, N'8 to 11')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (398, 52, 4, N'12 or more')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (399, 52, 8, N'Client doesn''t know')
GO
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (400, 52, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (401, 52, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (402, 53, 1, N'Completed project')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (403, 53, 2, N'Youth voluntarily left early')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (404, 53, 3, N'Youth was expelled or otherwise involuntarily discharged from project')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (405, 54, 1, N'Criminal activity/destruction of property/violence')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (406, 54, 2, N'Non-compliance with project rules')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (407, 54, 3, N'Non-payment of rent/occupancy charge')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (408, 54, 4, N'Reached maximum time allowed by project')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (409, 54, 5, N'Project terminated')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (410, 54, 6, N'Unknown/disappeared')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (411, 55, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (412, 55, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (413, 55, 2, N'Worker does not know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (414, 56, 0, N'No')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (415, 56, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (416, 56, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (417, 57, 1, N'Army')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (418, 57, 2, N'Air Force')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (419, 57, 3, N'Navy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (420, 57, 4, N'Marines')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (421, 57, 6, N'Coast Guard')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (422, 57, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (423, 57, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (424, 57, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (425, 58, 1, N'Honorable')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (426, 58, 2, N'General under honorable conditions')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (427, 58, 4, N'Bad conduct')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (428, 58, 5, N'Dishonorable')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (429, 58, 6, N'Under other than honorable conditions (OTH)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (430, 58, 7, N'Uncharacterized')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (431, 58, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (432, 58, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (433, 58, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (434, 59, 1, N'Outreach services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (435, 59, 2, N'Case management services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (436, 59, 3, N'Assistance obtaining VA benefits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (437, 59, 4, N'Assistance obtaining/coordinating other public benefits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (438, 59, 5, N'Direct provision of other public benefits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (439, 59, 6, N'Other (non-TFA) supportive service approved by VA')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (440, 60, 1, N'VA vocational and rehabilitation counseling')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (441, 60, 2, N'Employment and training services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (442, 60, 3, N'Educational assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (443, 60, 4, N'Health care services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (444, 61, 1, N'Health care services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (445, 61, 2, N'Daily living services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (446, 61, 3, N'Personal financial planning services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (447, 61, 4, N'Transportation services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (448, 61, 5, N'Income support services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (449, 61, 6, N'Fiduciary and representative payee services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (450, 61, 7, N'Legal services - child support')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (451, 61, 8, N'Legal services - eviction prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (452, 61, 9, N'Legal services - outstanding fines and penalties')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (453, 61, 10, N'Legal services - restore / acquire driver''s license')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (454, 61, 11, N'Legal services - other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (455, 61, 12, N'Child care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (456, 61, 13, N'Housing counseling')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (457, 62, 1, N'Personal financial planning services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (458, 62, 2, N'Transportation services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (459, 62, 3, N'Income support services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (460, 62, 4, N'Fiduciary and representative payee services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (461, 62, 5, N'Legal services - child support')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (462, 62, 6, N'Legal services - eviction prevention')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (463, 62, 7, N'Legal services - outstanding fines and penalties')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (464, 62, 8, N'Legal services - restore / acquire driver''s license')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (465, 62, 9, N'Legal services - other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (466, 62, 10, N'Child care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (467, 62, 11, N'Housing counseling')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (468, 63, 1, N'Rental assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (469, 63, 2, N'Security deposit')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (470, 63, 3, N'Utility deposit')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (471, 63, 4, N'Utility fee payment assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (472, 63, 5, N'Moving costs')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (473, 63, 8, N'Transportation services: tokens/vouchers')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (474, 63, 9, N'Transportation services: vehicle repair/maintenance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (475, 63, 10, N'Child care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (476, 63, 11, N'General housing stability assistance - emergency supplies')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (477, 63, 12, N'General housing stability assistance - other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (478, 63, 14, N'Emergency housing assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (479, 64, 1, N'Less than 30%')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (480, 64, 2, N'30% to 50%')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (481, 64, 3, N'Greater than 50%')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (482, 64, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (483, 65, 1, N'Full address')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (484, 65, 2, N'Incomplete or estimated address')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (485, 65, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (486, 65, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (487, 65, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (488, 66, 0, N'No (0 points)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (489, 66, 1, N'Yes')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (490, 66, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (491, 67, 0, N'0-6 days')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (492, 67, 1, N'7-13 days')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (493, 67, 2, N'14-21 days')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (494, 67, 3, N'More than 21 days (0 points)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (495, 67, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (496, 68, 0, N'0-14% of AMI for household size')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (497, 68, 1, N'15-30% of AMI for household size')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (498, 68, 2, N'More than 30% of AMI for household size (0 points)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (499, 68, 99, N'Data not collected')
GO
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (500, 69, 0, N'4 or more prior rental evictions')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (501, 69, 1, N'2-3 prior rental evictions')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (502, 69, 2, N'1 prior rental eviction')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (503, 69, 3, N'No prior rental evictions (0 points)')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (504, 69, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (505, 70, 0, N'4 or more times or total of at least 12 months in past three years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (506, 70, 1, N'2-3 times in past three years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (507, 70, 2, N'1 time in past three years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (508, 70, 3, N'4 or more times or total of at least 12 months in past three years')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (509, 70, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (510, 71, 1, N'Referral package forwarded to PHA')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (511, 71, 2, N'Voucher denied by PHA')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (512, 71, 3, N'Voucher issued by PHA')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (513, 71, 4, N'Voucher revoked or expired')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (514, 71, 5, N'Voucher in use – veteran moved into housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (515, 71, 6, N'Voucher was ported locally')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (516, 71, 7, N'Voucher was administratively absorbed by new PHA')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (517, 71, 8, N'Voucher was converted to Housing Choice Voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (518, 71, 9, N'Veteran exited – voucher was returned')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (519, 71, 10, N'Veteran exited – family maintained the voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (520, 71, 11, N'Veteran exited – prior to ever receiving a voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (521, 71, 12, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (522, 72, 1, N'Accomplished goals and/or obtained services and no longer needs CM')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (523, 72, 2, N'Transferred to another HUD/VASH program site')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (524, 72, 3, N'Found/chose other housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (525, 72, 4, N'Did not comply with HUD/VASH CM')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (526, 72, 5, N'Eviction and/or other housing related issues')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (527, 72, 6, N'Unhappy with HUD/VASH housing')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (528, 72, 7, N'No longer financially eligible for HUD/VASH voucher')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (529, 72, 8, N'No longer interested in participating in this program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (530, 72, 9, N'Veteran cannot be located')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (531, 72, 10, N'Veteran too ill to participate at this time')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (532, 72, 11, N'Veteran is incarcerated')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (533, 72, 12, N'Veteran is deceased')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (534, 72, 13, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (535, 73, 1, N'Adult day care and personal assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (536, 73, 2, N'Case management')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (537, 73, 3, N'Child care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (538, 73, 4, N'Criminal justice/legal services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (539, 73, 5, N'Education')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (540, 73, 6, N'Employment and training services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (541, 73, 7, N'Food/meals/nutritional services')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (542, 73, 8, N'Health/medical care')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (543, 73, 9, N'Life skills training')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (544, 73, 10, N'Mental health care/counseling')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (545, 73, 11, N'Outreach and/or engagement')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (546, 73, 12, N'Substance abuse services/treatment')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (547, 73, 13, N'Transportation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (548, 73, 14, N'Other HOPWA funded service')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (549, 74, 1, N'Rental assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (550, 74, 2, N'Security deposits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (551, 74, 3, N'Utility deposits')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (552, 74, 4, N'Utility payments')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (553, 74, 7, N'Mortgage assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (554, 75, 1, N'Applied; decision pending')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (555, 75, 2, N'Applied; client not eligible')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (556, 75, 3, N'Client did not apply')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (557, 75, 4, N'Insurance type not applicable for this client')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (558, 75, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (559, 75, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (560, 75, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (561, 76, 0, N'Not available')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (562, 76, 1, N'Available')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (563, 76, 2, N'Undetectable')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (564, 76, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (565, 76, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (566, 76, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (567, 77, 1, N'Medical Report')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (568, 77, 2, N'Client Report')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (569, 77, 3, N'Other')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (570, 78, 1, N'Able to maintain the housing they had at project entry')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (571, 78, 2, N'Moved to new housing unit')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (572, 78, 3, N'Moved in with family/friends on a temporary basis')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (573, 78, 4, N'Moved in with family/friends on a permanent basis')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (574, 78, 5, N'Moved to a transitional or temporary housing facility or program')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (575, 78, 6, N'Client became homeless – moving to a shelter or other place unfit for human habitation')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (576, 78, 7, N'Client went to jail/prison')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (577, 78, 8, N'Client doesn''t know')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (578, 78, 9, N'Client refused')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (579, 78, 10, N'Client died')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (580, 78, 99, N'Data not collected')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (581, 79, 1, N'Without a subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (582, 79, 2, N'With the subsidy they had at project entry')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (583, 79, 3, N'With an on-going subsidy acquired since project entry')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (584, 79, 4, N'But only with other financial assistance')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (585, 79, 11, N'With on-going subsidy')
INSERT [dbo].[hmis_Values] ([id], [ListID], [HMISValue], [HMISText]) VALUES (586, 79, 12, N'Without an on-going subsidy')
SET IDENTITY_INSERT [dbo].[hmis_Values] OFF
Type your paragraph here.