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]

VIEW: APPS.HRBV_APPRAISALS_V

Object Details

Object Name:	HRBV_APPRAISALS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A Business Intelligence System view

Appraisal (from PER_APPRAISALS table).

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
APPRAISAL_DATE	DATE			Appraisal date.
GROUP_DATE	DATE			Group date.
APPRAISAL_PERIOD_END_DATE	DATE		Yes	Appraisal period end date.
APPRAISAL_PERIOD_START_DATE	DATE		Yes	Appraisal period start date.
TYPE	VARCHAR2	(30)		(Lookup code based on lookup type APPRAISAL_TYPE).
TYPE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APPRAISAL_TYPE).
NEXT_APPRAISAL_DATE	DATE			Next appraisal date.
STATUS	VARCHAR2	(30)		(Lookup code based on lookup type APPRAISAL_ASSESSMENT_STATUS).
STATUS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APPRAISAL_ASSESSMENT_STATUS).
COMMENTS	VARCHAR2	(2000)		Comments.
OPEN	VARCHAR2	(30)		(Lookup code based on lookup type YES_NO).
OPEN_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type YES_NO).
SYSTEM_TYPE	VARCHAR2	(30)		(Lookup code based on lookup type APPRAISAL_SYS_TYPE).
SYSTEM_TYPE_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APPRAISAL_SYS_TYPE).
APPRAISAL_SYSTEM_STATUS	VARCHAR2	(30)		(Lookup code based on lookup type APPRAISAL_SYSTEM_STATUS).
APPRAISAL_SYSTEM_STATUS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APPRAISAL_SYSTEM_STATUS).
SYSTEM_PARAMS	VARCHAR2	(500)		System params.
APPRAISEE_ACCESS	VARCHAR2	(30)		(Lookup code based on lookup type APPRAISEE_ACCESS).
APPRAISEE_ACCESS_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type APPRAISEE_ACCESS).
ASSIGNMENT_START_DATE	DATE			Assignment start date.
POTENTIAL_READINESS_LEVEL	VARCHAR2	(30)		(Lookup code based on lookup type READINESS_LEVEL).
POTENTIAL_READINESS_LEVEL_M	VARCHAR2	(4000)		(Lookup meaning based on lookup type READINESS_LEVEL).
POTENTIAL_SHORT_TERM_WORKOPP	VARCHAR2	(240)		Potential short term workopp.
POTENTIAL_LONG_TERM_WORKOPP	VARCHAR2	(240)		Potential long term workopp.
POTENTIAL_DETAILS	VARCHAR2	(2000)		Potential details.
_DF:APR	CHAR	(26)
APPRAISAL_ID	NUMBER	(15)	Yes	Primary key for PER_APPRAISALS.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS.
APPRAISAL_TEMPLATE_ID	NUMBER	(15)	Yes	Foreign key to PER_APPRAISAL_TEMPLATES.
APPRAISEE_PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_PEOPLE_F.
APPRAISER_PERSON_ID	NUMBER	(15)	Yes	Foreign key to PER_ALL_PEOPLE_F.
GROUP_INITIATOR_ID	NUMBER	(9)		Foreign key to PER_ALL_PEOPLE_F
OVERALL_PERFORMANCE_LEVEL_ID	NUMBER	(15)		Foreign key to PER_RATING_LEVELS.
MAIN_APPRAISER_ID	NUMBER	(15)		Foreign Key to PER_ALL_PEOPLE_F .
ASSIGNMENT_ID	NUMBER	(15)		Foreign key to PER_ALL_ASSIGNMENTS_F.
ASSIGNMENT_BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
ASSIGNMENT_ORGANIZATION_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATION_UNITS.
ASSIGNMENT_JOB_ID	NUMBER	(15)		Foreign key to PER_JOBS
ASSIGNMENT_POSITION_ID	NUMBER	(15)		Foreign key to PER_ALL_POSITIONS.
ASSIGNMENT_GRADE_ID	NUMBER	(15)		Foreign key to PER_GRADES.
EVENT_ID	NUMBER	(15)		Foreign key to PER_EVENTS.
LAST_UPDATE_DATE	DATE			Standard who column
LAST_UPDATED_BY	NUMBER	(15)		Standard who column
CREATED_BY	NUMBER	(15)		Standard who column
CREATION_DATE	DATE			Standard who column
BG_SECURITY_FLAG_CODE	CHAR	(1)		Business group security flag code.

Query Text

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


SELECT APPRAISAL_DATE
,      GROUP_DATE
,      APPRAISAL_PERIOD_END_DATE
,      APPRAISAL_PERIOD_START_DATE
,      TYPE
,      TYPE_M
,      NEXT_APPRAISAL_DATE
,      STATUS
,      STATUS_M
,      COMMENTS
,      OPEN
,      OPEN_M
,      SYSTEM_TYPE
,      SYSTEM_TYPE_M
,      APPRAISAL_SYSTEM_STATUS
,      APPRAISAL_SYSTEM_STATUS_M
,      SYSTEM_PARAMS
,      APPRAISEE_ACCESS
,      APPRAISEE_ACCESS_M
,      ASSIGNMENT_START_DATE
,      POTENTIAL_READINESS_LEVEL
,      POTENTIAL_READINESS_LEVEL_M
,      POTENTIAL_SHORT_TERM_WORKOPP
,      POTENTIAL_LONG_TERM_WORKOPP
,      POTENTIAL_DETAILS
,      _DF:APR
,      APPRAISAL_ID
,      BUSINESS_GROUP_ID
,      APPRAISAL_TEMPLATE_ID
,      APPRAISEE_PERSON_ID
,      APPRAISER_PERSON_ID
,      GROUP_INITIATOR_ID
,      OVERALL_PERFORMANCE_LEVEL_ID
,      MAIN_APPRAISER_ID
,      ASSIGNMENT_ID
,      ASSIGNMENT_BUSINESS_GROUP_ID
,      ASSIGNMENT_ORGANIZATION_ID
,      ASSIGNMENT_JOB_ID
,      ASSIGNMENT_POSITION_ID
,      ASSIGNMENT_GRADE_ID
,      EVENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
,      BG_SECURITY_FLAG_CODE
FROM APPS.HRBV_APPRAISALS_V;

Dependencies

[top of page]

APPS.HRBV_APPRAISALS_V references the following:

APPS: HR_BIS - show dependent code; PER_APPRAISALS

APPS.HRBV_APPRAISALS_V is not referenced by any database object