The BDAccessControlTrx contains a lot of information and can be somewhat convoluted to understand. This page will explain more about the BDAccessControlTrx Table.
Some notes:
1) Every scan that occurs in the access control system is recorded in this table. Valid or not, the card existing or not, every scan gets recorded.
2) The 'Location' column actually refers to the 'instance' name of program running that is doing the scanning.
3) The 'Loc' column is actually a reference to a macola location.
When scanned:
When a card is scanned the following information is recorded:
AccessID - This is the parsed out value the system determined for the scanning card.
Location - This is the instance name of the piece of software that scanned the card.
ValidityCode - This is the result of this particular scan
0=OK
1=DuplicatePass 'For Season Passses
2=Duplicate 'For one time pass
3=Expired
4=Invalid
5=[Static]
6=OneUseUsedAlready
7=InvalidDayoftheWeek
8=InvalidTime
9=InvalidDateRange
10=InvalidLocation' macola location
11=NoTicketTypeFound
12=OfflineInvalid
13=ReturnedTicket
14=CanceledCard
15=IsLotteryCard
Codes for 100 and above are for revreg attempts
100=Sold
101=Scanned
102=SoldInMacolaAfterScanned
103=SaleFailedOnScan
Loc - This is a macola location, this comes from the settings of the software that scanned the card
Message - On a scan, this is the raw number that was scanned from the card.
ScannerUserID - This is the ID (bdusers table) of the person logged into the software that scanned the card.
RevenueRecognized - Has the revenue for this been recognized or not.
Situations:
* The Loc is blank, but revenuerecognition is 1 (meaning the revenue has been recognized).
No problems with this. No location was required by the accesscontrol, and the scanning macola location was left blank, so a blank gets recorded here.
When the revreg process ran, if the Loc (macola location) was blank, it attempts to use the Location (instance name) column as a macola location.
* The message says 'revenue recorded successfully', but the revenuerecognition column says 0.
Yes. This is normal. This is just a trx entry saying that revenue was recognized. The row itself is not revenue. The accessid shows what card the row is talking about that was recognized.