The GHR PaymentOutput.xml file is created using a number of document templates - a separate one for each section of the file. We are looking to provide, for the current payment, the Absence balances by Absence plan (ex. PTO)
- at the beginning of the pay cycle
- hours earned for that cycle
- hours taken for that cycle
- final balance.
The absence section of the PaymentOutput file pulls data from the PaymentDetailAbsence business class which I assume is updated when the Print Payments action runs. Although there are a lot of fields in the PaymentDetailAbsence record, I can only find valid values for current period earned, and current (ie. final) balance. I cannot find balance at the start of the pay period or hours used/taken in the pay period.
Q1: How can we get the Beginning balance and Taken for the pay period captured in the PaymentDetailAbsence record?
Q2: If that is not possible, what's the best way to find these values outside of the PaymentDetailAbsence record at the time the PaymentDetailAbsence record is created?
