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: IGF.IGF_FC_EFC_FRM_A

Object Details

Object Name:	IGF_FC_EFC_FRM_A
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_FC_EFC_FRM_A
Subobject Name:
Status:	VALID

Multiplication Factor - Formula A Table

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_FC_EFC_FRM_A_PK	NORMAL	UNIQUE	APPS_TS_SEED	S_AWARD_YEAR

Columns

Name	Datatype	Length	Mandatory	Comments
S_AWARD_YEAR	VARCHAR2	(30)	Yes	System Award Year
EMPL_EXP_ALLOWANCE_RATE1	NUMBER			Employment Expense allowance for 1 parent in percentage
EMPL_EXP_ALLOWANCE_AMOUNT1	NUMBER			Employment Expense allowance amount for 1 parent
EMPL_EXP_ALLOWANCE_RATE2	NUMBER			Employment Expense allowance for 2 parents in percentage
EMPL_EXP_ALLOWANCE_AMOUNT2	NUMBER			Employment Expense allowance amount for 2 parent
PARENT_ASSET_CONV_RATE	NUMBER			Parent's Asset Conversion Rate
STUD_INC_PROT_ALLOWANCE	NUMBER			Student's Income Protection Allowance
STUD_AVAILABLE_INCOME	NUMBER			Assessment of Student's Available Income
STUD_ASSET_ASSESSMENT_RATE	NUMBER			Students Asset Assessment Rate
INCOME_PROTECTION_DIFF_9	NUMBER			Income Protection Differential for other than 9 months.
A5_DEFAULT_AGE	NUMBER			Default age of older parent
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

Query Text

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


SELECT S_AWARD_YEAR
,      EMPL_EXP_ALLOWANCE_RATE1
,      EMPL_EXP_ALLOWANCE_AMOUNT1
,      EMPL_EXP_ALLOWANCE_RATE2
,      EMPL_EXP_ALLOWANCE_AMOUNT2
,      PARENT_ASSET_CONV_RATE
,      STUD_INC_PROT_ALLOWANCE
,      STUD_AVAILABLE_INCOME
,      STUD_ASSET_ASSESSMENT_RATE
,      INCOME_PROTECTION_DIFF_9
,      A5_DEFAULT_AGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_FC_EFC_FRM_A;

Dependencies

[top of page]

IGF.IGF_FC_EFC_FRM_A does not reference any database object

IGF.IGF_FC_EFC_FRM_A is referenced by following:

APPS: IGF_FC_EFC_FRM_A