text: --
  -- Copyright 2004-2014 The Kuali Foundation
  --
  -- Licensed under the Educational Community License, Version 2.0 (the "License");
  -- you may not use this file except in compliance with the License.
  -- You may obtain a copy of the License at
  --
  -- http://www.opensource.org/licenses/ecl2.php
  --
  -- Unless required by applicable law or agreed to in writing, software
  -- distributed under the License is distributed on an "AS IS" BASIS,
  -- WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  -- See the License for the specific language governing permissions and
  -- limitations under the License.
  --
  
  -- *********************************************************************
  -- Update Database Script
  -- *********************************************************************
  -- Change Log: src/main/config/db/db.changelog-main-upgrade.xml
  -- Ran at: 2/28/13 8:34 AM
  -- Against: KPMEDEV@jdbc:oracle:thin:@127.0.0.1:1521:XE
  -- Liquibase version: 2.0.5
  -- *********************************************************************
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230938.xml::1-oracle::lee55::(Checksum: 3:fdc149abd4c919408fadbcaa67f818c9)
  -- merge sql file changes
  CREATE SEQUENCE LM_LEDGER_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230938.xml::2::lee55::(Checksum: 3:1d61c750766c284465725fa327ee8db6)
  -- merge sql file changes
  CREATE TABLE LM_LEDGER_T (LM_LEDGER_ID VARCHAR2(60) NOT NULL, LEDGER_DATE DATE NOT NULL, DESCRIPTION VARCHAR2(255) NOT NULL, PRINCIPAL_ID VARCHAR2(40) NOT NULL, LEAVE_CODE VARCHAR2(15) NOT NULL, LM_LEAVE_CODE_ID NUMBER(38,0) NOT NULL, LM_SYS_SCHD_TIMEOFF_ID NUMBER(38,0) NOT NULL, LM_ACCRUAL_CATEGORY_ID NUMBER(38,0) NOT NULL, ACTIVE VARCHAR2(1) NOT NULL, HOURS INTEGER NOT NULL, APPLY_TO_YTD_USED VARCHAR2(255) NOT NULL, DOCUMENT_ID VARCHAR2(14) NOT NULL, PRINCIPAL_ACTIVATED VARCHAR2(40) NOT NULL, PRINCIPAL_INACTIVATED VARCHAR2(40) NOT NULL, TIMESTAMP_ACTIVATED DATE NOT NULL, TIMESTAMP_INACTIVATED DATE NOT NULL, ACCRUAL_GENERATED VARCHAR2(1) NOT NULL, BLOCK_ID NUMBER(38,0) NOT NULL, VER_NBR NUMBER(38,0) DEFAULT 1, OBJ_ID VARCHAR2(36), CONSTRAINT PK_LM_LEDGER_T PRIMARY KEY (LM_LEDGER_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230938.xml::3-oracle::lee55::(Checksum: 3:be9d3608d64f9533bf865fc65981378d)
  -- merge sql file changes
  CREATE SEQUENCE LM_LEDGER_BLOCK_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::3::lee55::(Checksum: 3:9957081fba9474cb636089678148ed06)
  -- another sql file merge
  DROP TABLE HR_HOLIDAY_CALENDAR_T;
  
  DROP TABLE HR_HOLIDAY_CALENDAR_DATES_T;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::4-oracle::lee55::(Checksum: 3:c1e46ddd617dcc711993a581aa552bc7)
  -- another sql file merge
  DROP SEQUENCE HR_HOLIDAY_CALENDAR_S;
  
  DROP SEQUENCE HR_HOLIDAY_CALENDAR_DATES_S;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::5-oracle::lee55::(Checksum: 3:828183a79a3bc1351f5b3de2a39c00d4)
  -- another sql file merge
  CREATE SEQUENCE LM_LEAVE_PLAN_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::6::lee55::(Checksum: 3:9db9b6111b6e34b22f55afc090d7db70)
  -- another sql file merge
  CREATE TABLE LM_LEAVE_PLAN_T (LM_LEAVE_PLAN_ID VARCHAR2(60) NOT NULL, LEAVE_PLAN VARCHAR2(15) NOT NULL, DESCR VARCHAR2(30), CAL_YEAR_START VARCHAR2(5), EFFDT DATE NOT NULL, OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, ACTIVE VARCHAR2(1) DEFAULT 'N', TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), CONSTRAINT PK_LM_LEAVE_PLAN_T PRIMARY KEY (LM_LEAVE_PLAN_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::7::lee55::(Checksum: 3:0ffc742f1bcdc32697377d3f714b4e8d)
  -- another sql file merge
  ALTER TABLE LM_ACCRUAL_CATEGORIES_T RENAME TO LM_ACCRUAL_CATEGORY_T;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_CATEGORY NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_CATEGORY VARCHAR2(15);
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_CATEGORY NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD LEAVE_PLAN VARCHAR2(15) NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD ACCRUAL_INTERVAL_EARN VARCHAR2(5) NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD UNIT_OF_TIME VARCHAR2(5) NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD PRORATION VARCHAR2(1) DEFAULT 'N';
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD DONATION VARCHAR2(1) DEFAULT 'N';
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD SHOW_ON_GRID VARCHAR2(1) DEFAULT 'N';
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD PLANNING_MONTHS NUMBER(38,0) DEFAULT 1 NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::8-oracle::lee55::(Checksum: 3:7c33f2d8b8f83dee34e67c056592fb8e)
  -- another sql file merge
  RENAME LM_ACCRUAL_CATEGORIES_S TO LM_ACCRUAL_CATEGORY_S;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::9-oracle::lee55::(Checksum: 3:c5918a81d68813d53087a21406a46472)
  -- another sql file merge
  CREATE SEQUENCE LM_ACCRUAL_CATEGORY_RULES_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::10::lee55::(Checksum: 3:788c86c50f075b54a42de95dfbf3a758)
  -- another sql file merge
  CREATE TABLE LM_ACCRUAL_CATEGORY_RULES_T (LM_ACCRUAL_CATEGORY_RULES_ID VARCHAR2(60) NOT NULL, SERVICE_UNIT_OF_TIME VARCHAR2(15) NOT NULL, START_ACC NUMBER(38,0) NOT NULL, END_ACC NUMBER(38,0) NOT NULL, ACCRUAL_RATE DECIMAL(10,2) NOT NULL, MAX_BAL DECIMAL(10,2) NOT NULL, MAX_BAL_ACTION_FREQUENCY VARCHAR2(5) NOT NULL, ACTION_AT_MAX_BAL VARCHAR2(5) NOT NULL, MAX_BAL_TRANS_ACC_CAT VARCHAR2(15), MAX_BAL_TRANS_CONV_FACTOR DECIMAL(10,2), MAX_TRANS_AMOUNT NUMBER(38,0), MAX_PAYOUT_AMOUNT NUMBER(38,0), MAX_PAYOUT_LEAVE_CODE VARCHAR2(15), MAX_USAGE NUMBER(38,0), MAX_CARRY_OVER NUMBER(38,0), LM_ACCRUAL_CATEGORY_ID NUMBER(38,0) NOT NULL, OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, ACTIVE VARCHAR2(1) DEFAULT 'N', TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), CONSTRAINT PK_LM_ACCRUAL_CATEGORY_RULES_T PRIMARY KEY (LM_ACCRUAL_CATEGORY_RULES_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::11-oracle::lee55::(Checksum: 3:55ef1d24d9bb2323d8d836443b03669f)
  -- another sql file merge
  CREATE SEQUENCE LM_LEAVE_CODE_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::12::lee55::(Checksum: 3:5c7942b1c4c1aef4778fe3f15f060aea)
  -- another sql file merge
  CREATE TABLE LM_LEAVE_CODE_T (LM_LEAVE_CODE_ID VARCHAR2(60) NOT NULL, LEAVE_PLAN VARCHAR2(15) NOT NULL, ELIGIBLE_FOR_ACC VARCHAR2(5) NOT NULL, ACCRUAL_CAT VARCHAR2(15), EARN_CODE VARCHAR2(15), LEAVE_CODE VARCHAR2(15) NOT NULL, DISP_NAME VARCHAR2(20), UNIT_OF_TIME VARCHAR2(5) NOT NULL, FRACT_TIME_ALLOWD VARCHAR2(5) NOT NULL, ROUND_OPT VARCHAR2(5) NOT NULL, ALLOW_SCHD_LEAVE VARCHAR2(5) NOT NULL, FMLA VARCHAR2(5) NOT NULL, WORKMANS_COMP VARCHAR2(5) NOT NULL, DEF_TIME NUMBER(38,0), EMPLOYEE VARCHAR2(1) DEFAULT 'N', APPROVER VARCHAR2(1) DEFAULT 'N', DEPT_ADMIN VARCHAR2(1) DEFAULT 'N', EFFDT DATE NOT NULL, OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, ACTIVE VARCHAR2(1) DEFAULT 'N', TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), CONSTRAINT PK_LM_LEAVE_CODE_T PRIMARY KEY (LM_LEAVE_CODE_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::13::lee55::(Checksum: 3:08f1ca30d345b9bcea443f72c153848b)
  -- another sql file merge
  CREATE TABLE LM_LEAVE_DOCUMENT_HEADER_T (DOCUMENT_ID VARCHAR2(14) NOT NULL, PRINCIPAL_ID VARCHAR2(10) NOT NULL, BEGIN_DATE TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') NOT NULL, END_DATE TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') NOT NULL, DOCUMENT_STATUS VARCHAR2(1) NOT NULL, OBJ_ID VARCHAR2(36) NOT NULL, VER_NBR NUMBER(38,0) NOT NULL);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::14::lee55::(Checksum: 3:a20b092a3879c17f3e5b0675337be06c)
  -- another sql file merge
  ALTER TABLE HR_JOB_T ADD ELIGIBLE_FOR_LEAVE VARCHAR2(1) DEFAULT 'N';
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::15-oracle::lee55::(Checksum: 3:8c69f0c9158d47992477fb122c26491d)
  -- another sql file merge
  CREATE SEQUENCE LM_SYS_SCHD_TIMEOFF_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201111230939.xml::16::lee55::(Checksum: 3:57404a424efb477af806fe853aaede6e)
  -- another sql file merge
  CREATE TABLE LM_SYS_SCHD_TIMEOFF_T (LM_SYS_SCHD_TIMEOFF_ID VARCHAR2(60) NOT NULL, LEAVE_PLAN VARCHAR2(15) NOT NULL, ACCRUAL_CATEGORY VARCHAR2(15) NOT NULL, LEAVE_CODE VARCHAR2(15) NOT NULL, ACCR_DT DATE NOT NULL, SCH_TIME_OFF_DT DATE, LOCATION VARCHAR2(15) NOT NULL, DESCR VARCHAR2(50) NOT NULL, AMOUNT_OF_TIME NUMBER(38,0) DEFAULT 1 NOT NULL, UNUSED_TIME VARCHAR2(5), TRANS_CONV_FACTOR DECIMAL(10,2), TRANSFER_TO_LEAVE_CODE VARCHAR2(15), EXP_DT DATE, PREMIUM_HOLIDAY VARCHAR2(5) NOT NULL, EFFDT DATE NOT NULL, OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, ACTIVE VARCHAR2(1) DEFAULT 'N', TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), CONSTRAINT PK_LM_SYS_SCHD_TIMEOFF_T PRIMARY KEY (LM_SYS_SCHD_TIMEOFF_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201112200337.xml::1-oracle::npadharia::(Checksum: 3:147fc38cee9f89d2f174183e4ff28847)
  -- KPME-1207 : npadharia : created Leave Donation maint doc.
  CREATE SEQUENCE LM_LEAVE_DONATION_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201112200337.xml::2::npadharia::(Checksum: 3:ba47d9f93736ed61478366dd8fe8b528)
  -- KPME-1207 : npadharia : created Leave Donation maint doc.
  CREATE TABLE LM_LEAVE_DONATION_T (LM_LEAVE_DONATION_ID VARCHAR2(60) NOT NULL, DONATED_ACC_CAT VARCHAR2(15) NOT NULL, RECIPIENTS_ACC_CAT VARCHAR2(15) NOT NULL, AMOUNT_DONATED DECIMAL(18,2) NOT NULL, AMOUNT_RECEIVED DECIMAL(18,2) NOT NULL, DONOR VARCHAR2(40) NOT NULL, RECEPIENT VARCHAR2(40) NOT NULL, DESCR VARCHAR2(50) NOT NULL, EFFDT DATE NOT NULL, OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, ACTIVE VARCHAR2(1) DEFAULT 'N', TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), CONSTRAINT PK_LM_LEAVE_DONATION_T PRIMARY KEY (LM_LEAVE_DONATION_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::2::lee55::(Checksum: 3:0f634071dd765b4cf99d18c0ef20ab1d)
  -- reorganized the sql files
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_INTERVAL_EARN NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_INTERVAL_EARN VARCHAR2(1);
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_INTERVAL_EARN NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T DROP COLUMN PLANNING_MONTHS;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::3-oracle::lee55::(Checksum: 3:3aaf175f58c6fc1a847942392ae10534)
  -- reorganized the sql files
  CREATE SEQUENCE LM_EMPLOYEE_OVERRIDE_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::4::lee55::(Checksum: 3:5b66bba12e0fa7e1a4da725212b17a5d)
  -- reorganized the sql files
  CREATE TABLE LM_EMPLOYEE_OVERRIDE_T (LM_EMPLOYEE_OVERRIDE_ID VARCHAR2(60) NOT NULL, PRINCIPAL_ID VARCHAR2(40) NOT NULL, ACCRUAL_CAT VARCHAR2(60) NOT NULL, LEAVE_PLAN VARCHAR2(60) NOT NULL, OVERRIDE_TYPE VARCHAR2(30) NOT NULL, OVERRIDE_VALUE NUMBER(38,0), DESCRIPTION VARCHAR2(50), ACTIVE VARCHAR2(1) DEFAULT 'N' NOT NULL, TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, CONSTRAINT PK_LM_EMPLOYEE_OVERRIDE_T PRIMARY KEY (LM_EMPLOYEE_OVERRIDE_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::5-oracle::lee55::(Checksum: 3:9002f4aff96654151073b29d45d96e61)
  -- reorganized the sql files
  CREATE SEQUENCE LM_LEAVE_ADJUSTMENT_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::6::lee55::(Checksum: 3:357616e96a1e0e9073eab178bedddac4)
  -- reorganized the sql files
  CREATE TABLE LM_LEAVE_ADJUSTMENT_T (LM_LEAVE_ADJUSTMENT_ID VARCHAR2(60) NOT NULL, PRINCIPAL_ID VARCHAR2(40) NOT NULL, ACCRUAL_CAT VARCHAR2(15) NOT NULL, LEAVE_PLAN VARCHAR2(15) NOT NULL, LEAVE_CODE VARCHAR2(15) NOT NULL, ADJUSTMENT_AMOUNT DECIMAL(20) NOT NULL, DESCRIPTION VARCHAR2(50), TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS'), OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, CONSTRAINT PK_LM_LEAVE_ADJUSTMENT_T PRIMARY KEY (LM_LEAVE_ADJUSTMENT_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202080934.xml::8::lee55::(Checksum: 3:c2e99da1c1ca1c3366e73820315aa11c)
  -- reorganized the sql files
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD MIN_PERCENT_WORKED DECIMAL(5,2) DEFAULT 0;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202090656.xml::1::tkagata::(Checksum: 3:92511913fe16c74e2c554439d7acfb75)
  -- Default for accrual_interval_earn needs to be "M" (monthly)
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY ACCRUAL_INTERVAL_EARN DEFAULT 'M';
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202221800.xml::1::henrydfs::(Checksum: 3:ec354e144929350d0963fc30e627972a)
  -- KPME-1247
  ALTER TABLE LM_LEAVE_PLAN_T ADD PLANNING_MONTHS VARCHAR2(3);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201202291146.xml::1::xichen::(Checksum: 3:dc3b64226f7bbbbce296dcf5b10fb028)
  -- KPME-1350, add allow_negative_accrual_balance field into Leave Code.
  ALTER TABLE LM_LEAVE_CODE_T ADD ALLOW_NEGATIVE_ACC_BALANCE VARCHAR2(1) DEFAULT 'N' NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203020913.xml::1::tkagata::(Checksum: 3:b405133d958a2c8b93577ad01b9bdcf7)
  -- kpme1250, kpme1268
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T ADD RECORD_TIME VARCHAR2(1) DEFAULT 'Y' NOT NULL;
  
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T ADD RECORD_LEAVE VARCHAR2(2) DEFAULT 'LM' NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::1-oracle::jkakkad::(Checksum: 3:0bd83a7c727ffa7d39f2dccda40fa7ae)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  CREATE SEQUENCE LM_LEAVE_BLOCK_HIST_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::2::jkakkad::(Checksum: 3:1852b88c8945925ab1d4c9947383a53f)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  CREATE TABLE LM_LEAVE_BLOCK_HIST_T (LM_LEAVE_BLOCK_HIST_ID VARCHAR2(60) NOT NULL, LM_LEAVE_BLOCK_ID VARCHAR2(60) NOT NULL, LEAVE_DATE DATE NOT NULL, DESCRIPTION VARCHAR2(255) NOT NULL, PRINCIPAL_ID VARCHAR2(40) NOT NULL, LEAVE_CODE VARCHAR2(15) NOT NULL, LM_LEAVE_CODE_ID VARCHAR2(60) NOT NULL, LM_SYS_SCHD_TIMEOFF_ID VARCHAR2(60) NOT NULL, LM_ACCRUAL_CATEGORY_ID VARCHAR2(60) NOT NULL, TK_ASSIGNMENT_ID VARCHAR2(60), HOURS INTEGER NOT NULL, APPLY_TO_YTD_USED VARCHAR2(255) NOT NULL, DOCUMENT_ID VARCHAR2(14) NOT NULL, PRINCIPAL_ID_MODIFIED VARCHAR2(40), TIMESTAMP DATE, PRINCIPAL_ID_DELETED VARCHAR2(40), TIMESTAMP_DELETED DATE, BLOCK_ID NUMBER(38,0), ACCRUAL_GENERATED VARCHAR2(1) NOT NULL, REQUEST_STATUS VARCHAR2(1), ACTION VARCHAR2(1), VER_NBR NUMBER(38,0) DEFAULT 1, OBJ_ID VARCHAR2(36), CONSTRAINT PK_LM_LEAVE_BLOCK_HIST_T PRIMARY KEY (LM_LEAVE_BLOCK_HIST_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::3-oracle::jkakkad::(Checksum: 3:bf0df407fb9d646a142263df79c0a6d1)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  CREATE SEQUENCE LM_LEAVE_STATUS_HIST_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::4::jkakkad::(Checksum: 3:ee62b0ee51632e10c7e61f1dd05db151)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  CREATE TABLE LM_LEAVE_STATUS_HIST_T (LM_LEAVE_STATUS_HIST_ID VARCHAR2(60) NOT NULL, LM_LEAVE_BLOCK_ID VARCHAR2(60) NOT NULL, REQUEST_STATUS VARCHAR2(1), TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') NOT NULL, PRINCIPAL_ID_MODIFIED VARCHAR2(40), REASON VARCHAR2(255), OBJ_ID VARCHAR2(36), VER_NBR NUMBER(38,0) DEFAULT 1 NOT NULL, CONSTRAINT PK_LM_LEAVE_STATUS_HIST_T PRIMARY KEY (LM_LEAVE_STATUS_HIST_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::5::jkakkad::(Checksum: 3:4f74d7fc418aa36c93df3039c40113fc)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  ALTER TABLE LM_LEDGER_T RENAME TO LM_LEAVE_BLOCK_T;
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN ACTIVE;
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN PRINCIPAL_ACTIVATED;
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN PRINCIPAL_INACTIVATED;
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN TIMESTAMP_ACTIVATED;
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN TIMESTAMP_INACTIVATED;
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD TIMESTAMP TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') NOT NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD PRINCIPAL_ID_MODIFIED VARCHAR2(40);
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD TK_ASSIGNMENT_ID VARCHAR2(60);
  
  ALTER TABLE LM_LEAVE_BLOCK_T RENAME COLUMN LM_LEDGER_ID TO LM_LEAVE_BLOCK_ID;
  
  ALTER TABLE LM_LEAVE_BLOCK_T RENAME COLUMN LEDGER_DATE TO LEAVE_DATE;
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD REQUEST_STATUS VARCHAR2(1);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203120603.xml::6-oracle::lee55::(Checksum: 3:78e31437936ca861e9c5217a239fd0c1)
  -- KPME-1392 KPME 1393 KPME 1394 SQLs added for required changes
  RENAME LM_LEDGER_S TO LM_LEAVE_BLOCK_S;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203160421.xml::1::jkakkad::(Checksum: 3:b2f03102832e718b5e9b3572b9d28e05)
  -- KPME-1232 Leave Request Page added
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY TIMESTAMP TIMESTAMP;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY TIMESTAMP NOT NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY TIMESTAMP_DELETED TIMESTAMP;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203160421.xml::2-oracle::jkakkad::(Checksum: 3:1719576a7a69553a00bfa3897a6e5caa)
  -- KPME-1232 Leave Request Page added
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY TIMESTAMP DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY TIMESTAMP_DELETED DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203160421.xml::2::jkakkad::(Checksum: 3:8640fe612bcdd91ee5062eac32a339e8)
  -- KPME-1232 Leave Request Page added
  ALTER TABLE LM_LEAVE_BLOCK_T RENAME COLUMN HOURS TO LEAVE_AMOUNT;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T RENAME COLUMN HOURS TO LEAVE_AMOUNT;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201203291520.xml::1::lee55::(Checksum: 3:f93f61491c3dceefe3bb41a6ca2dcde8)
  -- make the leave calendar work again
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY DESCRIPTION NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY APPLY_TO_YTD_USED NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY DESCRIPTION NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY APPLY_TO_YTD_USED NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201204101321.xml::1::tkagata::(Checksum: 3:d0cb0da74c884b5cb17c51423d44e9c3)
  -- KPME-1347
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY DESCR NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY DESCR VARCHAR2(50);
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY DESCR NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD LEAVE_CODE VARCHAR2(15);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201204131535.xml::1::henrydfs::(Checksum: 3:ee487d289e721c0dba7ddf75e8eec180)
  -- Max Balance Flag related JIRAs (KPME 1288, 1289, 1349, 1352, 1408) and needed SQL file  changes for schema changes to lm_accrual_category_t and lm_accrual_category_rules_t.
  ALTER TABLE LM_ACCRUAL_CATEGORY_T ADD HAS_RULES VARCHAR2(1);
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_RULES_T ADD MAX_BAL_FLAG VARCHAR2(1);
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_RULES_T MODIFY LM_ACCRUAL_CATEGORY_ID NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_RULES_T MODIFY LM_ACCRUAL_CATEGORY_ID VARCHAR2(60);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201204241305.xml::1::lfox::(Checksum: 3:fd7ebd5e56e5fa67b35a96dde3f954c6)
  -- modify table to allow null
  ALTER TABLE LM_LEAVE_CODE_T MODIFY LEAVE_PLAN NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201204300906.xml::1::jkakkad::(Checksum: 3:e9690409754d5034674e5ea6452eba53)
  -- KPME-1445 jobnumber, workarea, task fields added
  ALTER TABLE LM_LEAVE_BLOCK_T ADD JOB_NUMBER NUMBER(38,0);
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD WORK_AREA NUMBER(38,0);
  
  ALTER TABLE LM_LEAVE_BLOCK_T ADD TASK NUMBER(38,0);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205010840.xml::1::jkakkad::(Checksum: 3:5fc8539e2297eb46941cae44c5552b4c)
  -- KPME1464, added AffectPay field into Leave Code Maint page.
  ALTER TABLE LM_LEAVE_CODE_T ADD AFFECT_PAY VARCHAR2(1) DEFAULT 'N' NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205011112.xml::1::yingzhou::(Checksum: 3:96f4bee3508b6d051450a642e5a49cd0)
  -- kpme-1484: changed logic in leave calendar to display/add leave blocks with date, not document id
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY DOCUMENT_ID NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY DOCUMENT_ID NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205011141.xml::1::lfox::(Checksum: 3:0f5a90d8d416b61645e8fbfd2cf27210)
  -- modified for testing
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY LM_ACCRUAL_CATEGORY_ID NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY LM_ACCRUAL_CATEGORY_ID VARCHAR2(60);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205081455.xml::1::xichen::(Checksum: 3:4fe7b78af1eca1d45ee2899fdbd28f8c)
  -- KPME-1457. Added effectiveDate into table lm_employee_override_t and lm_ Leave_Adjustment_t.
  ALTER TABLE LM_LEAVE_ADJUSTMENT_T ADD EFFDT DATE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205081455.xml::2::xichen::(Checksum: 3:83d9ad2b4fc870d12b6592decf28a245)
  -- KPME-1457. Added effectiveDate into table lm_employee_override_t and lm_ Leave_Adjustment_t.
  ALTER TABLE LM_EMPLOYEE_OVERRIDE_T ADD EFFDT DATE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205081800.xml::1::henrydfs::(Checksum: 3:0357dee05eeb80589ef6c915611ba44a)
  -- KPME-1487, rename alter_employee_override.sql and alter_leave_adjustments to not execute after any sql files submitted in the AM on 05-09
  ALTER TABLE LM_LEAVE_DONATION_T ADD DONATED_LV_CODE VARCHAR2(15);
  
  ALTER TABLE LM_LEAVE_DONATION_T ADD RECIPIENTS_LV_CODE VARCHAR2(15);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201205301510.xml::1::yingzhou::(Checksum: 3:3d669c673008da7b1fd7c70ccd445426)
  -- kpme-1262, kpme-1209: added runAccrual logic in AccrualService, AccrualServiceTest
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY LM_SYS_SCHD_TIMEOFF_ID NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY LM_SYS_SCHD_TIMEOFF_ID VARCHAR2(60);
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY LM_SYS_SCHD_TIMEOFF_ID NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206051321.xml::1::yingzhou::(Checksum: 3:e0c2758d455f0b33527ed6a906443668)
  -- kpme-1267: partial commit, create empty leave block for employee status change
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T MODIFY LM_ACCRUAL_CATEGORY_ID NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206071531.xml::1::jkakkad::(Checksum: 3:132e38c598c11aec10c3af9f2874f344)
  -- KPME-1624 Earn code maint changed for Leave Management
  ALTER TABLE HR_EARN_CODE_T ADD LEAVE_PLAN VARCHAR2(15);
  
  ALTER TABLE HR_EARN_CODE_T ADD ACCRUAL_BAL_ACTION VARCHAR2(15);
  
  ALTER TABLE HR_EARN_CODE_T ADD FRACT_TIME_ALLOWD VARCHAR2(5) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD ROUND_OPT VARCHAR2(5) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD ROLLUP_TO_EARNCODE VARCHAR2(3);
  
  ALTER TABLE HR_EARN_CODE_T ADD ELIGIBLE_FOR_ACC VARCHAR2(1) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD AFFECT_PAY VARCHAR2(1) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD ALLOW_SCHD_LEAVE VARCHAR2(1) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD FMLA VARCHAR2(1) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD WORKMANS_COMP VARCHAR2(15) NOT NULL;
  
  ALTER TABLE HR_EARN_CODE_T ADD DEF_TIME VARCHAR2(15);
  
  ALTER TABLE HR_EARN_CODE_T ADD ALLOW_NEGATIVE_ACC_BALANCE VARCHAR2(1) NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206121602.xml::2::yingzhou::(Checksum: 3:2898bced189a552b74afa87acbeffd24)
  -- kpme-1641: added new id to principalHRAttributes table
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T ADD LEAVE_PLAN VARCHAR2(15);
  
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T ADD LEAVE_CALENDAR VARCHAR2(15);
  
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T DROP COLUMN HOLIDAY_CALENDAR_GROUP;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206141101.xml::1::jkakkad::(Checksum: 3:309ebbb263242a57df8d43936a57fd40)
  -- KPME-1632 Earn Code Group maint doc changes
  ALTER TABLE HR_EARN_GROUP_T RENAME COLUMN HR_EARN_GROUP_ID TO HR_EARN_CODE_GROUP_ID;
  
  ALTER TABLE HR_EARN_GROUP_T RENAME COLUMN EARN_GROUP TO EARN_CODE_GROUP;
  
  ALTER TABLE HR_EARN_GROUP_T MODIFY EARN_CODE_GROUP NOT NULL;
  
  ALTER TABLE HR_EARN_GROUP_T RENAME TO HR_EARN_CODE_GROUP_T;
  
  ALTER TABLE HR_EARN_GROUP_DEF_T RENAME COLUMN HR_EARN_GROUP_DEF_ID TO HR_EARN_CODE_GROUP_DEF_ID;
  
  ALTER TABLE HR_EARN_GROUP_DEF_T RENAME COLUMN HR_EARN_GROUP_ID TO HR_EARN_CODE_GROUP_ID;
  
  ALTER TABLE HR_EARN_GROUP_DEF_T RENAME TO HR_EARN_CODE_GROUP_DEF_T;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206141101.xml::2-oracle::jkakkad::(Checksum: 3:f350626a75da463594a02c96cca95bad)
  -- KPME-1632 Earn Code Group maint doc changes
  RENAME HR_EARN_GROUP_S TO HR_EARN_CODE_GROUP_S;
  
  RENAME HR_EARN_GROUP_DEF_S TO HR_EARN_CODE_GROUP_DEF_S;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206181101.xml::1::jkakkad::(Checksum: 3:4f4baf479a06a30a0e6301049a5e5b51)
  -- KPME-1634 Acc cat maint leave code reference changed to earn code
  ALTER TABLE LM_ACCRUAL_CATEGORY_T RENAME COLUMN LEAVE_CODE TO EARN_CODE;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_T MODIFY EARN_CODE NOT NULL;
  
  ALTER TABLE LM_ACCRUAL_CATEGORY_RULES_T RENAME COLUMN MAX_PAYOUT_LEAVE_CODE TO MAX_PAYOUT_EARN_CODE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206191001.xml::1::jkakkad::(Checksum: 3:2dc24ba36af8e40fde404d768c11ef82)
  -- KPME-1635 System scheduled time off maint doc change (reference changed from leave code to earn code)
  ALTER TABLE LM_SYS_SCHD_TIMEOFF_T RENAME COLUMN LEAVE_CODE TO EARN_CODE;
  
  ALTER TABLE LM_SYS_SCHD_TIMEOFF_T RENAME COLUMN TRANSFER_TO_LEAVE_CODE TO TRANSFER_TO_EARN_CODE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206200901.xml::1::jkakkad::(Checksum: 3:8980cfaae63c1e83b2b94541062e8e09)
  -- KPME-1636 and KPME-1637 Leave Donation/Adjustment maint doc earn code changes
  ALTER TABLE LM_LEAVE_ADJUSTMENT_T RENAME COLUMN LEAVE_CODE TO EARN_CODE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206200901.xml::2::jkakkad::(Checksum: 3:4a3736476a059bee8d95630f2771d34a)
  -- KPME-1636 and KPME-1637 Leave Donation/Adjustment maint doc earn code changes
  ALTER TABLE LM_LEAVE_DONATION_T RENAME COLUMN DONATED_LV_CODE TO DONATED_ER_CODE;
  
  ALTER TABLE LM_LEAVE_DONATION_T RENAME COLUMN RECIPIENTS_LV_CODE TO RECIPIENTS_ER_CODE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206201455.xml::1::jkakkad::(Checksum: 3:bd4cd1dc889ee912c18c2e00470a3d39)
  -- Earn Code length changed from 3 to 15
  ALTER TABLE HR_EARN_CODE_T MODIFY ROLLUP_TO_EARNCODE VARCHAR2(15);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201206250940.xml::1::yingzhou::(Checksum: 3:8714a1d6bf725c02543074bbddf8aedf)
  -- kpme-1661: change leave block to use Earn Code instead of Leave Code, gui and test changes. Changed Accrual calculation to be based on work days.
  ALTER TABLE LM_LEAVE_BLOCK_T RENAME COLUMN LEAVE_CODE TO EARN_CODE;
  
  ALTER TABLE LM_LEAVE_BLOCK_T RENAME COLUMN LM_LEAVE_CODE_ID TO HR_EARN_CODE_ID;
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY HR_EARN_CODE_ID NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY HR_EARN_CODE_ID VARCHAR2(15);
  
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY HR_EARN_CODE_ID NOT NULL;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T RENAME COLUMN LEAVE_CODE TO EARN_CODE;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T RENAME COLUMN LM_LEAVE_CODE_ID TO HR_EARN_CODE_ID;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201207111400.xml::1::yingzhou::(Checksum: 3:254b621ef244a41cfe225f1a6cfec50f)
  -- KPME-1685
  ALTER TABLE LM_LEAVE_BLOCK_T ADD LEAVE_BLOCK_TYPE VARCHAR2(5) NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201207111400.xml::2::yingzhou::(Checksum: 3:8fb00da8ed3fac0b948c96faa5efb60e)
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T ADD LEAVE_BLOCK_TYPE VARCHAR2(5) NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201207131103.xml::1::jkakkad::(Checksum: 3:371db20db7236b5b2b61f044241d631d)
  -- KPME-1676 Record Time/Leave removed from Princiapal Attributes
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T DROP COLUMN RECORD_TIME;
  
  ALTER TABLE HR_PRINCIPAL_ATTRIBUTES_T DROP COLUMN RECORD_LEAVE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201207241500.xml::1::yingzhou::(Checksum: 3:d7d802948272360cfa0ea9cdb346900c)
  -- KPME-1267
  CREATE TABLE LM_PRIN_ACCR_RAN_T (PRINCIPAL_ID VARCHAR2(40) NOT NULL, LAST_RAN_TS DATE NOT NULL, CONSTRAINT PK_LM_PRIN_ACCR_RAN_T PRIMARY KEY (PRINCIPAL_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201208021300.xml::1::yingzhou::(Checksum: 3:29e94b3a4f9a38b8e0e1c2ee68223c61)
  -- KPME-1267
  ALTER TABLE LM_PRIN_ACCR_RAN_T MODIFY LAST_RAN_TS NULL;
  
  ALTER TABLE LM_PRIN_ACCR_RAN_T MODIFY LAST_RAN_TS TIMESTAMP;
  
  ALTER TABLE LM_PRIN_ACCR_RAN_T MODIFY LAST_RAN_TS NOT NULL;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201208021300.xml::2-oracle::yingzhou::(Checksum: 3:5ca74479e4e4ae280417ae42e69aaba6)
  -- KPME-1267
  ALTER TABLE LM_PRIN_ACCR_RAN_T MODIFY LAST_RAN_TS DEFAULT to_date('1970-01-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201208291913.xml::1::jkakkad::(Checksum: 3:7bac1de40ca5b8ff4bd4a70fa0ef901a)
  -- KPME-1746 Principal HR Attributes - Change workmans comp to workers comp
  ALTER TABLE hr_principal_attributes_t RENAME COLUMN WORKSMAN_ELIGIBLE TO WORKERS_ELIGIBLE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201209041500.xml::1::jjhanso::(Checksum: 3:fc2f0f2b11f00ace670c182911bea942)
  -- Adding missing primary keys
  ALTER TABLE LM_LEAVE_DOCUMENT_HEADER_T ADD CONSTRAINT PK_LM_LEAVE_DOCUMENT_HEADER_T PRIMARY KEY (DOCUMENT_ID);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201209071100.xml::1::yingzhou::(Checksum: 3:5ed632eb949a4f1ed05d29d7fcf43804)
  -- KPME-1760
  ALTER TABLE LM_LEAVE_BLOCK_T MODIFY LEAVE_AMOUNT VARCHAR2(10);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201209131413.xml::1::jkakkad::(Checksum: 3:8c02f438e26a3c81d1feaffe006adc14)
  -- KPME-1763 Earn Code: Add Flag- Usage Limit
  ALTER TABLE HR_EARN_CODE_T ADD USAGE_LIMIT VARCHAR2(5) DEFAULT 'I';
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201210030913.xml::1::kbtaylor::(Checksum: 3:00b67aab74de8d9eba6046c9d39b1a15)
  -- KPME-1842: Increasing the length of the description to 50
  ALTER TABLE LM_LEAVE_PLAN_T MODIFY DESCR VARCHAR2(50);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201210230922.xml::1::kbtaylor::(Checksum: 3:61022bdd475056acdec7cdc54dc55fcc)
  -- KPME-1490: Remove foreign key ids from linkages requiring effective date matchings
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN HR_EARN_CODE_ID;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T DROP COLUMN HR_EARN_CODE_ID;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201210230922.xml::2::kbtaylor::(Checksum: 3:5cbfd52d538b4c7c2ddf9e7e13838ae7)
  -- KPME-1490: Remove foreign key ids from linkages requiring effective date matchings
  ALTER TABLE LM_LEAVE_BLOCK_T ADD ACCRUAL_CATEGORY VARCHAR2(15);
  
  UPDATE LM_LEAVE_BLOCK_T lb SET ACCRUAL_CATEGORY = (SELECT ACCRUAL_CATEGORY FROM LM_ACCRUAL_CATEGORY_T ac WHERE lb.LM_ACCRUAL_CATEGORY_ID = ac.LM_ACCRUAL_CATEGORY_ID);
  
  ALTER TABLE LM_LEAVE_BLOCK_T DROP COLUMN LM_ACCRUAL_CATEGORY_ID;
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T ADD ACCRUAL_CATEGORY VARCHAR2(15);
  
  UPDATE LM_LEAVE_BLOCK_HIST_T lb SET ACCRUAL_CATEGORY = (SELECT ACCRUAL_CATEGORY FROM LM_ACCRUAL_CATEGORY_T ac WHERE lb.LM_ACCRUAL_CATEGORY_ID = ac.LM_ACCRUAL_CATEGORY_ID);
  
  ALTER TABLE LM_LEAVE_BLOCK_HIST_T DROP COLUMN LM_ACCRUAL_CATEGORY_ID;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211060924.xml::1-oracle::drgodfrey::(Checksum: 3:41159cce43db900a67790a0fe2690adf)
  -- merge sql file changes
  CREATE SEQUENCE LM_BALANCE_TRANSFER_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211060924.xml::2::drgodfrey::(Checksum: 3:67f8019a149b3218bc6564c3920db7c3)
  -- create lm_balance_transfer_t for balance transfer document
  CREATE TABLE LM_BALANCE_TRANSFER_T (LM_BALANCE_TRANSFER_ID VARCHAR2(60) NOT NULL, LM_ACCRUAL_CATEGORY_RULES_ID VARCHAR2(60), PRINCIPAL_ID VARCHAR2(40) NOT NULL, TRANSFER_AMOUNT DECIMAL(10,2) NOT NULL, DEBITED_ACCRUAL_CATEGORY VARCHAR2(15) NOT NULL, CREDITED_ACCRUAL_CATEGORY VARCHAR2(15), FORFEITED_AMOUNT DECIMAL(10,2), PAYOUT_EARN_CODE VARCHAR2(15) NOT NULL, EFFECTIVE_DATE DATE NOT NULL, CONSTRAINT PK_LM_BALANCE_TRANSFER_T PRIMARY KEY (LM_BALANCE_TRANSFER_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211271627.xml::1::drgodfrey::(Checksum: 3:c3278cb5335e93e72b5298da9d2700ba)
  -- removing payout earn code from lm_balance_transfer_t
  ALTER TABLE LM_BALANCE_TRANSFER_T DROP COLUMN PAYOUT_EARN_CODE;
  
  ALTER TABLE LM_BALANCE_TRANSFER_T RENAME COLUMN DEBITED_ACCRUAL_CATEGORY TO FROM_ACCRUAL_CATEGORY;
  
  ALTER TABLE LM_BALANCE_TRANSFER_T RENAME COLUMN CREDITED_ACCRUAL_CATEGORY TO TO_ACCRUAL_CATEGORY;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211291227.xml::1::kbtaylor::(Checksum: 3:1ca261631c4ad40e617858dde88dd243)
  -- KPME-1939: Removing old batch tables
  DROP TABLE TK_BATCH_JOB_ENTRY_T;
  
  DROP TABLE TK_BATCH_JOB_T;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211291227.xml::1-oracle::kbtaylor::(Checksum: 3:407dde3f3dd8816417abbfe6fe2b7346)
  -- KPME-1939: Removing old batch tables
  DROP SEQUENCE TK_BATCH_JOB_ENTRY_S;
  
  DROP SEQUENCE TK_BATCH_JOB_S;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211291227.xml::2::kbtaylor::(Checksum: 3:bc1f41708c0a9d44039e0b4d80e7efb5)
  -- KPME-1939: Merging date and time columns for batch calendar entries
  ALTER TABLE HR_CALENDAR_ENTRIES_T ADD BATCH_INITIATE_DATE TIMESTAMP;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T ADD BATCH_END_PAY_PERIOD_DATE TIMESTAMP;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T ADD BATCH_EMPLOYEE_APPROVAL_DATE TIMESTAMP;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T ADD BATCH_SUPERVISOR_APPROVAL_DATE TIMESTAMP;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211291227.xml::3-oracle::kbtaylor::(Checksum: 3:64bc75c6ea501627fbe947c0e110157d)
  -- KPME-1939: Merging date and time columns for batch calendar entries
  UPDATE HR_CALENDAR_ENTRIES_T SET BATCH_EMPLOYEE_APPROVAL_DATE = TO_DATE(TO_CHAR(EMPLOYEE_APPROVAL_DATE, 'MM/DD/YYYY ') || TO_CHAR(EMPLOYEE_APPROVAL_TIME, 'HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS'), BATCH_END_PAY_PERIOD_DATE = TO_DATE(TO_CHAR(END_PAY_PERIOD_DATE, 'MM/DD/YYYY ') || TO_CHAR(END_PAY_PERIOD_TIME, 'HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS'), BATCH_INITIATE_DATE = TO_DATE(TO_CHAR(INITIATE_DATE, 'MM/DD/YYYY ') || TO_CHAR(INITIATE_TIME, 'HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS'), BATCH_SUPERVISOR_APPROVAL_DATE = TO_DATE(TO_CHAR(SUPERVISOR_APPROVAL_DATE, 'MM/DD/YYYY ') || TO_CHAR(SUPERVISOR_APPROVAL_TIME, 'HH24:MI:SS'), 'MM/DD/YYYY HH24:MI:SS');
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201211291227.xml::4::kbtaylor::(Checksum: 3:de8cd2302f6222b0875254031a60d1cf)
  -- KPME-1939: Merging date and time columns for batch calendar entries
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN INITIATE_DATE;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN INITIATE_TIME;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN END_PAY_PERIOD_DATE;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN END_PAY_PERIOD_TIME;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN EMPLOYEE_APPROVAL_DATE;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN EMPLOYEE_APPROVAL_TIME;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN SUPERVISOR_APPROVAL_DATE;
  
  ALTER TABLE HR_CALENDAR_ENTRIES_T DROP COLUMN SUPERVISOR_APPROVAL_TIME;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201212030954.xml::1::jjhanso::(Checksum: 3:2a5a2b46a988fbaad56c78ff0fdd7c88)
  -- create lm_balance_transfer_t for balance transfer document
  CREATE TABLE LM_LEAVE_REQ_DOC_T (DOC_HDR_ID VARCHAR2(40) NOT NULL, LM_LEAVE_BLOCK_ID VARCHAR2(60), ACTION_CD VARCHAR2(1), DESCR VARCHAR2(255), OBJ_ID VARCHAR2(36), VER_NBR DECIMAL(8,0) DEFAULT 1 NOT NULL, CONSTRAINT PK_LM_LEAVE_REQ_DOC_T PRIMARY KEY (DOC_HDR_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201212030954.xml::2::jjhanso::(Checksum: 3:7df1f95e6dfb5a0fcea4c859e54afe19)
  ALTER TABLE LM_LEAVE_BLOCK_T ADD LEAVE_REQUEST_ID VARCHAR2(40);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201301091752.xml::1-oracle::tvisnius::(Checksum: 3:e04fdced153783a19b3bb9290ce46340)
  -- merge sql file changes
  CREATE SEQUENCE LM_LEAVE_PAYOUT_S START WITH 10000;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201301091752.xml::2::tvisnius::(Checksum: 3:526789bb8a3007ebd745d598e0065389)
  -- create lm_leave_payout_t for leave payout document
  CREATE TABLE LM_LEAVE_PAYOUT_T (LM_LEAVE_PAYOUT_ID VARCHAR2(60) NOT NULL, PRINCIPAL_ID VARCHAR2(40) NOT NULL, EARN_CODE VARCHAR2(60) NOT NULL, EFFECTIVE_DATE DATE NOT NULL, FROM_ACCRUAL_CATEGORY VARCHAR2(15) NOT NULL, PAYOUT_AMOUNT DECIMAL(10,2) NOT NULL, FORFEITED_AMOUNT DECIMAL(10,2), CONSTRAINT PK_LM_LEAVE_PAYOUT_T PRIMARY KEY (LM_LEAVE_PAYOUT_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201301181054.xml::2::dgodfrey::(Checksum: 3:b8a21eb308c74dec81341680a54913b0)
  ALTER TABLE LM_BALANCE_TRANSFER_T ADD AMOUNT_TRANSFERRED DECIMAL(20);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201301301000.xml::1::yingzhou::(Checksum: 3:55c480ab4600712024554da6c2a0709d)
  ALTER TABLE LM_SYS_SCHD_TIMEOFF_T DROP COLUMN EXP_DT;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302052120.xml::1::jkakkad::(Checksum: 3:34dce08112a9ea41d0a6db55e0d5f688)
  ALTER TABLE LM_LEAVE_PLAN_T ADD BATCH_CARRY_OVER_START_DATE VARCHAR2(5);
  
  ALTER TABLE LM_LEAVE_PLAN_T ADD BATCH_CARRY_OVER_START_TIME DATE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302111600.xml::1::yingzhou::(Checksum: 3:99225e0161e42615454d2611e9a4247a)
  ALTER TABLE LM_BALANCE_TRANSFER_T ADD SSTO_ID VARCHAR2(60);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302151700.xml::1::dgodfrey::(Checksum: 3:1c721ecb836ad51610ddfda1701dbf16)
  ALTER TABLE LM_BALANCE_TRANSFER_T ADD STATUS VARCHAR2(1);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::1::kbtaylor::(Checksum: 3:44131a85314b0e594ba8d620f50b4746)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  DROP TABLE QRTZ_CALENDARS;
  
  DROP TABLE QRTZ_FIRED_TRIGGERS;
  
  DROP TABLE QRTZ_TRIGGER_LISTENERS;
  
  DROP TABLE QRTZ_BLOB_TRIGGERS;
  
  DROP TABLE QRTZ_CRON_TRIGGERS;
  
  DROP TABLE QRTZ_SIMPLE_TRIGGERS;
  
  DROP TABLE QRTZ_TRIGGERS;
  
  DROP TABLE QRTZ_JOB_LISTENERS;
  
  DROP TABLE QRTZ_JOB_DETAILS;
  
  DROP TABLE QRTZ_PAUSED_TRIGGER_GRPS;
  
  DROP TABLE QRTZ_SCHEDULER_STATE;
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::2::kbtaylor::(Checksum: 3:05141d539bb8dce6c42b2fdcaf018166)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_JOB_DETAILS (JOB_NAME VARCHAR2(200) NOT NULL, JOB_GROUP VARCHAR2(200) NOT NULL, DESCRIPTION VARCHAR2(250), JOB_CLASS_NAME VARCHAR2(250) NOT NULL, IS_DURABLE VARCHAR2(1) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, IS_STATEFUL VARCHAR2(1) NOT NULL, REQUESTS_RECOVERY VARCHAR2(1) NOT NULL, JOB_DATA BLOB, CONSTRAINT PK_QRTZ_JOB_DETAILS PRIMARY KEY (JOB_NAME, JOB_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::3::kbtaylor::(Checksum: 3:690081a87fce68317ee37423de8b06b0)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_JOB_LISTENERS (JOB_NAME VARCHAR2(200) NOT NULL, JOB_GROUP VARCHAR2(200) NOT NULL, JOB_LISTENER VARCHAR2(200) NOT NULL, CONSTRAINT PK_QRTZ_JOB_LISTENERS PRIMARY KEY (JOB_NAME, JOB_GROUP, JOB_LISTENER));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::4::kbtaylor::(Checksum: 3:024e9f79a729d3787b12ca7f24417df9)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_TRIGGERS (TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, JOB_NAME VARCHAR2(200) NOT NULL, JOB_GROUP VARCHAR2(200) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, DESCRIPTION VARCHAR2(250), NEXT_FIRE_TIME DECIMAL(13,0), PREV_FIRE_TIME DECIMAL(13,0), PRIORITY DECIMAL(13,0), TRIGGER_STATE VARCHAR2(16) NOT NULL, TRIGGER_TYPE VARCHAR2(8) NOT NULL, START_TIME DECIMAL(13,0) NOT NULL, END_TIME DECIMAL(13,0), CALENDAR_NAME VARCHAR2(200), MISFIRE_INSTR DECIMAL(2,0), JOB_DATA BLOB, CONSTRAINT PK_QRTZ_TRIGGERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::5::kbtaylor::(Checksum: 3:b2a5f32227a1f38c63df291959c2008b)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_SIMPLE_TRIGGERS (TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, REPEAT_COUNT DECIMAL(7,0) NOT NULL, REPEAT_INTERVAL DECIMAL(12,0) NOT NULL, TIMES_TRIGGERED DECIMAL(10,0) NOT NULL, CONSTRAINT PK_QRTZ_SIMPLE_TRIGGERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::6::kbtaylor::(Checksum: 3:557af6b7d712cd88f340b9c84abd1551)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_CRON_TRIGGERS (TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, CRON_EXPRESSION VARCHAR2(120) NOT NULL, TIME_ZONE_ID VARCHAR2(80), CONSTRAINT PK_QRTZ_CRON_TRIGGERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::7::kbtaylor::(Checksum: 3:015ab996cb1cddd917402ebb77f6f819)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_BLOB_TRIGGERS (TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, BLOB_DATA BLOB, CONSTRAINT PK_QRTZ_BLOB_TRIGGERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::8::kbtaylor::(Checksum: 3:6a816ae547af29121803bfeaf35f94e9)
  CREATE TABLE QRTZ_TRIGGER_LISTENERS (TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, TRIGGER_LISTENER VARCHAR2(200) NOT NULL, CONSTRAINT PK_QRTZ_TRIGGER_LISTENERS PRIMARY KEY (TRIGGER_NAME, TRIGGER_GROUP, TRIGGER_LISTENER));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::9::kbtaylor::(Checksum: 3:cfabbdadbac48b78c0dc83ed2335bba7)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_CALENDARS (CALENDAR_NAME VARCHAR2(200) NOT NULL, CALENDAR BLOB NOT NULL, CONSTRAINT PK_QRTZ_CALENDARS PRIMARY KEY (CALENDAR_NAME));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::10::kbtaylor::(Checksum: 3:0cf13b1c7652122de28ca1bcc5949b95)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_PAUSED_TRIGGER_GRPS (TRIGGER_GROUP VARCHAR2(200) NOT NULL, CONSTRAINT PK_QRTZ_PAUSED_TRIGGER_GRPS PRIMARY KEY (TRIGGER_GROUP));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::11::kbtaylor::(Checksum: 3:c53e31a42f4f91fdcb8439b641dbec5e)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_FIRED_TRIGGERS (ENTRY_ID VARCHAR2(95) DEFAULT '' NOT NULL, TRIGGER_NAME VARCHAR2(200) NOT NULL, TRIGGER_GROUP VARCHAR2(200) NOT NULL, IS_VOLATILE VARCHAR2(1) NOT NULL, INSTANCE_NAME VARCHAR2(200) NOT NULL, FIRED_TIME DECIMAL(13,0) NOT NULL, PRIORITY DECIMAL(13,0) NOT NULL, STATE VARCHAR2(16) NOT NULL, JOB_NAME VARCHAR2(200), JOB_GROUP VARCHAR2(200), IS_STATEFUL VARCHAR2(1), REQUESTS_RECOVERY VARCHAR2(1), CONSTRAINT PK_QRTZ_FIRED_TRIGGERS PRIMARY KEY (ENTRY_ID));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::12::kbtaylor::(Checksum: 3:4e60726aa7ffac74297f1a93bc792cd0)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE TABLE QRTZ_SCHEDULER_STATE (INSTANCE_NAME VARCHAR2(200) NOT NULL, LAST_CHECKIN_TIME DECIMAL(13,0) NOT NULL, CHECKIN_INTERVAL DECIMAL(13,0) NOT NULL, CONSTRAINT PK_QRTZ_SCHEDULER_STATE PRIMARY KEY (INSTANCE_NAME));
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::13::kbtaylor::(Checksum: 3:6fe69e56caf3881985a622793fe75984)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  ALTER TABLE QRTZ_JOB_LISTENERS ADD CONSTRAINT QRTZ_JOB_LISTENERS_FK1 FOREIGN KEY (JOB_NAME, JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP);
  
  ALTER TABLE QRTZ_TRIGGERS ADD CONSTRAINT QRTZ_TRIGGERS_FK1 FOREIGN KEY (JOB_NAME, JOB_GROUP) REFERENCES QRTZ_JOB_DETAILS (JOB_NAME, JOB_GROUP);
  
  ALTER TABLE QRTZ_SIMPLE_TRIGGERS ADD CONSTRAINT QRTZ_SIMPLE_TRIGGERS_FK1 FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP);
  
  ALTER TABLE QRTZ_CRON_TRIGGERS ADD CONSTRAINT QRTZ_CRON_TRIGGERS_FK1 FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP);
  
  ALTER TABLE QRTZ_BLOB_TRIGGERS ADD CONSTRAINT QRTZ_BLOB_TRIGGERS_FK1 FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP);
  
  ALTER TABLE QRTZ_TRIGGER_LISTENERS ADD CONSTRAINT QRTZ_TRIGGER_LISTENERS_FK1 FOREIGN KEY (TRIGGER_NAME, TRIGGER_GROUP) REFERENCES QRTZ_TRIGGERS (TRIGGER_NAME, TRIGGER_GROUP);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181258.xml::14::kbtaylor::(Checksum: 3:1eef8f7becf9080ef26ee4bc11931066)
  -- KPME-2184: Updating Quartz tables to 1.8.4 standards
  CREATE INDEX IDX_QRTZ_J_REQ_RECOVERY ON QRTZ_JOB_DETAILS(REQUESTS_RECOVERY);
  
  CREATE INDEX IDX_QRTZ_T_NEXT_FIRE_TIME ON QRTZ_TRIGGERS(NEXT_FIRE_TIME);
  
  CREATE INDEX IDX_QRTZ_T_STATE ON QRTZ_TRIGGERS(TRIGGER_STATE);
  
  CREATE INDEX IDX_QRTZ_T_NFT_ST ON QRTZ_TRIGGERS(NEXT_FIRE_TIME, TRIGGER_STATE);
  
  CREATE INDEX IDX_QRTZ_T_VOLATILE ON QRTZ_TRIGGERS(IS_VOLATILE);
  
  CREATE INDEX IDX_QRTZ_FT_TRIG_NAME ON QRTZ_FIRED_TRIGGERS(TRIGGER_NAME);
  
  CREATE INDEX IDX_QRTZ_FT_TRIG_GROUP ON QRTZ_FIRED_TRIGGERS(TRIGGER_GROUP);
  
  CREATE INDEX IDX_QRTZ_FT_TRIG_NM_GP ON QRTZ_FIRED_TRIGGERS(TRIGGER_NAME, TRIGGER_GROUP);
  
  CREATE INDEX IDX_QRTZ_FT_TRIG_VOLATILE ON QRTZ_FIRED_TRIGGERS(IS_VOLATILE);
  
  CREATE INDEX IDX_QRTZ_FT_TRIG_INST_NAME ON QRTZ_FIRED_TRIGGERS(INSTANCE_NAME);
  
  CREATE INDEX IDX_QRTZ_FT_JOB_NAME ON QRTZ_FIRED_TRIGGERS(JOB_NAME);
  
  CREATE INDEX IDX_QRTZ_FT_JOB_GROUP ON QRTZ_FIRED_TRIGGERS(JOB_GROUP);
  
  CREATE INDEX IDX_QRTZ_FT_JOB_STATEFUL ON QRTZ_FIRED_TRIGGERS(IS_STATEFUL);
  
  CREATE INDEX IDX_QRTZ_FT_JOB_REQ_RECOVERY ON QRTZ_FIRED_TRIGGERS(REQUESTS_RECOVERY);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302181500.xml::1::dgodfrey::(Checksum: 3:0b9f5e55bf8a529800a7a9679ff3ecb8)
  ALTER TABLE LM_LEAVE_PAYOUT_T ADD STATUS VARCHAR2(1);
  
  -- Changeset src/main/config/db/1.5.0/db.changelog-201302191135.xml::1::dgodfrey::(Checksum: 3:346d6a0ff6cac13c0bb657d4e1514c93)
  ALTER TABLE LM_LEAVE_BLOCK_T ADD TRANS_DOC_ID VARCHAR2(40);
  