Table: IGS_PE_RES_DTLS_ALL

Product:	IGS - Student System
Description:	This table holds the details about the students residency details.
Implementation/DBA Data:	IGS.IGS_PE_RES_DTLS_ALL

Primary Key: IGS_PE_RES_DTLS_PK

1. RESIDENT_DETAILS_ID

Primary Key: IGS_PE_RES_DTLS_U2

1. PERSON_ID
2. RESIDENCY_CLASS_CD
3. CAL_TYPE
4. SEQUENCE_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_PE_RES_DTLS_ALL		IGS_CA_INST_ALL	IGS_PE_RES_DTLS_ALL.CAL_TYPE IGS_PE_RES_DTLS_ALL.SEQUENCE_NUMBER
IGS_PE_RES_DTLS_ALL		HZ_PARTIES	IGS_PE_RES_DTLS_ALL.PERSON_ID
IGS_PE_RES_DTLS_ALL		IGS_PE_CODE_CLASSES	IGS_PE_RES_DTLS_ALL.RESIDENCY_STATUS_ID
IGS_PE_RES_DTLS_ALL		IGS_PE_CODE_CLASSES	IGS_PE_RES_DTLS_ALL.RESIDENCY_CLASS_ID
IGS_PE_RES_DTLS_H		IGS_PE_RES_DTLS_ALL	IGS_PE_RES_DTLS_H.PERSON_ID IGS_PE_RES_DTLS_H.RESIDENCY_CLASS_CD