View Pending Absences in COGNOS

dhamberger
Journeyman

View Pending Absences in COGNOS

We are looking for a way to use COGNOS to check our staff's time off balances. We have created a report and can see the leave type, beginning balances, days taken, and current balances.  BUT we cannot find a way to see thier pending balances- a balance that includes future requests that their supervisor has not approved yet.  Every report generated only shows balances on time that has been approved.  Does anyone know how to see pending time off requests from COGNOS?

2 Replies
MuskanS
Community Support Expert
Community Support Expert

Hi! @dhamberger,

 

Currently, there is not a way to use COGNOS to check staff's time off balances.  The report will only show balances on time that has been approved. 


Muskan Sehar

PowerSchool Community Moderator


Remember to give Kudos to suggestions that help you! If a suggestion solves your issue, please select Accept As Solution on the post so others can see the solution, too!
Community Moderator
pamols
PowerSchool Champion
PowerSchool Champion

Our districts are using 5.2 efinance Plus and using the workflow that came out with 5.2.   We set up our groups and roles with the same code so that we can have a unique identifier to link the group with the role..  We can then pull by approval group (role) to view all absences.  

 

following is our report by groups for leave for the next seven days.  

 

<report xmlns="http://developer.cognos.com/schemas/report/12.0/" useStyleVersion="10" expressionLocale="en">
<modelPath>/content/folder[@name='Packages']/package[@name='eFinancePLUS']/model[@name='model']</modelPath>
<drillBehavior modelBasedDrillThru="true"/>
<layouts>
<layout>
<reportPages>

<page name="Page1" refQuery="Query1">
<style>
<defaultStyles>
<defaultStyle refStyle="pg"/>
</defaultStyles>
</style>
<pageBody>
<style>
<defaultStyles>
<defaultStyle refStyle="pb"/>
</defaultStyles>
</style>
<contents><list showColumnTitles="hide" refQuery="Query2" name="List2">
<listColumns>
<listColumn>
<listColumnTitle>
<contents/>
</listColumnTitle>
<listColumnBody>
<contents><list horizontalPagination="true" name="List1" refQuery="Query2">



<noDataHandler>
<contents>
<block>
<contents>
<textItem>
<dataSource>
<staticValue>No Data Available</staticValue>
</dataSource>
<style>
<CSS value="padding:10px 18px;"/>
</style>
</textItem>
</contents>
</block>
</contents>
</noDataHandler>
<style>
<CSS value="border-collapse:collapse"/>
<defaultStyles>
<defaultStyle refStyle="ls"/>
</defaultStyles>
</style>
<listColumns><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="group_id"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><CSS value="width:1in"/></style><contents><textItem><dataSource><dataItemValue refDataItem="group_id"/></dataSource></textItem></contents><listColumnRowSpan refDataItem="group_id"/></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="Empl No"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="Empl No"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="L Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="L Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="F Name"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="F Name"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="field_value3"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles><dataFormat><stringFormat/></dataFormat></style><contents><textItem><dataSource><dataItemValue refDataItem="field_value3"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="field_value4"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="field_value4"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="status"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="status"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="field_value5"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="field_value5"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="field_value1"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="field_value1"/></dataSource></textItem></contents></listColumnBody></listColumn><listColumn><listColumnTitle><style><defaultStyles><defaultStyle refStyle="lt"/></defaultStyles></style><contents><textItem><dataSource><dataItemLabel refDataItem="field_value2"/></dataSource></textItem></contents></listColumnTitle><listColumnBody><style><defaultStyles><defaultStyle refStyle="lm"/></defaultStyles></style><contents><textItem><dataSource><dataItemValue refDataItem="field_value2"/></dataSource></textItem></contents></listColumnBody></listColumn></listColumns><listGroups><listGroup refDataItem="group_id"><sortList><sortItem refDataItem="field_value3" sortOrder="ascending"/></sortList></listGroup></listGroups></list></contents>
<style>
<defaultStyles>
<defaultStyle refStyle="sb"/>
</defaultStyles>
</style>
</listColumnBody>
</listColumn>
</listColumns>



<style>
<CSS value="border-collapse:collapse; width:100%"/>
<defaultStyles>
<defaultStyle refStyle="sc"/>
</defaultStyles>
</style>
<listGroups><listGroup refDataItem="Employee Loc. Building Name"><listHeader><listRows><listRow><rowCells><rowCell><contents><textItem><dataSource><dataItemLabel refDataItem="Employee Loc. Building Name"/></dataSource></textItem><textItem><dataSource><staticValue>: </staticValue></dataSource></textItem><textItem><dataSource><dataItemValue refDataItem="Employee Loc. Building Name"/></dataSource></textItem></contents><style><defaultStyles><defaultStyle refStyle="sh"/></defaultStyles></style></rowCell></rowCells></listRow></listRows></listHeader><XMLAttributes><XMLAttribute name="RS_SectionedEdge" value="columns" output="no"/></XMLAttributes></listGroup></listGroups><sectionsFrame refFrame="List1" sectionedEdge="columns"/></list></contents>
</pageBody>
</page></reportPages>
</layout>
</layouts>
<XMLAttributes><XMLAttribute name="RS_CreateExtendedDataItems" value="true" output="no"/><XMLAttribute name="listSeparator" value="," output="no"/><XMLAttribute name="RS_modelModificationTime" value="2020-07-06T21:04:01.093Z" output="no"/></XMLAttributes><queries><query name="Employee">
<source>
<model/>
</source>
<selection><dataItem name="Employee Number" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Employee Number]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Last Name" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Last Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Middle Name" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Middle Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="First Name" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[First Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Department" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Department]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Department Title" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Department Title]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Email Address" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Email Address]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Employee Location Code" aggregate="none" rollupAggregate="none"><expression>[Personnel Info].[Personnel Detail].[Employee Location Code]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Employee Loc. Building Name" aggregate="none" rollupAggregate="none"><expression>[Personnel Info].[Personnel Detail].[Employee Loc. Building Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
</query><query name="Attendance">
<source>
<model/>
</source>
<selection><dataItem name="Employee Number" aggregate="none" rollupAggregate="none"><expression>[HUMAN RESOURCES].[Employee Info].[Employee Number]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Pay Code" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Pay Code]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Pay Code Title - Attend" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Pay Code Title - Attend]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Start Date" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Start Date]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="4" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Stop Date" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Stop Date]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="4" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Leave Hours/Days" aggregate="total"><expression>[Attendance Info].[Leave Hours/Days]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="2" output="no"/><XMLAttribute name="RS_dataUsage" value="fact" output="no"/></XMLAttributes></dataItem><dataItem name="Remarks" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Remarks]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Check Date" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Check Date]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="4" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Status Flag" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Status Flag]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Leave Code" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Leave Code]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="Pay Run" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Pay Run]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem><dataItem name="Post Flag" aggregate="none" rollupAggregate="none"><expression>[Attendance Info].[Post Flag]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="attribute" output="no"/></XMLAttributes></dataItem></selection>
</query><query name="EAC Leave Request">
<source>
<model/>
</source>
<selection><dataItem name="Empl No" aggregate="none" rollupAggregate="none"><expression>[HUMAN_RESOURCE].[Employee].[Empl No]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="L Name" aggregate="none" rollupAggregate="none"><expression>[HUMAN_RESOURCE].[Employee].[L Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="F Name" aggregate="none" rollupAggregate="none"><expression>[HUMAN_RESOURCE].[Employee].[F Name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="identifier" output="no"/></XMLAttributes></dataItem><dataItem name="dataset_instance_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Code].[dataset_instance_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value" aggregate="none" rollupAggregate="none" label="Leave Bank"><expression>[ADMIN].[Dynamic Leave Code].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="status" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf User Defined Hdr for Lv Requests].[status]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value1" aggregate="none" rollupAggregate="none" label="Leave Units value"><expression>[ADMIN].[Dynamic Leave Units].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value2" aggregate="none" rollupAggregate="none" label="Comments"><expression>[ADMIN].[Dynamic Leave Comment].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value3" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Start Date].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value4" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave End Date].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="group_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[group_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="role_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[role_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="dataset_instance_id1" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[dataset_instance_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="screen_number" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[screen_number]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="list_sequence" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[list_sequence]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_number" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[field_number]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="field_value5" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[field_value]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="change_date_time" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[change_date_time]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="4" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="change_uid" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Type].[change_uid]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem></selection>
<detailFilters><detailFilter use="required" postAutoAggregation="false"><filterDefinition><filterStringCompare refDataItem="group_id" operator="like" not="true" caseInsensitive="yes"><filterValue>is null</filterValue></filterStringCompare></filterDefinition></detailFilter></detailFilters></query><query name="Roles">
<source>
<model/>
</source>
<selection><dataItem name="detail_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[detail_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="event_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[event_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="status" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[status]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="group_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[group_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="role_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[role_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="actor_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Wf Instance Event Details for Lv Requests].[actor_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="dataset_instance_id" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Dynamic Leave Code].[dataset_instance_id]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="empl_no" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Empl for Leave Request Approver].[empl_no]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="1" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="l_name" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Empl for Leave Request Approver].[l_name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="f_name" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Empl for Leave Request Approver].[f_name]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem><dataItem name="email_addr" aggregate="none" rollupAggregate="none"><expression>[ADMIN].[Empl for Leave Request Approver].[email_addr]</expression><XMLAttributes><XMLAttribute name="RS_dataType" value="3" output="no"/><XMLAttribute name="RS_dataUsage" value="unknown" output="no"/></XMLAttributes></dataItem></selection>
</query><query name="Query1">
<source>

<joinOperation>
<joinOperands>
<joinOperand cardinality="0:1"><queryRef refQuery="EAC Leave Request"/></joinOperand>
<joinOperand cardinality="0:1"><queryRef refQuery="Roles"/></joinOperand>
</joinOperands>
<joinFilter>
<filterExpression>[EAC Leave Request].[group_id] = [Roles].[group_id] and
[EAC Leave Request].[role_id] = [Roles].[role_id]</filterExpression>
</joinFilter>
</joinOperation></source>
<selection><dataItem name="Empl No"><expression>[EAC Leave Request].[Empl No]</expression></dataItem><dataItem name="L Name"><expression>[EAC Leave Request].[L Name]</expression></dataItem><dataItem name="F Name"><expression>[EAC Leave Request].[F Name]</expression></dataItem><dataItem name="dataset_instance_id"><expression>[EAC Leave Request].[dataset_instance_id]</expression></dataItem><dataItem name="field_value"><expression>[EAC Leave Request].[field_value]</expression></dataItem><dataItem name="status"><expression>[EAC Leave Request].[status]</expression></dataItem><dataItem name="field_value1"><expression>[EAC Leave Request].[field_value1]</expression></dataItem><dataItem name="field_value2"><expression>[EAC Leave Request].[field_value2]</expression></dataItem><dataItem name="field_value3"><expression>[EAC Leave Request].[field_value3]</expression></dataItem><dataItem name="field_value4"><expression>[EAC Leave Request].[field_value4]</expression></dataItem><dataItem name="group_id"><expression>[EAC Leave Request].[group_id]</expression></dataItem><dataItem name="empl_no"><expression>[Roles].[empl_no]</expression></dataItem><dataItem name="l_name"><expression>[Roles].[l_name]</expression></dataItem><dataItem name="f_name"><expression>[Roles].[f_name]</expression></dataItem><dataItem name="email_addr"><expression>[Roles].[email_addr]</expression></dataItem><dataItem name="field_value5"><expression>[EAC Leave Request].[field_value5]</expression></dataItem></selection>
<detailFilters><detailFilter use="required" postAutoAggregation="false"><filterExpression>[empl_no]is not null</filterExpression></detailFilter></detailFilters></query><query name="Query2">
<source>

<joinOperation>
<joinOperands>
<joinOperand cardinality="1:N"><queryRef refQuery="Query1"/></joinOperand>
<joinOperand cardinality="1:N"><queryRef refQuery="Employee"/></joinOperand>
</joinOperands>
<joinFilter>
<filterExpression>[Query1].[Empl No] = [Employee].[Employee Number]</filterExpression>
</joinFilter>
</joinOperation></source>
<selection><dataItem name="Empl No"><expression>[Query1].[Empl No]</expression></dataItem><dataItem name="L Name"><expression>[Query1].[L Name]</expression></dataItem><dataItem name="F Name"><expression>[Query1].[F Name]</expression></dataItem><dataItem name="dataset_instance_id"><expression>[Query1].[dataset_instance_id]</expression></dataItem><dataItem name="status"><expression>[Query1].[status]</expression></dataItem><dataItem name="field_value1" label="Leave Units "><expression>[Query1].[field_value1]</expression></dataItem><dataItem name="field_value2" label="Leave Comments"><expression>[Query1].[field_value2]</expression></dataItem><dataItem name="field_value3" label="Leave Start"><expression>[Query1].[field_value3]</expression></dataItem><dataItem name="field_value4" label="Leave End"><expression>[Query1].[field_value4]</expression></dataItem><dataItem name="group_id" label="Leave Group"><expression>[Query1].[group_id]</expression></dataItem><dataItem name="empl_no"><expression>[Query1].[empl_no]</expression></dataItem><dataItem name="l_name"><expression>[Query1].[l_name]</expression></dataItem><dataItem name="f_name"><expression>[Query1].[f_name]</expression></dataItem><dataItem name="email_addr"><expression>[Query1].[email_addr]</expression></dataItem><dataItem name="Employee Location Code"><expression>[Employee].[Employee Location Code]</expression></dataItem><dataItem name="Employee Loc. Building Name"><expression>[Employee].[Employee Loc. Building Name]</expression></dataItem><dataItem name="field_value5" label="Leave Reason"><expression>[Query1].[field_value5]</expression></dataItem></selection>
<detailFilters><detailFilter use="required" postAutoAggregation="false"><filterExpression>[field_value3] between current_date and current_date +7</filterExpression></detailFilter><detailFilter use="required" postAutoAggregation="false"><filterExpression>[Query1].[status] &lt;&gt;'Cancel'</filterExpression></detailFilter></detailFilters></query></queries><reportName>5.2 Employee Leave by location +7 days</reportName></report>