FND Design Data [Home] [Help]

Table: IGS_AS_EXAM_INSTANCE_ALL

Product: IGS - Student System
Description: Describes relationship between examination session instance and venue
Implementation/DBA Data: TableIGS.IGS_AS_EXAM_INSTANCE_ALL
Primary Key: IGS_AS_EXAM_INSTANCE_ALL_PK
  1. ColumnASS_ID
  2. ColumnEXAM_CAL_TYPE
  3. ColumnEXAM_CI_SEQUENCE_NUMBER
  4. ColumnDT_ALIAS
  5. ColumnDAI_SEQUENCE_NUMBER
  6. ColumnSTART_TIME
  7. ColumnEND_TIME
  8. ColumnVENUE_CD
Foreign Keys
Table
Foreign Table Foreign Key Column
IGS_AS_EXAM_INSTANCE_ALL FK Joins to TableIGS_AS_ASSESSMNT_ITM_ALL IGS_AS_EXAM_INSTANCE_ALL.ASS_ID
IGS_AS_EXAM_INSTANCE_ALL FK Joins to TableIGS_AS_EXAM_SESSION_ALL IGS_AS_EXAM_INSTANCE_ALL.EXAM_CAL_TYPE
IGS_AS_EXAM_INSTANCE_ALL.EXAM_CI_SEQUENCE_NUMBER
IGS_AS_EXAM_INSTANCE_ALL.DT_ALIAS
IGS_AS_EXAM_INSTANCE_ALL.DAI_SEQUENCE_NUMBER
IGS_AS_EXAM_INSTANCE_ALL.START_TIME
IGS_AS_EXAM_INSTANCE_ALL.END_TIME
IGS_AS_EXAM_INSTANCE_ALL FK Joins to TableHZ_PARTIES IGS_AS_EXAM_INSTANCE_ALL.COLLECT_PERSON_ID
IGS_AS_EXAM_INSTANCE_ALL FK Joins to TableIGS_GR_VENUE_ALL IGS_AS_EXAM_INSTANCE_ALL.VENUE_CD
TableIGS_AS_EXM_INS_SPVSR FK Joins to IGS_AS_EXAM_INSTANCE_ALL IGS_AS_EXM_INS_SPVSR.ASS_ID
IGS_AS_EXM_INS_SPVSR.EXAM_CAL_TYPE
IGS_AS_EXM_INS_SPVSR.EXAM_CI_SEQUENCE_NUMBER
IGS_AS_EXM_INS_SPVSR.DT_ALIAS
IGS_AS_EXM_INS_SPVSR.DAI_SEQUENCE_NUMBER
IGS_AS_EXM_INS_SPVSR.START_TIME
IGS_AS_EXM_INS_SPVSR.END_TIME
IGS_AS_EXM_INS_SPVSR.VENUE_CD
TableIGS_AS_STD_EXM_INSTN_ALL FK Joins to IGS_AS_EXAM_INSTANCE_ALL IGS_AS_STD_EXM_INSTN_ALL.ASS_ID
IGS_AS_STD_EXM_INSTN_ALL.EXAM_CAL_TYPE
IGS_AS_STD_EXM_INSTN_ALL.EXAM_CI_SEQUENCE_NUMBER
IGS_AS_STD_EXM_INSTN_ALL.DT_ALIAS
IGS_AS_STD_EXM_INSTN_ALL.DAI_SEQUENCE_NUMBER
IGS_AS_STD_EXM_INSTN_ALL.START_TIME
IGS_AS_STD_EXM_INSTN_ALL.END_TIME
IGS_AS_STD_EXM_INSTN_ALL.VENUE_CD