eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

Table: IGS_CA_DA_INST_PAIR

Product:	IGS - Student System (Obsolete)
Description:	Stores the pairing of two date alias instances and enables the definition of a period of time inclusive of the two date aliases
Implementation/DBA Data:	Not implemented in this database

Primary Key: DAIP_UK

DT_ALIAS
DAI_SEQUENCE_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER

Primary Key: IGS_CA_DA_INST_PAIR_PK

DT_ALIAS
DAI_SEQUENCE_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
RELATED_DT_ALIAS
RELATED_DAI_SEQUENCE_NUMBER
RELATED_CAL_TYPE
RELATED_CI_SEQUENCE_NUMBER

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_CA_DA_INST_PAIR		IGS_CA_DA_INST	IGS_CA_DA_INST_PAIR.DT_ALIAS IGS_CA_DA_INST_PAIR.DAI_SEQUENCE_NUMBER IGS_CA_DA_INST_PAIR.CAL_TYPE IGS_CA_DA_INST_PAIR.CI_SEQUENCE_NUMBER
IGS_CA_DA_INST_PAIR		IGS_CA_DA_INST	IGS_CA_DA_INST_PAIR.RELATED_DT_ALIAS IGS_CA_DA_INST_PAIR.RELATED_DAI_SEQUENCE_NUMBER IGS_CA_DA_INST_PAIR.RELATED_CAL_TYPE IGS_CA_DA_INST_PAIR.RELATED_CI_SEQUENCE_NUMBER