1. Loan Collection Setup Guide
  2. Administration System
  3. Data Files
  4. Input tab
  5. Column Definitions

2.7.2.2 Column Definitions

Each input data file definition is made up of one or more column definitions. These define the structure of data to be loaded from external system.
  1. In the Column Definitions section, perform any of the Basic Operations mentioned in Navigation chapter.
    A brief description of the fields is given below:

    Table 2-29 Column Definitions

    Field Do this
    Seq Specify the order in which the input data dump will process the column information.
    Column Name Specify name of the column.
    Column Description Specify description of the column.
    Data Type Select the data type from the drop-down list. The selected data type describes the type of data the column is expected to contain such as INTEGER/DATE/NUMBER/CHARACTER. This effects how the input data file processing handles the data, and should not be changed.
    Format Mask

    Select the format mask for the column from the drop-down list. The list displays the format depending on the Data Type selected.

    For example; Date fields may be entered using the MM/DD/YYYY format, Number fields may be entered as decimal numbers with varying degrees of precision. Other formats for each data type are available.
    Length

    Specify the column length (the maximum number of characters of the data to be included in the input file)

    Each input data details column may contain up to 240 characters of data. If the output data details column contains more data than the length value the data will be truncated. For VARIABLE records the length should be set to “-1” or a Delimited file will be created with FIXED LENGTH columns.
    Sort Specify the order in which the column definitions are to be sorted for display in the external interface screen (Customer Service > External Interfaces). There can be a maximum of 61 column definitions.
    Enabled Default selected. If not, you can check this box to enable the column definition.
  2. Perform any of the Basic Actions mentioned in Navigation chapter.

Parent topic: Input tab