인사
테이블 (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