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_APPRAISAL_TEMPLATES

Object Details

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

The appraisal template is the header of, or grouping for, a number of
appraisal questions. Each appraisal template defines a type of
appraisal e.g. Annual performance review.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PER_APPRAISAL_TEMPLATES_PK

APPRAISAL_TEMPLATE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_APPRAISAL_TEMPLATES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	APPRAISAL_TEMPLATE_ID
PER_APPRAISAL_TEMPLATES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PER_APPRAISAL_TEMPLATES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSESSMENT_TYPE_ID
PER_APPRAISAL_TEMPLATES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RATING_SCALE_ID
PER_APPRAISAL_TEMPLATES_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	QUESTIONNAIRE_TEMPLATE_ID
PER_APPRAISAL_TEMPLATES_UK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME BUSINESS_GROUP_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
PER_APPRAISAL_TEMPLATES	HR_ALL_ORGANIZATION_UNITS	PER_APPRAISAL_TEMPLATES BUSINESS_GROUP_ID
PER_APPRAISAL_TEMPLATES	HR_QUESTIONNAIRES	PER_APPRAISAL_TEMPLATES QUESTIONNAIRE_TEMPLATE_ID
PER_APPRAISAL_TEMPLATES	PER_ASSESSMENT_TYPES	PER_APPRAISAL_TEMPLATES ASSESSMENT_TYPE_ID
PER_APPRAISAL_TEMPLATES	PER_RATING_SCALES	PER_APPRAISAL_TEMPLATES RATING_SCALE_ID
PER_APPRAISALS	PER_APPRAISAL_TEMPLATES	PER_APPRAISALS APPRAISAL_TEMPLATE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
APPRAISAL_TEMPLATE_ID	NUMBER	(15)	Yes	Primary key of Appraisal Template
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
NAME	VARCHAR2	(80)	Yes	Name or Title of the Appraisal Template
DESCRIPTION	VARCHAR2	(2000)		A brief description of the nature and purpose of the appraisal te
DATE_FROM	DATE			The date from which the Appraisal Template is valid
DATE_TO	DATE			The date until which the Appraisal Template is valid
ASSESSMENT_TYPE_ID	NUMBER	(9)		Unique identifier of assessment type
RATING_SCALE_ID	NUMBER	(9)		Primary Key for PER_RATING_SCALES
QUESTIONNAIRE_TEMPLATE_ID	NUMBER			Foreign key to PER_PROPOSAL_QUESTION_TYPES.
QUESTIONNAIRE_LANGUAGE	VARCHAR2	(30)		The language of the Questionnaire
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
LAST_UPDATE_DATE	DATE			Standard Who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column.
CREATED_BY	NUMBER	(15)		Standard Who column.
CREATION_DATE	DATE			Standard Who column.
INSTRUCTIONS	LONG	(0)		General instructions on how to complete the Appraisal
OBJECTIVE_ASMNT_TYPE_ID	NUMBER	(9)		Identifier of assessment type
MA_QUEST_TEMPLATE_ID	NUMBER	(15)		Foreign key to HR_QUESTIONNAIRES
LINK_APPR_TO_LEARNING_PATH	VARCHAR2	(30)		Indicates Learning path is enabled
FINAL_SCORE_FORMULA_ID	NUMBER	(9)		Foreign key to FF_FORMULAS
UPDATE_PERSONAL_COMP_PROFILE	VARCHAR2	(30)		Indicates whether personal competency profile is updated
COMP_PROFILE_SOURCE_TYPE	VARCHAR2	(150)		Source of proficieny level value in PER_COMPETENCE_ELEMENTS
SHOW_COMPETENCY_RATINGS	VARCHAR2	(30)		Flag to show Competency ratings
SHOW_OBJECTIVE_RATINGS	VARCHAR2	(30)		Flag to show Objective ratings
SHOW_OVERALL_RATINGS	VARCHAR2	(30)		Flag to show overall ratings
SHOW_OVERALL_COMMENTS	VARCHAR2	(30)		Flag to show overall comments
PROVIDE_OVERALL_FEEDBACK	VARCHAR2	(30)		Flag to providing overall feedback
SHOW_PARTICIPANT_DETAILS	VARCHAR2	(30)		Flag to show Participant Details
ALLOW_ADD_PARTICIPANT	VARCHAR2	(30)		Indicates whether addition of participant is allowed
SHOW_ADDITIONAL_DETAILS	VARCHAR2	(30)		Flag to Show Additional Details
SHOW_PARTICIPANT_NAMES	VARCHAR2	(30)		Flag to show Participant Names
SHOW_PARTICIPANT_RATINGS	VARCHAR2	(30)		Show Participant Ratings
AVAILABLE_FLAG	VARCHAR2	(30)		Indicates whether template is available
SHOW_QUESTIONNAIRE_INFO	VARCHAR2	(30)		Show Questionnaire Info flag
MA_OFF_TEMPLATE_CODE	VARCHAR2	(80)		Main Appraiser's Offline Template Code
APPRAISEE_OFF_TEMPLATE_CODE	VARCHAR2	(80)		Appraisee's Offline Template Code
OTHER_PART_OFF_TEMPLATE_CODE	VARCHAR2	(80)		Other Participant's Offline Template Code
PART_REV_OFF_TEMPLATE_CODE	VARCHAR2	(80)		Reviewer's Offline Template Code
PART_APP_OFF_TEMPLATE_CODE	VARCHAR2	(80)		Appraiser's Offline Template Code

Query Text

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


SELECT APPRAISAL_TEMPLATE_ID
,      BUSINESS_GROUP_ID
,      OBJECT_VERSION_NUMBER
,      NAME
,      DESCRIPTION
,      DATE_FROM
,      DATE_TO
,      ASSESSMENT_TYPE_ID
,      RATING_SCALE_ID
,      QUESTIONNAIRE_TEMPLATE_ID
,      QUESTIONNAIRE_LANGUAGE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      INSTRUCTIONS
,      OBJECTIVE_ASMNT_TYPE_ID
,      MA_QUEST_TEMPLATE_ID
,      LINK_APPR_TO_LEARNING_PATH
,      FINAL_SCORE_FORMULA_ID
,      UPDATE_PERSONAL_COMP_PROFILE
,      COMP_PROFILE_SOURCE_TYPE
,      SHOW_COMPETENCY_RATINGS
,      SHOW_OBJECTIVE_RATINGS
,      SHOW_OVERALL_RATINGS
,      SHOW_OVERALL_COMMENTS
,      PROVIDE_OVERALL_FEEDBACK
,      SHOW_PARTICIPANT_DETAILS
,      ALLOW_ADD_PARTICIPANT
,      SHOW_ADDITIONAL_DETAILS
,      SHOW_PARTICIPANT_NAMES
,      SHOW_PARTICIPANT_RATINGS
,      AVAILABLE_FLAG
,      SHOW_QUESTIONNAIRE_INFO
,      MA_OFF_TEMPLATE_CODE
,      APPRAISEE_OFF_TEMPLATE_CODE
,      OTHER_PART_OFF_TEMPLATE_CODE
,      PART_REV_OFF_TEMPLATE_CODE
,      PART_APP_OFF_TEMPLATE_CODE
FROM HR.PER_APPRAISAL_TEMPLATES;

Dependencies

[top of page]

HR.PER_APPRAISAL_TEMPLATES does not reference any database object

HR.PER_APPRAISAL_TEMPLATES is referenced by following:

APPS: PER_APPRAISAL_TEMPLATES; PER_APPRAISAL_TEMPLATES_WHO
PUBLIC: PER_APPRAISAL_TEMPLATES