Agent Based Dashboard

Tables (7)

CSAT (raw1)

  • survey_create_dt (Field)
  • inquiry_id (Field2)
  • survey_score (Field3)
  • is_dissatisfied_agent (Field4)
  • inquiry_category_kor1 (Field5)
  • inquiry_category_kor2 (Field6)
  • media_type_code (Field7)
  • Field8
  • Field9

Contact Category (CopyOfraw4)

  • categorycode (category_code) — Primary key
  • categoryid (category_id)
  • fullname (category_fullname)
  • categorylevel (Field3)

Counie Agent List (CopyOfUntitled)

  • Agent ID (Agent_ID) — Primary key — NOT NULL
  • 소속 (Group)
  • 팀 (Team)
  • 업무 (Work_type)
  • 기수 (Wave)
  • 직무 (Job_type)
  • Field5
  • Field6

OSP Agent List (Untitled)

  • Agent ID (Agent_ID) — Primary key — NOT NULL
  • 센터 (CSAO)
  • 사이트 (site)
  • 소속 채널 (Channel(소속))
  • 투입 채널 (Channel(투입))
  • 직무 (직무 소분류)
  • 소속 팀 (팀)
  • 쿠팡 업무 시작일 (쿠팡업무 시작일)
  • 쿠팡 업무 종료일
  • Field9

Operation Data (raw3)

  • Field
  • Field2
  • Field3
  • Field4

QA Evaluation (raw2)

  • Field
  • Field2
  • Field3
  • Field4
  • Field5

Training Results (raw4)

  • Agent ID (Agent_ID) — Primary key
  • 교육명 (Training_name) — Primary key
  • categorycode (category_code) — Foreign key → Contact Category.categorycode
  • Month
  • Week
  • 교육 방법 (Training_method)
  • 교육 소요시간 (Training_time)
  • 교육 시작일 (Training_start)
  • 교육 종료일 (Training_end)
  • 교육 이수여부 (Training_complete)