This is an old revision of the document!
jn table
CREATE TABLE employees_jn ( id NUMBER(6,0) , jn_type VARCHAR2(1 BYTE), employee_id NUMBER(6,0) , first_name VARCHAR2(20 BYTE), last_name VARCHAR2(25 BYTE) , email VARCHAR2(25 BYTE) , phone_number VARCHAR2(20 BYTE), hire_date DATE , job_id VARCHAR2(10 BYTE) , job_title VARCHAR2(100 BYTE) , old_salary NUMBER(8,2), new_salary NUMBER(8,2), commission_pct NUMBER(2,2), manager_id NUMBER(6,0), manager_name VARCHAR2(100 BYTE), department_id NUMBER(4,0), department_name VARCHAR2(100 BYTE), valid_from date, valid_to date )