FND Design Data [Home] [Help]

Table: IGS_FI_A_HIERARCHIES

Product: IGS - Student System
Description: Captures application hierarchies setup information from the Define Application Hierarchy form along with information about the credit type associated with this hierarchy.
Implementation/DBA Data: TableIGS.IGS_FI_A_HIERARCHIES
Primary Key: IGS_FI_A_HIERARCHIES_PK
  1. ColumnAPPL_HIERARCHY_ID
Primary Key: IGS_FI_A_HIERARCHIES_UK
  1. ColumnHIERARCHY_NAME
  2. ColumnVERSION_NUMBER
  3. ColumnEFFECTIVE_START_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_FI_A_HIERARCHIES FK Joins to TableIGS_FI_CR_TYPES_ALL IGS_FI_A_HIERARCHIES.CREDIT_TYPE_ID
TableIGS_FI_APPLICATIONS FK Joins to IGS_FI_A_HIERARCHIES IGS_FI_APPLICATIONS.APPL_HIERARCHY_ID
TableIGS_FI_CR_TYPES_ALL FK Joins to IGS_FI_A_HIERARCHIES IGS_FI_CR_TYPES_ALL.APPL_HIERARCHY_ID
TableIGS_FI_APP_RULES FK Joins to IGS_FI_A_HIERARCHIES IGS_FI_APP_RULES.APPL_HIERARCHY_ID