N-27D-1/N-27D-1/A
| Field Name | Data Definition | Data Type | Original/Engineered |
|---|---|---|---|
| reporting_period | Placeholder for the period range (e.g., "For the period from 01/01/2023 to 03/31/2023"). | Text (String) | Original |
| depositor_or_principal_underwriter_name | Name of the depositor or principal underwriter maintaining the segregated trust account. | Text (String) | Original |
| irs_employer_identification_no | IRS Employer Identification Number (EIN) of the depositor/principal underwriter. | Text (String) | Original |
| depositor_address | Address of the depositor or principal underwriter. | Text (String) | Original |
| registered_investment_company_name | Name of the registered investment company for which the account is maintained. | Text (String) | Original |
| irs_company_identification_no | IRS Employer Identification Number (EIN) of the registered investment company. | Text (String) | Original |
| period_start_date | Start date of the reporting period (e.g., "01/01/2023"). | Date | Original |
| period_end_date | End date of the reporting period (e.g., "03/31/2023"). | Date | Original |
| beginning_balance | Balance in the segregated trust account at the start of the reporting period. | Numeric (Float) | Original |
| deposits_paragraph_c | Deposits made under Rule 27d-1(c) (e.g., plan payments). | Numeric (Float) | Original |
| deposits_paragraph_e | Deposits made under Rule 27d-1(e) (e.g., additional reserves). | Numeric (Float) | Original |
| interest_income | Interest earned (received or accrued) during the period. | Numeric (Float) | Original |
| gains_or_losses_on_sales | Net gains/(losses) from sales of securities in the account. | Numeric (Float) | Original |
| unrealized_appreciation_depreciation | Unrealized appreciation/(depreciation) of investments held. | Numeric (Float) | Original |
| total_deposits_and_income | Sum of all deposits, interest, gains, and unrealized changes. | Numeric (Float) | Original |
| withdrawals_paragraph_f1 | Withdrawals for refunds under Rule 27d-1(f)(1) (e.g., plan cancellations). | Numeric (Float) | Original |
| withdrawals_paragraph_f2 | Withdrawals for refunds under Rule 27d-1(f)(2) (e.g., excess reserves). | Numeric (Float) | Original |
| withdrawals_paragraph_f3 | Other permitted withdrawals under Rule 27d-1(f)(3). | Numeric (Float) | Original |
| total_withdrawals | Sum of all withdrawals during the period. | Numeric (Float) | Original |
| ending_balance | Balance in the segregated trust account at the end of the period. | Numeric (Float) | Original |
| minimum_required_paragraph_d | Minimum amount required under Rule 27d-1(d) (e.g., base reserve). | Numeric (Float) | Original |
| minimum_required_paragraph_e | Minimum amount required under Rule 27d-1(e) (e.g., additional reserve). | Numeric (Float) | Original |
| total_minimum_required | Sum of all minimum required amounts under Rule 27d-1. | Numeric (Float) | Original |
| minimum_before_f3_withdrawals | Minimum balance required before paragraph (f)(3) withdrawals are permitted. | Numeric (Float) | Original |
| signature_city_state | City and state where the form is signed. | Text (String) | Original |
| signature_date | Date the form is signed. | Date | Original |
| signatory_name_title | Name and title of the person signing the form (e.g., CFO). | Text (String) | Original |
| Field Name | Description | Data Type | Original/Engineered |
|---|---|---|---|
| reporting_period | Placeholder for the period range (e.g., "For the period from 01/01/2023 to 03/31/2023"). | Text (String) | Original |
| depositor_or_principal_underwriter_name | Name of the depositor or principal underwriter maintaining the segregated trust account. | Text (String) | Original |
| irs_employer_identification_no | IRS Employer Identification Number (EIN) of the depositor/principal underwriter. | Text (String) | Original |
| depositor_address | Address of the depositor or principal underwriter. | Text (String) | Original |
| registered_investment_company_name | Name of the registered investment company for which the account is maintained. | Text (String) | Original |
| irs_company_identification_no | IRS Employer Identification Number (EIN) of the registered investment company. | Text (String) | Original |
| period_start_date | Start date of the reporting period (e.g., "01/01/2023"). | Date | Original |
| period_end_date | End date of the reporting period (e.g., "03/31/2023"). | Date | Original |
| beginning_balance | Balance in the segregated trust account at the start of the reporting period. | Numeric (Float) | Original |
| deposits_paragraph_c | Deposits made under Rule 27d-1(c) (e.g., plan payments). | Numeric (Float) | Original |
| deposits_paragraph_e | Deposits made under Rule 27d-1(e) (e.g., additional reserves). | Numeric (Float) | Original |
| interest_income | Interest earned (received or accrued) during the period. | Numeric (Float) | Original |
| gains_or_losses_on_sales | Net gains/(losses) from sales of securities in the account. | Numeric (Float) | Original |
| unrealized_appreciation_depreciation | Unrealized appreciation/(depreciation) of investments held. | Numeric (Float) | Original |
| total_deposits_and_income | Sum of all deposits, interest, gains, and unrealized changes. | Numeric (Float) | Original |
| withdrawals_paragraph_f1 | Withdrawals for refunds under Rule 27d-1(f)(1) (e.g., plan cancellations). | Numeric (Float) | Original |
| withdrawals_paragraph_f2 | Withdrawals for refunds under Rule 27d-1(f)(2) (e.g., excess reserves). | Numeric (Float) | Original |
| withdrawals_paragraph_f3 | Other permitted withdrawals under Rule 27d-1(f)(3). | Numeric (Float) | Original |
| total_withdrawals | Sum of all withdrawals during the period. | Numeric (Float) | Original |
| ending_balance | Balance in the segregated trust account at the end of the period. | Numeric (Float) | Original |
| minimum_required_paragraph_d | Minimum amount required under Rule 27d-1(d) (e.g., base reserve). | Numeric (Float) | Original |
| minimum_required_paragraph_e | Minimum amount required under Rule 27d-1(e) (e.g., additional reserve). | Numeric (Float) | Original |
| total_minimum_required | Sum of all minimum required amounts under Rule 27d-1. | Numeric (Float) | Original |
| minimum_before_f3_withdrawals | Minimum balance required before paragraph (f)(3) withdrawals are permitted. | Numeric (Float) | Original |
| signature_city_state | City and state where the form is signed. | Text (String) | Original |
| signature_date | Date the form is signed. | Date | Original |
| signatory_name_title | Name and title of the person signing the form (e.g., CFO). | Text (String) | Original |