Table: IGS_FI_FEE_AS_ITEMS

Product:	IGS - Student System
Description:	This entity stores an itemized list of assessment items that have contributed to the student's assessment.
Implementation/DBA Data:	IGS.IGS_FI_FEE_AS_ITEMS

Primary Key: AITM_UK

1. TRANSACTION_ID
2. PERSON_ID
3. FEE_TYPE
4. FEE_CAT
5. FEE_CAL_TYPE
6. FEE_CI_SEQUENCE_NUMBER
7. COURSE_CD
8. CRS_VERSION_NUMBER
9. LOCATION_CD
10. UOO_ID
11. ORG_UNIT_CD

Primary Key: IGS_FI_FEE_AS_ITEMS_PK

1. FEE_ASS_ITEM_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
IGS_FI_FEE_AS_ITEMS		IGS_FI_FEE_AS_ALL	IGS_FI_FEE_AS_ITEMS.PERSON_ID IGS_FI_FEE_AS_ITEMS.TRANSACTION_ID
IGS_FI_FEE_AS_ITEMS		HZ_PARTIES	IGS_FI_FEE_AS_ITEMS.PERSON_ID
IGS_FI_FEE_AS_ITEMS		IGS_EN_UNIT_SET_ALL	IGS_FI_FEE_AS_ITEMS.UNIT_SET_CD IGS_FI_FEE_AS_ITEMS.US_VERSION_NUMBER
IGS_FI_FEE_AS_ITEMS		IGS_PS_UNIT_TYPE_LVL	IGS_FI_FEE_AS_ITEMS.UNIT_TYPE_ID
IGS_FI_FEE_AS_ITEMS		IGS_AS_UNIT_CLASS_ALL	IGS_FI_FEE_AS_ITEMS.UNIT_CLASS
IGS_FI_FEE_AS_ITEMS		IGS_AS_UNIT_MODE	IGS_FI_FEE_AS_ITEMS.UNIT_MODE
IGS_FI_FEE_AS_ITEMS		IGS_PS_UNIT_LEVEL_ALL	IGS_FI_FEE_AS_ITEMS.UNIT_LEVEL
IGS_FI_FEE_AS_ITEMS		IGS_RU_RULE	IGS_FI_FEE_AS_ITEMS.SCOPE_RUL_SEQUENCE_NUM
IGS_FI_FEE_AS_ITEMS		%	IGS_FI_FEE_AS_ITEMS.ELM_RNG_ORDER_NAME
IGS_FI_FAI_DTLS		IGS_FI_FEE_AS_ITEMS	IGS_FI_FAI_DTLS.FEE_ASS_ITEM_ID