Extracts calculation detail for a plan item between the start date and end date.

GETDETAIL("DefName", StartDate, EndDate, Type, MeasDate (optional))

"DefName": the name of the item for which you need additional detail. This name must be enclosed in quotes.

Startdate: the earliest date that the detail should be extracted.

EndDate: the latest date that the detail should be extracted.

Type: refer to the following to determine the type code to use:

• 0: Net Deposits/Withdrawals (excluding interest)
• 1: Deposits only (excluding interest)
• 2: Withdrawals only (excluding interest)
• 3: Net interest credited
• 4: Interest rate
• 5: Interest rate (for terminated participants if separate rate)
• 6: Employee DB contributions (any). Note that this does not include opening balance amounts.
• 7: Employee DB contributions (pre-tax only). Note that this does not include opening balance amounts.
• 8: Employee DB contributions (post-tax only). Note that this does not include opening balance amounts.
• 9: DC contributions (any)
• 10: DC contributions (employee only)
• 11: DC contributions (employer only)
• 12: DC contributions (catchup only)
• 13: Rollover/transfer

• 0: Unit amount
• 1: Unit reported amount
• 2: Bank balance (at end of period)

MeasDate: this is the date as of which the amount determination is to be made for purposes of getting the requested detail.

If no date is passed here, DB Precision will measure as of the end date passed and if any calculation has already been done on or after the end date, the system will pull calculation details from those results.

This date generally only needs to be specified if you need to specify an exact calculation and account determination date (that is then equal to this date) for determining this detail.