12-27-2021 02:08 PM
Does anyone have the bitwise values to know what all is configured on each of the segment sections? I am putting together a dashboard to help in some configuration things so that other teams can just refer to the dashboard and know what HL7 stuff we need and what we don't. So I am hoping to get some details regarding the flags column so I can translate it to what all of the settings that are turned on for that specific segment.
Thanks.
12-28-2021 07:24 AM
Here's what I have for OnBase 18 (16 really, but it still works in 18):
CASE WHEN (flags & 0x00000001) = 1THEN 'Yes' ELSE 'No' END AS 'Date (1)',CASE WHEN (flags & 0x00000002) = 2THEN 'Yes' ELSE 'No' END AS 'Time (2)',CASE WHEN (flags & 0x00000040) = 64THEN 'Yes' ELSE 'No' END AS 'Required (64)',CASE WHEN (flags & 0x00000080) = 128THEN 'Yes' ELSE 'No' END AS 'Filter (128)',CASE WHEN (flags & 0x00000100) = 256THEN 'Yes' ELSE 'No' END AS 'Repeatable (256)',CASE WHEN (flags & 0x00010000) = 65536THEN 'Yes' ELSE 'No' END AS 'MergeMPI (65536)',CASE WHEN (flags & 0x00020000) = 131072THEN 'Yes' ELSE 'No' END AS 'MergeMRN (131072)',CASE WHEN (flags & 0x00030000) = 196608THEN 'Yes' ELSE 'No' END AS 'MergeAcc (196608)',CASE WHEN (flags & 0x00040000) = 262144THEN 'Yes' ELSE 'No' END AS 'MergeVisit (262144)'
12-28-2021 07:24 AM
Here's what I have for OnBase 18 (16 really, but it still works in 18):
CASE WHEN (flags & 0x00000001) = 1THEN 'Yes' ELSE 'No' END AS 'Date (1)',CASE WHEN (flags & 0x00000002) = 2THEN 'Yes' ELSE 'No' END AS 'Time (2)',CASE WHEN (flags & 0x00000040) = 64THEN 'Yes' ELSE 'No' END AS 'Required (64)',CASE WHEN (flags & 0x00000080) = 128THEN 'Yes' ELSE 'No' END AS 'Filter (128)',CASE WHEN (flags & 0x00000100) = 256THEN 'Yes' ELSE 'No' END AS 'Repeatable (256)',CASE WHEN (flags & 0x00010000) = 65536THEN 'Yes' ELSE 'No' END AS 'MergeMPI (65536)',CASE WHEN (flags & 0x00020000) = 131072THEN 'Yes' ELSE 'No' END AS 'MergeMRN (131072)',CASE WHEN (flags & 0x00030000) = 196608THEN 'Yes' ELSE 'No' END AS 'MergeAcc (196608)',CASE WHEN (flags & 0x00040000) = 262144THEN 'Yes' ELSE 'No' END AS 'MergeVisit (262144)'
12-28-2021 08:02 AM
Thanks
12-28-2021 08:47 AM
Play around with this first - mess with some of those settings and then try the query again.
1. Optional isn't a flag - required is a flag. If it's not required, then it's optional.
2. General isn't a Data Type in the database. If it's flagged as Date, it's a Date. If it's flagged as Time, then it's Time. If it's flagged as both Date and Time, then the Data Type is TimeStamp. If it's flagged as neither Date nor Time, it's General.
3. Looks like the translation table settings are in the 400000 range, maybe 100000, 200000, 400000? But you can figure this out yourself by checking a box and rerunning the query.
12-28-2021 09:49 AM
Good points there Steven. I guess I didn't think about the fact of there might not be a bitwise calculation for some values. I will make a note of that.
Regarding your #3, I will have to test that out and see what happens. 🙂
Find what you came for
We want to make your experience in Hyland Connect as valuable as possible, so we put together some helpful links.