--- reportDefinition: ! description: "HistoricalPayAmount 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: "specificAccountsCharged.expenditureAccount" label: "Expenditure Account" ascending: true controlBreak: false pageBreak: false - propertyName: "historicalPositionPay.employeePay.employeeNumber" label: "Employee Number" ascending: true controlBreak: true pageBreak: false - propertyName: "historicalPositionPay.employeePay.payroll.payDate" label: "Pay Date" 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)\")])\nspecificAccountsCharged.fund.eq param(\"fund\")\nspecificAccountsCharged.function.eq\ \ param(\"function\")\nspecificAccountsCharged.object.eq param(\"object\")\n\ specificAccountsCharged.scc.eq param(\"scc\")\nspecificAccountsCharged.subject.eq\ \ param(\"subject\")\nspecificAccountsCharged.operationalUnit.eq param(\"opu\"\ )\nspecificAccountsCharged.instructionalLevel.eq param(\"il\")\nspecificAccountsCharged.job.eq\ \ param(\"job\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayAmount" 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: true 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: "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: 2 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: 3 permission: null - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" 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: "Full Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "name" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Amount Charged" type: "java.math.BigDecimal" propertyName: "amountCharged" propertyPath: "specificAccountsCharged" 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: ! - "specificAccountsCharged" currentPath: ! [] suppressRepeating: false columnOrder: 5 permission: null - ! description: "Expenditure Account" type: "java.lang.String" propertyName: "expenditureAccount" propertyPath: "specificAccountsCharged" entityName: "HistoricalPayAccount" sortOrder: 1 controlBreak: false 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: ! - "specificAccountsCharged" currentPath: ! [] suppressRepeating: false columnOrder: 6 permission: null