I'm unsure, its a 3rd party app and uses entity framework with all inline SQL so no procedures for me to look at.
I will pass this to the development team to see if they can track it down within the source code to see what else goes on around these statements
The referenceID links to PSX_PUBLICATION_DOC from what I know, but there is also a ReferenceID column in 3 other tables.
The PSX prefix from what I am told is the holding area for any new content, once its approved it moves into RX tables