6.23 Configuring Contact Information
This table contains information which can be used to automatically populate the Parent Financial Institution and Location of Activity for a CTR. Based on the location identifier on the currency transaction, the CTR application will pull the matching kdd_ctr_org record into the CTR.
Some financial institutions for which parent financial institution identification is not available must have default parent institution identification in KDD_CTR_ORG table for all such CTR records.
Table 6-14 KDD_CTR_ORG table Attributes
| Column Name | Description |
|---|---|
| CTR_ID | Identifier for a specific Currency Transaction Reporting |
| ORG_INTRL_ID | Identifier for a specific organization that is unique across the enterprise. |
| DATA_DUMP_DT | Business date for which the data record is provided to Oracle Financial Services. |
| ORG_NM | Name of this organization. |
| ORG_SEQ_ID | Oracle Financial Services-specific identifier for this organization that is unique |
| ORG_TYPE_CD | Identifier of the Oracle client-specified type of this organization |
| ALT_ORG_INTRL_ID | Alternative identifier for this organization that is unique across the enterprise. |
| COST_CTR_ID | Cost center to which the Oracle client assigns this organization. |
| SRC_SYS_CD | Source system from which this data content was extracted. |
| ORG_CNTRY_CD | Country where the organization is located or headquartered. |
| CSTM_1_DT | Date field that is available for use at the Oracle client’s discretion. |
| CSTM_2_DT | Date field that is available for use at the Oracle client’s discretion. |
| CSTM_3_DT | Date field that is available for use at the Oracle client’s discretion. |
| CSTM_1_RL | Number field that is available for use at the Oracle client’s discretion. |
| CSTM_2_RL | Number field that is available for use at the Oracle client’s discretion. |
| CSTM_3_RL | Number field that is available for use at the Oracle client’s discretion. |
| CSTM_1_TX | Text field that is available for use at the Oracle client’s discretion. |
| CSTM_2_TX | Text field that is available for use at the Oracle client’s discretion. |
| CSTM_3_TX | Text field that is available for use at the Oracle client’s discretion. |
| CSTM_4_TX | Text field that is available for use at the Oracle client’s discretion. |
| CSTM_5_TX | Text field that is available for use at the Oracle client’s discretion. |
| PRCSNG_BATCH_NM | Ingestion batch in which Oracle Financial Services processed this data record. |
| JRSDCN_CD | Jurisdiction associated with this organization. |
| BUS_DMN_LIST_TX | Organization's business domain(s); for example, institutional or retail brokerage. Oracle Financial Services uses this field to control access to data across distinct business operations. |
| ORG_GRP_ID | Financial identification number for the Organization where the organization represents a financial institution. |
| ORG_DIVSN_ID | Financial identification number for the division of the Organization where the organization represents a financial institution. |
| ORG_PRMRY_FED_REG_CD | The parent financial institution primary federal regulator code for the federal regulator or BSA examiner with primary responsibility for enforcing the institution's Bank Secrecy Act compliance. |
| ORG_LEGAL_NM | The full legal name of the parent financial institution. |
| ORG_ALT_NM | The financial institution alternate name. |
| ORG_EIN_NB | The parent financial institution’s EIN. If the financial institution does not have an EIN, enter the SSN of the institution’s principal owner. Do not enter hyphens, slashes, alpha characters, or invalid entries such as all nines, all zeros, or “123456789” |
| ORG_ADDR_STRT_TX | The address of the parent financial institution headquarters |
| ORG_ADDR_CITY_NM | Enter the city of the parent financial institution headquarters. |
| ORG_ADDR_STATE_CD | Enter the code for the parent financial institution headquarters stat |
| ORG_ADDR_POSTL_CD | The parent financial institution ZIP Code. Do not include punctuation or formatting such as hyphens, periods, and spaces within the entry. A 9-digit entry cannot end with four zeros |
| ORG_FINCL_ID | Financial identification number for the Organization where the organization represents a financial institution. |
| ORG_FINCL_ID_TYPE_CD | Type of identification for the Organization where the organization represents a financial institution. |
| FINCL_ID_TYPE_OTHER_DESC_TX | Description of Organization Type if it is equal to Z (Other). |
| PARENT_ORG_FL | Indicator to specify that this organization is a parent, if the value is ‘Y’. |
| LAST_UPDATE_TS | This specifies the time stamp when the record was last update |
To automatically populate the Parent Financial Institution and Location of Activity for a CTR, use the following Insert script:
INSERT INTO KDD_CTR_ORG (CTR_ID,
ORG_INTRL_ID, DATA_DUMP_DT, ORG_NM, ORG_SEQ_ID, ORG_TYPE_CD, ALT_ORG_INTRL_ID, COST_CTR_ID, SRC_SYS_CD, ORG_CNTRY_CD, CSTM_1_DT, CSTM_2_DT, CSTM_3_DT, CSTM_1_RL, CSTM_2_RL, CSTM_3_RL, CSTM_1_TX, CSTM_2_TX, CSTM_3_TX, CSTM_4_TX, CSTM_5_TX, PRCSNG_BATCH_NM, JRSDCN_CD, BUS_DMN_LIST_TX, ORG_GRP_ID, ORG_DIVSN_ID,
VALUES(-1,
< organization ID >, NULL,
<organization Name>, NULL,
NULL, NULL,
NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
ORG_PRMRY_FED_REG_CD, ORG_LEGAL_NM, ORG_ALT_NM, ORG_EIN_NB, ORG_ADDR_STRT_TX, ORG_ADDR_CITY_NM, ORG_ADDR_STATE_CD, ORG_ADDR_POSTL_CD, ORG_FINCL_ID, ORG_FINCL_ID_TYPE_CD,
FINCL_ID_TYPE_OTHER_DESC_TX, PARENT_ORG_FL, LAST_UPDATE_TS)
< Institution Primary Federal Regulator ID>, NULL,
NULL,
<Institution EIN>,
< Institution Address >,
< Institution City >,
< Institution State >,
<Institution ZIP Code>, NULL,
NULL, NULL, 'Y', NULL
)