[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_LI_FAB_INTS |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_LI_FAB_INTS |
Subobject Name: | |
Status: | VALID |
Financial Aid Base Record Data Interface Table for Legacy Import
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Import Financial Aid Base Record Data
Category: BUSINESS_ENTITY IGF_BASE_RECORD
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_LI_FAB_INTS_PK | NORMAL | UNIQUE | APPS_TS_INTERFACE |
CI_ALTERNATE_CODE
PERSON_NUMBER |
IGF_AP_LI_FAB_INTS_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | IMPORT_STATUS_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_NUM | NUMBER | (15) | Yes | Unique Batch Identifier |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Calendar Instance Alternate Code (Award Year) of the Financial Aid Award. |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number of the Financial Aid Award. |
IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
AWARD_PROCESS_STATUS_CODE | VARCHAR2 | (30) | Indicates the packaging status | |
AWARD_PROCESS_STATUS_DATE | DATE | Indicates date on which package status was last updated | ||
AWARD_NOTIFY_STATUS | VARCHAR2 | (30) | Indicates status of award notification | |
AWARD_NOTIFY_STATUS_DATE | DATE | Indicates date on which award notification status was set | ||
OVERRIDE_NSLDS_FLAG | VARCHAR2 | (1) | Indicates whether student data mentioned in NSLDS files can be overridden at time of loan processing | |
PROFESSIONAL_JUDGMENT_FLAG | VARCHAR2 | (1) | Indicates whether FAA adjustment correction is sent for payment ISIR | |
DISBURSE_VERIFICATION_HOLD | VARCHAR2 | (1) | Indicates whether the Hold Disbursement for Manual Re-award checkbox is checked or n | |
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 for concurrent programs | |
PROGRAM_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
PROGRAM_UPDATE_DATE | DATE | Standard Who column for concurrent programs | ||
REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUM
, CI_ALTERNATE_CODE
, PERSON_NUMBER
, IMPORT_STATUS_TYPE
, AWARD_PROCESS_STATUS_CODE
, AWARD_PROCESS_STATUS_DATE
, AWARD_NOTIFY_STATUS
, AWARD_NOTIFY_STATUS_DATE
, OVERRIDE_NSLDS_FLAG
, PROFESSIONAL_JUDGMENT_FLAG
, DISBURSE_VERIFICATION_HOLD
, 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_LI_FAB_INTS;
IGF.IGF_AP_LI_FAB_INTS does not reference any database object
IGF.IGF_AP_LI_FAB_INTS is referenced by following:
|
|
|