--- reportDefinition: ! description: "HistoricalPayrollItem Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "403b" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "403b" querySpecification: specification: "code.oneOf ([param(\"codes\")])\nhistoricalEmployeePay.payroll.payDate.between\ \ param(\"startDate\"),param(\"endDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayrollItem" properties: ! - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "historicalEmployeePay.name" entityName: "Name" sortOrder: 2 controlBreak: true suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Last Name" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "name" columnOrder: 1 suppressRepeating: false - ! 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: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "name" columnOrder: 2 suppressRepeating: false - ! description: "Middle Name" type: "java.lang.String" propertyName: "middleName" 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: "Middle Name" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.name.middleName" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "name" columnOrder: 3 suppressRepeating: false - ! description: "Employee Ssn" type: "java.lang.String" propertyName: "employeeSsn" propertyPath: "historicalEmployeePay" entityName: "HistoricalEmployeePay" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Employee Ssn" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.employeeSsn" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" columnOrder: 4 suppressRepeating: false - ! description: "Street1" type: "java.lang.String" propertyName: "street1" propertyPath: "historicalEmployeePay.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street1" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.address.street1" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "address" columnOrder: 5 suppressRepeating: true - ! description: "Street2" type: "java.lang.String" propertyName: "street2" propertyPath: "historicalEmployeePay.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street2" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.address.street2" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "address" columnOrder: 6 suppressRepeating: true - ! description: "City" type: "java.lang.String" propertyName: "city" propertyPath: "historicalEmployeePay.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "City" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.address.city" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "address" columnOrder: 7 suppressRepeating: true - ! description: "State" type: "java.lang.String" propertyName: "state" propertyPath: "historicalEmployeePay.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "State" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.address.state" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "address" columnOrder: 8 suppressRepeating: true - ! description: "Postal Code" type: "java.lang.String" propertyName: "postalCode" propertyPath: "historicalEmployeePay.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Postal Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalEmployeePay.address.postalCode" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "address" columnOrder: 9 suppressRepeating: true - ! 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: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Total Employer Amount" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "totalEmployerAmount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false - ! 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: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "totalEmployeeAmount" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 11 suppressRepeating: false - ! description: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "historicalEmployeePay.payroll" entityName: "AbstractPayroll" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Pay Date" alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "historicalEmployeePay.payroll.payDate" dataSourcePath: path: ! [] currentPath: ! - "historicalEmployeePay" - "payroll" columnOrder: 12 suppressRepeating: false - ! 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: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 13 suppressRepeating: false