Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Understanding Actual Termination Date and Per_Periods_Of_Service — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Understanding Actual Termination Date and Per_Periods_Of_Service

Accepted answer
24
Views
4
Comments

Summary:

Looking for SQL to pull in an accurate termination date given a point in time. And if that point in time is BEFORE the termination, then the business is wanting a blank value for that cell.

Content (required):

The business is asking for a report which outlines a point in time snapshot of the company's employees. So basically, "given a date, show me all the stats on that employee as of that date." One column in the report is the "Actual Termination Date" in the per_periods_of_service table. The behavior I'm noticing in this table is that when a person is termed, it doesn't look like a new row gets inserted into the per_periods_of_service table, into which this termination date gets recorded, leaving the old row with a blank term date. Instead,

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!