[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_COA_GRP_ITEM_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_COA_GRP_ITEM_ALL |
Subobject Name: | |
Status: | VALID |
IGF_AW_COA_GRP_ITEM_ALL stores the total values of cost of attendance for each item in an award year.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_COA_GRP_ITEM_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COA_CODE
CI_CAL_TYPE CI_SEQUENCE_NUMBER ITEM_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COA_CODE | VARCHAR2 | (30) | Yes | Indicates cost of attendance code |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
ITEM_CODE | VARCHAR2 | (30) | Yes | Stores item code for specific item used in calculation of cost of attendance |
DEFAULT_VALUE | NUMBER | Default value for cost of attendance item | ||
FIXED_COST | VARCHAR2 | (30) | Yes | Indicates that item is component of fixed cost budgets |
PELL_COA | VARCHAR2 | (30) | Indicates if current item is necessary for Pell calculation | |
ACTIVE | VARCHAR2 | (30) | Yes | Indicator that specifies whether cost of attendance is active. Setting check box to inactive prevents use of cost of attendance item 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 | |
PELL_AMOUNT | NUMBER | Pell Amonut for cost of attendance item | ||
PELL_ALTERNATE_AMT | NUMBER | Alternate expenses in case of a Low Tuition fee Cost of Attendance | ||
ITEM_DIST | VARCHAR2 | (30) | Indicates if Item has overridden default term Distribution or not | |
LOCK_FLAG | VARCHAR2 | (1) | Lock Indicator |
Cut, paste (and edit) the following text to query this object:
SELECT COA_CODE
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, ITEM_CODE
, DEFAULT_VALUE
, FIXED_COST
, PELL_COA
, ACTIVE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, PELL_AMOUNT
, PELL_ALTERNATE_AMT
, ITEM_DIST
, LOCK_FLAG
FROM IGF.IGF_AW_COA_GRP_ITEM_ALL;
IGF.IGF_AW_COA_GRP_ITEM_ALL does not reference any database object
IGF.IGF_AW_COA_GRP_ITEM_ALL is referenced by following:
|
|
|