MPL Reporting - LTOs Falling Off in June FIX

Modified on Tue, 5 Aug at 1:01 PM

MPL Reporting Best Practice for LTO in June

GOAL: To provide a wholistic overview of the best practice to maintain in June when reporting MPL Files to OTIP to ensure that LTO’s remain on the MPL File for the duration and up to their End Date. 

Root Cause: Stored Procedure script NonTerminatedMemberData there is a condition which checks the AsOfDate, if it is between the Position Start and End Date. 

Since the Occasional Positions typically end at the End of June – the record is left out as the AsOfDate during June, is generating to the equivalent day in July. 

 

FIX: For the month of June only, users can simply update the auto-generated AsOfDate to be the last working day of the school year in June (in this example; 2025/06/27). 

Configuring the AsOfDate as last working day in June, will allow the LTOs to pull into MPL for the duration of June – as expected. 

IMPORTANT NOTE: For the rest of the year, AsOfDate does not need to be updated, it can simply auto-generate and be left as is. 

 

PROCESS OVERVIEW

STAFFING > POSITION & ASSIGNMENT > SAMPLE EID

A screenshot of a computer

AI-generated content may be incorrect.

**Occasional Position End Dated = 2025/06/27 with Benefit Plan = OTIP**

 

COMPENSATION > SALARY & ALLOWANCE > SAMPLE EID

A screenshot of a computer

AI-generated content may be incorrect.

**Matches the Position configuration**

 

BENEFITS > GENERATE HRIS FILE > OTIP > TEST

A screenshot of a computer

AI-generated content may be incorrect.

**Note automatic generation of As of Date for July (since current Date = June)**

 

Update As of Date to Last LTO Day of the Year

A screenshot of a computer

AI-generated content may be incorrect.

**Updated > Submitted** 

 

PROCESS > COMPLETED > MEMBER FILE

A screenshot of a computer

AI-generated content may be incorrect.

**Member is Work Status = Active**

 

PROCESS > COMPLETED > POSITION FILE

**Member has Position Records with End Date populating as expected**

 

 

 

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article