I was able to retrieve a table containing all the queries in our production system from the begining of our implementation several years ago.
How is the field "STATUS" determined?? Is there a time frame that a query, EVEN if it is ACTIVE ( meaning Version = A) becomes "STATUS = INACTIVE"?
I do not get the logic in determining how "Status" is made "INA" or "ACT". Because we have several queries with VERSION "A", meaning they are the active version and have a STATUS of "INA". Can anyone shed any light on this for me?