1. Partner Relationship Management Administration Guide
  2. HTIM MDF Period Ending Process Workflow

HTIM MDF Period Ending Process Workflow

On the last day of the current period, the MDF program account Monthly Snapshot for the current period is closed and a new Monthly Snapshot for the next period is created. This process is executed by running the HTIM MDF Period Ending Process workflow, which is illustrated in the following diagram. For information about enabling this workflow, see Process of Setting Up MDF Programs.


HTIM MDF Period Ending Process: This image is described in the surrounding text.

As shown in this diagram, the steps in this workflow are as follows:

  1. Query for the next period with an end date that is less than or equal to the current date and where the type is HTIM MDF Snapshot Month.

  2. Check if today is the end of the current period and if there are subsequent periods available:

    • If the period has not ended or there is no subsequent period available, the workflow ends.

    • If the period has ended and a subsequent period is available, the workflow creates a new Monthly Snapshot for each active MDF program account. Some fields in the new Monthly Snapshot are described in the following table.

      Field

      Description

      Beginning Balance

      Same value as the Ending Balance of the previous Monthly Snapshot.

      Accrued

      Total of all MDF accrual credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.

      Adjusted

      Total of all MDF adjustment credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.

      Reinstated

      Total of all MDF reinstatement credits for the current new period. The value is always 0 when the new Monthly Snapshot is created.

      Paid

      Total amount of all MDF debits paid for the current new period. The value is always 0 when the new Monthly Snapshot is created.

      Reserved

      Same value as the Reserved field in the previous Monthly Snapshot.

      30

      Same value as the 60 field in the previous Monthly Snapshot.

      60

      Same value as the 90 field in the previous Monthly Snapshot.

      90

      Value is TC90-TP90 where:

      TC90 is the Total Credits expiring within 60 to 90 days of this new period.

      TP90 is the Total Paid amounts equal or less than the total credits expiring within 60 to 90 days of this period.

      90+

      Value is TC90Plus-TP90Plus where:

      TC90Plus is the Total Credits expiring within 90+ days of this period.

      TP90Plus is the Total Paid amounts equal or less than the total credits expiring within 90-plus (+) days of this period.

      Available Balance

      Total of 30, 60, 90 and 90+ field values.