FND Design Data [Home] [Help]

Table: IGS_RC_I_APPL_ALL

Product: IGS - Student System
Description: Describes an enquiry application to the institution. The enquiry can be made at varying levels for varying information types, example faculty of education accommodation information.
Implementation/DBA Data: Not implemented in this database
Primary Key: IGS_RC_I_APPL_ALL_PK
  1. ColumnPERSON_ID
  2. ColumnENQUIRY_APPL_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_RC_I_APPL_ALL FK Joins to TableIGS_AD_CODE_CLASSES IGS_RC_I_APPL_ALL.EDU_GOAL_ID
IGS_RC_I_APPL_ALL FK Joins to TableIGS_AD_CODE_CLASSES IGS_RC_I_APPL_ALL.HOW_KNOWUS_ID
IGS_RC_I_APPL_ALL FK Joins to TableIGS_AD_CODE_CLASSES IGS_RC_I_APPL_ALL.WHO_INFLUENCED_ID
IGS_RC_I_APPL_ALL FK Joins to TableIGS_RC_I_ENTRY_LVLS IGS_RC_I_APPL_ALL.INQ_ENTRY_LEVEL_ID
IGS_RC_I_APPL_ALL FK Joins to TableIGS_CA_INST_REL IGS_RC_I_APPL_ALL.ADM_CAL_TYPE
IGS_RC_I_APPL_ALL.ADM_CI_SEQUENCE_NUMBER
IGS_RC_I_APPL_ALL.ACAD_CAL_TYPE
IGS_RC_I_APPL_ALL.ACAD_CI_SEQUENCE_NUMBER
IGS_RC_I_APPL_ALL FK Joins to TableHZ_PARTIES IGS_RC_I_APPL_ALL.PERSON_ID
IGS_RC_I_APPL_ALL FK Joins to TableHZ_PARTIES IGS_RC_I_APPL_ALL.REGISTERING_PERSON_ID
IGS_RC_I_APPL_ALL FK Joins to TableHZ_PARTIES IGS_RC_I_APPL_ALL.PARTY_ID
IGS_RC_I_APPL_ALL FK Joins to TableAS_SALES_LEADS IGS_RC_I_APPL_ALL.SALES_LEAD_ID
TableIGS_RC_I_A_CHARTYP FK Joins to IGS_RC_I_APPL_ALL IGS_RC_I_A_CHARTYP.PERSON_ID
IGS_RC_I_A_CHARTYP.ENQUIRY_APPL_NUMBER
TableIGS_RC_I_A_PKGITM FK Joins to IGS_RC_I_APPL_ALL IGS_RC_I_A_PKGITM.PERSON_ID
IGS_RC_I_A_PKGITM.ENQUIRY_APPL_NUMBER