Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Holds Information about Admission Application Program Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT APD.PERSON_ID
, P.PARTY_NUMBER
, PP.PERSON_NAME
, APD.ADMISSION_APPL_NUMBER
, APD.NOMINATED_COURSE_CD
, PSV.TITLE
, APD.SEQUENCE_NUMBER
, APD.PREDICTED_GPA
, APD.ACADEMIC_INDEX
, APD.ADM_CAL_TYPE
, APD.ADM_CI_SEQUENCE_NUMBER
, APD.APP_FILE_LOCATION
, APD.APP_SOURCE_ID
, APD.COURSE_CD
, APD.CRV_VERSION_NUMBER
, APD.WAITLIST_RANK
, APD.LOCATION_CD
, APD.ATTENT_OTHER_INST_CD
, APD.ATTENDANCE_MODE
, APD.EDU_GOAL_PRIOR_ENROLL_ID
, APD.ATTENDANCE_TYPE
, APD.DECISION_MAKE_ID
, APD.UNIT_SET_CD
, APD.DECISION_DATE
, '_DF:IGS:IGS_AD_APPL_INST_FLEX:APD'
, APD.DECISION_REASON_ID
, APD.US_VERSION_NUMBER
, APD.DECISION_NOTES
, APD.PENDING_REASON_ID
, APD.PREFERENCE_NUMBER
, APD.ADM_DOC_STATUS
, APD.ADM_ENTRY_QUAL_STATUS
, APD.DEFICIENCY_IN_PREP
, APD.LATE_ADM_FEE_STATUS
, APD.SPL_CONSIDER_COMMENTS
, '_LA:APD.APPLY_FOR_FINAID:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APD.FINAID_APPLY_DATE
, APD.ADM_OUTCOME_STATUS
, APD.ADM_OTCM_STATUS_AUTH_PERSON_ID
, APD.ADM_OUTCOME_STATUS_AUTH_DT
, APD.ADM_OUTCOME_STATUS_REASON
, APD.OFFER_DT
, APD.OFFER_RESPONSE_DT
, APD.PRPSD_COMMENCEMENT_DT
, APD.ADM_CNDTNL_OFFER_STATUS
, APD.CNDTNL_OFFER_CNDTN
, APD.CNDTNL_OFFER_SATISFIED_DT
, '_LA:APD.CNDTNL_OFFER_MUST_BE_STSFD_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APD.ADM_OFFER_RESP_STATUS
, APD.ACTUAL_RESPONSE_DT
, APD.ADM_OFFER_DFRMNT_STATUS
, APD.DEFERRED_ADM_CAL_TYPE
, APD.DEFERRED_ADM_CI_SEQUENCE_NUM
, APD.DEFERRED_TRACKING_ID
, APD.ASS_RANK
, APD.SECONDARY_ASS_RANK
, APD.INTRNTNL_ACCEPTANCE_ADVICE_NUM
, APD.ASS_TRACKING_ID
, APD.FEE_CAT
, APD.HECS_PAYMENT_OPTION
, APD.EXPECTED_COMPLETION_YR
, APD.EXPECTED_COMPLETION_PERD
, APD.CORRESPONDENCE_CAT
, APD.ENROLMENT_CAT
, APD.FUNDING_SOURCE
, APD.APPLICANT_ACPTNCE_CNDTN
, APD.SS_APPLICATION_ID
, APD.SS_PWD
, APD.ENTRY_STATUS
, APD.ENTRY_LEVEL
, APD.SCH_APL_TO_ID
, APD.AUTHORIZED_DT
, APD.AUTHORIZING_PERS_ID
, APD.IDX_CALC_DATE
, '_LA:APD.WAITLIST_STATUS:IGS_LOOKUP_VALUES:ADM_WAITLIST_STATUS:MEANING'
, APD.FUTURE_ACAD_CAL_TYPE
, APD.FUTURE_ACAD_CI_SEQUENCE_NUMBER
, APD.FUTURE_ADM_CAL_TYPE
, APD.FUTURE_ADM_CI_SEQUENCE_NUMBER
, APD.PREVIOUS_TERM_ADM_APPL_NUMBER
, APD.PREVIOUS_TERM_SEQUENCE_NUMBER
, APD.FUTURE_TERM_ADM_APPL_NUMBER
, APD.FUTURE_TERM_SEQUENCE_NUMBER
, APD.DEF_ACAD_CAL_TYPE
, APD.DEF_ACAD_CI_SEQUENCE_NUM
, APD.DEF_PREV_TERM_ADM_APPL_NUM
, APD.DEF_PREV_APPL_SEQUENCE_NUM
, APD.DEF_TERM_ADM_APPL_NUM
, APD.DEF_APPL_SEQUENCE_NUM
, APD.CREATED_BY
, APD.CREATION_DATE
, APD.LAST_UPDATED_BY
, APD.LAST_UPDATE_DATE
, APD.APPL_INST_STATUS
, APD.AIS_REASON AIS_REASON_CODE
, '_LA:APD.AIS_REASON:IGS_LOOKUP_VALUES:IGS_AD_WITHDRAW_RSN:MEANING' "_LA:AIS_REASON"
, APD.DECLINE_OFR_REASON DECLINE_OFR_REASON_CODE
, '_LA:APD.DECLINE_OFR_REASON:IGS_LOOKUP_VALUES:IGS_AD_DECL_OFR_REAS:MEANING' "_LA:DECLINE_OFR_REASON"
FROM IGS_AD_PS_APPL_INST_ALL APD
, HZ_PARTIES P
, HZ_PERSON_PROFILES PP
, IGS_PS_VER_ALL PSV
WHERE APD.NOMINATED_COURSE_CD = PSV.COURSE_CD
AND APD.CRV_VERSION_NUMBER = PSV.VERSION_NUMBER
AND APD.PERSON_ID = P.PARTY_ID
AND P.PARTY_ID = PP.PARTY_ID
AND PP.CONTENT_SOURCE_TYPE (+) = 'USER_ENTERED'
AND SYSDATE BETWEEN PP.EFFECTIVE_START_DATE
AND NVL(PP.EFFECTIVE_END_DATE
, SYSDATE) WITH READ ONLY