eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PER_PERF_MGMT_PLANS

Object Details

Object Name:	PER_PERF_MGMT_PLANS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_PERF_MGMT_PLANS
Subobject Name:
Status:	VALID

PER_PERF_MGMT_PLANS holds plans that control and automate performance management and its associated tasks.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_PERF_MGMT_PLANS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PLAN_ID
PER_PERF_MGMT_PLANS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERVISOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER	(15)	Yes	System generated plan primary key from PER_PERF_MGMT_PLANS_S.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	System-generated version of row. Increments by one with each update.
PLAN_NAME	VARCHAR2	(400)	Yes	The name for the performance management plan.
ADMINISTRATOR_PERSON_ID	NUMBER	(15)	Yes	The designated person who is the administrator of the plan.
PREVIOUS_PLAN_ID	NUMBER	(15)		The Id of the Performance Management Plan that preceded this one.
START_DATE	DATE		Yes	The date when the plan starts.
END_DATE	DATE		Yes	The date when the plan ends.
STATUS_CODE	VARCHAR2	(30)	Yes	Uses the lookup type HR_WPM_PLAN_STATUS to define the plan's status.
HIERARCHY_TYPE_CODE	VARCHAR2	(30)		Uses the lookup type HR_WPM_PLAN_HIER_TYPE to define the type of hierarchy used to define the plan's population.
SUPERVISOR_ID	NUMBER	(15)		When the hierarchy type is 'SUP', this is the top supervisor in the hierarchy.
SUPERVISOR_ASSIGNMENT_ID	NUMBER	(15)		When the hierarchy type is 'SUP_ASG', this is the assignment for the top supervisor in the hierarchy.
ORGANIZATION_STRUCTURE_ID	NUMBER	(15)		When the hierarchy type is 'ORG', this is the organization hierarchy used to define the plan's population.
ORG_STRUCTURE_VERSION_ID	NUMBER	(15)		The version number of the organization hierarchy.
TOP_ORGANIZATION_ID	NUMBER	(15)		When the hierarchy type is 'ORG', this is the top organization in the hierarchy.
POSITION_STRUCTURE_ID	NUMBER	(15)		When the hierarchy type is 'POS', this is the position hierarchy used to define the plan's population.
POS_STRUCTURE_VERSION_ID	NUMBER	(15)		The version number of the position hierarchy.
TOP_POSITION_ID	NUMBER	(15)		When the hierarchy type is 'POS', this is the top position in the hierarchy.
HIERARCHY_LEVELS	NUMBER	(15)		The levels to go down the hierarchy before excluding people from the plan's population; null for all levels.
AUTOMATIC_ENROLLMENT_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', life events are used to automatically enroll/de-enroll people from the plan.
ASSIGNMENT_TYPES_CODE	VARCHAR2	(30)	Yes	Uses HR_WPM_ASG_TYPES to determine which assignments will receive a scorecard.
PRIMARY_ASG_ONLY_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', personal scorecards are only created for the primary assignment.
INCLUDE_OBJ_SETTING_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', it indicates that objective setting will be part of this plan's process.
OBJ_SETTING_START_DATE	DATE			The date when objective setting should start.
OBJ_SETTING_DEADLINE	DATE			The date by which objectives should be set.
OBJ_SET_OUTSIDE_PERIOD_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', objectives can be set at any point during the plan.
METHOD_CODE	VARCHAR2	(30)	Yes	Uses HR_WPM_PLAN_METHOD to determine the method of setting objectives: 'CAS' for a cascading objectives method, 'PAR' for non-cascading method.
NOTIFY_POPULATION_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', notifications will be automatically sent to the plan's population.
AUTOMATIC_ALLOCATION_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', objectives from the objectives library are automatically allocated to plan members that are eligible.
COPY_PAST_OBJECTIVES_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', incomplete objectives are copied from the Previous Plan (as defined against this plan). When the Previous Plan is not defined, incomplete objectives are instead copied from the most recent past appraisal (which itself cannot be part of a Performance Management Plan).
SHARING_ALIGNMENT_TASK_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', an additional manager and employee task is displayed for objective sharing and alignment.
INCLUDE_APPRAISALS_FLAG	VARCHAR2	(30)	Yes	When set to 'Y', it indicates that appraisals will be part of this plan's process.
CHANGE_SC_STATUS_FLAG	VARCHAR2	(30)		When set to 'Y', it indicates scorecard status has to be changed
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE16	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE17	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE18	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE19	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE20	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE21	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE22	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE23	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE24	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE25	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE26	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE27	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE28	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE29	VARCHAR2	(150)		Descriptive flexfield column.
ATTRIBUTE30	VARCHAR2	(150)		Descriptive flexfield column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
UPDATE_LIBRARY_OBJECTIVES	VARCHAR2	(30)		signifies whether the library objectives will be overridden once the plan is republished.
AUTOMATIC_APPROVAL_FLAG	VARCHAR2	(30)		Automatic Approval Flag

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PLAN_ID
,      OBJECT_VERSION_NUMBER
,      PLAN_NAME
,      ADMINISTRATOR_PERSON_ID
,      PREVIOUS_PLAN_ID
,      START_DATE
,      END_DATE
,      STATUS_CODE
,      HIERARCHY_TYPE_CODE
,      SUPERVISOR_ID
,      SUPERVISOR_ASSIGNMENT_ID
,      ORGANIZATION_STRUCTURE_ID
,      ORG_STRUCTURE_VERSION_ID
,      TOP_ORGANIZATION_ID
,      POSITION_STRUCTURE_ID
,      POS_STRUCTURE_VERSION_ID
,      TOP_POSITION_ID
,      HIERARCHY_LEVELS
,      AUTOMATIC_ENROLLMENT_FLAG
,      ASSIGNMENT_TYPES_CODE
,      PRIMARY_ASG_ONLY_FLAG
,      INCLUDE_OBJ_SETTING_FLAG
,      OBJ_SETTING_START_DATE
,      OBJ_SETTING_DEADLINE
,      OBJ_SET_OUTSIDE_PERIOD_FLAG
,      METHOD_CODE
,      NOTIFY_POPULATION_FLAG
,      AUTOMATIC_ALLOCATION_FLAG
,      COPY_PAST_OBJECTIVES_FLAG
,      SHARING_ALIGNMENT_TASK_FLAG
,      INCLUDE_APPRAISALS_FLAG
,      CHANGE_SC_STATUS_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UPDATE_LIBRARY_OBJECTIVES
,      AUTOMATIC_APPROVAL_FLAG
FROM HR.PER_PERF_MGMT_PLANS;

Dependencies

[top of page]

HR.PER_PERF_MGMT_PLANS does not reference any database object

HR.PER_PERF_MGMT_PLANS is referenced by following:

HR: PER_PERF_MGMT_PLANS#