FND Design Data [Home] [Help]

Table: IGS_PS_FAC_WL

Product: IGS - Student System
Description: This table stores the workload for the faculty
Implementation/DBA Data: TableIGS.IGS_PS_FAC_WL
Primary Key: IGS_PS_FAC_WL_PK
  1. ColumnFAC_WL_ID
Primary Key: IGS_PS_FAC_WL_UK
  1. ColumnPERSON_ID
  2. ColumnCAL_TYPE
  3. ColumnCI_SEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PS_FAC_WL FK Joins to TableIGS_CA_INST_ALL IGS_PS_FAC_WL.CAL_TYPE
IGS_PS_FAC_WL.CI_SEQUENCE_NUMBER
IGS_PS_FAC_WL FK Joins to TableHZ_PARTIES IGS_PS_FAC_WL.PERSON_ID
TableIGS_PS_FAC_ASG_TASK FK Joins to IGS_PS_FAC_WL IGS_PS_FAC_ASG_TASK.FAC_WL_ID
TableIGS_PS_FAC_OVR_WL FK Joins to IGS_PS_FAC_WL IGS_PS_FAC_OVR_WL.FAC_WL_ID