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]

Table: IGS_EN_STDNT_PS_ATT_ALL

Product:	IGS - Student System
Description:	This entity describes a student's attempt at studying a particular course offered by the university.
Implementation/DBA Data:	IGS.IGS_EN_STDNT_PS_ATT_ALL

Primary Key: IGS_EN_STDNT_PS_ATT_ALL_PK

PERSON_ID
COURSE_CD

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_EN_STDNT_PS_ATT_ALL	IGS_AD_PS_APPL_INST_ALL	IGS_EN_STDNT_PS_ATT_ALL.PERSON_ID IGS_EN_STDNT_PS_ATT_ALL.ADM_ADMISSION_APPL_NUMBER IGS_EN_STDNT_PS_ATT_ALL.ADM_NOMINATED_COURSE_CD IGS_EN_STDNT_PS_ATT_ALL.ADM_SEQUENCE_NUMBER
IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_ATD_MODE_ALL	IGS_EN_STDNT_PS_ATT_ALL.DERIVED_ATT_MODE
IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_ATD_TYPE_ALL	IGS_EN_STDNT_PS_ATT_ALL.DERIVED_ATT_TYPE
IGS_EN_STDNT_PS_ATT_ALL	IGS_CA_INST_ALL	IGS_EN_STDNT_PS_ATT_ALL.CATALOG_CAL_TYPE IGS_EN_STDNT_PS_ATT_ALL.CATALOG_SEQ_NUM
IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_OFR_OPT_ALL	IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD IGS_EN_STDNT_PS_ATT_ALL.VERSION_NUMBER IGS_EN_STDNT_PS_ATT_ALL.CAL_TYPE IGS_EN_STDNT_PS_ATT_ALL.LOCATION_CD IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_MODE IGS_EN_STDNT_PS_ATT_ALL.ATTENDANCE_TYPE
IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_OFR_OPT_ALL	IGS_EN_STDNT_PS_ATT_ALL.COO_ID
IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_VER_ALL	IGS_EN_STDNT_PS_ATT_ALL.COURSE_CD IGS_EN_STDNT_PS_ATT_ALL.VERSION_NUMBER
IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_DCNT_REASONCD_ALL	IGS_EN_STDNT_PS_ATT_ALL.DISCONTINUATION_REASON_CD
IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_FEE_CAT_ALL	IGS_EN_STDNT_PS_ATT_ALL.FEE_CAT
IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_FUND_SRC_ALL	IGS_EN_STDNT_PS_ATT_ALL.FUNDING_SOURCE
IGS_EN_STDNT_PS_ATT_ALL	IGS_AD_LOCATION_ALL	IGS_EN_STDNT_PS_ATT_ALL.EXAM_LOCATION_CD
IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_CLASS_STD	IGS_EN_STDNT_PS_ATT_ALL.IGS_PR_CLASS_STD_ID
IGS_AD_PS_APPL_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_AD_PS_APPL_ALL.PERSON_ID IGS_AD_PS_APPL_ALL.TRANSFER_COURSE_CD
IGS_AS_ANON_ID_PS	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_ANON_ID_PS.PERSON_ID IGS_AS_ANON_ID_PS.COURSE_CD
IGS_AS_ANON_ID_US	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_ANON_ID_US.PERSON_ID IGS_AS_ANON_ID_US.COURSE_CD
IGS_AV_UNT_REF_CDS	IGS_EN_STDNT_PS_ATT_ALL	IGS_AV_UNT_REF_CDS.PERSON_ID IGS_AV_UNT_REF_CDS.APPLIED_COURSE_CD
IGS_AS_STU_TRN_CMTS	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_STU_TRN_CMTS.PERSON_ID IGS_AS_STU_TRN_CMTS.COURSE_CD
IGS_RE_CANDIDATURE_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_RE_CANDIDATURE_ALL.PERSON_ID IGS_RE_CANDIDATURE_ALL.SCA_COURSE_CD
IGS_FI_FEE_AS_RT	IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_FEE_AS_RT.PERSON_ID IGS_FI_FEE_AS_RT.COURSE_CD
IGS_FI_DSB_DTL_ALC	IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_DSB_DTL_ALC.PERSON_ID IGS_FI_DSB_DTL_ALC.COURSE_CD
IGS_EN_SPA_AWD_AIM	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_SPA_AWD_AIM.PERSON_ID IGS_EN_SPA_AWD_AIM.COURSE_CD
IGS_GR_GRADUAND_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_GR_GRADUAND_ALL.PERSON_ID IGS_GR_GRADUAND_ALL.COURSE_CD
IGS_HE_ST_SPA_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_HE_ST_SPA_ALL.PERSON_ID IGS_HE_ST_SPA_ALL.COURSE_CD
IGS_EN_PLAN_UNITS	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_PLAN_UNITS.PERSON_ID IGS_EN_PLAN_UNITS.COURSE_CD
IGS_EN_SPA_TERMS	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_SPA_TERMS.PERSON_ID IGS_EN_SPA_TERMS.PROGRAM_CD
IGS_FI_SPA_FEE_PRDS	IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_SPA_FEE_PRDS.PERSON_ID IGS_FI_SPA_FEE_PRDS.COURSE_CD
IGS_FI_SPECIAL_FEES	IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_SPECIAL_FEES.PERSON_ID IGS_FI_SPECIAL_FEES.COURSE_CD
IGS_HE_ST_SPA_CC	IGS_EN_STDNT_PS_ATT_ALL	IGS_HE_ST_SPA_CC.PERSON_ID IGS_HE_ST_SPA_CC.COURSE_CD
IGS_PR_COHINST_RANK	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_COHINST_RANK.PERSON_ID IGS_PR_COHINST_RANK.COURSE_CD
IGS_PR_RU_APPL_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_RU_APPL_ALL.SCA_PERSON_ID IGS_PR_RU_APPL_ALL.SCA_COURSE_CD
IGS_PS_STDNT_APV_ALT	IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_STDNT_APV_ALT.PERSON_ID IGS_PS_STDNT_APV_ALT.COURSE_CD
IGS_AS_SC_ATMPT_ENR	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_SC_ATMPT_ENR.PERSON_ID IGS_AS_SC_ATMPT_ENR.COURSE_CD
IGS_FI_CRS_AT_F_SPN	IGS_EN_STDNT_PS_ATT_ALL	IGS_FI_CRS_AT_F_SPN.PERSON_ID IGS_FI_CRS_AT_F_SPN.COURSE_CD
IGS_AS_SC_ATMPT_NOTE	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_SC_ATMPT_NOTE.PERSON_ID IGS_AS_SC_ATMPT_NOTE.COURSE_CD
IGS_EN_STDNTPSHECSOP	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_STDNTPSHECSOP.PERSON_ID IGS_EN_STDNTPSHECSOP.COURSE_CD
IGS_PR_SDT_PS_PR_MSR	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_SDT_PS_PR_MSR.PERSON_ID IGS_PR_SDT_PS_PR_MSR.COURSE_CD
IGS_PS_STDNT_SPL_REQ	IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_STDNT_SPL_REQ.PERSON_ID IGS_PS_STDNT_SPL_REQ.COURSE_CD
IGS_PS_STDNT_TRN	IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_STDNT_TRN.PERSON_ID IGS_PS_STDNT_TRN.COURSE_CD
IGS_PS_STDNT_TRN	IGS_EN_STDNT_PS_ATT_ALL	IGS_PS_STDNT_TRN.PERSON_ID IGS_PS_STDNT_TRN.TRANSFER_COURSE_CD
IGS_EN_STDNT_PS_INTM	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_STDNT_PS_INTM.PERSON_ID IGS_EN_STDNT_PS_INTM.COURSE_CD
IGS_GR_SPECIAL_AWARD_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_GR_SPECIAL_AWARD_ALL.PERSON_ID IGS_GR_SPECIAL_AWARD_ALL.COURSE_CD
IGS_PR_STDNT_PR_CK	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_STDNT_PR_CK.PERSON_ID IGS_PR_STDNT_PR_CK.COURSE_CD
IGS_PR_STDNT_PR_OU_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_STDNT_PR_OU_ALL.PERSON_ID IGS_PR_STDNT_PR_OU_ALL.COURSE_CD
IGS_PR_STU_ACAD_STAT	IGS_EN_STDNT_PS_ATT_ALL	IGS_PR_STU_ACAD_STAT.PERSON_ID IGS_PR_STU_ACAD_STAT.COURSE_CD
IGS_EN_SU_ATTEMPT_H_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_SU_ATTEMPT_H_ALL.PERSON_ID IGS_EN_SU_ATTEMPT_H_ALL.COURSE_CD
IGS_EN_SU_ATTEMPT_ALL	IGS_EN_STDNT_PS_ATT_ALL	IGS_EN_SU_ATTEMPT_ALL.PERSON_ID IGS_EN_SU_ATTEMPT_ALL.COURSE_CD
IGS_AS_SU_SETATMPT	IGS_EN_STDNT_PS_ATT_ALL	IGS_AS_SU_SETATMPT.PERSON_ID IGS_AS_SU_SETATMPT.COURSE_CD