 	_null_value text;
 	_blank_value text;
 	_no_text text;
-	_aggregation_delay date;
 	_rollup_text text;
 	_rollup_text2 text;
 BEGIN

	_blank_value = '';
	_no_text = 'no';
	EXECUTE 'SELECT table_name FROM ucr_table_name_mapping WHERE table_type = ' || quote_literal('ccs_record_monthly') INTO _ucr_ccs_record_table;
	_aggregation_delay = ($1 + INTERVAL ' - 4 DAYS')::DATE;

	EXECUTE 'INSERT INTO ' || quote_ident(_tablename5) || '(SELECT ' ||
		'state_id, ' ||

	_null_value text;
	_blank_value text;
	_no_text text;
	_rollup_text text;
	_rollup_text2 text;
BEGIN
