--- reportDefinition: ! description: "ContractCompensation Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "XLSX" templateName: "Compensation Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "position.employee.number" label: "Number" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "Compensation Report" querySpecification: specification: "position.employee.deleted.eq 'false'\ndateRange.startDate.eq param(\"\ startDate\",\"\",\"Compensation Start Date\")\ndateRange.stopDate.eq param(\"\ stopDate\",\"\",\"Compensation Stop Date\")\nposition.payGroup.code.like param(\"\ payGroup\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.ContractCompensation" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "position.employee" entityName: "Employee" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "employeeId" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.number" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 1 permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Last Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" suppressRepeating: false columnOrder: 2 permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "First Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "name" suppressRepeating: false columnOrder: 3 permission: null - ! description: "Pos #" type: "java.lang.Integer" propertyName: "number" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "NONE" source: "FIELD" label: null columnTitle: "jobNo" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "position.number" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 4 permission: null - ! description: "Type" type: "org.ssdt_ohio.usps.model.constants.CompensationType" propertyName: "type" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "contractType" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 5 permission: null - ! description: "Label" type: "java.lang.String" propertyName: "label" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "compensationLabel" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "label" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 6 permission: null - ! description: "Type" type: "java.lang.String" propertyName: "type" propertyPath: "jobCalendar" entityName: "JobCalendar" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "calendarType" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "jobCalendar.type" dataSourcePath: path: ! [] currentPath: ! - "jobCalendar" suppressRepeating: false columnOrder: 7 permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "compensationDescription" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 8 permission: null - ! 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: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "contractStartDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.startDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 9 permission: null - ! 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: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "contractStopDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.stopDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 10 permission: null - ! description: "Pay Unit" type: "org.ssdt_ohio.usps.model.constants.DailyOrHourlyOptions" propertyName: "payUnit" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "payUnit" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payUnit" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! description: "Unit Amount" type: "java.math.BigDecimal" propertyName: "unitAmount" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: "unitAmount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "unitAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 12 permission: null - ! description: "Retirement Hours" type: "java.math.BigDecimal" propertyName: "retirementHours" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "DEFAULT" source: "FIELD" label: "" columnTitle: "retireHours" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "retirementHours" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! description: "Pay Per Period" type: "java.math.BigDecimal" propertyName: "payPerPeriod" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "payPerPeriod" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payPerPeriod" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 14 permission: null - ! 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: "contractAmount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 15 permission: null - ! description: "Contract Obligation" type: "java.math.BigDecimal" propertyName: "contractObligation" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CURRENCY" source: "FIELD" label: "" columnTitle: "contractObligation" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractObligation" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 16 permission: null - ! description: "Contract Type" type: "java.lang.String" propertyName: "contractType" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "userContractType" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractType" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 17 permission: null - ! description: "Pays In Contract" type: "java.lang.Integer" propertyName: "paysInContract" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "paysInContract" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "paysInContract" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 18 permission: null - ! description: "Stretch Pay" type: "java.lang.Boolean" propertyName: "stretchPay" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "equalPays" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 9 relativePropertyName: "stretchPay" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 19 permission: null - ! description: "Salary Schedule Column" type: "java.lang.Integer" propertyName: "salaryScheduleColumn" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "salaryScheduleColumn" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "salaryScheduleColumn" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 20 permission: null - ! description: "Salary Schedule Id" type: "java.lang.String" propertyName: "salaryScheduleId" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "salaryScheduleIdd" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "salaryScheduleId" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 21 permission: null - ! description: "Salary Schedule Step" type: "java.math.BigDecimal" propertyName: "salaryScheduleStep" propertyPath: null entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "salaryScheduleStep" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "salaryScheduleStep" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 22 permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "calendarDate" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "calendarStartDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "calendarDate.startDate" dataSourcePath: path: ! [] currentPath: ! - "calendarDate" suppressRepeating: false columnOrder: 23 permission: null - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "calendarDate" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "calendarStopDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "calendarDate.stopDate" dataSourcePath: path: ! [] currentPath: ! - "calendarDate" suppressRepeating: false columnOrder: 24 permission: null - ! description: "Hours In Day" type: "java.math.BigDecimal" propertyName: "hoursInDay" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "DEFAULT" source: "FIELD" label: "" columnTitle: "hoursInDay" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "hoursInDay" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 25 permission: null - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true 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: 26 permission: null - ! 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: true format: null source: "FIELD" label: "" columnTitle: "positionDescription" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 27 permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "position.positionDate" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "positionStartDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.positionDate.startDate" dataSourcePath: path: ! [] currentPath: ! - "position" - "positionDate" suppressRepeating: false columnOrder: 28 permission: null - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "position.positionDate" entityName: "DateRange" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "CALENDAR" source: "FIELD" label: null columnTitle: "positionStopDate" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.positionDate.stopDate" dataSourcePath: path: ! [] currentPath: ! - "position" - "positionDate" suppressRepeating: false columnOrder: 29 permission: null - ! propertyName: "positionCode" reportableProperty: ! description: "Position Code" type: "java.lang.String" propertyName: "customFields.positionCode.value" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "positionCode" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.customFields.positionCode.value" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "positionCode" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 30 ascending: true sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Position" description: "Position Code" name: "position.customFields.positionCode.value" type: "java.lang.String" permission: null