DB record has archive stored file path

To expand on what Wayne explained:

DECLARE @VaultName NVARCHAR(256)
SELECT  @VaultName = VaultName
FROM    dbo.SystemInfo ;
WITH    Docs ( DocumentID, Filename, HexID )
          AS ( SELECT   DocumentID
                      , Filename
                      , dbo.fnHexNumber(DocumentID, 8, 1) AS HexId
               FROM     Documents
             )
    SELECT  Docs.DocumentID
          , Docs.Filename
          , @VaultName + '\' + RIGHT(Docs.HexID, 1) + '\' + Docs.HexID AS ArchivePath
    FROM    Docs
    ORDER BY ArchivePath

dbo.fnHexNumber() is a function already in the vault databases. It converts an integer to hex.