[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_COA_GROUP_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_COA_GROUP_ALL |
Subobject Name: | |
Status: | VALID |
IGF_AW_COA_GROUP_ALL links the cost of attendence code with each financial year.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_COA_GROUP_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
COA_CODE
CI_CAL_TYPE CI_SEQUENCE_NUMBER |
IGF_AW_COA_GROUP_ALL_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CI_CAL_TYPE
CI_SEQUENCE_NUMBER RULE_ORDER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COA_CODE | VARCHAR2 | (30) | Yes | Indicates cost of attendence code |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calender type. Used within operating unit. |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calender instance |
RULE_ORDER | NUMBER | (10) | Stores rule order for specific rule returned to form-Obsolete | |
S_RULE_CALL_CD | VARCHAR2 | (10) | Stores rule call code for rule returned-Obsolete | |
RUL_SEQUENCE_NUMBER | NUMBER | (15) | Stores rule sequence number for rule returned to form - Obsolete | |
PELL_COA | NUMBER | (13) | Pell Grant associated with COA - Obsolete | |
PELL_ALT_EXP | NUMBER | (13) | Alternate expenses in case of a Low Tuition fee Cost of Attendance - Obsolete | |
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 | |
COA_GRP_DESC | VARCHAR2 | (80) | Holds User Description of group |
Cut, paste (and edit) the following text to query this object:
SELECT COA_CODE
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, RULE_ORDER
, S_RULE_CALL_CD
, RUL_SEQUENCE_NUMBER
, PELL_COA
, PELL_ALT_EXP
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, COA_GRP_DESC
FROM IGF.IGF_AW_COA_GROUP_ALL;
IGF.IGF_AW_COA_GROUP_ALL does not reference any database object
IGF.IGF_AW_COA_GROUP_ALL is referenced by following:
|
|
|