Provides the details on the Goal Tasks (also called Actions)
Module: Goal Management
GOAL_ACTION_ID
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
|---|---|---|---|---|---|---|---|
| GOAL_ACTION_ID | NUMBER | 38 | 0 | True | Goal action Identifier | ||
| SOURCE_RECORD_ID | VARCHAR2 | 512 | This column is for Oracle Internal use only. Source Record Identifier:It is Goal action Identifier | ||||
| BUSINESS_GROUP_ID | NUMBER | 38 | 0 | Business Group Identifier | |||
| GOAL_ID | NUMBER | 38 | 0 | Goal Identifier | DW_GOAL_F | GOAL_ID | |
| ACTION_TYPE_CODE | VARCHAR2 | 32 | Type of Action | DW_GOAL_ACTION_TYPE_D_TL | ACTION_TYPE_CODE | ||
| PRIORITY_CODE | VARCHAR2 | 32 | Priortiy of Action | DW_GOAL_PRIORITY_D_TL | PRIORITY_CODE | ||
| START_DATE | DATE | Start Date | |||||
| TARGET_COMPLETION_DATE | DATE | Target Completion Date | |||||
| PERCENT_COMPLETE_CODE | VARCHAR2 | 32 | Percentage complete code | ||||
| STATUS_CODE | VARCHAR2 | 32 | Status of the task | DW_GOAL_TASK_STATUS_D_TL | STATUS_CODE | ||
| ACTION_NAME | VARCHAR2 | 256 | Action/Task Name |
Copyright © 2019, 2024, Oracle and/or its affiliates.