DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.PER_ZA_ASSESSMENTS#

Object Details
Object Name: PER_ZA_ASSESSMENTS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ASSESSMENT_ID NUMBER (9) Yes
PERSON_ID NUMBER (9) Yes
LEVEL_ID NUMBER (9)
NAME_OF_ASSESSOR VARCHAR2 (120)
INSTITUTION VARCHAR2 (120)
CREDIT NUMBER (10)
DATE_OF_ASSESSMENT DATE

FINAL_RESULT VARCHAR2 (120)
ASSESSMENT_NUMBER VARCHAR2 (10)
LOCATION_WHERE_ASSESSED VARCHAR2 (200)
FIELD_OF_LEARNING VARCHAR2 (30)
SUB_FIELD VARCHAR2 (120)
ASSESSMENT_START_DATE DATE

ASSESSMENT_END_DATE DATE

COMPETENCE_ACQUIRED VARCHAR2 (30)
ETQA_NAME VARCHAR2 (30)
CERTIFICATION_DATE DATE

CERTIFICATE_NUMBER VARCHAR2 (30)
ACCREDITED_BY VARCHAR2 (80)
DATE_OF_ACCREDITATION DATE

CERTIFICATION_EXPIRY_DATE DATE

LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE 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
,      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# references the following:

SchemaHR
TablePER_ZA_ASSESSMENTS
HR.PER_ZA_ASSESSMENTS# is referenced by following:

SchemaAPPS
SynonymPER_ZA_ASSESSMENTS
TriggerPER_ZA_ASSESSMENTS_WHO