--- reportDefinition: ! description: "Compensation Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "EMIS Reportable Report" suppressDetail: false showOptions: false sortProperties: ! - ! 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 - propertyName: "customFields.reportableToEMIS.value" label: "Reportable to EMIS" ascending: true controlBreak: false pageBreak: false - propertyName: "position.customFields.reportableToEMIS.value" label: "Reportable to EMIS" ascending: true controlBreak: false pageBreak: false - propertyName: "position.employee.reportToEmis" label: "Report to EMIS" ascending: true controlBreak: false pageBreak: false - propertyName: "position.customFields.positionStatus.value" label: "Position Status" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "EMIS Reportable Report" querySpecification: specification: "position.employee.archived.eq 'false'" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.Compensation" properties: ! - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "position.employee.name" entityName: "Name" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" 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: 1 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: false format: null source: "FIELD" label: "" 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: 2 permission: null - ! 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: false format: null source: "FIELD" label: "" columnTitle: "Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.number" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 3 permission: null - ! propertyName: "credentialID" reportableProperty: ! description: "Credential ID" type: "java.lang.String" propertyName: "customFields.credentialID.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Credential ID" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.credentialID.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Credential ID" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 4 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Credential ID" name: "position.employee.customFields.credentialID.value" type: "java.lang.String" permission: null - ! propertyName: "nonCertificateEmployeeID" reportableProperty: ! description: "Non-Certificate Employee ID" type: "java.lang.String" propertyName: "customFields.nonCertificateEmployeeID.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Non-Certificate Employee ID" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.nonCertificateEmployeeID.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Non-Certificate Employee ID" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 5 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Non-Certificate Employee ID" name: "position.employee.customFields.nonCertificateEmployeeID.value" type: "java.lang.String" permission: null - ! description: "Pos #" type: "java.lang.Integer" propertyName: "number" propertyPath: "position" entityName: "Position" sortOrder: 2 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false 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: 6 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: 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" suppressRepeating: false columnOrder: 7 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: "Position Code" 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: "Position Code" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 8 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Position" width: 0 format: null description: "Position Code" name: "position.customFields.positionCode.value" type: "java.lang.String" permission: null - ! propertyName: "positionStatus" reportableProperty: ! description: "Position Status" type: "java.lang.String" propertyName: "customFields.positionStatus.value" propertyPath: "position" entityName: "Position" sortOrder: 6 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Position Status" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.customFields.positionStatus.value" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Position Status" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 9 ascending: true sortOrder: 6 function: null suppressed: false entityName: "Position" width: 0 format: null description: "Position Status" name: "position.customFields.positionStatus.value" type: "java.lang.String" permission: null - ! propertyName: "reportableToEMIS" reportableProperty: ! description: "Reportable to EMIS" type: "java.lang.Boolean" propertyName: "customFields.reportableToEMIS.value" propertyPath: null entityName: "Compensation" sortOrder: 3 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Compensation 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 detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Compensation Reportable to EMIS" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 10 ascending: true sortOrder: 3 function: null suppressed: false entityName: "Compensation" width: 12 format: null description: "Reportable to EMIS" name: "customFields.reportableToEMIS.value" type: "java.lang.Boolean" permission: null - ! propertyName: "reportableToEMIS" reportableProperty: ! description: "Reportable to EMIS" type: "java.lang.Boolean" propertyName: "customFields.reportableToEMIS.value" propertyPath: "position" entityName: "Position" sortOrder: 4 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Position Reportable to EMIS" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "position.customFields.reportableToEMIS.value" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Position Reportable to EMIS" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 11 ascending: true sortOrder: 4 function: null suppressed: false entityName: "Position" width: 12 format: null description: "Reportable to EMIS" name: "position.customFields.reportableToEMIS.value" type: "java.lang.Boolean" permission: null - ! description: "Report to EMIS" type: "java.lang.Boolean" propertyName: "reportToEmis" propertyPath: "position.employee" entityName: "Employee" sortOrder: 5 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "Report to EMIS" columnTitle: "Employee Report to EMIS" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "position.employee.reportToEmis" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 12 permission: null - ! 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: "FIELD" label: "" columnTitle: "Contract Work Days" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractWorkDays" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! propertyName: "semesterHours" reportableProperty: ! description: "Semester Hours" type: "java.math.BigDecimal" propertyName: "customFields.semesterHours.value" propertyPath: "position.supervisor" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Semester Hours" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.supervisor.customFields.semesterHours.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "supervisor" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Semester Hours" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 14 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Semester Hours" name: "position.supervisor.customFields.semesterHours.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "separationDate" reportableProperty: ! description: "Separation Date" type: "java.util.Calendar" propertyName: "customFields.separationDate.value" propertyPath: "position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: null label: null columnTitle: "Separation Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "position.customFields.separationDate.value" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Separation Date" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 15 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Position" width: 11 format: "CALENDAR" description: "Separation Date" name: "position.customFields.separationDate.value" type: "java.util.Calendar" permission: null - ! propertyName: "separationReason" reportableProperty: ! description: "Separation Reason" type: "java.lang.String" propertyName: "customFields.separationReason.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: "Separation Reason" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.customFields.separationReason.value" dataSourcePath: path: ! [] currentPath: ! - "position" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Separation Reason" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 16 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Position" width: 0 format: null description: "Separation Reason" name: "position.customFields.separationReason.value" type: "java.lang.String" 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: "Contract Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "contractAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 17 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: false format: null source: "FIELD" label: "" columnTitle: "Pay Unit" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payUnit" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 18 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: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Unit Amount" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "unitAmount" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 19 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: false format: "DEFAULT" source: "FIELD" label: "" columnTitle: "Hours In Day" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "hoursInDay" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 20 permission: null - ! propertyName: "principalExperience" reportableProperty: ! description: "Principal Experience" type: "java.math.BigDecimal" propertyName: "customFields.principalExperience.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Principal Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.principalExperience.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Principal Experience" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 21 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Principal Experience" name: "position.employee.customFields.principalExperience.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "authorizedExperience" reportableProperty: ! description: "Authorized Experience" type: "java.math.BigDecimal" propertyName: "customFields.authorizedExperience.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Authorized Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.authorizedExperience.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Authorized Experience" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 22 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Authorized Experience" name: "position.employee.customFields.authorizedExperience.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "totalExperience" reportableProperty: ! description: "Total Experience" type: "java.math.BigDecimal" propertyName: "customFields.totalExperience.value" propertyPath: "position.employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Total Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.employee.customFields.totalExperience.value" dataSourcePath: path: ! [] currentPath: ! - "position" - "employee" suppressRepeating: false columnOrder: 0 permission: null detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Total Experience" controlHeaderOnly: false controlFooterOnly: false suppressRepeating: false columnOrder: 23 ascending: true sortOrder: 0 function: null suppressed: false entityName: "Employee" width: 0 format: null description: "Total Experience" name: "position.employee.customFields.totalExperience.value" type: "java.math.BigDecimal" 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: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Compensation Stop Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "dateRange.stopDate" dataSourcePath: path: ! [] currentPath: ! - "dateRange" suppressRepeating: false columnOrder: 24 permission: null