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_PS_VER_ALL

Product:	IGS - Student System (Obsolete)
Description:	This entity describes the versions of programs which are offered by the university, covering both award and non-award programs.
Implementation/DBA Data:	Not implemented in this database

Primary Key: IGS_PS_VER_PK

COURSE_CD
VERSION_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_PS_VER_ALL	IGS_FI_ACC_ALL	IGS_PS_VER_ALL.REV_ACCOUNT_CD
IGS_PS_VER_ALL	IGS_PS_STAT	IGS_PS_VER_ALL.COURSE_STATUS
IGS_PS_VER_ALL	IGS_PS_COURSE	IGS_PS_VER_ALL.COURSE_CD
IGS_PS_VER_ALL	IGS_PS_TYPE_ALL	IGS_PS_VER_ALL.COURSE_TYPE
IGS_PS_VER_ALL	IGS_PS_GOVT_SPL_TYPE	IGS_PS_VER_ALL.GOVT_SPECIAL_COURSE_TYPE
IGS_AD_PS_APPL_INST_ALL	IGS_PS_VER_ALL	IGS_AD_PS_APPL_INST_ALL.COURSE_CD IGS_AD_PS_APPL_INST_ALL.CRV_VERSION_NUMBER
IGS_PE_ALTERNATV_EXT	IGS_PS_VER_ALL	IGS_PE_ALTERNATV_EXT.COURSE_CD IGS_PE_ALTERNATV_EXT.VERSION_NUMBER
IGS_AV_ADV_STANDING_ALL	IGS_PS_VER_ALL	IGS_AV_ADV_STANDING_ALL.COURSE_CD IGS_AV_ADV_STANDING_ALL.VERSION_NUMBER
IGS_PS_ANL_LOAD	IGS_PS_VER_ALL	IGS_PS_ANL_LOAD.COURSE_CD IGS_PS_ANL_LOAD.VERSION_NUMBER
IGS_PS_AWARD	IGS_PS_VER_ALL	IGS_PS_AWARD.COURSE_CD IGS_PS_AWARD.VERSION_NUMBER
IGS_PS_IN_PKG_ITM	IGS_PS_VER_ALL	IGS_PS_IN_PKG_ITM.COURSE_CD IGS_PS_IN_PKG_ITM.VERSION_NUMBER
IGS_PS_FLD_STD_HIST_ALL	IGS_PS_VER_ALL	IGS_PS_FLD_STD_HIST_ALL.COURSE_CD IGS_PS_FLD_STD_HIST_ALL.VERSION_NUMBER
IGS_PS_FIELD_STUDY	IGS_PS_VER_ALL	IGS_PS_FIELD_STUDY.COURSE_CD IGS_PS_FIELD_STUDY.VERSION_NUMBER
IGS_PS_GRP_MBR	IGS_PS_VER_ALL	IGS_PS_GRP_MBR.COURSE_CD IGS_PS_GRP_MBR.VERSION_NUMBER
IGS_PS_OWN_HIST_ALL	IGS_PS_VER_ALL	IGS_PS_OWN_HIST_ALL.COURSE_CD IGS_PS_OWN_HIST_ALL.VERSION_NUMBER
IGS_CO_ITM_ALL	IGS_PS_VER_ALL	IGS_CO_ITM_ALL.COURSE_CD IGS_CO_ITM_ALL.CV_VERSION_NUMBER
IGS_PS_OWN	IGS_PS_VER_ALL	IGS_PS_OWN.COURSE_CD IGS_PS_OWN.VERSION_NUMBER
IGS_PS_OFR_ALL	IGS_PS_VER_ALL	IGS_PS_OFR_ALL.COURSE_CD IGS_PS_OFR_ALL.VERSION_NUMBER
IGS_PS_REF_CD_HIST_ALL	IGS_PS_VER_ALL	IGS_PS_REF_CD_HIST_ALL.COURSE_CD IGS_PS_REF_CD_HIST_ALL.VERSION_NUMBER
IGS_PS_CATEGORISE_ALL	IGS_PS_VER_ALL	IGS_PS_CATEGORISE_ALL.COURSE_CD IGS_PS_CATEGORISE_ALL.VERSION_NUMBER
IGS_PS_REF_CD	IGS_PS_VER_ALL	IGS_PS_REF_CD.COURSE_CD IGS_PS_REF_CD.VERSION_NUMBER
IGS_PS_STAGE	IGS_PS_VER_ALL	IGS_PS_STAGE.COURSE_CD IGS_PS_STAGE.VERSION_NUMBER
IGS_PS_UNIT_LVL_HIST_ALL	IGS_PS_VER_ALL	IGS_PS_UNIT_LVL_HIST_ALL.COURSE_CD IGS_PS_UNIT_LVL_HIST_ALL.COURSE_VERSION_NUMBER
IGS_PS_UNIT_LVL_ALL	IGS_PS_VER_ALL	IGS_PS_UNIT_LVL_ALL.COURSE_CD IGS_PS_UNIT_LVL_ALL.COURSE_VERSION_NUMBER
IGS_PS_VER_NOTE	IGS_PS_VER_ALL	IGS_PS_VER_NOTE.COURSE_CD IGS_PS_VER_NOTE.VERSION_NUMBER
IGS_PS_VER_RU	IGS_PS_VER_ALL	IGS_PS_VER_RU.COURSE_CD IGS_PS_VER_RU.VERSION_NUMBER
IGS_RE_DFLT_MS_SET_ALL	IGS_PS_VER_ALL	IGS_RE_DFLT_MS_SET_ALL.COURSE_CD IGS_RE_DFLT_MS_SET_ALL.VERSION_NUMBER
IGS_FI_FEE_AS_RATE	IGS_PS_VER_ALL	IGS_FI_FEE_AS_RATE.COURSE_CD IGS_FI_FEE_AS_RATE.VERSION_NUMBER
IGS_FI_FD_SRC_RSTN_H_ALL	IGS_PS_VER_ALL	IGS_FI_FD_SRC_RSTN_H_ALL.COURSE_CD IGS_FI_FD_SRC_RSTN_H_ALL.VERSION_NUMBER
IGS_FI_FND_SRC_RSTN	IGS_PS_VER_ALL	IGS_FI_FND_SRC_RSTN.COURSE_CD IGS_FI_FND_SRC_RSTN.VERSION_NUMBER
IGS_AS_GPC_PROGRAMS	IGS_PS_VER_ALL	IGS_AS_GPC_PROGRAMS.COURSE_CD IGS_AS_GPC_PROGRAMS.COURSE_VERSION_NUMBER
IGS_HE_ST_PROG_ALL	IGS_PS_VER_ALL	IGS_HE_ST_PROG_ALL.COURSE_CD IGS_HE_ST_PROG_ALL.VERSION_NUMBER
IGF_GR_PELL_SETUP_ALL	IGS_PS_VER_ALL	IGF_GR_PELL_SETUP_ALL.COURSE_CD IGF_GR_PELL_SETUP_ALL.VERSION_NUMBER
IGS_AD_DEPLVL_PRG	IGS_PS_VER_ALL	IGS_AD_DEPLVL_PRG.PROGRAM_CODE IGS_AD_DEPLVL_PRG.VERSION_NUMBER
IGS_EN_PSV_TERM_IT	IGS_PS_VER_ALL	IGS_EN_PSV_TERM_IT.COURSE_CD IGS_EN_PSV_TERM_IT.VERSION_NUMBER
IGS_FI_FTCI_ACCTS	IGS_PS_VER_ALL	IGS_FI_FTCI_ACCTS.COURSE_CD IGS_FI_FTCI_ACCTS.CRS_VERSION_NUMBER
IGS_HE_ST_PROG_CC	IGS_PS_VER_ALL	IGS_HE_ST_PROG_CC.COURSE_CD IGS_HE_ST_PROG_CC.VERSION_NUMBER
IGS_SS_APP_PGM_STG	IGS_PS_VER_ALL	IGS_SS_APP_PGM_STG.NOMINATED_COURSE_CD IGS_SS_APP_PGM_STG.CRV_VERSION_NUMBER
IGS_CO_OU_CO_REF_ALL	IGS_PS_VER_ALL	IGS_CO_OU_CO_REF_ALL.COURSE_CD IGS_CO_OU_CO_REF_ALL.CV_VERSION_NUMBER
IGS_PR_RU_APPL_ALL	IGS_PS_VER_ALL	IGS_PR_RU_APPL_ALL.CRV_COURSE_CD IGS_PR_RU_APPL_ALL.CRV_VERSION_NUMBER
IGS_PS_ACCTS_ALL	IGS_PS_VER_ALL	IGS_PS_ACCTS_ALL.COURSE_CD IGS_PS_ACCTS_ALL.VERSION_NUMBER
IGS_PE_TYP_INSTANCES_ALL	IGS_PS_VER_ALL	IGS_PE_TYP_INSTANCES_ALL.COURSE_CD IGS_PE_TYP_INSTANCES_ALL.CC_VERSION_NUMBER
IGS_PS_RSV_ORGUN_PRF	IGS_PS_VER_ALL	IGS_PS_RSV_ORGUN_PRF.PREFERENCE_CODE IGS_PS_RSV_ORGUN_PRF.PREFERENCE_VERSION
IGS_PS_RSV_UOP_PRF	IGS_PS_VER_ALL	IGS_PS_RSV_UOP_PRF.PREFERENCE_CODE IGS_PS_RSV_UOP_PRF.PREFERENCE_VERSION
IGS_PS_STDNT_APV_ALT	IGS_PS_VER_ALL	IGS_PS_STDNT_APV_ALT.EXIT_COURSE_CD IGS_PS_STDNT_APV_ALT.EXIT_VERSION_NUMBER
IGS_PS_STDNT_APV_ALT	IGS_PS_VER_ALL	IGS_PS_STDNT_APV_ALT.COURSE_CD IGS_PS_STDNT_APV_ALT.VERSION_NUMBER
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_AD_SBM_PS_FNTRGT	IGS_PS_VER_ALL	IGS_AD_SBM_PS_FNTRGT.COURSE_CD IGS_AD_SBM_PS_FNTRGT.CRV_VERSION_NUMBER
IGS_PR_S_CRV_PRG_CON	IGS_PS_VER_ALL	IGS_PR_S_CRV_PRG_CON.COURSE_CD IGS_PR_S_CRV_PRG_CON.VERSION_NUMBER
IGS_PR_UL_MARK_CNFG	IGS_PS_VER_ALL	IGS_PR_UL_MARK_CNFG.COURSE_CD IGS_PR_UL_MARK_CNFG.VERSION_NUMBER
IGS_PS_RSV_USEC_PRF	IGS_PS_VER_ALL	IGS_PS_RSV_USEC_PRF.PREFERENCE_CODE IGS_PS_RSV_USEC_PRF.PREFERENCE_VERSION