인사

테이블 (6)

FI_VENDOR (거래처)

  • vendor_id — NUMBER — 기본 키 — NOT NULL
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL
  • vendor_code — VARCHAR2(50) — NOT NULL
  • vendor_short_code — VARCHAR2(50)
  • vendor_full_name — VARCHAR2(200)
  • vendor_short_name — VARCHAR2(200)
  • business_type_lcode — VARCHAR2(100)
  • business_condition — VARCHAR2(100)
  • business_item — VARCHAR2(100)
  • related_vendor_flag — VARCHAR2(2)
  • biz_location — VARCHAR2(50)
  • biz_location_code — VARCHAR2(50)
  • customer_flag — VARCHAR2(1)
  • vendor_party_id — NUMBER
  • oe_order_flag — VARCHAR2(1)
  • wip_process_flag — VARCHAR2(1)
  • oe_delivery_flag — VARCHAR2(1)
  • out_process_flag — VARCHAR2(1)
  • sales_person_id — NUMBER
  • supplier_flag — VARCHAR2(1)

HRD_ATTEND_INTERFACE

  • device_id — NUMBER — NOT NULL
  • person_id — NUMBER — NOT NULL
  • card_num — VARCHAR2(50)
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL

HRM_CORP_MASTER (법인/사업장)

  • corp_id — NUMBER — 기본 키 — NOT NULL
  • vendor_id (vendor_id2) — NUMBER — 외래 키 → FI_VENDOR.vendor_id — NOT NULL
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL
  • corp_code — VARCHAR2(20) — NOT NULL
  • corp_name — VARCHAR2(100) — NOT NULL
  • legal_number — VARCHAR2(50)
  • president_name — VARCHAR2(80)
  • corp_category — VARCHAR2(2)
  • corp_type — VARCHAR2(2)
  • corp_sort_num — NUMBER
  • dept_control_yn — VARCHAR2(1)
  • duty_control_yn — VARCHAR2(1)
  • pay_control_yn — VARCHAR2(1)
  • default_flag — VARCHAR2(1)
  • vendor_id — NUMBER
  • retirement_pension_bank — VARCHAR2(200)
  • retirement_pension_account — VARCHAR2(50)
  • enabled_flag — VARCHAR2(1)
  • Field (VENDER_ID)

HRM_DEPT_MASTER (부서)

  • dept_id — NUMBER — 기본 키 — NOT NULL
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL
  • dept_code — VARCHAR2(30) — NOT NULL
  • dept_name — VARCHAR2(100)
  • dept_level — NUMBER — NOT NULL
  • entry_flag — VARCHAR2(1) — NOT NULL
  • upper_dept_id — NUMBER
  • dept_sort_num — NUMBER — NOT NULL
  • dept_group — VARCHAR2(30)
  • enabled_flag — VARCHAR2(1) — NOT NULL
  • effective_date_fr — DATE — NOT NULL
  • effective_date_to — DATE

HRM_OPERATING_UNIT (사업장)

  • operating_unit_id — NUMBER — 기본 키 — NOT NULL
  • corp_id — NUMBER — NOT NULL
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL
  • operating_unit_code — VARCHAR2(30) — NOT NULL
  • operating_unit_name — VARCHAR2(100)
  • fi_bank_id — NUMBER
  • fi_bank_account_id — NUMBER

HRM_PERSON_MASTER (인사 마스터)

  • person_id — NUMBER — 기본 키 — NOT NULL
  • dept_id (dept_id2) — NUMBER — 외래 키 → HRM_DEPT_MASTER.dept_id — NOT NULL
  • operating_unit_id (operating_unit_id2) — NUMBER — 외래 키 → HRM_OPERATING_UNIT.operating_unit_id — NOT NULL
  • corp_id (corp_id2) — NUMBER — 외래 키 → HRM_CORP_MASTER.corp_id — NOT NULL
  • person_num — VARCHAR2(50) — NOT NULL
  • name — VARCHAR2(100) — NOT NULL
  • corp_id — NUMBER — NOT NULL
  • operating_unit_id — NUMBER
  • work_corp_id — NUMBER
  • work_type_id — NUMBER
  • post_id — NUMBER
  • ocpt_id — NUMBER
  • abil_id — NUMBER
  • pay_grade_id — NUMBER
  • join_date — DATE
  • retire_date — DATE
  • employe_type — VARCHAR2(2)
  • legal_zip_code — VARCHAR2(30)
  • legal_addr1 — VARCHAR2(150)
  • legal_addr2 — VARCHAR2(150)
  • prsn_zip_code — VARCHAR2(30)
  • prsn_addr1 — VARCHAR2(150)
  • prsn_addr2 — VARCHAR2(150)
  • live_zip_code — VARCHAR2(30)
  • live_addr1 — VARCHAR2(150)
  • live_addr2 — VARCHAR2(150)
  • job_category_id — NUMBER
  • floor_id — NUMBER
  • cost_center_id — NUMBER
  • ic_card_no — VARCHAR2(50)
  • corp_type — VARCHAR2(2)
  • sob_id — NUMBER — NOT NULL
  • org_id — NUMBER — NOT NULL