Absence Scheduled Duration

HI

We need to get the Scheduled Duration value for the absence , can you please let me know which column stores this value in the back end table? I tired in ANC_PER_ABS_ENTRY_DTLS table in which Duration column is there but not Scheduled Duration.

Basically we need to know if emp is absence during the entire day or partial day, for that we plan to compare both Scheduled Duration , Duration columns

Thanks