<commit_before>-- *****************
--
-- SQL script to patch a release 1.0 DB to release 1.0.1 DB
-- Created 6-AUG-2008 by <NAME>
--
-- Includes JIRA Fixes:
--   KRACOEUS-1757 / KRACOEUS 1755 7-AUG-2008 <NAME>
--      - Change sh_parm_txt from 1 to 7 (TEMPORARY EMPLOYEE to REGULAR EMPLOYEE)
--   KRACOEUS-1753 11-AUG-2008 <NAME>
--      - Insert roles permissions relationship into KIM
--   KRACOEUS-1803 14-AUG-2008 <NAME>
--      - Remove Unit 000000 per KRACOEUS-827 change to Unit Hierarchy.
--   KRACOEUS-1813 19-AUG-2008 <NAME>
--      - Add 'budgetPersonDefaultPeriodType' to the 'sh_parm_t' table.
--
-- *****************

-- KRACOEUS-1757 / KRACOEUS-1755
UPDATE sh_parm_t
SET sh_parm_txt = '7'
WHERE sh_parm_nm = 'budgetPersonDefaultAppointmentType';

-- KRACOEUS-1753
INSERT INTO KIM_ROLES_PERMISSIONS_T (ROLE_ID, PERMISSION_ID, ACTIVE_FLAG) VALUES (7, 5, 'Y');
INSERT INTO KIM_ROLES_PERMISSIONS_T (ROLE_ID, PERMISSION_ID, ACTIVE_FLAG) VALUES (7, 7, 'Y');

-- KRACOEUS-1803
UPDATE unit SET parent_unit_number = null WHERE unit_number = '000001';
DELETE FROM unit WHERE unit_number = '000000';

-- KRACOEUS-1813
INSERT
INTO sh_parm_t(sh_parm_nmspc_cd,    sh_parm_dtl_typ_cd,    sh_parm_nm,    sh_parm_typ_cd,    sh_parm_txt,    sh_parm_desc,    sh_parm_cons_cd,    active_ind)
VALUES('KRA-B',    'D',    'budgetPersonDefaultPeriodType',    'CONFG',    '3',    'Default Period Type',    'A',    'Y');<commit_msg>Applying KRACOEUS-1817 sql script to 1.0.1 Patch Script<commit_after>-- *****************
--
-- SQL script to patch a release 1.0 DB to release 1.0.1 DB
-- Created 6-AUG-2008 by <NAME>
--
-- Includes JIRA Fixes:
--   KRACOEUS-1757 / KRACOEUS 1755 7-AUG-2008 <NAME>
--      - Change sh_parm_txt from 1 to 7 (TEMPORARY EMPLOYEE to REGULAR EMPLOYEE)
--   KRACOEUS-1753 11-AUG-2008 <NAME>
--      - Insert roles permissions relationship into KIM
--   KRACOEUS-1803 14-AUG-2008 <NAME>
--      - Remove Unit 000000 per KRACOEUS-827 change to Unit Hierarchy.
--   KRACOEUS-1813 19-AUG-2008 <NAME>
--      - Add 'budgetPersonDefaultPeriodType' to the 'sh_parm_t' table.
--   KRACOEUS-1817 25-AUG-2008 <NAME>
--      - Add 'POST SUBMISSION STATUS CODE' to fp_doc_type_t table.
--
-- *****************

-- KRACOEUS-1757 / KRACOEUS-1755
UPDATE sh_parm_t
SET sh_parm_txt = '7'
WHERE sh_parm_nm = 'budgetPersonDefaultAppointmentType';

-- KRACOEUS-1753
INSERT INTO KIM_ROLES_PERMISSIONS_T (ROLE_ID, PERMISSION_ID, ACTIVE_FLAG) VALUES (7, 5, 'Y');
INSERT INTO KIM_ROLES_PERMISSIONS_T (ROLE_ID, PERMISSION_ID, ACTIVE_FLAG) VALUES (7, 7, 'Y');

-- KRACOEUS-1803
UPDATE unit SET parent_unit_number = null WHERE unit_number = '000001';
DELETE FROM unit WHERE unit_number = '000000';

-- KRACOEUS-1813
INSERT
INTO sh_parm_t(sh_parm_nmspc_cd,    sh_parm_dtl_typ_cd,    sh_parm_nm,    sh_parm_typ_cd,    sh_parm_txt,    sh_parm_desc,    sh_parm_cons_cd,    active_ind)
VALUES('KRA-B',    'D',    'budgetPersonDefaultPeriodType',    'CONFG',    '3',    'Default Period Type',    'A',    'Y');

-- KRACOEUS-1817
INSERT
INTO fp_doc_type_t(fdoc_typ_cd,    ver_nbr,    fdoc_grp_cd,    fdoc_nm,    fin_elim_elgbl_cd,    fdoc_typ_active_cd,    fdoc_rtng_rule_cd,    fdoc_autoaprv_days,    fdoc_balanced_cd,    trn_scrbbr_ofst_gen_ind)
VALUES('POSS',    1,    'KR',    'POST SUBMISSION STATUS CODE',    'N',    'Y',    'N',    0,    'N',    'N');
{'fraction_non_alphanumeric': 0.13656783468104222, 'fraction_numerical': 0.06798442647499252, 'mean_word_length': 3.4772117962466487, 'pattern_counts': {'":': 0, '<': 14, '<?xml version=': 0, '>': 14, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '7323906', 'n_tokens_mistral': 1574, 'n_tokens_neox': 1363, 'n_words': 309}