FND Design Data [Home] [Help]

Table: IGS_PE_ALT_PERS_ID

Product: IGS - Student System
Description: This entity describes the other ids by which a person is known. eg. OLAA id, VTAC id, old id.
Implementation/DBA Data: TableIGS.IGS_PE_ALT_PERS_ID
Primary Key: IGS_PE_ALT_PERS_ID_PK
  1. ColumnPE_PERSON_ID
  2. ColumnAPI_PERSON_ID
  3. ColumnPERSON_ID_TYPE
  4. ColumnSTART_DT
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PE_ALT_PERS_ID FK Joins to TableHZ_PARTIES IGS_PE_ALT_PERS_ID.PE_PERSON_ID
IGS_PE_ALT_PERS_ID FK Joins to TableIGS_PE_PERSON_ID_TYP IGS_PE_ALT_PERS_ID.PERSON_ID_TYPE