Table: IGS_PS_TYPE_ALL

Product:	IGS - Student System
Description:	This entity describes the university set of program types. This set 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_TYPE_ALL

Primary Key: IGS_PS_TYPE_PK

1. COURSE_TYPE

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PS_TYPE_ALL		IGS_PS_TYPE_GRP	IGS_PS_TYPE_ALL.COURSE_TYPE_GROUP_CD
IGS_PS_TYPE_ALL		IGS_PS_GOVT_TYPE	IGS_PS_TYPE_ALL.GOVT_COURSE_TYPE
IGS_AD_CAT_PS_TYPE		IGS_PS_TYPE_ALL	IGS_AD_CAT_PS_TYPE.COURSE_TYPE
IGS_AS_COURSE_TYPE_ALL		IGS_PS_TYPE_ALL	IGS_AS_COURSE_TYPE_ALL.COURSE_TYPE
IGS_AS_STU_TRN_CMTS		IGS_PS_TYPE_ALL	IGS_AS_STU_TRN_CMTS.COURSE_TYPE
IGS_AV_STD_UNT_BASIS_ALL		IGS_PS_TYPE_ALL	IGS_AV_STD_UNT_BASIS_ALL.BASIS_COURSE_TYPE
IGS_AV_STD_ULVLBASIS_ALL		IGS_PS_TYPE_ALL	IGS_AV_STD_ULVLBASIS_ALL.BASIS_COURSE_TYPE
IGS_PS_VER_ALL		IGS_PS_TYPE_ALL	IGS_PS_VER_ALL.COURSE_TYPE
IGS_PS_TYPE_FEE_TRG		IGS_PS_TYPE_ALL	IGS_PS_TYPE_FEE_TRG.COURSE_TYPE
IGS_PS_UNIT_LVL_HIST_ALL		IGS_PS_TYPE_ALL	IGS_PS_UNIT_LVL_HIST_ALL.COURSE_TYPE
IGS_PS_UNIT_LVL_ALL		IGS_PS_TYPE_ALL	IGS_PS_UNIT_LVL_ALL.COURSE_TYPE
IGF_AP_FA_ANT_DATA		IGS_PS_TYPE_ALL	IGF_AP_FA_ANT_DATA.PROGRAM_TYPE
IGF_AW_COA_RATE_DET		IGS_PS_TYPE_ALL	IGF_AW_COA_RATE_DET.PROGRAM_TYPE
IGS_AD_DEPLVL_PRGTY		IGS_PS_TYPE_ALL	IGS_AD_DEPLVL_PRGTY.PROGRAM_TYPE
IGS_FI_1098T_PTS		IGS_PS_TYPE_ALL	IGS_FI_1098T_PTS.COURSE_TYPE
IGS_PS_DEGREES		IGS_PS_TYPE_ALL	IGS_PS_DEGREES.PROGRAM_TYPE
IGS_OR_REL_PS_TYPE		IGS_PS_TYPE_ALL	IGS_OR_REL_PS_TYPE.COURSE_TYPE
IGS_PR_CS_SCHDL		IGS_PS_TYPE_ALL	IGS_PR_CS_SCHDL.COURSE_TYPE
IGS_PS_PRG_UNIT_REL		IGS_PS_TYPE_ALL	IGS_PS_PRG_UNIT_REL.STUDENT_CAREER_LEVEL
IGS_PR_RU_APPL_ALL		IGS_PS_TYPE_ALL	IGS_PR_RU_APPL_ALL.COURSE_TYPE
IGS_EN_UNITSETPSTYPE		IGS_PS_TYPE_ALL	IGS_EN_UNITSETPSTYPE.COURSE_TYPE
IGS_AS_VAH_CONF		IGS_PS_TYPE_ALL	IGS_AS_VAH_CONF.COURSE_TYPE