12.2.2 Data Tab
The following table describes the information you must provide in the Data tab when creating an EDD.
Note:
Fields marked in red asterisk (*) are mandatoryTable 12-1 Data Tab Description
Fields | Description |
---|---|
Data File Name |
You can add multiple data files to an EDD. For example, if you need to add the Term Deposits Contracts data file. There are Term Deposits Contracts data files for retail as well as corporate accounts. Therefore, to get both these details, you first add the Term Deposits Contracts data file for retail accounts, such as td_contracts%#MISDATE%_1.csv, and as the next record, add the Term Deposits Contracts data file for corporate accounts. In case the file sizes are large, it is recommended you break the file into smaller files. Optimize file size is 3 GB for each file. Example: td_contracts%#MISDATE%_1.csv |
Record Delimiter |
The records are stored differently in different operating systems. The available options are:
For example, select Unix. |
File Format |
There are two options:
For example, select Delimited. |
Text Qualifier | A character that identifies text. Generally, double quotes are prefixed and suffixed to identify text. This is optional. |
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. |
Decimal Separator | The character used to identify the decimal and fractional part. Usually point (.) or comma (,) |
Read from template | Specify if you want to use a template containing all
values in the Excel file format. If the template is not available,
create it manually by clicking Add, under the Data Elements. If the
template is available, you can browse for the template. See the File EDD
Template.
You can also drop the template in the area “Drop template here or click to select “. |
Select Template (*.xls,*.xlsx,*.csv Files Only) | Click Browse and select the required template. |
Data Elements | |
Name |
Name of the field in EDD. Example: Field name in a file or column name in a table. Note: The Field name of XML type must not be more than 25 characters and for others must not be more than 30 characters. |
Type |
This shows the Data type. Example: String, Number, Date, EBCDIC, and so on. |
Length | This is applicable only for the EBCDIC format. This is the length of the EBCDIC data type. In the case of a file, it is length only. |
Precision |
This is used to specify the number of digits after the decimal point. Example: 10.3. |
Format |
Specify the format for columns of type date here. If left blank, a default format of DD/MM/YYYY is assumed and used. Note:
For example, in the file extract, to represent the date, 31st January 2020, as “31/01/2020”, specify the format as DD/MM/YYYY for the date columns. |
Record Type Code |
This identifies the Record type in a file where Header, Trailer, and Data are of different record length and type. The values can be any string available in the text file. This value is only possible for the first field in a file. Example: The values can be DATA; CTRL to specify it is a control record. |