Page Comparison

...

1. Connect to the database.

   • I connected to CADORSP.world as CADORS_DUI.
     

2. Obtain the CADORS_REQUEST_NUM(s) for the subscription with a query by the email address(es)
   Example:

   Code Block
   language sql
   select * from GA004_CADORS_REPORT_REQUEST where upper(EMAIL_ADDRESS_TXT) LIKE upper('etingey%@hotmail.com');

   • Verify that DATE_DEACTIVATED_DTE and DATE_DELETED_DTE are NULL.
     

3. Query the relevant table(s) with a query on the
   Example:
   

   Code Block
   select * from GA006_REGIONAL_SUBSCRIPTION where CADORS_REPORT_REQUEST_NUM IN ('A2K8G3Y7U6', 'P6N9L6W5D7');

   • Verify that DATE_DELETED_DTE is NULL.
     

Additional notes:
I tested subscribing using my TC email address. I also created a hotmail account.

• For my TC email address, the activation email and subscription emails were sent to my inbox.

• On the hotmail account, the activation email was sent directly to the junk folder.