eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: IGF.IGF_AW_LI_PELL_INTS

Object Details

Object Name:	IGF_AW_LI_PELL_INTS
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_AW_LI_PELL_INTS
Subobject Name:
Status:	VALID

Pell Origination Interface Table for Legacy Data Import
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - Pell Origination and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_PELL

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_AW_LI_PELL_INTS_PK	NORMAL	UNIQUE	APPS_TS_INTERFACE	CI_ALTERNATE_CODE PERSON_NUMBER AWARD_NUMBER_TXT ORIGINATION_ID_TXT
IGF_AW_LI_PELL_INTS_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	IMPORT_STATUS_TYPE
IGF_AW_LI_PELL_INTS_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	BATCH_NUM

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_NUM	NUMBER	(15)	Yes	Batch Number, used to identify the set of records included in the batch for processing
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.
AWARD_NUMBER_TXT	VARCHAR2	(15)	Yes	Unique Award Number of the Financial Aid Award for the student in context.
ORIGINATION_ID_TXT	VARCHAR2	(30)	Yes	Unique number used to identify origination
IMPORT_STATUS_TYPE	VARCHAR2	(1)	Yes	Record's Import status
ORIG_SEND_BATCH_ID_TXT	VARCHAR2	(30)		Origination Batch ID sent to COD
TRANSACTION_NUM_TXT	VARCHAR2	(30)		Transaction number from eligible SAR used to calculate award
EFC_AMT	NUMBER	(12)		Expected Family Contribution, must equal student's Expected Family Contribution from ISIR or SAR
VERIFICATION_STATUS_CODE	VARCHAR2	(30)		Status of verification of applicant data by the school
SECONDARY_EFC_AMT	NUMBER	(12)		Secondary Expected Family Contribution from ISIR
SECONDARY_EFC_CODE	VARCHAR2	(30)		Code indicating which Expected Family Contribution value is used to determine award amount
PELL_AWARD_AMT	NUMBER	(12)	Yes	Stores amount of award for student's entire school year
ENROLLMENT_STATUS_FLAG	VARCHAR2	(1)		Student's expected enrollment status for entire award year. Other is when student attends more than number of terms in full academic year. Valid values depend upon academic calendar and payment methodology fields.
ENROLLMENT_DATE	DATE			First date student was enrolled in eligible program in designated award year
PELL_COA_AMT	NUMBER	(12)		Must equal Cost of Attendance calculated by institution following federal Pell grant payment regulations
ACADEMIC_CALENDAR_CD	VARCHAR2	(30)	Yes	Calendar, which applies to student's educational program. Must be valid or system accepted to process record.
PAYMENT_METHOD_CODE	VARCHAR2	(30)	Yes	Formula used to calculate student's federal Pell grant award
INCRCD_FED_PELL_RCP_CODE	VARCHAR2	(30)		Code to indicate student's incarcerated status for students incarcerated in local penal institutions, but are otherwise eligible to receive federal Pell grants
ATTENDING_CAMPUS_CD	VARCHAR2	(30)		Pell identifier of attending campus
ORIG_STATUS_CODE	VARCHAR2	(30)		Code to indicate action to be taken
ORIG_STATUS_DATE	DATE			Date of transaction batch
ORIG_ED_USE_FLAGS_TXT	VARCHAR2	(30)		Flags that are set to inform institutions of modifications made to database that require immediate action to rectify
FT_SCH_PELL_AMT	NUMBER	(12)		Scheduled amount for full time student
PREV_ACCPT_EFC_AMT	NUMBER	(12)		Expected Family Contribution previously accepted and currently stored by RFMS for student. Valid for rejected originations.
PREV_ACCPT_TRAN_NUM_TXT	VARCHAR2	(30)		Transaction number previously accepted and currently stored by RFMS for student. It is populated for rejected originations.
PREV_ACCPT_SEC_EFC_CD	VARCHAR2	(30)		Secondary Expected Family Contribution code previously accepted and currently stored by RFMS for student
PREV_ACCPT_COA_AMT	NUMBER	(12)		Expected Family Contribution previously accepted and currently stored by RFMS for student. Valid for rejected originations.
ORIG_REJECT_CODES_TXT	VARCHAR2	(75)		Lists up to twenty-five 3-digit reject or warning codes that occurred during processing of origination record
WK_INST_TIME_CALC_PYMT_NUM	NUMBER	(5)		Total number of weeks on instructional time provided by student's program of study during full academic year
WK_INT_TIME_PRG_DEF_YR_NUM	NUMBER	(5)		Total number of weeks of instructional time in institution's definition of full academic year for student's program of study
CR_CLK_HRS_PRDS_SCH_YR_NUM	NUMBER	(5)		Total number of credit or clock hours institution expects student to complete and be paid for during current federal Pell grant award year
CR_CLK_HRS_ACAD_YR_NUM	NUMBER	(5)		Total number of credit or clock hours in institution's definition of full academic year for student's program of study
INST_CROSS_REF_CD	VARCHAR2	(30)		Contains cross reference information useful to institution for identifying student records internally
LOW_TUTION_FEE_CD	VARCHAR2	(30)		Code to identify tuition ranges when annual tuition is less than or equal to minimum defined by low tuition and fees table
PENDING_AMT	NUMBER	(12)		Pending amount yet to be paid to student
RFMS_PROCESS_DATE	DATE			Indicates date on which RFMS records were processed
RFMS_ACK_DATE	DATE			Indicates acknowledgement date when records were processed
IMPORT_RECORD_TYPE	VARCHAR2	(1)		Indicates whether the imported record is for Insert or Update
OPE_CD	VARCHAR2	(30)		Indicates OPE identifier sent in batch
PELL_ALT_EXP_AMT	NUMBER	(15)		Indicates the Alternate Pell Expense calculated for the student
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
REP_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Reporting Entity ID
ATD_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Attending Entity ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BATCH_NUM
,      CI_ALTERNATE_CODE
,      PERSON_NUMBER
,      AWARD_NUMBER_TXT
,      ORIGINATION_ID_TXT
,      IMPORT_STATUS_TYPE
,      ORIG_SEND_BATCH_ID_TXT
,      TRANSACTION_NUM_TXT
,      EFC_AMT
,      VERIFICATION_STATUS_CODE
,      SECONDARY_EFC_AMT
,      SECONDARY_EFC_CODE
,      PELL_AWARD_AMT
,      ENROLLMENT_STATUS_FLAG
,      ENROLLMENT_DATE
,      PELL_COA_AMT
,      ACADEMIC_CALENDAR_CD
,      PAYMENT_METHOD_CODE
,      INCRCD_FED_PELL_RCP_CODE
,      ATTENDING_CAMPUS_CD
,      ORIG_STATUS_CODE
,      ORIG_STATUS_DATE
,      ORIG_ED_USE_FLAGS_TXT
,      FT_SCH_PELL_AMT
,      PREV_ACCPT_EFC_AMT
,      PREV_ACCPT_TRAN_NUM_TXT
,      PREV_ACCPT_SEC_EFC_CD
,      PREV_ACCPT_COA_AMT
,      ORIG_REJECT_CODES_TXT
,      WK_INST_TIME_CALC_PYMT_NUM
,      WK_INT_TIME_PRG_DEF_YR_NUM
,      CR_CLK_HRS_PRDS_SCH_YR_NUM
,      CR_CLK_HRS_ACAD_YR_NUM
,      INST_CROSS_REF_CD
,      LOW_TUTION_FEE_CD
,      PENDING_AMT
,      RFMS_PROCESS_DATE
,      RFMS_ACK_DATE
,      IMPORT_RECORD_TYPE
,      OPE_CD
,      PELL_ALT_EXP_AMT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
FROM IGF.IGF_AW_LI_PELL_INTS;

Dependencies

[top of page]

IGF.IGF_AW_LI_PELL_INTS does not reference any database object

IGF.IGF_AW_LI_PELL_INTS is referenced by following:

APPS: IGF_AW_LI_PELL_INTS