Performance Document Status Fact
Module: Performance Management
EVALUATION_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
EVALUATION_ID | NUMBER | 38 | 0 | True | Business key of the performance document. | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Unique Key - EVALUATION_ID | ||||
EVALUATION_DATE | DATE | The date on which the evaluation takes place | |||||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group identifier | |||
PERSON_ID | NUMBER | 38 | 0 | Worker/person identifier | DW_PERSON_D | PERSON_ID | |
MANAGER_ID | NUMBER | 38 | 0 | Evaluation document manager identifier | DW_PERSON_D | PERSON_ID | |
ASSIGNMENT_ID | NUMBER | 38 | 0 | Assignment identifier on which the evaluation is performed | |||
TEMPLATE_DEFINITION_ID | NUMBER | 38 | 0 | Template Definitions identifier | DW_PERF_TEMPLATE_DEF_D | TEMPLATE_DEFINITION_ID | |
TEMPLATE_PERIOD_ID | NUMBER | 38 | 0 | Template Period identifier | DW_PERF_TEMPLATE_PERIOD_D | TEMPLATE_PERIOD_ID | |
STATUS_CODE | VARCHAR2 | 32 | The status code of the performance document | ||||
PREV_STATUS_CODE | VARCHAR2 | 32 | The previous status code of the performance document | ||||
START_DATE | DATE | Start Date of performance document | |||||
END_DATE | DATE | End Date of performance document |
Copyright © 2019, 2022, Oracle and/or its affiliates.