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

VIEW: APPS.IGS_FI_ELM_RNG_V

Object Details
Object Name: IGS_FI_ELM_RNG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_FI_ELM_RNG_V
Subobject Name:
Status: VALID

View Type

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


This view determines the elements range rate specific to a given fee category fee liability.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Identifier
ERR_ID NUMBER (9) Yes Defines the unique system generated element range rate ID.
FEE_TYPE VARCHAR2 (10) Yes Describes the fee types used for the purpose of applying fees and charges. A fee type may be used with many fee categories, permitting a single system wide fee definition to be used.
FEE_CAL_TYPE VARCHAR2 (10) Yes Calendar type with calendar category FEE.
FEE_CI_SEQUENCE_NUMBER NUMBER (6) Yes Uniquely identifies the calendar instance
S_RELATION_TYPE VARCHAR2 (10) Yes The system relation type to which the elements range belongs.
RANGE_NUMBER NUMBER (6) Yes Number that uniquely identifies the elements range rate record.
RATE_NUMBER NUMBER (9) Yes 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.
CREATE_DT DATE
Yes Contains the date and time the elements range rate was created.
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.
LOGICAL_DELETE_DT DATE

Contains the date and time the elements range rate record was logically deleted.
DSP_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.
DSP_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.
DSP_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.
DSP_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.
DSP_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.
DSP_GOVT_HECS_CNTRBTN_BAND NUMBER (38)
Contains the government contribution band value applicable to students liable for differential contribution. - Obsoleted Column.
DSP_CHG_RATE NUMBER
Yes Describes the per element charge rate EFTSU, per creditpoint, per unit, or flatrate for the fee assessment.
DSP_RESIDENCY_STATUS_CD VARCHAR2 (30)
This represents the Residency Status attribute stored as an identifier
DSP_RESIDENCY_STATUS VARCHAR2 (80)
This represents the Residency Status attribute
DSP_COURSE_CD VARCHAR2 (6)
Code used to identify the identify the program in that the student has enrolled
DSP_VERSION_NUMBER NUMBER (3)
Version Number of the Program
DSP_ORG_UNIT_CD VARCHAR2 (30)
The Organization Unit Code
DSP_CLASS_STANDING VARCHAR2 (50)
The Class Standing Attribute
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
UNIT_SET_CD VARCHAR2 (10)
Unit Set Code
US_VERSION_NUMBER NUMBER (3)
Unit Set Version Number
UNIT_TYPE_ID NUMBER

Unit Program Type Level Identifier
LEVEL_CODE VARCHAR2 (10)
Unit Program Type Level Code
UNIT_CLASS VARCHAR2 (10)
Institution-defined code that identifies a unit class.
UNIT_MODE VARCHAR2 (10)
Institution-defined mode of offering a unit.
UNIT_CD VARCHAR2 (10)
Unit Code
UNIT_VERSION_NUMBER NUMBER (3)
Unit Version Number
UNIT_LEVEL VARCHAR2 (10)
Unit Level
Query Text

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


SELECT ROW_ID
,      ERR_ID
,      FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      RANGE_NUMBER
,      RATE_NUMBER
,      CREATE_DT
,      FEE_CAT
,      LOGICAL_DELETE_DT
,      DSP_LOCATION_CD
,      DSP_ATTENDANCE_TYPE
,      DSP_ATTENDANCE_MODE
,      DSP_ORDER_OF_PRECEDENCE
,      DSP_GOVT_HECS_PAYMENT_OPTION
,      DSP_GOVT_HECS_CNTRBTN_BAND
,      DSP_CHG_RATE
,      DSP_RESIDENCY_STATUS_CD
,      DSP_RESIDENCY_STATUS
,      DSP_COURSE_CD
,      DSP_VERSION_NUMBER
,      DSP_ORG_UNIT_CD
,      DSP_CLASS_STANDING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_TYPE_ID
,      LEVEL_CODE
,      UNIT_CLASS
,      UNIT_MODE
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      UNIT_LEVEL
FROM APPS.IGS_FI_ELM_RNG_V;

Dependencies

[top of page]

APPS.IGS_FI_ELM_RNG_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_FI_ELM_RANGE_RT
SynonymIGS_FI_FEE_AS_RATE
ViewIGS_LOOKUP_VALUES
SynonymIGS_PS_UNIT_TYPE_LVL

APPS.IGS_FI_ELM_RNG_V is not referenced by any database object