We are currently working on the forum. For the short-term, all forum content will be in read-only format. We apologize for the interruption and look forward to collaborating with you shortly. All the best in your research!

discrepancy notes download in 3.1

Hi all,
When trying out the new discrepany notes download feature in 3.1, I noticed that for each discrepancy note, there are two notes generated for the download.
Please see attachments for yourself.
Is there a reason for this? Can anyone explain this?

Thanks,
Michael Shi
notes1.png
notes2.png
dnotes0_site1.csv
Study Subject ID,Subject Status,Study/Site OID,Thread ID,Note ID,Parent Note ID,Date Created,Date Update,Days Open,Days Since Updated,Discrepancy Type,Resolution Status,Event Name,CRF Name,CRF Status,Entity name,Entity value,Description,Detailed Notes,Assigned User,Study Id
001-001-003,available,S_TEST1,1,3,,22-Jun-2011,22-Jun-2011,0,,Query,New,SE_1,Test show hide CRF,Complete,med_pill_cnt,,pill counts,please fill out the pill counts,testuser,3
001-001-003,available,S_TEST1,1,4,3,22-Jun-2011,22-Jun-2011,,,Query,New,SE_1,Test show hide CRF,Complete,med_pill_cnt,,pill counts,please fill out the pill counts,testuser,3
Attachments:
notes1.png 37.8 KB
notes2.png 14.3 KB
dnotes0_site1.csv 623 bytes

Comments

  • agoodwinagoodwin Posts: 131 admin
    Hi Michael,

    This is expected functionality.

    Initially when a discrepancy note is logged, 2 records get stored in the database: A parent record and a child. Each subsequent response/update when a note is added to the thread will add one additional child note to the record. The parent record will always reflect the most recent status.

    Example:
    Action: A new failed validation check gets entered in OpenClinica.
    Result: 1 Parent note (status = “new”), 1 Child note (status=”new”) are saved in the database.
    Action: User opens the discrepancy and “adds a note to thread” with a status of updated.
    Result: 1 Parent note (status=”updated”), 1 Child note (status=”new”), 1 Child note (status=”updated”) are saved in the database.

    When you download this to excel, you should see a column for Note ID and Parent Note. This allows you to retain the whole thread for the life of the discrepancy.

    I hope this helps.

    Best regards,
    Alicia
    Sent: Thursday, June 23, 2011 9:17 AM
    To: [email protected]
    Subject: [Users] discrepancy notes download in 3.1

    Hi all,
    When trying out the new discrepany notes download feature in 3.1, I noticed that for each discrepancy note, there are two notes generated for the download.
    Please see attachments for yourself.

    Is there a reason for this? Can anyone explain this?

    Thanks,
    Michael Shi
  • cmicrcmicr Posts: 13
    Hi Alicia,
    Thanks for the clarifications. It makes sense now.
    Michael.
    On Thu, Jun 23, 2011 at 4:29 PM, Alicia Goodwin wrote:
    Hi Michael,

    This is expected functionality.

    Initially when a discrepancy note is logged, 2 records get stored in the database: A parent record and a child. Each subsequent response/update when a note is added to the thread will add one additional child note to the record. The parent record will always reflect the most recent status.

    Example:
    Action: A new failed validation check gets entered in OpenClinica.
    Result: 1 Parent note (status = “new”), 1 Child note (status=”new”) are saved in the database.
    Action: User opens the discrepancy and “adds a note to thread” with a status of updated.
    Result: 1 Parent note (status=”updated”), 1 Child note (status=”new”), 1 Child note (status=”updated”) are saved in the database.

    When you download this to excel, you should see a column for Note ID and Parent Note. This allows you to retain the whole thread for the life of the discrepancy.

    I hope this helps.

    Best regards,
    Alicia
    Sent: Thursday, June 23, 2011 9:17 AM
    To: [email protected]
    Subject: [Users] discrepancy notes download in 3.1

    Hi all,
    When trying out the new discrepany notes download feature in 3.1, I noticed that for each discrepancy note, there are two notes generated for the download.
    Please see attachments for yourself.

    Is there a reason for this? Can anyone explain this?

    Thanks,
    Michael Shi
This discussion has been closed.