as stated the confirmation number is just a random collection of letters that mean absolutely nothing.
I just checked a VS miles redemption for a forthcoming DL flight and the VS confirmation starts with a D and in the DL system a G
BA / AA flights I have done in the last year have started with K,P,M,Q,R,G,V and N !
If you want staff to enter something to ease reporting then why not the airport pairs so
ATLJFK
SEASFO etc
Or the client / project code.