--- reportDefinition: ! description: "New Employee EMIS Active/Inactive Non Contract Compensation Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "CSV" templateName: "EMIS Active Non Contract Compensation Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "dateRange.stopDate" label: "Stop Date" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false - propertyName: "position.number" label: "Pos #" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "EMIS Active Non Contract Compensation Report" querySpecification: specification: "position.employee.archived.eq 'false'\nposition.jobStatus.oneOf\ \ (['Active','Inactive'])\ntype.oneOf (['nonContract'])\nposition.hireDate.between\ \ param(\"startDate\"),param(\"endDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.NonContractCompensation" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Number" 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: 2 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: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: "NONE" source: "FIELD" label: "Pos #" columnTitle: "Pos #" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "position.number" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 4 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: "Position Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.positionDescription" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 5 permission: null - ! description: "Job Status" type: "org.ssdt_ohio.usps.model.constants.JobStatus" propertyName: "jobStatus" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Job Status" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.jobStatus" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 6 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: "Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 7 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: "Start Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.startDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 8 permission: null - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "dateRange" entityName: "DateRange" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true 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: 9 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: null columnTitle: "Pay Unit" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payUnit" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 10 permission: null - ! description: "Unit Amount" type: "java.math.BigDecimal" propertyName: "unitAmount" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: true format: null source: "FIELD" label: null columnTitle: "Unit Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "unitAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 permission: null - ! propertyName: "reportableToEMIS" reportableProperty: ! description: "Reportable to EMIS" type: "java.lang.Boolean" propertyName: "customFields.reportableToEMIS.value" propertyPath: null entityName: "NonContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Reportable to EMIS" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "customFields.reportableToEMIS.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true columnTitle: "Reportable to EMIS" baseClassProperty: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 12 sortOrder: 0 function: null suppressed: false entityName: "NonContractCompensation" format: null width: 12 description: "Reportable to EMIS" name: "customFields.reportableToEMIS.value" type: "java.lang.Boolean" 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: "Sum" baseClassProperty: true format: "DEFAULT" source: "FIELD" label: null columnTitle: "Hours In Day" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "hoursInDay" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null