Need SQL in BI to get the Tobacco Use details of a participant/dependent
SummaryI am trying to get the tobacco use details of a participant/dependent by writing a BI Query
I was trying to get the tobacco use details of a participan/dependent from BIP sql.
I see the Tobacco use being stored in Table: BEN_ELIG_TBCO_USE_PRTE - Column : USES_TBCO_FLAG but I am unable to connect it to the person(participant/Dependent)
I can see the same from UI by the navigation : Home > Benefits Admin > Enrollments > Search Person > Click to view the Benefits Summary > On the left panel click on Person Info > Under Person Info : Tobacco Use