Downloads
The CACOA is published under the MIT License: use it, change it, and share it. The files are static and free; no sign-up is needed.
Release 2027.03 Proposed
Draft for review. New codes and crosswalk rules are marked proposed. Changelog
Complete tables (Excel)
Every table: funds, objects, functions, departments, reference tables, validation rules, the FTR spine, the crosswalk, and the data dictionary.
CACOA-2027.03.xlsx · 805 KB
sha256 c703469efda0312bda49f3077647bcef4b24a44b47cb3be8b2bd0d4cd4e55169
Quick reference (Excel)
One sheet each for funds, functions, departments, and objects, with plain descriptions and FTR placement. Start here.
CACOA-2027.03-quick-reference.xlsx · 79 KB
sha256 cc16e096dc3fee86a25ced41b5b4f27e7650b3d10bfefab6cc6a8766fc20c801
FTR crosswalk (Excel)
Every FTR line and the codes that feed it, every rule, LGRS field IDs, the coverage report, and mapping rules ready for reporting software.
CACOA-2027.03-FTR-crosswalk.xlsx · 588 KB
sha256 c4e3e8dbde6976b54069f47d2afeb0e3a50dc190b5dc249ac6f501a8064af9aa
All tables as CSV, valid combination lists, and Navigator mapping rules
All tables as CSV, the Navigator mapping rules, the changelog, the coverage report, and the license.
CACOA-2027.03-csv.zip · 513 KB
sha256 8edaed2faa20ffe1b4a07f0bcb3cea399cb9581f675dfa9e9e490dc8dfe3b7e2
Valid code combinations (Excel)
CACOA-2027.03-valid-combinations.xlsx · 56 KB
sha256 5f49c080c3b646bf1308ac4f518b046fbb40efdbd3f87ab1e253384a2d458d33
Crosswalks to the other State Controller reports (Excel)
CACOA-2027.03-state-reports-crosswalk.xlsx · 219 KB
sha256 46222000d5de19ea90840092d9118623c2d2c3f81b7251ae1caf39f5f1c06c8b
Release 2026.10
Previous release, kept for reference.
All tables as CSV
All tables as CSV, the Navigator mapping rules, the changelog, the coverage report, and the license.
CACOA-2026.10-csv.zip · 226 KB
sha256 32e1f2a716c2d7460550bd3f14e23cc232cd6d18ee84797abc5873bcbdd60caf
FTR crosswalk (Excel)
Every FTR line and the codes that feed it, every rule, LGRS field IDs, the coverage report, and mapping rules ready for reporting software.
CACOA-2026.10-FTR-crosswalk.xlsx · 465 KB
sha256 d18bcf9b327a24f6c794c36bd32091610914d8c3cc571522cbacbcdaf0ed9a5a
Quick reference (Excel)
One sheet each for funds, functions, departments, and objects, with plain descriptions and FTR placement. Start here.
CACOA-2026.10-quick-reference.xlsx · 53 KB
sha256 f3304861e83417ee23f8e7a8058c62701e4ce3dfcabe9544f0cb20989a534987
Valid code combinations (Excel)
CACOA-2026.10-valid-combinations.xlsx · 40 KB
sha256 1b79ceb38172251fddb1b50c7ddd28b669289e0586f053a14a492fe9416a5423
Complete tables (Excel)
Every table: funds, objects, functions, departments, reference tables, validation rules, the FTR spine, the crosswalk, and the data dictionary.
CACOA-2026.10.xlsx · 430 KB
sha256 b9e1ed5ba14a1db245fdb87ec34162c1e11b6e7d51129955e3492802f2618880
Release 2026.03
Previous release, kept for reference.
Complete tables (Excel)
Every table: funds, objects, functions, departments, reference tables, validation rules, the FTR spine, the crosswalk, and the data dictionary.
CACOA_Base_Tables_v1.xlsx · 376 KB
sha256 0650f68f419f938836522114fe5c8beb0df0513c9fc46078100c849d13b72491
Quick reference (Excel)
One sheet each for funds, functions, departments, and objects, with plain descriptions and FTR placement. Start here.
CACOA_Base_Tables_v1_Quick.xlsx · 78 KB
sha256 150922d872b8b0cfa5a3234d72ecb1029f5231327e37f0bac740f17fa3269684
SQL Server schema (reference)
Reference SQL Server schema from release 2026.03.
CACOA_FTR_Schema_v1_COMPLETE_SQL2019.sql · 41 KB
sha256 e20b70aa76e47d04b27d7e3e1b4d0804ecb4a27c286a33920c9ae7d440ca8841