--- reportDefinition: ! description: "NonContractCompensation Report" tags: null predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "PORTRAIT" outputFormat: "XLSX-F" templateName: "Non Contract Compensation Mass Load Extract" suppressDetail: false showOptions: false sortProperties: ! [] queryParameters: ! {} title: "Non Contract Compensation Mass Load Extract" querySpecification: specification: "archived.eq 'false'" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.position.NonContractCompensation" properties: ! - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "code" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 1 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: "" columnTitle: "Type" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "type" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 2 permission: null - ! description: "Pos #" type: "java.lang.Integer" propertyName: "number" propertyPath: "position" entityName: "Position" sortOrder: 0 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: 3 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: true 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: 4 permission: null - ! description: "Last Name" type: "java.lang.String" propertyName: "lastName" 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: "" 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: 5 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: "" 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: 6 permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Description" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 7 permission: null - ! description: "Label" type: "java.lang.String" propertyName: "label" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Label" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "label" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 8 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: true 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: 9 permission: null - ! description: "Pay Plan" type: "org.ssdt_ohio.usps.model.constants.PayPlan" propertyName: "payPlan" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Pay Plan" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payPlan" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 10 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: "" columnTitle: "Pay Unit" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "payUnit" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 11 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: true format: null 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: 12 permission: null - ! description: "Retirement Hours" type: "java.math.BigDecimal" propertyName: "retirementHours" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Retirement Hours" alignment: "RIGHT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "retirementHours" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 13 permission: null - ! description: "Start Date" type: "java.util.Calendar" propertyName: "startDate" propertyPath: "calendarDate" 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: "calendarDate.startDate" dataSourcePath: path: ! [] currentPath: ! - "calendarDate" suppressRepeating: false columnOrder: 14 permission: null - ! description: "Stop Date" type: "java.util.Calendar" propertyName: "stopDate" propertyPath: "calendarDate" entityName: "DateRange" sortOrder: 0 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: "calendarDate.stopDate" dataSourcePath: path: ! [] currentPath: ! - "calendarDate" suppressRepeating: false columnOrder: 15 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: 16 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: 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: 17 permission: null - ! description: "Strs Advance" type: "java.lang.Boolean" propertyName: "strsAdvance" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Strs Advance" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 9 relativePropertyName: "strsAdvance" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 18 permission: null - ! description: "Supplemental Tax Option" type: "org.ssdt_ohio.usps.model.constants.SupplementalTaxOption" propertyName: "supplementalTaxOption" propertyPath: null entityName: "Compensation" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Supplemental Tax Option" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "supplementalTaxOption" dataSourcePath: path: ! [] currentPath: ! [] suppressRepeating: false columnOrder: 19 permission: null - ! description: "Code" type: "java.lang.String" propertyName: "code" propertyPath: "position.payGroup" entityName: "PayGroup" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: true format: null source: "FIELD" label: "" columnTitle: "Code" alignment: "LEFT" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "position.payGroup.code" dataSourcePath: path: ! [] currentPath: ! - "position" - "payGroup" suppressRepeating: false columnOrder: 20 permission: null