2.15 Collateral History Summary

This topic provides the information on Collateral History Summary.

The Collateral History Summary screen (GCDCOLSH) displays the history of modifications made to the following key fields of collateral (of all types) over a period of time:
  • Available Flag
  • Available Amount
  • Collateral Block Amount
  • Pool Contribution
  • Collateral Value
  • End date
  • Haircut %
  • Lendable Margin
  • Limit Contribution
  • Record Status
  • Status
  • Tanked Utilization
  • Utilization amount

Whenever any of the collateral key field is modified through online or batch modification process, the corresponding collateral record is moved to the ‘Collateral History Summary’ screen along with the child collateral record details.

  1. On the Home screen, specify GCDCOLSH in the text box and click the Next icon.
    The Collateral History Summary screen is displayed.

    Figure 2-99 Collateral History Summary


    Description of Figure 2-99 follows
    Description of "Figure 2-99 Collateral History Summary"

    In the above screen, entries made for the collateral varies based on different scenarios.

    Scenario 1: Record Entries on Collateral Expiry

    For the collaterals whose value does not become zero on expiry, only one entry is displayed in the ‘Collateral History Summary’ screen. Whereas, for collaterals whose value becomes zero, two entries are displayed as the child expiry and collateral expiry are captured in two separate entries.

    Reference Screens for two entries:

    Figure 2-100 Collateral History Summary Reference Screen 1


    Description of Figure 2-100 follows
    Description of "Figure 2-100 Collateral History Summary Reference Screen 1"

    Figure 2-101 Collateral History Summary Reference Screen 2


    Description of Figure 2-101 follows
    Description of "Figure 2-101 Collateral History Summary Reference Screen 2"

    Scenario 2: Collateral value modification due to Currency Revaluation of one child and child expiry of another child in the same batch

    In the main screen, 'Remarks' are updated based on the Cross currency revaluation. Whereas, in the history screen, the remarks are updated based on the child expiry since the Expiry batch runs before the Currency revaluation batch.

    Since the revaluation of second child available in the collateral is done through the Expiry batch, the system does not find any key field modification to push the data to history screen and the Currency revaluation batch remarks are not pushed to history.

    However for the above case, an increment entry for modification no will be done internally. Thus, in case of two child records (one child with cross currency that goes for currency revaluation on the first EOD) with different end dates (one as today and one as tomorrow), post two EOD’s, entries with Mod No 1 & 2 for one child expiry and one prior record and entries with Mod No 4 & 5 for collateral expiry and second child expiry are displayed in the 'Collateral History Summary' screen. Mod no 3 which is not shown is for Currency revaluation which happens after the first EOD for one child.

    Reference Screens:

    Figure 2-102 Life Insurance


    Description of Figure 2-102 follows
    Description of "Figure 2-102 Life Insurance"

    Figure 2-103 Collateral History Summary


    Description of Figure 2-103 follows
    Description of "Figure 2-103 Collateral History Summary"

  2. On Collateral History Summary screen, specify the fields.

    Table 2-143 Collateral History Summary

    Field Description
    Liability No Click the Search icon and select the liability number from the list.
    Collateral Code Click the Search icon and select the collateral code from the list.
    From Date Specify the ‘From Date’ of the period for which the collateral history summary is to be queried.
    To Date Specify the ‘To Date’ of the period for which the collateral history summary is to be queried.

    Collateral Log Details

    The following details of the collateral are displayed for the selected period on clicking ‘Execute Query’ at the top left corner.

    • Mod Number
    • Collateral Code
    • Collateral Description
    • Branch Code
    • Liability No
    • Liability Branch
    • Customer No
    • Collateral Type
    • Collateral Category
    • Start Date
    • End Date
    • Available
    • Status
    • Collateral Currency
    • Collateral Value
    • Hair Cut %
    • Lendable Margin
    • Limit Contribution
    • Available Amount
    • Pool Contribution
    • Collateral Block Amount
    • Utilization Amount
    • Tanked Utilization
    • Source
    • Authorization Status
    • Record Status
    • Remarks
    • Maker Id
    • Maker Date Stamp
    • Checker ID
    • Checker Date Stamp

    The reason for modification done through both online and batch modification process is displayed in the ‘Remarks’ field.

    For online modification, the remarks are shown as ‘Modified Online’, whereas for batch modification, actual remarks are shown. For example, for currency revaluation, the Remarks is as follows: ‘Modification of collateral value due to Currency revaluation of Vehicle’.

    If the ‘Collateral Value’ is modified due to currency revaluation and expiry of the child collaterals, then the Remarks field is updated based on the expiry of the child collateral as the Expiry batch runs before the Currency revaluation batch.

    Collateral Component Details

    Click this button to view the component level details of the collateral for the selected row (mod no). The ‘Collateral Component Details History’ screen with the details of child records under the collateral pertaining to the selected mod number is displayed.

    Figure 2-104 Collateral Component Details History


    Description of Figure 2-104 follows
    Description of "Figure 2-104 Collateral Component Details History"

Parent topic: Collaterals