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.PER_ZA_AREAS_OF_ASSESSMENT_V

Object Details

Object Name:	PER_ZA_AREAS_OF_ASSESSMENT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_ZA_AREAS_OF_ASSESSMENT_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

PER_ZA_AREAS_OF_ASSESSMENT_V is used to maintain table PER_ZA_AREAS_OF_ASSESSMENT via NQF forms.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
AREA_OF_ASSESSMENT_ID	NUMBER	(9)	Yes	Unique Area of Assessment Identifier
ASSESSMENT_ID	NUMBER	(9)	Yes	Assessment Identifier
AREA_OF_ASSESSMENT	VARCHAR2	(80)	Yes	Area of Assessment Description
AREA_OF_ASSESSMENT_MEANING	VARCHAR2	(4000)		Area of Assessment Meaning
ASSESSMENT_RESULT	VARCHAR2	(120)		Assessment Results - free text
ASSESSMENT_RESULT_MEANING	VARCHAR2	(4000)		Assessment Result Meaning
ASSESSMENT_CRITERIA	VARCHAR2	(120)		Assessment Criteria - free text
ASSESSMENT_CRITERIA_MEANING	VARCHAR2	(4000)		Assessment Criteria Meaning

Query Text

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


SELECT AREA_OF_ASSESSMENT_ID
,      ASSESSMENT_ID
,      AREA_OF_ASSESSMENT
,      AREA_OF_ASSESSMENT_MEANING
,      ASSESSMENT_RESULT
,      ASSESSMENT_RESULT_MEANING
,      ASSESSMENT_CRITERIA
,      ASSESSMENT_CRITERIA_MEANING
FROM APPS.PER_ZA_AREAS_OF_ASSESSMENT_V;

Dependencies

[top of page]

APPS.PER_ZA_AREAS_OF_ASSESSMENT_V references the following:

APPS: HR_GENERAL - show dependent code; PER_ZA_AREAS_OF_ASSESSMENT

APPS.PER_ZA_AREAS_OF_ASSESSMENT_V is not referenced by any database object