6.26 Using the Account Trim Table

Many institutions modify their customer's account identifiers with additional information in prefix or suffix format during ingestion into the Oracle data model. In order to support filing only the publicly available and non-modified account identifiers to FinCEN, institutions can define configurable logic for trimming account identifiers prior to being added to the E-File.

The Account Trim table (KDD_ACCT_TRIM) contains the trim function to be configured based on a value in the account ID. The Account Type is referencing a value in the prefix or suffix in the current account internal identifier.

For Example:

Account number = DDA000011223344556610000 
ACCT_TYPE ALTERATION_FUNCTION
DDA SUBSTR('##ACCT_NAME##',8,20)

Syntax: SUBSTR('@Place holder no change required@',Start Position,Substring_Length to be displayed from the start position - Cannot have negative value)

Post trimming, the Account ID in the E-File will be populated as "1122334455661" for the respective account record. If the condition specified in the Account Trim table is not met, then the entire account number will be populated in the E-File.