--- reportDefinition: ! description: "HistoricalPayAccount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "SSDT Account History Report v2.0" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "expenditureAccount" label: "Expenditure Account" ascending: true controlBreak: true pageBreak: false - propertyName: "historicalPositionPay.employeePay.payroll.payDate" label: "Pay Date" ascending: true controlBreak: false pageBreak: false - propertyName: "historicalPositionPay.employeePay.employeeNumber" label: "Employee Number" ascending: true controlBreak: true pageBreak: false - propertyName: "amountCharged" label: "Amount Charged" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "SSDT Account History Report v2.0" querySpecification: specification: "historicalPositionPay.employeePay.payroll.payDate.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: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "historicalPositionPay.employeePay.payroll" entityName: "AbstractPayroll" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: false function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Pay Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "historicalPositionPay.employeePay.payroll.payDate" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "payroll" suppressRepeating: false columnOrder: 1 permission: null - ! description: "Employee Number" type: "java.lang.String" propertyName: "employeeNumber" propertyPath: "historicalPositionPay.employeePay" entityName: "HistoricalEmployeePay" sortOrder: 2 controlBreak: true 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: 4 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