FND Design Data [Home] [Help]

Table: IGS_PS_ANL_LOAD

Product: IGS - Student System
Description: This entity describes the annual load for each year of a program. Units are linked to this load defining the standard load for their EFTSU calculation.
Implementation/DBA Data: TableIGS.IGS_PS_ANL_LOAD
Primary Key: IGS_PS_ANL_LOAD_PK
  1. ColumnCOURSE_CD
  2. ColumnVERSION_NUMBER
  3. ColumnYR_NUM
  4. ColumnEFFECTIVE_START_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_ANL_LOAD FK Joins to TableIGS_PS_VER_ALL IGS_PS_ANL_LOAD.COURSE_CD
IGS_PS_ANL_LOAD.VERSION_NUMBER
TableIGS_PS_ANL_LOAD_U_LN FK Joins to IGS_PS_ANL_LOAD IGS_PS_ANL_LOAD_U_LN.COURSE_CD
IGS_PS_ANL_LOAD_U_LN.CRV_VERSION_NUMBER
IGS_PS_ANL_LOAD_U_LN.YR_NUM
IGS_PS_ANL_LOAD_U_LN.EFFECTIVE_START_DT