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_UNIT_OFR_OPT_ALL

Product:	IGS - Student System
Description:	This entity describes the available options for each unit offering.
Implementation/DBA Data:	IGS.IGS_PS_UNIT_OFR_OPT_ALL

Primary Key: IGS_PS_UNIT_OFR_OPT_ALL_UK2

CAL_TYPE
CI_SEQUENCE_NUMBER
CALL_NUMBER

Primary Key: IGS_PS_UNIT_OFR_OPT_PK

UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
LOCATION_CD
UNIT_CLASS

Primary Key: UOO_UK

UOO_ID

Primary Key: UOO_UK1

UOO_ID

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_PS_UNIT_OFR_OPT_ALL	IGS_FI_ACC_ALL	IGS_PS_UNIT_OFR_OPT_ALL.REV_ACCOUNT_CD
IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_GRD_SCHEMA	IGS_PS_UNIT_OFR_OPT_ALL.GRADING_SCHEMA_CD IGS_PS_UNIT_OFR_OPT_ALL.GS_VERSION_NUMBER
IGS_PS_UNIT_OFR_OPT_ALL	HZ_PARTIES	IGS_PS_UNIT_OFR_OPT_ALL.UNIT_CONTACT
IGS_PS_UNIT_OFR_OPT_ALL	IGS_AD_LOCATION_ALL	IGS_PS_UNIT_OFR_OPT_ALL.LOCATION_CD
IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_UNIT_CLASS_ALL	IGS_PS_UNIT_OFR_OPT_ALL.UNIT_CLASS
IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_UNIT_OFR_PAT_ALL	IGS_PS_UNIT_OFR_OPT_ALL.UNIT_CD IGS_PS_UNIT_OFR_OPT_ALL.VERSION_NUMBER IGS_PS_UNIT_OFR_OPT_ALL.CAL_TYPE IGS_PS_UNIT_OFR_OPT_ALL.CI_SEQUENCE_NUMBER
IGS_AD_PS_APLINSTUNT_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AD_PS_APLINSTUNT_ALL.UNIT_CD IGS_AD_PS_APLINSTUNT_ALL.UV_VERSION_NUMBER IGS_AD_PS_APLINSTUNT_ALL.CAL_TYPE IGS_AD_PS_APLINSTUNT_ALL.CI_SEQUENCE_NUMBER IGS_AD_PS_APLINSTUNT_ALL.LOCATION_CD IGS_AD_PS_APLINSTUNT_ALL.UNIT_CLASS
IGS_AS_ANON_ID_US	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_ANON_ID_US.UOO_ID
IGS_AS_STU_TRN_CMTS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_STU_TRN_CMTS.UOO_ID
IGS_AS_USEC_SESSNS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_USEC_SESSNS.UOO_ID
IGS_EN_SPL_PERM	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SPL_PERM.UOO_ID
IGS_EN_ELGB_OVR_STEP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_ELGB_OVR_STEP.UOO_ID
IGS_AS_GAA_SUB_HIST	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_GAA_SUB_HIST.UOO_ID
IGS_EN_ELGB_OVR_UOO	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_ELGB_OVR_UOO.UOO_ID
IGS_EN_NSTD_USEC_DL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_NSTD_USEC_DL.UOO_ID
IGS_EN_PLAN_UNITS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_PLAN_UNITS.UOO_ID
IGS_EN_USEC_DISC_DL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_USEC_DISC_DL.UOO_ID
IGS_FI_FAI_DTLS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_FI_FAI_DTLS.UOO_ID
IGS_FI_FTCI_ACCTS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_FI_FTCI_ACCTS.UOO_ID
IGS_PS_NSUS_RTN	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_NSUS_RTN.UOO_ID
IGS_PS_US_EXAM_MEET	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_US_EXAM_MEET.UOO_ID
IGS_PS_USEC_X_GRPMEM	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_GRPMEM.UOO_ID
IGS_PS_US_UNSCHED_CL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_US_UNSCHED_CL.UOO_ID
IGS_PS_USEC_SP_FEES	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_SP_FEES.UOO_ID
IGS_PS_USEC_WLST_PRI	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_WLST_PRI.UOO_ID
IGS_PS_USO_CLAS_MEET	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USO_CLAS_MEET.UOO_ID
IGS_AS_NOTIFY_BE	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_NOTIFY_BE.UOO_ID
IGS_PS_USEC_ACCTS_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_ACCTS_ALL.UOO_ID
IGS_PS_RSV_EXT	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_RSV_EXT.UOO_ID
IGS_PS_RSV_TEMP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_RSV_TEMP.UOO_ID
IGS_EN_SU_ATTEMPT_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UNIT_CD IGS_EN_SU_ATTEMPT_ALL.VERSION_NUMBER IGS_EN_SU_ATTEMPT_ALL.CAL_TYPE IGS_EN_SU_ATTEMPT_ALL.CI_SEQUENCE_NUMBER IGS_EN_SU_ATTEMPT_ALL.LOCATION_CD IGS_EN_SU_ATTEMPT_ALL.UNIT_CLASS
IGS_EN_SU_ATTEMPT_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UOO_ID
IGS_EN_SU_ATTEMPT_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_EN_SU_ATTEMPT_ALL.UOO_ID
IGS_PS_TCH_RSOV_HIST_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_TCH_RSOV_HIST_ALL.UNIT_CD IGS_PS_TCH_RSOV_HIST_ALL.VERSION_NUMBER IGS_PS_TCH_RSOV_HIST_ALL.CAL_TYPE IGS_PS_TCH_RSOV_HIST_ALL.CI_SEQUENCE_NUMBER IGS_PS_TCH_RSOV_HIST_ALL.LOCATION_CD IGS_PS_TCH_RSOV_HIST_ALL.UNIT_CLASS
IGS_PS_TCH_RESP_OVRD_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_TCH_RESP_OVRD_ALL.UNIT_CD IGS_PS_TCH_RESP_OVRD_ALL.VERSION_NUMBER IGS_PS_TCH_RESP_OVRD_ALL.CAL_TYPE IGS_PS_TCH_RESP_OVRD_ALL.CI_SEQUENCE_NUMBER IGS_PS_TCH_RESP_OVRD_ALL.LOCATION_CD IGS_PS_TCH_RESP_OVRD_ALL.UNIT_CLASS
IGS_PS_TCH_RESP_OVRD_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_TCH_RESP_OVRD_ALL.UOO_ID
IGS_PS_TCH_RESP_OVRD_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_TCH_RESP_OVRD_ALL.UOO_ID
IGS_PS_UNITASS_ITEM	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_UNITASS_ITEM.UOO_ID
IGS_AS_USEC_ATD_LINE	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_USEC_ATD_LINE.UOO_ID
IGS_PS_UNT_OFR_OPT_N	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_UNT_OFR_OPT_N.UNIT_CD IGS_PS_UNT_OFR_OPT_N.VERSION_NUMBER IGS_PS_UNT_OFR_OPT_N.CAL_TYPE IGS_PS_UNT_OFR_OPT_N.CI_SEQUENCE_NUMBER IGS_PS_UNT_OFR_OPT_N.LOCATION_CD IGS_PS_UNT_OFR_OPT_N.UNIT_CLASS
IGS_PS_UNT_OFR_OPT_N	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_UNT_OFR_OPT_N.UOO_ID
IGS_PS_UNT_OFR_OPT_N	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_UNT_OFR_OPT_N.UOO_ID
IGS_AS_US_AI_GROUP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_AS_US_AI_GROUP.UOO_ID
IGS_PS_USEC_AS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_AS.UOO_ID
IGS_PS_USEC_AS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_AS.UOO_ID
IGS_PS_USEC_CHARGE	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_CHARGE.UOO_ID
IGS_PS_USEC_CPS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_CPS.UOO_ID
IGS_PS_USEC_CPS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_CPS.UOO_ID
IGS_PS_USEC_CATEGORY	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_CATEGORY.UOO_ID
IGS_PS_USEC_RU	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_RU.UOO_ID
IGS_PS_USEC_RU	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_RU.UOO_ID
IGS_PS_USEC_GRD_SCHM	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_GRD_SCHM.UOO_ID
IGS_PS_USEC_LIM_WLST	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_LIM_WLST.UOO_ID
IGS_PS_USEC_LIM_WLST	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_LIM_WLST.UOO_ID
IGS_PS_USEC_OCCURS_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_OCCURS_ALL.UOO_ID
IGS_PS_USEC_OCCURS_ALL	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_OCCURS_ALL.UOO_ID
IGS_PS_USEC_PRV_GRAD	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_PRV_GRAD.UOO_ID
IGS_PS_USEC_SPNSRSHP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_SPNSRSHP.UOO_ID
IGS_PS_USEC_SPNSRSHP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_SPNSRSHP.UOO_ID
IGS_PS_RSV_USEC_PRI	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_RSV_USEC_PRI.UOO_ID
IGS_PS_USEC_RPT_COND	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_RPT_COND.UOO_ID
IGS_PS_USEC_REF	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_REF.UOO_ID
IGS_PS_USEC_REF	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_REF.UOO_ID
IGS_PS_USEC_RPT_FMLY	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_RPT_FMLY.UOO_ID
IGS_PS_USEC_TCH_RESP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_TCH_RESP.UOO_ID
IGS_PS_USEC_TCH_RESP	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_TCH_RESP.UOO_ID
IGS_PS_USEC_X_USEC	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_USEC.CHILD_UOO_ID
IGS_PS_USEC_X_USEC	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_USEC.CHILD_UOO_ID
IGS_PS_USEC_X_USEC	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_USEC.PARENT_UOO_ID
IGS_PS_USEC_X_USEC	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_USEC.PARENT_UOO_ID
IGS_PS_USEC_X_UNITS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_UNITS.UOO_ID
IGS_PS_USEC_X_UNITS	IGS_PS_UNIT_OFR_OPT_ALL	IGS_PS_USEC_X_UNITS.UOO_ID