--- reportDefinition: ! description: "New EMIS Employee Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "CSV" templateName: "EMIS Demographic Data Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "lastPaidDate" label: "Last Paid Date" ascending: true controlBreak: false pageBreak: false - propertyName: "name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "EMIS Demographic Data Report" querySpecification: specification: "archived.eq 'false'\nhireDate.between param(\"startDate\"),param(\"\ endDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.employee.Employee" properties: ! - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Number" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "number" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 1 permission: null - ! propertyName: "credentialID" reportableProperty: ! description: "Credential ID" type: "java.lang.String" propertyName: "customFields.credentialID.value" propertyPath: null 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: "customFields.credentialID.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Credential ID" suppressRepeating: false columnOrder: 2 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "Credential ID" name: "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: null 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: "customFields.nonCertificateEmployeeID.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Non-Certificate Employee ID" suppressRepeating: false columnOrder: 3 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "Non-Certificate Employee ID" name: "customFields.nonCertificateEmployeeID.value" type: "java.lang.String" permission: null - ! description: "SSN" type: "java.lang.String" propertyName: "ssn" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "SSN" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "ssn" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 4 permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "name" entityName: "Name" sortOrder: 2 controlBreak: false suppressed: false 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: 0 relativePropertyName: "name.lastName" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 5 permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false 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: 0 relativePropertyName: "name.firstName" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 6 permission: null - ! description: "Middle Name" type: "java.lang.String" propertyName: "middleName" propertyPath: "name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Middle Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "name.middleName" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 7 permission: null - ! description: "Suffix" type: "java.lang.String" propertyName: "suffix" propertyPath: "name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Suffix" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "name.suffix" dataSourcePath: path: ! [] currentPath: ! - "name" suppressRepeating: false columnOrder: 8 permission: null - ! description: "Termination Date" type: "java.util.Calendar" propertyName: "terminationDate" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Termination Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "terminationDate" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 9 permission: null - ! description: "Last Paid Date" type: "java.util.Calendar" propertyName: "lastPaidDate" propertyPath: null entityName: "Employee" sortOrder: 1 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "METHOD" label: null columnTitle: "Last Paid Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "lastPaidDate" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 10 permission: null - ! propertyName: "totalExperience" reportableProperty: ! description: "Total Experience" type: "java.math.BigDecimal" propertyName: "customFields.totalExperience.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: "Total Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.totalExperience.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Total Experience" suppressRepeating: false columnOrder: 11 sortOrder: 0 function: "Sum" suppressed: false format: null width: 0 entityName: "Employee" description: "Total Experience" name: "customFields.totalExperience.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "authorizedExperience" reportableProperty: ! description: "Authorized Experience" type: "java.math.BigDecimal" propertyName: "customFields.authorizedExperience.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: "Authorized Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.authorizedExperience.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Authorized Experience" suppressRepeating: false columnOrder: 12 sortOrder: 0 function: "Sum" suppressed: false format: null width: 0 entityName: "Employee" description: "Authorized Experience" name: "customFields.authorizedExperience.value" type: "java.math.BigDecimal" permission: null - ! description: "Birth Date" type: "java.util.Calendar" propertyName: "birthDate" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: "Birth Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "birthDate" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! propertyName: "ECEQualification" reportableProperty: ! description: "ECE Qualification" type: "java.lang.String" propertyName: "customFields.ECEQualification.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "ECE Qualification" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.ECEQualification.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "ECE Qualification" suppressRepeating: false columnOrder: 14 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "ECE Qualification" name: "customFields.ECEQualification.value" type: "java.lang.String" permission: null - ! propertyName: "degreeType" reportableProperty: ! description: "Degree Type" type: "java.lang.String" propertyName: "customFields.degreeType.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Degree Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.degreeType.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Degree Type" suppressRepeating: false columnOrder: 15 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "Degree Type" name: "customFields.degreeType.value" type: "java.lang.String" permission: null - ! propertyName: "semesterHours" reportableProperty: ! description: "Semester Hours" type: "java.math.BigDecimal" propertyName: "customFields.semesterHours.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: "Semester Hours" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.semesterHours.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Semester Hours" suppressRepeating: false columnOrder: 16 sortOrder: 0 function: "Sum" suppressed: false format: null width: 0 entityName: "Employee" description: "Semester Hours" name: "customFields.semesterHours.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "gender" reportableProperty: ! description: "Gender" type: "java.lang.String" propertyName: "customFields.gender.value" propertyPath: null entityName: "Employee" sortOrder: 0 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: "customFields.gender.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Gender" suppressRepeating: false columnOrder: 17 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "Gender" name: "customFields.gender.value" type: "java.lang.String" permission: null - ! propertyName: "principalExperience" reportableProperty: ! description: "Principal Experience" type: "java.math.BigDecimal" propertyName: "customFields.principalExperience.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: null source: null label: null columnTitle: "Principal Experience" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.principalExperience.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "RIGHT" columnTitle: "Principal Experience" suppressRepeating: false columnOrder: 18 sortOrder: 0 function: "Sum" suppressed: false format: null width: 0 entityName: "Employee" description: "Principal Experience" name: "customFields.principalExperience.value" type: "java.math.BigDecimal" permission: null - ! propertyName: "primaryRace" reportableProperty: ! description: "Primary Race" type: "java.lang.String" propertyName: "customFields.primaryRace.value" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Primary Race" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "customFields.primaryRace.value" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 0 permission: null ascending: true controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false baseClassProperty: false alignment: "LEFT" columnTitle: "Primary Race" suppressRepeating: false columnOrder: 19 sortOrder: 0 function: null suppressed: false format: null width: 0 entityName: "Employee" description: "Primary Race" name: "customFields.primaryRace.value" type: "java.lang.String" permission: null - ! description: "American Indian Alaska Native" type: "java.lang.Boolean" propertyName: "americanIndianAlaskaNative" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.americanIndianAlaskaNative" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 20 permission: null - ! description: "Asian" type: "java.lang.Boolean" propertyName: "asian" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.asian" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 21 permission: null - ! description: "Black" type: "java.lang.Boolean" propertyName: "black" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.black" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 22 permission: null - ! description: "Hispanic Latino Option" type: "org.ssdt_ohio.usps.model.constants.HispanicLatinoOptions" propertyName: "hispanicLatinoOption" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.hispanicLatinoOption" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 23 permission: null - ! description: "Native Hawaiian Pacific Islander" type: "java.lang.Boolean" propertyName: "nativeHawaiianPacificIslander" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.nativeHawaiianPacificIslander" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 24 permission: null - ! description: "White" type: "java.lang.Boolean" propertyName: "white" propertyPath: "race" entityName: "Race" sortOrder: 0 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: "race.white" dataSourcePath: path: ! [] currentPath: ! - "race" suppressRepeating: false columnOrder: 25 permission: null - ! description: "Report to EMIS" type: "java.lang.Boolean" propertyName: "reportToEmis" propertyPath: null entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: "Report to EMIS" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "reportToEmis" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 26 permission: null