/*****SAMPLE DATA*****/
declare @cust_id bigint
declare @sys_user_id bigint
insert into cust(cust_sts,cust_name,cust_email,cust_phone,cust_phone_type,cust_notes) values ('ACTIVE','ACME Industries','contact@acme.com','234-234-2345','WORK','Sample Customer');
set @cust_id = scope_identity();
set @sys_user_id = scope_identity();
insert into jsharmony.cust_user_role(sys_user_id,cust_role_name) values (@sys_user_id,'CSYSADMIN');
insert into jsharmony.cust_user_role(sys_user_id,cust_role_name) values (@sys_user_id,'CUSER');