Does an Relative Record number ever change

All,

We are using an audit tool that pulls from our journal and then outputs to a file. Usually we are good to go, but this time I see that we don't have this file keyed in a way that we can easily tie out to it.
We can build a view use the RRN as that is captured in the file and tying out to the RRN in the primary file and capture a key field(s), but the question came up as to would the RRN in the primary file ever change if we did a Reorg on the file or if the file is set up to reuse deleted records?

Thanks,
Ken M.





Ken Meade | Director of Information Technology


[ mailto:kmeade@xxxxxxxxxxxxxxxxx | kmeade@xxxxxxxxxxxxxxxxx ] | (603) 444-3570





Littleton Coin Company, Inc.


1309 Mt Eustis Rd, Littleton NH 03561


[ http://www.littletoncoin.com/ | www.littletoncoin.com ]