APPRAISAL - 2024-05-28 02:41:05

Tables (21)

EPER_APPR+OBJ_KEYS_HIST (CopyOfOJB 수정기록 확정기준)

  • HISTORY_ID (Key) — NUMBER — Primary key — NOT NULL
  • APPRAISAL_OBJECTIVE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • TEMPLATE_ID (Field3) — NUMBER
  • OBJECTIVE_KEY_DESC (Field4) — VARCHAR
  • OBJECTIVE_KEY_TYPE (Field5) — VARCHAR
  • ENABLED_FLAG (Field6) — VARCHAR
  • OBJECTIVE_VERSION_NUMBER (Field7) — NUMBER
  • CURRENT_RECORD_FLAG (Field8) — VARCHAR
  • Field9
  • APPRAISAL_OBJECTIVE_ID (PK) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL

  • APPRAISAL_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (FK) — NUMBER — Primary key — NOT NULL
  • ORG_ID (Field3) — NUMBER
  • PERSON_ID (Field4) — NUMBER
  • STATUS (Field5) — VARCHAR
  • APPRAISER_ID_1ST (Field6) — NUMBER
  • APPRAISER_ID_2ND (Field7) — NUMBER
  • APPRAISER_ID_3RD (Field8) — NUMBER
  • SCORE_OBJECTIVE_SELF (Field9) — NUMBER
  • SCORE_COMPETENCE_SELF (Field10) — NUMBER
  • SCORE_TOTAL_SELF (Field11) — NUMBER
  • APPRAISAL_TEMPLATE_CD (Field12) — VARCHAR
  • SCORE_OBJECTIVE_1ST (Field13) — NUMBER
  • SCORE_COMPETENCE_1ST (Field14) — NUMBER
  • SCORE_TOTAL_1ST (Field15) — NUMBER
  • FINAL_SCORE (Field16) — NUMBER
  • FINAL_SCORE_ADJUST (Field17) — NUMBER
  • FINAL_GRADE (Field18) — VARCHAR
  • FINAL_GRADE_ADJUST (Field19) — VARCHAR
  • TEMPLATE_ID (Key) — NUMBER — Foreign key — NOT NULL
  • FINAL_SCORE_OBJECTIVE (Field) — NUMBER
  • FINAL_SCORE_OBJECTIVE_ADJUST (Field2) — NUMBER
  • FINAL_SCORE_COMPETENCE (Field20) — NUMBER
  • FINAL_SCORE_COMPETENCE_ADJUST (Field21) — NUMBER
  • FINAL_GRADE_OBJECTIVE_ADJUST (Field22) — VARCHAR
  • FINAL_GRADE_COMPETENCE_ADJUST (Field23) — VARCHAR
  • PROMOTION_POINT_COMPETENCE (Field24) — NUMBER
  • PROMOTION_POINT_TOTAL (Field25)

EPER_APPRAISAL_COMPETENCES (Untitled5)

  • APPRAISAL_COMPETENCE_ID (Field) — NUMBER — Primary key
  • TEMPLATE_ID (Field2) — NUMBER
  • APPRAISAL_ID (Field3) — NUMBER
  • COMPETENCE_ID (Field4) — NUMBER
  • REQUIRED_LEVEL (Field5) — VARCHAR
  • WEIGHT (Field6) — NUMBER
  • GRADE (Field7) — VARCHAR
  • SCORE (Field8) — NUMBER
  • COMMENTS (Field9) — VARCHAR
  • SCORE_1ST (Field10) — NUMBER
  • GRADE_1ST (Field11) — VARCHAR
  • PERFORMANCE_DESCRIPTION (Field12) — VARCHAR
  • SCORE_2ND (Field13) — NUMBER
  • APPRAISAL_ID (PK) — NUMBER — Foreign key — NOT NULL
  • TEMPLATE_ID (FK) — NUMBER — Foreign key — NOT NULL
  • COMPETENCE_ID (Key) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_DETAILED_SCORE (Untitled10)

  • DETAILED_SCORE_ID (PK) — NUMBER — Primary key — NOT NULL
  • APPRAISAL_OBJECTIVE_ID (Field) — NUMBER
  • PERSON_ID (Field2) — NUMBER
  • RESULT_TYPE_ID (Field3) — NUMBER
  • RESULT_TYPE (Field4) — VARCHAR
  • GRADE (Field5) — VARCHAR
  • SCORE (Field6) — NUMBER
  • APPRAISER_TYPE (Field7) — VARCHAR
  • APPRAISAL_OBJECTIVE_ID (PK2) — NUMBER — Foreign key — NOT NULL
  • RESULT_TYPE_ID (PK3) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_FEEDBACK (Untitled11)

  • FEEDBACK_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • FROM_PERSON_ID (Field3) — NUMBER
  • TO_PERSON_ID (Field4) — NUMBER
  • COMMENTS (Field5) — VARCHAR
  • FEEDBACK_DATE (Field6) — DATE
  • SOURCE_TYPE (Field7) — VARCHAR
  • SOURCE_ID (Field8) — NUMBER
  • ENABLED_FLAG (Field9) — VARCHAR
  • APPRAISAL_ID (PK2) — NUMBER — Foreign key — NOT NULL
  • TEMPLATE_ID (FK) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_GROUP (Untitled3)

  • GROUP_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (FK) — NUMVER — Primary key — NOT NULL
  • STEP (Field) — VARCHAR
  • APPRAISER_ID (Field2) — NUMBER
  • GROUP_NAME (Field3) — VARCHAR
  • GROUP_CODE (Field4) — VARCHAR
  • START_DATE (Field5) — DATE
  • END_DATE (Field6) — DATE
  • ENABLED_FLAG (Field7) — VARCHAR
  • TEMPLATE_ID (Key) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_GROUP_DETAIL (Untitled4)

  • DETAIL_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • APPRAISAEE_ID (Field3) — NUMBER
  • SCORE_ADJUST (Field4) — NUMBER
  • RANK (Field5) — NUMBER
  • RANK_ADJUST (Field6) — NUMBER
  • GRADE (Field7) — VARCHAR
  • GRADE_ADJUST (Field8) — VARCHAR
  • START_DATE (Field9) — DATE
  • END_DATE (Field10) — DATE
  • ENABLED_FLAG (Field11) — VARCHAR
  • STEP (Field12) — VARCHAR
  • OBJECTIVE_SCORE_ADJUST (Field13) — NUMBER
  • OBJECTIVE_RANK (Field14) — NUMBER
  • OBJECTIVE_RANK_ADJUST (Field15) — NUMBER
  • OBJECTIVE_GRADE (Field16) — VARCHAR
  • OBJECTIVE_GRADE_ADJUST (Field17) — VARCHAR
  • COMPETENCE_SCORE_ADJUST (Field18) — NUMBER
  • COMPETENCE_RANK (Field19) — NUMBER
  • COMPETENCE_RANK_ADJUST (Field20) — NUMBER
  • COMPETENCE_GRADE (Field21) — VARCHAR
  • COMPETENCE_GRADE_ADJUST (Field22) — VARCHAR
  • GROUP_ID (PK2) — NUMBER — Foreign key — NOT NULL
  • TEMPLATE_ID (FK) — NUMVER — Foreign key — NOT NULL

EPER_APPRAISAL_KPI_INFO (KPI내용, 데이터를 꺼내서 테이블에 저장)

  • KPI_ID (PK) — NUMBER — Primary key — NOT NULL
  • JOB_FAMILY (Field) — VARCHAR
  • KPI_NAME (Field2) — VARCHAR
  • KPI_DESCRIPTION (Field3) — VARCHAR
  • KPI_STANDARD (Field4) — VARCHAR
  • KPI_UOM (Field5) — VARCHAR
  • KPI_FORMULA (Field6) — VARCHAR
  • KPI_TYPE (Field7) — VARCHAR

EPER_APPRAISAL_OBJECTIVES (Untitled9)

  • APPRAISAL_OBJECTIVE_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • OBJECTIVE_TYPE_CD (Field3) — VARCHAR
  • OBJECTIVE_TITLE (Field4) — VARCHAR
  • OBJECTIVE_DESCRIPTION (Field5) — VARCHAR
  • OBJECTIVE_KPI (Field6) — VARCHAR
  • WEIGHT (Field7) — NUMBER
  • PERFORMANCE_DESCRIPTION (Field8) — VARCHAR
  • GRADE (Field9) — VARCHAR
  • SCORE (Field10) — NUMBER
  • COMMENTS (Field11) — VARCHAR
  • SCORE_1ST (Field12) — NUMBER
  • GRADE_1ST (Field13) — VARCHAR
  • ENABLED_FLAG (Field14) — VARCHAR
  • SCORE_2ND (Field15) — NUMBER
  • STATUS (Field16) — VARCHAR
  • TARGET_DATE (Field17) — DATE
  • OBJECTIVE_CATEGORY (Field18) — VARCHAR
  • APPRAISAL_ID (PK2) — NUMBER — Foreign key — NOT NULL
  • TEMPLATE_ID (FK) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_OBJECTIVES_HIST (CopyOfUntitled9)

  • HISTORY_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • OBJECTIVE_TYPE_CD (Field3) — VARCHAR
  • OBJECTIVE_TITLE (Field4) — VARCHAR
  • OBJECTIVE_DESCRIPTION (Field5) — VARCHAR
  • OBJECTIVE_KPI (Field6) — VARCHAR
  • WEIGHT (Field7) — NUMBER
  • PERFORMANCE_DESCRIPTION (Field8) — VARCHAR
  • GRADE (Field9) — VARCHAR
  • SCORE (Field10) — NUMBER
  • COMMENTS (Field11) — VARCHAR
  • CURRENT_RECORD_FALG (Field12) — VARCHAR
  • OBJECTIVE_VERSION_NUMBER (Field13) — NUMBER
  • ENABLED_FALG (Field14) — VARCHAR
  • TARGET_DATE (Field15) — DATE
  • STATUS (Field16) — VARCHAR
  • OBJECTIVE_CATEGORY (Field17) — VARCHAR
  • APPRAISAL_OBJECTIVE_ID (PK2) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_OBJ_KEYS (OJB 수정기록 목표별 저장기준)

  • OBJECTIVE_KEY_ID (Key) — NUMBER — Primary key — NOT NULL
  • APPRAISAL_OBJECTIVE_ID (Field) — NUMBER
  • APPRAISAL_ID (Field2) — NUMBER
  • TEMPLATE_ID (Field3) — NUMBER
  • OBJECTIVE_KEY_DESC (Field4) — VARCHAR
  • OBJECTIVE_KEY_TYPE (Field5) — VARCHAR
  • ENABLED_FLAG (Field6) — VARCHAR
  • APPRAISAL_OBJECTIVE_ID (PK) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_RESULT_GRADE (각항목별등급과점수)

  • RESULT_GRADE_ID (PK) — NUMBER — Primary key — NOT NULL
  • RESULT_TYPE_ID (Field) — NUMBER
  • GRADE (Field2) — VARCHAR
  • SCORE (Field3) — NUMBER
  • ENABLED_FLAG (Field4) — VARCHAR
  • RESULT_TYPE_ID (PK2) — NUMBER — Foreign key — NOT NULL

EPER_APPRAISAL_RESULT_TYPE (양질신속성)

  • RESULT_TYPE_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • TEMPLATE_TYPE (Field2) — VARCHAR
  • RESULT_TYPE (Field3) — VARCHAR
  • ENABLED_FLAG (Field4) — VARCHAR

EPER_APPRAISAL_TEMPLATE (Untitled)

  • TEMPLATE_ID (Key) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_NAME (Field) — VARCHAR
  • TEMPLATE_TYPE (Field2) — VARCHAR
  • START_DATE (Field3) — DATE
  • END_DATE (Field4) — DATE
  • APPRAISAL_DATE (Field5) — DATE
  • STATUS (Field6) — VARCHAR
  • ATTRIBUTE1 (Field7) — VARCHAR

EPER_APPRAISAL_TEMPLATE_PERIOD (Untitled2)

  • PERIOD_ID (PK) — NUMBER — Primary key — NOT NULL
  • PERIOD_TYPE (Field) — VARCHAR
  • DESCRIPTION (Field2) — VARCHAR
  • START_DATE (Field3) — DATE
  • END_DATE (Field4) — DATE
  • ENABLED_FLAG (Field5) — VARCHAR
  • ATTRIBUTE1 (Field6) — VARCHAR
  • TEMPLATE_ID (Key) — NUMBER — Foreign key — NOT NULL

EPER_APPR_APPORTION_LINE (Untitled7)

  • LINE_ID (PK) — NUMBER — Primary key — NOT NULL
  • HEADER_ID (Field2) — NUMBER
  • MEMBER_BY_GROUP (Field3) — NUMBER
  • GRADE_FORM (Field4) — VARCHAR
  • GRADE_TO (Field5) — VARCHAR
  • MEMBER_BY_GRADE (Field6) — NUMBER
  • START_DATE (Field7) — DATE
  • END_DATE (Field8) — DATE
  • ENABLED_FLAG (Field9) — VARCHAR

EPER_APPR_APPORTION_RATE (CopyOfUntitled7)

  • RATE_ID (PK) — NUMBER — Primary key — NOT NULL
  • HEADER_ID (Field2) — NUMBER
  • GRADE (Field4) — VARCHAR
  • PERCENTAGE (Field6) — NUMBER
  • START_DATE (Field7) — DATE
  • END_DATE (Field8) — DATE
  • ENABLED_FLAG (Field9) — VARCHAR
  • STANDARD_FLAG (Field) — VARCHAR

EPER_COMPETENCES (Untitled6)

  • COMPETENCE_ID (Key) — NUMBER — Primary key — NOT NULL
  • COMPETENCE_ID (Field) — NUMBER
  • COMPETENCE_NAME (Field2) — VARCHAR
  • CINOETEBCE_TYPE_CD (Field3) — VARCHAR
  • COMPETENCE_DEFINITIONS (Field4) — VARCHAR
  • WEIGHT (Field5) — NUMBER
  • STSART_DATE (Field6) — DATE
  • END_DATE (Field7) — DATE
  • ENABLED_FLAG (Field8) — VARCHAR

EPER_COMPETENCE_ELEMENT (각 COM이 어떤 분야/직급에 해당하는지)

  • ELEMENT_ID (PK) — NUMBER — Primary key — NOT NULL
  • ELEMENT_ID (Field) — NUMBER
  • COMPETENCE_ID (Field2) — NUMBER
  • APPRAISAL_TEMPLATE_CD (Field3) — VARCHAR
  • WEIGHT (Field4) — NUMBER
  • START_DATE (Field5) — DATE
  • END_DATE (Field6) — DATE
  • ENABLED_FLAG (Field7) — VARCHAR
  • COMPETENCE_ID (Key) — NUMBER — Foreign key — NOT NULL

EPER_COMPETENCE_LEVEL (Untitled8)

  • LEVEL_ID (PK) — NUMBER — Primary key — NOT NULL
  • COMPETENCE_ID (Field) — NUMBER
  • COMPETENCE_LEVEL (Field2) — VARCHAR
  • GRADE (Field3) — VARCHAR
  • LEVEL_DEFINITIONS (Field4) — VARCHAR
  • START_DATE (Field5) — DATE
  • END_DATE (Field6) — DATE
  • ENABLED_FLAG (Field7) — VARCHAR
  • COMPETENCE_ID (Key) — NUMBER — Foreign key — NOT NULL

EPER_SELF_DEVELOPMENT_PLAN (Untitled12)

  • PLAN_ID (PK) — NUMBER — Primary key — NOT NULL
  • TEMPLATE_ID (Field) — NUMBER
  • PERSON_ID (Field2) — NUMBER
  • GRADE (Field3) — VARCHAR
  • P1...P4 (Field4) — NUMBER OR VARCHAR
  • TEMPLATE_ID (Key) — NUMBER — Foreign key — NOT NULL