Table: IGS_PS_FLD_OF_STUDY_ALL

Product:	IGS - Student System
Description:	This entity describes the university set of fields of study. This is not limited to the DEET set and values, which are reported to DEET, will be mapped onto DEET equivalent values.
Implementation/DBA Data:	IGS.IGS_PS_FLD_OF_STUDY_ALL

Primary Key: IGS_PS_FLD_OF_STUDY_PK

1. FIELD_OF_STUDY

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PS_FLD_OF_STUDY_ALL		IGS_RE_GV_FLD_OF_SDY	IGS_PS_FLD_OF_STUDY_ALL.GOVT_FIELD_OF_STUDY
IGS_RE_CDT_FLD_OF_SY		IGS_PS_FLD_OF_STUDY_ALL	IGS_RE_CDT_FLD_OF_SY.FIELD_OF_STUDY
IGS_PS_FLD_STD_HIST_ALL		IGS_PS_FLD_OF_STUDY_ALL	IGS_PS_FLD_STD_HIST_ALL.FIELD_OF_STUDY
IGS_PS_FIELD_STUDY		IGS_PS_FLD_OF_STUDY_ALL	IGS_PS_FIELD_STUDY.FIELD_OF_STUDY
IGS_PS_FACLTY_DISP		IGS_PS_FLD_OF_STUDY_ALL	IGS_PS_FACLTY_DISP.DISPLN_UNIT_CD
IGS_HE_EN_SUSA_CC		IGS_PS_FLD_OF_STUDY_ALL	IGS_HE_EN_SUSA_CC.SUBJECT
IGS_HE_ST_PROG_CC		IGS_PS_FLD_OF_STUDY_ALL	IGS_HE_ST_PROG_CC.SUBJECT
IGS_HE_ST_SPA_CC		IGS_PS_FLD_OF_STUDY_ALL	IGS_HE_ST_SPA_CC.SUBJECT
IGS_HE_UT_EXCL_QALS		IGS_PS_FLD_OF_STUDY_ALL	IGS_HE_UT_EXCL_QALS.FIELD_OF_STUDY
IGS_PS_US_FLD_STUDY		IGS_PS_FLD_OF_STUDY_ALL	IGS_PS_US_FLD_STUDY.FIELD_OF_STUDY
IGS_SS_AD_ACADIN_STG		IGS_PS_FLD_OF_STUDY_ALL	IGS_SS_AD_ACADIN_STG.FIELD_OF_STUDY
IGS_AD_TER_EDU		IGS_PS_FLD_OF_STUDY_ALL	IGS_AD_TER_EDU.FIELD_OF_STUDY
IGS_UC_QUAL_DETS		IGS_PS_FLD_OF_STUDY_ALL	IGS_UC_QUAL_DETS.SUBJECT_CODE
IGS_PS_UNIT_FLD_STDY		IGS_PS_FLD_OF_STUDY_ALL	IGS_PS_UNIT_FLD_STDY.FIELD_OF_STUDY