insert into fb_persons(first_name,last_name,account_name,drug_shipment_flag) 
values('kumar','chandran','kchandran','Yes')
/
insert into fb_persons(first_name,last_name,account_name,status,status_date,drug_shipment_flag) 
values('veda','nagaraj','vnagaraj','active',sysdate,'Yes')
/
insert into fb_persons(first_name,last_name,account_name,status,status_date,drug_shipment_flag) 
values('bob','moyer','bmoyer','active',sysdate,'No')
/


insert into fb_organizations(organization_id,organization_name,national_provider_id) 
values('001','ctep1','10001')
/
insert into fb_organizations(organization_id,organization_name,national_provider_id) 
values('002','ctep2','10002')
/
insert into fb_organizations(organization_id,organization_name,national_provider_id) 
values('003','ctep3','10003')
/


insert into fb_addresses(address_line1,city,state,cou_id,ZIP_POSTAL_CODE) 
values('gateshead manor way','silver springs','va',237,'20998')
/
insert into fb_addresses(address_line1,city,state,cou_id,ZIP_POSTAL_CODE) 
values('travilah rd','rockville','md',237,'20998')
/
insert into fb_addresses(address_line1,city,state,cou_id,ZIP_POSTAL_CODE) 
values('summer pond dr','herndon','va',237,'20998')
/



insert into fb_person_types(per_id,ppr_type)
values(2,'IVR')
/
insert into fb_person_types(per_id,ppr_type)
values(3,'IVR')
/
insert into fb_person_types(per_id,ppr_type)
values(4,'sb')
/
insert into fb_labs(name) values('lab1')
/
insert into fb_labs(name) values('lab2')
/
insert into fb_labs(name) values('lab3')

insert into fb_irbs(name) values('irb1')
/
insert into fb_irbs(name) values('irb2')
/
insert into fb_irbs(name) values('irb3')
/
insert into fb_degrees(degree_name,comments) values('masters','masters')
/
insert into fb_degrees(degree_name,comments) values('doctorate','doctorate')
/

insert into fb_specialities(speciality_name) values('chemistry')
/
insert into fb_specialities(speciality_name) values('behavioral sciences')

insert into fb_person_specialities(spe_id,per_id) values(1,2)
/
insert into fb_person_specialities(spe_id,per_id) values(2,2)
/
insert into fb_person_specialities(spe_id,per_id) values(1,2)
/

insert into fb_person_degrees(deg_id,per_id) values(2,2)
/
insert into fb_person_degrees(deg_id,per_id) values(1,2)
/
insert into fb_person_degrees(deg_id,per_id) values(1,3)
/
insert into fb_organization_types(org_id,oor_type) values (1,'Sponsor')
/
insert into fb_organization_types(org_id,oor_type) values (2,'Sponsor')
/

insert into fb_party_addresses(role_type,comments,org_id,add_id)
values('Primary','Primary Address',1,1)
/
insert into fb_party_addresses(role_type,comments,org_id,add_id)
values('Primary','Primary Address',2,1)
/
insert into fb_party_addresses(role_type,comments,org_id,add_id)
values('Secondary','Secondary Address',1,2)
/
 
insert into fb_party_pair_combinations(comb_role_type,DESCRIPTION) values('ORG-PER','oragn to person')
/
insert into fb_party_pair_combinations(comb_role_type,DESCRIPTION) values('PER-PER','oragn to person')
/
insert into fb_party_pair_combinations(comb_role_type,DESCRIPTION) values('ORG-ORG','oragn to person')
/ 
insert into fb_party_pair_combinations(comb_role_type,DESCRIPTION) values('PER-PRO','oragn to person')
/ 
insert into fb_party_pairs(ppr_id,oor_id,ppc_id) values(1,1,3)
/ 
insert into fb_party_pairs(ppr_id,ppr_id_to,ppc_id) values(1,2,4)
/  
insert into fb_party_pairs(oor_id,oor_id_to,ppc_id) values(1,2,5)
/   
insert into fb_party_pairs(ppr_id,oor_id,ppc_id) values(1,2,3)
/    
i
/sert into fb_contact_mechanisms(cme_type,value) values('EMA','aa@aa.com')
insert into fb_contact_mechanisms(cme_type,value) values('FAX','111-222-2222')
/
insert into fb_contact_mechanisms(cme_type,value) values('PHO','222-333-4444')
/
    
insert into fb_party_contact_mechanisms(role_type,pad_id,cme_id) values('Primary',1,1)
/     
insert into fb_party_contact_mechanisms(role_type,pad_id,cme_id) values('Primary',2,2)
/    
insert into fb_party_contact_mechanisms(role_type,pad_id,cme_id) values('Primary',1,2)
/       
commit
/     
    