Returns a Sponsor Amount as of the specified date.

SPONSORAMTLOOKUP("AmtName", Date, Employer (optional), MatchType (optional), ReturnType (optional), AdditionalKey1 (optional), AdditionalKey2 (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).

MatchType: 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: 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