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_AW_TARGET_GRP_ALL

Object Details

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

IGF_AW_TARGET_GRP_ALL stores upper level constraints to be enforced on each grant.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AW_TARGET_GRP_ALL_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	TGRP_ID
IGF_AW_TARGET_GRP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	GROUP_CD ORG_ID CAL_TYPE SEQUENCE_NUMBER ADPLANS_ID
IGF_AW_TARGET_GRP_ALL_U3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RULE_ORDER

Columns

Name	Datatype	Length	Mandatory	Comments
GROUP_CD	VARCHAR2	(30)	Yes	Unique code that identifies group policy
DESCRIPTION	VARCHAR2	(80)	Yes	Long name for group code
MAX_GRANT_AMT	NUMBER	(12)		Stores value of maximum aid that can be given per student
MAX_GRANT_PERCT	NUMBER	(12)		Stores percentage value for maximum aid that student can get through grants
MAX_GRANT_PERCT_FACT	VARCHAR2	(30)		Factor against which maximum percentage amount is calculated
MAX_LOAN_AMT	NUMBER	(12)		Stores value of maximum loan that can be given per student
MAX_LOAN_PERCT	NUMBER	(12)		Stores percentage value for maximum aid that student can get through loans
MAX_LOAN_PERCT_FACT	VARCHAR2	(30)		Factor against which maximum percentage amount is calculated
MAX_WORK_AMT	NUMBER	(12)		Stores value of maximum aid that can be given per student
MAX_WORK_PERCT	NUMBER	(12)		Stores percentage value for maximum aid that student can get through work study program
MAX_WORK_PERCT_FACT	VARCHAR2	(30)		Factor against which maximum percentage amount is calculated
MAX_SHELP_AMT	NUMBER	(12)		Stores value of maximum aid that can be given per student
MAX_SHELP_PERCT	NUMBER	(12)		Stores percentage value for maximum aid that student can get through self help
MAX_SHELP_PERCT_FACT	VARCHAR2	(30)		Factor against which maximum percentage amount is calculated
MAX_GAP_AMT	NUMBER	(12)		Initial amount added to EFC to decrease all students' need
MAX_GAP_PERCT	NUMBER	(12)		Stores percentage value for maximum aid student can get through gap amount
MAX_GAP_PERCT_FACT	VARCHAR2	(30)		Factor against which maximum percentage amount is calculated
USE_FIXED_COSTS	VARCHAR2	(30)		Use fixed costs for packaging
MAX_AID_PKG	NUMBER	(12)		Maximum aid that can be packaged for student
RULE_ORDER	NUMBER	(10)		Obsolete
S_RULE_CALL_CD	VARCHAR2	(10)		Obsolete
RUL_SEQUENCE_NUMBER	NUMBER	(15)		Obsolete
ACTIVE	VARCHAR2	(30)	Yes	Indicator that specifies whether group code is active. Setting check box to inactive prevents use of group code in new or modified records.
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
ORG_ID	NUMBER	(15)		Operating unit identifier
TGRP_ID	NUMBER	(15)	Yes	Identifier for target group
CAL_TYPE	VARCHAR2	(10)	Yes	Stores the Calendar Type for the Award year
SEQUENCE_NUMBER	NUMBER	(6)	Yes	Stores the Award year calendar Sequence Number
MAX_GIFT_AMT	NUMBER	(12)		Maximum Gift aid amount that can be awarded
MAX_GIFT_PERCT	NUMBER	(12)		Maximum Gift aid % that can be awarded.
MAX_GIFT_PERCT_FACT	VARCHAR2	(30)		Maximum Gift aid % factor
MAX_SCHLRSHP_AMT	NUMBER	(12)		Maximum Scholarship amount that can be awarded
MAX_SCHLRSHP_PERCT	NUMBER	(12)		Maximum Scholarship % that can be awarded
MAX_SCHLRSHP_PERCT_FACT	VARCHAR2	(30)		Maximum Scholarship % factor
ADPLANS_ID	NUMBER			Foreign Key to the Award Distribution Plan Table

Query Text

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


SELECT GROUP_CD
,      DESCRIPTION
,      MAX_GRANT_AMT
,      MAX_GRANT_PERCT
,      MAX_GRANT_PERCT_FACT
,      MAX_LOAN_AMT
,      MAX_LOAN_PERCT
,      MAX_LOAN_PERCT_FACT
,      MAX_WORK_AMT
,      MAX_WORK_PERCT
,      MAX_WORK_PERCT_FACT
,      MAX_SHELP_AMT
,      MAX_SHELP_PERCT
,      MAX_SHELP_PERCT_FACT
,      MAX_GAP_AMT
,      MAX_GAP_PERCT
,      MAX_GAP_PERCT_FACT
,      USE_FIXED_COSTS
,      MAX_AID_PKG
,      RULE_ORDER
,      S_RULE_CALL_CD
,      RUL_SEQUENCE_NUMBER
,      ACTIVE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      TGRP_ID
,      CAL_TYPE
,      SEQUENCE_NUMBER
,      MAX_GIFT_AMT
,      MAX_GIFT_PERCT
,      MAX_GIFT_PERCT_FACT
,      MAX_SCHLRSHP_AMT
,      MAX_SCHLRSHP_PERCT
,      MAX_SCHLRSHP_PERCT_FACT
,      ADPLANS_ID
FROM IGF.IGF_AW_TARGET_GRP_ALL;

Dependencies

[top of page]

IGF.IGF_AW_TARGET_GRP_ALL does not reference any database object

IGF.IGF_AW_TARGET_GRP_ALL is referenced by following:

APPS: IGF_AW_TARGET_GRP_ALL