--- reportDefinition: ! description: "HistoricalPayAmount Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "HistoricalPayAmount Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "historicalPositionPay.employeePay.name.lastName" label: "Last Name" ascending: false controlBreak: false pageBreak: false queryParameters: ! {} title: "HistoricalPayAmount Report" querySpecification: specification: "historicalPositionPay.employeePay.payroll.payDate.eq param(\"\ payDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.HistoricalPayAmount" properties: ! - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "historicalPositionPay.employeePay.name" entityName: "Name" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: false function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "name" suppressRepeating: false columnOrder: 1 permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "historicalPositionPay.employeePay.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "First Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" - "name" suppressRepeating: false columnOrder: 2 permission: null - ! description: "Gross" type: "java.math.BigDecimal" propertyName: "gross" propertyPath: "historicalPositionPay.employeePay" entityName: "HistoricalEmployeePay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.gross" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" suppressRepeating: false columnOrder: 3 permission: null - ! description: "Adjusted Gross" type: "java.math.BigDecimal" propertyName: "adjustedGross" propertyPath: "historicalPositionPay.employeePay" entityName: "HistoricalEmployeePay" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "Adjusted Gross" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "historicalPositionPay.employeePay.adjustedGross" dataSourcePath: path: ! [] currentPath: ! - "historicalPositionPay" - "employeePay" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Pay Date" type: "java.util.Calendar" propertyName: "payDate" propertyPath: "historicalPositionPay.employeePay.payroll" entityName: "AbstractPayroll" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null 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: 5 permission: null - ! description: "Units" type: "java.math.BigDecimal" propertyName: "units" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: true format: "DEFAULT" source: "FIELD" label: null columnTitle: "Units" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "units" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 6 permission: null - ! description: "Rate" type: "java.math.BigDecimal" propertyName: "rate" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Rate" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "rate" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 7 permission: null - ! description: "Hours Worked" type: "java.math.BigDecimal" propertyName: "hoursWorked" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Hours Worked" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "hoursWorked" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 8 permission: null - ! description: "Applies For Retirement" type: "java.lang.Boolean" propertyName: "appliesForRetirement" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Applies For Retirement" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "appliesForRetirement" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 9 permission: null - ! description: "Pay Type" type: "org.ssdt_ohio.usps.model.constants.PayType" propertyName: "payType" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Pay Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payType" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 10 permission: null - ! description: "Supplemental" type: "java.lang.Boolean" propertyName: "supplemental" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Supplemental" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "supplemental" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! description: "Supplemental Tax Option" type: "org.ssdt_ohio.usps.model.constants.SupplementalTaxOption" propertyName: "supplementalTaxOption" propertyPath: null entityName: "AbstractPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Supplemental Tax Option" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "supplementalTaxOption" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 permission: null - ! description: "Amount" type: "java.math.BigDecimal" propertyName: "amount" propertyPath: null entityName: "HistoricalPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "FIELD" label: null columnTitle: "Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "amount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! description: "In Strs Advance Mode" type: "java.lang.Boolean" propertyName: "inStrsAdvanceMode" propertyPath: null entityName: "HistoricalPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "In Strs Advance Mode" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 9 relativePropertyName: "inStrsAdvanceMode" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 14 permission: null - ! description: "Retroactive Lump Sum Used" type: "java.lang.Boolean" propertyName: "retroactiveLumpSumUsed" propertyPath: null entityName: "HistoricalPayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Retroactive Lump Sum Used" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 14 relativePropertyName: "retroactiveLumpSumUsed" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 15 permission: null