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: ViewIGS.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:

SchemaAPPS
ViewIGS_FI_F_CAT_FEE_LBL
ViewIGS_FI_F_TYP_CA_INST
PL/SQL PackageIGS_FI_GEN_001 - show dependent code
APPS.IGS_FI_F_CAT_FEE_LBL_V is referenced by following:

SchemaAPPS
ViewIGS_FI_CNG_FCAT_LBL_SCA_PR_V
ViewIGS_FI_F_CAT_FEE_LBL_SCA_PRR_V
ViewIGS_FI_F_CAT_FEE_LBL_SCA_V
Package BodyIGS_FI_GEN_001 - show dependent code
Package BodyIGS_FI_GEN_004 - show dependent code
Package BodyIGS_FI_GEN_005 - show dependent code
Package BodyIGS_FI_PRC_FEE_ASS - show dependent code
Package BodyIGS_FI_VAL_FAS - show dependent code