Hi Avinash,
At AMRIT database level we identified Czcallduration is null cases, and also whenever we caluclated the callduration from calltime and callendtime we are getting some difference in callduration.

For your reference please find the below query and screenshot for callduration.
Query:
select BenCallID,BeneficiaryRegID,CreatedDate,CreatedBy,CallTypeID,CallTime,CallEndTime,CZcallStartTime,
CZcallEndTime,CZcallDuration,timestampdiff(second,calltime,callendtime) Call_duration_DB from t_bencall
where createddate>= '2024-09-01'and BeneficiaryRegID is not null and CallTypeID is not null order by CreatedDate desc;