CLIENTS: Talcum Powder FIX BRCA Testing to Point to Negative / Positive

[jesusitd]

Start with:

• BAY Advocacy
• BAY Paralegal
• ~~AWKO - Updating, Talc Years Q column was old! ~~
• Other Active Talcum Powder Clients (Dugan is broken. See #579 ) (Sullivan)

Cancer Disqualified Cards are COUNTING VER DQ :@ -> Actually not. It's confusing Bookmarks what's causing the issue. BRCA 1-2 Negative? Age of Diagnosis for Inventory Cases, 20+ as long as IP is living Docusign Sender of NON-CAUGHT CASES?????????????????? Family Cancer Diagnosis for Borderline Mucinous Tumors

WHAT NEEDS TO BE SEEN WITH THE BOOKMARKS???? WHAT WOULD MAKE SENSE???? NEED TO DEFINE

[jesusitd]

Age at diagnosis Fixed with new formula that gets both conditions

• Injured Party must have been 25-75 years old at diagnosis.
• Note: Inventory ages 20-24 & 76+ as long as injured party is living

  Talc P3 Age at Diagnosis =
  IF(
  ( 'Cases'[Talcum Cancer 1 Age of Diagnosis] >= 25
      && 'Cases'[Talcum Cancer 1 Age of Diagnosis] <= 75 )
      || ( 'Cases'[Talcum Cancer 1 Age of Diagnosis] >= 20
      && 'Cases'[Talc Injured Party Deceased] <> "Yes" ),
  "Meets Criteria",
  "Does Not Meet Criteria"
  )

BRCA Positive -> Uses new column, must refresh

Talc P1 Ovarian Group = 
...
  43                  && 'Cases'[Talc BRCA Results] <> "Positive"
  50                  && 'Cases'[Talc BRCA Results] <> "Positive"
...

Family History of Cancer

Talc P1 Ovarian Group = 
...
  44                  && NOT( CONTAINSSTRING( 'Cases'[Talc Family Cancer Diagnosis], "Borderline" ) )
  51                  && NOT( CONTAINSSTRING( 'Cases'[Talc Family Cancer Diagnosis], "Borderline" ) )
...

Usage Years Qualifying 1982 The rule is not correctly set up for this condition: • 1982-Present / Note: Hybrid Usage / If Injured Party had the majority of Talc usage prior to 1982 and a minimum of 1 year after, including usage during 1982 this is acceptable.

• The must accept EVEN if it was discontinued in 1982. Currently it is not accepting it. See case: https://crm.intakedesk.com/SuiteCRM/index.php?module=Cases&action=DetailView&record=d15ccf29-61b4-eb08-cd5e-5f25bc9f11af (Bay Advocacy Report, Talcum Powder - Amison)

  Talc P6 Usage Frequency = 
  IF(
  ( 'Cases'[Talc Usage Years Qualifying] >= 1
      && 'Cases'[talc_usage_years] >= 4 )
      || COALESCE(
          'Cases'[Talc Usage Applications Before Tubal Ligation],
          'Cases'[Talc Usage Total Applications]
      ) >= 1500,
  "Meets Criteria",
  "Does Not Meet Criteria"
  )

[jesusitd]

DONE.

Monitoring for 14 days. Close after 8/17/20.