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_ZA_ASSESSMENTS

Object Details

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

Table to store the NQF Assessment info for a person

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: PER_ZA_ASSESSMENTS_PK

ASSESSMENT_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PER_ZA_ASSESSMENTS_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ASSESSMENT_ID

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 Result obtained by person after assessment - free text
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
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
ETQA_NAME	VARCHAR2	(30)		ETQA (Government related) name
CERTIFICATION_DATE	DATE			Date of certification
CERTIFICATE_NUMBER	VARCHAR2	(30)		Certificate Number
ACCREDITED_BY	VARCHAR2	(80)		Institution (s) accredited by
DATE_OF_ACCREDITATION	DATE			Date of accreditation
CERTIFICATION_EXPIRY_DATE	DATE			Certification expiry date
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

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
,      ASSESSMENT_NUMBER
,      LOCATION_WHERE_ASSESSED
,      FIELD_OF_LEARNING
,      SUB_FIELD
,      ASSESSMENT_START_DATE
,      ASSESSMENT_END_DATE
,      COMPETENCE_ACQUIRED
,      ETQA_NAME
,      CERTIFICATION_DATE
,      CERTIFICATE_NUMBER
,      ACCREDITED_BY
,      DATE_OF_ACCREDITATION
,      CERTIFICATION_EXPIRY_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_ZA_ASSESSMENTS;

Dependencies

[top of page]

HR.PER_ZA_ASSESSMENTS does not reference any database object

HR.PER_ZA_ASSESSMENTS is referenced by following:

APPS: PER_ZA_ASSESSMENTS; PER_ZA_ASSESSMENTS_WHO
PUBLIC: PER_ZA_ASSESSMENTS