Thursday - Day 11
Accomplished:
set up dual monitors
finished code for free fall customer id compilation
unique customer id count has decreased...may be due to month purge of underlying base table (unique customer bridge table)
started exploring attribute tables (booking, purchases)
Notes:
PDL Tools usage
@delimiter is needed in order to run the sugarlib function from DBVisualizer. See http://confluence.dbvis.com/display/UG95/Executing+Complex+Statements#ExecutingComplexStatements-UsinganSQLBlock
added two more business units to scope of purchase order data (170, 172)
decided to filter booking data to
curent_status_ind = 1 and order_line_status=11 or 12 --> customer's booked and checkin part
curent_status_ind = 1 andorder_line_status= 4 --> customer's booked part
order_status_id values repesent status of booking or purchase ie. Booked, Cancelled, past visit, returned, etc
current_status_ind indicates if it is the current status of the order
for bookings, 4 = booked, 5 = cancelled, 11 = customer checked in to park, 12 = customer completed visit