<commit_before>SELECT af.row_number,
	af.allocation_transfer_agency,
	af.agency_identifier,
	af.beginning_period_of_availa,
	af.ending_period_of_availabil,
	af.availability_type_code,
	af.main_account_code,
	af.sub_account_code,
	af.program_activity_code,
	af.object_class
FROM award_financial AS af
WHERE af.submission_id = {}
	AND NOT EXISTS (
		SELECT 1
		FROM object_class_program_activity AS op
		WHERE af.tas IS NOT DISTINCT FROM op.tas
			AND (af.program_activity_code IS NOT DISTINCT FROM op.program_activity_code
				OR COALESCE(af.program_activity_code, 0) = 0
				OR af.program_activity_code = "")
			AND af.object_class IS NOT DISTINCT FROM op.object_class
			AND af.submission_id = op.submission_id
	);<commit_msg>Revert "Updated B20 to ignore blank or zero program activity code"<commit_after>SELECT af.row_number,
	af.allocation_transfer_agency,
	af.agency_identifier,
	af.beginning_period_of_availa,
	af.ending_period_of_availabil,
	af.availability_type_code,
	af.main_account_code,
	af.sub_account_code,
	af.program_activity_code,
	af.object_class
FROM award_financial AS af
WHERE af.submission_id = {}
	AND NOT EXISTS (
		SELECT 1
		FROM object_class_program_activity AS op
		WHERE af.tas IS NOT DISTINCT FROM op.tas
			AND af.program_activity_code IS NOT DISTINCT FROM op.program_activity_code
			AND af.object_class IS NOT DISTINCT FROM op.object_class
			AND af.submission_id = op.submission_id
	);
{'fraction_non_alphanumeric': 0.06272022551092318, 'fraction_numerical': 0.004228329809725159, 'mean_word_length': 5.228070175438597, 'pattern_counts': {'":': 0, '<': 3, '<?xml version=': 0, '>': 3, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '4045791', 'n_tokens_mistral': 554, 'n_tokens_neox': 506, 'n_words': 116}