Load Detail and Load Group Data Structures

The data model uses a group and detail structure to allow efficiency in storing data and to allow the modeling of a schedule of fees. For instance, when a fund offers a schedule of different fees, front load fees often change with the level of investment, each breakpoint in that fee structure will have the same group identifier. A new group for a particular CRSP Fund Number is created only when the fees change. During each update, if the fund continues to charge the same fees, the only change is to the “end date” of the group.

Front Load

Item ID Item Name Definition Header
front_group_no Front Group Number Unique identifier for the front load group. This item allows a schedule of front load fees to be grouped together. Front Group
fflbegdt Front Load Begin Date Load effective date range beginning and ending dates BegDt
fflenddt Front Load End Date EndDt
fdollar_amt Dollar Amount of Sales Charge Represents a breakpoint in a schedule of generally declining front load fees. If missing, front_load is the maximum front load for the fund.

Data available beginning 1992
DollarAmt
front_load Front Load Front load for investments represents maximum sales charge at breakpoint (represented in decimal format i.e. .075=7.5%) Front Load

Rear Load

Item ID Item Name Definition Header
rear_group_no Rear Load Group Number Rear Group Number - Unique identifier for the rear load group. This item allows a schedule of rear load fees to be grouped together. Rear Group
frlbegdt Rear Load Begin Date Load effective date range beginning and ending dates BegDt
frlenddt Rear Load End Date Load effective date range beginning and ending dates EndDt
load_type Load Type R = Redemption
C = Contingent Deferred Sales Charge (CDSC)
D = The time period for these records are in days and not months as with the other types
O = Historical records in which a distinction wasn’t made between the R and C load types. The previous source simply referred to all these rear loads as “other load,” hence the “O.”
Load Type
finv_lvl Investment Level Dollar Amount Dollar amount of investment level

Data available beginning January 2008
Inv Lvl
ftime_period Rear Load Time Period When investment is held this number of months or less, the associated rear-load fee applies Time
rear_load Rear Load Fee Fee charged when withdrawing funds Rear Load