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_AS_UNITASS_ITEM_ALL

Product:	IGS - Student System
Description:	Describes assessment items allocated to unit version within nominated teaching calendar instance
Implementation/DBA Data:	IGS.IGS_AS_UNITASS_ITEM_ALL

Primary Key: IGS_AS_UNITASS_ITEM_ALL_PK

UNIT_ASS_ITEM_ID

Primary Key: IGS_AS_UNITASS_ITEM_ALL_UK

UNIT_CD
VERSION_NUMBER
CAL_TYPE
CI_SEQUENCE_NUMBER
ASS_ID
SEQUENCE_NUMBER

Foreign Keys

Table	Foreign Table	Foreign Key Column
IGS_AS_UNITASS_ITEM_ALL	IGS_CA_INST_ALL	IGS_AS_UNITASS_ITEM_ALL.EXAM_CAL_TYPE IGS_AS_UNITASS_ITEM_ALL.EXAM_CI_SEQUENCE_NUMBER
IGS_AS_UNITASS_ITEM_ALL	IGS_AS_GRD_SCHEMA	IGS_AS_UNITASS_ITEM_ALL.GRADING_SCHEMA_CD IGS_AS_UNITASS_ITEM_ALL.GS_VERSION_NUMBER
IGS_AS_UNITASS_ITEM_ALL	IGS_AD_LOCATION_ALL	IGS_AS_UNITASS_ITEM_ALL.LOCATION_CD
IGS_AS_UNITASS_ITEM_ALL	IGS_AS_UNIT_AI_GRP	IGS_AS_UNITASS_ITEM_ALL.UNIT_ASS_ITEM_GROUP_ID
IGS_AS_UNITASS_ITEM_ALL	IGS_PS_UNIT_OFR_PAT_ALL	IGS_AS_UNITASS_ITEM_ALL.UNIT_CD IGS_AS_UNITASS_ITEM_ALL.VERSION_NUMBER IGS_AS_UNITASS_ITEM_ALL.CAL_TYPE IGS_AS_UNITASS_ITEM_ALL.CI_SEQUENCE_NUMBER
IGS_AS_UNT_PATRN_ITM	IGS_AS_UNITASS_ITEM_ALL	IGS_AS_UNT_PATRN_ITM.UNIT_CD IGS_AS_UNT_PATRN_ITM.VERSION_NUMBER IGS_AS_UNT_PATRN_ITM.CAL_TYPE IGS_AS_UNT_PATRN_ITM.CI_SEQUENCE_NUMBER IGS_AS_UNT_PATRN_ITM.ASS_ID IGS_AS_UNT_PATRN_ITM.UAI_SEQUENCE_NUMBER