(Gold Copy) This is the consolidated dataset that will be shared with the Hub. It contains all proposal lines marked as Included, along with all active Reference datasets. Both this dataset and the HUB equivalent contain Report Header columns needed for Tabular Reporting.
This dataset has the following 93 columns:
| Column Name | API Column Name | Data Type | Description | Sample Values |
|---|---|---|---|---|
| Budget Plan | budgetplanname | text | Budget Plan Name | Operating Budget FY2025-FY2026 view top 100 |
| Period | period | text | Budget Plan Period | FY2025 FY2026 view top 100 |
| Data Group | datagroup | text | Groups include the Plan and any active reference data | Operating Budget FY2025-FY2026 2024 Actuals 2024 Adopted Budget 2023 Adopted Budget view top 100 |
| Proposal Name | proposalname | text | Name of the Proposal | Public Utilities Tax Collector Parks Public Health Social Services view top 100 |
| Proposal Owner | proposalowner | text | Owner of the Proposal | Serena Messner Kim Arndtson Scott Dement Katya Craven Kevin Stout view top 100 |
| Stage Name | stagename | text | Budget Plan stage | Historical data Department Submission Baseline Finance Review Council/Board Review view top 100 |
| Stage Due Date | stageduedate | calendar_date | The data the stage is due for completion | view top 100 |
| Stage Order | stageseqorder | number | The numeric order of the Stage | 0 1 2 3 4 view top 100 |
| Reference Data | isreferencedata | checkbox | True if the line is related to Reference data. | true false view top 100 |
| Line Justification | proposallinejustification | text | Justification of the line budget amount | Increase in printing and mailing costs Mailers and postage for elections Additional costs related to erp upgrade GFOA - Updates on best practices and new reporting requirements Connect - Training for team in areas including Budget & Planning and Year end process/practices view top 100 |
| Account | lineaccount | text | The full GL Budget accout | 101-150-100-52500- 710-310-400-52500- 310-310-400-41110-CP0001 550-150-100-41110- 720-310-400-56100- view top 100 |
| Account Description | accountdescription | text | The text description of the Budget account | General supplies Regular full time Federal Payroll Taxes Workers' compensation Technical view top 100 |
| Account Type | accounttype | text | Type of Account (Expenditure, Revenue or Balance Sheet) | Expenditure Revenue Balance sheet view top 100 |
| Expenditure Amount | expenditureamount | number | The amount for Account type Expenditure | 42.62 900.78 927.8 51772.61 53325.79 view top 100 |
| Revenue Amount | revenueamount | number | The amount for Account type Revenue | 1961566.16 178728.73 303579.81 228283.37 201172.38 view top 100 |
| Balance Sheet Amount | balancesheetamount | number | The amount for Account type Balance Sheet | 2989.19 3766.38 4184.87 5791.29 5825.82 view top 100 |
| Most Current Proposal | iscurrentproposal | checkbox | True if the Proposal is the most correct of versions related to other stages. | true false view top 100 |
| Proposal Link | documentlink | url | A Hyperlink to the related Proposal | view top 100 |
| Activity Header | activityheader | text | Report Header combining Segment value and Name | view top 100 |
| Activity | activityname | text | Activity Name | view top 100 |
| Activity Value | activitysegment | text | Segment Value | view top 100 |
| Agency Header | agencyheader | text | Report Header combining Segment value and Name | view top 100 |
| Agency | agencyname | text | Agency Name | view top 100 |
| Agency Value | agencysegment | text | Segment Value | view top 100 |
| Category Header | categoryheader | text | Report Header combining Segment value and Name | view top 100 |
| Category | categoryname | text | Category Name | view top 100 |
| Category Value | categorysegment | text | Segment Value | view top 100 |
| Cost Center Header | costcenterheader | text | Report Header combining Segment value and Name | view top 100 |
| Cost Center | costcentername | text | Cost Center Name | view top 100 |
| Cost Center Value | costcentersegment | text | Segment Value | view top 100 |
| Department Header | departmentheader | text | Report Header combining Segment value and Name | 310 - Public Utilities 150 - Tax Collector 510 - Parks 450 - Public Health 120 - Controller view top 100 |
| Department | departmentname | text | Department Name | Public Utilities Tax Collector Parks Public Health Controller view top 100 |
| Department Value | departmentsegment | text | Segment Value | 310 150 510 450 120 view top 100 |
| Division Header | divisionheader | text | Report Header combining Segment value and Name | view top 100 |
| Division | divisionname | text | Division Name | view top 100 |
| Division Value | divisionsegment | text | Segment Value | view top 100 |
| Entity Header | entityheader | text | Report Header combining Segment value and Name | view top 100 |
| Entity | entityname | text | Entity Name | view top 100 |
| Entity Value | entitysegment | text | Segment Value | view top 100 |
| Function Header | functionheader | text | Report Header combining Segment value and Name | view top 100 |
| Function | functionname | text | Function Name | view top 100 |
| Function Value | functionsegment | text | Segment Value | view top 100 |
| Fund Header | fundheader | text | Report Header combining Segment value and Name | 101 - General Fund 710 - Water Fund 720 - Sewer Fund 550 - Evergreen Hills Golf Course Fund 310 - Capital Improvements Fund view top 100 |
| Fund | fundname | text | Fund Name | General Fund Water Fund Sewer Fund Evergreen Hills Golf Course Fund Capital Improvements Fund view top 100 |
| Fund Value | fundsegment | text | Segment Value | 101 710 720 550 310 view top 100 |
| Funding Source Header | fundingsourceheader | text | Report Header combining Segment value and Name | view top 100 |
| Funding Source | fundingsourcename | text | Funding Source Name | view top 100 |
| Funding Source Value | fundingsourcesegment | text | Segment Value | view top 100 |
| Funding Type Header | fundingtypeheader | text | Report Header combining Segment value and Name | view top 100 |
| Funding Type | fundingtypename | text | Funding Type Name | view top 100 |
| Funding Type Value | fundingtypesegment | text | Segment Value | view top 100 |
| Grade Header | gradeheader | text | Report Header combining Segment value and Name | view top 100 |
| Grade | gradename | text | Grade Name | view top 100 |
| Grade Value | gradesegment | text | Segment Value | view top 100 |
| Grant Header | grantheader | text | Report Header combining Segment value and Name | view top 100 |
| Grant | grantname | text | Grant Name | view top 100 |
| Grant Value | grantsegment | text | Segment Value | view top 100 |
| Location Header | locationheader | text | Report Header combining Segment value and Name | view top 100 |
| Location | locationname | text | Location Name | view top 100 |
| Location Value | locationsegment | text | Segment Value | view top 100 |
| Object Header | objectheader | text | Report Header combining Segment value and Name | 51100 - Regular full time 52200 - Federal Payroll Taxes 53400 - Technical 52300 - Retirement contributions 52600 - Workers' compensation view top 100 |
| Object Value | objectsegment | text | Segment Value | 51100 52200 52600 52100 52300 view top 100 |
| Object | objectname | text | Object Name | Regular full time Federal Payroll Taxes Group insurance Workers' compensation Retirement contributions view top 100 |
| Organization Header | organizationheader | text | Report Header combining Segment value and Name | view top 100 |
| Organization | organizationname | text | Organization Name | view top 100 |
| Organization Value | organizationsegment | text | Segment Value | view top 100 |
| Phase Header | phaseheader | text | Report Header combining Segment value and Name | view top 100 |
| Phase | phasename | text | Phase Name | view top 100 |
| Phase Value | phasesegment | text | Segment Value | view top 100 |
| Program Header | programheader | text | Report Header combining Segment value and Name | 100 - Admin & Finance 400 - Public Works 200 - Health & Human Svcs 500 - Recreation 300 - Public Protection view top 100 |
| Program | programname | text | Program Name | Admin & Finance Public Works Health & Human Svcs Recreation Public Protection view top 100 |
| Program Value | programsegment | text | Segment Value | 100 400 200 500 300 view top 100 |
| Project Header | projectheader | text | Report Header combining Segment value and Name | GR0002 - COVID Vaccine Distribution Grant OP0002 - GASB87 Implementation CP0002 - 3rd Street Repaving CP0001 - Maintenance Facility Improvements GR0001 - Police K9 Training Grant view top 100 |
| Project | projectname | text | Project Name | COVID Vaccine Distribution Grant GASB87 Implementation 3rd Street Repaving Maintenance Facility Improvements Police K9 Training Grant view top 100 |
| Project Value | projectsegment | text | Segment Value | GR0002 OP0002 CP0002 CP0001 GR0001 view top 100 |
| Unit Header | unitheader | text | Report Header combining Segment value and Name | view top 100 |
| Unit | unitname | text | Unit Name | view top 100 |
| Unit Value | unitsegment | text | Segment Value | view top 100 |
| User Segment1 Header | usersegment1header | text | Report Header combining Segment value and Name | view top 100 |
| User Segment1 | usersegment1name | text | User Segment1 Name | view top 100 |
| User Segment1 Value | usersegment1segment | text | Segment Value | view top 100 |
| User Segment2 Header | usersegment2header | text | Report Header combining Segment value and Name | view top 100 |
| User Segment2 | usersegment2name | text | User Segment2 Name | view top 100 |
| User Segment2 Value | usersegment2segment | text | Segment Value | view top 100 |
| User Segment3 Header | usersegment3header | text | Report Header combining Segment value and Name | view top 100 |
| Use segment3 | usersegment3name | text | Use segment3 Name | view top 100 |
| User Segment3 Value | usersegment3segment | text | Segment Value | view top 100 |
| User Segment4 Header | usersegment4header | text | Report Header combining Segment value and Name | view top 100 |
| User Segment4 | usersegment4name | text | User Segment4 Name | view top 100 |
| User Segment4 Value | usersegment4segment | text | Segment Value | view top 100 |
| User Segment5 Header | usersegment5header | text | Report Header combining Segment value and Name | view top 100 |
| User Segment5 | usersegment5name | text | User Segment5 Name | view top 100 |
| User Segment5 Value | usersegment5segment | text | Segment Value | view top 100 |