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Â