Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Holds details of a person's additional athletic information |
Implementation/DBA Data: | Not implemented in this database |
SELECT AD.ROWID ROW_ID
, AD.ATHLETIC_DETAILS_ID
, AD.PERSON_ID
, AD.ATHLETIC_GPA
, L1.MEANING ELIGIBILITY_STATUS
, AD.ELIGIBILITY_STATUS_CD
, L2.MEANING PREDICT_ELIG_M
, AD.PREDICT_ELIG_CODE
, L3.MEANING TENTATIVE_ADM_M
, AD.TENTATIVE_ADM_CODE
, AD.REVIEW_DATE
, AD.COMMENTS
, AD.CREATED_BY
, AD.CREATION_DATE
, AD.LAST_UPDATED_BY
, AD.LAST_UPDATE_DATE
, AD.LAST_UPDATE_LOGIN
FROM IGS_PE_ATHLETIC_DTL AD
, IGS_LOOKUP_VALUES L1
, IGS_LOOKUP_VALUES L2
, IGS_LOOKUP_VALUES L3
WHERE AD.ELIGIBILITY_STATUS_CD = L1.LOOKUP_CODE(+)
AND L1.LOOKUP_TYPE(+) = 'PE_ATH_ELG_STATUS'
AND AD.PREDICT_ELIG_CODE = L2. LOOKUP_CODE(+)
AND L2. LOOKUP_TYPE(+) = 'PE_PRE_ELIG_TYPE'
AND AD.TENTATIVE_ADM_CODE = L3. LOOKUP_CODE(+)
AND L3.LOOKUP_TYPE(+) = 'PE_TENTATIVE_ADM_TYPE'