AnsweredAssumed Answered

ca_contact table, Inactive column

Question asked by jlhawley on Jul 6, 2017
Latest reply on Jul 13, 2017 by TMACUL

I am trying to reference only Active accounts in Service Desk as a part of a project I am doing to create users via the web services. I am trying to leverage the "Inactive" column in the ca_contact table for some reporting. Going through the available objects see that the Contact Extended has Contact Extended Filters which reference this as "Contact Status". How do I make either that filter a regular object that I can use in the reporting and select only Active Users? I didn't see it in the schema designer despite it being in an existing table in MDB. From the data dictionary I see it references the boolean table but don't see it anywhere to add to the Universe in the Universe Design Tool. I was hesitant to create a new column knowing that it exists already. 

Outcomes