# DW_PERF_TEMPLATE_DEF_D

This table stores the structure and process for creating performance evaluations

## Details

Module: Performance Management

## Key Columns

BUSINESS_GROUP_ID, TEMPLATE_DEFINITION_ID

## Columns

Columns
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 |  |  | This column is for Oracle Internal use only. 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. |  |

Copyright © 2019, 2025, Oracle and/or its affiliates.