CLIENTS Dataflow Error: Talc Deceased from Database is Yes -1 and No 1

intakedesk / PowerBI-General

Placeholder for issues migrated from Jira

1 stars 0 forks source link

CLIENTS Dataflow Error: Talc Deceased from Database is Yes -1 and No 1 #555

Closed jesusitd closed 4 years ago

jesusitd commented 4 years ago

Fixed:

CASE
        id_intake_talc.talc_injured_party_deceased
        WHEN -1 THEN 'Yes'
        WHEN 1 THEN 'No'
        WHEN 0 THEN 'No'
        ELSE NULL
    END AS 'Talc Injured Party Deceased',

jesusitd commented 4 years ago

Review with @fedegarza for Old Cases

jesusitd commented 4 years ago

Eduardo updated Cases for correct -Yes and 1=No relationships.

Validating.

jesusitd commented 4 years ago

Some evidence of correct Deceased / Deceased Date integrity:

DONE.