From a 40-row sample across 11 columns.
plan| year | plan | revenues_1 | salaries | communication_expenses | advisory_and_auditing_fees | rent_reimbursement_to_the | administrative_support | recordkeeping_loan_fees_2 | custodian_fees | total_expenses |
|---|---|---|---|---|---|---|---|---|---|---|
| 2014 | 457 | 13306 | 873 | 1675 | 513 | 540 | 2556 | 5827 | 907 | 12891 |
| 2014 | 401(k) | 1613 |
The machine field names SoQL needs, with the publisher's own description of each.
| Field | Type | Description | Null | Values |
|---|---|---|---|---|
year | categorical | Plan Year - January-December | 0% | 202120222019of 10 |
plan | categorical | The Deferred Compensation Plan is an umbrella program for three defined contribution plans, the 457 Plan, 401(k) Plan, and 401(a) Plan, and a deemed IRA called the New York City Employee (NYCE) IRA | 0% | NYCE IRA401(k)457of 4 |
revenues_1 | integer | DCP receives revenue through a combination of participants’ quarterly administrative fees, amounts deducted from the net asset values, interest earned on assets held in the DCP’s custodial account and loan fees. | 0% | 475 |
salaries | integer | Salaries of City employees working for in the DCP administrative office, attributable to each Plan |
GET /api/datasets/w65z-zif5 GET /api/datasets/w65z-zif5/quality GET /api/datasets/w65z-zif5/related GET /api/columns?dataset=w65z-zif5
year| 125 |
| 238 |
| 76 |
| 77 |
| 345 |
| 659 |
| 104 |
| 1624 |
| 2014 | NYCE IRA | 123 | 14 | 27 | 9 | 9 | 23 | 48 | 12 | 142 |
| 2014 | 401(a) | 3 | — | — | — | — | — | 3 | — | 3 |
| 2015 | 457 | 13713 | 1029 | 1636 | 695 | 599 | 2666 | 5749 | 945 | 13319 |
| 2015 | 401(k) | 1728 | 156 | 248 | 104 | 76 | 332 | 691 | 112 | 1719 |
| 2015 | NYCE IRA | 137 | 18 | 28 | 12 | 10 | 31 | 50 | 13 | 162 |
| 2015 | 401(a) | 4 | — | — | — | — | — | 2 | — | 2 |
| 2016 | 457 | 14071 | 924 | 1902 | 631 | 586 | 2777 | 5601 | 969 | 13390 |
| 2016 | 401(k) | 1893 | 150 | 264 | 88 | 85 | 393 | 1008 | 129 | 2117 |
| 25% |
1815620 |
communication_expenses | integer | Expenses for communication and educational services provided to DCP participants, attributable to each Plan | 25% | 4922211902 |
advisory_and_auditing_fees | integer | Expenses for consulting and auditing services | 25% | 913137 |
rent_reimbursement_to_the | integer | The administration of the City of New York Deferred Compensation Plan is entirely self-funded. DCP reimburses the City for services/expenses incurred by OLR for the benefit of DCP, attributable to each Plan | 25% | 1213586 |
administrative_support | integer | Maintenance expenses, such as IT and administrative office expenses, attributable to each Plan | 25% | 552666773 |
recordkeeping_loan_fees_2 | integer | Expenses for third party recordkeeping services including participant account maintenance and issuance of quarterly statements, attributable to each Plan | 0% | 73691 |
custodian_fees | integer | Expenses to custody DCP assets and calculate daily net asset value for DCP investment options, attributable to each Plan | 25% | 2327212 |
total_expenses | integer | Total of all DCP annual expenses, attributable to each Plan | 0% | 7310 |