[Home] [Help] [Dependency Information]
Object Name: | IGF_AW_LI_COA_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AW_LI_COA_INTS |
Subobject Name: | |
Status: | VALID |
Interface table for importing Cost of Attendance Item details into the system
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Cost of Attendance Item Import Process
Category: BUSINESS_ENTITY IGF_COA
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AW_LI_COA_INTS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE | COAINT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NUM | NUMBER | (15) | Yes | Batch Identifier, used to identify the set of records to be processed. |
COAINT_ID | NUMBER | Yes | Uniquely identify each record in the interface table. | |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Award Year |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Identifier for student |
ITEM_CODE | VARCHAR2 | (30) | Yes | Identifier for Cost of Attendance Item |
PELL_COA_AMT | NUMBER | (15) | Pell Amount for current item | |
ALT_PELL_EXPENSE_AMT | NUMBER | (15) | Alternate Pell Expense for Cost of Attendance Item | |
FIXED_COST_FLAG | VARCHAR2 | (1) | Item's fixed cost | |
LD_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Indicates code for Term |
TERM_AMT | NUMBER | (15) | Amount for current Term | |
IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
IMPORT_RECORD_TYPE | VARCHAR2 | (1) | Determines whether this record has to update the System record if found in the system.Can have a value of U or Null | |
CREATED_BY | NUMBER | (15) | Standard Who Column | |
CREATION_DATE | DATE | Standard Who Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
LAST_UPDATE_DATE | DATE | Standard Who Column | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUM
, COAINT_ID
, CI_ALTERNATE_CODE
, PERSON_NUMBER
, ITEM_CODE
, PELL_COA_AMT
, ALT_PELL_EXPENSE_AMT
, FIXED_COST_FLAG
, LD_ALTERNATE_CODE
, TERM_AMT
, IMPORT_STATUS_TYPE
, IMPORT_RECORD_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM IGF.IGF_AW_LI_COA_INTS;
IGF.IGF_AW_LI_COA_INTS does not reference any database object
IGF.IGF_AW_LI_COA_INTS is referenced by following:
|
|
|