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

VIEW: APPS.IGS_FI_ELM_RANGE_RT_V

Object Details
Object Name: IGS_FI_ELM_RANGE_RT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_ELM_RANGE_RT_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 Mandatory 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, contribution, guild.
FEE_CAL_TYPE VARCHAR2 (10)
Calendar type with calendar category fee
FEE_CI_SEQUENCE_NUMBER NUMBER (6)
Uniquely identifies the calendar instance
S_RELATION_TYPE VARCHAR2 (10)
Describes the system relation type to that the elements range belongs
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.
LOWER_RANGE NUMBER (7)
Describes the lower range value in a fee assessment element range record. The value is inclusive and can be left unspecified if an upper range value is recorded. Element range records cannot overlap.
UPPER_RANGE NUMBER (7)
Describes the upper range value in a fee assessment element range record. The value is inclusive and can be left unspecified if a lower range value is recorded. Element range records cannot overlap.
OVERRIDE_CHG_METHOD_TYPE VARCHAR2 (30)
This is an optional field. If left blank, the element range record defaults to the charge method entered at either the fee type calendar instance level, or the fee category instance level, as appropriate. Alternatively, a flat rate override charge method can be specified for the element range record.
RANGE_NUMBER NUMBER (6)
A number that uniquely identifies the element range record
RATE_NUMBER NUMBER (9)
The fee assessment or charge rate for the elements rate range record. The fee assessment routine considers the charge method, the number of charge elements and the charge rate.
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.
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.
ATTENDANCE_MODE VARCHAR2 (2)
The code of an institution-defined attendance mode. An attendance mode identifies the mode of attendance in that a student undertakes a program. Each attendance mode must be mapped to a government attendance type. For example, are on campus, off campus.
RESIDENCY_STATUS_CD VARCHAR2 (30)
Residency Status Code
COURSE_CD VARCHAR2 (6)
Course Code
VERSION_NUMBER NUMBER (3)
Version Number
ORG_UNIT_CD VARCHAR2 (30)
Organisation Unit Code
CLASS_STANDING VARCHAR2 (50)
Class Standing
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)
A defined contribution payment option code. These codes are used for reporting student contribution details - 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
CURRENCY_CD VARCHAR2 (15)
Contains the derived currency codes in that fee assessments and payments that can be made
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
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
,      LOWER_RANGE
,      UPPER_RANGE
,      OVERRIDE_CHG_METHOD_TYPE
,      RANGE_NUMBER
,      RATE_NUMBER
,      LOCATION_CD
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
,      RESIDENCY_STATUS_CD
,      COURSE_CD
,      VERSION_NUMBER
,      ORG_UNIT_CD
,      CLASS_STANDING
,      ORDER_OF_PRECEDENCE
,      GOVT_HECS_PAYMENT_OPTION
,      GOVT_HECS_CNTRBTN_BAND
,      CHG_RATE
,      CURRENCY_CD
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UNIT_SET_CD
,      US_VERSION_NUMBER
FROM APPS.IGS_FI_ELM_RANGE_RT_V;

Dependencies

[top of page]

APPS.IGS_FI_ELM_RANGE_RT_V references the following:

SchemaAPPS
SynonymIGS_FI_ELM_RANGE
SynonymIGS_FI_ELM_RANGE_RT
ViewIGS_FI_FEE_AS_RATE_F_TYPE_V
ViewIGS_FI_F_CAT_FEE_LBL
PL/SQL PackageIGS_FI_GEN_001 - show dependent code

APPS.IGS_FI_ELM_RANGE_RT_V is not referenced by any database object