VIEW: HR.PER_ZA_ASSESSMENTS#

Source

View Text - Preformatted

select ASSESSMENT_ID ASSESSMENT_ID, PERSON_ID PERSON_ID, LEVEL_ID LEVEL_ID, NAME_OF_ASSESSOR NAME_OF_ASSESSOR, INSTITUTION INSTITUTION, CREDIT CREDIT, DATE_OF_ASSESSMENT DATE_OF_ASSESSMENT, FINAL_RESULT FINAL_RESULT, ASSESSMENT_NUMBER ASSESSMENT_NUMBER, LOCATION_WHERE_ASSESSED LOCATION_WHERE_ASSESSED, FIELD_OF_LEARNING FIELD_OF_LEARNING, SUB_FIELD SUB_FIELD, ASSESSMENT_START_DATE ASSESSMENT_START_DATE, ASSESSMENT_END_DATE ASSESSMENT_END_DATE, COMPETENCE_ACQUIRED COMPETENCE_ACQUIRED, ETQA_NAME ETQA_NAME, CERTIFICATION_DATE CERTIFICATION_DATE, CERTIFICATE_NUMBER CERTIFICATE_NUMBER, ACCREDITED_BY ACCREDITED_BY, DATE_OF_ACCREDITATION DATE_OF_ACCREDITATION, CERTIFICATION_EXPIRY_DATE CERTIFICATION_EXPIRY_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE from "HR"."PER_ZA_ASSESSMENTS"

View Text - HTML Formatted

SELECT ASSESSMENT_ID ASSESSMENT_ID
, PERSON_ID PERSON_ID
, LEVEL_ID LEVEL_ID
, NAME_OF_ASSESSOR NAME_OF_ASSESSOR
, INSTITUTION INSTITUTION
, CREDIT CREDIT
, DATE_OF_ASSESSMENT DATE_OF_ASSESSMENT
, FINAL_RESULT FINAL_RESULT
, ASSESSMENT_NUMBER ASSESSMENT_NUMBER
, LOCATION_WHERE_ASSESSED LOCATION_WHERE_ASSESSED
, FIELD_OF_LEARNING FIELD_OF_LEARNING
, SUB_FIELD SUB_FIELD
, ASSESSMENT_START_DATE ASSESSMENT_START_DATE
, ASSESSMENT_END_DATE ASSESSMENT_END_DATE
, COMPETENCE_ACQUIRED COMPETENCE_ACQUIRED
, ETQA_NAME ETQA_NAME
, CERTIFICATION_DATE CERTIFICATION_DATE
, CERTIFICATE_NUMBER CERTIFICATE_NUMBER
, ACCREDITED_BY ACCREDITED_BY
, DATE_OF_ACCREDITATION DATE_OF_ACCREDITATION
, CERTIFICATION_EXPIRY_DATE CERTIFICATION_EXPIRY_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
FROM "HR"."PER_ZA_ASSESSMENTS"