Release History

Data format is : YYYY-MM-DD

Version format is : major.minor.patch

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.