--- reportDefinition: ! description: "Appropriation Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Appropriation Summary" suppressDetail: true showOptions: false queryParameters: ! {} title: "Appropriation Summary" querySpecification: specification: "fullAccountCode.oneOf ([param(\"includefullAccountCode\",'',\"\ Include Full Account Code (i.e. 001-1100-500-0000)\")])\ncode.fund.like param(\"\ includeFund\",\"\",\"Include Fund (use % for wildcard)\")\ncode.func.like param(\"\ includeFunc\",\"\",\"Include Func (use % for wildcard)\")\ncode.object.like\ \ param(\"includeObj\",\"\",\"Include Obj (use % for wildcard)\")\ncode.scc.like\ \ param(\"includeSCC\",\"\",\"Include SCC (use % for wildcard)\")\nactive.oneOf\ \ ([param(\"active\",'',\"Active only? (true/false)\")])\nfilter.eq param(\"\ Filter Name\",\"\")\nasOfPeriod.eq param(\"asOfPeriod\",\"\",\"Report for a\ \ specific posting period (blank means current period).\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.budget.Appropriation" properties: ! - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: null entityName: "BudgetBase" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false - ! 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: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 2 suppressRepeating: false - ! description: "FYTD Appropriated" type: "java.math.BigDecimal" propertyName: "FYTDAppropriated" propertyPath: null entityName: "Appropriation" 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: 22 relativePropertyName: "FYTDAppropriated" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false - ! description: "Prior Year Encumbrance" type: "java.math.BigDecimal" propertyName: "priorYearEncumbrance" propertyPath: null entityName: "Appropriation" 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: 22 relativePropertyName: "priorYearEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false - ! description: "FYTD Expendable" type: "java.math.BigDecimal" propertyName: "FYTDExpendable" propertyPath: null entityName: "Appropriation" 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: 22 relativePropertyName: "FYTDExpendable" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false - ! description: "FYTD Expended" type: "java.math.BigDecimal" propertyName: "FYTDExpended" propertyPath: null entityName: "Appropriation" 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: 20 relativePropertyName: "FYTDExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false - ! description: "MTD Expended" type: "java.math.BigDecimal" propertyName: "MTDExpended" propertyPath: null entityName: "Appropriation" 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: 20 relativePropertyName: "MTDExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false - ! description: "Encumbrance" type: "java.math.BigDecimal" propertyName: "currentEncumbrance" propertyPath: null entityName: "Appropriation" 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: 20 relativePropertyName: "currentEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false - ! description: "Future Encumbrance" type: "java.math.BigDecimal" propertyName: "futureEncumbrance" propertyPath: null entityName: "Appropriation" 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: 20 relativePropertyName: "futureEncumbrance" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false - ! description: "FYTD Unencumbered" type: "java.math.BigDecimal" propertyName: "FYTDUnencumbered" propertyPath: null entityName: "Appropriation" 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: 20 relativePropertyName: "FYTDUnencumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false - ! description: "Percent Expended/Encumbered" type: "java.math.BigDecimal" propertyName: "percentExpendedEncumbered" propertyPath: null entityName: "Appropriation" 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: ! [] currentPath: ! [] columnOrder: 11 suppressRepeating: false - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "code" entityName: "AccountCode" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.fund" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 12 suppressRepeating: false - ! description: "Scc" type: "java.lang.String" propertyName: "scc" propertyPath: "code" entityName: "AccountCode" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: null label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.scc" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 13 suppressRepeating: false