FND Design Data [Home] [Help]

Table: IGS_PE_VISA

Product: IGS - Student System
Description: This is the table that will contain all information related to the visa
Implementation/DBA Data: TableIGS.IGS_PE_VISA
Primary Key: IGS_PE_VISA_PK
  1. ColumnVISA_ID
Primary Key: IGS_PE_VISA_U1
  1. ColumnPERSON_ID
  2. ColumnVISA_TYPE
  3. ColumnVISA_ISSUE_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PE_VISA FK Joins to TableHZ_PARTIES IGS_PE_VISA.PERSON_ID
IGS_PE_VISA FK Joins to TableHZ_PARTIES IGS_PE_VISA.AGENT_PERSON_ID
IGS_PE_VISA FK Joins to TableIGS_PE_PASSPORT IGS_PE_VISA.PASSPORT_ID
TableIGS_PE_VISIT_HISTRY FK Joins to IGS_PE_VISA IGS_PE_VISIT_HISTRY.VISA_ID