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_ASSESSMENTS_V

Object Details

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

View Type

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

PER_ZA_ASSESSMENTS_V is used to maintain table PER_ZA_ASSESSMENTS via NQF forms.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ASSESSMENT_ID	NUMBER	(9)	Yes	Unique Assessment Identifier
PERSON_ID	NUMBER	(9)	Yes	Person Identifier
LEVEL_ID	NUMBER	(9)		Assessment Level Identifier
NAME_OF_ASSESSOR	VARCHAR2	(120)		Name of the Assessor
INSTITUTION	VARCHAR2	(120)		Institution where assessment was done
CREDIT	NUMBER	(10)		Credits earned by person for this assessment
DATE_OF_ASSESSMENT	DATE			Date of the assessment
FINAL_RESULT	VARCHAR2	(120)		Final Results obtained by person after assessment - free text
FINAL_RESULT_MEANING	VARCHAR2	(4000)		Final Result Meaning
ASSESSMENT_NUMBER	VARCHAR2	(10)		Assessment reference number
LOCATION_WHERE_ASSESSED	VARCHAR2	(200)		Physical location where assessed
FIELD_OF_LEARNING	VARCHAR2	(30)		Assessment's field of Learning
FIELD_OF_LEARNING_MEANING	VARCHAR2	(4000)		Field of Learning meaning
SUB_FIELD	VARCHAR2	(120)		Assessment's sub field of Learning
ASSESSMENT_START_DATE	DATE			Assessment start date
ASSESSMENT_END_DATE	DATE			Assessment end date
COMPETENCE_ACQUIRED	VARCHAR2	(30)		Competence acquired in assessment
COMPETENCE_ACQUIRED_MEANING	VARCHAR2	(4000)		Competence acquired meaning
ETQA_NAME	VARCHAR2	(30)		ETQA (Government related) name
ETQA_NAME_MEANING	VARCHAR2	(4000)		ETQA Name meaning
CERTIFICATION_DATE	DATE			Date of certification
CERTIFICATE_NUMBER	VARCHAR2	(30)		Certificate Number
ACCREDITED_BY	VARCHAR2	(80)		Date of accreditation
DATE_OF_ACCREDITATION	DATE			Date of accreditation
CERTIFICATION_EXPIRY_DATE	DATE			Certification expiry date

Query Text

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


SELECT ASSESSMENT_ID
,      PERSON_ID
,      LEVEL_ID
,      NAME_OF_ASSESSOR
,      INSTITUTION
,      CREDIT
,      DATE_OF_ASSESSMENT
,      FINAL_RESULT
,      FINAL_RESULT_MEANING
,      ASSESSMENT_NUMBER
,      LOCATION_WHERE_ASSESSED
,      FIELD_OF_LEARNING
,      FIELD_OF_LEARNING_MEANING
,      SUB_FIELD
,      ASSESSMENT_START_DATE
,      ASSESSMENT_END_DATE
,      COMPETENCE_ACQUIRED
,      COMPETENCE_ACQUIRED_MEANING
,      ETQA_NAME
,      ETQA_NAME_MEANING
,      CERTIFICATION_DATE
,      CERTIFICATE_NUMBER
,      ACCREDITED_BY
,      DATE_OF_ACCREDITATION
,      CERTIFICATION_EXPIRY_DATE
FROM APPS.PER_ZA_ASSESSMENTS_V;

Dependencies

[top of page]

APPS.PER_ZA_ASSESSMENTS_V references the following:

APPS: HR_GENERAL - show dependent code; PER_ZA_ASSESSMENTS

APPS.PER_ZA_ASSESSMENTS_V is referenced by following:

PUBLIC: PER_ZA_ASSESSMENTS_V