DBA Data[Home] [Help] [Dependency Information]

TABLE: IGF.IGF_AP_FA_BASE_REC_ALL

Object Details
Object Name: IGF_AP_FA_BASE_REC_ALL
Object Type: TABLE
Owner: IGF
FND Design Data: TableIGF.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
IGF_AP_FA_BASE_REC_ALL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBASE_ID
IGF_AP_FA_BASE_REC_ALL_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCI_CAL_TYPE
ColumnCI_SEQUENCE_NUMBER
ColumnPERSON_ID
Columns
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
Query Text

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;

Dependencies

[top of page]

IGF.IGF_AP_FA_BASE_REC_ALL does not reference any database object

IGF.IGF_AP_FA_BASE_REC_ALL is referenced by following:

SchemaAPPS
SynonymIGF_AP_FA_BASE_REC_ALL