User-Defined Codes - Fund Accounting

Use the Fund Accounting user-defined codes to set up crosswalks between organizations or accounts in the Fund Accounting system and the state-defined codes, which must be reported to the Michigan Education Information System (MEIS) Financial Information Database (FID). Any organization chart level or account code not on the state School Code Master or the Michigan School Accounting Manual Chart of Accounts must be defined in a user-defined table if used by the district.

Set Up Crosswalks

1. On the start page, choose Fund Accounting.

2. Select Reference Tables, then choose User Defined Codes.

3. Click Add new.

4. Refer to Field Descriptions and enter valid information.

5. Click Accept.

6. Repeat these steps to create records for the remaining organization or account codes to be crosswalked to the state codes.

   

   For the Fund code crosswalk, you must set up any fund code not reportable to MEIS with 99 in the Title. Funds with a corresponding crosswalk value of 99 are bypassed while loading data.

Field Descriptions

Column Name	Data Type	Length	Description
Table Code	Character	2	The table code is used in the Setup Layout option of MI MEIS Financial Information. You can use any two-character code that is meaningful to you, except EF.
Code	Character	10	Enter the organization or account code that is being crosswalked to the state code. You must drop leading alphabetic characters or zeros from account codes.
Title	Character	25	Enter the state code from the Michigan School Code Master or the Michigan School Accounting Manual that corresponds to the district's code.

Populate EF (Educator Effectiveness)

Use Fund Accounting user-defined codes with the table code EF (Educator Effectiveness) in Michigan MEIS Registry of Educational Personnel (REP) reporting when loading substitutes set up as vendors.

Enter Educator Effectiveness codes in the Effectiveness field (vnduser.tcode7, page_no = “500”) on the Vendor Defined Page 500 – MEIS REP.

You must populate the EF table with the Educator Effectiveness codes.

1. On the start page, choose Fund Accounting.

2. Select Reference Tables, then choose User Defined Codes.

3. Click New.

4. Specify the Table Code as EF.

5. In the Code field, enter a code from the Educator Effectiveness Codes (for example, 01).

6. In the Title field, enter the corresponding title from the Educator Effectiveness Codes (for example, Highly Effective).

7. Click Accept.

8. Repeat these steps to create records for the remaining codes listed under Educator Effectiveness Codes.

Educator Effectiveness Codes