CDR Tickets

Unfortunately, this is not a release independent ticket, so I removed that sprint.

Here is the query answering your question of How are GPs selected?

        SELECT dt.name AS "Doc Type", cg.id   AS "CDR-ID",
               d.title AS "Title",    p.value AS "Status"
          FROM pub_proc_cg cg
          JOIN document d
            ON d.id  = cg.id
          JOIN doc_type dt
            ON dt.id = d.doc_type
          JOIN query_term_pub p
            ON d.id  = p.doc_id
         WHERE dt.name = 'Person'
           AND p.path = '/Person/ProfessionalInformation' +
                        '/GeneticsProfessionalDetails'    +
                        '/AdministrativeInformation/Directory/Include'
           AND p.value NOT IN ('Include')

Basically, a GP record for which the value for Directory/Include isn't Include will be listed on the report.

Thanks. That is the right way for identifying GPs that should be removed from Cancer.gov

This report is part of the weekly publishing. I'm adding this ticket to Hawking.

The following program has been modified on DEV:

• CheckHotfixRemove.py [hawking fa5aab7]

~oseipokuw, I ran the report from the command line and received the message:

No new documents found to be removed

If this is the expected output please mark this ticket as verified.

It appears that this report isn't being submitted anymore as part of the publishing job because organizations aren't being reported anymore.

Please go ahead and close this ticket.

Verified on PROD. Thanks!