1.15 Perform FIC Extraction

This topic provides the systematic instructions to execute the extraction.

FCIS provides a facility that enables you to extract data to FLEXCUBE Information Centre (FIC).

In order to extract data, you must set up the parameters that will govern the extraction of this data in the system.

Use the FIC Setup screen in the Authorization Menu of the Fund Manager component to perform this task.

1. Once you have set up the parameters, you can use the Extraction Form to execute the extraction. Process the Extraction screen, click FIC Extraction under the FIC Extraction menu item in the Maintenance menu of the Browser.
2. On FIC Extraction screen, specify the fields.
   For more information on fields, refer to the field description table.

   Table 1-19 FIC Extraction - Field Description

   Field	Description
   Segment Name	Alphanumeric, Mandatory Select the segment to which the source table belongs, from the options in the drop-down list. The source table is the table in which the data to be extracted must reside.
   MIS Date	Date Format, Mandatory The application date is displayed here by default, and all the tables that are pending extraction as on this date according to their frequency of extraction, are displayed in the Extraction Details section. If you chose another date here, click the Show button to view all the tables that are pending extraction as on this date according to their frequency of extraction. The MIS date can be changed to a value prior to the system application date. The date cannot be changed to a future date.
   Extraction Details	When the MIS Date is specified, all the destination tables that are pending extraction are displayed in this section along with the following details: The Extraction Routine that is to be executed The Loading Type where I represents incremental loading and T represents total loading. The Output Area where the extracted data is to reside The most previous date on which data was extracted from this table (the Last Extract Date) If the loading type of the extract is Incremental, the From and To dates are displayed

   This information is picked up by the system from the Destination Table Details Maintenance record for each of the destination tables, and displayed here.
3. If the extraction is to proceed, you must click Extract button, and the data will be extracted to the output area. As and when a destination table is fully extracted, the table row will disappear from the list in the Extraction Details section.
   The system displays a confirmation message upon successful completion of the extraction.