03_01b LSA Parameters and Metadata for HIC.sql

/*
LSA FY2024 Sample Code
Name:	03_01b LSA Parameters and Metadata for HIC.sql 

FY2024 Changes
		-New file with HIC parameters / new LSAScope value of 3 to indicate HIC

		(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.

	If LSAScope=3 (HIC), ReportStart and ReportEnd must be identical.   
*/
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)
		, '1/29/2025'
		, '1/29/2025'
		, 'XX-501'
		, 'Sample Code Inc.'
		, 'LSA Online'
		, 'Molly'			
		, 'molly@squarepegdata.com'
		, 3					
		, dateadd(yyyy, -7, '1/29/2025')