[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_EFC_DET |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_EFC_DET |
Subobject Name: | |
Status: | VALID |
OBSOLETE
Tablespace: | APPS_TS_ARCHIVE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_EFC_DET_PK | NORMAL | UNIQUE | APPS_TS_ARCHIVE |
BASE_ID
METHOD_CODE CONTEXT_ISIR_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
METHOD_CODE | VARCHAR2 | (30) | Yes | Stores the need analysis methodology code |
BASE_ID | NUMBER | (15) | Yes | Unique identifier for student financial aid record |
CONTEXT_ISIR_ID | NUMBER | (15) | Yes | Stores the context ISIR ID for which EFC was computed |
PRIMARY_EFC1 | NUMBER | (12) | One months cumulative effective family contribution | |
PRIMARY_EFC2 | NUMBER | (12) | Two months cumulative effective family contribution | |
PRIMARY_EFC3 | NUMBER | (12) | Three months cumulative effective family contribution | |
PRIMARY_EFC4 | NUMBER | (12) | Four months cumulative effective family contribution | |
PRIMARY_EFC5 | NUMBER | (12) | Five months cumulative effective family contribution | |
PRIMARY_EFC6 | NUMBER | (12) | Six months cumulative effective family contribution | |
PRIMARY_EFC7 | NUMBER | (12) | Seven months cumulative effective family contribution | |
PRIMARY_EFC8 | NUMBER | (12) | Eight months cumulative effective family contribution | |
PRIMARY_EFC9 | NUMBER | (12) | Nine months cumulative effective family contribution | |
PRIMARY_EFC10 | NUMBER | (12) | Nine months cumulative effective family contribution | |
PRIMARY_EFC11 | NUMBER | (12) | Eleven months cumulative effective family contribution | |
PRIMARY_EFC12 | NUMBER | (12) | Twelve months cumulative effective family contribution | |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
CREATION_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO columns |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO columns | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO columns | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard concurrent WHO columns | |
PROGRAM_ID | NUMBER | (15) | Standard concurrent WHO columns | |
PROGRAM_UPDATE_DATE | DATE | Standard concurrent WHO columns | ||
REQUEST_ID | NUMBER | (15) | Standard concurrent WHO columns |
Cut, paste (and edit) the following text to query this object:
SELECT METHOD_CODE
, BASE_ID
, CONTEXT_ISIR_ID
, PRIMARY_EFC1
, PRIMARY_EFC2
, PRIMARY_EFC3
, PRIMARY_EFC4
, PRIMARY_EFC5
, PRIMARY_EFC6
, PRIMARY_EFC7
, PRIMARY_EFC8
, PRIMARY_EFC9
, PRIMARY_EFC10
, PRIMARY_EFC11
, PRIMARY_EFC12
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
FROM IGF.IGF_AP_EFC_DET;
IGF.IGF_AP_EFC_DET does not reference any database object
IGF.IGF_AP_EFC_DET is referenced by following:
|
|
|