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_RATE

Object Details

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

This describes the method and parameters necessary for determining the amount to charge during fee assessment processing 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_RATE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FAR_ID
IGS_FI_FEE_AS_RATE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER RATE_NUMBER FEE_CAT
IGS_FI_FEE_AS_RATE_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER S_RELATION_TYPE RATE_NUMBER FEE_CAT
IGS_FI_FEE_AS_RATE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAT FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER FEE_TYPE
IGS_FI_FEE_AS_RATE_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LOCATION_CD
IGS_FI_FEE_AS_RATE_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_MODE
IGS_FI_FEE_AS_RATE_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ATTENDANCE_TYPE
IGS_FI_FEE_AS_RATE_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_HECS_PAYMENT_OPTION
IGS_FI_FEE_AS_RATE_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	GOVT_HECS_CNTRBTN_BAND

Columns

Name	Datatype	Length	Mandatory	Comments
FAR_ID	NUMBER	(15)	Yes	Contains the unique system generated fee assessment rate ID.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type with calendar category fee
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.
RATE_NUMBER	NUMBER	(9)	Yes	Uniquely identifies the fee assessment rate number
FEE_CAT	VARCHAR2	(10)		Describes the fee categories applicable to enrolled students. The purpose of the fee category is to identify the distinct fee assessment groups assigned fee type liabilities.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance
LOCATION_CD	VARCHAR2	(10)		Describes the program locations for that the fee should be assessed. If the field is left blank, the assessment rate applies to all locations. If a value is entered the assessment rate applies only to the nominated location.
S_RELATION_TYPE	VARCHAR2	(10)	Yes	Describes the system relation type for that the fee assessment rate belongs.
ATTENDANCE_TYPE	VARCHAR2	(2)		Describes the attendance types for that the fee should be assessed. These types are institution-defined. For example, full-time, part-time. If the field is left blank, the assessment rate applies to all attendance types. If a value is entered the assessment rate applies only to the nominated attendance type.
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the attendance modes for that the fee should be assessed. These modes are institution-defined. For example, on campus, off campus. If the field is left blank,the assessment rate applies to all attendance modes. If a value is entered the assessment rate applies only to the nominated attendance mode.
ORDER_OF_PRECEDENCE	NUMBER	(9)		Combinations of location, attendance type, and attendance mode across related fee assessment rates can lead to non-mutually exclusive rates being defined. To resolve this situation an order of precedence must be defined. The fee assessment routine will, for each student, select the rate with the lowest order of precedence.
GOVT_HECS_PAYMENT_OPTION	VARCHAR2	(10)		Contains the government contribution payment options for that the fee should be assessed. For example, 10 - DeferredPayment 11 - Upfront With Discount. If the field is left blank, the assessment rate applies to all payment options. If a value is entered the assessment rate applies only to the nominated payment option. - Obsoleted Column.
GOVT_HECS_CNTRBTN_BAND	NUMBER	(38)		Contains the government contribution band value applicable to students liable for differential contribution.- Obsoleted Column.
CHG_RATE	NUMBER		Yes	Describes the per element charge rate EFTSU, per creditpoint, per unit, or flatrate for the fee assessment.
UNIT_CLASS	VARCHAR2	(10)		This column is made obsolete
LOGICAL_DELETE_DT	DATE			Contains the date and time the fee assessment rate record was logically deleted.
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.
RESIDENCY_STATUS_ID	NUMBER	(15)		OBSOLETED. Represents the Residency Status Attribute stored as an ID
COURSE_CD	VARCHAR2	(6)		Code used to identify the program in which the student is enrolled
VERSION_NUMBER	NUMBER	(3)		The version number of the program code
ORG_PARTY_ID	NUMBER	(15)		The organization unit code
CLASS_STANDING	VARCHAR2	(50)		The Class Standing associated with the Fee Assessment record
RESIDENCY_STATUS_CD	VARCHAR2	(30)		Residency status code.
UNIT_SET_CD	VARCHAR2	(10)		Unit Set Code
US_VERSION_NUMBER	NUMBER	(3)		Unit Set Version Number
UNIT_CD	VARCHAR2	(10)		Unit Code
UNIT_VERSION_NUMBER	NUMBER	(3)		Unit Version Number
UNIT_LEVEL	VARCHAR2	(10)		Unit Level
UNIT_TYPE_ID	NUMBER			Unit Program Type Level Identifier
UNIT_MODE	VARCHAR2	(10)		Institution-defined mode of offering a unit.

Query Text

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


SELECT FAR_ID
,      FEE_CAL_TYPE
,      FEE_TYPE
,      RATE_NUMBER
,      FEE_CAT
,      FEE_CI_SEQUENCE_NUMBER
,      LOCATION_CD
,      S_RELATION_TYPE
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
,      ORDER_OF_PRECEDENCE
,      GOVT_HECS_PAYMENT_OPTION
,      GOVT_HECS_CNTRBTN_BAND
,      CHG_RATE
,      UNIT_CLASS
,      LOGICAL_DELETE_DT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      RESIDENCY_STATUS_ID
,      COURSE_CD
,      VERSION_NUMBER
,      ORG_PARTY_ID
,      CLASS_STANDING
,      RESIDENCY_STATUS_CD
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      UNIT_LEVEL
,      UNIT_TYPE_ID
,      UNIT_MODE
FROM IGS.IGS_FI_FEE_AS_RATE;

Dependencies

[top of page]

IGS.IGS_FI_FEE_AS_RATE does not reference any database object

IGS.IGS_FI_FEE_AS_RATE is referenced by following:

APPS: IGS_FI_FEE_AS_RATE