View: PER_ZA_FORMAL_QUALIFICATIONS_V

Product:	PER - Human Resources
Description:	PER_ZA_FORMAL_QUALIFICATIONS_V is used to maintain table PER_ZA_FORMAL_QUALIFICATIONS via NQF forms.
Implementation/DBA Data:	APPS.PER_ZA_FORMAL_QUALIFICATIONS_V

View Text

SELECT QUA.ROWID ROW_ID
, QUA.QUALIFICATION_ID
, QUA.BUSINESS_GROUP_ID
, QUA.OBJECT_VERSION_NUMBER
, DECODE(QUA.PERSON_ID
, NULL
, ESA.PERSON_ID
, QUA.PERSON_ID) PERSON_ID
, QUA.TITLE
, QUA.GRADE_ATTAINED
, QUA.STATUS
, HR_GENERAL.DECODE_LOOKUP('PER_SUBJECT_STATUSES'
, QUA.STATUS) STATUS_MEANING
, QUA.AWARDED_DATE
, QUA.FEE
, QUA.FEE_CURRENCY
, QUA.TRAINING_COMPLETED_AMOUNT
, QUA.REIMBURSEMENT_ARRANGEMENTS
, QUA.TRAINING_COMPLETED_UNITS
, QUA.TOTAL_TRAINING_AMOUNT
, QUA.START_DATE
, QUA.END_DATE
, QUA.LICENSE_NUMBER
, QUA.EXPIRY_DATE
, QUA.LICENSE_RESTRICTIONS
, QUA.PROJECTED_COMPLETION_DATE
, QUA.AWARDING_BODY
, QUA.TUITION_METHOD
, HR_GENERAL.DECODE_LOOKUP('PER_TUITION_METHODS'
, QUA.TUITION_METHOD) TUITION_METHOD_MEANING
, QUA.GROUP_RANKING
, QUA.COMMENTS
, QUA.QUALIFICATION_TYPE_ID
, PQT.NAME
, QUA.ATTENDANCE_ID
, NVL(ESA.ESTABLISHMENT
, EST.NAME) ESTABLISHMENT
, EST.LOCATION
, QUA.ATTRIBUTE_CATEGORY
, QUA.ATTRIBUTE1
, QUA.ATTRIBUTE2
, QUA.ATTRIBUTE3
, QUA.ATTRIBUTE4
, QUA.ATTRIBUTE5
, QUA.ATTRIBUTE6
, QUA.ATTRIBUTE7
, QUA.ATTRIBUTE8
, QUA.ATTRIBUTE9
, QUA.ATTRIBUTE10
, QUA.ATTRIBUTE11
, QUA.ATTRIBUTE12
, QUA.ATTRIBUTE13
, QUA.ATTRIBUTE14
, QUA.ATTRIBUTE15
, QUA.ATTRIBUTE16
, QUA.ATTRIBUTE17
, QUA.ATTRIBUTE18
, QUA.ATTRIBUTE19
, QUA.ATTRIBUTE20
, QUA.LAST_UPDATE_DATE
, QUA.LAST_UPDATED_BY
, QUA.LAST_UPDATE_LOGIN
, QUA.CREATED_BY
, QUA.CREATION_DATE
, PRQ.LEVEL_ID
, PRQ.FIELD_OF_LEARNING
, HR_GENERAL.DECODE_LOOKUP('ZA_NQF_FIELDS_OF_LEARNING'
, PRQ.FIELD_OF_LEARNING) FIELD_OF_LEARNING_MEANING
, PRQ.SUB_FIELD
, PRQ.REGISTRATION_DATE
, PRQ.REGISTRATION_NUMBER
FROM PER_QUALIFICATIONS QUA
, PER_QUALIFICATION_TYPES PQT
, PER_ESTABLISHMENT_ATTENDANCES ESA
, PER_ESTABLISHMENTS EST
, PER_ZA_FORMAL_QUALIFICATIONS PRQ
WHERE QUA.QUALIFICATION_TYPE_ID = PQT.QUALIFICATION_TYPE_ID
AND QUA.ATTENDANCE_ID = ESA.ATTENDANCE_ID (+)
AND ESA.ESTABLISHMENT_ID = EST.ESTABLISHMENT_ID (+)
AND PRQ.QUALIFICATION_ID(+) = QUA.QUALIFICATION_ID

Columns