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 — 레벨