This is version 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

MAINTAIN DEVELOPMENT GOALS#

The Maintain Development Goals ISDG form displays .......

Experience Data is maintained on the P2K_SA_REVIEWS, P2K_SA_GOAL_GROUPS, P2K_SA_DEVELOPMENT_GOALS, and P2K_SA_GOAL_ACTIVITES tables.

Number

Status

Review Phase

Reset Goals Dev

Period From/Period To

These fields define the review period.

Merit Month

Sign Off Received

Assignment

Entity

Submit Goals For

Cancel Review

Show Activities

---

Review Goals tab#

Competencies

Descriptions

Weight

Overall Point

Goals#

Seq

Job

Description

Start Date

Completion Date

Wgt

EE Rating

MRG Rating

---

Details tab#

End Date

Goal Status

Category

Competence Origin

Months in Job

Range

Activity Required By

Completion Level

Employee Comments

Manager Comments

---

Metric#

Metric

---

Activities#

Start Date

End Date

Review Phase

Comments

Management Only

Comments By

Goal Activity Type

Goal Activity Status

---

Review Comments tab#

General

Employee

This field allows the employee to add comments regarding the review.

Manager

This field allows the manager to add comments regarding the review.

---

Notes #

Click to create a new notes page

Column name	Data Type / Size	Domain	Mand.	Notes
ID	Number(10)	ID	Y
DEN_ID	Number(10)	ID	Y	link to P2K_CM_ENTITIES
REVIEW_NUMBER	Number(10)	NUMBER10	Y
SRT_ID	Number(10)	ID	Y	link to P2K_SA_REVIEW_TYPES
EAS_ID	Number(10)	ID	Y	link to P2K_HR_ASSIGNMENTS
MUS_ID	Number(10)	ID		link to P2K_AM_USERS
MEX_ID	Number(10)	ID		link to P2K_AM_EXECUTIONS, originating execution
SMX_ID	Number(10)	ID		link to P2K_SA_SALARY_MATRICES
REVIEW_STATUS	Varchar2(2)	X_REVIEW_STATUS	Y
REVIEW_DATE	Date()	DATE	Y
NEXT_REVIEW_DATE	Date()	DATE
REVIEW_METHOD	Varchar2(2)	X_REVIEW_METHOD
APPROVED	Varchar2(1)	TOGGLE
REVIEW_DONE_BY	Varchar2(50)	DESCRIPTION
OVERALL_RATING	Varchar2(2)	X_OVERALL_RATING
OVERALL_POINTS	Number(5)	NUMBER5
BASED_ON_PRIOR_JOB	Varchar2(1)	TOGGLE
DESCRIPTION	Varchar2(50)	DESCRIPTION
REVIEW_COMMENTS	Varchar2(2000)	VARCHAR2000
CREATE_DATE	Date()	DATE	Y
CREATE_USER	Varchar2(30)	VARCHAR30	Y
CHANGE_DATE	Date()	DATE	Y
CHANGE_USER	Varchar2(30)	VARCHAR30	Y
MERIT_MONTHS	Number(10)	NUMBER10
EE_SIGN_OFF	Varchar2(1)	TOGGLE
EID_ID_REVIEWER	Number(10)	ID		link to P2K_HR_IDENTITIES
RASE_ID	Number(10)	ID		link to P2K_RE_ASSESSMENT_EVENTS
INCENTIVE_PERCENT	Number(5)	NUMBER5
REVIEW_PHASE	Varchar2(2)	X_REVIEW_PHASE
REVIEW_PERIOD_FROM	Date()	DATE
REVIEW_PERIOD_TO	Date()	DATE
COMMENTS_EE	Varchar2(4000)	VARCHAR4000
COMMENTS_MGR	Varchar2(4000)	VARCHAR4000

Derived Fields#

Column Name
DRV_APPROVAL_BAR
DRV_APPROVAL_COMMENTS
DRV_AVERAGE_POINTS
DRV_TOTAL_REVIEW_POINTS
DRV_TOTAL_WEIGHTED_POINTS