[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_FA_BASE_REC |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_AP_FA_BASE_REC |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Holds the summarized information of all the financial aid processes for a student for an academic year
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
BASE_ID | NUMBER | (10) | Yes | |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | |
PERSON_ID | NUMBER | (15) | Yes | |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | |
ORG_ID | NUMBER | (15) | ||
EFC_F | NUMBER | (10) | ||
EFC_I | NUMBER | (10) | ||
NEED_F | NUMBER | (10) | ||
NEED_I | NUMBER | (10) | ||
COA_PENDING | VARCHAR2 | (30) | ||
VERIFICATION_PROCESS_RUN | VARCHAR2 | (30) | ||
INST_VERIF_STATUS_DATE | DATE | |||
MANUAL_VERIF_FLAG | VARCHAR2 | (30) | ||
FED_VERIF_STATUS | VARCHAR2 | (30) | ||
FED_VERIF_STATUS_DATE | DATE | |||
INST_VERIF_STATUS | VARCHAR2 | (30) | ||
NSLDS_ELIGIBLE | VARCHAR2 | (30) | ||
EDE_CORRECTION_BATCH_ID | VARCHAR2 | (25) | ||
FA_PROCESS_STATUS_DATE | DATE | |||
ISIR_CORR_STATUS | VARCHAR2 | (30) | ||
ISIR_CORR_STATUS_DATE | DATE | |||
ISIR_STATUS | VARCHAR2 | (30) | ||
ISIR_STATUS_DATE | DATE | |||
PROFILE_STATUS | VARCHAR2 | (30) | ||
PROFILE_STATUS_DATE | DATE | |||
PROFILE_FC | NUMBER | (15) | ||
COA_CODE_F | VARCHAR2 | (0) | ||
COA_FIXED | NUMBER | (12) | ||
COA_CODE_I | VARCHAR2 | (30) | ||
COA_F | NUMBER | (12) | ||
COA_I | NUMBER | (12) | ||
COA_PELL | NUMBER | (12) | ||
DISBURSEMENT_HOLD | VARCHAR2 | (30) | ||
FA_PROCESS_STATUS | VARCHAR2 | (30) | ||
NOTIFICATION_STATUS | VARCHAR2 | (30) | ||
NOTIFICATION_STATUS_DATE | DATE | |||
PACKAGING_HOLD | VARCHAR2 | (0) | Obsolete | |
NSLDS_DATA_OVERRIDE_FLG | VARCHAR2 | (30) | ||
PACKAGING_STATUS | VARCHAR2 | (30) | ||
PROF_JUDGEMENT_FLG | VARCHAR2 | (30) | ||
PACKAGING_STATUS_DATE | DATE | |||
PAYMENT_ISIR_ID | NUMBER | (15) | ||
TARGET_GROUP | VARCHAR2 | (30) | ||
TOTAL_PACKAGE_ACCEPTED | NUMBER | (11) | ||
TOTAL_PACKAGE_OFFERED | NUMBER | (11) | ||
ADMSTRUCT_ID | VARCHAR2 | (50) | ||
ADMSEGMENT_1 | VARCHAR2 | (150) | ||
ADMSEGMENT_2 | VARCHAR2 | (150) | ||
ADMSEGMENT_3 | VARCHAR2 | (150) | ||
ADMSEGMENT_4 | VARCHAR2 | (150) | ||
ADMSEGMENT_5 | VARCHAR2 | (150) | ||
ADMSEGMENT_6 | VARCHAR2 | (150) | ||
ADMSEGMENT_7 | VARCHAR2 | (150) | ||
ADMSEGMENT_8 | VARCHAR2 | (150) | ||
ADMSEGMENT_9 | VARCHAR2 | (150) | ||
ADMSEGMENT_10 | VARCHAR2 | (150) | ||
ADMSEGMENT_11 | VARCHAR2 | (150) | ||
ADMSEGMENT_12 | VARCHAR2 | (150) | ||
ADMSEGMENT_13 | VARCHAR2 | (150) | ||
ADMSEGMENT_14 | VARCHAR2 | (150) | ||
ADMSEGMENT_15 | VARCHAR2 | (150) | ||
ADMSEGMENT_16 | VARCHAR2 | (150) | ||
ADMSEGMENT_17 | VARCHAR2 | (150) | ||
ADMSEGMENT_18 | VARCHAR2 | (150) | ||
ADMSEGMENT_19 | VARCHAR2 | (150) | ||
ADMSEGMENT_20 | VARCHAR2 | (150) | ||
PACKSTRUCT_ID | VARCHAR2 | (50) | ||
PACKSEGMENT_1 | VARCHAR2 | (150) | ||
PACKSEGMENT_2 | VARCHAR2 | (150) | ||
PACKSEGMENT_3 | VARCHAR2 | (150) | ||
PACKSEGMENT_4 | VARCHAR2 | (150) | ||
PACKSEGMENT_5 | VARCHAR2 | (150) | ||
PACKSEGMENT_6 | VARCHAR2 | (150) | ||
PACKSEGMENT_7 | VARCHAR2 | (150) | ||
PACKSEGMENT_8 | VARCHAR2 | (150) | ||
PACKSEGMENT_9 | VARCHAR2 | (150) | ||
PACKSEGMENT_10 | VARCHAR2 | (150) | ||
PACKSEGMENT_11 | VARCHAR2 | (150) | ||
PACKSEGMENT_12 | VARCHAR2 | (150) | ||
PACKSEGMENT_13 | VARCHAR2 | (150) | ||
PACKSEGMENT_14 | VARCHAR2 | (150) | ||
PACKSEGMENT_15 | VARCHAR2 | (150) | ||
PACKSEGMENT_16 | VARCHAR2 | (150) | ||
PACKSEGMENT_17 | VARCHAR2 | (150) | ||
PACKSEGMENT_18 | VARCHAR2 | (150) | ||
PACKSEGMENT_19 | VARCHAR2 | (150) | ||
PACKSEGMENT_20 | VARCHAR2 | (150) | ||
MISCSTRUCT_ID | VARCHAR2 | (50) | ||
MISCSEGMENT_1 | VARCHAR2 | (150) | ||
MISCSEGMENT_2 | VARCHAR2 | (150) | ||
MISCSEGMENT_3 | VARCHAR2 | (150) | ||
MISCSEGMENT_4 | VARCHAR2 | (150) | ||
MISCSEGMENT_5 | VARCHAR2 | (150) | ||
MISCSEGMENT_6 | VARCHAR2 | (150) | ||
MISCSEGMENT_7 | VARCHAR2 | (150) | ||
MISCSEGMENT_8 | VARCHAR2 | (150) | ||
MISCSEGMENT_9 | VARCHAR2 | (150) | ||
MISCSEGMENT_10 | VARCHAR2 | (150) | ||
MISCSEGMENT_11 | VARCHAR2 | (150) | ||
MISCSEGMENT_12 | VARCHAR2 | (150) | ||
MISCSEGMENT_13 | VARCHAR2 | (150) | ||
MISCSEGMENT_14 | VARCHAR2 | (150) | ||
MISCSEGMENT_15 | VARCHAR2 | (150) | ||
MISCSEGMENT_16 | VARCHAR2 | (150) | ||
MISCSEGMENT_17 | VARCHAR2 | (150) | ||
MISCSEGMENT_18 | VARCHAR2 | (150) | ||
MISCSEGMENT_19 | VARCHAR2 | (150) | ||
MISCSEGMENT_20 | VARCHAR2 | (150) | ||
TOLERANCE_AMOUNT | NUMBER | (15) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
MANUAL_DISB_HOLD | VARCHAR2 | (1) | Indicates whether the Hold Disbursement for Manual Re-award checkbox is checked or not | |
PELL_ALT_EXPENSE | NUMBER | (15) | Alternate Pell Expense calculated for the student | |
ASSOC_ORG_NUM | NUMBER | Associated Organization with the Student in the Award Year | ||
AWARD_FMLY_CONTRIBUTION_TYPE | VARCHAR2 | (1) | To identify whether the Family contribution is Primary or Secondary EFC Type | |
ISIR_LOCKED_BY | NUMBER | (15) | Holds the User ID of the Person, who has locked the ISIR. | |
ADNL_UNSUB_LOAN_ELIG_FLAG | VARCHAR2 | (1) | Flag indicates if the Student is eligible for additional unsubsidized Loan. | |
LOCK_AWD_FLAG | VARCHAR2 | (1) | Lock Awards indicator | |
LOCK_COA_FLAG | VARCHAR2 | (1) | Lock Cost of Attendance indicator |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, BASE_ID
, CI_CAL_TYPE
, PERSON_ID
, CI_SEQUENCE_NUMBER
, ORG_ID
, EFC_F
, EFC_I
, NEED_F
, NEED_I
, COA_PENDING
, VERIFICATION_PROCESS_RUN
, INST_VERIF_STATUS_DATE
, MANUAL_VERIF_FLAG
, FED_VERIF_STATUS
, FED_VERIF_STATUS_DATE
, INST_VERIF_STATUS
, NSLDS_ELIGIBLE
, EDE_CORRECTION_BATCH_ID
, FA_PROCESS_STATUS_DATE
, ISIR_CORR_STATUS
, ISIR_CORR_STATUS_DATE
, ISIR_STATUS
, ISIR_STATUS_DATE
, PROFILE_STATUS
, PROFILE_STATUS_DATE
, PROFILE_FC
, COA_CODE_F
, COA_FIXED
, COA_CODE_I
, COA_F
, COA_I
, COA_PELL
, DISBURSEMENT_HOLD
, FA_PROCESS_STATUS
, NOTIFICATION_STATUS
, NOTIFICATION_STATUS_DATE
, PACKAGING_HOLD
, NSLDS_DATA_OVERRIDE_FLG
, PACKAGING_STATUS
, PROF_JUDGEMENT_FLG
, PACKAGING_STATUS_DATE
, PAYMENT_ISIR_ID
, TARGET_GROUP
, TOTAL_PACKAGE_ACCEPTED
, TOTAL_PACKAGE_OFFERED
, ADMSTRUCT_ID
, ADMSEGMENT_1
, ADMSEGMENT_2
, ADMSEGMENT_3
, ADMSEGMENT_4
, ADMSEGMENT_5
, ADMSEGMENT_6
, ADMSEGMENT_7
, ADMSEGMENT_8
, ADMSEGMENT_9
, ADMSEGMENT_10
, ADMSEGMENT_11
, ADMSEGMENT_12
, ADMSEGMENT_13
, ADMSEGMENT_14
, ADMSEGMENT_15
, ADMSEGMENT_16
, ADMSEGMENT_17
, ADMSEGMENT_18
, ADMSEGMENT_19
, ADMSEGMENT_20
, PACKSTRUCT_ID
, PACKSEGMENT_1
, PACKSEGMENT_2
, PACKSEGMENT_3
, PACKSEGMENT_4
, PACKSEGMENT_5
, PACKSEGMENT_6
, PACKSEGMENT_7
, PACKSEGMENT_8
, PACKSEGMENT_9
, PACKSEGMENT_10
, PACKSEGMENT_11
, PACKSEGMENT_12
, PACKSEGMENT_13
, PACKSEGMENT_14
, PACKSEGMENT_15
, PACKSEGMENT_16
, PACKSEGMENT_17
, PACKSEGMENT_18
, PACKSEGMENT_19
, PACKSEGMENT_20
, MISCSTRUCT_ID
, MISCSEGMENT_1
, MISCSEGMENT_2
, MISCSEGMENT_3
, MISCSEGMENT_4
, MISCSEGMENT_5
, MISCSEGMENT_6
, MISCSEGMENT_7
, MISCSEGMENT_8
, MISCSEGMENT_9
, MISCSEGMENT_10
, MISCSEGMENT_11
, MISCSEGMENT_12
, MISCSEGMENT_13
, MISCSEGMENT_14
, MISCSEGMENT_15
, MISCSEGMENT_16
, MISCSEGMENT_17
, MISCSEGMENT_18
, MISCSEGMENT_19
, MISCSEGMENT_20
, TOLERANCE_AMOUNT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, MANUAL_DISB_HOLD
, PELL_ALT_EXPENSE
, ASSOC_ORG_NUM
, AWARD_FMLY_CONTRIBUTION_TYPE
, ISIR_LOCKED_BY
, ADNL_UNSUB_LOAN_ELIG_FLAG
, LOCK_AWD_FLAG
, LOCK_COA_FLAG
FROM APPS.IGF_AP_FA_BASE_REC;
|
|
|