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_GR_PELL_SETUP_ALL

Object Details

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

Entity stores the Federal Pell grant setup details

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_GR_PELL_SETUP_ALL_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PELL_SEQ_ID
IGF_GR_PELL_SETUP_ALL_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	CI_CAL_TYPE CI_SEQUENCE_NUMBER REP_PELL_ID COURSE_CD VERSION_NUMBER REP_ENTITY_ID_TXT

Columns

Name	Datatype	Length	Mandatory	Comments
PELL_SEQ_ID	NUMBER	(15)	Yes	Identifier for each Pell grant
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates code for award year calender type. Used within operating unit.
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates unique identifier for award year calender instance
REP_PELL_ID	VARCHAR2	(30)		Reporting Pell identifier parent to record from the reporting Pell setup entity
PELL_PROFILE	VARCHAR2	(30)		Identification of particular group of setup data. Rules are needed in origination to assign Pell recipients to profiles. One profile is default origination profile - Obsolete
BRANCH_CAMPUS	VARCHAR2	(30)		FA126_3102439_CS_DP2.doc - Obsolete
ATTEND_CAMPUS_ID	VARCHAR2	(30)		FA126_3102439_CS_DP2.doc - Obsolete
USE_CENSUS_DTS	VARCHAR2	(30)		This Column is obsolete.
FUNDING_METHOD	VARCHAR2	(3)		Designates institution's funding method as advance or just in time. Advance allows institution to report disbursements 30 days prior to making them. Just in time allows institution to report disbursements 5 days prior to making them.
INST_CROSS_REF_CODE	VARCHAR2	(30)		Contains cross reference information useful to institution to identify student records internally
LOW_TUTION_FEE	VARCHAR2	(1)		This column is obsolete.
ACADEMIC_CAL	VARCHAR2	(30)	Yes	Calendar code that applies to student's educational program
PAYMENT_METHOD	VARCHAR2	(30)		Formula code used to calculate student's federal Pell grant award
WK_INST_TIME_CALC_PYMT	NUMBER	(5)		Total number of weeks of instructional time provided by student's program of study during full academic year
WK_INT_TIME_PRG_DEF_YR	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	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	NUMBER	(5)		Total number of credit or clock hours in institution's definition of full academic year for student's program of study
ALT_COA_LIMIT	NUMBER	(15)		Indicates the Alternative Cost of Attendance Limit for this PELL Setup
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
ORG_ID	NUMBER	(15)		Operating unit identifier
EFC_MAX	NUMBER	(15)		Maximum Expected Family Contribution
PELL_ALT_EXP_MAX	NUMBER	(15)		Maximum Pell Alternate Expenses
COURSE_CD	VARCHAR2	(6)		Program Code
VERSION_NUMBER	NUMBER	(3)		Program Version Number
PAYMENT_PERIODS_NUM	NUMBER			Number Of Payment Periods in an Academic Year.
ENR_BEFORE_TS_CODE	VARCHAR2	(30)		Enrollment Type to used for Pell Calc before Term Start Date.
ENR_IN_MT_CODE	VARCHAR2	(30)		Enrollment Type to be used for Pell in Mid Term
ENR_AFTER_TC_CODE	VARCHAR2	(30)		Enrollment Type to be used for Pell After Census Date.
REP_ENTITY_ID_TXT	VARCHAR2	(8)		Reporting Entity ID
RESPONSE_OPTION_CODE	VARCHAR2	(30)		Response Option Code
TERM_START_OFFSET_NUM	NUMBER			Offset to move term start date backward or forward.

Query Text

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


SELECT PELL_SEQ_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      REP_PELL_ID
,      PELL_PROFILE
,      BRANCH_CAMPUS
,      ATTEND_CAMPUS_ID
,      USE_CENSUS_DTS
,      FUNDING_METHOD
,      INST_CROSS_REF_CODE
,      LOW_TUTION_FEE
,      ACADEMIC_CAL
,      PAYMENT_METHOD
,      WK_INST_TIME_CALC_PYMT
,      WK_INT_TIME_PRG_DEF_YR
,      CR_CLK_HRS_PRDS_SCH_YR
,      CR_CLK_HRS_ACAD_YR
,      ALT_COA_LIMIT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ORG_ID
,      EFC_MAX
,      PELL_ALT_EXP_MAX
,      COURSE_CD
,      VERSION_NUMBER
,      PAYMENT_PERIODS_NUM
,      ENR_BEFORE_TS_CODE
,      ENR_IN_MT_CODE
,      ENR_AFTER_TC_CODE
,      REP_ENTITY_ID_TXT
,      RESPONSE_OPTION_CODE
,      TERM_START_OFFSET_NUM
FROM IGF.IGF_GR_PELL_SETUP_ALL;

Dependencies

[top of page]

IGF.IGF_GR_PELL_SETUP_ALL does not reference any database object

IGF.IGF_GR_PELL_SETUP_ALL is referenced by following:

APPS: IGF_GR_PELL_SETUP_ALL