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_V

Object Details

Object Name:	IGS_FI_F_CAT_FEE_LBL_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGS.IGS_FI_F_CAT_FEE_LBL_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
FEE_CAT	VARCHAR2	(10)	Yes	This field 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.
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	fee_cat_fee_liability.fee_type
FEE_LIABILITY_STATUS	VARCHAR2	(10)	Yes	This field describes the status assigned to a fee category fee liability to indicate its current level of activity. These statuses are institution-definable and map back onto system fee liability statuses which define associated functionality. Examples: ACTIVE, INACTIVE, PLANNED.
START_DT_ALIAS	VARCHAR2	(10)		The code which identifies the date alias for the date alias instance when fee assessment processing starts.
START_DAI_SEQUENCE_NUMBER	NUMBER			This field uniquely identifies the date alias instance.
END_DT_ALIAS	VARCHAR2	(10)		The code of the date alias used to control the end of automatic fee assessment processing.
END_DAI_SEQUENCE_NUMBER	NUMBER			A system generated sequence number used to uniquely identify the end of fee assessment processing date alias instance.
RETRO_DT_ALIAS	VARCHAR2	(10)		fee_type_cal_instance.retro_dt_alias
RETRO_DAI_SEQUENCE_NUMBER	NUMBER			fee_type_cal_instance.retro_dai_sequence_number
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. The options are: 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.
CURRENCY_CD	VARCHAR2	(15)		The currency code of the fee category fee liability.
PAYMENT_HIERARCHY_RANK	NUMBER			fee_cat_fee_liability.payment_hierarchy_rank - Obsoleted column
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)
SCOPE_RUL_SEQUENCE_NUM	NUMBER	(6)		Rule Sequence Number which defines the Fee Assessment Scope for a Fee Type Calendar Instance
ELM_RNG_ORDER_NAME	VARCHAR2	(30)		Element Range Order Name which defines the order in which fee assessment computes fees.
WAIVER_CALC_FLAG	VARCHAR2	(1)		Flag to identify that the Fee Type is marked for waiver amount calculation
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_CAT
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_TYPE
,      FEE_LIABILITY_STATUS
,      START_DT_ALIAS
,      START_DAI_SEQUENCE_NUMBER
,      END_DT_ALIAS
,      END_DAI_SEQUENCE_NUMBER
,      RETRO_DT_ALIAS
,      RETRO_DAI_SEQUENCE_NUMBER
,      S_CHG_METHOD_TYPE
,      RUL_SEQUENCE_NUMBER
,      CURRENCY_CD
,      PAYMENT_HIERARCHY_RANK
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      SCOPE_RUL_SEQUENCE_NUM
,      ELM_RNG_ORDER_NAME
,      WAIVER_CALC_FLAG
,      MAX_CHG_ELEMENTS
FROM APPS.IGS_FI_F_CAT_FEE_LBL_V;

Dependencies

[top of page]

APPS.IGS_FI_F_CAT_FEE_LBL_V references the following:

APPS: IGS_FI_F_CAT_FEE_LBL; IGS_FI_F_TYP_CA_INST; IGS_FI_GEN_001 - show dependent code

APPS.IGS_FI_F_CAT_FEE_LBL_V is referenced by following:

APPS: IGS_FI_CNG_FCAT_LBL_SCA_PR_V; IGS_FI_F_CAT_FEE_LBL_SCA_PRR_V; IGS_FI_F_CAT_FEE_LBL_SCA_V; IGS_FI_GEN_001 - show dependent code; IGS_FI_GEN_004 - show dependent code; IGS_FI_GEN_005 - show dependent code; IGS_FI_PRC_FEE_ASS - show dependent code; IGS_FI_VAL_FAS - show dependent code