---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "Budget Report"
  tags: null
  predefined: false
  parameters: !<org.ssdt_ohio.model.ReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "XLSX"
    templateName: "Budgets Worksheet"
    suppressDetail: false
    showOptions: false
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Budgets Worksheet"
  querySpecification:
    specification: "fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Include\
      \ Full Account Code (i.e. 001-1110-511-0000-000000-001-00-000)\")])\ncode.fund.like\
      \ param(\"code.fund\",\"\",\"Include Fund (use % for wildcard)\")\ncode.func.like\
      \ param(\"code.func\",\"\",\"Include Func (use % for wildcard)\")\ncode.object.like\
      \ param(\"code.object\",\"\",\"Include Object (use % for wildcard)\")\ncode.scc.like\
      \ param(\"code.scc\",\"\",\"Include SCC (use % for wildcard)\")\ncode.subject.like\
      \ param(\"code.subject\",\"\",\"Include Subject (use % for wildcard)\")\ncode.opu.like\
      \ param(\"code.opu\",\"\",\"Include OPU (use % for wildcard)\")\ncode.il.like\
      \ param(\"code.il\",\"\",\"Include IL (use % for wildcard)\")\ncode.job.like\
      \ param(\"code.job\",\"\",\"Include Job (use % for wildcard)\")\nfilter.eq param(\"\
      Filter Name\",\"\")"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.budget.Budget"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fund"
    type: "java.lang.String"
    propertyName: "fund"
    propertyPath: "code"
    entityName: "AccountCode"
    sortOrder: 2
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Fund"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.fund"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 1
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Func"
    type: "java.lang.String"
    propertyName: "func"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 3
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Func"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.func"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 2
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object"
    type: "java.lang.String"
    propertyName: "object"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 4
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Object"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.object"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 3
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "SCC"
    type: "java.lang.String"
    propertyName: "scc"
    propertyPath: "code"
    entityName: "AccountCode"
    sortOrder: 2
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: "SCC"
    columnTitle: "SCC"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.scc"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 4
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Subject"
    type: "java.lang.String"
    propertyName: "subject"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 5
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Subject"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.subject"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 5
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "OPU"
    type: "java.lang.String"
    propertyName: "opu"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 6
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: "OPU"
    columnTitle: "OPU"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.opu"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 6
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "IL"
    type: "java.lang.String"
    propertyName: "il"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 7
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: "IL"
    columnTitle: "IL"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.il"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 7
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Job"
    type: "java.lang.String"
    propertyName: "job"
    propertyPath: "code"
    entityName: "BudgetCode"
    sortOrder: 8
    controlBreak: false
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Job"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.job"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 8
    suppressRepeating: true
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: null
    entityName: "BudgetBase"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Description"
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 25
    relativePropertyName: "description"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList> []
    columnOrder: 9
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Appropriated"
    type: "java.math.BigDecimal"
    propertyName: "FYTDAppropriated"
    propertyPath: null
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "FYTD Appropriated"
    columnTitle: "FYTD Appropriated"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDAppropriated"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 10
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Prior Year Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "priorYearEncumbrance"
    propertyPath: null
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: "Prior Year Encumbrance"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "priorYearEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 11
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Expendable"
    type: "java.math.BigDecimal"
    propertyName: "FYTDExpendable"
    propertyPath: null
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "FYTD Expendable"
    columnTitle: "FYTD Expendable"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDExpendable"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 12
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Expended"
    type: "java.math.BigDecimal"
    propertyName: "FYTDExpended"
    propertyPath: null
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: "FYTD Expended"
    columnTitle: "FYTD Expended"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "FYTDExpended"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 13
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Next Year Proposed"
    type: "java.math.BigDecimal"
    propertyName: "nextYearProposed"
    propertyPath: null
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: ""
    columnTitle: "PA-"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "nextYearProposed"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 14
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Fiscal Year"
    type: "java.lang.Integer"
    propertyName: "fiscalYear"
    propertyPath: "priorYearActualExpended"
    entityName: "PriorYearAmount"
    sortOrder: 1
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: false
    function: null
    baseClassProperty: false
    format: "NONE"
    source: "FIELD"
    label: null
    columnTitle: "Fiscal Year"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "fiscalYear"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "priorYearActualExpended"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList> []
    columnOrder: 15
    suppressRepeating: false
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Amount"
    type: "java.math.BigDecimal"
    propertyName: "amount"
    propertyPath: "priorYearActualExpended"
    entityName: "PriorYearAmount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "CURRENCY"
    source: "FIELD"
    label: null
    columnTitle: "Amount"
    alignment: "RIGHT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "amount"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "priorYearActualExpended"
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList> []
    columnOrder: 16
    suppressRepeating: false