[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_GR_RFMS_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_GR_RFMS_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_GR_RFMS_ALL is an internal system table that stores RFMS data that needs to be sent to the RFMS system.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_GR_RFMS_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORIGINATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORIGINATION_ID | VARCHAR2 | (30) | Yes | Unique number used to identify origination |
| 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 |
| BASE_ID | NUMBER | (10) | Yes | Identifier for student financial aid record |
| AWARD_ID | NUMBER | (15) | Yes | Unique identifier for award |
| RFMB_ID | NUMBER | (15) | Stores batch header | |
| 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 student's EFC from ISIR or SAR | |
| VER_STATUS_CODE | VARCHAR2 | (30) | Status of verification of applicant data by 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 amount of award for student's entire school year |
| 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 | |
| ENROLLMENT_STATUS | VARCHAR2 | (1) | Student's expected enrollment status for entire award year. Other is when student attends more than number of terms in full academic year. Valid values depend upon academic calendar and payment methodology fields. | |
| ENROLLMENT_DT | DATE | First date student was enrolled in eligible program designated award year | ||
| COA_AMOUNT | NUMBER | (12) | Must equal cost of attendence calculated by institution following federal Pell grant payment regulations | |
| ACADEMIC_CALENDAR | VARCHAR2 | (30) | Calendar which applies to student's educational program. Must be valid or system accepted to process record. | |
| PAYMENT_METHOD | VARCHAR2 | (30) | Formula used to calculate student's federal Pell grant award | |
| TOTAL_PYMT_PRDS | NUMBER | (12) | Number of terms or payment periods in student's school year. For schools required to submit special disbursements, reporting must have valid value. | |
| INCRCD_FED_PELL_RCP_CD | VARCHAR2 | (30) | Code to indicate 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 identifier 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 made to database that require immediate action to rectify | |
| FT_PELL_AMOUNT | NUMBER | (12) | Scheduled amount for full time student | |
| PREV_ACCPT_EFC | NUMBER | (12) | EFC previously accepted and currently stored by RFMS for student. Valid for rejected originations. | |
| PREV_ACCPT_TRAN_NO | VARCHAR2 | (30) | Transaction number previously accepted and currently stored by RFMS for student. It is populated for rejected originations. | |
| PREV_ACCPT_SEC_EFC_CD | VARCHAR2 | (30) | Secondary EFC code previously accepted and currently stored by RFMS for student | |
| PREV_ACCPT_COA | NUMBER | (12) | Cost of attendence previously accepted and currently stored by RFMS for student | |
| ORIG_REJECT_CODE | VARCHAR2 | (75) | List of up to twenty-five 3-digit reject or warning codes that occurred during processing of origination record | |
| WK_INST_TIME_CALC_PYMT | NUMBER | (5) | Total number of weeks on 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 | |
| INST_CROSS_REF_CD | VARCHAR2 | (30) | Contains cross reference information useful to institution for identifying student records internally | |
| LOW_TUTION_FEE | VARCHAR2 | (30) | Flag to identify tuition ranges when annual tuition is less than or equal to minimum defined by low tuition and fees table | |
| REC_SOURCE | VARCHAR2 | (1) | Determines if record source is batch or manual | |
| 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 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 | |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| PENDING_AMOUNT | NUMBER | (15) | This is the amount the student is yet to be paid. | |
| BIRTH_DT | DATE | Birth Date for the student | ||
| LAST_NAME | VARCHAR2 | (150) | Last Name of the student | |
| FIRST_NAME | VARCHAR2 | (150) | First Name of the student | |
| MIDDLE_NAME | VARCHAR2 | (60) | Middle Name of the student | |
| CURRENT_SSN | VARCHAR2 | (30) | Current Social Security Number | |
| LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates this Pell Origination record is imported through Legacy Import Process | |
| REPORTING_PELL_CD | VARCHAR2 | (30) | Reporting Pell Identifier for the Student | |
| REP_ENTITY_ID_TXT | VARCHAR2 | (8) | Indicates Reporting Entity ID | |
| ATD_ENTITY_ID_TXT | VARCHAR2 | (8) | Indicates Attending Entity ID | |
| NOTE_MESSAGE | VARCHAR2 | (100) | Indicates Note message. | |
| FULL_RESP_CODE | VARCHAR2 | (30) | Indicates full response code | |
| DOCUMENT_ID_TXT | VARCHAR2 | (30) | Indicates document id. |
Cut, paste (and edit) the following text to query this object:
SELECT 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REQUEST_ID
, ORG_ID
, PENDING_AMOUNT
, BIRTH_DT
, LAST_NAME
, FIRST_NAME
, MIDDLE_NAME
, CURRENT_SSN
, LEGACY_RECORD_FLAG
, REPORTING_PELL_CD
, REP_ENTITY_ID_TXT
, ATD_ENTITY_ID_TXT
, NOTE_MESSAGE
, FULL_RESP_CODE
, DOCUMENT_ID_TXT
FROM IGF.IGF_GR_RFMS_ALL;
IGF.IGF_GR_RFMS_ALL does not reference any database object
IGF.IGF_GR_RFMS_ALL is referenced by following:
APPS
IGF_GR_RFMS_ALL
|
|
|
|