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_RFMS

Object Details

Object Name:	IGF_GR_RFMS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	IGF.IGF_GR_RFMS
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_rfms table
ORIGINATION_ID	VARCHAR2	(30)	Yes	Unique number used to identify an origination
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
BASE_ID	NUMBER	(10)	Yes	Identifier for student Financial Aid record
AWARD_ID	NUMBER	(15)	Yes	Identifier for award
RFMB_ID	NUMBER	(15)		Identifies each RFMS batch record uniquely
SYS_ORIG_SSN	VARCHAR2	(30)		Student's SSN from original FASFA
SYS_ORIG_NAME_CD	VARCHAR2	(80)		Student's name code from original FASFA
TRANSACTION_NUM	VARCHAR2	(30)		Transaction number from eligible SAR used to calculate award
EFC	NUMBER	(12)		Must equal the student's Expected Family Contribution from the ISIR or SAR
VER_STATUS_CODE	VARCHAR2	(30)		Status of verification of applicant data by the school
SECONDARY_EFC	NUMBER	(12)		Secondary EFC from ISIR
SECONDARY_EFC_CD	VARCHAR2	(30)		Code indicating which EFC value is used to determine award amount
PELL_AMOUNT	NUMBER	(12)	Yes	Stores the amount of award for student's entire school year
PELL_PROFILE	VARCHAR2	(0)		The 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-Obsolete
ENROLLMENT_STATUS	VARCHAR2	(1)		This student�s expected enrollment status for the entire award year
ENROLLMENT_DT	DATE			First date that the student was enrolled in an eligible program for the designated award year
COA_AMOUNT	NUMBER	(12)		Cost of attendence calculated by the institution following the federal pell grant Payment regulations
ACADEMIC_CALENDAR	VARCHAR2	(30)		Calendar code which applies to this student's educational program. Must be valid or system accepted to process record.
PAYMENT_METHOD	VARCHAR2	(30)		Formula code used to calculate the student's federal pell grant award
TOTAL_PYMT_PRDS	NUMBER	(12)		Number of terms or payment periods in student's school year
INCRCD_FED_PELL_RCP_CD	VARCHAR2	(30)		Code to indicate the student�s incarcerated status for students incarcerated in local penal institutions, but are otherwise eligible to receive Federal Pell Grants
ATTENDING_CAMPUS_ID	VARCHAR2	(30)		Pell id of attending campus
EST_DISB_DT1	DATE			Date of first disbursement to student is estimated to be made
ORIG_ACTION_CODE	VARCHAR2	(30)		Code to indicate action to be taken
ORIG_STATUS_DT	DATE			Date of transaction batch
ORIG_ED_USE_FLAGS	VARCHAR2	(30)		Flags that are set to inform institutions of modifications that have been made to their database and require immediate action to rectify
FT_PELL_AMOUNT	NUMBER	(12)		Scheduled amount for a full time student
PREV_ACCPT_EFC	NUMBER	(12)		EFC that was previously accepted and currently stored by RFMS for this student
PREV_ACCPT_TRAN_NO	VARCHAR2	(30)		Transaction number that was previously accepted and currently stored by RFMS for this student
PREV_ACCPT_SEC_EFC_CD	VARCHAR2	(30)		Secondary EFC Code that was previously accepted and currently stored by RFMS for this student
PREV_ACCPT_COA	NUMBER	(12)		Cost of attendence previously accepted and currently stored by RFMS for the student
ORIG_REJECT_CODE	VARCHAR2	(75)		List of up to twenty five 3 digit reject or warning codes which occurred during processing of this origination record
WK_INST_TIME_CALC_PYMT	NUMBER	(5)		Total number of weeks on instructional time provided by this student�s program of study during a full academic year
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
INST_CROSS_REF_CD	VARCHAR2	(30)		Contain any cross reference information useful to the institution to identify student records internally
LOW_TUTION_FEE	VARCHAR2	(30)		Flag to identify tuition ranges when the annual tuition is less than or equal to minimum defined by low tuition and fees table
REC_SOURCE	VARCHAR2	(1)		Determines if the record source is batch or manual
PENDING_AMOUNT	NUMBER	(15)
CREATED_BY	NUMBER	(15)	Yes	Standard who columns
CREATION_DATE	DATE		Yes	Standard who columns
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who columns
LAST_UPDATE_DATE	DATE		Yes	Standard who columns
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who columns
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
BIRTH_DT	DATE
FIRST_NAME	VARCHAR2	(150)
MIDDLE_NAME	VARCHAR2	(60)
LAST_NAME	VARCHAR2	(150)
CURRENT_SSN	VARCHAR2	(30)
LEGACY_RECORD_FLAG	VARCHAR2	(1)		Indicates this Pell Origination record is imported through Legacy Import Process
REP_PELL_ID	VARCHAR2	(30)		Reporting Pell Identifier for the Student
DOCUMENT_ID_TXT	VARCHAR2	(30)		Indicates document id
REP_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Reporting Entity Id
ATD_ENTITY_ID_TXT	VARCHAR2	(8)		Indicates Attending Entity Id
NOTE_MESSAGE	VARCHAR2	(100)		Text used by the school for its identification
FULL_RESP_CODE	VARCHAR2	(30)		Indicates full response code

Query Text

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


SELECT ROW_ID
,      ORIGINATION_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      BASE_ID
,      AWARD_ID
,      RFMB_ID
,      SYS_ORIG_SSN
,      SYS_ORIG_NAME_CD
,      TRANSACTION_NUM
,      EFC
,      VER_STATUS_CODE
,      SECONDARY_EFC
,      SECONDARY_EFC_CD
,      PELL_AMOUNT
,      PELL_PROFILE
,      ENROLLMENT_STATUS
,      ENROLLMENT_DT
,      COA_AMOUNT
,      ACADEMIC_CALENDAR
,      PAYMENT_METHOD
,      TOTAL_PYMT_PRDS
,      INCRCD_FED_PELL_RCP_CD
,      ATTENDING_CAMPUS_ID
,      EST_DISB_DT1
,      ORIG_ACTION_CODE
,      ORIG_STATUS_DT
,      ORIG_ED_USE_FLAGS
,      FT_PELL_AMOUNT
,      PREV_ACCPT_EFC
,      PREV_ACCPT_TRAN_NO
,      PREV_ACCPT_SEC_EFC_CD
,      PREV_ACCPT_COA
,      ORIG_REJECT_CODE
,      WK_INST_TIME_CALC_PYMT
,      WK_INT_TIME_PRG_DEF_YR
,      CR_CLK_HRS_PRDS_SCH_YR
,      CR_CLK_HRS_ACAD_YR
,      INST_CROSS_REF_CD
,      LOW_TUTION_FEE
,      REC_SOURCE
,      PENDING_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      BIRTH_DT
,      FIRST_NAME
,      MIDDLE_NAME
,      LAST_NAME
,      CURRENT_SSN
,      LEGACY_RECORD_FLAG
,      REP_PELL_ID
,      DOCUMENT_ID_TXT
,      REP_ENTITY_ID_TXT
,      ATD_ENTITY_ID_TXT
,      NOTE_MESSAGE
,      FULL_RESP_CODE
FROM APPS.IGF_GR_RFMS;

Dependencies

[top of page]

APPS.IGF_GR_RFMS references the following:

APPS: IGF_GR_RFMS_ALL

APPS.IGF_GR_RFMS is referenced by following:

APPS: IGF_AW_CANCEL_AWD - show dependent code; IGF_AW_GEN_003 - show dependent code; IGF_AW_SS_GEN_PKG - show dependent code; IGF_DB_DISB - show dependent code; IGF_GR_ESS_ESD_DATA - show dependent code; IGF_GR_GEN - show dependent code; IGF_GR_GEN - show dependent code; IGF_GR_GEN_XML - show dependent code; IGF_GR_GEN_XML - show dependent code; IGF_GR_MRR_LOAD_DATA - show dependent code; IGF_GR_PELL - show dependent code; IGF_GR_PELL_CALC - show dependent code; IGF_GR_REPACKAGE - show dependent code; IGF_GR_RFMS_DISB_ORIG - show dependent code; IGF_GR_RFMS_ORIG - show dependent code; IGF_GR_RFMS_V; IGF_GR_YTD_LOAD_DATA - show dependent code; IGF_SL_UPLOAD_XML - show dependent code