database h_source_id consistency in database

[Jeremy]

We have noticed that when looking up request in the database there are some that have usernames in the h_source_id field and then there are some that have numbers (like below) why is there differences...should these not all display the username?

This number doesn't seem to initially relate to anything in the loggers account details.

[Guest Mary]

@Jeremy

The h_source_id stores Analyst User ID, Email Message id , Guest Portal username, Co-worker User ID as documented in https://wiki.hornbill.com/index.php/Table_Info:_Main_Request_Table

The example in your screenshot was raised from an email, hence the message ID.