eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGS_AD_PS_APLINSTHST_APLHIST_V

Product:	IGS - Student System (Obsolete)
Description:	Request for program entry for an admission period
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT ACAIH.PERSON_ID
, ACAIH.ADMISSION_APPL_NUMBER
, ACAIH.NOMINATED_COURSE_CD
, ACAIH.SEQUENCE_NUMBER
, ACAIH.HIST_START_DT
, ACAIH.HIST_END_DT
, ACAIH.HIST_WHO
, ACAIH.HIST_OFFER_ROUND_NUMBER
, ACAIH.ADM_CAL_TYPE
, ACAIH.ADM_CI_SEQUENCE_NUMBER
, ACAIH.COURSE_CD
, ACAIH.CRV_VERSION_NUMBER
, ACAIH.LOCATION_CD
, ACAIH.ATTENDANCE_MODE
, ACAIH.ATTENDANCE_TYPE
, ACAIH.UNIT_SET_CD
, ACAIH.US_VERSION_NUMBER
, ACAIH.PREFERENCE_NUMBER
, ACAIH.ADM_DOC_STATUS
, ACAIH.ADM_ENTRY_QUAL_STATUS
, ACAIH.LATE_ADM_FEE_STATUS
, ACAIH.ADM_OUTCOME_STATUS
, ACAIH.ADM_OTCM_STATUS_AUTH_PERSON_ID
, ACAIH.ADM_OUTCOME_STATUS_AUTH_DT
, ACAIH.ADM_OUTCOME_STATUS_REASON
, ACAIH.OFFER_DT
, ACAIH.OFFER_RESPONSE_DT
, ACAIH.PRPSD_COMMENCEMENT_DT
, ACAIH.ADM_CNDTNL_OFFER_STATUS
, ACAIH.CNDTNL_OFFER_SATISFIED_DT
, ACAIH.CNDTNL_OFFER_MUST_BE_STSFD_IND
, ACAIH.ADM_OFFER_RESP_STATUS
, ACAIH.ACTUAL_RESPONSE_DT
, ACAIH.ADM_OFFER_DFRMNT_STATUS
, ACAIH.DEFERRED_ADM_CAL_TYPE
, ACAIH.DEFERRED_ADM_CI_SEQUENCE_NUM
, ACAIH.DEFERRED_TRACKING_ID
, ACAIH.ASS_RANK
, ACAIH.SECONDARY_ASS_RANK
, ACAIH.INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ACAIH.ASS_TRACKING_ID
, ACAIH.FEE_CAT
, ACAIH.HECS_PAYMENT_OPTION
, ACAIH.EXPECTED_COMPLETION_YR
, ACAIH.EXPECTED_COMPLETION_PERD
, ACAIH.CORRESPONDENCE_CAT
, ACAIH.ENROLMENT_CAT
, ACAIH.FUNDING_SOURCE
, ACAIH.APPLICANT_ACPTNCE_CNDTN
, ACAIH.CNDTNL_OFFER_CNDTN
, ACAH.TRANSFER_COURSE_CD
, ACAH.BASIS_FOR_ADMISSION_TYPE
, ACAH.ADMISSION_CD
, ACAH.COURSE_RANK_SET
, ACAH.COURSE_RANK_SCHEDULE
, ACAH.REQ_FOR_RECONSIDERATION_IND
, ACAH.REQ_FOR_ADV_STANDING_IND
, ACAIH.CREATED_BY
, ACAIH.CREATION_DATE
, ACAIH.LAST_UPDATED_BY
, ACAIH.LAST_UPDATE_DATE
, ACAIH.LAST_UPDATE_LOGIN
, ACAIH.APPL_INST_STATUS FROM IGS_AD_PS_APLINSTHST ACAIH
, IGS_AD_PS_APPL_HIST ACAH
WHERE ACAH.PERSON_ID = ACAIH.PERSON_ID
AND ACAH.ADMISSION_APPL_NUMBER = ACAIH.ADMISSION_APPL_NUMBER
AND ACAH.NOMINATED_COURSE_CD = ACAIH.NOMINATED_COURSE_CD
AND ACAH.HIST_START_DT = ACAIH.HIST_START_DT UNION SELECT ACAIH.PERSON_ID
, ACAIH.ADMISSION_APPL_NUMBER
, ACAIH.NOMINATED_COURSE_CD
, ACAIH.SEQUENCE_NUMBER
, ACAIH.HIST_START_DT
, ACAIH.HIST_END_DT
, ACAIH.HIST_WHO
, ACAIH.HIST_OFFER_ROUND_NUMBER
, ACAIH.ADM_CAL_TYPE
, ACAIH.ADM_CI_SEQUENCE_NUMBER
, ACAIH.COURSE_CD
, ACAIH.CRV_VERSION_NUMBER
, ACAIH.LOCATION_CD
, ACAIH.ATTENDANCE_MODE
, ACAIH.ATTENDANCE_TYPE
, ACAIH.UNIT_SET_CD
, ACAIH.US_VERSION_NUMBER
, ACAIH.PREFERENCE_NUMBER
, ACAIH.ADM_DOC_STATUS
, ACAIH.ADM_ENTRY_QUAL_STATUS
, ACAIH.LATE_ADM_FEE_STATUS
, ACAIH.ADM_OUTCOME_STATUS
, ACAIH.ADM_OTCM_STATUS_AUTH_PERSON_ID
, ACAIH.ADM_OUTCOME_STATUS_AUTH_DT
, ACAIH.ADM_OUTCOME_STATUS_REASON
, ACAIH.OFFER_DT
, ACAIH.OFFER_RESPONSE_DT
, ACAIH.PRPSD_COMMENCEMENT_DT
, ACAIH.ADM_CNDTNL_OFFER_STATUS
, ACAIH.CNDTNL_OFFER_SATISFIED_DT
, ACAIH.CNDTNL_OFFER_MUST_BE_STSFD_IND
, ACAIH.ADM_OFFER_RESP_STATUS
, ACAIH.ACTUAL_RESPONSE_DT
, ACAIH.ADM_OFFER_DFRMNT_STATUS
, ACAIH.DEFERRED_ADM_CAL_TYPE
, ACAIH.DEFERRED_ADM_CI_SEQUENCE_NUM
, ACAIH.DEFERRED_TRACKING_ID
, ACAIH.ASS_RANK
, ACAIH.SECONDARY_ASS_RANK
, ACAIH.INTRNTNL_ACCEPTANCE_ADVICE_NUM
, ACAIH.ASS_TRACKING_ID
, ACAIH.FEE_CAT
, ACAIH.HECS_PAYMENT_OPTION
, ACAIH.EXPECTED_COMPLETION_YR
, ACAIH.EXPECTED_COMPLETION_PERD
, ACAIH.CORRESPONDENCE_CAT
, ACAIH.ENROLMENT_CAT
, ACAIH.FUNDING_SOURCE
, ACAIH.APPLICANT_ACPTNCE_CNDTN
, ACAIH.CNDTNL_OFFER_CNDTN
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ACAIH.CREATED_BY
, ACAIH.CREATION_DATE
, ACAIH.LAST_UPDATED_BY
, ACAIH.LAST_UPDATE_DATE
, ACAIH.LAST_UPDATE_LOGIN
, ACAIH.APPL_INST_STATUS FROM IGS_AD_PS_APLINSTHST ACAIH
WHERE NOT EXISTS ( SELECT 'X' FROM IGS_AD_PS_APPL_HIST ACAH WHERE ACAH.PERSON_ID = ACAIH.PERSON_ID
AND ACAH.ADMISSION_APPL_NUMBER = ACAIH.ADMISSION_APPL_NUMBER
AND ACAH.NOMINATED_COURSE_CD = ACAIH.NOMINATED_COURSE_CD
AND ACAH.HIST_START_DT = ACAIH.HIST_START_DT) UNION SELECT ACAH.PERSON_ID
, ACAH.ADMISSION_APPL_NUMBER
, ACAH.NOMINATED_COURSE_CD
, TO_NUMBER(NULL)
, ACAH.HIST_START_DT
, ACAH.HIST_END_DT
, ACAH.HIST_WHO
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, TO_NUMBER(NULL)
, IGS_GE_DATE.IGSDATE(NULL)
, NULL
, IGS_GE_DATE.IGSDATE(NULL)
, IGS_GE_DATE.IGSDATE(NULL)
, IGS_GE_DATE.IGSDATE(NULL)
, NULL
, IGS_GE_DATE.IGSDATE(NULL)
, NULL
, NULL
, IGS_GE_DATE.IGSDATE(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
, NULL
, NULL
, TO_NUMBER(NULL)
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, ACAH.TRANSFER_COURSE_CD
, ACAH.BASIS_FOR_ADMISSION_TYPE
, ACAH.ADMISSION_CD
, ACAH.COURSE_RANK_SET
, ACAH.COURSE_RANK_SCHEDULE
, ACAH.REQ_FOR_RECONSIDERATION_IND
, ACAH.REQ_FOR_ADV_STANDING_IND
, ACAH.CREATED_BY
, ACAH.CREATION_DATE
, ACAH.LAST_UPDATED_BY
, ACAH.LAST_UPDATE_DATE
, ACAH.LAST_UPDATE_LOGIN
, NULL FROM IGS_AD_PS_APPL_HIST ACAH WHERE NOT EXISTS ( SELECT 'X' FROM IGS_AD_PS_APLINSTHST ACAIH WHERE ACAIH.PERSON_ID = ACAH.PERSON_ID
AND ACAIH.ADMISSION_APPL_NUMBER = ACAH.ADMISSION_APPL_NUMBER
AND ACAIH.NOMINATED_COURSE_CD = ACAH.NOMINATED_COURSE_CD
AND ACAIH.HIST_START_DT = ACAH.HIST_START_DT)

Columns

Name
PERSON_ID
ADMISSION_APPL_NUMBER
NOMINATED_COURSE_CD
SEQUENCE_NUMBER
HIST_START_DT
HIST_END_DT
HIST_WHO
HIST_OFFER_ROUND_NUMBER
ADM_CAL_TYPE
ADM_CI_SEQUENCE_NUMBER
COURSE_CD
CRV_VERSION_NUMBER
LOCATION_CD
ATTENDANCE_MODE
ATTENDANCE_TYPE
UNIT_SET_CD
US_VERSION_NUMBER
PREFERENCE_NUMBER
ADM_DOC_STATUS
ADM_ENTRY_QUAL_STATUS
LATE_ADM_FEE_STATUS
ADM_OUTCOME_STATUS
ADM_OTCM_STATUS_AUTH_PERSON_ID
ADM_OUTCOME_STATUS_AUTH_DT
ADM_OUTCOME_STATUS_REASON
OFFER_DT
OFFER_RESPONSE_DT
PRPSD_COMMENCEMENT_DT
ADM_CNDTNL_OFFER_STATUS
CNDTNL_OFFER_SATISFIED_DT
CNDTNL_OFFER_MUST_BE_STSFD_IND
ADM_OFFER_RESP_STATUS
ACTUAL_RESPONSE_DT
ADM_OFFER_DFRMNT_STATUS
DEFERRED_ADM_CAL_TYPE
DEFERRED_ADM_CI_SEQUENCE_NUM
DEFERRED_TRACKING_ID
ASS_RANK
SECONDARY_ASS_RANK
INTRNTNL_ACCEPTANCE_ADVICE_NUM
ASS_TRACKING_ID
FEE_CAT
HECS_PAYMENT_OPTION
EXPECTED_COMPLETION_YR
EXPECTED_COMPLETION_PERD
CORRESPONDENCE_CAT
ENROLMENT_CAT
FUNDING_SOURCE
APPLICANT_ACPTNCE_CNDTN
CNDTNL_OFFER_CNDTN
TRANSFER_COURSE_CD
BASIS_FOR_ADMISSION_TYPE
ADMISSION_CD
COURSE_RANK_SET
COURSE_RANK_SCHEDULE
REQ_FOR_RECONSIDERATION_IND
REQ_FOR_ADV_STANDING_IND
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
APPL_INST_STATUS