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_F_CAT_FEE_LBL_SCA_RT_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PERSON_ID	NUMBER	(15)	Yes	This field describes the ID code that uniquely identifies a person.
COURSE_CD	VARCHAR2	(6)	Yes	The unique identifier for a course of study, (DETYA element reference number 307).
VERSION_NUMBER	NUMBER	(3)	Yes	The version number of the course. There can only be one version of a course with a system status of ACTIVE and an unset EXPIRY DATE.
CAL_TYPE	VARCHAR2	(10)	Yes	The code of a FEE calendar type which defines the period of time in which the fee type operates.
LOCATION_CD	VARCHAR2	(10)	Yes	This field contains the course location at which the contract applies. If the field is left blank, the contract rate applies to all locations. If a value is entered the contract applies only to the nominated location.
ATTENDANCE_MODE	VARCHAR2	(2)	Yes	This field contains the attendance mode to which the contract applies. Attendance modes are institution-defined. Examples: On campus, Off campus DETYA element reference 329. If the field is left blank, the contract rate applies to all attendance modes. If a value is entered the contract rate applies only to the nominated mode.
ATTENDANCE_TYPE	VARCHAR2	(2)	Yes	This field contains the attendance type to which the contract applies. Attendance types are institution-defined. Examples: Full-time, Part-time. DETYA element reference 330. If the field is left blank, the contract rate applies to all attendance types. If a value is entered the contract rate applies only to the nominated attendance type.
HECS_PAYMENT_OPTION	VARCHAR2	(4000)		This field describes the possible HECS payment options. Examples: DEFERRED, UPFRONT, EXEMPT.
FEE_ASS_IND	VARCHAR2	(1)		An indicator which specifies whether or not student course attempts with the context status are considered by the fee assessment routine. Setting the checkbox (ticked) includes the course status.
FEE_CAT	VARCHAR2	(10)		The fee category applicable to the student's course attempt. Fee categories are used to define the set of fees and charges applicable to a student studying a particular course.
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	This field uniquely identifies the calendar instance.
FEE_TYPE	VARCHAR2	(10)	Yes	The fee types used for the purpose of applying fees and charges. A fee type may be used with many fee categories. Once a fee type is allocated to a fee category it is known as a liability. A fee type which is a liability in more than one fee category may have different attributes in each of these categories.
S_FEE_TYPE	VARCHAR2	(10)	Yes	This field describes the system recognised fee types: HECS, TUITION and OTHER. The system type determines characteristics of the fee and determines those which are reported to the Commonwealth Government (HECS, TUITION) and those which are not (OTHER).
S_FEE_TRIGGER_CAT	VARCHAR2	(10)	Yes	This field describes the system defined fee trigger category applicable to the fee type. It is used to restrict the fee triggers that may be defined for a fee category fee liability of the fee type. Examples of these categories are COURSE and INSTITUTN.
FEE_LIABILITY_STATUS	VARCHAR2	(10)	Yes
START_DT	DATE			The date from which the calendar instance becomes effective. For example, the calendar instance Semester 1 1999 may commence on 1/3/1999.
END_DT	DATE			The date from which the calendar instance is no longer effective. For example, the calendar instance Semester 1 1999 may end on 11/6/1999.
RETRO_DT	DATE			The code which identifies the date alias for a date alias instance representing the period until which retrospective fee assessment can be made. The date alias instance can be optionally used to define a period running past the fee calendar instance processing cycle. If not specified, retrospective fee assessments are not permitted.
S_CHG_METHOD_TYPE	VARCHAR2	(30)		This field describes the methods for determining the number of 'charge elements' for use in a fee assessment calculation. Examples: Flat Rate, Per EFTSU (load), Per Unit (student unit attempts), Per Credit Point (enrolled). Note: Per EFTSU, Per Unit and Per Credit Point only apply to enrolment fee classifications.
RUL_SEQUENCE_NUMBER	NUMBER			This field uniquely identifies the rule which will be used in the assessment of fees.
CHG_RATE	NUMBER			This field contains the monetary value of the contract fee assessment rate. The rate defined is based on the charge method for the fee type. For example; if the charge method is PERUNIT and the charge rate is $800, the contract rate will be $800 for each unit. If the student incurs load for four units in the fee assessment period the contract fee assessment rate will be $3200.
CURRENCY_CD	VARCHAR2	(15)		This field contains the currency codes in which fee assessments and payments may be made.
CHG_RATE_LOCATION_CD	VARCHAR2	(10)		This field describes the course 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 only to the nominated location.
CHG_RATE_ATTENDANCE_TYPE	VARCHAR2	(2)		This field describes the attendance types for which the fee should be assessed. These types are institution-defined. Examples: Full-time, Part-time. DETYA element reference 330. 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.
CHG_RATE_ATTENDANCE_MODE	VARCHAR2	(2)		This field describes the attendance modes for which the fee should be assessed. These modes are institution-defined. Examples: On campus, Off campus. DETYA element reference 329. 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.
CONTRACT_START_DT	DATE			This field contains the date from which the contract fee assessment rate is effective.
CONTRACT_END_DT	DATE			This field contains the date at which the contract fee assessment rate is no longer effective.
CONTRACT_RATE	NUMBER			This field describes the monetary value of the contract fee assessment rate.
CONTRACT_LOCATION_CD	VARCHAR2	(10)		This field contains the course location at which the contract applies. If the field is left blank, the contract rate applies to all locations. If a value is entered the contract rate applies only to the nominated location.
CONTRACT_ATTENDANCE_TYPE	VARCHAR2	(2)		This field describes the attendance types to which the contract applies. These types are user-defined. Examples: Full-time, Part-time. DETYA element reference 330. If the field is left blank, the contract rate applies to all attendance types. If a value is entered the contract rate applies only to the nominated attendance type.
CONTRACT_ATTENDANCE_MODE	VARCHAR2	(2)		This field describes the attendance mode to which the contract applies. These modes are user-defined. Examples: On campus, Off campus. DETYA element reference 329. If the field is left blank, the contract rate applies to all attendance modes. If a value is entered the contract rate applies only to the nominated attendance mode.
LOWER_NRML_RATE_OVRD_IND	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)

Query Text

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


SELECT PERSON_ID
,      COURSE_CD
,      VERSION_NUMBER
,      CAL_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      HECS_PAYMENT_OPTION
,      FEE_ASS_IND
,      FEE_CAT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_TYPE
,      S_FEE_TYPE
,      S_FEE_TRIGGER_CAT
,      FEE_LIABILITY_STATUS
,      START_DT
,      END_DT
,      RETRO_DT
,      S_CHG_METHOD_TYPE
,      RUL_SEQUENCE_NUMBER
,      CHG_RATE
,      CURRENCY_CD
,      CHG_RATE_LOCATION_CD
,      CHG_RATE_ATTENDANCE_TYPE
,      CHG_RATE_ATTENDANCE_MODE
,      CONTRACT_START_DT
,      CONTRACT_END_DT
,      CONTRACT_RATE
,      CONTRACT_LOCATION_CD
,      CONTRACT_ATTENDANCE_TYPE
,      CONTRACT_ATTENDANCE_MODE
,      LOWER_NRML_RATE_OVRD_IND
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_FI_F_CAT_FEE_LBL_SCA_RT_V;

Dependencies

[top of page]

APPS.IGS_FI_F_CAT_FEE_LBL_SCA_RT_V references the following:

APPS: IGS_CA_GEN_001 - show dependent code; IGS_CA_GEN_002 - show dependent code; IGS_EN_GEN_002 - show dependent code; IGS_FI_FEE_AS_RATE_F_TYPE_V; IGS_FI_FEE_AS_RT; IGS_FI_F_CAT_FEE_LBL_SCA_V; IGS_FI_GEN_001 - show dependent code

APPS.IGS_FI_F_CAT_FEE_LBL_SCA_RT_V is referenced by following:

APPS: IGS_FI_GEN_004 - show dependent code