I have the following query.
For this ID, i have PHYSICAL_ABUSE_SW = 'Y' and DRUGEXPOSED_NEWBORN_SW = 'Y'
But from my select, i get only "Physical Abuse"..
I'm expecting "Neglect" to be picked as a second row, but it's not picking.
Can someone kindly help?
(SUSPICIOUS_DEATH_SW ='Y' OR
NON_ACCIDENTAL_SW = 'Y' OR
INJURY_INCONSISTENT_SW = 'Y' OR
INJURY_SUSPICIOUS_SW = 'Y' OR
CHILD_TOXIC_CHEMICALS_SW = 'Y' OR
CAREGIVER_ACTION_SW = 'Y' OR
PHYSICAL_ABUSE_SW = 'Y'
THEN 'Physical Abuse'
When (SEXUAL_MOLESTATION_SW ='Y' OR
SEXUAL_ACT_SIBLINGS_SW ='Y' OR
SEXUAL_EXPLOIT_CAREGIVER_SW ='Y' OR
SEXUAL_PHY_BEH_SUS_ABUSE_SW ='Y' OR
SEXUAL_ABUSE_SW = 'Y'
THEN 'Sexual Abuse'
When ( DEATH_NEGLECT_SW ='Y' OR
NON_ORGANIC_FAILURE_SW = 'Y' OR
MALNUTRITION_SW = 'Y' OR
UNSAFE_HOME_SW = 'Y' OR
INADEQUATE_CLOTHING_SW = 'Y' OR
INADEQUATE_SUPERVISION_SW = 'Y' OR
DISCHARGED_FACILITY_SW = 'Y' OR
CAREGIVER_INTERVENE_SW = 'Y' OR
MAL_NEG_CHILD_ABANDONED_SW = 'Y' OR
CHILD_DISABLED_SW = 'Y' OR
CHILD_LEFTALONE_SW = 'Y' OR
CHILD_LEFTALONE_LONG_SW = 'Y' OR
PRIORDEATH_CHILD_SW = 'Y' OR
DRUGEXPOSED_NEWBORN_SW = 'Y' OR
SEXUAL_PERPETRATOR_SW = 'Y' OR
CAREGIVER_IMPAIRMENT_SW = 'Y' OR
UNREASONABLE_DELAY_SW = 'Y' OR
NEGLECT_SW = 'Y' OR
NEGLECT_SD_SW = 'Y'
When (CHILD_IMPAIRMENT_FAILURE_SW = 'Y' OR
Then 'Mental Injury - Neglect'
When (CHILD_IMPAIRMENT_SW = 'Y' OR
Then 'Mental Injury - Abuse'
where screening_id = 9000