[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_DI_RESP_DTLS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_SL_DI_RESP_DTLS |
Subobject Name: | |
Status: | VALID |
Table storing the DL Loan Information Response Elements from the response XML file
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_DI_RESP_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | DL_INFO_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DL_INFO_ID | NUMBER | Yes | Identifier for the DL Information Response records | |
STDNT_RESP_ID | NUMBER | Identifier for the corresponding student response record. | ||
LOAN_KEY_NUM | NUMBER | Indicates the Loan Key Attribute | ||
ORIG_FEE_PCT_NUM | NUMBER | Indicates the origination fee percent used for this record. | ||
INT_REB_PCT_NUM | NUMBER | Indicates the interest rebate percentage used for the disbursement. | ||
PNOTE_PRINT_CODE | VARCHAR2 | (30) | Indicates the Promissory Note printoption used for this record. | |
DISCLOSURE_PRINT_CODE | VARCHAR2 | (30) | Indicates whether the school or COD will print the Disclosure Statement. The party(school or COD) who is responsible for mailing the Disclosure Statement is also responsible for printing and mailing the Plain Language Disclosure Statement. | |
GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates the student's current college grade level in the program or college. | |
FIN_AWD_BEGIN_DATE | DATE | Indicates the date when classes begin for the specific period covered by aid. | ||
FIN_AWD_END_DATE | DATE | Indicates the date when classes end for the specific period covered by aid. | ||
ACAD_YR_BEGIN_DATE | DATE | Indicates the date the student's academic year starts at the school. | ||
ACAD_YR_END_DATE | DATE | Indicates the date the student's academic year ends at the school. | ||
RESP_CODE | VARCHAR2 | (30) | Indicates the Response Code | |
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 | |
PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_ID | NUMBER | (15) | Standard Who column | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column | ||
REQUEST_ID | NUMBER | (15) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT DL_INFO_ID
, STDNT_RESP_ID
, LOAN_KEY_NUM
, ORIG_FEE_PCT_NUM
, INT_REB_PCT_NUM
, PNOTE_PRINT_CODE
, DISCLOSURE_PRINT_CODE
, GRADE_LEVEL_CODE
, FIN_AWD_BEGIN_DATE
, FIN_AWD_END_DATE
, ACAD_YR_BEGIN_DATE
, ACAD_YR_END_DATE
, RESP_CODE
, 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_SL_DI_RESP_DTLS;
IGF.IGF_SL_DI_RESP_DTLS does not reference any database object
IGF.IGF_SL_DI_RESP_DTLS is referenced by following:
|
|
|