Release History

Data format is : YYYY-MM-DD

Version format is : major.minor.patch

2.1.7 Released ( 2015-06-10 )

MASTER ACCESS API 버그 패치 및 요청사항

1. 업무 기준 API 사용시 잘못된 결과의 출력 버그 수정.

2. 업무 기준 API 사용시 조건에 만족한 결과가 복수의 결과를 리턴 할수 있도록 수정.

3. 업무기준의 비교 연산( <, <=, >, >=, <= BETWEEN <=, < BETWEEN <=, <= BETWEEN <, < BETWEEN < )시 입력값이 null,""에 대해서 return값을 false 처리 하도록 하였음.

4. 업무 기준의 비교 연산시 not between과 between문의 잘못된 Number 체크 및 초기화로 버그 수정.

MASTER MANGER 개선 사항

1. 업무 기준 데이터 화면에서의 예외처리 ROW에 대한 이상 결과 수정.

2. 표준항목과 표준용어 약어 column SIZE 변경 ( 10 -> 100)

패치 적용시 필수 작업

Glue master version 2.1.6 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요.

    ALTER TABLE STANDARD_GLOSSARY_ITEM MODIFY( STD_ABBR VARCHAR2( 100 ));

2.1.6 Released ( 2015-05-29 )

화면 UI의 DHTMLX 4.1.3로 Upgrade(IE10 대응)

MSSQL을 사용 가능 하도록 SQL 추가 적용

GlueMaster.properties에 적용 방법

    manager.querypath=query/mssql
    access.querypath=access-query/mssql

DATABASE의 Column의 SIZE 변경

    MASTER COMMON ID(MC_ID,BR_ID,CR_ID,IF_ID) 의 사이즈 변경(20 -> 60)
    표준명칭(STD_NM)의 사이즈 변경(60 -> 100)
    다국어 명칭,동의어1,2,3(GLOBAL_NM,SYNM1,SYNM1,SYNM1)의 사이즈 변경 (30 -> 100)

패치 적용시 필수 작업

Glue master version 2.1.5 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요.

    ALTER TABLE BUSINESS_RULE_DATA MODIFY( BR_ID VARCHAR2( 60 ));
    ALTER TABLE BUSINESS_RULE_LAYOUT MODIFY( BR_ID VARCHAR2( 60 ));
    ALTER TABLE BUSINESS_RULE_LAYOUT MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE CALCULATION_FORMULA MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_FACTOR MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_ITEM MODIFY( CR_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( GLOBAL_NM VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM1 VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM2 VARCHAR2( 100 ));
    ALTER TABLE GLOBAL_GLOSSARY_ITEM MODIFY( SYNM3 VARCHAR2( 100 ));
    ALTER TABLE INTERFACE_TC_CHECK MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_TC MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_LAYOUT MODIFY( IF_ID VARCHAR2( 60 ));
    ALTER TABLE INTERFACE_LAYOUT MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE MASTER_CODE_CATEGORY MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_CODE_ITEM MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_CODE_ITEM MODIFY( ITEM_NM VARCHAR2( 100 ));
    ALTER TABLE MASTER_COMMON MODIFY( CM_ID VARCHAR2( 60 ));
    ALTER TABLE MASTER_COMMON MODIFY( CM_NM VARCHAR2( 100 ));
    ALTER TABLE STANDARD_GLOSSARY_ITEM MODIFY( STD_NM VARCHAR2( 100 ));
    ALTER TABLE TRANSACTION_CODE MODIFY( MC_ID VARCHAR2( 60 ));
    ALTER TABLE CALCULATION_INOUT MODIFY( CR_ID VARCHAR2( 60 ));

2.1.5 Released ( 2015-01-30 )

MYSQL을 사용 가능 하도록 SQL 추가 적용

GlueMaster.properties에 적용 방법

    manager.querypath=query/mysql
    access.querypath=access-query/mysql

[Masterdata 이행]화면 PasgeSet기능 추가

2.1.4 Released ( 2014-12-31 )

측정관리 화면의 다국어 오류에 대한 대응 - 측정관리 테이블(UNIT_OF_MEASURE) 의 LANG_CD column의 PRIMARY KEY 추가

설정 (패치 적용시 필수 작업)

UNIT_OF_MEASURE 테이블 (필수 Data) - (oracle base)

  1. alter table UNIT_OF_MEASURE drop primary key;
  
  2. alter table UNIT_OF_MEASURE add CONSTRAINT UNIT_OF_MEASURE_PK primary key(UOM_NM, LANG_CD);

2.1.3 Released ( 2014-11-28 )

Glue Core version 변경

  - Glue Core 4.2.2-RELEASE -> Glue Core 4.2.3-RELEASE 변경

PPAS(Postgres Plus Advanced Server)를 위한 내부 변경

  - PPAS 관련 SQL 추가
  
  - Page Set 관련 정보 추가

IE 10 호환성 보기 대응

  - 표준용어 화면의 조회 조건의 타이틀 밑으로 내려가는 현상 수정
  
  - 표준아이템 검색 팝업 화면의 타이틀 및으로 내려가는 현상 수정
  
  - 사용자 설정 화면의 깨지는 현상 수정 
 
  - 표준용어, 표준항목, 마스터코드, 트랜잭션코드,업무기준, 계산수식, 인터페이스포맷 
     이력 관리 화면 등의 날짜 출력 부분에서의 오류 수정.

다국적언어를 위한 중국어 대응

  - GMResource_zh_CN.properties의 추가
    (Common data의 미적용)

기타 수정 및 추가 사항

  - site 문서화 자료 추가
  
  - TRANSACTION CODE의 IMPORT 할때 누락한 SQL문 추가  
  
  - Access 수정 : 계산수식 공식 미등록시 정상처리 되는 오류 수정 
  
  - Access 수정 : System.out.println() 출력 부분 삭제 

2.1.2 Released ( 2014-09-15 )

표준 용어 및 표준 항목의 이름, ID의 입력, 수정 UI, SIZE 변경.

 - 표준항목관리, 표준용어관리 Popup의 [이름],[ID]의 UI Size 10 -> 60 확장(표준용어ID DB Size 확장)
 
 - 표준항목관리, 표준용어관리 Popup의 View SIZE의 확장
 
 - 표준용어의 ID의 NULL Check에서 제외
 
 - 표준용어, IMPORT(표준용어)에 대상의 표준용어 ID의 NULL 입력시 표준용어이름과 동일한 내용으로 ID입력

패치 적용시 필수 작업

Glue master version 2.1.1 이하 버전 사용시 필요한 아래 DataBase script(oracle base)를 실행 해주세요.

  alter table STANDARD_GLOSSARY_ITEM modify STD_ID varchar2(60);

2.1.1 Released ( 2013-08-04 )

기능 추가

이력 기능 추가

업무 화면에서 DataBase에 추가(insert), 수정(update), 삭제(delete) 처리에 대해서
이력을 관리 하며 해당 관리Data를 엑셀 파일로 Export 가능하다.

화면 사용 가이드

Master 이력 사용자 가이드

설정 (패치 적용시 필수 작업)

GlueMaster.properties(선택)

    #Is Master History( true-이력 사용함, false-이력 사용 안함(Default) )
    manager.ismasterhistory=true

DataBase Table Script(필수) - (oracle base)

-- 마스터 이력 항목
CREATE TABLE MASTER_BUSINESS_HISTORY
(
    -- 업무구분
    BIZ_TYPE VARCHAR2(10) NOT NULL,
    -- 이력구분
    HIS_TYPE VARCHAR2(10) NOT NULL,
    -- SQL 쿼리 ID
    SQL_QUERY_ID VARCHAR2(100) NOT NULL,
    -- SQL 쿼리 파라메터
    SQL_QUERY_PARAMETER VARCHAR2(4000) NOT NULL,
    -- 생성자
    CREATE_ID VARCHAR2(20) NOT NULL,
    -- 생성일시
    CREATE_TSMP TIMESTAMP NOT NULL,
);

Common Data(필수 Data) - (oracle base)

Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','Business Type','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','업무 구분','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','History Type','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','이력 구분','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

Common Data Detail(필수 Data) - (oracle base)

Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SG','표준용어',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SI','표준항목',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','SM','표준메시지',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','MC','마스터코드',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','TC','트랜잭션코드',5,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','BR','업무기준',6,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','CR','계산수식',7,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IF','인터페이스포맷',8,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IT','인터페이스전문',9,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','UM','사용자관리',10,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','LM','언어관리',11,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','CM','공통코드관리',12,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','MM','측정단위관리',13,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','RM','권한그룹관리',14,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','IM','Export/Import',15,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','ko_KR','AM','Access관리',16,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SG','standard glossaries',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SI','standard items',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','SM','standard messages',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','MC','master codes',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','TC','Transaction codes',5,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','BR','business rules',6,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','CR','calculation rules',7,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IF','interface formats',8,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IT','interface TCs',9,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','UM','master users',10,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','LM','language codes',11,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','CM','common codes',12,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','MM','unit of measures',13,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','RM','respansibilities',14,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','IM','export/import',15,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_BUSINESS_TYPE','en_US','AM','master access',16,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','CT','추가',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','UT','수정',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','ko_KR','DT','삭제',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','CT','create',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','UT','update',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('MASTER_HISTORY_TYPE','en_US','DT','delete',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

사용자 설정 추가(날짜 표현 포맷 변경)

사용자의 원하는 날짜 포맷으로 화면에 출력 할수 있도록 설정 한다.

설정 (패치 적용시 필수 작업)

Common Data(필수 Data) - (oracle base)

Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','Date Format','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE (CD_NM,LANG_CD,CD_DESC,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','날짜 포멧','gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

Common Data Detail(필수 Data) - (oracle base)

Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','SD','yyyy/mm/dd HH:MM',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','DT','mm/dd/yyyy HH:MM',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','HD','yyyy-mm-dd HH:MM',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','ko_KR','HM','mm-dd-yyyy HH:MM',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','SD','yyyy/mm/dd HH:MM',1,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','DT','mm/dd/yyyy HH:MM',2,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','HD','yyyy-mm-dd HH:MM',3,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);
Insert into COMMON_CODE_DETAIL (CD_NM,LANG_CD,CD_VAL,VAL_DESC,SORT_SEQ,CREATE_ID,CREATE_TSMP,MODIFY_ID,MODIFY_TSMP) values ('DATE_FORMAT','en_US','HM','mm-dd-yyyy HH:MM',4,'gluemast',CURRENT_TIMESTAMP,'gluemast',CURRENT_TIMESTAMP);

2.1.0 Released ( 2014-04-28 )

  • initial version.