KB-EVAL
Tables (15)
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled (T_EVAL_CALL_RESULT)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (SID) — BIGINT — Primary key — NOT NULL — 콜 ID
- Key2 (DBS_ID) — INT — Primary key — NOT NULL — DBS ID
- Key3 (FORM_REVISION_ID) — INT — Primary key — NOT NULL — 폼 ID
- Key4 (SCORED_BY_NO_AGENT) — CHAR(7) — Primary key — NOT NULL — 평가자 사번
- Field3 (IDX_PLAN_MASTER) — BIGINT — NOT NULL — 평가계획 IDX
- Field (EV_ROUND) — INT — NOT NULL — 평가차수
- Field (LOCAL_START_TIME) — DATETIME — 상담시작일자
- Field (LOCAL_DATE_SCORED) — DATETIME — 평가일자
- Field (OVERALL_SCORE) — NUMERIC(7,2) — 총점
- Field (USER_ID) — INT — 상담사 ID
- Field (USER_NAME) — VARCHAR(50) — 상담사명
- Field (WINNT_LOGIN) — CHAR(7) — 상담사 사번
- Field (FORM_COMMENTS) — VARCHAR(600) — 총평
- Field (P1_VALUE) — VARCHR(128)
- Field (P2_VALUE) — VAWRCHAR(128)
- Field (P3_VALUE) — VARCHAR(128)
- Field (P4_VALUE) — VARCHAR(128)
- Field (P5_VALUE) — VARCHAR(128)
- Field (P6_VALUE) — VARCHAR(128)
- Field (P7_VALUE) — VARCHAR(128)
- Field (P8_VALUE) — VARCHAR(128)
- Field (P9_VALUE) — VARCHAR(128)
- Field (P10_VALUE) — VARCHAR(128)
- Field (P11_VALUE) — VARCHAR(128)
- Field (P12_VALUE) — VARCHAR(128)
- Field (P13_VALUE) — VARCHAR(128)
- Field (P14_VALUE) — VARCHAR(128)
- Field (P15_VALUE) — VARCHAR(128)
- Field (P16_VALUE) — VARCHAR(128)
- Field (P17_VALUE) — VARCHAR(128)
- Field (P18_VALUE) — VARCHAR(128)
- Field (P19_VALUE) — VARCHAR(128)
- Field (P20_VALUE) — VARCHAR(128)
- Field (P21_VALUE) — VARCHAR(128)
- Field (P22_VALUE) — VARCHAR(128)
- Field (P23_VALUE) — VARCHAR(128)
- Field (P24_VALUE) — VARCHAR(128)
- Field (P25_VALUE) — VARCHAR(128)
- Field (RSLTREFDIV) — NCHAR(1)
- Field (SCORED_BY) — INT — 평가자
- Field (FORM_TITLE) — VARCHAR(1024) — 폼 타이틀
- Field (SCORED_ID) — INT
Copy Of Copy Of Copy Of Copy Of Copy Of Untitled2 (T_EVAL_CALL_RESULT_SCORE)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (SID) — BIGINT — Primary key — NOT NULL — 콜 ID
- Key2 (DBS_ID) — INT — Primary key — NOT NULL — DBS ID
- Key3 (SCORED_BY_NO_AGENT) — CHAR(7) — Primary key — NOT NULL — 평가자 사번
- Key (FORM_REVISION_ID) — INT — Primary key — NOT NULL — 폼 ID
- Field3 (SCORE_ID) — INT — NOT NULL — SCORE ID
- Field (AGENT_ID) — INT — NOT NULL — 상담사 ID
- Field (FORM_TITLE) — VARCHAR(1024) — 폼 타이틀
- Field (FORM_COMMENTS) — VARCHAR(1024) — 총평
- Field (COMMENTS) — VARCHAR(1024) — 항목 피드백
- Field (SCORE_NUMERIC_VALUE) — NUMERIC(7,2) — 평가 점수
- Field (SECTION_CAPTION) — VARCHAR(1024) — 섹션
- Field (CATEGORY_CAPTION) — VARCHAR(1024) — 카테고리
- Field (ELEMENT_CAPTION_TEXT) — VARCHAR(1024) — 엘리먼트
- Field (SUM_ATTAINED_SCORE) — NUMERIC(7,2) — 자동/수동 평가
- Field (OVERALL_SCORE) — NUMERIC(7,2) — 총점
- Field (LOCAL_DATE_SCORED) — DATETIME — 평가 일자
- Field (DT_CREATED) — DATETIME — 생성일
- Field (ELEMENT_POSSIBLE_SCORE) — NUMERIC(7,2) — 획득가능점수
- Field (ELEMENT_ID) — INT — 엘리먼트 ID
Copy Of Copy Of Copy Of Copy Of Untitled (T_EVAL_CALL)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (IDX_CALL) — BIGINT — Primary key — NOT NULL — 콜 ID
- Key (DBS_ID) — INT — Primary key — NOT NULL — DBS ID
- Key (FORM_REVISION_ID) — INT — Primary key — NOT NULL — 폼 ID
- Key (NO_AGENT_QA) — CHAR(7) — Primary key — NOT NULL — 평가자 사번
- Field3 (IDX_PLAN_MASTER) — BIGINT — NOT NULL — 평가계획 IDX
- Field (EV_ROUND) — INT — NOT NULL — 평가차수
- Field (NO_AGENT) — CHAR(7) — 상담사 사번
- Field (DS_WRITE) — DATETIME — 등록일
- Field (IS_EVAL) — INT — 평가여부
- Field (OVERALL_SCORE) — NUMERIC(7,2) — 총점
- Field (SCORE_ID) — INT — SCORE_ID
- Field (IS_MANUAL) — CHAR(1) — 자동/수동 평가
Copy Of Copy Of Copy Of Untitled (T_PLAN_ROUND_CA_ASSIGN)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (IDX_PLAN_MASTER) — BIGINT — Primary key — NOT NULL — 평가계획 IDX
- Key (EV_ROUND) — INT — Primary key — NOT NULL — 평가차수
- Field3 (NO_AGENT_QA) — CHAR(7) — NOT NULL — 평가자 사번
- Field (NO_AGENT_CA) — CHAR(7) — NOT NULL — 상담사 사번
Copy Of Copy Of Untitled (T_INSA_SKILL)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- NO_AGENT — CHAR(7) — Primary key — NOT NULL — 사번
- Field2 (CD_SKILL) — CHAR(2) — NOT NULL — 스킬코드
- Field3 (DS_SKILL) — CHAR(10) — NOT NULL — 스킬등록일
- Field (NO_WRITER) — VARCHAR(10) — NOT NULL — 등록자 사번
- Field (EV_YM) — VARCHAR(10) — 연월
Copy Of Untitled (T_PLAN_ROUND_CA)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (IDX_PLAN_MASTER) — BIGINT — Primary key — NOT NULL — 평가계획 IDX
- Key (EV_ROUND) — INT — Primary key — NOT NULL — 평가차수
- Field3 (NO_AGENT) — CHAR(7) — NOT NULL — 사번
- Field (DS_WRITE) — VARCHAR(20) — NOT NULL — 등록일
Copy Of Untitled2 (T_CALL_SEARCH_INFO)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK_AUTO_INC
- Key (IDX_PLAN_MASTER) — BIGINT — Primary key — NOT NULL — 평가계획 IDX
- Key (EV_ROUND) — INT — Primary key — NOT NULL — 평가차수
- Field (CD_CATE1) — NVARCHAR(50) — NOT NULL — 콜 타입
- Field (CD_CATE2) — NVARCHAR(50) — NOT NULL — 서브 콜타입
- Field (CD_QUEUE) — VARCHAR(2000) — NOT NULL — 큐 인입
- Field (DS_START) — VARCHAR(10) — NOT NULL — 조회 시작일
- Field (DS_END) — VARCHAR(10) — NOT NULL — 조회 종료일
- Field (DS_COUNSEL_START) — VARCHAR(10) — 상담 시작일
- Field (DS_COUNSEL_END) — VARCHAR(10) — 상담 종료일
- Field (DS_CALL_START) — VARCHAR(10) — 콜 시작 시간
- Field (DS_CALL_END) — VARCHAR(10) — 콜 종료 시간
- Field (CD_RELATION) — NVARCHAR(20) — 관계
- Field (CD_GUGUN) — NVARCHAR(30) — 구분
- Field (CD_EVAL_LARGE) — NVARCHAR(50) — 평가유형 대
- Field (CD_EVAL_MIDDLE) — NVARCHAR(50) — 평가유형 중
- Field (CD_WORK_PROCESS) — NVARCHAR(30) — 업무
- Field (CD_CALL_CHANGE) — VARCHAR(20) — 콜 전환
- Field (CD_AGE) — VARCHAR(50) — 연령
- Field (CD_SEX) — VARCHAR(50)
- Field (NM_CUSTOMER) — VARCHAR(64) — 고객명
- Field (CD_CUSTOMER) — VARCHAR(64) — 고객 코드
- Field (CD_ACCIDENT_RECEPTION) — VARCHAR(64)
- Field (CD_UNIQUE) — VARCHAR(1000)
Copy Of Untitled3 (T_CODE_WORK)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK_AUTO_INC
- Field (CD_VALUE) — VARCHAR(150) — 코드 값
T_INSA_AGENT
- NO_AGENT — CHAR(7) — Primary key — NOT NULL — 사번
- ID_AGENT — CHAR(7) — NOT NULL — AGENT ID
- ID_PORTAL — VARCHAR(30) — NOT NULL — 포탈 ID
- CD_CONSIGN_CMPY — CHAR(3) — NOT NULL — 위탁사코드
- CD_CENTER — CHAR(7) — NOT NULL — 센터코드
- CD_DEPT — CHAR(7) — NOT NULL — 부서코드
- CD_TEAM — CHAR(7) — NOT NULL — 팀코드
- CD_JOB_POSITION — CHAR(3) — NOT NULL — 직책코드
- NM_JOB_POSITION — NVARCHAR(50) — NOT NULL — 직책명
- CD_POST_POSITION — NCHAR(10) — NOT NULL — 직위코드
- NM_POST_POSITION — NCHAR(10) — NOT NULL — 직위명
- CD_AGENT_GRADE — CHAR(3) — NOT NULL — 상담사등급코드
- NM_AGENT_GRADE — NVARCHAR(30) — NOT NULL — 상담사등급명
- ST_WORKING — CHAR(1) — NOT NULL — 재직상태
- DS_WORK_START — CHAR(10) — NOT NULL — 입사일자
- DS_WORK_END — CHAR(10) — NOT NULL — 퇴사일자
- DS_WORK_PAUSE — CHAR(10) — NOT NULL — 휴직일자
- CNT_WORKING_MONTH — VARCHAR(5) — NOT NULL — 근속월수
- TY_WORKING — CHAR(1) — NOT NULL — 직원유형
- FG_RECORDING — CHAR(1) — NOT NULL — 녹음대상자여부
- FG_SA — CHAR(1) — NOT NULL — 음성분석대상자여부
- FG_AUTH_QM — CHAR(1) — QM 사용권한여부
- CD_QM_USER_GUBUN — CHAR(1) — NOT NULL — QM 사용자 구분코드
- FG_AUTH_PM — CHAR(1) — NOT NULL — PM 사용권한 여부
- CD_PM_USER_GUBUN — CHAR(1) — NOT NULL — PM 사용자 구분 코드
- DS_WRITE — VARCHAR(19) — NOT NULL — 입사일시 ???
- DS_MODIFY — VARCHAR(19) — NOT NULL — 최종수정일자
- Field (CD_SKILL) — NVARCHAR(10) — NOT NULL — 스킬코드
- Field2 (DS_SKILL) — CHAR(10) — NOT NULL — 평가자의 스킬설정일자
- Field3 (NO_REFLECT) — CHAR(1) — NOT NULL — 성과반영여부
T_INSA_GROUP
- CD_GROUP — CHAR(7) — Primary key — NOT NULL — 조직코드
- CD_GROUP_GUBUN — CHAR(1) — NOT NULL — 조직구분코드
- CD_CONSIGN_CMPY — CHAR(3) — NOT NULL — 위탁사코드
- CD_GROUP_PARENT — CHAR(7) — NOT NULL — 상위조직코드
- NM_CONSIGN_CMPY — NVARCHAR(150) — NOT NULL — 위탁사명
- NM_GROUP — NVARCHAR(150) — NOT NULL — 조직명
- FG_LEVEL — CHAR(1) — NOT NULL — 레벨정보
- NO_ORDERBY — VARCJAR(10) — NOT NULL — 정렬순서
- FG_RECORDING — CHAR(1) — NOT NULL — 녹음대상여부
- DS_OPEN — VARCHAR(10) — NOT NULL — 개설일자
- DS_CLOSE — VARCHAR(10) — NOT NULL — 폐쇄일자
- DS_WRITE — VARCHAR(19) — NOT NULL — 입력일시
- DS_MODIFY — VARCHAR(19) — NOT NULL — 변경일시
Untitled (T_EVAL_PLAN_MASTER)
- Key (IDX) — BIGINT — Primary key — NOT NULL
- Field (NO_AGENT) — CHAR(7) — NOT NULL — 등록자 사번
- Field2 (EV_NAME) — varchar(150) — NOT NULL — 평가계획명
- Field3 (EV_YM) — CHAR(7) — NOT NULL — 평가 연.월
- Field4 (EV_KIND) — CHAR(1) — NOT NULL — 평가구분
- Field5 (EV_TASK) — CHAR(1) — NOT NULL — 평가업무
- Field6 (EV_ROUND) — TINYINT — NOT NULL — 최대차수
- Field (EV_ACHIEVED) — CHAR(1) — NOT NULL — 업적반영
- Field (EV_USE) — CHAR(1) — NOT NULL — 사용여부
- Field (EV_SUBJECT) — VARCHAR(250) — NOT NULL — 평가주제
- Field (EV_CRETERIA) — TEXT — NOT NULL — 평가기준
- Field (DS_DATE) — VARCHAR(20) — NOT NULL — 등록일
Untitled (T_SIMPLE_PLAN_AGENT)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK, AUTO_INC
- NO_AGENT (ID_QA) — CHAR(7) — Primary key — NOT NULL — 사번
- NO_AGENT (ID_AGENT) — CHAR(7) — Primary key — NOT NULL — 사번
- Field4 (ID_WRITER) — CHAR(7) — NOT NULL — 등록자 사번
- Field5 (DS_WRITE) — VARCHAR(20) — NOT NULL — 등록일자
- Field (IDX_PLAN_MASTER) — BIGINT — NOT NULL — 평가계획 IDX
Untitled (T_PLAN_ROUND_BASIC)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK, AUTO_INC
- Key (IDX_PLAN_MASTER) — BIGINT — Primary key — NOT NULL — 평가계획 IDX
- Field2 (EV_ROUND) — TINYINT — NOT NULL — 차수
- Field3 (DS_ROUND_START) — VARCHAR(10) — NOT NULL — 차수 시작일
- Field4 (DS_ROUND_END) — VARCHAR(10) — NOT NULL — 차수 종료일
- Field5 (NO_RATE) — TINYINT — NOT NULL — 성과반영비율
- Field6 (EV_FORM1) — VARCHAR(10) — NOT NULL — 평가폼 1
- Field (EV_FORM2) — VARCHAR(10) — NOT NULL — 평가폼2
- Field (CD_SKILL) — NVARCHAR(10) — NOT NULL — 스킬 코드
- Field (DS_WRITE) — VARCHAR(20) — NOT NULL — 등록일
Untitled (T_PLAN_ROUND_QA)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK,AUTO_INC
- Key (IDX_PLAN_MASTER) — BIGINT — Primary key — NOT NULL — 평가계획 IDX
- Key (EV_ROUND) — INT — Primary key — NOT NULL — 평가차수
- Field3 (NO_AGENT) — CHAR(7) — NOT NULL — 사번
- Field4 (NO_ASSIGN_CNT) — SMALLINT — NOT NULL — 할당건수
- Field (DS_WRITE) — VARCHAR(20) — NOT NULL — 등록일
Untitled (T_CODE)
- Key (IDX) — BIGINT — Primary key — NOT NULL — PK_AUTO_INC
- Field (CD_TYPE) — VARCHAR(20) — NOT NULL — 코드 타입
- Field (CD_KEY) — VARCHAR(20) — NOT NULL — 코드 키
- Field (CD_VALUE) — VARCHAR(5) — NOT NULL — 코드 값
- Field (NO_ORDER) — INT — NOT NULL — 정렬번호
- Field (COMMENT) — VARCHAR(50) — NOT NULL — 설명
- Field (CD_PARENT) — VARCHAR(50) — 부모 코드
- Field (NO_LEVEL) — TINYINT — 레벨