FND Design Data [Home] [Help]

Table: IGS_FI_PERSON_HOLDS

Product: IGS - Student System (Obsolete)
Description: This table acts as an intermediate table that will be used by the release hold process to find out the holds placed on a person by student finance. The Apply Hold Process populates data into this table.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_FI_PERSON_HOLDS_PK
  1. ColumnPERSON_ID
  2. ColumnHOLD_TYPE
  3. ColumnHOLD_START_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_PERSON_HOLDS FK Joins to TableIGS_CA_INST_ALL IGS_FI_PERSON_HOLDS.FEE_CAL_TYPE
IGS_FI_PERSON_HOLDS.FEE_CI_SEQUENCE_NUMBER
IGS_FI_PERSON_HOLDS FK Joins to TableIGS_FI_ENCMB_TYPE_ALL IGS_FI_PERSON_HOLDS.HOLD_TYPE
IGS_FI_PERSON_HOLDS FK Joins to TableIGS_FI_HOLD_PLAN IGS_FI_PERSON_HOLDS.HOLD_PLAN_NAME
IGS_FI_PERSON_HOLDS FK Joins to TableHZ_PARTIES IGS_FI_PERSON_HOLDS.PERSON_ID
IGS_FI_PERSON_HOLDS FK Joins to TableIGS_FI_PP_STD_ATTRS IGS_FI_PERSON_HOLDS.STUDENT_PLAN_ID
IGS_FI_PERSON_HOLDS FK Joins to TableIGS_FI_CREDITS_ALL IGS_FI_PERSON_HOLDS.RELEASE_CREDIT_ID