The Fund Manager component is equipped to manage administrative activities, which include the purging of data, maintenance of extraction information for extraction of data from the FIC application. This chapter explains these functions.
This chapter also explains the Query Builder, which can be used to construct user defined query statements to obtain information from the database.
This chapter contains the following sections:
This section contains the following topics:
You can use this screen to maintain the frequency of purging for the tables in the system. According to the frequency specified here, the tables are purged during the End of Day processes.
Invoke the ‘Purge Frequency Maintenance Detail’ screen by typing ‘UTDPURGS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button. The ‘Purge Frequency Maintenance Detail’ screen is displayed. Select ‘New’ from the Actions menu in the Application tool bar or click new icon to enter the details.
Purge Key
Alphanumeric; 100 Characters; Mandatory
Purge key is the purge name that you need to maintain.
Table Name
Alphanumeric; 50 Characters; Mandatory
The name of the table for which a purge frequency must be set up is displayed here.
Purge Frequency
Optional
Specify the frequency at which the selected table must be purged as part of the End of Day processes. You can use the drop-down list to make your choice. Following are the options available in the drop-down list:
If purge frequency is maintained as not scheduled, the system will ignore this purge activity from execution during EOD.
Last Purge Date
Date Format; Optional
Specify the last purge date.
Retention Period
Numeric; 22 Characters; Optional
Specify the retention period in days based on retention period and frequency maintained.
Retention Frequency
Optional
Select the retention frequency from the drop-down. Following are the options available in the drop-down list:
Retention Period in Days
Numeric; 22 Characters; Optional
Specify the retention period in days based on the Retention Period Value and Frequency. For instance, If Retention Period is 1, and Retention Frequency is selected as weekly then you need to specify 7 in this field (1*7days in a week=7).
Pre Purge Procedure Required?
Optional
You can execute a pre-defined procedure before the purging activity from the drop-down list. The list displays the following values:
Pre Purge Procedure Name
Alphanumeric; 35 Characters; Mandatory if Pre Purge Procedure Required? is selected as ‘Yes’
Specify the pre purge procedure name.
Column Referred For Retention
Alphanumeric; 50 Characters; Optional
Specify the column in the table which will be referred before processing purge. Alternatively, you can select column referred for retention from the option list. The list displays all valid column referred for retention maintained in the system.
If purge is already processed, then process will start from the last purge date.
Dynamic Procedure Name
Alphanumeric; 35 Characters; Mandatory
Specify the dynamic procedure name.
The system will create dynamic procedure during authorization. The system will validate the parameters provided for purging. If the specified procedure name already exists, then the system displays an override message.
Authorization will fail if dynamic procedure cannot be created without errors.
Archive Required?
Optional
Select ‘Yes’ if you want backup to be taken before purge. Else select ‘No’.
If you select ‘Yes’, the system will copy the existing data into corresponding purge tables specified in the grid.
Note
Actual Table and corresponding purge table should be in same number of columns and order of columns. If there is mismatch, dynamic procedure creation will fail and maintenance cannot be authorized.
If you select ‘No’, the system will delete the data from the table.
Commit Counter
Numeric; 22 Characters; Optional
Specify commit frequency for archival/purging activity. If maintained, it should be greater than zero. If you do not provide commit frequency, then the system will consider static maintenance available. In the absence of static data, system will default 10000 as commit counter.
Installation Criteria
Alphanumeric; 255 Characters; Optional
Enter the installation criteria based on which the purge will be maintained.
If any new purge activity is maintained, the same can be provided during first time maintenance only. Subsequent amendment of this value is restricted.
User Criteria
Alphanumeric; 255 Characters; Optional
You can amend the purge details before process and enter the user defined criteria.
User defined Criteria is an additional criteria which will be appended to installation criteria to filter parent table data to be archived.
Purge Order
Numeric; 3 Characters; Optional
Specify the purge order details.
Table Name
Alphanumeric; 50 Characters; Optional
Specify the archived table name.
Archive Table Name
Alphanumeric; 50 Characters; Optional
Specify the archived table name.
Primary Key Column Name
Alphanumeric; 225 Characters; Optional
Specify the primary key name.
Parent Primary Key Column Name
Alphanumeric; 225 Characters; Optional
Specify the parent primary key column name.
The system performs the following validations for Purge Order:
Note
The dynamic packages will get recreated on unlock, save and authorisation.
This section contains the following topics:
You can retrieve a previously entered record in the Summary Screen, as follows:
Invoke the ‘Purge Frequency Maintenance Summary’ screen by typing ‘UTSPURGS’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button. Specify any or all of the following details in the corresponding fields:
Click ‘Search’ button to view the records. All the records with the specified details are retrieved and displayed in the lower portion of the screen.
Note
You can also retrieve the individual record detail from the detail screen by querying in the following manner:
You can perform Edit, Delete, Amend, Authorize, Reverse, Confirm operations by selecting the operation from the Action list. You can also search a record by using a combination of % and alphanumeric value.
Example
You can search the record for Purge Key by using the combination of % and alphanumeric value as follows:-
You can modify the details of Purge Frequency Maintenance that you have already entered into the system, provided it has not subsequently authorized. You can perform this operation as follows:
To view a record that you have previously input, you must retrieve the same in the Purge Frequency Summary screen as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized Purge Frequency must be authorized in the system for it to be processed. To authorize a record:
When a checker authorizes a record, details of validation, if any, that were overridden by the maker of the record during the Save operation are displayed. If any of these overrides results in an error, the checker must reject the record.
After a Purge Frequency Maintenance is authorized, it can be modified using the Unlock operation from the Action List. To make changes to a record after authorization:
An amended Purge Frequency Maintenance must be authorized for the amendment to be made effective in the system. The authorization of amended records can be done only from Fund Manager Module and Agency Branch module.
The process of subsequent authorization is the same as that for normal transactions.
If you want to create a new Purge Frequency Maintenance with the same attributes of an existing maintenance, you can copy the attributes of an existing Purge Frequency Maintenance to a new one.
To copy the attributes:
Indicate the ID for the new Purge Frequency Maintenance. You can, however, change the details of the new maintenance.
This section contains the following topics:
You can provide the purge fund data along with relevant audit/ history information using ‘Purge Use Case Maintenance’ screen. All tables from which data will be archived/purged will be available as factory shipped maintenance. You can purge or archive fund data based on predefined criteria. You can also purge or archive fund information along with associated maintenances, transaction data and audit trail information.
There will be a pre purge procedure which will populate the identified records for authorization. The screen will also identify records which cannot be purged for business reasons.
On authorization of the pre purged record, the system will actual archive/ purge process based on the maintained schedule. The system will log the detail of records which could not be purged along with reasons.
The system will purge/ archive all fund data including the following information:
Note
Only the data which is not interlinked to any other record will be purged/archived. Interlinked data which will lead to system inconsistency will not be archived/purged. Data once archived cannot be restored back to main tables.
You can invoke the ‘Purge Use Case Maintenance’ screen by typing ‘UTDFNPUR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Purge Function
Alphanumeric; 16 Characters; Mandatory
Specify the purge function details.
Purge Frequency
Mandatory
Select the purge frequency from the drop-down list. The list displays the following values:
Last Purge Date
Display
The system displays the last purge date.
Pre Purge Mode
Mandatory
Select the pre purge model from the drop-down list. The list displays the following values:
Commit Counter
Numeric; 8 Characters; Mandatory
Specify the commit counter.
Archive Required?
Optional
Select if archive is required or not from the drop-down list. The list displays the following values:
Table Name
Alphanumeric; 50 Characters; Mandatory
Specify the table name.
Retention Period Basis
Optional
Select the retention period basis from the drop-down list. The list displays the following values:
Retention Period
Numeric; 8 Characters; Optional
Specify the retention period.
Column Referred For Retention
Alphanumeric; 50 Characters; Optional
Specify the column referred for retention.
Post Purge Mode
Mandatory
Select the post purge mode from the drop-down list. The list displays the following values:
User Criteria
Alphanumeric; 2000 Characters; Optional
Specify the user criteria details.
Purge Key
Alphanumeric; 100 Characters; Mandatory
Specify the purge key. Alternatively, you can select purge key from the option list. The list displays all valid purge keys maintained in the system.
Purge Order
Numeric; 2 Characters; Mandatory
Specify the purge order.
Pre Purge Procedure Name
Alphanumeric; 35 Characters; Mandatory
Specify the pre purge procedure name.
Dependent Purge Key
Alphanumeric; 100 Characters; Mandatory
Specify the dependent purge key. Alternatively, you can select dependent purge key from the option list. The list displays all valid dependent purge keys maintained in the system.
This section contains the following topics:
You can retrieve a previously entered record in the Summary Screen, as follows:
Invoke the ‘Purge Use Case Maintenance Summary’ screen by typing ‘UTSFNPUR’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button. Specify any or all of the following details in the corresponding fields:
Click ‘Search’ button to view the records. All the records with the specified details are retrieved and displayed in the lower portion of the screen.
Note
You can also retrieve the individual record detail from the detail screen by querying in the following manner:
You can perform Edit, Delete, Amend, Authorize, operations by selecting the operation from the Action list. You can also search a record by using a combination of % and alphanumeric value.
Example
You can search the record for Purge Frequency by using the combination of % and alphanumeric value as follows:
You can modify the details of Purge Use Case Maintenance that you have already entered into the system, provided it has not subsequently authorized. You can perform this operation as follows:
To view a record that you have previously input, you must retrieve the same in the Purge Use Case Maintenance Summary screen as follows:
You can delete only unauthorized records in the system. To delete a record that you have previously entered:
An unauthorized Purge Use Case Maintenance must be authorized in the system for it to be processed. To authorize a record:
When a checker authorizes a record, details of validation, if any, that were overridden by the maker of the record during the Save operation are displayed. If any of these overrides results in an error, the checker must reject the record.
After a Purge Use Case Maintenance is authorized, it can be modified using the Unlock operation from the Action List. To make changes to a record after authorization:
An amended Purge Use Case Maintenance must be authorized for the amendment to be made effective in the system. The authorization of amended records can be done only from Fund Manager Module and Agency Branch module.
The process of subsequent authorization is the same as that for normal transactions.
This section contains the following topics:
You can authorize the pre-purge records. Once the record is authorized, the system will generate an interface file to verify the pre-purge records.
You can view the purge details using ‘Purge View’ screen. You can invoke this screen by typing ‘UTDPURVW’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Purge Use Case Key
Alphanumeric; 100 Characters; Optional
Specify the purge use case key. Alternatively, you can select purge use case key from the option list. The list displays all valid purge use case key maintained in the system.
Pre Purge Executed date
Display
The system displays the pre purge executed date based on the selected purge use case key..
Pre Purge Executed Appdate
Display
The system displays the pre purge executed app date based on the selected purge use case key.
Batch Ref Number
Display
The system displays the batch reference number.
Clicking ‘Authorize’ button, the system will authorize the records and will also extract a interface file in text format and will be placed in the export file path. You can use this extract to pre purge records to verify the data being purged. Once authorized, the system will purge/archive record where validations are successful as per purge schedule.
This section contains the following topics:
You can execute the pre-purge and post-purge process using ‘Purge Batch’ screen. You can invoke this screen by typing ‘UTDPURBT’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Purge Use Case Key
Alphanumeric; 60 Characters; Mandatory
Specify the purge use case key. Alternatively, you can select purge use case key from the option list. The list displays all valid purge use case key maintained in the system.
Purge Selection
Mandatory
Select the purge status from the drop-down list. The list displays the following values:
Note
Purge keys with pre/post as manual only will be listed in the purge batch screen option list based on the purge selection.
Click ‘Execute’ button to execute the purge batch.
There will be a pre purge procedure which will populate the identified records for authorization. The screen will also identify records which cannot be purged for business reasons.
On authorization of the pre purged record, the system will archive/purge process based on the maintained schedule. The system will also log the detail of records which could not be purged along with reasons.
Once archived or purged, unitholder details will not be visible in any of the following screens
This section contains the following topics:
You can trigger the purge process post maintenance of the Purge Frequency using ‘Purge Processing’ screen. Once this batch is processed, the system moves the records that are maintained for archival to the archival tables.
You can invoke ‘Purge Processing’ screen by typing ‘UTDPURGE’ in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button.
You can specify the following details:
Operation
Optional
Select the operation as Process or Execute from the drop-down list.
After selecting the operation, click ‘Save’ or ‘Ok’ button to perform the purge activity.