1. Using CRR & CTR Administration Service
  2. Data Preparation and Loading
  3. Data Preparation
  4. Using Excel Upload
  5. Table Details

5.1.1.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 5-1 List of Tables

Fields Table Name goAML USSAR AUS SMR PH STR PH CTR Description
1

FCC_RR_BRANCH_INFO_B

FCC_RR_BRANCH_INFO_TL

 Yes Yes Yes No No

The Branch where the transaction has taken place.

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

2 FCC_RR_REPORT_CASE_TYPE_MAP Yes Yes Yes Yes No Provides mapping between report type and case type.
3

FCC_RR_REPORTING_PERSON_B

FCC_RR_REPORTING_PERSON_TL

 Yes Yes Yes No No

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 Yes No No No The reporting person's address.
5

FCC_RR_RPTNG_PRSN_PHONE_B

FCC_RR_RPTNG_PRSN_PHONE_TL

 Yes Yes Yes No No The reporting person's phone number.
6

FCC_RR_RPTNG_IDENTIFICATION_B

FCC_RR_RPTNG_IDENTIFICATION_TL

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

FCC_RR_COUNTRY_B

FCC_RR_COUNTRY_TL

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

FCC_RR_STATES_B

FCC_RR_STATES_TL

 Yes Yes Yes No No The state of Financial Institution.
9

FCC_RR_REPORT_TYPE_B

FCC_RR_REPORT_TYPE_TL

 Yes Yes Yes Yes No The type of report.
10

FCC_RR_FININST_INFO_B*

FCC_RR_FININST_INFO_TL

 Yes Yes Yes Yes* 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 Yes Yes No No The International Organization for Standardization (ISO) currency list.
12 FCC_RR_MAP_JURIS_TMPLT_TYPE Yes Yes Yes Yes Yes The mapping of the FI's regulatory jurisdiction and the applicable STR/SAR template for those jurisdictions.
13 FCC_RR_INSTALL_PARAM Yes Yes Yes No No The configuration details such as, Date format, Locking Period, and so on.
14

FCC_RR_CODE_DESC_B

FCC_RR_CODE_DESC_TL

 Yes No Yes No No This provides configuration for digital currency and relation type.
15 FCC_RR_CASETYPE_REASON_MAP No No No Yes No

To map case type to Reason for Suspicion

NOTE: Map DEFAULT as a case type to any reason. If you do not specify any case type, then you can opt DEFAULT case type.

For more information on sample templates, see Data format.

Note:

  • To load reference data into the PH CTR application, set column N_TMPLT_ID as 4.
  • To load reference data into the PH STR application, set column N_TMPLT_ID as 3.
  • To load reference data into the goAML application, set column N_TMPLT_ID as 28.
  • To load reference data into the USSAR application, set column N_TMPLT_IDas 1.
  • To load reference data into the AU SMR application, set column N_TMPLT_ID as 2.
  • 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.
  • In goAML, Reference Data Management is supported for Reporting Entity, Reporting Branch, and Reporting Person.
  • In USSAR, Reference Data Management is supported for Filing Institution only and does not support Financial Institution and Branch.
  • In AU SMR, Reference Data Management is supported for Reporting Entity, Reporting Branch, and Reporting Person.
  • 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