Fund fees — fund_fees_YYYYMMDD.txt.gz
One file of the SQXray data dictionary. Field list (.csv)
Fund fees — fund_fees_YYYYMMDD.txt.gz
One row per share class per prospectus date: the fee stack as filed in the Risk/Return summary, the peer fee rank on the current SEC-sourced row, and the share-class type. is_current marks the newest prospectus per class.
| Field | Type | Nullable | Description | Example |
|---|---|---|---|---|
analysis_date | DATE | never blank | The date the file was published for. Only prospectuses and peer cross-sections dated on or before it are read. | 2026-08-27 |
fund_isin | VARCHAR(12) | never blank (key) | The share class's ISIN — the same key, under the same name, as every other share-class file. Always an ISIN; a class without one is not in this file. | US0014191342 |
portfolio_id | BIGINT UNSIGNED | never blank | The portfolio this class belongs to: the same portfolio_id the reference, liquidity and holdings files carry, so the fee stack joins the portfolio-grain files directly. Every class of a portfolio carries the same value. | 20834 |
prospectus_date | DATE | never blank (key) | The date of the prospectus that states this row's fee table. One class has one row per prospectus, so the rows are the class's expense-ratio history. | 2026-06-26 |
is_current | TINYINT(1) | never blank | 1 on the class's newest prospectus on or before analysis_date, 0 on every older one. Filter on it to read one fee table per class. | 1 |
share_class_type | VARCHAR(16) | may be blank | Share class designation read from the class name, one of the share_class_type values in the appendix. Blank where the name states none, or one outside that list. | Retirement |
fee_source | VARCHAR(32) | never blank | Where this row's fee facts come from, as <domain>:<source>: sec:rr_xbrl for a Risk/Return prospectus fee table, else the web/EMT/KID source stating the class's fees. Peer columns ride sec:rr_xbrl rows only. | sec:rr_xbrl |
gross_er_pct | DECIMAL(9,4) | may be blank | Total annual fund operating expenses before any waiver or reimbursement, as a percent of assets (0.95 means 0.95%). | 0.8100 |
net_er_pct | DECIMAL(9,4) | may be blank | Total annual fund operating expenses after waivers and reimbursements, percent of assets. Equals gross_er_pct where the prospectus states no waiver, and never exceeds it. | 0.8100 |
mgmt_fee_pct | DECIMAL(9,4) | may be blank | The management fee, percent of assets. | 0.5200 |
fee_12b1_pct | DECIMAL(9,4) | may be blank | Distribution and service (12b-1) fees, percent of assets. | 0.0000 |
other_expenses_pct | DECIMAL(9,4) | may be blank | Other expenses, percent of assets. Stated by SEC prospectus fee tables only: blank on a web/EMT/KID-sourced row. | 0.2900 |
acquired_fund_fees_pct | DECIMAL(9,4) | may be blank | Acquired fund fees and expenses (the cost of underlying funds held), percent of assets. Stated by SEC prospectus fee tables only: blank on a web/EMT/KID-sourced row. | 0.0100 |
fee_waiver_pct | DECIMAL(9,4) | may be blank | Fee waiver or expense reimbursement, percent of assets; a waiver is negative, never positive, and gross_er_pct + fee_waiver_pct = net_er_pct. A waiver filed as a positive magnitude is restated to this sign. | -0.0600 |
max_front_load_pct | DECIMAL(9,4) | may be blank | Maximum sales charge on purchases, percent of the offering price. | 0.0000 |
max_deferred_load_pct | DECIMAL(9,4) | may be blank | Maximum deferred sales charge, percent of the offering price (or of the other base the filer states). | 0.0000 |
redemption_fee_pct | DECIMAL(9,4) | may be blank | Redemption fee, percent of the amount redeemed; carried negative on every row, as SEC filers report it. | 0.0000 |
exchange_fee_pct | DECIMAL(9,4) | may be blank | Exchange fee, percent of the amount exchanged. Stated by SEC prospectus fee tables only: blank on a web/EMT/KID-sourced row. | 0.0000 |
turnover_pct | DECIMAL(9,4) | may be blank | Portfolio turnover rate for the most recent fiscal year, percent. A portfolio-level figure, so every class of a portfolio carries the same value. Blank where the filing states a rate above 10,000%, a tagging error. | 27.0000 |
expense_example_1y | DECIMAL(12,2) | may be blank | Dollars an investor pays over 1 year on the SEC's $10,000 illustration. Always on the $10,000 base and non-decreasing across the four horizons; a cell filed on another base or out of order is restated or blank. | 83.00 |
expense_example_3y | DECIMAL(12,2) | may be blank | Dollars over 3 years on the $10,000 illustration. Always on the $10,000 base and non-decreasing across the four horizons; a cell filed on another base or out of order is restated or blank. | 259.00 |
expense_example_5y | DECIMAL(12,2) | may be blank | Dollars over 5 years on the $10,000 illustration. Always on the $10,000 base and non-decreasing across the four horizons; a cell filed on another base or out of order is restated or blank. | 450.00 |
expense_example_10y | DECIMAL(12,2) | may be blank | Dollars over 10 years on the $10,000 illustration. Always on the $10,000 base and non-decreasing across the four horizons; a cell filed on another base or out of order is restated or blank. | 1002.00 |
net_er_pct_rank | TINYINT UNSIGNED | may be blank | Percentile rank of net_er_pct within the class's category cohort, 1 cheapest to 100 most expensive. Present on the current sec:rr_xbrl row only. | 91 |
net_er_quintile | TINYINT | may be blank | Fee level of net_er_pct within its cohort, 1 (cheapest fifth) to 5 (most expensive fifth). Derived from net_er_pct_rank. | 5 |
net_er_peer_median | DECIMAL(18,6) | may be blank | The cohort's median net expense ratio, percent. | 0.650000 |
net_er_peer_count | SMALLINT UNSIGNED | may be blank | Distinct portfolios in the cohort net_er_pct was ranked against. | 481 |
gross_er_pct_rank | TINYINT UNSIGNED | may be blank | Percentile rank of gross_er_pct within the cohort, 1 cheapest to 100 most expensive. Present on the current sec:rr_xbrl row only. | 84 |
gross_er_quintile | TINYINT | may be blank | Fee level of gross_er_pct within its cohort, 1 to 5. | 5 |
gross_er_peer_median | DECIMAL(18,6) | may be blank | The cohort's median gross expense ratio, percent. | 0.766750 |
gross_er_peer_count | SMALLINT UNSIGNED | may be blank | Distinct portfolios in the cohort gross_er_pct was ranked against. | 480 |
turnover_pct_rank | TINYINT UNSIGNED | may be blank | Percentile rank of turnover_pct within the cohort, 1 lowest turnover to 100 highest. Present on the current sec:rr_xbrl row only. | 27 |
turnover_quintile | TINYINT | may be blank | Turnover level within its cohort, 1 (lowest fifth) to 5 (highest fifth). | 2 |
turnover_peer_median | DECIMAL(18,6) | may be blank | The cohort's median portfolio turnover, percent. | 48.000000 |
turnover_peer_count | SMALLINT UNSIGNED | may be blank | Distinct portfolios in the cohort turnover_pct was ranked against. | 398 |
peer_category | VARCHAR(24) | may be blank | The SQX category the peer statistics were computed within. Blank where the class has no peer rank. | FI-US |
peer_rank_asof | DATE | may be blank | The date of the peer cross-section the peer columns come from. Blank where the class is in no peer cohort. A cohort too small to rank still publishes its size here with the rank blank. | 2026-08-27 |