| Table PA_Goal |
| PRIMARY KEY | ||
|
PA_Goal_ID
NUMBER (10, 0) NOT NULL | ||
|
AD_Client_ID
NUMBER (10, 0) NOT NULL | ||
|
AD_Org_ID
NUMBER (10, 0) NOT NULL | ||
|
IsActive
CHAR (1) default: 'Y' CHECK ( IsActive in ( 'Y' , 'N' )) NOT NULL | ||
|
Created
DATE default: SYSDATE NOT NULL | ||
|
CreatedBy
NUMBER (10, 0) NOT NULL | ||
|
Updated
DATE default: SYSDATE NOT NULL | ||
|
UpdatedBy
NUMBER (10, 0) NOT NULL | ||
|
Name
NVARCHAR2 (60) NOT NULL | ||
|
Description
NVARCHAR2 (255) | ||
|
Note
NVARCHAR2 (2000) | ||
|
RelativeWeight
NUMBER NOT NULL | ||
|
IsSummary
CHAR (1) default: 'N' NOT NULL | ||
|
Parent_ID
NUMBER (10, 0) | PA_Goal | |
|
SeqNo
NUMBER (10, 0) NOT NULL | ||
|
PA_Measure_ID
NUMBER (10, 0) NOT NULL | PA_Measure | |
|
MeasureTarget
NUMBER NOT NULL | ||
|
MeasureActual
NUMBER NOT NULL | ||
|
GoalPerformance
NUMBER NOT NULL | Measures achieving the goal from 0 to 1 | |
|
DateLastRun
DATE | When was actual performance calvulated | |
FOREIGN KEY PA_Goal_Parent: Parent_ID => PA_Goal PAMeasure_PAGoal: PA_Measure_ID => PA_Measure | ||
REFERENCED BY AD_ClientInfo, AD_OrgInfo, AD_User, AD_User, AD_Workbench, PA_Goal | ||