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_FEE_AS_ALL

Object Details

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

IGS_FI_FEE_AS_ALL describes the fee assessments against a person for a fee category fee liability.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_FEE_AS_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID TRANSACTION_ID
IGS_FI_FEE_AS_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAT FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER FEE_TYPE
IGS_FI_FEE_AS_ALL_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CURRENCY_CD
IGS_FI_FEE_AS_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	COURSE_CD
IGS_FI_FEE_AS_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER
IGS_FI_FEE_AS_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
TRANSACTION_ID	NUMBER	(6)	Yes	Uniquely identifies the fee assessment
FEE_TYPE	VARCHAR2	(10)	Yes	Describes the fee types used for the purpose of applying fees and charges. A fee type might be used with many fee categories, permitting a single system wide fee definition to be used. For example, contribution, guild.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type with calendar category of fee used in the assessment of student fees.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
FEE_CAT	VARCHAR2	(10)		Fee categories are created to identify distinct fee assessment groups.
S_TRANSACTION_TYPE	VARCHAR2	(30)	Yes	Describes the fee assessment system transaction type
TRANSACTION_DT	DATE		Yes	Describes the date of recording the fee assessment
TRANSACTION_AMOUNT	NUMBER		Yes	Describes the transaction amount of a fee category fee liability fee assessment. The amount might be both positive or negative.
CURRENCY_CD	VARCHAR2	(15)	Yes	Describes the currency code applicable to the transaction amount. Note, it is only specified for non local currency codes.
EXCHANGE_RATE	NUMBER		Yes	Describes the rate of exchange for the currency
CHG_RATE	NUMBER	(8)		Describes the per element charge rate used for the fee assessment transaction. - column obsolete
CHG_ELEMENTS	NUMBER	(7)		Describes the number of charge elements used for the fee assessment transaction.
EFFECTIVE_DT	DATE			Contains the date of the effective assessment. Assessments can be made retrospectively, hence the transaction date and the effective date may be different.
COURSE_CD	VARCHAR2	(6)		Unique identifier for a program of study
NOTIFICATION_DT	DATE			Describes the date the debtor was notified of the fee assessment.
SPONSOR_CD	VARCHAR2	(10)		OBSOLETE (Describes the code that uniquely identifies the student fee sponsor )- Obsolete
LOGICAL_DELETE_DT	DATE			Date the fee assessment was logically deleted.
COMMENTS	VARCHAR2	(2000)		Contains any special notes or other important information relating to the fee assessment.
ORG_ID	NUMBER	(15)		Operating unit identifier
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.

Query Text

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


SELECT PERSON_ID
,      TRANSACTION_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_CAT
,      S_TRANSACTION_TYPE
,      TRANSACTION_DT
,      TRANSACTION_AMOUNT
,      CURRENCY_CD
,      EXCHANGE_RATE
,      CHG_RATE
,      CHG_ELEMENTS
,      EFFECTIVE_DT
,      COURSE_CD
,      NOTIFICATION_DT
,      SPONSOR_CD
,      LOGICAL_DELETE_DT
,      COMMENTS
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
FROM IGS.IGS_FI_FEE_AS_ALL;

Dependencies

[top of page]

IGS.IGS_FI_FEE_AS_ALL does not reference any database object

IGS.IGS_FI_FEE_AS_ALL is referenced by following:

APPS: IGS_FI_FEE_AS_ALL