fetching event registration status from the database

Hi,
I am working on a custom script that needs to fetch the event registration status from our Joomla database.
But currently we couldn't find where the status is saved in the  database after the registrant has cancelled his/her event. We've looked at the "_eb_registrants" table in the database. The "payment_status" doesn't show the cancellation change status after the member has cancelled the event registration. 
Can you let me know where to look?

Hello

The data is stored in published field:

- 0: Pending
- 1: Paid
- 2: Cancelled

Hope it helps

Regards,

Tuan

Hi Tuan,

I have a script that needs to identify folks on the waiting list. Is the "published" field in eb_registrants set to 3 for people on the waiting list? Or is there a better way to identify someone on the waiting list?

Thanks, Alan

Hi Alan

Checked for published = 3 in #__eb_registrants table is the only option

Regards,

Tuan