--- reportDefinition: ! description: "Compensation Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "EEO-5 Template Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "position.positionDescription" label: "Position Description" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.customFields.gender.value" label: "Gender" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.name.fullName" label: "Full Name" ascending: true controlBreak: false pageBreak: false - propertyName: "dateRange.startDate" label: "Start Date" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.hispanicLatinoOption" label: "Hispanic Latino Option" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.americanIndianAlaskaNative" label: "American Indian Alaska Native" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.asian" label: "Asian" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.black" label: "Black" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.nativeHawaiianPacificIslander" label: "Native Hawaiian Pacific Islander" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.race.white" label: "White" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.odjfsHireDateForReport" label: "Odjfs Hire Date For Report" ascending: false controlBreak: false pageBreak: false - propertyName: "position.employee.customFields.partTime.value" label: "Part Time" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "EEO-5 Template Report" querySpecification: specification: "position.jobStatus.ne 'Deceased,Terminated'\nposition.employee.lastPaidDate.between\ \ param(\"startDate\"),param(\"endDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.Compensation" properties: ! - ! description: "Full Name" type: "java.lang.String" propertyName: "fullName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 3 controlBreak: false suppressed: false 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" columnOrder: 1 suppressRepeating: true permission: null - ! description: "Position Description" type: "java.lang.String" propertyName: "positionDescription" propertyPath: "position" entityName: "Position" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false 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" columnOrder: 2 suppressRepeating: false permission: null - ! propertyName: "assignmentArea" reportableProperty: ! description: "Assignment Area" type: "java.lang.String" propertyName: "customFields.assignmentArea.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: "Assignment Area" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.customFields.assignmentArea.value" dataSourcePath: path: ! [] currentPath: ! - "position" columnOrder: 0 suppressRepeating: false permission: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false baseClassProperty: false ascending: true columnTitle: "Assignment Area" entityName: "Position" function: null columnOrder: 3 sortOrder: 0 suppressed: false suppressRepeating: false alignment: "LEFT" controlBreak: false pageBreak: false width: 0 format: null description: "Assignment Area" name: "position.customFields.assignmentArea.value" type: "java.lang.String" permission: null - ! propertyName: "gender" reportableProperty: ! description: "Gender" type: "java.lang.String" propertyName: "customFields.gender.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Gender" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.gender.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 0 suppressRepeating: false permission: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false baseClassProperty: false ascending: true columnTitle: "Gender" entityName: "Employee" function: null columnOrder: 4 sortOrder: 2 suppressed: false suppressRepeating: false alignment: "LEFT" controlBreak: false pageBreak: false width: 0 format: null description: "Gender" name: "position.employee.customFields.gender.value" type: "java.lang.String" permission: null - ! description: "Hispanic Latino Option" type: "org.ssdt_ohio.usps.model.constants.HispanicLatinoOptions" propertyName: "hispanicLatinoOption" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Hispanic Latino Option" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.race.hispanicLatinoOption" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 5 suppressRepeating: false permission: null - ! description: "American Indian Alaska Native" type: "java.lang.Boolean" propertyName: "americanIndianAlaskaNative" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "American Indian Alaska Native" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "position.employee.race.americanIndianAlaskaNative" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 6 suppressRepeating: false permission: null - ! description: "Asian" type: "java.lang.Boolean" propertyName: "asian" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Asian" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.asian" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 7 suppressRepeating: false permission: null - ! description: "Black" type: "java.lang.Boolean" propertyName: "black" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Black" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.black" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 8 suppressRepeating: false permission: null - ! description: "Native Hawaiian Pacific Islander" type: "java.lang.Boolean" propertyName: "nativeHawaiianPacificIslander" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Native Hawaiian Pacific Islander" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "position.employee.race.nativeHawaiianPacificIslander" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 9 suppressRepeating: false permission: null - ! description: "White" type: "java.lang.Boolean" propertyName: "white" propertyPath: "position.employee.race" entityName: "Race" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "White" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "position.employee.race.white" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" - "race" columnOrder: 10 suppressRepeating: false permission: null - ! description: "Odjfs Hire Date For Report" type: "java.util.Calendar" propertyName: "odjfsHireDateForReport" propertyPath: "position.employee" entityName: "Employee" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: false function: null baseClassProperty: false format: "CALENDAR" source: "METHOD" label: "" columnTitle: "Odjfs Hire Date For Report" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.employee.odjfsHireDateForReport" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 11 suppressRepeating: false permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "dateRange" entityName: "DateRange" sortOrder: 3 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" columnOrder: 12 suppressRepeating: false permission: null - ! propertyName: "partTime" reportableProperty: ! description: "Part Time" type: "java.lang.Boolean" propertyName: "customFields.partTime.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 6 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Part Time" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 4 relativePropertyName: "position.employee.customFields.partTime.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" columnOrder: 0 suppressRepeating: false permission: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false baseClassProperty: false ascending: true columnTitle: "Part Time" entityName: "Employee" function: null columnOrder: 13 sortOrder: 6 suppressed: false suppressRepeating: false alignment: "LEFT" controlBreak: false pageBreak: false width: 4 format: null description: "Part Time" name: "position.employee.customFields.partTime.value" type: "java.lang.Boolean" permission: null