--- reportDefinition: ! description: "FuturePayAmount Report" tags: "" predefined: false parameters: ! pageSize: "LETTER" pageOrientation: "LANDSCAPE" outputFormat: "PDF" templateName: "Future Pay Report with Accounts & Description" suppressDetail: false showOptions: false sortProperties: ! - ! propertyName: "reportEmployee" label: "Employee" ascending: true controlBreak: true pageBreak: false queryParameters: ! {} title: "Future Pay Report with Accounts & Description" querySpecification: specification: "payrollFilter.eq 'false'\neffectiveDate.between param(\"beginningEffectiveDate\"\ ),param(\"endingEffectiveDate\")\ncompensation.position.payGroup.code.oneOf\ \ ([param(\"payGroups\",'',\"Enter Pay Group(s) (Separate multiples with commas)\"\ )])\ndescription.contains param(\"futurePayDescription\",\"\",\"Description\ \ Contains?\")" querySpecParameters: ! [] entity: "org.ssdt_ohio.usps.model.payroll.FuturePayAmount" properties: ! - ! description: "Employee" type: "java.lang.String" propertyName: "reportEmployee" propertyPath: null entityName: "FuturePayAmount" sortOrder: 1 controlBreak: true suppressed: true pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "reportEmployee" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 1 suppressRepeating: false permission: null - ! description: "Position Number" type: "java.lang.Integer" propertyName: "number" propertyPath: "compensation.position" entityName: "Position" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "NONE" source: "FIELD" label: null columnTitle: null alignment: "CENTER" controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 7 relativePropertyName: "compensation.position.number" dataSourcePath: path: ! [] currentPath: ! - "compensation" - "position" columnOrder: 2 suppressRepeating: false permission: null - ! description: "Pay Type" type: "java.lang.String" propertyName: "reportablePayType" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "reportablePayType" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 3 suppressRepeating: false permission: null - ! description: "Units" type: "java.math.BigDecimal" propertyName: "units" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "DEFAULT" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 6 relativePropertyName: "units" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 4 suppressRepeating: false permission: null - ! description: "Rate" type: "java.math.BigDecimal" propertyName: "rate" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "rate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 5 suppressRepeating: false permission: null - ! description: "Gross" type: "java.math.BigDecimal" propertyName: "gross" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: "Sum" baseClassProperty: false format: "CURRENCY" source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "gross" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 6 suppressRepeating: false permission: null - ! description: "Description" type: "java.lang.String" propertyName: "description" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 0 relativePropertyName: "description" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 7 suppressRepeating: false permission: null - ! description: "Applies For Retirement" type: "java.lang.Boolean" propertyName: "appliesForRetirement" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "appliesForRetirement" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 8 suppressRepeating: false permission: null - ! description: "Retire Hours" type: "java.math.BigDecimal" propertyName: "retireHours" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 5 relativePropertyName: "retireHours" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 9 suppressRepeating: false permission: null - ! description: "Effective Date" type: "java.util.Calendar" propertyName: "effectiveDate" propertyPath: null entityName: "FuturePayAmount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: "CALENDAR" source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 10 relativePropertyName: "effectiveDate" dataSourcePath: path: ! [] currentPath: ! [] columnOrder: 10 suppressRepeating: false permission: null - ! description: "Fnd Func Obj SCC Subj OPU IL Job" type: "java.lang.String" propertyName: "reportAccountCode" propertyPath: "specificPayAccount.expenditureAccount" entityName: "ExpenditureAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "METHOD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 33 relativePropertyName: "expenditureAccount.reportAccountCode" dataSourcePath: path: ! - "specificPayAccount" currentPath: ! - "expenditureAccount" columnOrder: 11 suppressRepeating: false permission: null - ! description: "Employer Distribution" type: "java.lang.Boolean" propertyName: "employerDistribution" propertyPath: "specificPayAccount" entityName: "SpecificPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 15 relativePropertyName: "employerDistribution" dataSourcePath: path: ! - "specificPayAccount" currentPath: ! [] columnOrder: 12 suppressRepeating: false permission: null - ! description: "Leave Projection" type: "java.lang.Boolean" propertyName: "leaveProjection" propertyPath: "specificPayAccount" entityName: "SpecificPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 12 relativePropertyName: "leaveProjection" dataSourcePath: path: ! - "specificPayAccount" currentPath: ! [] columnOrder: 13 suppressRepeating: false permission: null - ! description: "Amount Charged" type: "java.math.BigDecimal" propertyName: "amountCharged" propertyPath: "specificPayAccount" entityName: "SpecificPayAccount" sortOrder: 0 controlBreak: false suppressed: false pageBreak: false ascending: true function: null baseClassProperty: false format: null source: "FIELD" label: null columnTitle: null alignment: null controlHeaderOnly: false controlFooterOnly: false detailHeaderOnly: false width: 8 relativePropertyName: "amountCharged" dataSourcePath: path: ! - "specificPayAccount" currentPath: ! [] columnOrder: 14 suppressRepeating: false permission: null