[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
IGF.IGF_GR_COD_HISTORY does not reference any database object
IGF.IGF_GR_COD_HISTORY is referenced by following:
|
|
|