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_ITEMS

Object Details

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

Stores an itemized list of assessment items that have contributed to the students assessment.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_FEE_AS_ITEMS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_ASS_ITEM_ID
IGS_FI_FEE_AS_ITEMS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TRANSACTION_ID PERSON_ID FEE_TYPE FEE_CAT FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER COURSE_CD CRS_VERSION_NUMBER LOCATION_CD UOO_ID ORG_UNIT_CD
IGS_FI_FEE_AS_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
FEE_ASS_ITEM_ID	NUMBER	(15)	Yes	Unique system generated fee assessment Item ID
PERSON_ID	NUMBER	(15)	Yes	Person Identifier and foreign key to HZ_PARTIES. This is a sequence generated value.
TRANSACTION_ID	NUMBER	(10)	Yes	Assessment transaction identifier
STATUS	VARCHAR2	(30)	Yes	Denotes the status of the fee assessment Item Like E, O for ENROLLED , OVERIDDEN.
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_CAT	VARCHAR2	(10)		Fee categories are created to identify distinct fee assessment groups. Fee categories might contain one or more fee types.
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	Uniquely identifies the calendar instance.
RUL_SEQUENCE_NUMBER	NUMBER	(10)		Rule sequence number to identify the rule for amount calculation.
S_CHG_METHOD_TYPE	VARCHAR2	(30)	Yes	Charge method type for this assessment item
DESCRIPTION	VARCHAR2	(150)		Denotes charge description
CHG_ELEMENTS	NUMBER	(7)		Number of charge elements for the fee assessment items.
AMOUNT	NUMBER			Charge amount for this fee assessment item
FEE_EFFECTIVE_DT	DATE			Effective date for this assessment item
COURSE_CD	VARCHAR2	(6)		Unique identifier for a study program
CRS_VERSION_NUMBER	NUMBER	(3)		Program version number
COURSE_ATTEMPT_STATUS	VARCHAR2	(30)		Program attempt status for the fee assessment
ATTENDANCE_MODE	VARCHAR2	(2)		Describes the mode of attendance by that a student undertakes a program.
ATTENDANCE_TYPE	VARCHAR2	(2)		Describes whether or not a student is classified as being full-time or part-time, based on their study load in the reference year.
UNIT_CD	VARCHAR2	(10)		Unique identifier of a unit - obsolete column
UNIT_VERSION_NUMBER	NUMBER	(3)		Is used to uniquely identify each version of a unit set. - obsolete column
UNIT_ATTEMPT_STATUS	VARCHAR2	(30)		Is used to identify status of a unit attempt.
UNIT_LOCATION_CD	VARCHAR2	(10)		Denotes the code of a physical location owned or used by an institution -OBSOLETED.
CAL_TYPE	VARCHAR2	(10)		Denotes the unit load calendar type - obsolete column
CI_SEQUENCE_NUMBER	NUMBER	(6)		Denotes the unit load calendar instance - obsolete column
EFTSU	NUMBER	(7)		Equivalent full time student unit, represents the student load for a unit or part of a unit expressed as a proportion of the workload for a standard annual program for students undertaking a full year of study in a particular year of a particular program.
CREDIT_POINTS	NUMBER	(6)		Unit credit points for the unit
LOGICAL_DELETE_DATE	DATE			The date the fee assessment item was logically deleted.
UNIT_CLASS	VARCHAR2	(10)		Institution-defined code that identifies a unit class.
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
INVOICE_ID	NUMBER	(15)		Invoice Identifier to uniquely identify the created invoice.
ORG_UNIT_CD	VARCHAR2	(30)		Unique identification number for this party
CLASS_STANDING	VARCHAR2	(50)		Class Standing
RESIDENCY_STATUS_ID	NUMBER	(15)		OBSOLETED. This represents the Residency Status attribute stored as an ID
LOCATION_CD	VARCHAR2	(10)		The location to which the created charge belongs
UOO_ID	NUMBER	(7)		The unit offering option to which the student enrolled.
CHG_RATE	NUMBER			The charge rate for the assessment
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_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.
SCOPE_RUL_SEQUENCE_NUM	NUMBER	(6)		Rule Sequence Number which defines the Fee Assessment Scope
ELM_RNG_ORDER_NAME	VARCHAR2	(30)		Element Range Order Name which defines the order in which fee assessment computes fees.
MAX_CHG_ELEMENTS	NUMBER	(7)		The maximum number of charge elements that will be considered for charge amount calculation during Fee Assessment

Query Text

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


SELECT FEE_ASS_ITEM_ID
,      PERSON_ID
,      TRANSACTION_ID
,      STATUS
,      FEE_TYPE
,      FEE_CAT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      RUL_SEQUENCE_NUMBER
,      S_CHG_METHOD_TYPE
,      DESCRIPTION
,      CHG_ELEMENTS
,      AMOUNT
,      FEE_EFFECTIVE_DT
,      COURSE_CD
,      CRS_VERSION_NUMBER
,      COURSE_ATTEMPT_STATUS
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      UNIT_CD
,      UNIT_VERSION_NUMBER
,      UNIT_ATTEMPT_STATUS
,      UNIT_LOCATION_CD
,      CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      EFTSU
,      CREDIT_POINTS
,      LOGICAL_DELETE_DATE
,      UNIT_CLASS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVOICE_ID
,      ORG_UNIT_CD
,      CLASS_STANDING
,      RESIDENCY_STATUS_ID
,      LOCATION_CD
,      UOO_ID
,      CHG_RATE
,      RESIDENCY_STATUS_CD
,      UNIT_SET_CD
,      US_VERSION_NUMBER
,      UNIT_LEVEL
,      UNIT_TYPE_ID
,      UNIT_MODE
,      SCOPE_RUL_SEQUENCE_NUM
,      ELM_RNG_ORDER_NAME
,      MAX_CHG_ELEMENTS
FROM IGS.IGS_FI_FEE_AS_ITEMS;

Dependencies

[top of page]

IGS.IGS_FI_FEE_AS_ITEMS does not reference any database object

IGS.IGS_FI_FEE_AS_ITEMS is referenced by following:

APPS: IGS_FI_FEE_AS_ITEMS