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]

VIEW: APPS.IGF_GR_PELL_SETUP

Object Details

Object Name:	IGF_GR_PELL_SETUP
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_GR_PELL_SETUP
Subobject Name:
Status:	VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Database rowid for igf_gr_pell_setup table
PELL_SEQ_ID	NUMBER	(15)	Yes	Identifier for each pell grant
CI_CAL_TYPE	VARCHAR2	(10)	Yes	Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER	NUMBER	(6)	Yes	Indicates a unique identifier for the award year calender instance
REP_PELL_ID	VARCHAR2	(30)		Reporting Pell id parent to this record, from the reporting Pell setup entity
PELL_PROFILE	VARCHAR2	(0)		Column to Be Obsoleted -- Identification of a particular group of setup data. Rules will be needed in origination to assign Pell recipients to profiles. One profile will be the default origination profile.
BRANCH_CAMPUS	VARCHAR2	(0)		FA126_3102439_CS_DP2.doc - Obsolete
ATTEND_CAMPUS_ID	VARCHAR2	(0)		FA126_3102439_CS_DP2.doc - Obsolete
USE_CENSUS_DTS	VARCHAR2	(30)		Obsolete
FUNDING_METHOD	VARCHAR2	(3)		Designates the institution�s funding method as advance or just in time. Advance allows the institution to report disbursements 30 days prior to making them. Just in time allows the institution to report disbursements 5 days prior to making them.
INST_CROSS_REF_CODE	VARCHAR2	(30)		Contains any cross reference information useful to the institution to identify student records internally
LOW_TUTION_FEE	VARCHAR2	(1)		Obsolete
ACADEMIC_CAL	VARCHAR2	(30)	Yes	Calendar code which applies to this student's educational program
PAYMENT_METHOD	VARCHAR2	(30)		Formula code used to calculate the student's federal Pell grant award
WK_INST_TIME_CALC_PYMT	NUMBER	(5)		Formula used to calculate the student's federal Pell grant award
WK_INT_TIME_PRG_DEF_YR	NUMBER	(5)		Total number of weeks of instructional time in the institution�s definition of a full academic year for this student�s program of study
CR_CLK_HRS_PRDS_SCH_YR	NUMBER	(5)		Total number of credit or clock hours institution expects this student to complete and be paid for during the current federal Pell grant award year
CR_CLK_HRS_ACAD_YR	NUMBER	(5)		Total number of credit or clock hours in the institution�s definition of a full academic year for this student�s program of study
ALT_COA_LIMIT	NUMBER	(15)		Indicates Alternate 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)
EFC_MAX	NUMBER	(15)
PELL_ALT_EXP_MAX	NUMBER	(15)
COURSE_CD	VARCHAR2	(6)		Course Code
VERSION_NUMBER	NUMBER	(3)		Version Number
PAYMENT_PERIODS_NUM	NUMBER			Payment Periods in a Academic Year
ENR_BEFORE_TS_CODE	VARCHAR2	(30)		Enrollment Type Before Term Start
ENR_IN_MT_CODE	VARCHAR2	(30)		Enrollment Type in Mid Term
ENR_AFTER_TC_CODE	VARCHAR2	(30)		Enrollment Type After Census Date
REP_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Reporting entity id
RESPONSE_OPTION_CODE	VARCHAR2	(30)		Indicates 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 ROW_ID
,      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 APPS.IGF_GR_PELL_SETUP;

Dependencies

[top of page]

APPS.IGF_GR_PELL_SETUP references the following:

APPS: IGF_GR_PELL_SETUP_ALL

APPS.IGF_GR_PELL_SETUP is referenced by following:

APPS: IGF_GR_PELL_CALC - show dependent code; IGF_GR_PELL_SETUP_V; IGF_GR_REPACKAGE - show dependent code; IGF_GR_RFMS_DISB_ORIG - show dependent code