[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_ALT_AMTS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_GR_ALT_AMTS |
Subobject Name: | |
Status: | VALID |
Stores the Alternate Pell Amount for the given cost of attendance ranges, expected family contribution amounts and alternate expenses.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_GR_ALT_AMTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SEQUENCE_TXT |
IGF_GR_ALT_AMTS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
SYS_AWD_YR
ENROLLMENT_STAT_CODE COA_RANGE_START COA_RANGE_END EFC_RANGE_START EFC_RANGE_END EXP_RANGE_START EXP_RANGE_END |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SEQUENCE_TXT | VARCHAR2 | (15) | Yes | Unique Sequence for Identification |
SYS_AWD_YR | VARCHAR2 | (30) | Yes | System Award Year |
ENROLLMENT_STAT_CODE | VARCHAR2 | (30) | Yes | Student's enrollment status code |
COA_RANGE_START | NUMBER | (15) | Yes | Start range of cost of attendance values |
COA_RANGE_END | NUMBER | (15) | Yes | End range of cost of attendance values |
EFC_RANGE_START | NUMBER | (15) | Yes | Start range of EFC |
EFC_RANGE_END | NUMBER | (15) | Yes | End range of EFC |
EXP_RANGE_START | NUMBER | (15) | Yes | Start range of alternate expenses |
EXP_RANGE_END | NUMBER | (15) | Yes | End range of alternate expenses |
PELL_AMOUNT | NUMBER | (15) | Yes | Amount of Pell grant |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT SEQUENCE_TXT
, SYS_AWD_YR
, ENROLLMENT_STAT_CODE
, COA_RANGE_START
, COA_RANGE_END
, EFC_RANGE_START
, EFC_RANGE_END
, EXP_RANGE_START
, EXP_RANGE_END
, PELL_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM IGF.IGF_GR_ALT_AMTS;
IGF.IGF_GR_ALT_AMTS does not reference any database object
IGF.IGF_GR_ALT_AMTS is referenced by following:
|
|
|