Getting Absence Reason in BIP

Summary:

I need to get the absence reason for a large number of absence in a BIP report. However, when trying to link the Absence Entry Reason ID to the Reason ID using "ANC_PER_ABS_ENTRIES.ABSENCE_TYPE_REASON_ID = ANC_ABSENCE_REASON_F.ABSENCE_REASON_ID", the report does not return any data.

Am I using the wrong attribute and is there any other way to get the Absence Reason value data in BIP?