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_F_TYP_CA_INST_ALL

Object Details

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

IGS_FI_F_TYP_CA_INST_ALL describes the periods of fee assessment fee calendar instances applicable to a fee type.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGS_FI_F_TYP_CA_INST_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	FEE_TYPE FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER RETRO_DT_ALIAS RETRO_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER END_DT_ALIAS END_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_CAL_TYPE FEE_CI_SEQUENCE_NUMBER START_DT_ALIAS START_DAI_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RUL_SEQUENCE_NUMBER
IGS_FI_F_TYP_CA_INST_ALL_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	FEE_TYPE_CI_STATUS
IGS_FI_F_TYP_CA_INST_ALL_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACCOUNT_CD

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 can be used within many fee categories, and once allocated to a fee category it is known as a liability. Fee types with a system fee type of hecs and or or a system fee trigger category of institutn operate differently to other fee types in that all required data must be defined at the fee type calendar instance level rather than at fee category level. In doing this, a single system wide definition can be used for fee types such as hecs and general service fee.
FEE_CAL_TYPE	VARCHAR2	(10)	Yes	Code of a fee calendar type that defines the period of time inthat the fee type will operate.
FEE_CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the calendar instance.
FEE_TYPE_CI_STATUS	VARCHAR2	(10)	Yes	Status assigned to a fee type calendar instance to indicate its current level of activity. These statuses are institution-defined and map back onto system fee structure statuses. For example active, inactive, planned.
START_DT_ALIAS	VARCHAR2	(10)	Yes	Code that identifies the date alias for the date aliasinstance at that fee assessment processing begins.
START_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the start fee assessment processingdate alias instance.
END_DT_ALIAS	VARCHAR2	(10)	Yes	Code that identifies the date alias for the date aliasinstance at that fee assessment processing ends.
END_DAI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Uniquely identifies the end fee assessment processing datealias instance.
RETRO_DT_ALIAS	VARCHAR2	(10)		Code that identifies the date alias for a date aliasinstance representing the period until that retrospective feeassessment can be made. The date alias instance can be optionally usedto define a period running past the fee calendar instance processingcycle. If not specified, retrospective fee assessments are notpermitted.
RETRO_DAI_SEQUENCE_NUMBER	NUMBER	(6)		Uniquely identifies the retrospective fee assessmentprocessing date alias instance.
S_CHG_METHOD_TYPE	VARCHAR2	(30)		Describes the methods for determining the number of charge elements for use in a fee assessment calculation.
RUL_SEQUENCE_NUMBER	NUMBER	(6)		Uniquely identifies the rule that will be used in theassessment of fees.
FIN_CAL_TYPE	VARCHAR2	(10)		This column is made obsolete
FIN_CI_SEQUENCE_NUMBER	NUMBER	(6)		This column is made obsolete
ACCOUNT_CD	VARCHAR2	(40)		This column is made obsolete
PAYMENT_HIERARCHY_RANK	NUMBER	(5)		Contains the ranking of the payment to implement the apportionment hierarchy. Partial payments will be allocated firstly to invoice lines of a higher rank. - Obsolete.
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
REQUEST_ID	NUMBER	(15)		Request identifier of last concurrent program to update this record.
PROGRAM_ID	NUMBER	(15)		Program identifier of last concurrent program to update this record.
PROGRAM_APPLICATION_ID	NUMBER	(15)		Application identifier of last concurrent program to update this record.
PROGRAM_UPDATE_DATE	DATE			Last update date of this record by a concurrent program.
SUBACCOUNT_ID	NUMBER	(15)		Obsolete- This field captures the Sub Account Identifier
INITIAL_DEFAULT_AMOUNT	NUMBER			The amount that is used by the Fee Assessment if run in the initial default/initial prior modes.
ACCT_HIER_ID	NUMBER	(15)		Account Hierarchy ID
REC_GL_CCID	NUMBER	(38)		Receivables account FlexField CCID
REV_ACCOUNT_CD	VARCHAR2	(40)		Revenue Account code string
REC_ACCOUNT_CD	VARCHAR2	(40)		Receivables Account code string
RET_GL_CCID	NUMBER	(38)		Retention Account Flexfield CCID
RET_ACCOUNT_CD	VARCHAR2	(40)		Retention Account Code String
RETENTION_LEVEL_CODE	VARCHAR2	(30)		Retention Level
COMPLETE_RET_FLAG	VARCHAR2	(1)		Complete Withdrawal Retention Rule Indicator
NONZERO_BILLABLE_CP_FLAG	VARCHAR2	(1)		Flag to identify if fee needs to be assessed for any student unit attempt with zero billable credit point.
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.
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_TYPE
,      FEE_CAL_TYPE
,      FEE_CI_SEQUENCE_NUMBER
,      FEE_TYPE_CI_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
,      FIN_CAL_TYPE
,      FIN_CI_SEQUENCE_NUMBER
,      ACCOUNT_CD
,      PAYMENT_HIERARCHY_RANK
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      SUBACCOUNT_ID
,      INITIAL_DEFAULT_AMOUNT
,      ACCT_HIER_ID
,      REC_GL_CCID
,      REV_ACCOUNT_CD
,      REC_ACCOUNT_CD
,      RET_GL_CCID
,      RET_ACCOUNT_CD
,      RETENTION_LEVEL_CODE
,      COMPLETE_RET_FLAG
,      NONZERO_BILLABLE_CP_FLAG
,      SCOPE_RUL_SEQUENCE_NUM
,      ELM_RNG_ORDER_NAME
,      MAX_CHG_ELEMENTS
FROM IGS.IGS_FI_F_TYP_CA_INST_ALL;

Dependencies

[top of page]

IGS.IGS_FI_F_TYP_CA_INST_ALL does not reference any database object

IGS.IGS_FI_F_TYP_CA_INST_ALL is referenced by following:

APPS: IGS_FI_F_TYP_CA_INST_ALL