Objective

Diagnose the live PTO request record shown by Sam: blank Ending Date/Time, Current Year Delta meaning, and whether PTO approval permissions are limited to Sam, Jenni, and Janelle.

Live findings

• Record checked: a4RUV000004KMV72AO, Jennifer H 2026-04-29 14:30:00Z Partial Day.
• Ending_Date_Time__c is null.
• Underlying component fields are populated: Ending_Date__c = 2026-04-29 and Ending_Time__c = 16:30:00.000Z, which is 12:30 PM ET on April 29, 2026.
• Length_Minutes__c is null because its formula switches to Ending_Date_Time__c when Beginning_Date_Time__c exists.
• Many recent partial-day records have the same null Ending_Date_Time__c pattern.
• Active New_Time_Off_Request v42 creates Beginning_Date_Time__c, Beginning_Date__c, Beginning_Time__c, Ending_Date__c, and Ending_Time__c, but does not assign Ending_Date_Time__c.
• Local metadata contains a later New_Time_Off_Request file that assigns Ending_Date_Time__c, but the live active flow is still v42 and does not have that assignment.

Current Year Delta

Formula verified from live object metadata:

IF(AND(Current_Year_Request__c=TRUE,TEXT(Status__c)="Approved"), Required_PTO__c*(-1), IF(AND(Current_Year_Request__c=TRUE,OR(TEXT(Status__c)="Accrual",TEXT(Status__c)="Bonus Time")), Required_PTO__c, 0))

Meaning:

• Pending requests show 0.
• Approved PTO subtracts the PTO amount, for example 0.25 becomes -0.25.
• Accrual or Bonus Time adds the PTO amount.
• Anything outside the current-year formula condition returns 0.

Related issue: Current_Year_Request__c is hardcoded to YEAR(Beginning_Date__c) = 2026, so it will need annual maintenance or a dynamic formula.

Approval model