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