1. CTR Admin Guide
  2. Data Preparation and Loading
  3. Using Excel Upload
  4. Table Details

6.2.1 Table Details

This section provides a complete list of tables. Refer to these tables to prepare data accordingly in the .csv format.

Note:

B stands for base tables and TL stands for Language translation table.

Table 6-1 List of Tables

Fields Table Name US CTR Description
1

FCC_RR_BRANCH_INFO_B

FCC_RR_BRANCH_INFO_TL

 Yes

The Branch where the transaction has taken place.

NOTE: A default flag is provided to enable default branch information on UI.

3

FCC_RR_REPORTING_PERSON_B

FCC_RR_REPORTING_PERSON_TL

 Yes

The person who is reporting the transaction. This is the person whom FIU can contact if more details are required.

NOTE: A default flag is provided to enable the default reporting person on UI.

4

FCC_RR_RPTNG_PRSN_ADDR_B

FCC_RR_RPTNG_PRSN_ADDR_TL

 Yes The reporting person's address.
5

FCC_RR_RPTNG_PRSN_PHONE_B

FCC_RR_RPTNG_PRSN_PHONE_TL

 Yes The reporting person's phone number.
6

FCC_RR_RPTNG_IDENTIFICATION_B

FCC_RR_RPTNG_IDENTIFICATION_TL

 Yes The reporting person's identification details. For example, passport, driving license, and so on.
7

FCC_RR_COUNTRY_B

FCC_RR_COUNTRY_TL

 Yes The International Organization for Standardization (ISO) country list.
8

FCC_RR_STATES_B

FCC_RR_STATES_TL

 Yes The state of Financial Institution.
10

FCC_RR_FININST_INFO_B*

FCC_RR_FININST_INFO_TL

 Yes

The Financial Institution where the transactions have occurred. This is applicable only for FCC_RR_FININST_INFO_B*

NOTE: Default flag is provided to enable default Financial Institution or reporting entity on UI.

11

FCC_RR_CURRENCY_B

FCC_RR_CURRENCY_TL

 Yes The International Organization for Standardization (ISO) currency list.
12 FCC_RR_MAP_JURIS_TMPLT_TYPE Yes The mapping of the FI's regulatory jurisdiction and the applicable STR/SAR template for those jurisdictions.
13 FCC_RR_INSTALL_PARAM Yes The configuration details such as Date format, Locking Period, and so on.
For more information on sample templates, see Sample Template.

Note:

  • You must prepare and upload data in the sequence mentioned.
  • Data preparation is a one-time activity. Hence, you must be careful while preparing data.
  • You can only add and modify data.
  • You cannot delete data.
  • You cannot leave any column blank in the .csv file. If you have any blank fields in UI, then enter the “null” value in the .csv file.  
  • The value of the column marked with an asterisk must be unique. If the multiple asterisks are marked, then the combination must be unique.
  • To list all the values in UI, set the flag (F_IS_ACTIVE) as Y to enable reference data and to unlist all the values in UI, set the flag (F_IS_ACTIVE) as N to disable reference data in the following table:
    • FCC_RR_BRANCH_INFO
    • FCC_RR_REPORTING_PERSON
    • FCC_RR_FININST_INFO