apply_oracle_lab10.txt - SQL> SQL> SQL> Step#1 Query records and insert into RENTAL table SQL> SQL> SQL> Step#1 Verify number of rows prior to insert

apply_oracle_lab10.txt - SQL> SQL> SQL> Step#1 Query...

This preview shows page 1 out of 566 pages.

You've reached the end of your free preview.

Want to read all 566 pages?

Unformatted text preview: SQL> SQL> -- ---------------------------------------------------------------------- SQL> -- Step #1 : Query records and insert into RENTAL table. SQL> -- ---------------------------------------------------------------------- SQL> -- ---------------------------------------------------------------------- SQL> -- Step #1 : Verify number of rows prior to insert. SQL> -- ---------------------------------------------------------------------- SQL> -- Count rentals before insert. SQL> SELECT COUNT(*) AS "Rental before count" 2 FROM rental; Rental before count ------------------- 8 1 row selected. SQL> SQL> -- ---------------------------------------------------------------------- SQL> -- Step #1 : Fix query and query results. SQL> -- ---------------------------------------------------------------------- SQL> SET NULL '<Null>' SQL> COLUMN rental_id FORMAT 9999 HEADING "Rental|ID #" SQL> COLUMN customer FORMAT 9999 HEADING "Customer|ID #" SQL> COLUMN check_out_date FORMAT A9 HEADING "Check Out|Date" SQL> COLUMN return_date FORMAT A10 HEADING "Return|Date" SQL> COLUMN created_by FORMAT 9999 HEADING "Created|By" SQL> COLUMN creation_date FORMAT A10 HEADING "Creation|Date" SQL> COLUMN last_updated_by FORMAT 9999 HEADING "Last|Update|By" SQL> COLUMN last_update_date FORMAT A10 HEADING "Last|Updated" SQL> SELECT DISTINCT 2 r.rental_id 3 , c.contact_id 4 , tu.check_out_date AS check_out_date 5 , tu.return_date AS return_date 6 , 3 AS created_by 7 , TRUNC(SYSDATE) AS creation_date 8 , 3 AS last_updated_by 9 , TRUNC(SYSDATE) AS last_update_date 10 FROM MEMBER M 11 JOIN CONTACT C 12 ON M.MEMBER_ID = C.MEMBER_ID 13 JOIN transaction_upload tu 14 ON M.account_number = tu.account_number 15 AND c.first_name = tu.first_name 16 AND NVL(c.middle_name, 'x') = NVL(tu.middle_name, 'x') 17 AND c.last_name = tu.last_name 18 LEFT JOIN RENTAL R 19 ON c.contact_id = r.customer_id 20 AND TRUNC(tu.check_out_date) = TRUNC(r.check_out_date) 21 AND TRUNC(tu.return_date) = TRUNC(r.return_date); Contact -------- Last Rental Contact Check Out Return Created Creation Update Last ID # ID # Date Date By Date By Updated ------ -------- --------- ---------- ------- ---------- ------ ---------- <Null> 1008 18-OCT-09 21-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 23-DEC-09 26-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 25-APR-09 28-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 05-JAN-09 08-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 23-AUG-09 26-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 19-MAY-09 22-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 30-OCT-09 02-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 15-DEC-09 18-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 27-SEP-09 30-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 04-OCT-09 07-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 29-AUG-09 01-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 26-SEP-09 29-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 16-FEB-09 19-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 22-JUL-09 25-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 08-JUN-09 11-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 22-JUL-09 25-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 16-MAY-09 19-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 19-APR-09 22-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 19-MAR-09 22-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 25-JAN-09 28-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 20-JUL-09 23-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 25-DEC-09 28-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 26-APR-09 29-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 21-OCT-09 24-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 13-MAR-09 16-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 30-JAN-09 02-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 28-APR-09 01-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 21-JUL-09 24-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 15-SEP-09 18-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 23-FEB-09 26-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 25-JAN-09 28-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 23-FEB-09 26-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 19-JUL-09 22-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 13-JAN-09 16-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 28-JUL-09 31-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 23-MAR-09 26-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 22-DEC-09 25-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 31-DEC-09 03-JAN-10 3 15-MAR-20 3 15-MAR-20 <Null> 1001 02-DEC-09 05-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 31-MAR-09 03-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 17-APR-09 20-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 31-MAR-09 03-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 27-AUG-09 30-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 18-OCT-09 21-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 26-OCT-09 29-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 11-JUL-09 14-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 08-APR-09 11-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 12-OCT-09 15-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 23-JUL-09 26-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 19-APR-09 22-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 26-SEP-09 29-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 17-MAY-09 20-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 08-SEP-09 11-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 06-MAR-09 09-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 13-OCT-09 16-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 01-SEP-09 04-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 17-FEB-09 20-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 26-FEB-09 01-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 07-OCT-09 10-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 27-JAN-09 30-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 15-MAR-09 18-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 14-FEB-09 17-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 11-MAY-09 14-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 18-NOV-09 21-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 22-SEP-09 25-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 02-NOV-09 05-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 03-MAR-09 06-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 17-MAY-09 20-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 03-FEB-09 06-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 17-FEB-09 20-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 09-APR-09 12-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 13-SEP-09 16-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 24-APR-09 27-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 07-SEP-09 10-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 22-NOV-09 25-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 26-APR-09 29-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 03-NOV-09 06-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 23-JAN-09 26-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 23-NOV-09 26-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 18-MAR-09 21-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 10-NOV-09 13-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 16-MAY-09 19-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 19-FEB-09 22-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 01-AUG-09 04-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 28-OCT-09 31-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 18-FEB-09 21-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 20-AUG-09 23-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 27-NOV-09 30-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 14-FEB-09 17-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 09-AUG-09 12-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 11-JAN-09 14-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 22-APR-09 25-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 30-OCT-09 02-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 12-JAN-09 15-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 29-JUN-09 02-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 19-JUL-09 22-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 24-MAR-09 27-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 08-JAN-09 11-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 21-NOV-09 24-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 05-NOV-09 08-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 24-NOV-09 27-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 28-NOV-09 01-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 30-JAN-09 02-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 16-JUN-09 19-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 16-MAR-09 19-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 07-OCT-09 10-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 10-JAN-09 13-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 01-JUL-09 04-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 13-APR-09 16-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 18-DEC-09 21-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 14-MAR-09 17-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 10-MAR-09 13-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 05-AUG-09 08-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 20-MAR-09 23-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 08-NOV-09 11-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 07-OCT-09 10-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 20-JAN-09 23-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 26-MAR-09 29-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 24-AUG-09 27-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 17-JUL-09 20-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 11-JUN-09 14-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 13-JUL-09 16-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 15-MAY-09 18-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 29-MAR-09 01-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 28-SEP-09 01-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 22-JUL-09 25-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 04-NOV-09 07-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 24-APR-09 27-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 01-AUG-09 04-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 24-SEP-09 27-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 08-APR-09 11-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 12-FEB-09 15-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 27-AUG-09 30-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 20-MAR-09 23-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 08-JUN-09 11-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 16-MAY-09 19-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 21-JUN-09 24-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 26-DEC-09 29-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 21-MAY-09 24-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 09-JAN-09 12-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 11-FEB-09 14-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 02-JUL-09 05-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 14-NOV-09 17-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 06-FEB-09 09-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 07-MAY-09 10-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 24-SEP-09 27-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 11-AUG-09 14-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 14-OCT-09 17-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 30-JUN-09 03-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 20-DEC-09 23-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 09-APR-09 12-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 10-MAR-09 13-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 30-MAR-09 02-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 29-JUN-09 02-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 24-DEC-09 27-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 24-MAR-09 27-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 30-JAN-09 02-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 14-APR-09 17-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 19-JUN-09 22-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 27-NOV-09 30-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 08-OCT-09 11-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 30-DEC-09 02-JAN-10 3 15-MAR-20 3 15-MAR-20 <Null> 1008 09-NOV-09 12-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 07-MAR-09 10-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 04-MAR-09 07-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 15-MAY-09 18-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 17-SEP-09 20-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 08-MAR-09 11-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 29-MAR-09 01-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 04-OCT-09 07-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 31-MAR-09 03-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 21-JUL-09 24-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 16-SEP-09 19-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 13-MAY-09 16-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 09-JUL-09 12-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 14-NOV-09 17-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 08-FEB-09 11-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 14-APR-09 17-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 23-APR-09 26-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 27-FEB-09 02-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 09-MAY-09 12-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 15-APR-09 18-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 18-JUN-09 21-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 26-JAN-09 29-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 15-FEB-09 18-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 23-JUN-09 26-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 18-DEC-09 21-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 02-AUG-09 05-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 28-FEB-09 03-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 07-APR-09 10-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 26-JUL-09 29-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 01-DEC-09 04-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 25-OCT-09 28-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 27-JUL-09 30-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 09-MAR-09 12-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 18-AUG-09 21-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 20-FEB-09 23-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 01-MAR-09 04-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 03-MAR-09 06-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 11-MAY-09 14-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 27-MAR-09 30-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 21-AUG-09 24-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 09-JUN-09 12-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 02-SEP-09 05-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 03-FEB-09 06-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 04-APR-09 07-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 18-JUL-09 21-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 06-SEP-09 09-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 12-FEB-09 15-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 01-DEC-09 04-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 06-MAY-09 09-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 02-OCT-09 05-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 25-MAR-09 28-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 03-NOV-09 06-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 18-DEC-09 21-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 24-FEB-09 27-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 04-AUG-09 07-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 05-OCT-09 08-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 28-AUG-09 31-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 25-NOV-09 28-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 07-MAR-09 10-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 17-JUL-09 20-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 06-AUG-09 09-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 18-MAY-09 21-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 05-NOV-09 08-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 03-OCT-09 06-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 21-JUN-09 24-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 16-JUL-09 19-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 25-OCT-09 28-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 16-SEP-09 19-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 12-FEB-09 15-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 17-MAR-09 20-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 18-FEB-09 21-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 27-SEP-09 30-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 16-NOV-09 19-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 25-APR-09 28-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 17-JAN-09 20-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 15-JAN-09 18-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 10-JUL-09 13-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 17-JUN-09 20-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 13-JUL-09 16-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 24-DEC-09 27-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 12-SEP-09 15-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 06-APR-09 09-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 06-NOV-09 09-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 16-APR-09 19-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 19-FEB-09 22-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 25-APR-09 28-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 01-NOV-09 04-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 28-JUL-09 31-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 12-SEP-09 15-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 01-MAY-09 04-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 21-JAN-09 24-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 28-AUG-09 31-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 27-OCT-09 30-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 22-FEB-09 25-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 13-OCT-09 16-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 06-SEP-09 09-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 26-APR-09 29-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 28-MAR-09 31-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 15-DEC-09 18-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 03-APR-09 06-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 17-DEC-09 20-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 29-NOV-09 02-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 16-JUN-09 19-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 07-FEB-09 10-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 02-MAY-09 05-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 14-MAY-09 17-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 21-JUN-09 24-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 31-MAR-09 03-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 20-SEP-09 23-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 12-SEP-09 15-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 24-FEB-09 27-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 14-MAR-09 17-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 30-MAR-09 02-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 04-APR-09 07-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1006 10-SEP-09 13-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 30-MAR-09 02-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 13-JAN-09 16-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 10-JAN-09 13-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 08-AUG-09 11-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 25-JUL-09 28-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 13-MAY-09 16-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 07-FEB-09 10-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 11-FEB-09 14-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 30-DEC-09 02-JAN-10 3 15-MAR-20 3 15-MAR-20 <Null> 1003 29-JAN-09 01-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 20-MAY-09 23-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 31-AUG-09 03-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 14-SEP-09 17-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 10-JAN-09 13-JAN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 13-DEC-09 16-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 28-APR-09 01-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1014 08-MAY-09 11-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 28-JUL-09 31-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 01-FEB-09 04-FEB-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 21-NOV-09 24-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1005 14-SEP-09 17-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 18-OCT-09 21-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1008 25-JUN-09 28-JUN-09 3 15-MAR-20 3 15-MAR-20 <Null> 1004 18-SEP-09 21-SEP-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 14-JUL-09 17-JUL-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 02-AUG-09 05-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 02-APR-09 05-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1001 20-OCT-09 23-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1009 09-AUG-09 12-AUG-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 03-MAY-09 06-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1010 17-APR-09 20-APR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 01-DEC-09 04-DEC-09 3 15-MAR-20 3 15-MAR-20 <Null> 1007 21-NOV-09 24-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1013 29-APR-09 02-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 12-MAR-09 15-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1002 10-NOV-09 13-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 03-MAR-09 06-MAR-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 08-MAY-09 11-MAY-09 3 15-MAR-20 3 15-MAR-20 <Null> 1011 24-NOV-09 27-NOV-09 3 15-MAR-20 3 15-MAR-20 <Null> 1012 29-SEP-09 02-OCT-09 3 15-MAR-20 3 15-MAR-20 <Null> 1003 17-JUL-09 20-JUL-09 3 15-MAR-20 3 15-MAR-20 <...
View Full Document

  • Fall '19
  • Set null

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture