Flexible General Ledger Account Amounts Monthly
cityoffargond-test.data.socrata.com | Last Updated 8 Oct 2024Secured View for Flexible General Ledger Account Amounts Monthly
This dataset has the following 229 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| AccountId | account_id | number | 10051 14174 10454 8657 11167 view top 100 |
| FiscalYearId | fiscal_year_id | number | 17 18 19 20 21 view top 100 |
| FiscalYear | fiscal_year | text | FY2018 FY2019 FY2020 FY2021 FY2022 view top 100 |
| CalendarYear | calendar_year | number | 2018 2019 2020 2021 2022 view top 100 |
| CalendarMonth | calendar_month | number | 1 2 3 4 5 view top 100 |
| FiscalMonthSequence | fiscal_month_sequence | number | 1 2 3 4 5 view top 100 |
| HierarchyName | hierarchy_name | text | Databank Reporting Hierarchy view top 100 |
| FullAccount | full_account | text | 332-DS10DN-299200 701-000000-201200 545-5451OP-74-7400-000-78-434800 301-DS19AN-213500 535-5354TX-299200 view top 100 |
| Description | description | text | Budgetary Fund Balance - Unreserved Budget Control - Estimated Revenues Reserve for Encumbrances Retainage Payable - AP Encumbrances view top 100 |
| AccountSubTypeCode | account_sub_type_code | text | E B R BFB CRTN view top 100 |
| EffectiveStartDate | effective_start_date | calendar_date | view top 100 |
| EffectiveEndDate | effective_end_date | calendar_date | view top 100 |
| GrantId | grant_id | number | view top 100 |
| ReferenceAccountId | reference_account_id | number | 5444 5447 5455 5458 5466 view top 100 |
| StatusCode | status_code | text | A D view top 100 |
| StatusName | status_name | text | Active Deleted view top 100 |
| StatusDescription | status_description | text | Active Deleted view top 100 |
| BalanceTypeCode | balance_type_code | text | U L A view top 100 |
| BalanceTypeName | balance_type_name | text | Fund Balance Liability Asset view top 100 |
| BalanceTypeDescription | balance_type_description | text | Fund Balance Liability Balance Type Asset Balance Type view top 100 |
| BalanceTypeCategoryCode | balance_type_category_code | text | U L A view top 100 |
| BalanceTypeCategoryName | balance_type_category_name | text | Fund Balance Liability Asset view top 100 |
| BalanceTypeCategoryDescription | balance_type_category_description | text | Fund Balance Liability Balance Type Asset Balance Type view top 100 |
| OriginalBudget | original_budget | number | 0.00 view top 100 |
| Changes | changes | number | 0.00 500.00 100000.00 150000.00 472.00 view top 100 |
| RevisedBudget | revised_budget | number | 0.00 5000.00 500.00 100000.00 150000.00 view top 100 |
| AvailableBudget | available_budget | number | 0.00 -2000.00 5000.00 -5000.00 -1000.00 view top 100 |
| ExpendPriorYear | expend_prior_year | number | 0.00 view top 100 |
| EncumbrancePriorYear | encumbrance_prior_year | number | 0.00 view top 100 |
| UnpostedActuals | unposted_actuals | number | 0.00 2000.00 5000.00 -5000.00 -500.00 view top 100 |
| PostedActuals | posted_actuals | number | 0.00 100000.00 -100000.00 25000.00 -75.00 view top 100 |
| UnpostedEncumbrance | unposted_encumbrance | number | 0.00 view top 100 |
| PostedEncumbrance | posted_encumbrance | number | 0.00 view top 100 |
| PreEncumbrance | pre_encumbrance | number | 0.00 500.00 view top 100 |
| UnpostedActualsFullAccrual | unposted_actuals_full_accrual | number | 0.00 2000.00 5000.00 -5000.00 -500.00 view top 100 |
| PostedActualsFullAccrual | posted_actuals_full_accrual | number | 0.00 100000.00 -100000.00 25000.00 -50.00 view top 100 |
| UnpostedPreEncumbranceFullAccrual | unposted_pre_encumbrance_full_accrual | number | 0.00 500.00 view top 100 |
| UnpostedEncumbranceFullAccrual | unposted_encumbrance_full_accrual | number | 0.00 view top 100 |
| PostedEncumbranceFullAccrual | posted_encumbrance_full_accrual | number | 0.00 view top 100 |
| OriginalBudgetFullAccrual | original_budget_full_accrual | number | 0.00 view top 100 |
| TransfersInFullAccrual | transfers_in_full_accrual | number | 0.00 500.00 100000.00 150000.00 472.00 view top 100 |
| TransfersOutFullAccrual | transfers_out_full_accrual | number | 0.00 -500.00 -472.00 -250.00 view top 100 |
| RevisedBudgetFullAccrual | revised_budget_full_accrual | number | 0.00 5000.00 500.00 100000.00 150000.00 view top 100 |
| UnpostedActualsCash | unposted_actuals_cash | number | 0.00 2000.00 -5000.00 5000.00 1000.00 view top 100 |
| PostedActualsCash | posted_actuals_cash | number | 0.00 100000.00 -100000.00 25000.00 -150000.00 view top 100 |
| UnpostedPreEncumbranceCash | unposted_pre_encumbrance_cash | number | 0.00 500.00 view top 100 |
| UnpostedEncumbranceCash | unposted_encumbrance_cash | number | 0.00 view top 100 |
| PostedEncumbranceCash | posted_encumbrance_cash | number | 0.00 view top 100 |
| OriginalBudgetCash | original_budget_cash | number | 0.00 view top 100 |
| TransfersInCash | transfers_in_cash | number | 0.00 500.00 100000.00 150000.00 472.00 view top 100 |
| TransfersOutCash | transfers_out_cash | number | 0.00 -500.00 -472.00 -250.00 view top 100 |
| RevisedBudgetCash | revised_budget_cash | number | 0.00 5000.00 500.00 100000.00 150000.00 view top 100 |
| IsDeleted | is_deleted | text | 0 view top 100 |
| LastModified | last_modified | calendar_date | 2024-10-07T17:17:12.572 view top 100 |
| Dimension1_Code | dimension1_code | text | 400 600 700 300 110 view top 100 |
| Dimension1_Name | dimension1_name | text | Revenue Types view top 100 |
| Dimension1_Description | dimension1_description | text | Revenue Types view top 100 |
| Dimension1 | dimension1 | text | 400-Revenue Types 600-Revenue Types 700-Revenue Types 300-Revenue Types 110-Revenue Types view top 100 |
| Dimension2_Code | dimension2_code | text | 2OP 1HU 4OT 3CA view top 100 |
| Dimension2_Name | dimension2_name | text | Expense Type view top 100 |
| Dimension2_Description | dimension2_description | text | Expense Type view top 100 |
| Dimension2 | dimension2 | text | 2OP-Expense Type 1HU-Expense Type 4OT-Expense Type 3CA-Expense Type view top 100 |
| Dimension3_Code | dimension3_code | text | 101 100 401 201 212 view top 100 |
| Dimension3_Name | dimension3_name | text | Budget Rollup Group view top 100 |
| Dimension3_Description | dimension3_description | text | Budget Rollup Group view top 100 |
| Dimension3 | dimension3 | text | 101-Budget Rollup Group 100-Budget Rollup Group 401-Budget Rollup Group 201-Budget Rollup Group 212-Budget Rollup Group view top 100 |
| Dimension4_Code | dimension4_code | text | view top 100 |
| Dimension4_Name | dimension4_name | text | view top 100 |
| Dimension4_Description | dimension4_description | text | view top 100 |
| Dimension4 | dimension4 | text | view top 100 |
| Dimension5_Code | dimension5_code | text | view top 100 |
| Dimension5_Name | dimension5_name | text | view top 100 |
| Dimension5_Description | dimension5_description | text | view top 100 |
| Dimension5 | dimension5 | text | view top 100 |
| Dimension6_Code | dimension6_code | text | view top 100 |
| Dimension6_Name | dimension6_name | text | view top 100 |
| Dimension6_Description | dimension6_description | text | view top 100 |
| Dimension6 | dimension6 | text | view top 100 |
| Dimension7_Code | dimension7_code | text | view top 100 |
| Dimension7_Name | dimension7_name | text | view top 100 |
| Dimension7_Description | dimension7_description | text | view top 100 |
| Dimension7 | dimension7 | text | view top 100 |
| Dimension8_Code | dimension8_code | text | view top 100 |
| Dimension8_Name | dimension8_name | text | view top 100 |
| Dimension8_Description | dimension8_description | text | view top 100 |
| Object - FID - MI FID | dimension8 | text | view top 100 |
| Dimension9_Code | dimension9_code | text | view top 100 |
| Dimension9_Name | dimension9_name | text | view top 100 |
| Dimension9_Description | dimension9_description | text | view top 100 |
| Object_2028 | dimension9 | text | view top 100 |
| Dimension10_Code | dimension10_code | text | view top 100 |
| Dimension10_Name | dimension10_name | text | view top 100 |
| Dimension10_Description | dimension10_description | text | view top 100 |
| Dimension10 | dimension10 | text | view top 100 |
| Dimension11_Code | dimension11_code | text | view top 100 |
| Dimension11_Name | dimension11_name | text | view top 100 |
| Dimension11_Description | dimension11_description | text | view top 100 |
| Dimension11 | dimension11 | text | view top 100 |
| Dimension12_Code | dimension12_code | text | view top 100 |
| Dimension12_Name | dimension12_name | text | view top 100 |
| Dimension12_Description | dimension12_description | text | view top 100 |
| Dimension12 | dimension12 | text | view top 100 |
| Dimension13_Code | dimension13_code | text | view top 100 |
| Dimension13_Name | dimension13_name | text | view top 100 |
| Dimension13_Description | dimension13_description | text | view top 100 |
| Dimension13 | dimension13 | text | view top 100 |
| Dimension14_Code | dimension14_code | text | view top 100 |
| Dimension14_Name | dimension14_name | text | view top 100 |
| Dimension14_Description | dimension14_description | text | view top 100 |
| Dimension14 | dimension14 | text | view top 100 |
| Dimension15_Code | dimension15_code | text | view top 100 |
| Dimension15_Name | dimension15_name | text | view top 100 |
| Dimension15_Description | dimension15_description | text | view top 100 |
| Dimension15 | dimension15 | text | view top 100 |
| Dimension16_Code | dimension16_code | text | view top 100 |
| Dimension16_Name | dimension16_name | text | view top 100 |
| Dimension16_Description | dimension16_description | text | view top 100 |
| Dimension16 | dimension16 | text | view top 100 |
| Dimension17_Code | dimension17_code | text | view top 100 |
| Dimension17_Name | dimension17_name | text | view top 100 |
| Dimension17_Description | dimension17_description | text | view top 100 |
| Dimension17 | dimension17 | text | view top 100 |
| Dimension18_Code | dimension18_code | text | view top 100 |
| Dimension18_Name | dimension18_name | text | view top 100 |
| Dimension18_Description | dimension18_description | text | view top 100 |
| Dimension18 | dimension18 | text | view top 100 |
| Dimension19_Code | dimension19_code | text | view top 100 |
| Dimension19_Name | dimension19_name | text | view top 100 |
| Dimension19_Description | dimension19_description | text | view top 100 |
| Dimension19 | dimension19 | text | view top 100 |
| Dimension20_Code | dimension20_code | text | view top 100 |
| Dimension20_Name | dimension20_name | text | view top 100 |
| Dimension20_Description | dimension20_description | text | view top 100 |
| Dimension20 | dimension20 | text | view top 100 |
| PostedTransfersOut | postedtransfersout | number | 0.00 -500.00 -472.00 -250.00 view top 100 |
| UnpostedTransfersIn | unpostedtransfersin | number | 0.00 view top 100 |
| UnpostedTransfersOut | unpostedtransfersout | number | 0.00 view top 100 |
| UnpostedTransfersInFullAccrual | unpostedtransfersinfullaccrual | number | 0.00 view top 100 |
| UnpostedTransfersOutFullAccrual | unpostedtransfersoutfullaccrual | number | 0.00 view top 100 |
| UnpostedTransfersInCash | unpostedtransfersincash | number | 0.00 view top 100 |
| UnpostedTransfersOutCash | unpostedtransfersoutcash | number | 0.00 view top 100 |
| Segment1_Code | segment1_code | text | 101 301 515 500 505 view top 100 |
| Segment1_Name | segment1_name | text | Fund view top 100 |
| Segment1_Description | segment1_description | text | General Fund Refunding Improvement Bonds Solid Waste Utility Water Utility Water Reclamation Utility view top 100 |
| Segment2_Code | segment2_code | text | 000000 5151OP 5001OP 5051OP 5451OP view top 100 |
| Segment2_Name | segment2_name | text | Sub-fund view top 100 |
| Segment2_Description | segment2_description | text | Undefined Sub-fund Solid Waste Utility Operating Water Utility Operating Water Reclamation Utility Operating Transit Operating view top 100 |
| Segment3_Code | segment3_code | text | 50 24 85 40 72 view top 100 |
| Segment3_Name | segment3_name | text | Department view top 100 |
| Segment3_Description | segment3_description | text | Fargo Cass Public Health Planning & Development Debt Service Public Works Solid Waste view top 100 |
| Segment4_Code | segment4_code | text | 8500 2430 5001 5002 5004 view top 100 |
| Segment4_Name | segment4_name | text | Division view top 100 |
| Segment4_Description | segment4_description | text | Debt Service Parking Authority Harm Reduction Nursing Clinic view top 100 |
| Segment5_Code | segment5_code | text | 000 542 521 510 520 view top 100 |
| Segment5_Name | segment5_name | text | Program view top 100 |
| Segment5_Description | segment5_description | text | Undefined Program Clinic Services Chronic Disease / Aging Care Gladys Ray Shelter Communicable Disease view top 100 |
| Segment6_Code | segment6_code | text | 25 10 55 15 40 view top 100 |
| Segment6_Name | segment6_name | text | Function view top 100 |
| Segment6_Description | segment6_description | text | Public Health & Welfare General Government Debt Service Public Safety Public Transportation view top 100 |
| Segment7_Code | segment7_code | text | 202001 299303 299302 299301 299300 view top 100 |
| Segment7_Name | segment7_name | text | Object view top 100 |
| Segment7_Description | segment7_description | text | Budget Control - Estimated Revenues Payroll Liabilities Expenditure Summary Control Accounts Payable Reserve for Encumbrances view top 100 |
| Segment8_Code | segment8_code | text | view top 100 |
| Segment8_Name | segment8_name | text | view top 100 |
| Segment8_Description | segment8_description | text | view top 100 |
| Segment9_Code | segment9_code | text | view top 100 |
| Segment9_Name | segment9_name | text | view top 100 |
| Segment9_Description | segment9_description | text | view top 100 |
| Segment10_Code | segment10_code | text | view top 100 |
| Segment10_Name | segment10_name | text | view top 100 |
| Segment10_Description | segment10_description | text | view top 100 |
| Segment11_Code | segment11_code | text | view top 100 |
| Segment11_Name | segment11_name | text | view top 100 |
| Segment11_Description | segment11_description | text | view top 100 |
| Segment12_Code | segment12_code | text | view top 100 |
| Segment12_Name | segment12_name | text | view top 100 |
| Segment12_Description | segment12_description | text | view top 100 |
| Segment13_Code | segment13_code | text | view top 100 |
| Segment13_Name | segment13_name | text | view top 100 |
| Segment13_Description | segment13_description | text | view top 100 |
| Segment14_Code | segment14_code | text | view top 100 |
| Segment14_Name | segment14_name | text | view top 100 |
| Segment14_Description | segment14_description | text | view top 100 |
| Segment15_Code | segment15_code | text | view top 100 |
| Segment15_Name | segment15_name | text | view top 100 |
| Segment15_Description | segment15_description | text | view top 100 |
| Segment16_Code | segment16_code | text | view top 100 |
| Segment16_Name | segment16_name | text | view top 100 |
| Segment16_Description | segment16_description | text | view top 100 |
| Segment17_Code | segment17_code | text | view top 100 |
| Segment17_Name | segment17_name | text | view top 100 |
| Segment17_Description | segment17_description | text | view top 100 |
| Segment18_Code | segment18_code | text | view top 100 |
| Segment18_Name | segment18_name | text | view top 100 |
| Segment18_Description | segment18_description | text | view top 100 |
| Segment19_Code | segment19_code | text | view top 100 |
| Segment19_Name | segment19_name | text | view top 100 |
| Segment19_Description | segment19_description | text | view top 100 |
| Segment20_Code | segment20_code | text | view top 100 |
| Segment20_Name | segment20_name | text | view top 100 |
| Segment20_Description | segment20_description | text | view top 100 |
| Fund | segment1 | text | 101-General Fund 301-Refunding Improvement Bonds 515-Solid Waste Utility 500-Water Utility 505-Water Reclamation Utility view top 100 |
| Sub Fund | segment2 | text | 000000-Undefined Sub-fund 5151OP-Solid Waste Utility Operating 5001OP-Water Utility Operating 5051OP-Water Reclamation Utility Operating 5451OP-Transit Operating view top 100 |
| Function | segment3 | text | 50-Fargo Cass Public Health 24-Planning & Development 85-Debt Service 40-Public Works 72-Solid Waste view top 100 |
| Agency | segment4 | text | 8500-Debt Service 2430-Parking Authority 5001-Harm Reduction 5002-Nursing 5004-Clinic view top 100 |
| Service | segment5 | text | 000-Undefined Program 542-Clinic Services 521-Chronic Disease / Aging Care 510-Gladys Ray Shelter 520-Communicable Disease view top 100 |
| Sub Service | segment6 | text | 25-Public Health & Welfare 10-General Government 55-Debt Service 15-Public Safety 40-Public Transportation view top 100 |
| Location | segment7 | text | 202001-Retainage Payable - AP 299303-Budgetary Fund Balance - Reserved for Encumbrances 299302-Budgetary Fund Balance - Unreserved 299301-Budget Control - Appropriations 299300-Budget Control - Estimated Revenues view top 100 |
| segment8 | segment8 | text | view top 100 |
| segment9 | segment9 | text | view top 100 |
| segment10 | segment10 | text | view top 100 |
| segment11 | segment11 | text | view top 100 |
| segment12 | segment12 | text | view top 100 |
| segment13 | segment13 | text | view top 100 |
| segment14 | segment14 | text | view top 100 |
| segment15 | segment15 | text | view top 100 |
| segment16 | segment16 | text | view top 100 |
| segment17 | segment17 | text | view top 100 |
| segment18 | segment18 | text | view top 100 |
| segment19 | segment19 | text | view top 100 |
| segment20 | segment20 | text | view top 100 |
| StartingBalanceFullAccrual | startingbalancefullaccrual | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| EndingBalanceFullAccrual | endingbalancefullaccrual | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| StartingBalanceCash | startingbalancecash | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| EndingBalanceCash | endingbalancecash | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| StartingBalanceModified | startingbalancemodified | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| EndingBalanceModified | endingbalancemodified | number | 0.00 25000.00 100000.00 -25000.00 -100000.00 view top 100 |
| RowIdentifier | rowidentifier | text | 13591|22|2023|4 6615|18|2019|5 15579|18|2019|5 14901|19|2020|11 6988|22|2023|5 view top 100 |
| PostedTransfersIn | postedtransfersin | number | 0.00 500.00 100000.00 150000.00 472.00 view top 100 |