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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: IGS.IGS_FI_SPECIAL_FEES

Object Details

Object Name:	IGS_FI_SPECIAL_FEES
Object Type:	TABLE
Owner:	IGS
FND Design Data:	IGS.IGS_FI_SPECIAL_FEES
Subobject Name:
Status:	VALID

Stores Student Special Fees transactions

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_SPECIAL_FEES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SPECIAL_FEE_ID
IGS_FI_SPECIAL_FEES_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID COURSE_CD UOO_ID FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER S_TRANSACTION_TYPE_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
SPECIAL_FEE_ID	NUMBER		Yes	Special Fee Transaction Identifier
PERSON_ID	NUMBER	(15)	Yes	Person Identifier
COURSE_CD	VARCHAR2	(6)	Yes	Program Code associated with the Student Unit Attempt
UOO_ID	NUMBER	(7)	Yes	Unit Section Identifier associated with the Special Fee
FEE_TYPE	VARCHAR2	(10)	Yes	Special Fee Type
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Fee Calendar Type associated with the Special Fee Transaction
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Fee Calendar Instance Identifier
FEE_AMT	NUMBER		Yes	Special Fee Amount
TRANSACTION_DATE	DATE		Yes	Transaction date for the Special Fee
S_TRANSACTION_TYPE_CODE	VARCHAR2	(30)	Yes	Transaction Type Identifier indicating if the transaction is 'Special Fee' or 'Retention'.
INVOICE_ID	NUMBER	(15)	Yes	Special Fees charge identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
REQUEST_ID	NUMBER	(15)		Standard Concurrent Program Column
PROGRAM_ID	NUMBER	(15)		Standard Concurrent Program Column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Concurrent Program Column
PROGRAM_UPDATE_DATE	DATE			Standard Concurrent Program Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SPECIAL_FEE_ID
,      PERSON_ID
,      COURSE_CD
,      UOO_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_AMT
,      TRANSACTION_DATE
,      S_TRANSACTION_TYPE_CODE
,      INVOICE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_SPECIAL_FEES;

Dependencies

[top of page]

IGS.IGS_FI_SPECIAL_FEES does not reference any database object

IGS.IGS_FI_SPECIAL_FEES is referenced by following:

APPS: IGS_FI_SPECIAL_FEES