# Report: CR INT8036 LOA details to Assembled RaaS

**Date:** 01/17/2023  
**Report Type:** Advanced  
**Data Source:** Workers by Organization  
**Data Source Type:** Standard  
**Primary Business Object:** Worker  
**Report Tags:** Integrations

## Data Source Description  
Accesses Worker as its primary business object and returns 1 row per worker. Only includes active workers who are:  
1) associated with the organizations selected,  
2) associated with the corresponding subordinate organizations if Include Subordinate Organizations is selected,  
3) the manager associated with each supervisory and subordinate organization if Include Managers and 1 or more supervisory organizations are selected.  
Prompts you for Include Managers, Include Subordinate Organizations, and Organizations to automatically filter the report results.

## Columns  
| Business Object | Field | Column Heading Override | XML Alias | Format | Options |  
| --- | --- | --- | --- | --- | --- |  
| Worker | Worker | Worker |  |  |  |  
| Worker | Workday ID | workdayID |  |  |  |  
| Worker | Email - Primary Work | primaryWorkEmail |  |  |  |  
| Worker | On Leave | On Leave |  |  |  |  
| Leave of Absence Requests | Effective Date | Effective Date |  |  |  |  
| Leave of Absence Requests | Last Day of Leave - Estimated | Last_Day_of_Leave_-Estimated |  |  |  |  
| Leave of Absence Requests | Last Day of Leave - Actual | Last_Day_of_Leave_-Actual |  |  |  |  
| Leave of Absence Requests | Leave or Time Off Request Status | Leave_or_Time_Off_REQUEST_Status |  |  |  |

### Group Column Headings  
| Business Object | Group Column Heading XML Alias |  
| --- | --- |  
| Leave of Absence Requests | Leave_of_Absence_Requests_group |

## Sort  
Specify how the results should be sorted:  
- Sort and Group Sort by first accessible column.

## Filter  
| Filter on Instances | Filter conditions for filtering on instances |  |  |  |  
| --- | --- | --- | --- | --- |  
| And/Or | ( | Field | Operator | Comparison Type | Comparison Value |  
| And | Terminated | equal to | Value specified in this filter |  |  
| And | Requests | Leave of Absence | is not empty |  |

### Filter on Aggregations  
Filter condition for filtering on aggregated values.

### Prompts  
Specify the prompt defaults that should be used

## Runtime Date Prompts  
| Effective Date | Use date and time at runtime |  
| --- | --- |  
| Entry Date | Use date and time at runtime | Yes |

## Output Options  
| Field | Prompt Qualifier | Label for Prompt | Label For Prompt XML Alias | Default Type | Default Value | Required | Do Not Prompt at Runtime | Do Not Include in Subtitle |  
| --- | --- | --- | --- | --- | --- | --- | --- | --- |  
| Organizations |  | Organizations | Specify default value | Head of Customer Support | Yes | Yes |  |  
| Include Managers |  | Include_Managers | Specify default value | Yes |  | Yes |  |  
| Include Subordinate Organizations |  | Include_Subordinate_Organizations | Specify default value | Yes |  | Yes |  |

## Gauge Options  
| Metered Value | Metered Value Label Override | Gauge Range |  
| --- | --- | --- |  
| Maximum Value | Automatically Scale | Yes | Fixed 0 |

## Sharing Options  
Share with specific authorized groups and users:  
• Report Owned by: Report Administrator ISU_INT8036_Time_Leave_details_Assembled_RaaS

## Advanced Options  
- Report Performance: Optimized for Performance.
- View Options: Freeze First Column, Enable Preferred Currency, Enable Save Parameters.
- Web Services Options: Enable As Web Service, Web Service API Version v39.0.

### Temporary Report  
- Temporary Report Date Report Definition will be Deleted.