Executing the FCCRTFDataLoadUtility Batch

Before executing the FCCRTFDataLoadUtility batch, certain steps are required to prepare the Customer data for redaction of Personal Identifying Information (PII).

Before executing the FCCRTFDataLoadUtility batch, certain steps are required to prepare the Customer data for redaction of Personal Identifying Information (PII).

1. Before executing the FCCRTFDataLoadUtility batch, you must update the FCC_RTF_SQL_QUERY table to provide the Customer Internal ID and other relevant details for the customers who require redaction in the correct format.
   Information on how this data should be provided can be found in the FCC_RTF_SQL_QUERY table at Sample Templates for Data Loading.

   Note:

   The CSV file should follow proper naming conventions. For example, 20231129_FCC_RTF_SQL_QUERY_TAB.csv
2. Upload the FCC_RTF_SQL_QUERY.csv file you have created into Object Storage using the steps found in Uploading Data into Object Storage.
3. Execute the FCCRTFDataLoadUtility batch.
   1. In $DATAORIGIN$, enter the Data Origin provided in the FCC_RTF_SQL_QUERY.csv file you uploaded into Object Storage
   2. In $BATCHDATE$, select the MISDATE associated with the FCC_RTF_SQL_QUERY.csv file you uploaded into Object Storage.