[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_FA_BASE_REC_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_FA_BASE_REC_ALL |
Subobject Name: | |
Status: | VALID |
Holds the summarized information of all the financial aid processes for a student for an academic year.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_FA_BASE_REC_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BASE_ID |
IGF_AP_FA_BASE_REC_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CI_CAL_TYPE
CI_SEQUENCE_NUMBER PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BASE_ID | NUMBER | (10) | Yes | Unique identifier for student financial aid record |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit. |
PERSON_ID | NUMBER | (15) | Yes | Person identifier |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
BBAY | VARCHAR2 | (30) | Indicates borrower based academic year value | |
CURRENT_ENROLLED_HRS | NUMBER | (8) | Denotes currently enrolled hours of student. Obtained from Oracle Student System. | |
EFC_F | NUMBER | (10) | Denotes student's EFC as per calculations made by federal methodology - Obsolete | |
SPECIAL_HANDLING | VARCHAR2 | (30) | Indicates whether student belongs to group that needs special handling | |
EFC_I | NUMBER | (10) | Denotes student's EFC as per calculations made by institutional methodology - Obsolete | |
NEED_F | NUMBER | (10) | Denotes need calculated as per federal method - Obsolete | |
NEED_I | NUMBER | (10) | Denotes need calculated as per institutional method - Obsolete | |
COA_PENDING | VARCHAR2 | (30) | Denotes whether cost of attendance calculation is pending | |
SAP_EVALUATION_DATE | DATE | Obsolete | ||
SAP_SELECTED_FLAG | VARCHAR2 | (30) | Obsolete | |
STATE_SAP_STATUS | VARCHAR2 | (30) | Obsolete | |
VERIFICATION_PROCESS_RUN | VARCHAR2 | (30) | Indicates whether verification selection process has been run on financial aid base record | |
INST_VERIF_STATUS_DATE | DATE | Indicates date on which institutional verification flag is set | ||
MANUAL_VERIF_FLAG | VARCHAR2 | (30) | Indicates whether financial aid record is manually selected for verification | |
FED_VERIF_STATUS | VARCHAR2 | (30) | Denotes whether selected for federal verification process | |
FED_VERIF_STATUS_DATE | DATE | Date when federal verification status is set | ||
INST_VERIF_STATUS | VARCHAR2 | (30) | Indicates whether selected for institutional verification | |
NSLDS_ELIGIBLE | VARCHAR2 | (30) | Indicates eligibility for NSLDS loans | |
EDE_CORRECTION_BATCH_ID | VARCHAR2 | (25) | Denotes electronic data exchange correction batch identifier | |
FA_PROCESS_STATUS_DATE | DATE | Denotes date of overall processing status of financial aid record | ||
ISIR_CORR_STATUS | VARCHAR2 | (30) | Denotes status of corrections made to payment ISIR indicated on financial aid base record | |
ISIR_CORR_STATUS_DATE | DATE | Denotes date on which correction status for payment ISIR is updated | ||
ISIR_STATUS | VARCHAR2 | (30) | Denotes status of payment ISIR | |
ISIR_STATUS_DATE | DATE | Denotes date on which ISIR status was set | ||
PROFILE_STATUS | VARCHAR2 | (30) | Stores the status of profile record added for the student. | |
PROFILE_STATUS_DATE | DATE | Stores the date on which the status of profile record added for the student | ||
PROFILE_FC | NUMBER | (15) | Holds the Family Contribution from Profile records | |
PELL_ELIGIBLE | VARCHAR2 | (30) | Denotes eligibility status for Pell grant | |
AWARD_ADJUSTED | VARCHAR2 | (30) | Indicates whether original package is manually adjusted | |
CHANGE_PENDING | VARCHAR2 | (30) | Indicates biographic change pending date for ISIR correction | |
COA_CODE_F | VARCHAR2 | (30) | This column is obsolete | |
COA_FIXED | NUMBER | (12) | Denotes cost of attendance for fixed items | |
COA_CODE_I | VARCHAR2 | (30) | This column is obsolete | |
COA_F | NUMBER | (12) | Denotes cost of attendance for student calculated as per federal methodology | |
COA_I | NUMBER | (12) | Denotes cost of attendance for student calculated as per institutional methodology | |
COA_PELL | NUMBER | (12) | Denotes cost of attendance for Pell grant | |
DISBURSEMENT_HOLD | VARCHAR2 | (30) | Indicates whether disbursements are to be put on hold | |
ENROLMENT_STATUS | VARCHAR2 | (30) | Indicates student's current enrollment status, such as half time or full time | |
ENROLMENT_STATUS_DATE | DATE | Indicates date on which enrollment status was set | ||
FA_PROCESS_STATUS | VARCHAR2 | (30) | Indicates overall processing status of financial aid student | |
FEDERAL_SAP_STATUS | VARCHAR2 | (30) | Obsolete | |
GRADE_LEVEL | VARCHAR2 | (30) | Indicates grade level, such as first year or sophomore | |
GRADE_LEVEL_DATE | DATE | Indicates date on which grade level was set | ||
GRADE_LEVEL_TYPE | VARCHAR2 | (30) | Indicates type of grade level | |
INST_SAP_STATUS | VARCHAR2 | (30) | Obsolete | |
LAST_PACKAGED | DATE | Indicates date on which package was last updated | ||
NOTIFICATION_STATUS | VARCHAR2 | (30) | Indicates status of award notification | |
NOTIFICATION_STATUS_DATE | DATE | Indicates date on which award notification status was set | ||
PACKAGING_HOLD | VARCHAR2 | (30) | Obsolete | |
NSLDS_DATA_OVERRIDE_FLG | VARCHAR2 | (30) | Indicates whether student data mentioned in NSLDS files can be overridden at time of loan processing | |
PACKAGING_STATUS | VARCHAR2 | (30) | Denotes packaging status | |
PROF_JUDGEMENT_FLG | VARCHAR2 | (30) | Indicates whether FAA adjustment correction is sent for payment ISIR | |
PACKAGING_STATUS_DATE | DATE | Indicates date on which packaging status was set | ||
PAYMENT_ISIR_ID | NUMBER | (15) | Indicates ISIR identifier that is marked for consideration in packaging process - Obsolete | |
QA_SAMPLING | VARCHAR2 | (30) | Indicates quality assurance sampling | |
TARGET_GROUP | VARCHAR2 | (30) | Indicates cost of attendance group to which student belongs | |
TODO_CODE | VARCHAR2 | (30) | Indicates to-do code assigned to student | |
TOTAL_PACKAGE_ACCEPTED | NUMBER | (11) | Indicates total package accepted | |
TOTAL_PACKAGE_OFFERED | NUMBER | (11) | Indicates total package offered | |
TRANSCRIPT_AVAILABLE | NUMBER | (10) | Indicates whether financial aid transcript is available for transferred student | |
TOLERANCE_AMOUNT | NUMBER | (15) | Indicates extent to which any difference in ISIR amount and verification amount is ignored | |
TRANSFERED | VARCHAR2 | (30) | Indicates if student transferred from another school | |
TOTAL_AID | NUMBER | (11) | Indicates total aid offered | |
ADMSTRUCT_ID | VARCHAR2 | (50) | Admissions Descriptive Flexfield structure identifier | |
ADMSEGMENT_1 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_2 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_3 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_4 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_5 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_6 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_7 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_8 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_9 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_10 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_11 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_12 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_13 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_14 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_15 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_16 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_17 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_18 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_19 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
ADMSEGMENT_20 | VARCHAR2 | (150) | Admissions Descriptive Flexfield segment | |
PACKSTRUCT_ID | VARCHAR2 | (50) | Packaging Descriptive Flexfield structure identifier | |
PACKSEGMENT_1 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_2 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_3 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_4 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_5 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_6 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_7 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_8 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_9 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_10 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_11 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_12 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_13 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_14 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_15 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_16 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_17 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_18 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_19 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
PACKSEGMENT_20 | VARCHAR2 | (150) | Packaging Descriptive Flexfield segment | |
MISCSTRUCT_ID | VARCHAR2 | (50) | Miscellaneous Descriptive Flexfield structure identifier | |
MISCSEGMENT_1 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_2 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_3 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_4 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_5 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_6 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_7 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_8 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_9 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_10 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_11 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_12 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_13 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_14 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_15 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_16 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_17 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_18 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_19 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
MISCSEGMENT_20 | VARCHAR2 | (150) | Miscellaneous Descriptive Flexfield segment | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | 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 | ||
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 Unit for a Person in an 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 BASE_ID
, CI_CAL_TYPE
, PERSON_ID
, CI_SEQUENCE_NUMBER
, ORG_ID
, BBAY
, CURRENT_ENROLLED_HRS
, EFC_F
, SPECIAL_HANDLING
, EFC_I
, NEED_F
, NEED_I
, COA_PENDING
, SAP_EVALUATION_DATE
, SAP_SELECTED_FLAG
, STATE_SAP_STATUS
, 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
, PELL_ELIGIBLE
, AWARD_ADJUSTED
, CHANGE_PENDING
, COA_CODE_F
, COA_FIXED
, COA_CODE_I
, COA_F
, COA_I
, COA_PELL
, DISBURSEMENT_HOLD
, ENROLMENT_STATUS
, ENROLMENT_STATUS_DATE
, FA_PROCESS_STATUS
, FEDERAL_SAP_STATUS
, GRADE_LEVEL
, GRADE_LEVEL_DATE
, GRADE_LEVEL_TYPE
, INST_SAP_STATUS
, LAST_PACKAGED
, NOTIFICATION_STATUS
, NOTIFICATION_STATUS_DATE
, PACKAGING_HOLD
, NSLDS_DATA_OVERRIDE_FLG
, PACKAGING_STATUS
, PROF_JUDGEMENT_FLG
, PACKAGING_STATUS_DATE
, PAYMENT_ISIR_ID
, QA_SAMPLING
, TARGET_GROUP
, TODO_CODE
, TOTAL_PACKAGE_ACCEPTED
, TOTAL_PACKAGE_OFFERED
, TRANSCRIPT_AVAILABLE
, TOLERANCE_AMOUNT
, TRANSFERED
, TOTAL_AID
, 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
, 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 IGF.IGF_AP_FA_BASE_REC_ALL;
IGF.IGF_AP_FA_BASE_REC_ALL does not reference any database object
IGF.IGF_AP_FA_BASE_REC_ALL is referenced by following:
|
|
|