fund dimension
(OLT_DIM_FUND) No description available.
general ledger star schemas
operating ledger star schemas
monthly snapshots
actual transactions
budget transactions
commitment transactions
individual column descriptions (OLT_DIM_FUND)
| Column Name | Column Description |
|---|---|
| Fund Key | Primary key uniquely identifying each row in the fund dimension. |
| Fund Chart of Accounts | A code representing the individual chart of accounts for a particular reporting entity within Rensselaer (i.e. 9 = Troy Chart of Accounts; H = Hartford Chart of Accounts). |
| Fund Chart of Accounts Description | The description corresponding to the chart of accounts for a particular reporting entity within Rensselaer (e.g. Rensselaer at Hartford, Rensselaer at Troy). |
| Fund Classification | The 1st level of Institute fund groups used for management-level reporting and analysis (e.g. Designated Funds, Endowment, Annuity Life Income Funds, Loan Funds, Plant Funds, Restricted Funds, Unrestricted Funds, etc.). |
| Fund Category | The 2nd level of Institute fund groups used for management-level reporting and analysis (e.g. Federal Loan Funds, Unexpended Plant Funds, Sponsored Research, Auxiliary Funds, etc.). |
| Fund Subcategory | The 3rd level of Institute fund groups used for management-level reporting and analysis (e.g. Rensselaer Union, etc.). |
| Fund Type Level 1 | The 1st level of Banner fund type codes, summarizing funds for departmental reporting and analysis. |
| Fund Type Level 1 Description | The description corresponding to the 1st level fund type code, summarizing funds for departmental reporting and analysis. |
| Fund Type Level 2 | The 2nd level of Banner fund type codes, summarizing funds for departmental reporting and analysis. |
| Fund Type Level 2 Description | The description corresponding to the 2nd level fund type code, summarizing funds for departmental reporting and analysis. |
| Fund Level 1 | The 1st level of summarized Banner fund codes used for departmental budget activity, reporting and analysis. |
| Fund Level 1 Description | The description corresponding to the 1st level fund code. |
| Fund Level 1 Financial Manager | The financial manager responsible for the given 1st level fund code. |
| Fund Level 2 | The 2nd level of summarized Banner fund codes used for departmental budget activity, reporting and analysis. |
| Fund Level 2 Description | The description corresponding to the 2nd level fund code. |
| Fund Level 2 Financial Manager | The financial manager responsible for the given 2nd level fund code. |
| Fund Level 3 | The 3rd level of summarized Banner fund codes used for departmental budget activity, reporting and analysis. |
| Fund Level 3 Description | The description corresponding to the 3rd level fund code. |
| Fund Level 3 Financial Manager | The financial manager responsible for the given 3rd level fund code. |
| Fund | The 4th level of summarized Banner fund codes used for departmental budget activity, reporting and analysis. |
| Fund Description | The description corresponding to the 4th level fund code. |
| Fund Financial Manager | The financial manager responsible for the given 4th level fund code. |
| Fund Status | The current status (e.g. Active, Inactive, Termed, etc.) of the fund at the lowest level of the fund hierarchy (Fund Code Level 4). |
| Fund Termination Date | If applicable, the termination date of the fund at the lowest level of the fund hierarchy (Fund Code Level 4). |
| Capital Project Indicator | Indicator that identifies all capital and non-capital project plant funds (i.e. Capital Project, Non Capital Project). |
| Plant Project Indicator | Indicator that identifies all plant funds (i.e. Plant Fund). |
| Fund Restriction Indicator | Indicator that identifies funds in Banner FAS117 categories (i.e. P=Permanently Restricted; T=Temporarily Restricted; U=Unrestricted). |
| Current Fund Indicator | Indicator that identifies current funds (i.e. Current Fund; Non Current Fund; Unknown). |
| Grant Code | The grant code to which a fund is assigned. |
| Indirect Cost Basis Code | The code corresponding to the indirect cost calculation. |
| Indirect Cost Basis Description | The description corresponding to the Indirect Cost Basis Code, a code identifying the indirect cost calculation. |
| Indirect Cost Rate | The rate used in the indirect cost calculation. |
| Sponsored Funds and Fin Aid Indicator | Indicator that identifies sponsored funds (i.e. None; Other Sponsored Programs; Sponsored Financial Aid; Sponsored Research). |
| EOY Sponsored Funds and Fin Aid Indicator | Indicator that identifies sponsored funds (i.e. None; Other Sponsored Programs; Sponsored Financial Aid; Sponsored Research), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Chart of Accounts | A code representing the individual chart of accounts for a particular reporting entity within Rensselaer (i.e. 9 = Troy Chart of Accounts; H = Hartford Chart of Accounts). |
| EOY Fund Chart of Accounts Description | The description corresponding to the chart of accounts for a particular reporting entity within Rensselaer (e.g. Rensselaer at Hartford, Rensselaer at Troy). |
| EOY Fund Classification | The 1st level of Institute fund groups used for management-level reporting and analysis (e.g. Designated Funds, Endowment, Annuity Life Income Funds, Loan Funds, Plant Funds, Restricted Funds, Unrestricted Funds, etc.), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Category | The 2nd level of Institute fund groups used for management-level reporting and analysis (e.g. Federal Loan Funds, Unexpended Plant Funds, Sponsored Research, Auxiliary Funds, etc.), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Subcategory | The 3rd level of Institute fund groups used for management-level reporting and analysis (e.g. Rensselaer Union, etc.), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Type Level 1 | The 1st level of Banner fund type codes, summarizing funds for departmental reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Type Level 1 Description | The description corresponding to the 1st level fund type code, summarizing funds for departmental reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Type Level 2 | The 2nd level of Banner fund type codes, summarizing funds for departmental reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Type Level 2 Description | The description corresponding to the 2nd level fund type code, summarizing funds for departmental reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 1 | The 1st level of summarized Banner fund codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 1 Description | The description corresponding to the 1st level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 1 Financial Manager | The financial manager responsible for the given 1st level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 2 | The 2nd level of summarized Banner fund codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 2 Description | The description corresponding to the 2nd level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 2 Financial Manager | The financial manager responsible for the given 2nd level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 3 | The 3rd level of summarized Banner fund codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 3 Description | The description corresponding to the 3rd level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Level 3 Financial Manager | The financial manager responsible for the given 3rd level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund | The 4th level of summarized Banner fund codes used for departmental budget activity, reporting and analysis, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Description | The description corresponding to the 4th level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Financial Manager | The financial manager responsible for the given 4th level fund code, for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Status | The current status (e.g. Active, Inactive, Termed, etc.) of the fund at the lowest level of the fund hierarchy (Fund Code Level 4), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Begin Date | The date on which the given fund hierarchy was effective. |
| EOY Fund End Date | The date on which the given fund hierarchy was no longer effective. |
| EOY Fund Termination Date | If applicable, the termination date of the fund at the lowest level of the fund hierarchy (Fund Code Level 4), for each fiscal year in which the fund hierarchy changes. |
| EOY Capital Project Indicator | Indicator that identifies all capital and non-capital project plant funds (i.e. Capital Project, Non Capital Project), for each fiscal year in which the fund hierarchy changes. |
| EOY Fund Restriction Indicator | Indicator that identifies funds in Banner FAS117 categories (i.e. P=Permanently Restricted; T=Temporarily Restricted; U=Unrestricted), for each fiscal year in which the fund hierarchy changes. |
| EOY Current Fund Indicator | Indicator that identifies current funds (i.e. Current Fund; Non Current Fund; Unknown), for each fiscal year in which the fund hierarchy changes. |
| EOY Grant Code | The grant code to which a fund is assigned, for each fiscal year in which the fund hierarchy changes. |
| EOY Indirect Cost Basis Code | The code corresponding to the indirect cost calculation, for each fiscal year in which the fund hierarchy changes. |
| EOY Indirect Cost Basis Description | The description corresponding to the Indirect Cost Basis Code, a code identifying the indirect cost calculation, for each fiscal year in which the fund hierarchy changes. |
| EOY Indirect Cost Rate | The rate used in the indirect cost calculation, for each fiscal year in which the fund hierarchy changes. |
| EOY Plant Project Indicator | Indicator that identifies all plant funds (i.e. Plant Fund), for each fiscal year in which the fund hierarchy changes. |
| Fund - Home Portfolio | The 1st level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Portfolio Description | The description corresponding to the portfolio code (e.g. Administration, School of Engineering, Human Resources, etc.). The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Portfolio Financial Manager | The name of the financial manager responsible for the portfolio. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Department | The 2nd level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Department Description | The description corresponding to the department code (e.g. Campus Facilities and Facilities Design, Chemical Engineering, General Benefits Administration, etc.). The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Department Financial Manager | The name of the financial manager responsible for the department. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Unit | The 3rd level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Unit Description | The description corresponding to the unit code. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Unit Financial Manager | The name of the financial manager responsible for the unit. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Section | The 4th level in the organizational hierarchy of academic or administrative entities within the Institute. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Section Description | The description corresponding to the section code. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Section Financial Manager | The name of the financial manager responsible for the section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization | The 5th level in the organizational hierarchy of academic or administrative entities within the Institute, representing an area of financial responsibility within an organizational section. The organizational hierarchy consists of 5 levels: Portfolio, Department, Unit, Section, and Sub-Section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Description | The description corresponding to the sub-section code. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Financial Manager | The name of the financial manager responsible for the sub-section. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Status | The current status (e.g. Active, Inactive, Terminated, Retired, etc.) of the organization at the lowest (data-entry) level of the hierarchy. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Termination Date | The termination date of the organization at the lowest (data-entry) level of the hierarchy. The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Type | The type of entity that the organization corresponds to (e.g. Academic School, Administrative, Center, etc.). The Home Org defines the organization to which the given fund formally belongs. |
| Fund - Home Organization Effective Date | The effective date of a change to an organization identifier (i.e. predecessor code, description, financial manager, status, etc.) at the lowest (data-entry) level in the hierarchy. The Home Org defines the organization to which the given fund formally belongs. |
