LSASampleCode/03_01a LSA Parameters and Metadata.sql at master · jbloescw/LSASampleCode · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
/*
LSA FY2024 Sample Code
Name:	03_01a LSA Parameters and Metadata for AHAR.sql

FY2024 Changes
		-Update dates
		-Filename changed to specify that parameters are for an annual report vs a HIC (single day) report

		(Detailed revision history maintained at https://github.com/HMIS/LSASampleCode)

	The hard-coded values here must be replaced with code to accept actual user-entered parameters
	and info specific to the HMIS application.
*/
delete from lsa_Report

insert into lsa_Report (
		  ReportID			--system-generated unique identifier for report process
		, ReportStart		--user-entered start of report period
		, ReportEnd			--user-entered end of report period
		, ReportCoC			--user-selected HUD Continuum of Care Code
		, SoftwareVendor	--name of vendor
		, SoftwareName		--name of HMIS application
		, VendorContact		--name of vendor contact
		, VendorEmail		--email address of vendor contact
		, LSAScope			--user-selected 1=systemwide, 2=project-focused 3=HIC
		, LookbackDate		--ReportStart - 7 years
		)
	select
		  right(year(getdate()), 1)*100000000 + cast(format (getdate(),'MMddHHmm') as int)
		, '10/1/2023'
		, '9/30/2024'
		, 'XX-501'
		, 'Sample Code Inc.'
		, 'LSA Online'
		, 'Molly'
		, 'molly@squarepegdata.com'
		, 1
		, dateadd(yyyy, -7, '10/1/2023')