[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_PELL_ORIGINATIONS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_PELL_ORIGINATIONS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that Stores all the RFMS data that needs to be sent to the COD system.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORIGINATION_ID | VARCHAR2 | (30) | Yes | Unique number used to identify origination |
| ORIGINAL_SSN | VARCHAR2 | (30) | Student's SSN from original FASFA | |
| ORIGINAL_NAME_CODE | VARCHAR2 | (80) | Student's name code from original FASFA | |
| FIRST_NAME | VARCHAR2 | (150) | First Name of the student | |
| MIDDLE_NAME | VARCHAR2 | (60) | Middle Name of the student | |
| LAST_NAME | VARCHAR2 | (150) | Last Name of the student | |
| DATE_OF_BIRTH | DATE | Birth Date for the student | ||
| CURRENT_SSN | VARCHAR2 | (30) | Current Social Security Number | |
| TRANSACTION_NUMBER | VARCHAR2 | (30) | Transaction number from eligible SAR used to calculate award | |
| EFC | NUMBER | (12) | Must equal student's EFC from ISIR or SAR | |
| _LA:VERIFICATION_STATUS | CHAR | (68) | Status of verification of applicant data by school | |
| SECONDARY_EFC | NUMBER | (12) | Secondary EFC from ISIR | |
| _LA:SECONDARY_EFC_CODE | CHAR | (68) | Code indicating which EFC value is used to determine award amount | |
| PELL_AWARD | NUMBER | (12) | Yes | Stores amount of award for student's entire school year |
| _LA:ENROLLMENT_STATUS | CHAR | (74) | 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_DATE | DATE | First date student was enrolled in eligible program designated award year | ||
| COST_OF_ATTENDANCE | NUMBER | (12) | Must equal cost of attendance calculated by institution following federal Pell grant payment regulations | |
| _LA:ACADEMIC_CALENDAR | CHAR | (67) | Calendar which applies to student's educational program. Must be valid or system accepted to process record. | |
| _LA:PAYMENT_METHOD | CHAR | (70) | Formula used to calculate student's federal Pell grant award | |
| TOTAL_PAYMENT_PERIODS | 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 | |
| _LA:INCARCERATED_CODE | CHAR | (82) | 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 | |
| FIRST_DISBURSEMENT_DATE | DATE | Date of first disbursement to student is estimated to be made | ||
| _LA:ORIGINATION_STATUS | CHAR | (69) | Code to indicate action to be taken | |
| ORIGINATION_STATUS_DATE | DATE | Date of transaction batch | ||
| RECTIFICATION_FLAGS | VARCHAR2 | (30) | Flags that are set to inform institutions of modifications made to database that require immediate action to rectify | |
| SCHEDULED_AWARD | NUMBER | (12) | Scheduled amount for full time student | |
| PREVIOUSLY_ACCPTED_EFC | NUMBER | (12) | EFC previously accepted and currently stored by RFMS for student. Valid for rejected originations | |
| PREVIOUSLY_ACCPTED_TRAN_NO | VARCHAR2 | (30) | Transaction number previously accepted and currently stored by RFMS for student. It is populated for rejected originations | |
| PREVIOUSLY_ACCPTED_SEC_EFC | VARCHAR2 | (30) | Secondary EFC code previously accepted and currently stored by RFMS for student | |
| PREVIOUSLY_ACCPTED_COA | NUMBER | (12) | Cost of attendance previously accepted and currently stored by RFMS for student | |
| ORIGINATION_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_YEAR | NUMBER | (5) | Total number of credit or clock hours in institution's definition of full academic year for student's program of study | |
| ORIGINATION_CROSS_REFERENCE | VARCHAR2 | (30) | Contains cross reference information useful to institution for identifying student records internally | |
| LOW_TUITION_FEE_CODE | VARCHAR2 | (30) | Flag to identify tuition ranges when annual tuition is less than or equal to minimum defined by low tuition and fees table | |
| RECORD_SOURCE | VARCHAR2 | (1) | Determines if record source is batch or manual | |
| PENDING_AMOUNT | NUMBER | (15) | This is the amount the student is yet to be paid | |
| LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates this Pell Origination record is imported through Legacy Import Process | |
| AWARD_YEAR | VARCHAR2 | (10) | Alternate short reference code for identifying a calendar instance. | |
| AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for the calendar Instance | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person unique identification number |
| PERSON_NAME | VARCHAR2 | (360) | Yes | Person Name |
| BATCH_IDENTIFICATION_NUMBER | VARCHAR2 | (30) | Unique batch identification number | |
| BATCH_PROCESS_DATE | DATE | Batch processed date | ||
| 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 | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
| CREATED_BY | NUMBER | (15) | Yes | WHO column |
| CREATION_DATE | DATE | Yes | WHO column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | WHO column |
| LAST_UPDATE_DATE | DATE | Yes | WHO column | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ORIGINATION_ID
, ORIGINAL_SSN
, ORIGINAL_NAME_CODE
, FIRST_NAME
, MIDDLE_NAME
, LAST_NAME
, DATE_OF_BIRTH
, CURRENT_SSN
, TRANSACTION_NUMBER
, EFC
, _LA:VERIFICATION_STATUS
, SECONDARY_EFC
, _LA:SECONDARY_EFC_CODE
, PELL_AWARD
, _LA:ENROLLMENT_STATUS
, ENROLLMENT_DATE
, COST_OF_ATTENDANCE
, _LA:ACADEMIC_CALENDAR
, _LA:PAYMENT_METHOD
, TOTAL_PAYMENT_PERIODS
, _LA:INCARCERATED_CODE
, ATTENDING_CAMPUS_ID
, FIRST_DISBURSEMENT_DATE
, _LA:ORIGINATION_STATUS
, ORIGINATION_STATUS_DATE
, RECTIFICATION_FLAGS
, SCHEDULED_AWARD
, PREVIOUSLY_ACCPTED_EFC
, PREVIOUSLY_ACCPTED_TRAN_NO
, PREVIOUSLY_ACCPTED_SEC_EFC
, PREVIOUSLY_ACCPTED_COA
, ORIGINATION_REJECT_CODE
, WK_INST_TIME_CALC_PYMT
, WK_INT_TIME_PRG_DEF_YR
, CR_CLK_HRS_PRDS_SCH_YR
, CR_CLK_HRS_ACAD_YEAR
, ORIGINATION_CROSS_REFERENCE
, LOW_TUITION_FEE_CODE
, RECORD_SOURCE
, PENDING_AMOUNT
, LEGACY_RECORD_FLAG
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, PERSON_NUMBER
, PERSON_NAME
, BATCH_IDENTIFICATION_NUMBER
, BATCH_PROCESS_DATE
, BASE_ID
, AWARD_ID
, RFMB_ID
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFFV_PELL_ORIGINATIONS;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_GR_RFMS_ALL
IGF_GR_RFMS_BATCH_ALL
IGS_CA_INST_ALL
APPS.IGFFV_PELL_ORIGINATIONS is not referenced by any database object
|
|
|
|