TImesheet Note Discrepancies

Products

• Clarity PPM SaaS

Issue/Introduction

Notes are getting associated with different timesheets from different time periods.

Using the following query:
select pruid, prid, prrecordid, prcreatedtime, prmodtime, prvalue, prnotedate created_by, updated_by
from prnote
where prtablename = 'prtimesheet' and not exists (select prid from prtimesheet where prid = prrecordid)

It appears timesheet notes are getting created against different timesheets.

 

 

Environment

Release : 15.9.1

Component : CA PPM SAAS TIME MANAGEMENT

Resolution

Run the following query to review the notes:

select * from prnote
where prtablename in ('PRTimeSheet', 'PRTimeEntry')
and prrecordid in (timesheet_id_list)
order by prcreatedtime desc



Review the following fields to investigate how the issue came to be:

PRUID - the origin of the timesheet
PRRecordid - the timesheet id
PRCreatedtime - the time the note was created
PRModtime - the time the note was edited