Returns a Sponsor Amount as of the specified date.

SPONSORAMTLOOKUP("AmtName", Date, Employer (optional), MatchType (optional), ReturnType (optional), AdditionalKey1 (optional), AdditionalKey2 (optional), Amount (optional))

• "AmtName": the name of the Sponsor Amount that is being analyzed. This name must be enclosed in quotes.
• Date: date for which sponsor amount is to be retrieved (CALCDATE for example).
• Employer (optional): employer code used for the sponsor amount lookup. The default is -1, meaning any value is allowed for this parameter.
• MatchType (optional): TRUE indicates that an exact date match to the date is required for amount retrieval. FALSE indicates that the latest amount as of the date is to be retrieved.
• ReturnType (optional): refer to the following to determine which values should be retrieved.
  • 0: amount (default)
  • 1: retrieve effective date of amount
  • 2: retrieve stop date of amount
  • 3: retrieve amount's employer code
  • 4: retrieve amount's primary additional identifier
  • 5: retrieve amount's secondary additional identifier
• AdditionalKey1 (optional): primary additional identifier used for the sponsor amount lookup. The default is -1, meaning any value is allowed for this parameter.
• AdditionalKey2 (optional): secondary additional identifier used for the sponsor amount lookup. The default is -1, meaning any value is allowed for this parameter.
• Amount (optional): amount value passed to the sponsor amount lookup. The default is -1, meaning any value is allowed for this parameter.