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_AP_EFC_FRML_A

Object Details

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

OBSOLETE

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AP_EFC_FRML_A_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	CI_CAL_TYPE CI_SEQUENCE_NUMBER METHOD_CODE

Columns

Name	Datatype	Length	Mandatory	Comments
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Calendar Type Code
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Calendar Instance sequence number
METHOD_CODE	VARCHAR2	(30)	Yes	Comes from the values setup in the Need Analysis Methodology Form
EMPL_EXP_PERCT_1	NUMBER	(6)		Stores the % of lower income value for employment expense allowance for one parent family
EMPL_EXP_ALLOW_1	NUMBER	(12)		Stores the employment expense dollar amount allowance for one parent family
EMPL_EXP_PERCT_2	NUMBER	(6)		Stores the % of lower income value for employment expense allowance for two parent family
EMPL_EXP_ALLOW_2	NUMBER	(12)		Stores the employment expense dollar amount allowance for two parent family
PARENT_ASST_CONV_RATE	NUMBER	(6)		Parent asset conversion rate
STUD_INC_PRCT_ALLOW	NUMBER	(12)		Students income protection allowance
STUD_AVAIL_INCOME	NUMBER	(12)		Assessment of students available income
STUD_ASSET_ASS_RATE	NUMBER	(6)		Students asset assessment rate
INC_PROT_DIFF_9	NUMBER	(12)		Income protection differential for other than 9 months
A5_DEFAULT_AGE	NUMBER	(3)		Default age as per table A5
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 CI_SEQUENCE_NUMBER
,      CI_CAL_TYPE
,      METHOD_CODE
,      EMPL_EXP_PERCT_1
,      EMPL_EXP_ALLOW_1
,      EMPL_EXP_PERCT_2
,      EMPL_EXP_ALLOW_2
,      PARENT_ASST_CONV_RATE
,      STUD_INC_PRCT_ALLOW
,      STUD_AVAIL_INCOME
,      STUD_ASSET_ASS_RATE
,      INC_PROT_DIFF_9
,      A5_DEFAULT_AGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM IGF.IGF_AP_EFC_FRML_A;

Dependencies

[top of page]

IGF.IGF_AP_EFC_FRML_A does not reference any database object

IGF.IGF_AP_EFC_FRML_A is referenced by following:

APPS: IGF_AP_EFC_FRML_A