FND Design Data [Home] [Help]

Table: IGS_PE_RES_DTLS_ALL

Product: IGS - Student System
Description: This table holds the details about the students residency details.
Implementation/DBA Data: TableIGS.IGS_PE_RES_DTLS_ALL
Primary Key: IGS_PE_RES_DTLS_PK
  1. ColumnRESIDENT_DETAILS_ID
Primary Key: IGS_PE_RES_DTLS_U2
  1. ColumnPERSON_ID
  2. ColumnRESIDENCY_CLASS_CD
  3. ColumnCAL_TYPE
  4. ColumnSEQUENCE_NUMBER
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_PE_RES_DTLS_ALL FK Joins to TableIGS_CA_INST_ALL IGS_PE_RES_DTLS_ALL.CAL_TYPE
IGS_PE_RES_DTLS_ALL.SEQUENCE_NUMBER
IGS_PE_RES_DTLS_ALL FK Joins to TableHZ_PARTIES IGS_PE_RES_DTLS_ALL.PERSON_ID
IGS_PE_RES_DTLS_ALL FK Joins to TableIGS_PE_CODE_CLASSES IGS_PE_RES_DTLS_ALL.RESIDENCY_STATUS_ID
IGS_PE_RES_DTLS_ALL FK Joins to TableIGS_PE_CODE_CLASSES IGS_PE_RES_DTLS_ALL.RESIDENCY_CLASS_ID
TableIGS_PE_RES_DTLS_H FK Joins to IGS_PE_RES_DTLS_ALL IGS_PE_RES_DTLS_H.PERSON_ID
IGS_PE_RES_DTLS_H.RESIDENCY_CLASS_CD