<cfset agency_db = 'agency_1150' />
<cfset agency_id =  '1150' />

<cfquery name="insert_documents" datasource="#Application.DataSrc#">
			INSERT INTO #agency_db#.DocumentDesc
			(DOC_ID, Agency_ID, DocumentType, Skill, Required, Description, Expires)
			VALUES 
			  ( '1', '#agency_id#' , 'Patient', 'SN', '1', 'Physician Face-to-Face (F2F)','expires on certification end date'),
			  ( '2', '#agency_id#' , 'Patient', 'SN', '1', 'History & Physical (H&P)','expires never'),
			  ( '3', '#agency_id#' , 'Patient', 'SN', '0', 'Home Health Order','expires never'),
			  ( '4', '#agency_id#' , 'Patient', 'SN', '0', 'CMS Forms','expires never'),
			  ( '5', '#agency_id#' , 'Patient', 'SN', '0', 'Admission Forms','expires never'),
			  ( '6', '#agency_id#' , 'Patient', 'SN', '0', 'Clinical Forms','expires never'),
			  ( '7', '#agency_id#' , 'Patient', 'SN', '0', 'Insurance Pre-Authorizations','expires never'),
			  ( '8', '#agency_id#' , 'Patient', 'SN', '0', 'Physician Visit Notes','expires never'),
			  ( '9', '#agency_id#' , 'Patient', 'SN', '0', 'Labs/Diagnostics Orders','expires never'),
			  ( '10', '#agency_id#' , 'Patient', 'SN', '0', 'Labs/Diagnostics Results','expires never');
		</cfquery>	

		<cfquery name="insert_defaultpayer" datasource="#Application.DataSrc#">
			INSERT INTO #agency_db#.pPayer
			   (Loc_ID, Status, Output, Payer_No, Submitter_ID, Receiver_ID, Pay_Name, Pay_Street, Pay_City, Pay_State, Pay_Zip, 
			   	Pay_Phone, Pay_Contact, PayerSource, Pay_frequency, Identification_Code_Qualifier, Auth_Req, Agency_Biller, 
			   	Biller_First, Biller_Type, Biller_Last_or_Company, Biller_NPI, Biller_Submitter_ID, Pay_Website, Web_User,
			   	 Web_Pass, Date_Create, Created_by, Date_Change, Change_by)
			VALUES 
				('#agency_id#', '0', 'no output', NULL, NULL, NULL, 'Medicaid', '123 Main St', 'Hartford', 'CT', '06117', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
				('#agency_id#', '0', 'Medicare', '13579', 'ME077187', '14004', 'Medicare', 'PO Box 1000', 'Hingham', 'ME', '02044-1000', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
		</cfquery>

		<cfquery name="insert_defaultrevenuecodes" datasource="#Application.DataSrc#">
			INSERT INTO #agency_db#.pRevenue_Code
			   (Rev_CodeID, Agency_ID, Payer_ID, Status, Rev_Code, HCPCS, Tier, Measure, Visit_Type, Description, 
			   	QB_Export, Export_Date, TimeAuthorization, Modifier, GL_Account, Units, EClaim_Price, Balance, 
			   	Quick_Books_Price, New_EClaim_Price, New_EClaim_Price_Eff_Enddate, New_QuickBooks_Price, 
			   	New_QuickBooks_Effdate)
			VALUES 
				('1', '#agency_id#', '1', '0', '0551', 'W0050', '0', 'visit', 'SN', 'RN Visit', '0', NULL, '0', NULL, NULL, '0', '125.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('2', '#agency_id#', '1', '0', '421', 'G0151', '0', 'visit', 'PT', 'PT Visit', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('3', '#agency_id#', '1', '0', '421', 'G0157', '0', 'visit', 'PT', 'PT ASSISTANT VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('4', '#agency_id#', '1', '0', '431', 'G0152', '0', 'visit', 'OT', 'OT VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('5', '#agency_id#', '1', '0', '431', 'G0158', '0', 'visit', 'OT', 'OT ASSIST VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('6', '#agency_id#', '1', '0', '571', 'G0156', '0', 'visit', 'HHA', 'HHA Visit', '0', NULL, '0', NULL, NULL, '0', '60.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('7', '#agency_id#', '2', '0', '421', 'G0151', '0', 'visit', 'PT', 'PT Visit', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('8', '#agency_id#', '2', '0', '421', 'G0157', '0', 'visit', 'PT', 'PT ASSISTANT VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('9', '#agency_id#', '2', '0', '431', 'G0152', '0', 'visit', 'OT', 'OT VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('10', '#agency_id#', '2', '0', '431', 'G0158', '0', 'visit', 'OT', 'OT ASSIST VISIT', '0', NULL, '0', NULL, NULL, '0', '150.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('11', '#agency_id#', '2', '0', '571', 'G0156', '0', 'visit', 'HHA', 'HHA VISIT', '0', NULL, '0', NULL, NULL, '0', '60.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL),
				('12', '#agency_id#', '2', '0', '551', 'G0151', '0', 'visit', 'SN', 'Skilled Nurse Visit', '0', NULL, '0', NULL, NULL, '0', '135.00', '0.00', '0.00', '0.00', NULL, '0.00', NULL);
		</cfquery>
			

		<cfquery name="insert_defaultcommsubjects" datasource="#Application.DataSrc#">
			INSERT INTO #agency_db#.CommunicationSubjects
			   ( Agency_ID, Subject, Created_By, Created_Date, Mod_By, Mod_Date, active)
			VALUES 
				('#agency_id#', 'missed visit', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'status & careplan changes', NULL, NULL, '2', '2022-11-03 09:31:16', 'Y'),
				('#agency_id#', 'no treatment', '2', NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Medication reconciliation', '15', '2023-06-21 16:18:30', NULL, NULL, 'Y'),
				('#agency_id#', 'Discharge Summary - SN', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Discharge Summary - PT', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Discharge Summary - OT', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Discharge Summary - ST', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Discharge Summary - MSW', NULL, NULL, NULL, NULL, 'Y'),
				('#agency_id#', 'Physical Therapy BEFORE the 30 days', '2', '2023-07-03 08:41:43', NULL, NULL, 'Y'),
				('#agency_id#', 'Report of Unstable Symptoms to Certifying Physician', '23', '2023-07-13 11:13:46', NULL, NULL, 'Y');
		</cfquery>

		<cfquery name="insert_defaultvitalparam" datasource="#Application.DataSrc#">
			INSERT INTO #agency_db#.pVital_Param
			   (Param_ID, Agency_ID, Status, Item_ID, Vital_Sign, Value_Low, Value_High, Date_Create,
			    Created_by, Date_Change, Change_by)
			VALUES 
				('1', '#agency_id#', '0', '1', 'temperature', '95', '100.5', NULL, NULL, NULL, NULL),
				('2', '#agency_id#', '0', '2', 'heart rate', '60', '100', NULL, NULL, NULL, NULL),
				('3', '#agency_id#', '0', '3', 'respiratory rate', '12', '24', NULL, NULL, NULL, NULL),
				('4', '#agency_id#', '0', '4', 'blood pressure systolic', '160', '190', NULL, NULL, NULL, NULL),
				('5', '#agency_id#', '0', '5', 'blood pressure diastolic', '60', '90', NULL, NULL, NULL, NULL),
				('6', '#agency_id#', '0', '7', 'O2 saturation', '90', '90', NULL, NULL, NULL, NULL),
				('7', '#agency_id#', '0', '8', 'pain', '-1', '2', NULL, NULL, NULL, NULL),
				('8', '#agency_id#', '0', '9', 'blood sugar', '60', '250', NULL, NULL, NULL, NULL),
				('9', '#agency_id#', '0', '10', 'INR', '2', '6', NULL, NULL, NULL, NULL),
				('10', '#agency_id#', '0', '11', 'cholesterol', '60', '500', NULL, NULL, NULL, NULL),
				('11', '#agency_id#', '0', '12', 'lithium', '0', '0', NULL, NULL, NULL, NULL);
		</cfquery>