SSRS report needed that includes ACFR Fund Type as shown in Chart Manager
Description of Issue
Which table holds ACFR fund type?
Context
Chart of Account Segments
Chart Manager
SSRS reporting
Cause
Resolution
The glfundat table can be used to report on funds by their ACFR fund type. Please see additional notes below for which fund type links to each number.
Additional Information
List below correlates the number from glfu_cafr_fund_type to the field in Chart Manager or Chart of Account Segments
0- Field was left blank
1- General fund
2- Special revenue funds
3- Debt service funds
4- Permanent funds
5- Capital project funds
6- Enterprise funds
7- Internal service funds
8- Custodial funds
9- Investment trust funds
10- Pension trust funds
11- Private-purpose trust fundsÂ
12- Governmental component unit
13- Business-Type component unit
14- Non-reportingÂ