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]

VIEW: APPS.IGS_FI_FEE_AS_RATE_F_TYPE_V

Object Details

Object Name:	IGS_FI_FEE_AS_RATE_F_TYPE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_FEE_AS_RATE_F_TYPE_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

No longer used

[View Source]

Columns

Name	Datatype	Length	Comments
FEE_TYPE	VARCHAR2	(10)	Describes the fee types used for the purpose of applying fees and charges. A fee type can be used with many fee categories, permitting a single system wide fee definition to be used. For example, hecs, guild.
FEE_CAL_TYPE	VARCHAR2	(10)	Calendar type with calendar category of Fee used in the assessment of student fees
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Uniquely identifies the calendar instance
S_RELATION_TYPE	VARCHAR2	(10)	Describes the system relation type that the fee assessment rate belongs
FEE_CAT	VARCHAR2	(10)	Fee categories are created to identify distinct fee assessment groups. Fee categories can contain one or more fee types, these fee types are. The fee category assigned to a student program attempt determines the fees that are potentially liable.
RATE_NUMBER	NUMBER	(9)	Uniquely identifies the fee assessment rate
LOCATION_CD	VARCHAR2	(10)	Describes the program locations for which 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 onlyto the nominated location.
ATTENDANCE_TYPE	VARCHAR2	(2)	The code of an institution-defined attendance type. An attendance type identifies if a student is classified as part-time or full-time in the program, based on their study load in the reference year. Each attendance type must be mapped to a government attendance type, DETYA element 330.
ATTENDANCE_MODE	VARCHAR2	(2)	The code of an institution-defined attendance mode. An attendance mode identifies the mode of attendance in which a student undertakes a program. Each attendance mode must be mapped to agovernment attendance type, DETYA element 329. For example, on campus, off camus.
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 ofprecedence 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)	A government-defined contribution payment option code. These codes are used for reporting student contribution details to government. - Obsoleted Column.
GOVT_HECS_CNTRBTN_BAND	NUMBER	(38)	Contains the government contribution band. Contribution bands are mapped to government discipline groups and are relevant in calculating the contribution liability applicable to a unit of study. - Obsoleted Column.
CHG_RATE	NUMBER		Describes the per element charge rate used for the fee assessment transaction
UNIT_CLASS	VARCHAR2	(10)	A unit class describes the time and mode of availability of a class. Unit classes are assigned to unit offering options to describe the way the class will be presented to students.
CURRENCY_CD	VARCHAR2	(15)	Describes the currency code applicable to the transaction amount
CREATED_BY	NUMBER	(15)	Standard Who column
CREATION_DATE	DATE		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Standard Who column
LAST_UPDATE_DATE	DATE		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard Who column
RESIDENCY_STATUS_CD	VARCHAR2	(30)	Residency status code
COURSE_CD	VARCHAR2	(6)	Code used to identify the Program in that the Student has enrolled
VERSION_NUMBER	NUMBER	(3)	The Version Number of the Program Code
ORG_PARTY_ID	NUMBER	(15)	The ID of the Organisation Unit Code
ORG_UNIT_CD	VARCHAR2	(30)	The Organisation Unit Code
CLASS_STANDING	VARCHAR2	(50)	The Class Standing Attribute
UNIT_SET_CD	VARCHAR2	(10)	Unit Set Code
US_VERSION_NUMBER	NUMBER	(3)	Unit Set Version Number

Query Text

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


SELECT FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      FEE_CAT
,      RATE_NUMBER
,      LOCATION_CD
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
,      ORDER_OF_PRECEDENCE
,      GOVT_HECS_PAYMENT_OPTION
,      GOVT_HECS_CNTRBTN_BAND
,      CHG_RATE
,      UNIT_CLASS
,      CURRENCY_CD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      RESIDENCY_STATUS_CD
,      COURSE_CD
,      VERSION_NUMBER
,      ORG_PARTY_ID
,      ORG_UNIT_CD
,      CLASS_STANDING
,      UNIT_SET_CD
,      US_VERSION_NUMBER
FROM APPS.IGS_FI_FEE_AS_RATE_F_TYPE_V;

Dependencies

[top of page]

APPS.IGS_FI_FEE_AS_RATE_F_TYPE_V references the following:

APPS: HZ_PARTIES; IGS_FI_FEE_AS_RATE; IGS_FI_F_CAT_FEE_LBL; IGS_FI_GEN_001 - show dependent code

APPS.IGS_FI_FEE_AS_RATE_F_TYPE_V is referenced by following:

APPS: IGS_FI_ELM_RANGE_RT_V; IGS_FI_F_CAT_FEE_LBL_SCA_RT_V