Skip to main content

MatDateCheck

1. Description​

The MatDateCheck Derivation Type is used to ensure maturity date is not earlier than As-On-Date.

2. Screen Configuration​

mat_date_check_image

For the specified columns it will check if the date value of those columns are less than or greated than AS_ON_DATE. Let's assume CustId="C1" and AccNum="A01", then it will give "C1_A01" in the output.

3. Required Fields​

  • name: Output Field Name.
  • data_type: Output Field Type. Possible values are: "String".
  • dervation
    • derivation_type: The calculation type used is "MatDateCheck".
    • req_fields
      • col_name: Field names from the input metadata.
      • date_format: Date format to be checked for the mentioned columns value.