--- reportDefinition: ! description: "Budget Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Budget Expense Worksheet" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "code.opu" label: "OPU" ascending: true controlBreak: true pageBreak: true - propertyName: "code.fund" label: "Fund" ascending: true controlBreak: true pageBreak: true - propertyName: "cashAccount.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "appropriation.fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "fullAccountCode" label: "Full Account Code" ascending: true controlBreak: false pageBreak: false - propertyName: "code.object" label: "Object" ascending: true controlBreak: false pageBreak: false - propertyName: "code.func" label: "Func" ascending: true controlBreak: false pageBreak: false - propertyName: "description" label: "Description" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Budget Expense 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\",\"\")\nactive.eq 'True'\nasOfPeriod.eq param(\"asOfPeriod\",\"\ \",\"Total As of Period (If a date is specified FYTD and Encumbrance amounts\ \ will be calculated as of that period)\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usas.model.budget.Budget" properties: ! - ! 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: "FIELD" label: "" columnTitle: "FUND-SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "cashAccount.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "cashAccount" columnOrder: 1 suppressRepeating: true permission: null - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: "appropriation" entityName: "BudgetBase" sortOrder: 2 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Appropriation" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 36 relativePropertyName: "appropriation.fullAccountCode" dataSourcePath: path: ! [] currentPath: ! - "appropriation" columnOrder: 2 suppressRepeating: true permission: null - ! description: "Full Account Code" type: "java.lang.String" propertyName: "fullAccountCode" propertyPath: null entityName: "BudgetBase" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Budget" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: true width: 36 relativePropertyName: "fullAccountCode" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "BudgetBase" sortOrder: 3 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: true width: 25 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false permission: null - ! 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: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! 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: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! 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: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! 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: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false permission: null - ! description: "FYTD Unencumbered" type: "java.math.BigDecimal" propertyName: "FYTDUnencumbered" propertyPath: null entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: "FYTD Unencumbered" columnTitle: "Amount Available" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "FYTDUnencumbered" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "FYTDPercent Expended" type: "java.math.BigDecimal" propertyName: "FYTDPercentExpended" propertyPath: null entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "PERCENT" source: "METHOD" label: "" columnTitle: "FYTDPercent Expended" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "FYTDPercentExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false permission: null - ! 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: "Next Year Proposed" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "nextYearProposed" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 11 suppressRepeating: false permission: null - ! description: "Prior Year Expended" type: "java.math.BigDecimal" propertyName: "priorYearExpended" propertyPath: null entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Prior Year Expended" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "priorYearExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 12 suppressRepeating: false permission: null - ! description: "Two Years Prior Expended" type: "java.math.BigDecimal" propertyName: "twoYearsPriorExpended" propertyPath: null entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Two Years Prior Expended" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "twoYearsPriorExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 13 suppressRepeating: false permission: null - ! description: "Three Years Prior Expended" type: "java.math.BigDecimal" propertyName: "threeYearsPriorExpended" propertyPath: null entityName: "Budget" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Three Years Prior Expended" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "threeYearsPriorExpended" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 14 suppressRepeating: false permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: "code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true 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: ! [] currentPath: ! - "code" columnOrder: 15 suppressRepeating: false permission: null - ! description: "Func" type: "java.lang.String" propertyName: "func" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 16 suppressRepeating: false permission: null - ! description: "Function One Digit Level" type: "java.lang.String" propertyName: "functionOneDigitLevel" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.functionOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 17 suppressRepeating: false permission: null - ! description: "Function Two Digit Level" type: "java.lang.String" propertyName: "functionTwoDigitLevel" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Function Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.functionTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 18 suppressRepeating: false permission: null - ! description: "Object" type: "java.lang.String" propertyName: "object" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 19 suppressRepeating: false permission: null - ! description: "Object One Digit Level" type: "java.lang.String" propertyName: "objectOneDigitLevel" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Object One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.objectOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 20 suppressRepeating: false permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: "code" entityName: "AccountCode" sortOrder: 0 controlBreak: false suppressed: true 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: ! [] currentPath: ! - "code" columnOrder: 21 suppressRepeating: false permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 22 suppressRepeating: false permission: null - ! description: "Subject Two Digit Level" type: "java.lang.String" propertyName: "subjectTwoDigitLevel" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Subject Two Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.subjectTwoDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 23 suppressRepeating: false permission: null - ! description: "OPU" type: "java.lang.String" propertyName: "opu" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 24 suppressRepeating: false permission: null - ! description: "Opu One Digit Level" type: "java.lang.String" propertyName: "opuOneDigitLevel" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Opu One Digit Level" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code.opuOneDigitLevel" dataSourcePath: path: ! [] currentPath: ! - "code" columnOrder: 25 suppressRepeating: false permission: null - ! description: "Job" type: "java.lang.String" propertyName: "job" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 26 suppressRepeating: false permission: null - ! description: "IL" type: "java.lang.String" propertyName: "il" propertyPath: "code" entityName: "BudgetCode" sortOrder: 0 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: ! [] currentPath: ! - "code" columnOrder: 27 suppressRepeating: false permission: null