. The
selected file is removed from the list.Use this section to understand how to prepare and load the required data for using OFS CRR CS.
· Data Preparation: Use this section to prepare the customer seeded data in the required .csv (comma-separated value) format or Admin UI. This section provides the complete list of tables and corresponding .csv files.
· Data Loading: Use this section to load data into the system using the Excel Upload option.
Use this section to prepare the required customer seeded data to load into the system.
Topics:
· Mapping and Loading Reporting Person
Use this section to prepare the required data and report type to load into the system using the .csv format.
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.
Tables and description
S.No
|
Table Name |
goAML |
US SAR |
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 the 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 Financial Intelligence Unit (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 in which the Financial Institution is based out. |
9 |
FCC_RR_REPORT_TYPE_B FCC_RR_REPORT_TYPE_TL |
Yes |
Yes |
Yes |
Yes |
No |
The type of report. This defines template type whether goAML or USSAR |
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: A default flag is provided to enable the default Financial Institution or reporting entity on UI. |
11 |
FCC_RR_MAP_JURIS_TMPLT_TYPE |
Yes |
Yes |
Yes |
No |
No |
The mapping of the FI's regulatory jurisdiction and the applicable STR/SAR template for those jurisdictions. |
12 |
FCC_RR_INSTALL_PARAM |
Yes |
Yes |
Yes |
Yes |
Yes |
The configuration details such as Date format, Locking Period, and so on. |
13 |
FCC_RR_CURRENCY_B FCC_RR_CURRENCY_TL |
Yes |
Yes |
Yes |
No |
No |
The International Organization for Standardization (ISO) currency list. |
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 |
This is 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, 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 goAML application, set column N_TMPLT_ID as 28. · To load reference data into USSAR application, set column N_TMPLT_ID as 1. · To load reference data into 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 AUS 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 |
Use this section to prepare the required customer seeded data into the system using admin UI.
NOTE:
· You must configure Jurisdiction Template Mapping first and followed by the rest of admin UI features.
· Based on the selection of the Template, fields and mandatory fields dynamically change.
To access these sections, follow these steps:
1. Log in to Oracle RR Cloud Service as an Admin and click Oracle Financial Services Crime and Compliance Management Anti Money Laundering Cloud Service.
2. On the Navigation List (LHS), click Compliance Regulatory Reporting Administration. The following list is displayed.
§ Country
§ Currency
§ Employer
§ Reporting Person Identification
§ Status
§ State
This section provides information about the branch where the transaction has taken place. Here you can manage the existing branch information and add new branch details.
To add new branch information, follow these steps:
1. On the Navigation List, click Branch Information. The Branch Information page is displayed with the list of existing branch details.
2. To view the list of branch details, select the required temple from the Template drop-down list. For example, goAML, USSAR, AUSAR, and so on.
3. To add new branch information, click Add button. The Branch Details window is displayed.
4. Enter the details of the required fields in the Branch Details window.
The following table explains the Branch Details fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the template from the drop-down list to which you want to add new branch details. For example, goAML, USSAR, AUSAR, and so on. |
Financial Institution |
Select the Financial Institution from the drop-down list. |
Branch Code |
Enter the branch code details. |
Country |
Enter the name of the country where this branch is situated. |
State |
Enter the name of the state where this branch is situated. |
Set as Default? |
Select whether this branch is a default branch. |
Is Active? |
Select whether this branch is active. |
RSSD Number |
Enter RSSD Number. The RSSD ID is a unique identifier assigned to financial institutions by the Federal Reserve. |
Branch Tin |
Enter the branch Tin. The TIN is Tax Identification Number. |
Branch Territory Code |
Enter the branch territory code. |
Branch Area Code |
Enter the branch area code. |
Branch Phone |
Enter the branch phone number. |
Branch Fax |
Enter the branch fax number. |
Branch Email |
Enter the branch email. |
Zip Code |
Enter the branch zip code |
5. Click Save. New branch information is added to the Branch Information list page.
6. To edit the existing branch information, select the required Record Number and click Edit. The Branch Details window is displayed.
7. Modify the required details in the fields. For more information on the fields, see the above table.
8. Click Save. The branch details are modified and updated.
This section provides information about the mapping between report type and case type. Here you can manage the existing case-type reason and add new case-type reason details.
To add a new case-type reason, follow these steps:
1. On the Navigation List, click Case Type Reason. The Case Type Reason page is displayed with the list of existing Case Type Reason details.
2. To add a new case type reason, click Add button. The Case Type Reason window is displayed.
3. Enter the details of the required fields in the Case Type Reason window.
The following table explains Case Type Reason fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Case Type Code |
Select the required case type code from the Case Type Code drop-down list. |
Reason |
Enter the reason for the case type. Mention the default reason for case type. This is applicable for PHSTR. NOTE: You can enter up to 1000 characters. |
4. Click Save. A new case type reason is added to the Case Type Reason list page.
5. To edit the existing case type reason details, select the required case type code and click Edit. The Case Type Reason window is displayed.
6. Modify the required details in the fields (You can only modify Reason field). For more information on the fields, see the above table.
7. Click Save. The case type reason details are modified and updated.
This section provides information about the configuration for digital currency and relation type. Here you can manage the existing code set and add new code set details. This is applicable for AUSMR.
To add a new code set, follow these steps:
1. On the Navigation List, click Code Set Configuration. The Code Set Configuration page is displayed with the list of existing Code Set details.
2. To view the list of code set, select the required temple from the Template drop-down list. For example, USSAR, AUSAR, and so on.
3. To add a new code set, click Add button. The Code Set window is displayed.
4. Enter the details of the required fields in the Code Set window.
The following table explains Code Set fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Code Set |
Select the code set from the Code set drop-down list (Relation Type or Digital Currency). |
Code Value |
Enter the code value. This is currency code value. For example, INR, USD, and so on. NOTE: You can enter up to 25 characters. |
Locale |
Displays language. By default, it is the English language. |
Code Description |
Enter the code value. This is currency code description. For example, INR, USD, and so on. NOTE: You can enter up to 1000 characters. |
5. Click Save. A new code set is added to the Code Set list page.
6. To edit the existing code set details, select the required code set and click Edit. The Code Set window is displayed.
7. Modify the required details in the fields (You can only modify the Code Description field). For more information on the fields, see the above table.
8. Click Save. The code set details are modified and updated.
This section provides information about the International Organization for Standardization (ISO) country list. Here you can manage the existing country and add new country details.
To add a new country, follow these steps:
1. On the Navigation List, click Country. The Country page is displayed with the list of existing country details.
2. To view the list of country, select the required temple from the Template drop-down list. For example, USSAR, AUSAR, and so on.
3. To add a new country, click Add button. The Country window is displayed.
4. Enter the details of the required fields in the Country window.
The following table explains Country fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Country Set |
Enter the country code. NOTE: You can enter up to three characters. |
Country ID |
Enter the country Identification number. NOTE: You can enter up to 20 characters. |
Locale |
Displays the language. By default, it is the English language. |
Country Name |
Enter the name of the country. NOTE: You can enter up to 255 characters. |
5. Click Save. A new country is added to the Country list page.
6. To edit the existing country details, select the required country and click Edit. The Country window is displayed.
7. Modify the required details in the fields (You can only modify the country name field). For more information on the fields, see the above table.
8. Click Save. The country details are modified and updated.
This section provides information about the International Organization for Standardization (ISO) currency list. Here you can manage the existing country and add new country details.
To add a new currency, follow these steps:
1. On the Navigation List, click Currency. The Currency page is displayed with the list of existing currency details.
2. To view the list of currency, select the required temple from the Template drop-down list. For example, USSAR, AUSAR, and so on.
3. To add a new currency, click Add button. The Currency window is displayed.
4. Enter the details of the required fields in the currency window.
The following table explains currency fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Currency code |
Enter the currency code. NOTE: You can enter up to three characters. |
Locale |
Displays the language. By default, it is the English language. |
Currency Name |
Enter the name of the currency. NOTE: You can enter up to 255 characters. |
5. Click Save. A new currency is added to the Currency list page.
6. To edit the existing currency details, select the required currency and click Edit. The Currency window is displayed.
7. Modify the required details in the fields (You can only modify the Currency Name field). For more information on the fields, see the above table.
8. Click Save. The Currency details are modified and updated.
This section provides information about the employer who is reporting the transaction. This is the employer whom FIU can contact if more details are required.
To add a new Employer, follow these steps:
1. On the Navigation List, click Employer. The Employer page is displayed with the list of existing employer details.
2. To view the list of employers, select the required temple from the Template drop-down list. For example, PHSTR, USSAR, and AUSAR.
3. To add a new employer, click Add button. The Employer window is displayed.
4. Enter the details of the required fields in the employer window.
The following table explains employer fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Gender |
Select the gender from the drop-down list. |
Date Of Birth |
Select the date of birth from the calendar. |
SSN |
Enter the Social Security number. NOTE: You can enter up to 255 characters. |
Email ID |
Enter the email address. |
Nationality 1, Nationality 2, and Nationality 3 |
Enter the Nationality 1, Nationality 2, and Nationality 3. |
Resident Country |
Select the country of residence from the drop-down list. |
Passport Number |
Enter the passport number. NOTE: You can enter up to 50 characters. |
Passport Country |
Passport Country |
ID Number |
Enter the identification number. NOTE: You can enter up to 255 characters. |
Deceased |
Select whether the employer is deceased from the drop-down list. |
Deceased Date |
Select the date of the deceased from the calendar. |
Tax Registration Number |
Enter the tax registration number. |
Person Tax Number |
Enter the person's tax number. |
Financial Institution |
Select the financial institution from the drop-down list. |
Set as Default? |
Select Yes or No from the drop-down list to set as a default. |
Is Active ? |
Select Yes or No from the drop-down list to mention it as active. |
Locale |
Displays language. By default, English is displayed. |
Title, First Name, Middle Name, Last Name, Prefix, Alias, Birthplace, Mother Name, Occupation, ID Type, Source of wealth |
Enter personal details such as Title, First Name, Middle Name, Last Name, Prefix, Alias, Birthplace, and Mother Name |
Comments |
Enter comments. |
5. Click Save. A new employer is added to the Employer list page.
6. To edit the existing employer details, select the required employer and click Edit. The Employer window is displayed.
7. Modify the required details in the fields. For more information on the fields, see the above table.
8. Click Save. The Employer details are modified and updated.
This section provides information about the Financial Institutions where the transactions have occurred. Here you can manage the existing financial institution and add new financial institution details.
To add a new financial institution, follow these steps:
1. On the Navigation List, click Financial Institution. The Financial Institution page is displayed with the list of existing financial institution details.
2. To view the list of a financial institution, select the required temple from the Template drop-down list. For example, USSAR, AUSAR, and so on.
3. To add a new financial institution, click Add button. The Financial Institution window is displayed.
4. Enter the details of the required fields in the financial institution window.
The following table explains financial institution fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Fin Inst ID |
Enter the Financial institution identification number. NOTE: You can enter up to 20 characters. |
Fin Inst Code |
Enter the Financial institution code. NOTE: You can enter up to 20 characters. |
TIN |
Enter the Taxpayer Identification Number. NOTE: You can enter up to 25 characters. |
TIN Type |
Select the Taxpayer Identification Number from the drop-down list. |
Type Of Fin Inst |
Select the type of financial institution from the drop-down list. |
Type Of Securities and Futures Inst |
Select the type of securities and futures Iist from the drop-down list. |
Country, State, Postal Code, Address Type |
Select or enter the address details such as country, state, postal code, and address type. |
Primary Fed Regulator |
Select the primary fed regulator from the drop-down list. |
Type Of Gaming Inst |
Select the type of gaming institution from the drop-down list. |
Fin Inst ID Type |
Select the financial institution identification type from the drop-down list. |
Is Filing Institution? |
Select Yes or No to specify whether it is a filing institution. |
Is Financial Institution? |
Select Yes or No to specify whether it is a financial institution. |
Currency |
Select the currency from the drop-down list. |
Set as Default? |
Select Yes or No to set as a defaulter. |
Is Active? |
Select Yes or No to set as a active. |
Preference Order |
Enter the preference order. This is applicable for goAML Template. |
Reporting Reference |
Enter reporting reference. This is applicable for goAML Template. |
FIU Reference |
Enter financial Institution reference. This is applicable for goAML Template. |
Locale |
Displays locale language. English is a default language. |
Legal Name Of The Fin Inst |
Enter the legal name of the financial institution. |
Alternate Name |
Enter the alternate name of the financial institution. |
Other Fin Inst Type Desc |
Enter the other financial institution type description. |
Other Securities and Futures Inst Type Desc |
Enter the other securities and futures institution type description. |
Address, City, Town |
Enter financial institution address details. |
Other Gaming Inst Type Desc |
Enter other gaming Institution type description. |
Comments |
Enter additional comments. |
5. Click Save. A new financial institution is added to the Financial Institution list page.
6. To edit the existing financial institution details, select the required currency and click Edit. The Financial Institution window is displayed.
7. Modify the required details in the fields (You can only modify Currency Name field). For more information on the fields, see the above table.
8. Click Save. The Financial Institution details are modified and updated.
This section provides information about configuration details such as, Date format, Locking Period, and so on. Here you can manage the existing install parameters details.
To manage install params, follow these steps:
1. On the Navigation List, click Install Params. The Install Params page is displayed with the list of existing install params details.
2. To edit the existing install params details, select the required install param name and click Edit. The Install Params window is displayed.
3. Modify the required details in the fields such as Value and Organization Name.
4. Click Save. The Install Params details are modified and updated.
This section provides information about the mapping of the FI's regulatory jurisdiction and the applicable STR/SAR template for those jurisdictions. Here you can manage the existing jurisdiction templates and add new jurisdiction template details.
To add a new jurisdiction template mapping, follow these steps:
1. On the Navigation List, click Currency. The Jurisdiction Template Map page is displayed with the list of existing jurisdiction template mapping details.
2. To add a new jurisdiction template mapping, click Add button. The Jurisdiction Template Map window is displayed.
3. Enter the details of the required fields in the Jurisdiction Template Map window.
The following table explains jurisdiction template fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Jurisdictions |
Select the required jurisdictions from the Jurisdictions drop-down list. |
Template Type |
Select the required template type from the Template Type drop-down list. |
Template |
Select the required template from the Template drop-down list. |
4. Click Save. A new jurisdiction template is added to the Jurisdiction Template Map list page.
5. To edit the existing jurisdiction template details, select the required Jurisdiction Template Map and click Edit. The Jurisdiction Template Map window is displayed.
6. Modify the required details in the fields (You can only modify the Template field). For more information on the fields, see the above table.
7. Click Save. The Jurisdiction Template Map details are modified and updated.
This section provides information about mapping between report type and case type. Here you can manage the existing report case type and add new report case type details.
To add a new report case type, follow these steps:
1. On the Navigation List, click Report Case Type. The Report Case Type page is displayed with the list of existing report case type details.
2. To view the list of report case types, select the required temple from the Template drop-down list. For example, USSAR, AUSAR, and so on.
3. To add a new report case type, click Add button. The Report Case Type window is displayed.
4. Enter the details of the required fields in the Report Case Type window.
The following table explains report case type fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Case Type Code |
Select the case type code from the drop-down list. |
Report Type Code |
Select the report type code from the drop-down list. |
5. Click Save. A new report case type is added to the Report Case Type list page.
6. To edit the existing report case type details, select the required Report Case Type and click Edit. The Report Case Type window is displayed.
7. Modify the required details in the fields (You can only modify the Report Type Code field). For more information on the fields, see the above table.
8. Click Save. The Report Case Type details are modified and updated.
This section provides information about the person who is reporting the transaction. This is the person whom FIU can contact if more details are required.
To add a new reporting person, follow these steps:
1. On the Navigation List, click Reporting Person. The Reporting Person page is displayed with the list of existing reporting person details.
2. To view the list of reporting persons, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new reporting person, click Add button. The Reporting Person window is displayed.
4. Enter the details of the required fields in the Reporting Person window.
The following table explains reporting person fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Gender |
Select the gender from the drop-down list. |
Date Of Birth |
Select the date of birth from the calendar. |
SSN |
Enter the Social Security number. NOTE: You can enter up to 255 characters. |
Email ID |
Enter the email address. |
Nationality 1, Nationality 2, and Nationality 3 |
Enter the Nationality 1, Nationality 2, and Nationality 3. |
Resident Country |
Select the country of residence from the drop-down list. |
Passport Number |
Enter the passport number. NOTE: You can enter up to 50 characters. |
Passport Country |
Passport Country |
ID Number |
Enter the identification number. NOTE: You can enter up to 255 characters. |
Deceased |
Select whether Reporting Person is deceased from the drop-down list. |
Deceased Date |
Select the date of the deceased from the calendar. |
Tax Registration Number |
Enter the tax registration number. |
Person Tax Number |
Enter the person's tax number. |
Employer Name |
Select the employer's name from the drop-down list. |
Financial Institution |
Select the financial institution from the drop-down list. |
Set as Default? |
Select Yes or No from the drop-down list to set as a default. |
Is Active ? |
Select Yes or No from the drop-down list to mention it as active. |
Locale |
Displays language. By default, English is displayed. |
Title, First Name, Middle Name, Last Name, Prefix, Alias, Birthplace, Mother Name, Occupation, ID Type, Source of wealth |
Enter personal details such as Title, First Name, Middle Name, Last Name, Prefix, Alias, Birthplace, and Mother Name |
Comments |
Enter comments. |
5. Click Save. A new reporting person is added to the Reporting Person list page.
6. To edit the existing reporting person details, select the required Reporting Person and click Edit. The Reporting Person window is displayed.
7. Modify the required details in the fields. For more information on the fields, see the above table.
8. Click Save. The Reporting Person details are modified and updated.
This section provides information about the reporting person's address. This is the person whom FIU can contact if more details are required.
To add a new reporting person address, follow these steps:
1. On the Navigation List, click Reporting Person Address. The Reporting Person Address page is displayed with the list of existing reporting person address details.
2. To view the list of reporting person addresses, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new reporting person address, click Add button. The Reporting Person Address window is displayed.
4. Enter the details of the required fields in the Reporting Person Address window.
The following table explains reporting person Address fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Reporting Person Name |
Select the reporting person's name from the drop-down list. |
Identification Type |
Select the reporting person's identification type from the drop-down list. |
Country, State |
Select the country, state from the drop-down list. |
Address Type |
Select the type of address from the drop-down list. |
Zip Code |
Enter zip code details. NOTE: You can enter up to 50 characters. |
Comments |
Enter comments. |
Address, District, City, Town |
Enter Address, District, City, and Town details. |
5. Click Save. A new reporting person Address is added to the Reporting Person Address list page.
6. To edit the existing reporting person details, select the required Reporting Person Address and click Edit. The Reporting Person Address window is displayed.
7. Modify the required details in the fields (you cannot modify Template and Reporting Person Name fields). For more information on the fields, see the above table.
8. Click Save. The Reporting Person Address details are modified and updated.
This section provides information about the reporting person's identification details. For example, passport, driving license, and so on. Here you can manage the existing reporting person identification and add new reporting person identification details.
To add a new reporting person identification, follow these steps:
1. On the Navigation List, click Reporting Person Identification. The Reporting Person Identification page is displayed with the list of existing Reporting Person Identification details.
2. To view the list of reporting person identification, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new reporting person identification, click Add button. The Reporting Person Identification window is displayed.
4. Enter the details of the required fields in the Reporting Person Identification window.
The following table explains reporting person identification fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Reporting Person Name |
Select the reporting person's name from the drop-down list. |
Identification Type |
Select the reporting person's identification type from the drop-down list. |
Country, State |
Select country, state from the drop-down list. |
Identification Number |
Enter the identification number. NOTE: You can enter up to 255 characters. |
Issue Date and Expiry Date |
Select the issue date and expiry date from the calendar. |
Issue By |
Enter issuing authority details. NOTE: You can enter up to 20 characters. |
Comments |
Enter comments. |
5. Click Save. A new reporting person identification is added to the Reporting Person Identification list page.
6. To edit the existing reporting person identification details, select the required Reporting Person Identification and click Edit. The Reporting Person Identification window is displayed.
7. Modify the required details in the fields (you cannot modify Template and Reporting Person Name fields). For more information on the fields, see the above table.
8. Click Save. The Reporting Person Identification details are modified and updated.
This section provides information about the reporting person's phone details. Here you can manage the existing reporting person's phone and add reporting person new phone details.
To add a new reporting person phone, follow these steps:
1. On the Navigation List, click Reporting Person Phone. The Reporting Person Phone page is displayed with the list of existing Reporting Person Phone details.
2. To view the list of reporting person phones, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new reporting person's phone, click Add button. The Reporting Person Phone window is displayed.
4. Enter the details of the required fields in the Reporting Person Phone window.
The following table explains reporting person phone fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Reporting Person Name |
Select the reporting person's name from the drop-down list. |
Contact Type |
Select the reporting person's contact type from the drop-down list. |
Communication Type |
Select the reporting person's communication type from the drop-down list. |
Country Phone Code |
Enter country phone code. |
Country Phone Code |
Enter a phone number. |
Country Phone Code |
Enter phone number extension. |
Comments |
Enter comments. |
5. Click Save. A new reporting person phone is added to the Reporting Person Phone list page.
6. To edit the existing reporting person phone details, select the required Reporting Person Phone and click Edit. The Reporting Person Phone window is displayed.
7. Modify the required details in the fields (you cannot modify Template and Reporting Person Name fields). For more information on the fields, see the above table.
8. Click Save. The Reporting Person's Phone details are modified and updated.
This section provides information about report type. Here you can manage the existing report type and add new report type details.
To add a new report type, follow these steps:
1. On the Navigation List, click Report Type. The Report Type page is displayed with the list of existing report type details.
2. To add a new report type, click Add button. The Report Type window is displayed.
3. Enter the details of the required fields in the Report Type window.
The following table explains report-type fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Report Type Code |
Select the required report type code from the drop-down list. |
Comment |
Enter the required comments. NOTE: You can enter up to 4000 characters. |
Is Active? |
Select Yes or No to specify whether the report type is active from the drop-down list. |
Report Type Name |
Enter report type name. NOTE: You can enter up to 4000 characters. |
Report Type Description |
Enter report type description. NOTE: You can enter up to 6000 characters. |
4. Click Save. A new report type is added to the Report Type list page.
5. To edit the existing report type details, select the required Report Type and click Edit. The Report Case Type window is displayed.
6. Modify the required details in the fields (You can not modify the Report Type Code field). For more information on the fields, see the above table.
7. Click Save. The Report Type details are modified and updated.
This section provides information about the status of the report. Here you can manage the existing report status and add new report status details.
To add a new report status, follow these steps:
1. On the Navigation List, click Report Status. The Report Status page is displayed with the list of existing Report Status details.
2. To view the list of report status, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new report status, click Add button. The Report Status window is displayed.
4. Enter the details of the required fields in the Report Status window.
The following table explains report status fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Code |
Select the reporting person's name from the drop-down list. |
Is Read Only |
Select Yes or No to specify whether the status is read-only. |
Name |
Enter the name of the status. |
Description |
Enter the required description. |
5. Click Save. A new report status is added to the Report Status list page.
6. To edit the existing report status details, select the required Report Status and click Edit. The Report Status window is displayed.
7. Modify the required details in the fields (you cannot modify the Template and code fields). For more information on the fields, see the above table.
8. Click Save. The Report Status details are modified and updated.
This section provides information about the state of the financial institution. Here you can manage the existing state and add new state details.
To add a new state, follow these steps:
1. On the Navigation List, click State. The State page is displayed with the list of existing State details.
2. To view the list of state, select the required temple from the Template drop-down list. For example, USSAR and AUSAR.
3. To add a new state, click Add button. The State window is displayed.
4. Enter the details of the required fields in the State window.
The following table explains state fields. The fields marked asterisk * are mandatory.
Fields |
Description |
Template |
Select the required template from the Template drop-down list. |
Country Code |
Select the country code from the drop-down list. |
State Code |
Select the state code from the drop-down list. |
State Name |
Enter the name of the state. |
5. Click Save. A new state is added to the State list page.
6. To edit the existing state details, select the required State and click Edit. The State window is displayed.
7. Modify the required details in the fields (you can only modify state name fields). For more information on the fields, see the above table.
8. Click Save. The State details are modified and updated.
While preparing data, map Reporting Person to Reporting Person's Address, Phone, and Identification.
After mapping, you must upload the Reporting Person and Reporting Person's Address, Phone, and Identification in the following sequence:
1. Upload Reporting Person.
2. Upload Reporting Person Address, Phone, and Identification.
NOTE: The N_RPTNG_PERSON_SKEY* in FCC_RR_RPTNG_PRSN_ADDR , FCC_RR_RPTNG_PRSN_PHONE, and FCC_RR_RPTNG_IDENTIFICATION tables must be same as N_RPTNG_PERSON_SKEY* in FCC_RR_REPORTING_PERSON.
After you have prepared data in the .csv file using Table 4, you can upload reference data into the system. If there is any correction to be made to the uploaded reference data, you can download the uploaded reference data tables, edit, and upload them into the system.
To upload reference data into the system, follow these steps:
1. In the Navigation List LHS menu, select Compliance Regulatory Reporting Administration, and click Reference Data Upload. The Reference Data Upload page is displayed.
2. Click Drop files here or click upload. Select the .csv file from your system. The uploaded file is displayed with File Name, Filesize, and File Type in the file list.
3. Select the required file from the list and click Upload. The file is uploaded to the system.
NOTE: You can upload only one file at a time.
4. To remove
the file from the list, select the required File
Name and click Remove File
. The
selected file is removed from the list.
5. In case, you want to modify the uploaded reference data, go to the Reference Data Download Section, select the table from the Select to Download drop-down list and click Download. Modify the required information and upload the reference data table by repeating steps 2 and 3.
NOTE:
This section applies only to the PH CTR Application.
After you load the CTR-related data, you must run the following batches.
· Ingestion
· PHCTRScenario_Daily
· PHCTRDataLoad
For more information on scheduling batches, see Using Scheduler Service.