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

Product:	IGS - Student System
Description:	Describes an instance of a date alias in a calendar instance
Implementation/DBA Data:	IGS.IGS_CA_DA_INST

Primary Key: IGS_CA_DA_INST_PK

DT_ALIAS
SEQUENCE_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_CA_DA_INST	IGS_CA_INST_ALL	IGS_CA_DA_INST.CAL_TYPE IGS_CA_DA_INST.CI_SEQUENCE_NUMBER
IGS_CA_DA_INST	IGS_CA_DA	IGS_CA_DA_INST.DT_ALIAS
IGS_AD_PECRS_OFOP_DT	IGS_CA_DA_INST	IGS_AD_PECRS_OFOP_DT.DT_ALIAS IGS_AD_PECRS_OFOP_DT.DAI_SEQUENCE_NUMBER IGS_AD_PECRS_OFOP_DT.ADM_CAL_TYPE IGS_AD_PECRS_OFOP_DT.ADM_CI_SEQUENCE_NUMBER
IGS_CA_DA_INST_OFST	IGS_CA_DA_INST	IGS_CA_DA_INST_OFST.DT_ALIAS IGS_CA_DA_INST_OFST.DAI_SEQUENCE_NUMBER IGS_CA_DA_INST_OFST.CAL_TYPE IGS_CA_DA_INST_OFST.CI_SEQUENCE_NUMBER
IGS_CA_DA_INST_OFST	IGS_CA_DA_INST	IGS_CA_DA_INST_OFST.OFFSET_DT_ALIAS IGS_CA_DA_INST_OFST.OFFSET_DAI_SEQUENCE_NUMBER IGS_CA_DA_INST_OFST.OFFSET_CAL_TYPE IGS_CA_DA_INST_OFST.OFFSET_CI_SEQUENCE_NUMBER
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
IGS_FI_F_CAT_CA_INST	IGS_CA_DA_INST	IGS_FI_F_CAT_CA_INST.END_DT_ALIAS IGS_FI_F_CAT_CA_INST.END_DAI_SEQUENCE_NUMBER IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST	IGS_CA_DA_INST	IGS_FI_F_CAT_CA_INST.RETRO_DT_ALIAS IGS_FI_F_CAT_CA_INST.RETRO_DAI_SEQUENCE_NUMBER IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_CA_INST	IGS_CA_DA_INST	IGS_FI_F_CAT_CA_INST.START_DT_ALIAS IGS_FI_F_CAT_CA_INST.START_DAI_SEQUENCE_NUMBER IGS_FI_F_CAT_CA_INST.FEE_CAL_TYPE IGS_FI_F_CAT_CA_INST.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_CAT_FEE_LBL_ALL	IGS_CA_DA_INST	IGS_FI_F_CAT_FEE_LBL_ALL.START_DT_ALIAS IGS_FI_F_CAT_FEE_LBL_ALL.START_DAI_SEQUENCE_NUMBER IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CAL_TYPE IGS_FI_F_CAT_FEE_LBL_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_FEE_ENCMB	IGS_CA_DA_INST	IGS_FI_FEE_ENCMB.DT_ALIAS IGS_FI_FEE_ENCMB.DAI_SEQUENCE_NUMBER IGS_FI_FEE_ENCMB.FEE_CAL_TYPE IGS_FI_FEE_ENCMB.FEE_CI_SEQUENCE_NUMBER
IGS_FI_FEE_PAY_SCHD	IGS_CA_DA_INST	IGS_FI_FEE_PAY_SCHD.DT_ALIAS IGS_FI_FEE_PAY_SCHD.DAI_SEQUENCE_NUMBER IGS_FI_FEE_PAY_SCHD.FEE_CAL_TYPE IGS_FI_FEE_PAY_SCHD.FEE_CI_SEQUENCE_NUMBER
IGS_FI_FEE_RET_SCHD	IGS_CA_DA_INST	IGS_FI_FEE_RET_SCHD.DT_ALIAS IGS_FI_FEE_RET_SCHD.DAI_SEQUENCE_NUMBER IGS_FI_FEE_RET_SCHD.FEE_CAL_TYPE IGS_FI_FEE_RET_SCHD.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL	IGS_CA_DA_INST	IGS_FI_F_TYP_CA_INST_ALL.END_DT_ALIAS IGS_FI_F_TYP_CA_INST_ALL.END_DAI_SEQUENCE_NUMBER IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL	IGS_CA_DA_INST	IGS_FI_F_TYP_CA_INST_ALL.RETRO_DT_ALIAS IGS_FI_F_TYP_CA_INST_ALL.RETRO_DAI_SEQUENCE_NUMBER IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL	IGS_CA_DA_INST	IGS_FI_F_TYP_CA_INST_ALL.START_DT_ALIAS IGS_FI_F_TYP_CA_INST_ALL.START_DAI_SEQUENCE_NUMBER IGS_FI_F_TYP_CA_INST_ALL.FEE_CAL_TYPE IGS_FI_F_TYP_CA_INST_ALL.FEE_CI_SEQUENCE_NUMBER
IGS_FI_TP_RET_SCHD	IGS_CA_DA_INST	IGS_FI_TP_RET_SCHD.DT_ALIAS IGS_FI_TP_RET_SCHD.DAI_SEQUENCE_NUMBER IGS_FI_TP_RET_SCHD.TEACH_CAL_TYPE IGS_FI_TP_RET_SCHD.TEACH_CI_SEQUENCE_NUMBER