--- reportDefinition: ! description: "HistoricalPayAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Account History Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "expenditureAccount" label: "Expenditure Account" ascending: true controlBreak: true pageBreak: false - propertyName: "historicalPositionPay.employeePay.payroll.dateRange.stopDate" label: "Stop Date" ascending: true controlBreak: true pageBreak: false queryParameters: ! {} title: "Account History Report" querySpecification: specification: "historicalPositionPay.employeePay.payroll.dateRange.stopDate.between\ \ param(\"startDate\"),param(\"endDate\")\nhistoricalPositionPay.employeePay.employeeNumber.oneOf\ \ ([param(\"employeNumber\",'',\"Employee Number (enter one or more separated\ \ by commas)\")])\nfund.eq param(\"fund\")\nfunction.eq param(\"function\")\n\ object.eq param(\"object\")\nscc.eq param(\"scc\")\nsubject.eq param(\"subject\"\ )\noperationalUnit.eq param(\"opu\")\ninstructionalLevel.eq param(\"il\")\n\ job.eq param(\"job\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayAccount" properties: ! - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "historicalPositionPay.employeePay.payroll.dateRange" entityName: "DateRange" sortOrder: 2 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "Stop Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "historicalPositionPay.employeePay.payroll.dateRange.stopDate" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "payroll" - "dateRange" suppressRepeating: false columnOrder: 1 permission: null - ! description: "Employee Number" type: "java.lang.String" propertyName: "employeeNumber" propertyPath: "historicalPositionPay.employeePay" entityName: "HistoricalEmployeePay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Employee Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.employeeNumber" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" suppressRepeating: false columnOrder: 2 permission: null - ! description: "Position Number" type: "java.lang.Integer" propertyName: "positionNumber" propertyPath: "historicalPositionPay" entityName: "HistoricalPositionPay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Position Number" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.positionNumber" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" suppressRepeating: false columnOrder: 3 permission: null - ! description: "Report Name" type: "java.lang.String" propertyName: "reportName" propertyPath: "historicalPositionPay.employeePay.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "" columnTitle: "Report Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 25 relativePropertyName: "historicalPositionPay.employeePay.name.reportName" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "name" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Expenditure Account" type: "java.lang.String" propertyName: "expenditureAccount" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 1 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Expenditure Account" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 33 relativePropertyName: "expenditureAccount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 5 permission: null - ! description: "Amount Charged" type: "java.math.BigDecimal" propertyName: "amountCharged" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Amount Charged" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amountCharged" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 6 permission: null - ! description: "Chargeable Calculation Percentage" type: "java.math.BigDecimal" propertyName: "percentageToCalculateChargableAmount" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "Chargeable Calculation Percentage" columnTitle: "Chargeable Calculation Percentage" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "percentageToCalculateChargableAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 7 permission: null - ! description: "Fund" type: "java.lang.String" propertyName: "fund" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Fund" columnTitle: "Fund" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "fund" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 8 permission: null - ! description: "Func" type: "java.lang.String" propertyName: "function" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Func" columnTitle: "Func" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "function" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 9 permission: null - ! description: "Obj" type: "java.lang.String" propertyName: "object" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Obj" columnTitle: "Obj" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "object" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 10 permission: null - ! description: "SCC" type: "java.lang.String" propertyName: "scc" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "SCC" columnTitle: "SCC" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "scc" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! description: "Subject" type: "java.lang.String" propertyName: "subject" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Subject" columnTitle: "Subject" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "subject" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 permission: null - ! description: "OPU" type: "java.lang.String" propertyName: "operationalUnit" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "OPU" columnTitle: "OPU" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "operationalUnit" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! description: "Job" type: "java.lang.String" propertyName: "job" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "Job" columnTitle: "Job" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 3 relativePropertyName: "job" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 14 permission: null - ! description: "IL" type: "java.lang.String" propertyName: "instructionalLevel" propertyPath: null entityName: "HistoricalPayAccount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: "IL" columnTitle: "IL" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 2 relativePropertyName: "instructionalLevel" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 15 permission: null