obzen_outcome_table

Tables (12)

C_CD_MNG (마케팅 공통코드)

  • CDM_CD (공통코드) — VARCHAR2(64) — Primary key — NOT NULL
  • CDM_TY (공통코드유형) — VARCHAR2(8)
  • CULTURE (언어코드) — VARCHAR2(16)
  • CDM_TY_NM (공통코드유형명) — VARCHAR2(95)
  • CDM_CD_NM (공통코드명) — VARCHAR2(95)
  • CDM_USE_DSTIC_CD (공통코드사용여부) — VARCHAR2(8)
  • CDM_NM1 (TEMP명1) — VARCHAR2(150)
  • CDM_CD1 (TEMP코드1) — VARCHAR2(100)
  • CDM_MODI_EMP (수정사원번호) — VARCHAR2(16)
  • CDM_MODI_DT (수정일시) — VARCHAR2(20)
  • CDM_DESC (코드설명) — VARCHAR2(385)
  • CDM_FLD1 (코드필드1) — VARCHAR2(2000)
  • CDM_FLD2 (코드필드2) — VARCHAR2(2000)

C_CHAN (채널매체)

  • CHAN_CD (채널코드) — VARCHAR2(8) — Primary key — NOT NULL
  • CHAN_TY (채널종류) — VARCHAR2(2)
  • TEMPLATE_NM (템플릿리소스명) — VARCHAR2(128)
  • RESOURCE_NM (리소스명) — VARCHAR2(128)
  • CHAN_DSTIC_CD (채널사용구분코드) — VARCHAR2(8)
  • SCRT_PSNL_RPLC_YN (스크립트개인화치환여부) — CHAR(1)
  • CHAN_RSNAL_AMT (채널매체개별단가) — NUMBER(16,0)
  • TEM_APL_YN (기간적용여부) — CHAR(1)
  • CHAN_EX_CAPA (채널수행용량) — NUMBER
  • SCRT_REG_SIZE (스크립트등록사이즈) — NUMBER
  • SMP_CAMP_FRAME_PATH (심플캠페인프레임경로) — VARCHAR2(256)
  • CHAN_TRNS_TEM (채널전송기간) — NUMBER
  • REBM_CHAN_QUEUE_NM (REBM채널큐명) — VARCHAR2(32)
  • BBRN_USE_YN (영업점사용여부) — CHAR(1)
  • SCRT_FRAME_PATH (스크립트프레임경로) — VARCHAR2(512)
  • PRNT_SEQNO (출력순서) — NUMBER
  • IMG_MNG_ID (이미지관리ID) — VARCHAR2(24)
  • CHAN_SMP_MSG (채널간략메시지) — VARCHAR2(128)
  • CHANIF_NM (채널인터페이스이름) — VARCHAR2(10)
  • CHAN_MODI_EMP (수정사원번호) — VARCHAR2(16)
  • CHAN_MODI_DT (최종수정일시) — VARCHAR2(20)
  • CONT_RSRCT_TEM (접촉제한기간) — NUMBER
  • CONT_RSRCT_CNT (접촉제한회수) — NUMBER
  • TRNS_CRAT_TM (전송데이터생성시간) — VARCHAR2(8)
  • WORK_DT_APL_YN (영업일적용여부) — CHAR(1)
  • REBM_DT_RSRCT_CNT (REBM일별제한회수) — NUMBER
  • REBM_TRNS_STR_TM (REBM전송시작시간) — VARCHAR2(4)
  • REBM_TRNS_END_TM (REBM전송종료시간) — VARCHAR2(4)
  • REBM_EX_USE_YN (REBM 수행채널 사용여부) — CHAR(1)
  • TEBM_EX_USE_YN (Time-Gap EBM 수행채널 사용여부) — CHAR(1)
  • DDMA_PROC_ID (DDMA프로세스식별자) — VARCHAR2(16)
  • REBM_PSNL_RPLC_YN (REBM개인화치환여부) — CHAR(1)
  • CHAN_DT_INPUT_CD (채널일자입력구분코드) — VARCHAR2(8)

C_CUST_CONT_HIST (고객접촉이력)

  • CUST_ID (Key) — VARCHAR2(15) — Primary key — NOT NULL
  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
  • REBM_DETECT_ID (실시간EBM검출식별자) — NUMBER(20,0)
  • EX_CAMP_ID (수행캠페인 ID) — VARCHAR2(24)
  • CONT_CHAN_DIV_CD (고객 접촉 채널) — VARCHAR2(5)
  • CONT_WRK_DIV_CD (채널 결과코드) — VARCHAR2(2)
  • AGNT_SND_DT (채널 AGENT에 전송된 시각) — VARCHAR2(14)
  • AGNT_SND_CD (채널 AGENT에 전송된 결과코드) — VARCHAR2(5)
  • SND_RSLT_DIV_CD (고객수신코드(노출여부)) — VARCHAR2(1)
  • CONT_RSLT_DIV_CD (수신접촉 결과코드(클릭여부)) — VARCHAR2(4)
  • RECV_DT (고객수신시간(노출일시)) — DATE
  • RETN_DT (고객으로부터 회송된 시간) — DATE
  • OPN_DT (고객으로부터 OPEN된 시간(클릭일시)) — DATE
  • CONT_DEPT_CD (고객접촉 부서ID) — VARCHAR2(5)
  • CONT_EMP_NO (고객접촉 직원ID) — VARCHAR2(10)
  • CONT_TXT (고객접촉 내용 요약) — VARCHAR2(512)
  • UPD_DTM (최종 UPDATE시간) — VARCHAR2(14)

C_EX_ACT (수행활동고객목록)

  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Primary key — NOT NULL
  • EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24) — Foreign key → C_EX_CAMP.EX_CAMP_ID — NOT NULL
  • ACT_ID (캠페인활동식별자) — VARCHAR2(24)
  • EX_ACT_STAT (캠페인활동상태) — VARCHAR2(8)
  • EX_ACT_STR_DT (시작일자) — VARCHAR2(10) — NOT NULL
  • EX_ACT_END_DT (종료일자) — VARCHAR2(10)
  • CHAN_TRNS_CUSTG_CNT (채널전송고객수) — NUMBER(16,0)
  • EX_ACT_LST_INPUT_DT (최종입력일시) — VARCHAR2(1)
  • EA_WORK_DT (작업일) — VARCHAR2(10)
  • EA_WORK_EX_YN (작업수행여부) — VARCHAR2(1)
  • CHAN_CD (채널코드) — VARCHAR2(8)
  • EX_STEP_ID (수행캠페인단계식별자) — VARCHAR2(24)
  • STEP_LEVEL (단계레벨) — NUMBER(38,0)
  • EX_ACT_CRAT_STR_DTM (생성 시작일시) — VARCHAR2(20)
  • EX_ACT_CRAT_END_DTM (생성 종료일시) — VARCHAR2(20)
  • EX_ACT_CRAT_TERM (생성소요시간) — NUMBER(10,0)
  • PSNL_SCRT_CRAT_CD (개인화스크립트생성코드) — VARCHAR2(15)

C_EX_ACT_CUST_LIST (수행활동별개인화목록)

  • CUST_ID (고객번호) — VARCHAR2(32) — Primary key — NOT NULL
  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
  • EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24)
  • CAMP_BRCH (캠페인유형코드) — VARCHAR2(8)
  • CAMP_EX_SYS (캠페인수행시스템) — VARCHAR2(8)
  • CHAN_CD (채널코드) — VARCHAR2(8) — NOT NULL
  • WORK_DT (작업일) — VARCHAR2(8)
  • SEGM_ID (세그먼트식별자) — VARCHAR2(24)
  • CONT_SET_YN (대조군여부) — VARCHAR2(1)
  • CHAN_BRCH_CD (채널분류코드) — VARCHAR2(8)
  • FATG_USE_YN (퍼티그사용여부) — VARCHAR2(1)
  • ACT_ID (캠페인활동식별자) — VARCHAR2(24)
  • CUST_ID_INFO1 (고객식별자 정보1) — VARCHAR2(32)
  • CUST_ID_INFO2 (고객식별자 정보2) — VARCHAR2(32)
  • CUST_ID_INFO3 (고객식별자 정보3) — VARCHAR2(32)

C_EX_ACT_SCRT (수행캠페인활동스크립트)

  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Primary key — NOT NULL
  • SCRT_ID (스크립트식별자) — VARCHAR2(16)
  • EAS_WORK_DT (작업일) — VARCHAR2(10)
  • EAS_WORK_EX_YN (작업수행여부) — CHAR(1)

C_EX_CAMP (수행캠페인)

  • EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24) — Primary key — NOT NULL
  • CAMP_ID (캠페인식별자) — VARCHAR2(24)
  • EX_CAMP_NM (수행캠페인명) — VARCHAR2(16)
  • EX_CAMP_STAT (수행캠페인상태) — VARCHAR2(195)
  • CAMP_EX_TY (캠페인실행유형코드) — VARCHAR2(8)
  • CAMP_KIND (기획그룹종류) — VARCHAR2(8)
  • FRST_BRCH_CD (캠페인제1유형코드) — VARCHAR2(8)
  • SCND_BRCH_CD (캠페인제2유형코드) — VARCHAR2(8)
  • CAMP_BRCH (캠페인유형) — VARCHAR2(8)
  • EX_CAMP_STR_DT (수행시작일자) — VARCHAR2(8)
  • EX_CAMP_END_DT (수행종료일자) — VARCHAR2(10)
  • EC_WORK_DT (작업일) — VARCHAR2(10)
  • EC_WORK_EX_YN (작업수행여부) — VARCHAR2(10)
  • EX_CAMP_VALID_STR_DT (수행유효시작일) — CHAR(1)
  • EX_CAMP_VALID_DT (수행유효일자) — VARCHAR2(10)
  • CAMP_PRITY (캠페인우선순위) — VARCHAR2(10)
  • CAMP_DRFT_DEPT (캠페인기안부서코드) — NUMBER(38,0)
  • CAMP_DRFT_EMP (캠페인기안사원번호) — VARCHAR2(16)
  • CAMP_INV_ID (캠페인Inv식별자) — VARCHAR2(16)
  • CAMP_INV_KIND_CD (기획방법종류코드) — VARCHAR2(16)
  • CAMP_BZWK_DSTIC (캠페인업무구분) — VARCHAR2(8)
  • CAMP_DETSUBJ_CD (캠페인세부주제코드) — VARCHAR2(8)
  • TEST_EX_YN (테스트수행여부) — CHAR(1)
  • CAMP_PLAN_WORK_SYS (캠페인기획작업시스템) — VARCHAR2(8)
  • CAMP_EX_SYS (수행시스템) — VARCHAR2(8)
  • EX_CAMP_BACKUP_YN (수행캠페인백업여부) — CHAR(1)
  • SYS_AR_CD (시스템영역코드) — VARCHAR2(8)
  • CAMP_EX_NUM (캠페인 수행번호) — NUMBER(38,0)
  • EX_CAMP_OZID (캠페인 설계정보) — VARCHAR2(32)
  • CAMP_COST_TOT_AMT (캠페인비용) — NUMBER(10,0)
  • EX_CAMP_CRAT_TM (수행캠페인생성시간) — VARCHAR2(6)
  • CAMP_GRP_ID (캠페인그룹식별자) — VARCHAR2(16)
  • CAMP_AFTER_ACT (캠페인후속조치) — VARCHAR2(512)
  • END_TM (종료시간) — VARCHAR2(6)
  • CAMP_ABT_EX_CD (AB테스트 수행캠페인 종류) — VARCHAR2(32)

C_SCRT_CONT (스크립트컨텐츠)

  • SCRT_ID (스크립트식별자) — VARCHAR2(16) — Primary key — NOT NULL
  • SCRT_TTL (제목) — VARCHAR2(256)
  • SCRT_CONT (내용) — VARCHAR2(4000)
  • SCRT_ADD_CONT (상세문구) — VARCHAR2(4000)

C_TY_SCND_BRCH (캠페인 유형 제2분류)

  • SCND_BRCH_CD (캠페인유형제2분류코드) — VARCHAR2(8) — Primary key — NOT NULL
  • CULTURE (언어코드) — VARCHAR2(16)
  • PLAN_WORK_SYS (기획작업시스템) — VARCHAR2(8)
  • FRST_BRCH_CD (캠페인유형제1분류코드) — VARCHAR2(8)
  • SCND_BRCH_NM (캠페인유형제2분류명) — VARCHAR2(95)
  • SCND_BRCH_EMP (제2분류수정사원) — VARCHAR2(16)
  • SCND_BRCH_DTM (제2분류수정일시) — VARCHAR2(20)
  • SBRCH_USE_DSTIC_CD (사용구분코드) — CHAR(1)

C_TY_THRD_BRCH (캠페인 유형 제3분류)

  • CAMP_BRCH (캠페인유형분류코드) — VARCHAR2(8) — Primary key — NOT NULL
  • CULTURE (언어코드) — VARCHAR2(16)
  • PLAN_WORK_SYS (기획작업시스템) — VARCHAR2(8)
  • SCND_BRCH_CD (캠페인유형제2분류코드) — VARCHAR2(8)
  • CAMP_BRCH_NM (캠페인유형분류명) — VARCHAR2(95)
  • CAMP_BRCH_EMP (캠페인유형수정사원) — VARCHAR2(16)
  • CAMP_BRCH_DTM (캠페인유형수정일시) — VARCHAR2(20)
  • CAMP_PRITY (캠페인우선순위) — NUMBER(38,0)
  • PROD_HOLD_YN (상품보유여부) — CHAR(1)

OBZEN_RSLT (오브젠성과분석테이블)

  • CUST_ID (고객번호) — VARCHAR2(32) — Foreign key → C_EX_ACT_CUST_LIST.CUST_ID — NOT NULL
  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(32) — Foreign key → C_EX_ACT_CUST_LIST.EX_ACT_ID — NOT NULL
  • CUST_ID (고객번호2) — Foreign key → C_CUST_CONT_HIST.CUST_ID
  • EX_ACT_ID (수행캠페인활동식별자2) — Foreign key → C_CUST_CONT_HIST.EX_ACT_ID
  • EX_CAMP_ID (수행캠페인식별자) — VARCHAR2(24)
  • CONT_SET_YN (대조군여부) — VARCHAR2(1)
  • EX_CAMP_NM (수행캠페인명) — VARCHAR2(16)
  • CONT_CHAN_DIV_CD (고객접촉채널코드) — VARCHAR2(5)
  • CONT_CHAN_DIV_NM (고객접촉채널이름) — VARCHAR2(5)
  • CHAN_TRNS_CUSTG_CNT (채널전송고객수) — NUMBER(16,0)
  • CAMP_EX_TY (캠페인실행유형코드) — VARCHAR2(8)
  • CAMP_EX_TY_NM (캠페인실행유형코드이름) — VARCHAR2(95)
  • SCND_BRCH_CD (캠페인제2유형코드) — VARCHAR2(8)
  • SCND_BRCH_NM (캠페인제2유형이름) — VARCHAR2(95)
  • CAMP_BRCH (캠페인유형) — VARCHAR2(8)
  • CAMP_BRCH_NM (캠페인유형이름) — VARCHAR2(95)
  • REBM_DETECT_ID (실시간ebm검출식별아이디) — NUMBER(20,0)
  • EX_CAMP_STR_DT (수행시작일자) — VARCHAR2(8)
  • EX_CAMP_END_DT (수행종료일자) — VARCHAR2(10)
  • AGNT_SND_DT (채널agent에전송된시각) — VARCHAR2(14)
  • SCRT_TTL (스크립트제목) — VARCHAR2(256)
  • SCRT_CONT (스크립트) — VARCHAR2(4000)
  • TEST_EX_YN (테스트수행여부) — CHAR(1)
  • FATG_USE_YN (퍼티그사용여부) — VARCHAR2(1)
  • CAMP_PRITY (캠페인우선순위) — VARCHAR2(10)
  • EX_ACT_STAT (캠페인활동상태) — VARCHAR2(8)
  • EX_ACT_STAT_NM (캠페인활동상태이름) — VARCHAR2(95)
  • PSNL_SCRT_CRAT_CD (개인화스크립트생성코드) — VARCHAR2(15)
  • AGNT_SND_CD (채널agent에전송된결과코드) — VARCHAR2(5)
  • SND_RSLT_DIV_CD (고객수신코드) — VARCHAR2(1)
  • SND_RSLT_DIV_NM (고객수신코드이름) — VARCHAR2(95)
  • CONT_RSLT_DIV_CD (수신접촉결과코드) — VARCHAR2(4)
  • CONT_RSLT_DIV_NM (수신접촉결과이름) — VARCHAR2(95)
  • RECV_DT (고객수신시간) — DATE
  • OPN_DT (고객으로부터오픈된시간) — DATE
  • EX_CAMP_ID (수행캠페인식별자2) — Foreign key → C_EX_CAMP.EX_CAMP_ID — NOT NULL
  • EX_ACT_ID (수행캠페인활동식별자3) — Foreign key → C_EX_ACT.EX_ACT_ID — NOT NULL
  • EX_ACT_ID (수행캠페인활동식별자4) — Foreign key → SCRT_TEMP.EX_ACT_ID — NOT NULL
  • SCND_BRCH_CD (캠페인유형제2분류코드2) — Foreign key → C_TY_SCND_BRCH.SCND_BRCH_CD — NOT NULL
  • CAMP_BRCH (캠페인유형분류코드) — Foreign key → C_TY_THRD_BRCH.CAMP_BRCH — NOT NULL
  • CHAN_CD (채널코드) — Foreign key → C_CHAN.CHAN_CD — NOT NULL
  • CDM_CD (공통코드) — Foreign key → C_CD_MNG.CDM_CD — NOT NULL

SCRT_TEMP (스크립트 임시테이블)

  • EX_ACT_ID (수행캠페인활동식별자) — VARCHAR2(24) — Foreign key → C_EX_ACT_SCRT.EX_ACT_ID — NOT NULL
  • SCRT_ID (스크립트식별자) — VARCHAR2(16) — Foreign key → C_SCRT_CONT.SCRT_ID — NOT NULL
  • SCRT_TTL (제목) — VARCHAR2(256)
  • SCRT_CONT (내용) — VARCHAR2(4000)