Usage Note 62708: How to increase the maximum field length of the Narrative field for SARX reports in SAS® Enterprise Case Management
The maximum length of the Narrative field has increased with the new FinCEN support for Suspicious Activity Report (SAR) data in an XML report format (SARX). You can now specify a maximum length of up to 20,000 characters for the Narrative field. The default maximum length in SAS Enterprise Case Management is still 17,000 characters, to retain compatibility with the SAR format.
To increase the maximum length of the Narrative field in SAS Enterprise Case Management, make the following changes:
- Update the user interface definition file for SARX reports, rr-fincen-sarx-01.xml, as follows:
- Find the "<tab id="NarrativeTab">" tab declaration in Step 5 of the file.
- In the tab, find the definition for the field, "RR.X_SAR_NARRATIVE_DESC." Change the value of the max-length attribute to the desired maximum field length, up to a maximum of 20000.
<field name="RR.X_SAR_NARRATIVE_DESC" type="textarea" length="180" rows="10" required="true"
max-length="20000">
<label>
<message key="field.rr.x_sar_narrative_desc.label.txt"/>
</label>
</field>
- Update the field length for the RR.X_SAR_NARRATIVE_DESC field.
- Option 1: Modify the rr_udf_def_sarx.csv file in the SAS-configuration-directory/Levn/Applications\SASEnterpriseCaseManagement\Source\form_template directory.
- Note: You can use this option only if you are performing the initial configuration, and you have not executed the loadrr_config_fincen_sarx.sas macro.
- In the file, find the row containing the "X_SAR_NARRATIVE_DESC" field. Change the value of 17000 for the MAX_CHAR_CNT column in that row to your desired maximum field length, such as 20000.
RR,X_SAR_NARRATIVE_DESC,LNGVARCHAR,20000,,Suspicious Activity Information - Narrative
- Option 2: Update the RR_UDF_DEF table in the SAS Enterprise Case Management database.
- Find the row where udf_table_nm='RR' and udf_nm='X_SAR_NARRATIVE_DESC'. Change the value of the MAX_CHAR_CNT column from 17000 to your desired maximum field length, such as 20000, as shown in the example below:
update ecm_db.rr_udf_def
set max_char_cnt=20000
where udf_table_nm='RR' and udf_nm='X_SAR_NARRATIVE_DESC';
Note: If you increase the field length but also use the SAR format, you should verify that the user interface definition file for the SAR format contains a valid limit. Verify that the max-length attribute for the RR.X_SAR_NARRATIVE_DESC field in the rr-fincen-sar-01.xml file is set to 17000, as shown below:
<field name="RR.X_SAR_NARRATIVE_DESC" type="textarea" length="180" rows="10" required="true"
max-length="17000">
<label>
<message key="field.rr.x_sar_narrative_desc.label.txt"/>
</label>
</field>
Operating System and Release Information
| SAS System | SAS Enterprise Case Management | 64-bit Enabled Solaris | 6.3_M1 | | 9.4 TS1M3 | |
| 64-bit Enabled AIX | 6.3_M1 | | 9.4 TS1M3 | |
| Microsoft® Windows® for x64 | 6.3_M1 | | 9.4 TS1M3 | |
| Linux for x64 | 6.3_M1 | | 9.4 TS1M3 | |
*
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be
fixed.
You can increase the maximum field length for the Narrative in SARX reports to 20,000 characters. The default maximum value of 17,000 is maintained for compatibility with SAR reports.
| Date Modified: | 2018-08-08 17:10:03 |
| Date Created: | 2018-08-02 16:51:34 |