insert into {schema}_code_note_scope (code_seq, code_val, code_txt, code_code, code_attrib) VALUES (2, 'C', 'Customer', 'cust', NULL);
insert into {schema}_code_doc_scope (code_seq, code_val, code_txt, code_code, code_attrib) VALUES (2, 'C', 'Customer', 'cust', NULL);

INSERT INTO {schema}_cust_role (cust_role_seq, cust_role_sts, cust_role_name, cust_role_desc, cust_role_code, cust_role_attrib) VALUES (1, 'ACTIVE', 'CSYSADMIN', 'Administrator', NULL,NULL);
INSERT INTO {schema}_cust_role (cust_role_seq, cust_role_sts, cust_role_name, cust_role_desc, cust_role_code, cust_role_attrib) VALUES (2, 'ACTIVE', 'CX_B', 'Browse', NULL, NULL);
INSERT INTO {schema}_cust_role (cust_role_seq, cust_role_sts, cust_role_name, cust_role_desc, cust_role_code, cust_role_attrib) VALUES (3, 'ACTIVE', 'CX_X', 'Entry / Update', NULL, NULL);
INSERT INTO {schema}_cust_role (cust_role_seq, cust_role_sts, cust_role_name, cust_role_desc, cust_role_code, cust_role_attrib) VALUES (1, 'ACTIVE', 'CUSER', 'Client User', NULL, NULL);
INSERT INTO {schema}_cust_role (cust_role_seq, cust_role_sts, cust_role_name, cust_role_desc, cust_role_code, cust_role_attrib) VALUES (0, 'ACTIVE', 'C*', 'All Users', NULL, NULL);

INSERT INTO {schema}_menu__tbl (menu_group, menu_id, menu_sts, menu_id_parent, menu_name, menu_seq, menu_desc, menu_desc_ext, menu_desc_ext2, menu_cmd, menu_image, menu_subcmd) VALUES ('C', 2, 'ACTIVE', NULL, 'CLIENT', NULL, 'Customer', NULL, NULL, NULL, NULL, NULL);
INSERT INTO {schema}_menu__tbl (menu_group, menu_id, menu_sts, menu_id_parent, menu_name, menu_seq, menu_desc, menu_desc_ext, menu_desc_ext2, menu_cmd, menu_image, menu_subcmd) VALUES ('C', 200, 'ACTIVE', 2, 'Client/Dashboard', NULL, 'Dashboard', NULL, NULL, '%%%NAMESPACE%%%Client/Dashboard', NULL, NULL);
INSERT INTO {schema}_menu__tbl (menu_group, menu_id, menu_sts, menu_id_parent, menu_name, menu_seq, menu_desc, menu_desc_ext, menu_desc_ext2, menu_cmd, menu_image, menu_subcmd) VALUES ('C', 2800, 'ACTIVE', 2, 'Client/Admin', NULL, 'Administration', NULL, NULL, NULL, NULL, NULL);
INSERT INTO {schema}_menu__tbl (menu_group, menu_id, menu_sts, menu_id_parent, menu_name, menu_seq, menu_desc, menu_desc_ext, menu_desc_ext2, menu_cmd, menu_image, menu_subcmd) VALUES ('C', 280000, 'ACTIVE', 2800, 'Client/Admin/CustUser_Listing', NULL, 'Users', NULL, NULL, '%%%NAMESPACE%%%Client/Admin/CustUser_Listing', NULL, NULL);

INSERT INTO {schema}_cust_menu_role (menu_id, cust_menu_role_snotes, cust_role_name) VALUES (200, NULL, 'CX_B');
INSERT INTO {schema}_cust_menu_role (menu_id, cust_menu_role_snotes, cust_role_name) VALUES (2800, NULL, 'CSYSADMIN');
INSERT INTO {schema}_cust_menu_role (menu_id, cust_menu_role_snotes, cust_role_name) VALUES (280000, NULL, 'CSYSADMIN');
INSERT INTO {schema}_cust_menu_role (menu_id, cust_menu_role_snotes, cust_role_name) VALUES (200, NULL, 'CX_X');
INSERT INTO {schema}_cust_menu_role (menu_id, cust_menu_role_snotes, cust_role_name) VALUES (200, NULL, 'CUSER');

INSERT INTO {schema}_sys_menu_role (menu_id, sys_role_name) VALUES (2, 'SYSADMIN');
INSERT INTO {schema}_sys_menu_role (menu_id, sys_role_name) VALUES (200, 'SYSADMIN');
INSERT INTO {schema}_sys_menu_role (menu_id, sys_role_name) VALUES (2800, 'SYSADMIN');
INSERT INTO {schema}_sys_menu_role (menu_id, sys_role_name) VALUES (280000, 'SYSADMIN');

INSERT INTO {schema}_param__tbl (param_process, param_attrib, param_desc, param_type, code_name, is_param_app, is_param_user, is_param_sys) VALUES ('USERS', 'HASH_SEED_C', 'Hash Seed Client Users', 'C', NULL,  0, 0, 1);
INSERT INTO {schema}_param_sys (param_sys_process, param_sys_attrib, param_sys_val) VALUES ('USERS', 'HASH_SEED_C', 'NOT CONFIGURED');

INSERT INTO {schema}_txt__tbl (txt_process, txt_attrib, txt_type, txt_title, txt_body, txt_bcc, txt_desc) VALUES ('CMS', 'Client/Agreement', 'HTML', 'Client Agreement', NULL, NULL, 'Client Agreement');
INSERT INTO {schema}_txt__tbl (txt_process, txt_attrib, txt_type, txt_title, txt_body, txt_bcc, txt_desc) VALUES ('CMS', 'Client/Agreement_Complete', 'HTML', 'Client Agreement Complete', '<p>Thank you for completing sign-up.</p>
', NULL, 'Client Agreement Complete');
INSERT INTO {schema}_txt__tbl (txt_process, txt_attrib, txt_type, txt_title, txt_body, txt_bcc, txt_desc) VALUES ('CMS', 'Client/Dashboard', 'HTML', 'Client Dashboard Message of the Day', '<p>Welcome to the jsHarmony Client Portal</p>
', NULL, 'Client Dashboard Message of the Day');
