1.3 Process Purge Use Case Maintenance

This topic gives the systematic instructions to provide the purge fund data along with relevant audit/ history information.

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 maintenance, 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:
  • Fund Rules (UTNFNDRL)
  • Fund Bank Account (UTDFNDAC)
  • Fund Entity (UTDFNENT)
  • Fund Calendar (UTDHOLID)
  • Fund conversion (UTDFNCVR)
  • Fund Dividend Records including payment/ reinvestment records at fund level
  • Fund WHT (UTDWHTAX)
  • Fund Price (UTDFPRIC)
  • Periodic Load (UTDPERLM)
  • Fund Switch Restriction (UTDFNSWR)
  • GL (UTDGLISD)
  • Mock Dividend (UTDMOCKD)
  • UH Balledger
  • BOD Outstanding Units
  • Corporate Action Tables Fund User (UTDFNDUS)
  • Fund Sub Acc Mapping (UTDFSAMS)
  • Fund Price Holiday (UTDFPHOL)
  • Fund Investment Component (UTDFICRM)
  • Fund CPMF (UTDFCPMF)
  • Fund Agency Limit (UTDFALMT)
  • Auto-switch Set up (UTDASSSD)
  • ADHOC price (UTDAHPRM)
  • Agent Price Basis (UTDAGTPR)
  • Fund UH Category Holding Period (UTDMINHL)
  • Unit Price Rounding (UTDPRRRL)
  • Target-based Fee (UTDTGBFE)

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.

  1. On Home Screen, type UTDFNPUR in the text box, and click Next.
    The Purge Use Case Maintenance screen is displayed.

    Figure 1-3 Purge Use Case Maintenance


    Description of Figure 1-3 follows
    Description of "Figure 1-3 Purge Use Case Maintenance"

  2. On Purge Use Case Maintenance screen, click New to enter the details.
    For more information on fields, refer to the field description table.

    Table 1-2 Purge Use Case Maintenance - Field Description

    Field Description
    Basic Information Section This section displays all basic 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:
    • Daily
    • Monthly
    • Fortnight
    • Quarterly
    • Half Yearly
    • Yearly
    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:
    • EOD
    • Manual
    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:
    • Yes
    • No
    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:
    • Daily
    • Monthly
    • Fortnight
    • Quarterly
    • Half Yearly
    • Yearly
    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:
    • EOD
    • Manual
    • Automatic
    User Criteria

    Alphanumeric; 2000 Characters; Optional

    Specify the user criteria details.
    Purge Key Details This section displays the purge key 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; Optional

    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.

Parent topic: Administration