PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Exporting a query with Excel formmating applied

We have a vacation bolt on module with its own custom tables. I've created a query with two unions that:

1) Parent: If applicable, returns any vacation days entered per employee

2) Union 1: If vacation time has been entered, then summarizes the total vacation time allowed for the year by employee

3) Union 2: If no vacation days are entered, then it does the same as union 1. This is because the join drops people on union 1 if there are no days in the 'vacation entered' table, so this is a duplicate to capture those people who are dropped

So the query works, extracts what I want, and displays everything I want ... but it's kind of busy. I've attached a picture with fake names to this message, but keep in mind some managers might end up with 250+ rows and 40+ employees on their file.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center