--- reportDefinition: ! description: "HistoricalEmployeePay Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "XLS" templateName: "Void Payroll History Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false - propertyName: "payrollItemsPaid.code" label: "Code" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Void Payroll History Report" querySpecification: specification: "payroll.dateRange.startDate.ge param(\"startDate\")\npayroll.dateRange.stopDate.le\ \ param(\"endDate\")\nvoided.eq 't'" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalEmployeePay" properties: ! - ! description: "Employee Number" type: "java.lang.String" propertyName: "employeeNumber" propertyPath: null entityName: "HistoricalEmployeePay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "employeeNumber" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 1 permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "name" entityName: "Name" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "name.lastName" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 2 permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "name.firstName" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 3 permission: null - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "payrollItemsPaid" entityName: "HistoricalPayrollItem" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "code" dataSourcePath: path: ! - "payrollItemsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 4 permission: null - ! description: "Type" type: "org.ssdt_ohio.usps.model.constants.PayrollItemType" propertyName: "type" propertyPath: "payrollItemsPaid" entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "type" dataSourcePath: path: ! - "payrollItemsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 5 permission: null - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: "payrollItemsPaid" entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! - "payrollItemsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 6 permission: null - ! description: "Employer Amount" type: "java.math.BigDecimal" propertyName: "employerAmount" propertyPath: "payrollItemsPaid" entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Employer Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employerAmount" dataSourcePath: path: ! - "payrollItemsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 7 permission: null - ! description: "Applicable Gross" type: "java.math.BigDecimal" propertyName: "applicableGross" propertyPath: "payrollItemsPaid" entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Applicable Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "applicableGross" dataSourcePath: path: ! - "payrollItemsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 8 permission: null - ! description: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "payroll" entityName: "AbstractPayroll" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: "" columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "payroll.payDate" dataSourcePath: path: ! [] currentPath: ! - "payroll" suppressRepeating: false columnOrder: 9 permission: null - ! description: "Position Number" type: "java.lang.Integer" propertyName: "positionNumber" propertyPath: "positionsPaid" entityName: "HistoricalPositionPay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "positionNumber" dataSourcePath: path: ! - "positionsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 10 permission: null - ! description: "Work Days" type: "java.lang.Integer" propertyName: "workDays" propertyPath: "positionsPaid" entityName: "HistoricalPositionPay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "workDays" dataSourcePath: path: ! - "positionsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! description: "Hours Worked" type: "java.math.BigDecimal" propertyName: "hoursWorked" propertyPath: "positionsPaid.payAmountsPaid" entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "hoursWorked" dataSourcePath: path: ! - "positionsPaid" - "payAmountsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 12 permission: null - ! description: "Rate" type: "java.math.BigDecimal" propertyName: "rate" propertyPath: "positionsPaid.payAmountsPaid" entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "rate" dataSourcePath: path: ! - "positionsPaid" - "payAmountsPaid" currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null