--- reportDefinition: ! description: "Position Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "CSV" templateName: "American Fidelity Census Report" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "employee.name.lastName" label: "Last Name" ascending: true controlBreak: false pageBreak: false queryParameters: ! {} title: "American Fidelity Census Report" querySpecification: specification: "employee.lastPaidDate.ge param(\"lastPaidDate\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.Position" properties: ! - ! description: "SSN" type: "java.lang.String" propertyName: "ssn" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "SSN" columnTitle: "SSN" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.ssn" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 1 suppressRepeating: false permission: null - ! description: "Number" type: "java.lang.String" propertyName: "number" propertyPath: "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: "employee.number" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" propertyPath: "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: "employee.name.lastName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 3 suppressRepeating: false permission: null - ! description: "First Name" type: "java.lang.String" propertyName: "firstName" propertyPath: "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: "employee.name.firstName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 4 suppressRepeating: false permission: null - ! description: "Middle Name" type: "java.lang.String" propertyName: "middleName" propertyPath: "employee.name" entityName: "Name" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Middle Name" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.name.middleName" dataSourcePath: path: ! [] currentPath: ! - "employee" - "name" columnOrder: 5 suppressRepeating: false permission: null - ! description: "Street1" type: "java.lang.String" propertyName: "street1" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street1" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.street1" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 6 suppressRepeating: false permission: null - ! description: "Street2" type: "java.lang.String" propertyName: "street2" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Street2" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.street2" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 7 suppressRepeating: false permission: null - ! description: "City" type: "java.lang.String" propertyName: "city" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "City" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.city" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 8 suppressRepeating: false permission: null - ! description: "State" type: "java.lang.String" propertyName: "state" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "State" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.state" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 9 suppressRepeating: false permission: null - ! description: "Postal Code" type: "java.lang.String" propertyName: "postalCode" propertyPath: "employee.address" entityName: "Address" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Postal Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.address.postalCode" dataSourcePath: path: ! [] currentPath: ! - "employee" - "address" columnOrder: 10 suppressRepeating: false permission: null - ! propertyName: "homePhone" reportableProperty: ! description: "Home Phone" type: "java.lang.String" propertyName: "customFields.homePhone.value" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Home Phone" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.customFields.homePhone.value" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 0 suppressRepeating: false permission: null ascending: true columnTitle: "Home Phone" columnOrder: 11 sortOrder: 0 function: null baseClassProperty: false controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" suppressRepeating: false suppressed: false format: null entityName: "Employee" width: 0 description: "Home Phone" name: "employee.customFields.homePhone.value" type: "java.lang.String" permission: null - ! description: "Birth Date" type: "java.util.Calendar" propertyName: "birthDate" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Birth Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "employee.birthDate" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 12 suppressRepeating: false permission: null - ! description: "Hire Date" type: "java.util.Calendar" propertyName: "hireDate" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: "" columnTitle: "Hire Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "employee.hireDate" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 13 suppressRepeating: false permission: null - ! description: "Contract Amount" type: "java.math.BigDecimal" propertyName: "contractAmount" propertyPath: "compensations" 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: ! - "compensations" currentPath: ! [] columnOrder: 14 suppressRepeating: false permission: null - ! propertyName: "gender" reportableProperty: ! description: "Gender" type: "java.lang.String" propertyName: "customFields.gender.value" propertyPath: "employee" 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: "employee.customFields.gender.value" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 0 suppressRepeating: false permission: null ascending: true columnTitle: "Gender" columnOrder: 15 sortOrder: 0 function: null baseClassProperty: false controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" suppressRepeating: false suppressed: false format: null entityName: "Employee" width: 0 description: "Gender" name: "employee.customFields.gender.value" type: "java.lang.String" permission: null - ! description: "Pays In Contract" type: "java.lang.Integer" propertyName: "paysInContract" propertyPath: "compensations" entityName: "ContractCompensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Pays In Contract" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "paysInContract" dataSourcePath: path: ! - "compensations" currentPath: ! [] columnOrder: 16 suppressRepeating: false permission: null - ! propertyName: "checkDistribution" reportableProperty: ! description: "Check Distribution" type: "java.lang.String" propertyName: "customFields.checkDistribution.value" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: null label: null columnTitle: "Check Distribution" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.customFields.checkDistribution.value" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 0 suppressRepeating: false permission: null ascending: true columnTitle: "Check Distribution" columnOrder: 17 sortOrder: 0 function: null baseClassProperty: false controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false controlBreak: false pageBreak: false alignment: "LEFT" suppressRepeating: false suppressed: false format: null entityName: "Employee" width: 0 description: "Check Distribution" name: "employee.customFields.checkDistribution.value" type: "java.lang.String" permission: null - ! description: "Position Description" type: "java.lang.String" propertyName: "positionDescription" propertyPath: null 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: "positionDescription" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 18 suppressRepeating: false permission: null - ! description: "Primary Email Address" type: "java.lang.String" propertyName: "primaryEmailAddress" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Primary Email Address" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "employee.primaryEmailAddress" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 19 suppressRepeating: false permission: null - ! description: "Pos #" type: "java.lang.Integer" propertyName: "number" propertyPath: null entityName: "Position" sortOrder: 0 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: "number" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 20 suppressRepeating: false permission: null - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "payGroup" entityName: "PayGroup" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: "" columnTitle: "Pay Group" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payGroup.code" dataSourcePath: path: ! [] currentPath: ! - "payGroup" columnOrder: 21 suppressRepeating: false permission: null - ! description: "Last Paid Date" type: "java.util.Calendar" propertyName: "lastPaidDate" propertyPath: "employee" entityName: "Employee" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "METHOD" label: "" columnTitle: "Last Paid Date" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 11 relativePropertyName: "employee.lastPaidDate" dataSourcePath: path: ! [] currentPath: ! - "employee" columnOrder: 22 suppressRepeating: false permission: null