[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGF.IGF_AW_TARGET_GRP_ALL does not reference any database object
IGF.IGF_AW_TARGET_GRP_ALL is referenced by following:
|
|
|