GLM
테이블 (54)
(직무) ASIS평가기준평가자_내역 (tb_glm_evl_crit_dgns_crit_bs)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- scal_mark_nm — varchar(200)
- crit_yr — varchar(4)
- peer_cnt — jsonb
- bf_perfm_evl_yr — varchar(4)
- gl_evl_grd_cd — varchar(50)
- gl_evl_grd_nm — varchar(200)
- gl_evl_item_cd_1 — varchar(50)
- gl_evl_item_cd_2 — varchar(50)
- gl_evl_item_cd_3 — varchar(50)
- gl_evl_item_cd_4 — varchar(50)
- gl_evl_item_cd_5 — varchar(50)
- gl_evl_item_cd_6 — varchar(50)
- gl_evl_item_cd_7 — varchar(50)
- gl_evl_item_cd_8 — varchar(50)
- gl_evl_item_cd_9 — varchar(50)
- gl_evl_item_cd_10 — varchar(50)
- use_yn — bpchar(1)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL심의결과_내역 (tb_glm_gl_delib_rslt_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- delib_rslt_cd — varchar(50)
- opnn_cntn — varchar(4000)
- fnl_gl_cd — varchar(50)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증AI면접대상자_내역 (tb_glm_glcert_ai_intvw_trgtpr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증PEER_내역 (tb_glm_glcert_peer_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- peer_emp_no — varchar(20) — 기본 키 — NOT NULL
- seq — numeric(20)
- peer_dept_cd — varchar(20)
- cnfm_yn — bpchar(1)
- rsn_cntn — varchar(500)
- comp_cd — varchar(20)
- use_yn — bpchar(1)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증PMS_내역 (tb_glm_glcert_pms_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20)
- evlee_emp_no — varchar(20)
- pfmc_yr — varchar(4)
- pjt_nm — varchar(200)
- dply_st_dt — varchar(8)
- dply_ed_dt — varchar(8)
- pfmc_role_cntn — varchar(1000)
- edit_psbl_yn — bpchar(1)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) GL인증강단점_내역 (tb_glm_glcert_sawp_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- forte_cntn — varchar(4000)
- flaw_cntn — varchar(4000)
- use_yn — bpchar(1)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증동료코멘트_내역 (tb_glm_glcert_cowrkr_cmnt_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- gl_evltr_div_cd — varchar(50) — 기본 키 — NOT NULL
- forte_cmnt_cntn — varchar(4000)
- spmp_cmnt_cntn — varchar(4000)
- cmprh_cmnt_cntn — varchar(4000)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증수행직무_내역 (tb_glm_glcert_pfmc_job_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20)
- evlee_emp_no — varchar(20)
- pfmc_st_dt — varchar(8)
- pfmc_ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- dept_cd — varchar(20)
- job_id — varchar(20)
- use_yn — bpchar(1)
- job_task_id — varchar(20)
(직무) GL인증종합평가_내역 (tb_glm_glcert_cmprh_evl_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- gl_evltr_type_cd — varchar(50) — 기본 키 — NOT NULL
- evltr_emp_no — varchar(20) — 기본 키 — NOT NULL
- gl_evl_artcl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- evl_artcl_no — numeric(20) — 기본 키 — NOT NULL
- gl_evl_artcl_grd_cd — varchar(50)
- evl_artcl_score — numeric(10, 3)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) GL인증파일첨부_내역 (tb_glm_glcert_file_attch_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- use_yn — bpchar(1)
- file_size_val — numeric(24)
- file_path — varchar(500)
- orgnl_file_nm — varchar(300)
- save_file_nm — varchar(300)
- acs_url — varchar(200)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- attch_file_grp_no — numeric(20)
- attch_file_no — numeric(20)
(직무) 업무코드_마스터 (tb_glm_task_cd_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- task_cd — varchar(20) — 기본 키 — NOT NULL
- task_cd_nm — varchar(200)
- task_div_cd — varchar(50)
- high_task_cd — varchar(20)
- task_val — varchar(20)
- sort_sq — numeric(6) — NOT NULL
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- rmk_cntn — varchar(4000)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- job_task_div_cd — varchar(50)
(직무) 직무_기본 (tb_glm_job_bs)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- crit_dt — varchar(8)
- jl_cd — varchar(50)
- sort_sq — numeric(6)
- dept_cd — varchar(20)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- job_abbrv_nm — varchar(200)
- job_grp_id — varchar(20)
- job_div_cd — varchar(50)
- job_nope — numeric(12)
- excl_yn — bpchar(1)
- rmk_cntn — varchar(4000)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
(직무) 직무담당_내역 (tb_glm_job_chrg_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_chrg_id — varchar(20) — 기본 키 — NOT NULL
- job_id — varchar(20) — NOT NULL
- crit_dt — varchar(8) — NOT NULL
- emp_no — varchar(20) — NOT NULL
- cpbl_score — numeric(10, 3)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무담당역량_내역 (tb_glm_job_chrg_cpbl_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_chrg_id — varchar(20) — 기본 키 — NOT NULL
- job_cpbl_seq — numeric(10) — 기본 키 — NOT NULL
- cpbl_id — varchar(20) — NOT NULL
- job_cpbl_div_cd — varchar(50)
- cpbl_val — varchar(20)
- cpbl_score — numeric(10, 3)
- job_task_id — varchar(20)
- esntl_yn — bpchar(1)
- sort_sq — numeric(6)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무상세경험_내역 (tb_glm_job_dtl_exprn_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- relvt_lv_cd — varchar(50) — 기본 키 — NOT NULL
- esntl_exprn_cntn — varchar(2000)
- pref_exprn_cntn — varchar(2000)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 직무상세공통역량_내역 (tb_glm_job_dtl_comn_cpbl_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- cpbl_id — varchar(20) — 기본 키 — NOT NULL
- cpbl_defn_cntn — varchar(4000)
- gl1_aplcn_yn — bpchar(1)
- gl2_aplcn_yn — bpchar(1)
- gl3_aplcn_yn — bpchar(1)
- gl4_aplcn_yn — bpchar(1)
- gl5_aplcn_yn — bpchar(1)
- gl6_aplcn_yn — bpchar(1)
- gl7_aplcn_yn — bpchar(1)
- gl8_aplcn_yn — bpchar(1)
- gl9_aplcn_yn — bpchar(1)
- gl10_aplcn_yn — bpchar(1)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
- cpbl_nm — varchar(200)
(직무) 직무상세자격증_내역 (tb_glm_job_dtl_certf_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- qlfc_kd_cd — varchar(50)
- lvl_cd — varchar(50)
- issue_inst_nm — varchar(300)
- esntl_rqmt_yn — bpchar(1)
- pref_rqmt_yn — bpchar(1)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 직무상세직무관계_내역 (tb_glm_job_dtl_job_rel_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- job_rel_cd — varchar(50) — 기본 키 — NOT NULL
- job_rel_nm — varchar(200)
- esntl_rqmt_yn — bpchar(1)
- pref_rqmt_yn — bpchar(1)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 직무상세학력_내역 (tb_glm_job_dtl_acbg_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- acbg_cd — varchar(50) — 기본 키 — NOT NULL
- mjr_cd — varchar(50) — 기본 키 — NOT NULL
- seq — numeric(20) — NOT NULL
- esntl_rqmt_yn — bpchar(1)
- pref_rqmt_yn — bpchar(1)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 직무신청_내역 (tb_glm_job_aply_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- aply_no — numeric(20) — 기본 키 — NOT NULL
- aply_job_id — varchar(20)
- aply_dept_cd — varchar(20)
- aply_wrkpl_cd — varchar(50)
- rcmdtn_yn — bpchar(1)
- rcmdtn_job_id — varchar(20)
- rcmmr_emp_no — varchar(20)
- rcmdtn_dt — varchar(8)
- job_mvmn_psbl_dt — varchar(8)
- answr_emp_no — varchar(20)
- ans_dt — varchar(8)
- rmk_cntn — varchar(4000)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무업무_내역 (tb_glm_job_task_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- job_task_id — varchar(20) — 기본 키 — NOT NULL
- job_task_nm — varchar(200) — NOT NULL
- job_task_lvl_cd — varchar(50)
- sort_sq — numeric(6)
- job_wgt — numeric(10, 3)
- job_task_cntn — varchar(500)
- reqmt_mtm — numeric(6)
- ocrn_cycl_val — numeric(12)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- job_task_div_cd — varchar(50)
- job_task_cd — varchar(50)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
(직무) 직무업무담당_내역 (tb_glm_job_task_chrg_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_chrg_id — varchar(20) — 기본 키 — NOT NULL
- job_seq — numeric(12) — 기본 키 — NOT NULL
- job_id — varchar(20)
- job_task_id — varchar(20)
- crit_dt — varchar(8)
- job_task_grd_cd — varchar(50)
- job_task_score — numeric(10, 3)
- job_task_wgt — numeric(10, 3)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무역량_내역 (tb_glm_job_cpbl_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- job_cpbl_seq — numeric(10) — 기본 키 — NOT NULL
- cpbl_id — varchar(20)
- job_cpbl_div_cd — varchar(50)
- job_cpbl_clsf_cd — varchar(20)
- job_cpbl_clsf_comn_grp_cd — varchar(50)
- gl_cd — varchar(50)
- job_cpbl_cd — varchar(50)
- cpbl_val — varchar(20)
- cpbl_score — numeric(10, 3)
- job_task_id — varchar(20)
- esntl_yn — bpchar(1)
- pref_yn — bpchar(1)
- sort_sq — numeric(6)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- cpbl_defn_cntn — varchar(4000)
- use_yn — bpchar(1) — NOT NULL
- comp_cd — varchar(20)
- gl1_relvt_yn — bpchar(1)
- gl2_relvt_yn — bpchar(1)
- gl3_relvt_yn — bpchar(1)
- gl4_relvt_yn — bpchar(1)
- gl5_relvt_yn — bpchar(1)
- gl6_relvt_yn — bpchar(1)
- gl7_relvt_yn — bpchar(1)
- gl8_relvt_yn — bpchar(1)
- gl9_relvt_yn — bpchar(1)
- gl10_relvt_yn — bpchar(1)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- esntl_cntn — varchar(1000)
- pref_cntn — varchar(1000)
(직무) 직무추천_기본 (tb_glm_job_rcmdtn_bs)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_rcmdtn_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — NOT NULL
- rcmdtn_job_id — varchar(20) — NOT NULL
- rcmdtn_dt — varchar(8)
- job_id — varchar(20)
- rcmmr_emp_no — varchar(20)
- job_mvmn_psbl_dt — varchar(8)
- job_cpbl_val — varchar(20)
- rcmdtn_job_cpbl_val — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무추천_상세 (tb_glm_job_rcmdtn_dtl)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_rcmdtn_id — varchar(20) — 기본 키 — NOT NULL
- rcmdtn_seq — numeric(6) — 기본 키 — NOT NULL
- cpbl_id — varchar(20)
- cpbl_val — varchar(20)
- job_cpbl_val — varchar(20)
- rcmdtn_cpbl_val — varchar(20)
- rcmdtn_job_cpbl_val — varchar(20)
- sort_sq — numeric(6)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무추천경로_기본 (tb_glm_job_rcmdtn_path_bs)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_rcmdtn_path_id — varchar(20) — 기본 키 — NOT NULL
- emp_no — varchar(20) — NOT NULL
- job_id — varchar(20)
- rcmdtn_dt — varchar(8)
- jl_cd — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무추천경로_상세 (tb_glm_job_rcmdtn_path_dt)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_rcmdtn_path_id — varchar(20) — 기본 키 — NOT NULL
- rcmdtn_seq — numeric(6) — 기본 키 — NOT NULL
- rcmdtn_job_id — varchar(20)
- rcmdtn_dt — varchar(8)
- jl_cd — varchar(50)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 직무활동_내역 (tb_glm_job_actvt_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- job_task_id — varchar(20) — 기본 키 — NOT NULL
- job_actvt_id — varchar(20) — 기본 키 — NOT NULL
- job_actvt_nm — varchar(200) — NOT NULL
- sort_sq — numeric(6)
- job_actvt_cntn — varchar(4000)
- reqmt_mtm — numeric(6)
- actvt_cond_cntn — varchar(4000)
- use_yn — bpchar(1) — NOT NULL
- comp_cd — varchar(20)
- seq — numeric(20)
- lcls_cd — varchar(50)
- cpbl_defn_cntn — varchar(4000)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- gl_aplcn_cd_01 — varchar(50)
- gl_aplcn_cd_02 — varchar(50)
- gl_aplcn_cd_03 — varchar(50)
- gl_aplcn_cd_04 — varchar(50)
- gl_aplcn_cd_05 — varchar(50)
- gl_aplcn_cd_06 — varchar(50)
- gl_aplcn_cd_07 — varchar(50)
- gl_aplcn_cd_08 — varchar(50)
- gl_aplcn_cd_09 — varchar(50)
- gl_aplcn_cd_10 — varchar(50)
- job_actvt_cd — varchar(50)
- lcls_nm — varchar(200)
(직무) 평가가중치설정_마스터 (tb_glm_evl_wgt_set_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- wgt_grp_cd — varchar(50) — 기본 키 — NOT NULL
- artcl_cd — varchar(50) — 기본 키 — NOT NULL
- wgt — numeric(10, 3)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준EPIC척도_마스터 (tb_glm_evl_crit_epic_scal_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_id — varchar(20) — 기본 키 — NOT NULL
- gl_cd — varchar(50) — 기본 키 — NOT NULL
- eci_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- st_dt — varchar(8) — 기본 키 — NOT NULL
- seq — numeric(20) — 기본 키 — NOT NULL
- lcls_cd — varchar(50)
- dtls_evl_artcl_cntn — varchar(2000)
- ed_dt — varchar(8)
- comp_cd — varchar(20)
- pfmc_dept_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
- lcls_nm — varchar(200)
(직무) 평가기준GL항목_마스터 (tb_glm_evl_crit_gl_item_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- glcert_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- choc_yn — bpchar(1)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 평가기준_마스터 (tb_glm_evl_crit_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evl_crit_nm — varchar(100)
- evl_yr — varchar(4)
- gl_evl_type_cd — varchar(50)
- gl_evl_rnd_cd — varchar(50)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- crit_dt — varchar(8)
- rmk_cntn — varchar(4000)
- evlee_cnds_id — varchar(20)
- evl_prgr_yn — bpchar(1)
- notic_mttr_cntn — text
- gl_evl_dtls_artcl_cd — varchar(50)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준그룹_마스터 (tb_glm_evl_crit_grp_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- empl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- prrty_rank_val — numeric(24)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준그룹조건_마스터 (tb_glm_evl_crit_grp_cond_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- empl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- cnds_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- optr_cd — varchar(50) — 기본 키 — NOT NULL
- cond_cd — varchar(500)
- cond_nm — varchar(1000)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준진단항목_마스터 (tb_glm_evl_crit_dgns_item_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_artcl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- qstn_type_cd — varchar(50) — 기본 키 — NOT NULL
- scal_type_cd — varchar(50)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- use_yn — bpchar(1)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 평가기준진단항목_상세 (tb_glm_evl_crit_dgns_item_dt)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_artcl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- dtl_seq — numeric(10) — 기본 키 — NOT NULL
- job_id — varchar(20)
- gl_cd — varchar(50)
- gl_evl_artcl_cd — varchar(50)
- evl_artcl_no — numeric(20)
- lcls_cd — varchar(50)
- evl_dtls_qtitm_cntn — varchar(2000)
- comp_cd — varchar(20)
- use_yn — bpchar(1)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- lcls_nm — varchar(200)
(직무) 평가기준진행_내역 (tb_glm_evl_crit_prgr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- prgr_step_cd — varchar(50) — 기본 키 — NOT NULL
- sort_sq — numeric(6)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준척도_마스터 (tb_glm_evl_crit_scal_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- scal_type_cd — varchar(50) — 기본 키 — NOT NULL
- impl_crit_grd_cd — varchar(20) — 기본 키 — NOT NULL
- grd_nm — varchar(100)
- evl_crit_expl — varchar(500)
- dtls_expl — varchar(500)
- st_score — numeric(10, 3)
- st_incld_yn — bpchar(1)
- ed_score — numeric(10, 3)
- ed_incld_yn — bpchar(1)
- crit_score — numeric(10, 3)
- fxqty_gudln_cntn — varchar(500)
- sincr_gudln_cntn — varchar(500)
- inqry_sq — numeric(10)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가기준평가양식_마스터 (tb_glm_evl_crit_evl_style_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_style_cd — varchar(50) — 기본 키 — NOT NULL
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
- gl_evl_style_type_cd — varchar(50)
(직무) 평가기준평가자_내역 (tb_glm_evl_crit_evltr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evltr_grp_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evltr_div_cd — varchar(50) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- fnl_phase_val — numeric(24)
- jbpos_grp_cd — varchar(50)
- rmk_cntn — varchar(4000)
- use_yn — bpchar(1)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무) 평가기준평가진행_내역 (tb_glm_evl_crit_evl_prgr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_step_cd — varchar(50) — 기본 키 — NOT NULL
- st_dt — varchar(8)
- ed_dt — varchar(8)
- sort_sq — numeric(6)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가점수년도_내역 (tb_glm_evl_score_yr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- crit_yr — varchar(4) — 기본 키 — NOT NULL
- crit_yr_gl_evl_rslt_cd — varchar(50)
- crit_yr_gl_evl_rslt_cd_1 — varchar(50)
- crit_yr_gl_evl_rslt_cd_2 — varchar(50)
- crit_yr_gl_evl_rslt_cd_3 — varchar(50)
- crit_yr_gl_evl_rslt_cd_4 — varchar(50)
- crit_yr_gl_evl_rslt_cd_5 — varchar(50)
- crit_yr_gl_evl_rslt_cd_6 — varchar(50)
- rmk_cntn — varchar(4000)
- etc_cntn — varchar(500)
- etc_cntn_1 — varchar(500)
- etc_cntn_2 — varchar(500)
- etc_cntn_3 — varchar(500)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무) 평가점수월_내역 (tb_glm_evl_score_mn_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- crit_ym — varchar(6) — 기본 키 — NOT NULL
- gl_evl_rslt_cd — varchar(50)
- rmk_cntn — varchar(4000)
- etc_cntn — varchar(500)
- etc_cntn_1 — varchar(500)
- etc_cntn_2 — varchar(500)
- etc_cntn_3 — varchar(500)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
(직무)역량_마스터 (tb_glm_cpbl_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- cpbl_id — varchar(20) — 기본 키 — NOT NULL
- cpbl_nm — varchar(200) — NOT NULL
- clsf_cd — varchar(20)
- sort_sq — numeric(6)
- cpbl_cntn — varchar(500)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- job_cpbl_div_cd — varchar(50)
(직무)역량분류_마스터 (tb_glm_cpbl_clsf_ms)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- clsf_cd — varchar(20) — 기본 키 — NOT NULL
- clsf_nm — varchar(200) — NOT NULL
- high_clsf_cd — varchar(20)
- task_div_cd — varchar(50)
- sort_sq — numeric(6)
- kywd_cntn — varchar(300)
- clsf_cntn — varchar(500)
- aplcn_st_dt — varchar(8)
- aplcn_ed_dt — varchar(8)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)역량키워드_내역 (tb_glm_cpbl_kywd_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- cpbl_id — varchar(20) — 기본 키 — NOT NULL
- cpbl_kywd_seq — numeric(6) — 기본 키 — NOT NULL
- kywd_nm — varchar(200) — NOT NULL
- kywd_itno — numeric(12)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)전문성진단수행직무_내역 (tb_glm_etdn_pfmc_job_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- unit_task_id — varchar(20) — 기본 키 — NOT NULL
- unit_task_dtl_id — varchar(20) — 기본 키 — NOT NULL
- unit_task_cntn — varchar(300)
- unit_task_dtl_cntn — varchar(300)
- lcls_cd — varchar(50)
- pfmc_yn — bpchar(1)
- rmk_cntn — varchar(4000)
- comp_cd — varchar(20)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- lcls_nm — varchar(200)
(직무)전문성진단직무수행도_내역 (tb_glm_etdn_job_pfmcs_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- gl_evl_artcl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- evl_artcl_no — numeric(20) — 기본 키 — NOT NULL
- gl_evl_artcl_grd_cd — varchar(50)
- evl_artcl_score — numeric(10, 3)
- opnn_cntn — varchar(4000)
- evltr_emp_no — varchar(20)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)전문성진단직무평가수행도_내역 (tb_glm_etdn_job_eva_pfmcs_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- evl_item_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_item_div_cd — varchar(50)
- evl_high_item_id — varchar(20)
- evl_high_item_cntn — varchar(2000)
- evl_item_cntn — varchar(2000) — NOT NULL
- evl_item_dtl_cntn — varchar(2000)
- gl_evl_artcl_grd_cd — varchar(50)
- evl_artcl_score — numeric(10, 3)
- comp_cd — varchar(20)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)직무신설_상세 (tb_glm_job_ncr_dt)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_ncr_no — varchar(20) — 기본 키 — NOT NULL
- dtl_seq — numeric(10) — 기본 키 — NOT NULL
- job_id — varchar(20)
- job_nm — varchar(100)
- high_job_id — varchar(20)
- crit_dt — varchar(8)
- job_cntn — varchar(500)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- job_abbrv_nm — varchar(200)
- jl_cd — varchar(50)
- dept_cd — varchar(20)
(직무)직무신설업무_상세 (tb_glm_job_ncr_task_dt)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- job_ncr_no — varchar(20) — 기본 키 — NOT NULL
- dtl_seq — numeric(10) — 기본 키 — NOT NULL
- job_id — varchar(20)
- job_task_cd — varchar(50) — NOT NULL
- job_task_nm — varchar(200) — NOT NULL
- job_task_div_cd — varchar(50)
- job_task_lvl_cd — varchar(50)
- sort_sq — numeric(6)
- job_wgt — numeric(10, 3)
- job_task_cntn — varchar(500)
- reqmt_mtm — numeric(6)
- ocrn_cycl_val — numeric(12)
- use_yn — bpchar(1) — NOT NULL
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)진단수행평가자_내역 (tb_glm_dgns_pfmc_evltr_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- evltr_emp_no — varchar(20) — 기본 키 — NOT NULL
- gl_evltr_type_cd — varchar(50) — 기본 키 — NOT NULL
- evlee_org_id — varchar(20)
- job_id — varchar(20)
- evltr_org_id — varchar(20)
- clv_evl_gl_grd_cd — varchar(50)
- clv_evl_score — numeric(10, 3)
- hlv_gl_evl_grd_cd — varchar(50)
- hlv_evl_score — numeric(10, 3)
- gl_fnl_evl_grd_cd — varchar(50)
- fnl_evl_score — numeric(10, 3)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
- use_yn — bpchar(1)
- rmk_cntn — varchar(4000)
(직무)진단수행피평가자_내역 (tb_glm_dgns_pfmc_evlee_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- emp_no — varchar(20) — 기본 키 — NOT NULL
- dept_id — varchar(20)
- job_id — varchar(20)
- gl_evl_step_cd — varchar(50)
- gl_evl_stat_cd — varchar(50)
- gl_evl_grd_cd — varchar(50)
- gl_cd — varchar(50)
- evl_score — numeric(10, 3)
- trgt_yn — bpchar(1)
- st_dt — varchar(8)
- ed_dt — varchar(8)
- crit_dt — varchar(8)
- gl_evl_style_cd — varchar(50)
- phase_wgt_grp_cd — varchar(50)
- gl_evl_grp_cd — varchar(50)
- evl_rslt_open_yn — bpchar(1)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL
(직무)진단코멘트_내역 (tb_glm_dgns_cmnt_ls)
- tennt_id — varchar(3) — 기본 키 — NOT NULL
- evl_crit_id — varchar(20) — 기본 키 — NOT NULL
- gl_evl_type_cd — varchar(50) — 기본 키 — NOT NULL
- evlee_emp_no — varchar(20) — 기본 키 — NOT NULL
- phase_val — numeric(24) — 기본 키 — NOT NULL
- gl_evl_artcl_grp_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evl_artcl_cd — varchar(50) — 기본 키 — NOT NULL
- gl_evltr_div_cd — varchar(50) — 기본 키 — NOT NULL
- evltr_emp_no — varchar(20) — 기본 키 — NOT NULL
- cmnt_cntn — varchar(4000)
- comp_cd — varchar(20)
- regpr_id — varchar(20) — NOT NULL
- regpr_ip — varchar(20) — NOT NULL
- reg_dttm — timestamp — NOT NULL
- gmt_reg_dttm — timestamp — NOT NULL
- upder_id — varchar(20) — NOT NULL
- upder_ip — varchar(20) — NOT NULL
- upd_dttm — timestamp — NOT NULL
- gmt_upd_dttm — timestamp — NOT NULL