12.2.3 Control Tab

Using the Control tab, you can:

1. Reconcile between source data received and data loaded into AFCS, using the control information available from the source system. This feature is used to implement record count validation or amount reconciliation from a source file. It also allows specifying a threshold for validation. The specified threshold is compared with the difference (record count or amount) to perform the validation. The execution fails only if the difference is more than the threshold value.
2. The threshold can be an absolute or a percentage value. The connector execution process considers the threshold type while performing reconciliation.
3. Generate control information for file extracts from AFCS. Specifying control for extract EDDs generates control details, based on the configuration in the EDD. Both record count and amount value (sum, average, max, and so on) for specific columns are recorded into the control file.

   Note:

   This option is applicable only for file type EDDs (ASCII and EBCDIC).

   Table 12-2 Control Tab Description

   Fields	Description (Fields marked in red asterisk(*) are mandatory)
   When Separate File is selected as Yes.
   File Name	Specify the name of the file.
   File Format	There are two options: Fixed Length: The file has records and columns with a fixed length. Each column has a predetermined and unchanging size, set when the record layout is designed, and the sum of the column sizes add up to the record size. Delimited: There is a separation of the records and columns using a delimiter character like a comma, semicolon, hyphen, or so on. In the previous example, select Delimited.
   Column Delimiter	If the File Format is selected as Fixed Length, the Column Delimiter would be Other by default . If the File format is selected as Delimited, the following options are available in the drop-down list. Other Space Semicolon Comma Tab In the previous example, select Comma.
   Record Type Code	Used to uniquely identify a record within a file. A financial institution sometimes provides files that have data and control records within the same file. In such a case, to distinguish between data record and control record, the first field is Record Type. It has a specific value to identify that. Here, specify the value that identifies the data. Values can be ‘DATA’ and so on. For the Control record, the value is specified under the Control tab. Only the first field of a file is used for Record Type.
   Record Delimiter	The records are stored differently in different operating systems. The following options are available: MS-DOS Unix No Record Delimiter Other For example, select Unix.
   Skip number of records	Provide the number of records to be skipped. The records are skipped from the top. Generally, this is used to skip Headers. Example: If you specify this as 1, the first row in the file will be ignored.
   Text Qualifier	A character that identifies text. Generally, double quotes are prefixed and suffixed to identify text. This is optional.
   Decimal separator	Specify up to which decimal digit you want to view the result.
   Record Type Length	The length of the record type value to pick up the correct record. For example, if the control record is “DATATotal Records400” and DATA is the Record type, the length is ‘4’. This is applicable only for Control records that are of fixed length.
   Control Name Length	Based on the previous example, the Control name is “Total Records”. Therefore, the Control Name Length is ‘13’.
   Control Value Length	Based on the previous example, the Control value is 400. Hence, the length of the control value is ‘3’.
   When Separate File is selected as No.
   Record Type Code	Used to uniquely identify a record within a file. A financial institution sometimes provides files that have data and control records within the same file. In such a case, to distinguish between data record and control record, the first field is Record Type. It has a specific value to identify that. Here, specify the value that identifies the data. Values can be ‘DATA’ and so on. For the Control record, the value is specified under the Control tab. Only the first field of a file is used for Record Type.
   Control Value Length	Based on the previous example, the Control value is 400. Hence, the length of the control value is ‘3’
   Control Name Length	Based on the previous example, the Control name is “Total Records”. Hence, the Control Name Length is ‘13’.
   Controls
   Control Name	Specify the name of the control.
   Aggregation Method	Select either Aggregation Method or Count. The supported aggregation methods are as follows: Min Max Average Sum
   Aggregation Column Name	Select the column on which the aggregation method is applied. NOTE: For count, no column needs to be selected.
   Threshold Type	This field is optional. There are two available options for threshold: percentage or absolute. If you select percentage, the reconciliation difference in percent is matched against this threshold value. If you select absolute, the absolute percent difference is matched against this threshold value.
   Threshold Value	Specify the difference value in percent or absolute.