--- reportDefinition: ! description: "HistoricalPayrollItem Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "Payroll Item History Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "code" label: "Code" ascending: true controlBreak: true pageBreak: false - propertyName: "historicalEmployeePay.employeeNumber" label: "Employee Number" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Payroll Item History Report" querySpecification: specification: "historicalEmployeePay.payroll.payDate.between param(\"startDate\"\ ),param(\"endDate\")\ncode.oneOf ([param(\"codes\",'',\"Payroll Item Codes (separated\ \ by commas)\")])\nhistoricalEmployeePay.voided.eq 'false'" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayrollItem" properties: ! - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 1 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 1 permission: null - ! description: "Employee Number" type: "java.lang.String" propertyName: "employeeNumber" propertyPath: "historicalEmployeePay" entityName: "HistoricalEmployeePay" sortOrder: 2 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: "historicalEmployeePay.employeeNumber" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" suppressRepeating: false columnOrder: 2 permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "historicalEmployeePay.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "name" suppressRepeating: false columnOrder: 3 permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "historicalEmployeePay.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "First Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "name" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Applicable Gross" type: "java.math.BigDecimal" propertyName: "applicableGross" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Applicable Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "applicableGross" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 5 permission: null - ! description: "Rate" type: "java.math.BigDecimal" propertyName: "rate" propertyPath: "payrollItem" entityName: "PayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Rate" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payrollItem.rate" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" suppressRepeating: false columnOrder: 6 permission: null - ! description: "Total Employee Amount" type: "java.math.BigDecimal" propertyName: "totalEmployeeAmount" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Total Employee Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "totalEmployeeAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 7 permission: null - ! description: "Deduction Type" type: "org.ssdt_ohio.usps.model.constants.CityDeductionType" propertyName: "deductionType" propertyPath: "payrollItem" entityName: "CityTaxItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Deduction Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payrollItem.deductionType" dataSourcePath: path: ! [] currentPath: ! - "payrollItem" suppressRepeating: false columnOrder: 8 permission: null - ! description: "Total Employer Amount" type: "java.math.BigDecimal" propertyName: "totalEmployerAmount" propertyPath: null entityName: "HistoricalPayrollItem" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Total Employer Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "totalEmployerAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 9 permission: null