This table stores the structure and process for creating performance evaluations
Module: Performance Management
TEMPLATE_DEFINITION_ID, BUSINESS_GROUP_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
TEMPLATE_DEFINITION_ID | NUMBER | 38 | 0 | True | Business Key for Template Definition | ||
BUSINESS_GROUP_ID | NUMBER | 38 | 0 | True | Business Group identifier | ||
SOURCE_RECORD_ID | VARCHAR2 | 128 | Unique Key consisting of TEMPLATE_DEFINITION_ID, BUSINESS_GROUP_ID | ||||
TEMPLATE_TYPE_CODE | VARCHAR2 | 32 | Identifies template type of the performance document. | ||||
VALID_FROM_DATE | DATE | This is the date when the performance template is valid from | |||||
VALID_TO_DATE | DATE | This is the last day that the performance template is valid | |||||
TEMPLATE_STATUS_CODE | VARCHAR2 | 32 | Status of the Performance Template(Active/Inactive) | ||||
DOC_TYPE_ID | NUMBER | 38 | 0 | Document Type. | DW_PERF_DOCUMENT_TYPE_D_TL | DOC_TYPE_ID | |
PROCESS_FLOW_ID | NUMBER | 38 | 0 | Indicates the Process Flow definiton that is used in template definiton for internal processing. |