<commit_before><databaseChangeLog xmlns='http://www.liquibase.org/xml/ns/dbchangelog'
	xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
	xsi:schemaLocation='http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd'>

	<changeSet author="KFSCGB" id="KFSMI">
	
	 	<addForeignKeyConstraint constraintName="CG_AGENCY_R1"
			referencedTableName="CG_BILL_FREQ_T" baseColumnNames="CG_AGENCY_BILL_FREQ_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="BILL_FREQ_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R2"
			referencedTableName="CG_FIN_FORM_TYP_T" baseColumnNames="CG_AGENCY_FIN_FORM_TYP_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="FIN_FORM_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R3"
			referencedTableName="CG_INV_TYP_T" baseColumnNames="CG_AGENCY_INV_TYP_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="INV_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R4"
			referencedTableName="CG_FIN_RPT_FREQ_T" baseColumnNames="FIN_RPT_FREQ_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="FIN_RPT_FREQ_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_R1"
			referencedTableName="CG_LTRCR_FND_T" baseColumnNames="CG_LTRCR_FND_CD"
			baseTableName="CG_AWD_T" referencedColumnNames="CG_LTRCR_FND_CD" />
	</changeSet>
			
	<changeSet author="KFSCGB" id="KFSMI1">
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R1"
			referencedTableName="CG_AGENCY_T" baseColumnNames="CG_AGENCY_NBR"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="CG_AGENCY_NBR" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R2"
			referencedTableName="CG_AGENCY_ADDR_TYP_T" baseColumnNames="CG_AGENCY_ADDR_TYPE_CD"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="CG_AGENCY_ADDR_TYPE_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R3"
			referencedTableName="CG_INV_TYP_T" baseColumnNames="INV_TYP_CD"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="INV_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_LTRCR_FND_R1"
			baseTableName="CG_LTRCR_FND_T" baseColumnNames="CG_LTRCR_FNDGRP_CD"
			referencedTableName="CG_LTRCR_FNDGRP_T" referencedColumnNames="CG_LTRCR_FNDGRP_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R1"
			referencedTableName="CG_AWD_T" baseColumnNames="CGPRPSL_NBR"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="CGPRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_FNDMGR_R1"
			referencedTableName="CG_AWD_T" baseColumnNames="CGPRPSL_NBR"
			baseTableName="CG_AWD_FNDMGR_T" referencedColumnNames="CGPRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R2"
			referencedTableName="CA_CHART_T" baseColumnNames="FIN_COA_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="FIN_COA_CD" />
		<addForeignKeyConstraint constraintName="AR_MLSTN_R1"
			referencedTableName="AR_MLSTN_SCHDL_T" baseColumnNames="PRPSL_NBR"
			baseTableName="AR_MLSTN_T" referencedColumnNames="PRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R3"
			referencedTableName="CA_ACCOUNT_T" baseColumnNames="ACCOUNT_NBR,FIN_COA_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="ACCOUNT_NBR,FIN_COA_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R4"
			referencedTableName="CA_SUB_ACCT_T" baseColumnNames="FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R5"
			referencedTableName="CA_OBJECT_CODE_T" baseColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,FIN_OBJECT_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,FIN_OBJECT_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R6"
			referencedTableName="CA_SUB_OBJECT_CD_T"
			baseColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD"
			baseTableName="CG_AWD_INV_ACCT_T"
			referencedColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD" />
		<addForeignKeyConstraint constraintName="AR_INV_MLSTN_R1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_MLSTN_T" referencedColumnNames="FDOC_NBR" />
		<addForeignKeyConstraint constraintName="AR_INV_BILL_R1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_BILL_T" referencedColumnNames="FDOC_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R7"
			referencedTableName="CA_PROJECT_T" baseColumnNames="PROJECT_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="PROJECT_CD" />
		<addForeignKeyConstraint constraintName="AR_LTRCR_RVW_DTL_R1"
			referencedTableName="AR_LTRCR_RVW_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_LTRCR_RVW_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<!-- To modify foreign key constraints from Invoice Detail, Invoice Account 
		Detail and Invoice Agency Address Detail to Customer Invoice Table -->
	<changeSet author="kfs" id="AR_CG_INV_DTL_T_DROP_FK">	
		
		<addForeignKeyConstraint constraintName="AR_CG_INV_DTL_FK1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_CG_INV_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="kfs" id="AR_INV_AGENCY_ADDR_DTL_T_DROP_FK">
		
		<addForeignKeyConstraint constraintName="AR_INV_AGENCY_ADDR_DTL_TR1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_AGENCY_ADDR_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="kfs" id="AR_INV_ACCT_DTL_T_DROP_FK">
		
		<addForeignKeyConstraint constraintName="AR_INV_ACCT_DTL_TR1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_ACCT_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>
	
		<changeSet author="KFS411CGB"
		id="KFSCNTRB908_DUNNING_CAMPAIGN_MAINTENANCE_DOCUMENT_03">
		<addForeignKeyConstraint constraintName="AR_DUN_LTR_DIST_DOC_TR1"
			referencedTableName="AR_DUN_CMPGN_DOC_T" baseColumnNames="CMPGN_ID"
			baseTableName="AR_DUN_LTR_DIST_T" referencedColumnNames="CMPGN_ID" />
	</changeSet>

	<changeSet author="KFS411CGB"
		id="KFSCNTRB900_COLLECTION_ACTIVITY_PROCESSING_06">
		<addForeignKeyConstraint constraintName="AR_EVENT_FK1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="INVOICE_NBR"
			baseTableName="AR_EVENT_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="KFS411CGB"
		id="KFSCNTRB1101_COLLETOR_HIERARCHY_MAINTENANCE_DOCUMENT_03">
		<addForeignKeyConstraint constraintName="AR_CLCTR_INFO_TR1"
			referencedTableName="AR_CLCTR_HEAD_T" baseColumnNames="CLCTR_HEAD_PRNCPL_ID"
			baseTableName="AR_CLCTR_INFO_T" referencedColumnNames="CLCTR_HEAD_PRNCPL_ID" />
	</changeSet>

	<changeSet author="KFSCGB" id="AR_MLSTN_MOD1">
		<addPrimaryKey tableName="AR_MLSTN_T" columnNames="CGPRPSL_NBR,MLSTN_ID" />
		<modifySql dbms="oracle">
			<replace replace="varchar" with="varchar2" />
			<replace replace="decimal" with="number" />
			<replace replace="datetime" with="date" />
		</modifySql>
	</changeSet>
	
	<changeSet author="KFSCGB" id="AR_CG_INV_DTL_ADD_FIELDS">
		<addPrimaryKey tableName="AR_CG_INV_DTL_T" columnNames="INV_DTL_ID,FDOC_NBR" />
		<modifySql dbms="oracle">
			<replace replace="decimal" with="number" />
		</modifySql>
	</changeSet>
	
</databaseChangeLog><commit_msg>KFSMI-11243 : updated liquibase file for this.<commit_after><databaseChangeLog xmlns='http://www.liquibase.org/xml/ns/dbchangelog'
	xmlns:xsi='http://www.w3.org/2001/XMLSchema-instance'
	xsi:schemaLocation='http://www.liquibase.org/xml/ns/dbchangelog http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-2.0.xsd'>

	<changeSet author="KFSCGB" id="KFSMI">
	
	 	<addForeignKeyConstraint constraintName="CG_AGENCY_R1"
			referencedTableName="CG_BILL_FREQ_T" baseColumnNames="CG_AGENCY_BILL_FREQ_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="BILL_FREQ_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R2"
			referencedTableName="CG_FIN_FORM_TYP_T" baseColumnNames="CG_AGENCY_FIN_FORM_TYP_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="FIN_FORM_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R3"
			referencedTableName="CG_INV_TYP_T" baseColumnNames="CG_AGENCY_INV_TYP_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="INV_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_R4"
			referencedTableName="CG_FIN_RPT_FREQ_T" baseColumnNames="FIN_RPT_FREQ_CD"
			baseTableName="CG_AGENCY_T" referencedColumnNames="FIN_RPT_FREQ_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_R1"
			referencedTableName="CG_LTRCR_FND_T" baseColumnNames="CG_LTRCR_FND_CD"
			baseTableName="CG_AWD_T" referencedColumnNames="CG_LTRCR_FND_CD" />
	</changeSet>
			
	<changeSet author="KFSCGB" id="KFSMI1">
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R1"
			referencedTableName="CG_AGENCY_T" baseColumnNames="CG_AGENCY_NBR"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="CG_AGENCY_NBR" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R2"
			referencedTableName="CG_AGENCY_ADDR_TYP_T" baseColumnNames="CG_AGENCY_ADDR_TYPE_CD"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="CG_AGENCY_ADDR_TYPE_CD" />
		<addForeignKeyConstraint constraintName="CG_AGENCY_ADDR_R3"
			referencedTableName="CG_INV_TYP_T" baseColumnNames="INV_TYP_CD"
			baseTableName="CG_AGENCY_ADDR_T" referencedColumnNames="INV_TYP_CD" />
		<addForeignKeyConstraint constraintName="CG_LTRCR_FND_R1"
			baseTableName="CG_LTRCR_FND_T" baseColumnNames="CG_LTRCR_FNDGRP_CD"
			referencedTableName="CG_LTRCR_FNDGRP_T" referencedColumnNames="CG_LTRCR_FNDGRP_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R1"
			referencedTableName="CG_AWD_T" baseColumnNames="CGPRPSL_NBR"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="CGPRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_FNDMGR_R1"
			referencedTableName="CG_AWD_T" baseColumnNames="CGPRPSL_NBR"
			baseTableName="CG_AWD_FNDMGR_T" referencedColumnNames="CGPRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R2"
			referencedTableName="CA_CHART_T" baseColumnNames="FIN_COA_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="FIN_COA_CD" />
		<addForeignKeyConstraint constraintName="AR_MLSTN_R1"
			referencedTableName="AR_MLSTN_SCHDL_T" baseColumnNames="PRPSL_NBR"
			baseTableName="AR_MLSTN_T" referencedColumnNames="PRPSL_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R3"
			referencedTableName="CA_ACCOUNT_T" baseColumnNames="ACCOUNT_NBR,FIN_COA_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="ACCOUNT_NBR,FIN_COA_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R4"
			referencedTableName="CA_SUB_ACCT_T" baseColumnNames="FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="FIN_COA_CD,ACCOUNT_NBR,SUB_ACCT_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R5"
			referencedTableName="CA_OBJECT_CODE_T" baseColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,FIN_OBJECT_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,FIN_OBJECT_CD" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R6"
			referencedTableName="CA_SUB_OBJECT_CD_T"
			baseColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD"
			baseTableName="CG_AWD_INV_ACCT_T"
			referencedColumnNames="UNIV_FISCAL_YR,FIN_COA_CD,ACCOUNT_NBR,FIN_OBJECT_CD,FIN_SUB_OBJ_CD" />
		<addForeignKeyConstraint constraintName="AR_INV_MLSTN_R1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_MLSTN_T" referencedColumnNames="FDOC_NBR" />
		<addForeignKeyConstraint constraintName="AR_INV_BILL_R1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_BILL_T" referencedColumnNames="FDOC_NBR" />
		<addForeignKeyConstraint constraintName="CG_AWD_INV_ACCT_R7"
			referencedTableName="CA_PROJECT_T" baseColumnNames="PROJECT_CD"
			baseTableName="CG_AWD_INV_ACCT_T" referencedColumnNames="PROJECT_CD" />
		<addForeignKeyConstraint constraintName="AR_LTRCR_RVW_DTL_R1"
			referencedTableName="AR_LTRCR_RVW_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_LTRCR_RVW_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<!-- To modify foreign key constraints from Invoice Detail, Invoice Account 
		Detail and Invoice Agency Address Detail to Customer Invoice Table -->
	<changeSet author="kfs" id="AR_CG_INV_DTL_T_DROP_FK">	
		
		<addForeignKeyConstraint constraintName="AR_CG_INV_DTL_FK1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_CG_INV_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="kfs" id="AR_INV_AGENCY_ADDR_DTL_T_DROP_FK">
		
		<addForeignKeyConstraint constraintName="AR_INV_AGENCY_ADDR_DTL_TR1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_AGENCY_ADDR_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="kfs" id="AR_INV_ACCT_DTL_T_DROP_FK">
		
		<addForeignKeyConstraint constraintName="AR_INV_ACCT_DTL_TR1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="FDOC_NBR"
			baseTableName="AR_INV_ACCT_DTL_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>
	
		<changeSet author="KFS411CGB"
		id="KFSCNTRB908_DUNNING_CAMPAIGN_MAINTENANCE_DOCUMENT_03">
		<addForeignKeyConstraint constraintName="AR_DUN_LTR_DIST_DOC_TR1"
			referencedTableName="AR_DUN_CMPGN_DOC_T" baseColumnNames="CMPGN_ID"
			baseTableName="AR_DUN_LTR_DIST_T" referencedColumnNames="CMPGN_ID" />
	</changeSet>

	<changeSet author="KFS411CGB"
		id="KFSCNTRB900_COLLECTION_ACTIVITY_PROCESSING_06">
		<addForeignKeyConstraint constraintName="AR_EVENT_FK1"
			referencedTableName="AR_INV_DOC_T" baseColumnNames="INVOICE_NBR"
			baseTableName="AR_EVENT_T" referencedColumnNames="FDOC_NBR" />
	</changeSet>

	<changeSet author="KFS411CGB"
		id="KFSCNTRB1101_COLLETOR_HIERARCHY_MAINTENANCE_DOCUMENT_03">
		<addForeignKeyConstraint constraintName="AR_CLCTR_INFO_TR1"
			referencedTableName="AR_CLCTR_HEAD_T" baseColumnNames="CLCTR_HEAD_PRNCPL_ID"
			baseTableName="AR_CLCTR_INFO_T" referencedColumnNames="CLCTR_HEAD_PRNCPL_ID" />
	</changeSet>

	<changeSet author="KFSCGB" id="AR_MLSTN_MOD1">
		<addPrimaryKey tableName="AR_MLSTN_T" columnNames="CGPRPSL_NBR,MLSTN_ID" />
		<addPrimaryKey tableName="AR_MLSTN_T" columnNames="MLSTN_ID" />
		<modifySql dbms="oracle">
			<replace replace="varchar" with="varchar2" />
			<replace replace="decimal" with="number" />
			<replace replace="datetime" with="date" />
		</modifySql>
	</changeSet>
	
	<changeSet author="KFSCGB" id="AR_CG_INV_DTL_ADD_FIELDS">
		<addPrimaryKey tableName="AR_CG_INV_DTL_T" columnNames="INV_DTL_ID,FDOC_NBR" />
		<modifySql dbms="oracle">
			<replace replace="decimal" with="number" />
		</modifySql>
	</changeSet>
	
</databaseChangeLog>
{'fraction_non_alphanumeric': 0.09967654630668692, 'fraction_numerical': 0.008515413558650736, 'mean_word_length': 10.058394160583942, 'pattern_counts': {'":': 0, '<': 124, '<?xml version=': 0, '>': 124, 'https://': 0, 'lorem ipsum': 0, 'www.': 8, 'xml': 10}, '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': '5031444', 'n_tokens_mistral': 6614, 'n_tokens_neox': 6046, 'n_words': 511}