Bitwise values for hsi.hl7segmentfield flags column

[Ryan_Wakefield]

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.

[Steven_Thorders · Accepted solution]

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)'

[Ryan_Wakefield]

Thanks @Steven Thorderson , these are definitely helpful. I just need to figure out the rest of the items like translation table (receiving, sending, filtering), Optional, Data Type (General vs. Date vs. Time vs. TimeStamp), and others. So hopefully we can get someone from Hyland to chime in on this as well.

[Steven_Thorders]

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.

[Ryan_Wakefield]

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. 🙂