read this article https://community.servicenow.com/community?id=community_question&sys_id=2e4b4321db9cdbc01dcaf3231f961987

Recreated my database view with prefixes in lowercase and now I get visible data.  Had tried renaming in the original but no change.  Complete fresh recreate with lowercase and it's fine.  Go figure.

Still curious to try to fix my script but this got me what I needed.

Thanks,

Andrew