--------------------------------------------------------------------------
-- This is the dataset for the TEMPORAL INCUMBENTS table for Chap 5-7 . --
-- Use one of the code fragments in chapter 5 to create the temporal    --
-- INCUMBENTS table.                                                    --
--                                                                      --
-- Note:  If a code fragment drops and recreates the INCUMBENTS table,  --
-- you must reload the data from this file to populate the INCUMBENTS   --
-- table.                                                               --
--------------------------------------------------------------------------
INSERT INTO INCUMBENTS
   (SSN, PCN, START_DATE, END_DATE)
VALUES 
   ('111223333' , '900225' , TO_DATE('1996-01-01','YYYY-MM-DD'), TO_DATE('1996-06-01','YYYY-MM-DD'))
;

INSERT INTO INCUMBENTS
   (SSN, PCN, START_DATE, END_DATE)
VALUES 
   ('111223333' , '120033' , TO_DATE('1996-06-01','YYYY-MM-DD'), TO_DATE('1996-08-01','YYYY-MM-DD'))
;

INSERT INTO INCUMBENTS
   (SSN, PCN, START_DATE, END_DATE)
VALUES 
   ('111223333' , '120033' , TO_DATE('1996-08-01','YYYY-MM-DD'), TO_DATE('1996-10-01','YYYY-MM-DD'))
;

INSERT INTO INCUMBENTS
   (SSN, PCN, START_DATE, END_DATE)
VALUES 
   ('111223333' , '137112' , TO_DATE('1996-10-01','YYYY-MM-DD'), TO_DATE('3000-01-01','YYYY-MM-DD'))
;

INSERT INTO INCUMBENTS
   (SSN, PCN, START_DATE, END_DATE)
VALUES 
   ('444332222' , '120033', TO_DATE('1997-01-01','YYYY-MM-DD'), TO_DATE('3000-01-01','YYYY-MM-DD'))
;

