FND Design Data [Home] [Help]

Table: IGS_PS_ANL_LOAD_U_LN

Product: IGS - Student System
Description: This entity describes a unit, which is linked to an annual load figure for the purposes of calculating its EFTSU. For example, a unit may be linked to the load for the first year of the program.
Implementation/DBA Data: TableIGS.IGS_PS_ANL_LOAD_U_LN
Primary Key: IGS_PS_ANL_LOAD_U_LN_PK
  1. ColumnCOURSE_CD
  2. ColumnCRV_VERSION_NUMBER
  3. ColumnYR_NUM
  4. ColumnEFFECTIVE_START_DT
  5. ColumnUNIT_CD
  6. ColumnUV_VERSION_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_ANL_LOAD_U_LN FK Joins to TableIGS_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
IGS_PS_ANL_LOAD_U_LN FK Joins to TableIGS_PS_UNIT_VER_ALL IGS_PS_ANL_LOAD_U_LN.UNIT_CD
IGS_PS_ANL_LOAD_U_LN.UV_VERSION_NUMBER