ALTER Table hrsa_social_archives Add employee_id2 NUMBER(38,0)
/
update hrsa_social_archives a SET a.employee_id2=a.employee_id
/
alter table hrsa_social_archives drop column employee_id
/
alter table hrsa_social_archives rename column employee_id2 to employee_id
/
alter table hrsa_social_archives MODIFY (employee_id not null)
/

ALTER Table hrsa_fund_archives Add employee_id2 NUMBER(38,0)
/
update hrsa_fund_archives a SET a.employee_id2=a.employee_id
/
alter table hrsa_fund_archives drop column employee_id
/
alter table hrsa_fund_archives rename column employee_id2 to employee_id
/
alter table hrsa_fund_archives MODIFY (employee_id not null)
/

ALTER Table hrsa_other_archives Add employee_id2 NUMBER(38,0)
/
update hrsa_other_archives a SET a.employee_id2=a.employee_id
/
alter table hrsa_other_archives drop column employee_id
/
alter table hrsa_other_archives rename column employee_id2 to employee_id
/
alter table hrsa_other_archives MODIFY (employee_id not null)
/


ALTER TABLE hrsa_insurance_base_info ADD employee_type number 
/