Returns the specified amount for a Plan Sponsor Reported Amount based upon the parameters provided.

RPTAMTLOOKUP("RptAmtName", Date, MatchType, ReturnType, IgnoreProjected, IgnoreEstimated)

"RptAmtName": the name of the Reported Amount that is being analyzed. This name must be enclosed in quotes.

Date: date for which reported 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 amounts should be retrieved.

• 0: retrieve reported amount without annualization
• 1: retrieve reported amount with annualization (based upon a 365-day year)
• 2: retrieve effective date of reported amount
• 3: retrieve stop date of reported amount
• 4: retrieve all amounts with same month as specified date
• 5: retrieve all amounts with same quarter as specified date
• 6: retrieve all amounts with same half year as specified date
• 7: retrieve all amounts with same year as specified date
• 8: retrieve all amounts since initial hire date to specified date
• 9: retrieve minimum of all amounts from initial hire date to specified date
• 10: retrieve maximum of all amounts from initial hire date to specified date
• 11: retrieve additional identifier
• 12: retrieve all retrieve date received
• 13: retrieve reported amount with annualization (based upon completed months)
• 14: retrieve reported amount with annualization (based upon nearest months)
• 15: retrieve reported amount with annualization (based upon next-highest months)
• 16: retrieve latest prior reported amount that is different from current reported amount as of CALCDATE. If there is no prior reported amount that is different from the current amount, the current reported amount will be returned.
• 17: retrieve number of amounts on date
• 18: retrieve secondary additional identifier
• 19: retrieve third additional identifier

IgnoreProjected (optional): TRUE indicates that projected amounts should be ignored when performing the lookup (default is FALSE).

IgnoreEstimated (optional): TRUE indicates that estimated amounts should be ignored when performing the lookup (default is FALSE).

RPTAMTLOOKUP("HOURS", CALCDATE, FALSE, 0, FALSE, FALSE): retrieves latest hours as of the calculation date