--- reportDefinition: ! description: "Compensation Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Compensation Report" suppressDetail: false showOptions: true sortProperties: ! - ! propertyName: "position.payGroup.code" label: "Code" ascending: true controlBreak: true pageBreak: true - propertyName: "position.payGroup.description" label: "Description" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.name.fullName" label: "Full Name" ascending: true controlBreak: true pageBreak: false - propertyName: "position.employee.number" label: "Number" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.name.firstName" label: "First Name" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Compensation Report" querySpecification: specification: "position.employee.deleted.eq 'false'\nposition.positionDescription.oneOf\ \ ([param(\"positionDescription\",'',\"Position Description(s)\")])\nposition.payGroup.code.oneOf\ \ ([param(\"paygroup\",'',\"Pay Group(s)\")])\ncompensationAmounts.paysPaid.eq\ \ param(\"paysPaid\",\"\",\"Pays Paid\")\nposition.jobStatus.eq param(\"active\"\ ,\"\",\"Active Only? (Enter active for active only or inactive for inactive\ \ only. Leave blank for both.)\")\ndateRange.startDate.ge param(\"StartDate\"\ ,\"\",\"Starting Compensation Date\")\ndateRange.stopDate.le param(\"EndDate\"\ ,\"\",\"Ending Compensation Date\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.Compensation" properties: ! - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 1 controlBreak: true suppressed: true pageBreak: true ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.payGroup.code" dataSourcePath: path: ! [] currentPath: ! - "position" - "payGroup" suppressRepeating: false columnOrder: 1 - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 1 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.payGroup.description" dataSourcePath: path: ! [] currentPath: ! - "position" - "payGroup" suppressRepeating: false columnOrder: 2 - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 2 controlBreak: true suppressed: true 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: "position.employee.name.fullName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" suppressRepeating: false columnOrder: 3 - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "position.employee" entityName: "Employee" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Number" alignment: "LEFT" controlHeaderOnly: true controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.number" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 4 - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 3 controlBreak: false suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 7 relativePropertyName: "position.employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" suppressRepeating: false columnOrder: 5 - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 4 controlBreak: false suppressed: true 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: 6 relativePropertyName: "position.employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" suppressRepeating: false columnOrder: 6 - ! description: "Position Description" type: "java.lang.String" propertyName: "positionDescription" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Position Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 7 - ! description: "Contract Days Worked" type: "java.math.BigDecimal" propertyName: "contractDaysWorked" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Contract Days Worked" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractDaysWorked" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 8 - ! description: "Contract Work Days" type: "java.math.BigDecimal" propertyName: "contractWorkDays" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "DEFAULT" source: "METHOD" label: "" columnTitle: "Contract Work Days" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractWorkDays" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 9 - ! description: "Pays Paid" type: "java.lang.Integer" propertyName: "paysPaid" propertyPath: "compensationAmounts" entityName: "CompensationAmounts" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Pays Paid" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "compensationAmounts.paysPaid" dataSourcePath: path: ! [] currentPath: ! - "compensationAmounts" suppressRepeating: false columnOrder: 10 - ! description: "Amount Paid" type: "java.math.BigDecimal" propertyName: "amountPaid" propertyPath: "compensationAmounts" entityName: "CompensationAmounts" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Amount Paid" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "compensationAmounts.amountPaid" dataSourcePath: path: ! [] currentPath: ! - "compensationAmounts" suppressRepeating: false columnOrder: 11 - ! description: "Contract Amount" type: "java.math.BigDecimal" propertyName: "contractAmount" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "Contract Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "contractAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "dateRange" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Start Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.startDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 13 - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "dateRange" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Stop Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.stopDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 14