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_COD_HISTORY

Object Details

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

Table storing the history for the Pell Records sent and received from COD.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_GR_COD_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	RFMS_ORIG_HIST_ID
IGF_GR_COD_HISTORY_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORIGINATION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
RFMS_ORIG_HIST_ID	NUMBER		Yes	Unique Identifier for Pell Origination History
ORIGINATION_ID	VARCHAR2	(30)	Yes	Identifier for the pell record
AWARD_ID	NUMBER		Yes	Identifier for the award
DOCUMENT_ID_TXT	VARCHAR2	(30)	Yes	Identifier for the document
BASE_ID	NUMBER		Yes	Identifier for the student in the award year.
FIN_AWARD_YEAR	VARCHAR2	(30)		Indicates the year corresponding to awards.
CPS_TRANS_NUM	VARCHAR2	(2)		Indicates the transaction number from eligible ISIR used to calculate award.
AWARD_AMT	NUMBER			Indicates the total award amount that the student is eligible to receive as determined by the school.
COA_AMT	NUMBER			The cost of attending school. For Pell, the amount must equal COA calculated by the School for a full-time student or a full academic year following the Federal Pell Grant Program requirements.
LOW_TUTION_FEE	VARCHAR2	(30)		Indicator identifying tuition ranges when the annual tuition is less than or equal to minimum defined by low tuition and fees table.
INCARC_FLAG	VARCHAR2	(30)		Indicator identifying if the student is incarcerated in local penal institution but otherwise eligible to receive Federal Pell Grants.
VER_STATUS_CODE	VARCHAR2	(30)		Verification status of the applicant as reported by the school.
ENROLLMENT_DATE	DATE			First date that the student was enrolled in an eligible program for the designated award year. If the student enrolled in a crossover payment period before the first day of the Pell award year (July 1), but which will be paid from 2004- 2005 funds, report the actual start date of the student's classes for that payment period
SEC_EFC_CODE	VARCHAR2	(30)		Indicator of EFC value used to determine award amount.
YTD_DISB_AMT	NUMBER			For Pell, the total amount that has been disbursed to the student for the award year.
TOT_ELIG_USED	NUMBER			Total percentage for all schools of the student's annual Pell eligibility used for the specific award year.
SCHD_PELL_AMT	NUMBER			Scheduled amount for a full time student.
NEG_PEND_AMT	NUMBER			The amount by which the Pell award is overpaid (i.e., sum of disbursements exceeds Award Amount). School must adjust either award amount or disbursement amount within 30 days to avoid a COD-generated negative disbursement.
CPS_VERIF_FLAG	VARCHAR2	(30)		Indicates whether this student has been selected for verification by the CPSon any transaction number for this award year.
HIGH_CPS_TRANS_NUM	NUMBER			Indicates the highest transaction number on CPS for this student and award.
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note Message
FULL_RESP_CODE	VARCHAR2	(30)		Indicates the full response code
ATD_ENTITY_ID_TXT	VARCHAR2	(30)		Attending School Entity ID
REP_ENTITY_ID_TXT	VARCHAR2	(30)		Reporting School Entity ID
SOURCE_ENTITY_ID_TXT	VARCHAR2	(30)		Source Entity ID
PELL_STATUS	VARCHAR2	(30)		Indicates the status of the Pell Record
PELL_STATUS_DATE	DATE			Indicates date on which the status of the Pell Record changed
S_SSN	VARCHAR2	(30)		Indicates the current Social Security Number of the student
DRIVER_LIC_STATE	VARCHAR2	(60)		Attribute indicating the person's driver's License State.
DRIVER_LIC_NUMBER	VARCHAR2	(30)		Attribute indicating the person's driver's License Number.
S_DATE_OF_BIRTH	DATE			Attribute indicating the person's Date of birth.
FIRST_NAME	VARCHAR2	(60)		Attribute indicating the person's First name
MIDDLE_NAME	VARCHAR2	(60)		Attribute indicating the person's Middle name.
S_LAST_NAME	VARCHAR2	(60)		Attribute indicating the person's Last name.
S_CHG_DATE_OF_BIRTH	DATE			Indicates the old birth date
S_CHG_SSN	VARCHAR2	(30)		Indicates the old SSN
S_CHG_LAST_NAME	VARCHAR2	(150)		Indicates the old last name
PERMT_ADDR_FOREIGN_FLAG	VARCHAR2	(1)		Indicates if the permanent address is foreign or not.
ADDR_TYPE_CODE	VARCHAR2	(30)		Indicates whether the address is Permanent or Temporary
PERMT_ADDR_LINE_1	VARCHAR2	(40)		Indicates the first line of permanent address
PERMT_ADDR_LINE_2	VARCHAR2	(40)		Indicates the second line of permanent address
PERMT_ADDR_LINE_3	VARCHAR2	(40)		Indicates the third line of permanent address
PERMT_ADDR_CITY	VARCHAR2	(60)		Indicates the permanent address's city
PERMT_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the permanent address's state code
PERMT_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the permanent address's postal Code (zip code).
PERMT_ADDR_COUNTY	VARCHAR2	(30)		Indicates the permanent address's county
PERMT_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the permanent address's country
PHONE_NUMBER_1	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phone numbers for a person.
PHONE_NUMBER_2	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phone numbers for a person.
PHONE_NUMBER_3	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phone numbers for a person.
EMAIL_ADDRESS	VARCHAR2	(138)		Indicates the E-mail address of the person
CITZN_STATUS_CODE	VARCHAR2	(30)		Indicates the citizenship status code of the person
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
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT RFMS_ORIG_HIST_ID
,      ORIGINATION_ID
,      AWARD_ID
,      DOCUMENT_ID_TXT
,      BASE_ID
,      FIN_AWARD_YEAR
,      CPS_TRANS_NUM
,      AWARD_AMT
,      COA_AMT
,      LOW_TUTION_FEE
,      INCARC_FLAG
,      VER_STATUS_CODE
,      ENROLLMENT_DATE
,      SEC_EFC_CODE
,      YTD_DISB_AMT
,      TOT_ELIG_USED
,      SCHD_PELL_AMT
,      NEG_PEND_AMT
,      CPS_VERIF_FLAG
,      HIGH_CPS_TRANS_NUM
,      NOTE_MESSAGE
,      FULL_RESP_CODE
,      ATD_ENTITY_ID_TXT
,      REP_ENTITY_ID_TXT
,      SOURCE_ENTITY_ID_TXT
,      PELL_STATUS
,      PELL_STATUS_DATE
,      S_SSN
,      DRIVER_LIC_STATE
,      DRIVER_LIC_NUMBER
,      S_DATE_OF_BIRTH
,      FIRST_NAME
,      MIDDLE_NAME
,      S_LAST_NAME
,      S_CHG_DATE_OF_BIRTH
,      S_CHG_SSN
,      S_CHG_LAST_NAME
,      PERMT_ADDR_FOREIGN_FLAG
,      ADDR_TYPE_CODE
,      PERMT_ADDR_LINE_1
,      PERMT_ADDR_LINE_2
,      PERMT_ADDR_LINE_3
,      PERMT_ADDR_CITY
,      PERMT_ADDR_STATE_CODE
,      PERMT_ADDR_POST_CODE
,      PERMT_ADDR_COUNTY
,      PERMT_ADDR_COUNTRY
,      PHONE_NUMBER_1
,      PHONE_NUMBER_2
,      PHONE_NUMBER_3
,      EMAIL_ADDRESS
,      CITZN_STATUS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM IGF.IGF_GR_COD_HISTORY;

Dependencies

[top of page]

IGF.IGF_GR_COD_HISTORY does not reference any database object

IGF.IGF_GR_COD_HISTORY is referenced by following:

APPS: IGF_GR_COD_HISTORY