1.1 Process Purge Frequency Maintenance Detail

This topic provides the systematic instructions 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.
  1. On Home Screen, type UTDPURGS in the text box, and click Next.
    The Purge Frequency Maintenance Detail screen is displayed.

    Figure 1-1 Purge Frequency Maintenance Detail


    Description of Figure 1-1 follows
    Description of "Figure 1-1 Purge Frequency Maintenance Detail"

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

    Table 1-1 Purge Frequency Maintenance Detail - Field Description

    Field Description
    Basic Information Section This section displays all basic 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:
    • Daily
    • Weekly
    • Bi-Weekly
    • Monthly
    • Quarterly
    • Half Yearly
    • Yearly
    • Not Scheduled

    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:
    • Daily
    • Weekly
    • Bi-Weekly
    • Monthly
    • Quarterly
    • Half Yearly
    • Yearly
    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:
    • Yes - If you select this option, the system will capture Pre Purge Procedure Name.
    • No - If you select this option, the Pre Purge Procedure Name is not required.
    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.
    Additional Information Section This section displays all additional details.
    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.
    Child Details The section displays the purge table and primary key details.
    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.
  3. You can view the following validations performed by the system for Purge Order.

    Note: The dynamic packages will get recreated on unlock, save and authorization.

    The system performs the following validations for Purge Order:
    • Purge Order defines the order in which the tables needs to be purged.
    • Purge order for Master table should be 0.
    • If master table is not provided in the grid, the system will use master table only for identifying the data for purge; during purge process the system will purge only the tables provided in the grid.
    • If no table information are provided in the grid, the system will delete the parent table data based on the criteria provided. If no criteria is provided, then the system will truncate the table.
    • Purge order of child tables should be greater than 0.
    • Purging of master table will be done after purging of all the child tables (if master table is provided in the grid).
    • Primary Key Column Name and Parent Primary Key Column Name: Column names of master and child tables to be provided here.
    • Details of child table to be provided in Primary Key Column Name and details of master table to be provided in Parent Primary Key Column Name.
    • Data is mandatory for all child tables.

Parent topic: Administration