ERP 인사기본

테이블 (3)

조직 H_ASG_MASTER (H_ASG_MASTER)

  • 회사코드 (TENANT_ID) — NOT NULL — 기본 키 — NOT NULL
  • 회사상세코드 (CO_CD) — NOT NULL — 기본 키 — NOT NULL
  • Key (EFFCT_START_DATE) — NOT NULL — 기본 키 — NOT NULL
  • 사원번호(LEADER_EMP_NO) (EMP_NO) — NULL — 외래 키 → 조직_조직마스터.사원번호(EMP_NO) — NOT NULL
  • (EMP_STATUS_CD) — NOT NULL
  • (HIRE_TYPE_CD) — NULL
  • (EMP_TYPE_CD) — NULL
  • (ECNY_TYPE_CD) — NULL
  • (BIZ_AREA_CD) — NULL
  • (ORG_CD) — NULL
  • (COST_CD) — NULL
  • (LBCST_COST_CD) — NULL
  • (JOB_POSITION_CD) — NULL
  • (JOB_TITLE_CD) — NOT NULL
  • (JOB_GRADE_CD) — NULL
  • (YY_CNT) — NULL
  • Field (YEAR_GRADE) — NULL
  • 이메일 (JOB_ID) — NULL
  • Field (JOB_CD) — NULL
  • 핸드폰번호 (HAND_TEL_NO) — NULL
  • Field (TEL_NO) — NULL
  • Field (EM_TEL_NO) — NULL
  • Field (NOW_JOB_GRADE_PRMOT_DATE) — NULL
  • Field (NOW_ORG_ASG_DATE) — NULL
  • Field (NOW_JOB_TITLE_ASG_DATE) — NULL
  • Field (NOW_JOB_POSITION_ASG_DATE) — NULL
  • Field (NOW_JOB_ASG_DATE) — NULL
  • Field (FRST_ENT_CO_CD) — NULL
  • Field (RCM_MJ_CO_CD) — NULL
  • Field (RCM_DP_CO_CD) — NULL
  • Field (EXE_ASG_DATE) — NULL
  • Field (SLY_PEAK_DATE) — NULL
  • 경력인정년수 (CAREER_YY) — NULL
  • 경력인정개월수 (CAREER_MM) — NULL
  • Field (CAREER_JOB_GRADE_CD) — NULL
  • Field (YHD_STD_DATE) — NOT NULL
  • Field (WRK_STD_DATE) — NOT NULL
  • Field (BEFORE_CO_CD) — NULL
  • 이전_사원_번호 (BEFORE_EMP_NO) — NULL
  • 사진첨부파일 (PHOTO) — NULL
  • Field2 (RE_HIRE_RECMND_CD) — NULL
  • 퇴직금기산일 (SEP_STD_DATE) — NOT NULL
  • 사내추천 사번 (RECMND_EMP_NO) — NULL
  • 사내추천 관계코드 (RECMND_RELATE_CD) — NULL
  • Field (RECMND_NAME) — NULL
  • Field (RECMND_WORK_PLACE) — NULL
  • Field (RECMND_TITLE) — NULL
  • Field (USER_ID) — NULL
  • Field

조직 PSN_MASTER (H_PSN_MASTER)

  • 회사코드 (TENANT_ID) — NOT NULL — 기본 키 — NOT NULL
  • 회사상세코드 (CO_CD) — NOT NULL — 기본 키 — NOT NULL
  • 사원번호 (EMP_NO) — NOT NULL — 기본 키 — NOT NULL
  • 성명 (NAME) — NOT NULL
  • 영문_성명 (ENG_NAME) — NULL
  • Field (HANJA_NAME) — NULL
  • 주민번호 (RGST_NO) — NULL
  • 성별 (SEX_CD) — NULL
  • 생년월일 (BIRT) — NULL
  • 정렬코드 (SO_LU_CD) — NULL
  • 외국인_여부 (FRGNR_YN) — NOT NULL
  • 국적 (NAT_CD) — NULL
  • Field (EMP_STATUS_CD) — NULL
  • Field (ENTR_DATE) — NULL
  • 최초입사일자 (FRST_ENTR_DATE) — NULL
  • Field (REST_DATE) — NULL
  • Field (RETURN_DATE) — NULL
  • Field (RETIRE_DATE) — NOT NULL
  • 이메일 (EMAIL_ADDR) — NULL
  • Field (EXTRL_EMAIL) — NULL
  • 핸드폰번호 (HAND_TEL_NO) — NULL
  • Field (TEL_NO) — NULL
  • Field (EM_TEL_NO) — NULL
  • Field (NOW_JOB_GRADE_PRMOT_DATE) — NULL
  • Field (NOW_ORG_ASG_DATE) — NULL
  • Field (NOW_JOB_TITLE_ASG_DATE) — NULL
  • Field (NOW_JOB_POSITION_ASG_DATE) — NULL
  • Field (NOW_JOB_ASG_DATE) — NULL
  • Field (FRST_ENT_CO_CD) — NULL
  • Field (RCM_MJ_CO_CD) — NULL
  • Field (RCM_DP_CO_CD) — NULL
  • Field (EXE_ASG_DATE) — NULL
  • Field (SLY_PEAK_DATE) — NULL
  • 경력인정년수 (CAREER_YY) — NULL
  • 경력인정개월수 (CAREER_MM) — NULL
  • Field (CAREER_JOB_GRADE_CD) — NULL
  • Field (YHD_STD_DATE) — NOT NULL
  • Field (WRK_STD_DATE) — NOT NULL
  • Field (BEFORE_CO_CD) — NULL
  • 이전_사원_번호 (BEFORE_EMP_NO) — NULL
  • 사진첨부파일 (PHOTO) — NULL
  • Field2 (RE_HIRE_RECMND_CD) — NULL
  • 퇴직금기산일 (SEP_STD_DATE) — NOT NULL
  • 사내추천 사번 (RECMND_EMP_NO) — NULL
  • 사내추천 관계코드 (RECMND_RELATE_CD) — NULL
  • Field (RECMND_NAME) — NULL
  • Field (RECMND_WORK_PLACE) — NULL
  • Field (RECMND_TITLE) — NULL
  • Field (USER_ID) — NULL
  • Field

조직_조직마스터 (H_ORG_MASTER)

  • 회사코드 (TENANT_ID) — NOT NULL — 기본 키 — NOT NULL
  • 회사상세코드 (CO_CD) — NOT NULL — 기본 키 — NOT NULL
  • 유효시작일자 (EFFCT_START_DATE) — NOT NULL — 기본 키 — NOT NULL
  • 조직코드 (ORG_CD) — NOT NULL — 기본 키 — NOT NULL
  • 사원번호(EMP_NO) (LEADER_EMP_NO) — NULL — 외래 키 → 조직 PSN_MASTER.사원번호 — NOT NULL
  • 유효종료일자 (EFFCT_END_DATE) — NOT NULL
  • Field (BIZ_AREA_CD) — NULL
  • (SORT_NO) — NULL
  • Field (UPPER_ORG_CD) — NULL
  • Field (ORG_ASG_CD) — NULL
  • 정렬코드 (SORT_CD) — NOT NULL
  • Field (ORG_TYPE_CD) — NULL
  • Field (ORG_FORM_CD) — NULL
  • Field (ORG_LEVEL_CD) — NULL
  • Field (SECT_CD) — NULL
  • Field (DEPT_CD) — NULL
  • Field (ORG_JBGP_CD) — NULL
  • Field (ADDR) — NULL
  • Field (COST_CD) — NULL
  • Field (LBCST_COST_CD) — NULL
  • Field (LLX_PAY_CNTER_CD) — NULL
  • Field (HR_ORG_YN) — NULL
  • Field (WPLC_CD) — NULL
  • Field (ORG_CREAT_DATE) — NOT NULL
  • Field (ORG_ABL_DATE) — NULL
  • Field