---
reportDefinition: !<org.ssdt_ohio.reporting.AdhocReportDefinition>
  description: "ExpenditureAccount Report"
  tags: "Public Shared"
  predefined: false
  parameters: !<org.ssdt_ohio.reporting.AdhocReportParameters>
    pageSize: "LETTER"
    pageOrientation: "LANDSCAPE"
    outputFormat: "PDF"
    templateName: "Budget Summary Report"
    suppressDetail: false
    showOptions: false
    sortProperties: !<java.util.ArrayList> []
    queryParameters: !<java.util.LinkedHashMap> {}
  title: "Budget Summary Report"
  querySpecification:
    specification: "fullAccountCode.oneOf ([param(\"fullAccountCode\",'',\"Include\
      \ Full Account Code (i.e. 001-1110-511-0000-000000-001-00-000)\")])\ncode.fund.oneOf\
      \ ([param(\"includecode.fund\",'',\"Include Funds (001,006)\")])\ncode.func.like\
      \ param(\"includecode.func\",\"\",\"Include Function (use % for wildcard)\"\
      )\ncode.object.like param(\"includecode.object\",\"\",\"Include Object (use\
      \ % for wildcard)\")\ncode.scc.like param(\"includecode.scc\",\"\",\"Include\
      \ SCC (use % for wildcard)\")\ncode.subject.like param(\"includecode.subject\"\
      ,\"\",\"Include Subject (use % for wildcard)\")\ncode.opu.like param(\"includecode.opu\"\
      ,\"\",\"Include OPU (use % for wildcard)\")\ncode.il.like param(\"includecode.il\"\
      ,\"\",\"Include IL (use % for wildcard)\")\ncode.job.like param(\"includecode.job\"\
      ,\"\",\"Include Job (use % for wildcard)\")\nfilter.eq param(\"Filter Name\"\
      ,\"\")\nallAmountsZero.oneOf ([param(\"allAmountsZero\",'',\"Include Accounts\
      \ with all Zeros? (true/false)\")])"
    querySpecParameters: !<java.util.ArrayList> []
  entity: "org.ssdt_ohio.usas.model.account.ExpenditureAccount"
  properties: !<java.util.ArrayList>
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: "cashAccount"
    entityName: "Account"
    sortOrder: 1
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: "METHOD"
    label: null
    columnTitle: "Cash Acct"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 36
    relativePropertyName: "cashAccount.fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 1
    suppressRepeating: true
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Full Account Code"
    type: "java.lang.String"
    propertyName: "fullAccountCode"
    propertyPath: null
    entityName: "Account"
    sortOrder: 4
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: null
    label: null
    columnTitle: "Budget"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: true
    width: 0
    relativePropertyName: "fullAccountCode"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 2
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Description"
    type: "java.lang.String"
    propertyName: "description"
    propertyPath: null
    entityName: "Account"
    sortOrder: 4
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: true
    format: null
    source: null
    label: null
    columnTitle: "Description"
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: true
    width: 24
    relativePropertyName: "description"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 3
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Appropriated"
    type: "java.math.BigDecimal"
    propertyName: "FYTDAppropriated"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.FYTDAppropriated"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 4
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Prior Year Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "priorYearEncumbrance"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.priorYearEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 5
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Expendable"
    type: "java.math.BigDecimal"
    propertyName: "FYTDExpendable"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.FYTDExpendable"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 6
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Expended"
    type: "java.math.BigDecimal"
    propertyName: "FYTDExpended"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.FYTDExpended"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 7
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "MTD Expended"
    type: "java.math.BigDecimal"
    propertyName: "MTDExpended"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.MTDExpended"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 8
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "currentEncumbrance"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.currentEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 9
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Future Encumbrance"
    type: "java.math.BigDecimal"
    propertyName: "futureEncumbrance"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.futureEncumbrance"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 10
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "FYTD Unencumbered"
    type: "java.math.BigDecimal"
    propertyName: "FYTDUnencumbered"
    propertyPath: "budget"
    entityName: "Budget"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: "Sum"
    baseClassProperty: false
    format: "CURRENCY"
    source: "METHOD"
    label: null
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "budget.FYTDUnencumbered"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 11
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Percent Expended/Encumbered"
    type: "java.math.BigDecimal"
    propertyName: "percentExpendedEncumbered"
    propertyPath: null
    entityName: "ExpenditureAccount"
    sortOrder: 0
    controlBreak: false
    suppressed: false
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: "PERCENT"
    source: "METHOD"
    label: "Percent Expended/Encumbered"
    columnTitle: null
    alignment: null
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "percentExpendedEncumbered"
    dataSourcePath:
      path: !<java.util.ArrayList> []
      currentPath: !<java.util.ArrayList> []
    columnOrder: 12
    suppressRepeating: false
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Function Two Digit Level"
    type: "java.lang.String"
    propertyName: "functionTwoDigitLevel"
    propertyPath: "code"
    entityName: "ExpenditureCode"
    sortOrder: 2
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Func 2 Digit "
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.functionTwoDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 13
    suppressRepeating: true
    permission: null
  - !<org.ssdt_ohio.reporting.ReportablePropertyImpl>
    description: "Object One Digit Level"
    type: "java.lang.String"
    propertyName: "objectOneDigitLevel"
    propertyPath: "code"
    entityName: "ExpenditureCode"
    sortOrder: 3
    controlBreak: true
    suppressed: true
    pageBreak: false
    ascending: true
    function: null
    baseClassProperty: false
    format: null
    source: "FIELD"
    label: ""
    columnTitle: "Obj 1 Digit "
    alignment: "LEFT"
    controlHeaderOnly: false
    controlFooterOnly: false
    detailHeaderOnly: false
    width: 0
    relativePropertyName: "code.objectOneDigitLevel"
    dataSourcePath:
      path: !<java.util.Collections$UnmodifiableRandomAccessList> []
      currentPath: !<java.util.Collections$UnmodifiableRandomAccessList>
      - "code"
    columnOrder: 14
    suppressRepeating: true
    permission: null