How to determine if PayPal Subscription has ended to notify external Software?

Where can I determine in the database how and when a subscription is cancel by the member so I can notify a external software program?