Type TaxExemptOrganization
Type category Entity
Description The TEO table contains data for MMD Tax Exempt Organization.
Timeseries key id, assetValuationDateavailable from 2007-06-30
Fields
Name Type Filters Description
key id string(500)* = The id field uniquely identifies the entity record.
timeline assetValuationDate date* =< >= Asset Valuation Date as per most recently reported data. This date will always reflect the last day of the month for reporting period.
active boolean Indicates if TEO is active.
link batch Batch = The batch that provided the data
link batchRun BatchRun = The batchRun that provided the data
link company Company MMD Company id, foreign key that links to the Company entity.
currencyCode string(3) Local currency conversion code.
investmentPoolFundAssets long Assets of the sub-fund in USD.
investmentPoolFundAssetsLoc long Same as investmentPoolFundAssets. Figures shown in local currency.
investmentPoolFundName string(280) Name of the sub-fund related to the investment pool.
investmentPoolFundSeqNo long Sequence of the sub-fund.
irsCategoryCode string(2) IRS Category Code.
irsCategoryDescription string(1000) IRS Category description.
irsCategorySubcode string(2) IRS Category Subcode.
planSeqNo long Plan Sequence Number - There are often several pension plan records associated.
totalAssets long Total Assets in USD.
totalAssetsLoc long Same as totalAssets. Figures shown in local currency.
totalInvestmentPool long Total Investment Pool in USD.
totalInvestmentPoolLoc long Same as totalInvestmentPool. Figures shown in local currency.
totalLiabilities long Total Liabilities in USD.
totalLiabilitiesLoc long Same as totalLiabilities. Figures shown in local currency
updateDate dateTime TEO record last updated on.
22 rows of 22 total
API Open API Specification