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_RT_H_ALL

Object Details

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

This entity describes the history of changes to a fee assessment rate.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_FEE_AS_RT_H_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER S_RELATION_TYPE RATE_NUMBER HIST_START_DT
IGS_FI_FEE_AS_RT_H_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAT FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER FEE_TYPE

Columns

Name	Datatype	Length	Mandatory	Comments
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.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar type with calendar category fee.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies calendar instance
S_RELATION_TYPE	VARCHAR2	(10)	Yes	Describes the system relation type to that the fee assessment rate belongs.
RATE_NUMBER	NUMBER	(9)	Yes	Uniquely identifies fee assessment rate
HIST_START_DT	DATE		Yes	Effective start date and time of the history record.
HIST_END_DT	DATE		Yes	Effective end date and time of the history record.
HIST_WHO	NUMBER	(15)	Yes	Updated by person at the time of the history.
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.
LOCATION_CD	VARCHAR2	(10)		The location name or code. The location represents a geographical location and might be used to indicate where programs and units can be offered.
ATTENDANCE_TYPE	VARCHAR2	(2)		Describes the attendance types for a program. For example, full-time, part-time.
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the attendance modes in that theprogram is offered. These modes are user-defined. For example, on campus, off campus.
ORDER_OF_PRECEDENCE	NUMBER	(9)		Describes the order of precedence applied to the fee assessment rate.
GOVT_HECS_PAYMENT_OPTION	VARCHAR2	(10)		Describes the possible types of contribution payment options. - Obsoleted Column.
GOVT_HECS_CNTRBTN_BAND	NUMBER	(38)		Contains the government contribution band value. - Obsoleted Column.
CHG_RATE	NUMBER			Describes the per element charge rate for the fee assessment.
UNIT_CLASS	VARCHAR2	(10)		Represents the class the unit taught.
RESIDENCY_STATUS_ID	NUMBER	(15)		OBSOLETED. This 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)		Class Standing
ORG_ID	NUMBER	(15)		Operating unit identifier
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
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 FEE_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      S_RELATION_TYPE
,      RATE_NUMBER
,      HIST_START_DT
,      HIST_END_DT
,      HIST_WHO
,      FEE_CAT
,      LOCATION_CD
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
,      ORDER_OF_PRECEDENCE
,      GOVT_HECS_PAYMENT_OPTION
,      GOVT_HECS_CNTRBTN_BAND
,      CHG_RATE
,      UNIT_CLASS
,      RESIDENCY_STATUS_ID
,      COURSE_CD
,      VERSION_NUMBER
,      ORG_PARTY_ID
,      CLASS_STANDING
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      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_RT_H_ALL;

Dependencies

[top of page]

IGS.IGS_FI_FEE_AS_RT_H_ALL does not reference any database object

IGS.IGS_FI_FEE_AS_RT_H_ALL is referenced by following:

APPS: IGS_FI_FEE_AS_RT_H_ALL