DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGFFV_PELL_YTD_ORIGINATIONS

Object Details
Object Name: IGFFV_PELL_YTD_ORIGINATIONS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGFFV_PELL_YTD_ORIGINATIONS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full View for the Entity that holds the information about the year to date origination data


[View Source]

Columns
Name Datatype Length Mandatory Comments
ORIGINAL_SSN VARCHAR2 (9)
Student's SSN from original FAFSA
ORIGINAL_NAME_CODE VARCHAR2 (2)
Student's name code from original FAFSA
ATTEND_PELL_ID VARCHAR2 (30)
Pell identifier of campus attended
ED_USE VARCHAR2 (30)
Not currently used
INST_CROSS_REF_CODE VARCHAR2 (30)
Contains cross reference information useful to institution for internally identifying student records
_LA:ACTION_CODE CHAR (65)
Lookup tag for Code indicating action to be taken
ACCPT_AWARD_AMOUNT NUMBER (12)
Accepted award amount for entire school year
ACCPTED_DISBURSEMENT_DATE1 DATE

Estimate of date first disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE2 DATE

Estimate of date second disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE3 DATE

Estimate of date third disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE4 DATE

Estimate of date fourth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE5 DATE

Estimate of date fifth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE6 DATE

Estimate of date sixth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE7 DATE

Estimate of date seventh disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE8 DATE

Estimate of date eighth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE9 DATE

Estimate of date ninth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE10 DATE

Estimate of date tenth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE11 DATE

Estimate of date eleventh disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE12 DATE

Estimate of date twelfth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE13 DATE

Estimate of date thirteenth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE14 DATE

Estimate of date fourteenth disbursement to student occurs
ACCPTED_DISBURSEMENT_DATE15 DATE

Estimate of date fifteenth disbursement to student occurs
ACCPTED_ENROLLMENT_DATE DATE

First date student was enrolled in eligible program for designated school year
ACCPTED_LOW_TUTION_FLAG VARCHAR2 (1)
Flag to identify tuition ranges when annual tuition is less than or equal to minimum defined by low tuition and fees table
_LA:ACCPT_VER_STAT_FLAG CHAR (72)
Lookup tag for Status of verification of applicant data by school
_LA:ACCPT_INCR_PELL_CODE CHAR (79)
Lookup tag for Code indicating student's incarcerated status for students incarcerated in local penal institutions, but are otherwise eligible to receive federal Pell grants
ACCPTED_TRANSACTION_NUMBER VARCHAR2 (2)
Transaction number from eligible student aid report used to calculate award
ACCPTED_ESTMTD_FAMILY_CONTRIB NUMBER (12)
Must equal student's EFC from institutional student information report or student aid report
_LA:ACCPT_SECONDARY_EFC CHAR (66)
Lookup tag for Code indicating which EFC value is used to determine award amount
_LA:ACCPT_ACADEMIC_CALENDAR CHAR (65)
Lookup tag for Calendar which applies to student's educational program. Must be valid or system accepted to process record.
_LA:ACCPT_PAYMENT_METHOD CHAR (74)
Lookup tag for Formula used to calculate student's federal Pell grant award
ACCPTED_COST_OF_ATTENDNCE NUMBER (12)
Lookup tag for Cost of attendance calculated by institution following federal Pell grant payment regulations
_LA:ACCPT_ENROLLMENT_STATUS CHAR (73)
Code that applies to student's expected enrollment status for award year
ACCPT_WEEKS_INSTALMNT_PAYMENT VARCHAR2 (30)
Total number of weeks on instructional time provided by student's program of study during full academic year
WEEK_INST_TIME_CALC_PAYMENT NUMBER (5)
Weeks of instructional time used to calculate payment
ACCPT_WKS_ACADEMIC VARCHAR2 (30)
Total number of credit or clock hours in all payment periods institution expects student to attend and be paid for during federal Pell grant award year
ACCPT_CR_ACADEMIC_YEAR VARCHAR2 (30)
Total number of credit or clock hours in institution's definition of full academic year for student's program of study
INST_SEQUENCE_NUMBER VARCHAR2 (30)
Internal sequence number institution defines
SCH_FULL_TIME_PELL NUMBER (12)
Scheduled amount for full time student
STUDENT_NAME VARCHAR2 (30)
Student's name
STUDENT_DATE_OF_BIRTH DATE

Student's date of birth
CPS_VER_SEL_CODE VARCHAR2 (1)
Designates whether CPS selected student for institutional verification of applicant data as of transaction number reported
YTD_DISBURSEMENT_AMOUNT NUMBER (12)
Total of processed disbursements by RFMS
BATCH_ID VARCHAR2 (30)
Number generated by institution to uniquely identify specific batch of records
PROCESS_DATE DATE

Date record, or segment, was processed by federal Pell grant program
ORIGINATION_ID VARCHAR2 (30)
Unique code for each origination
YTDOR_ID NUMBER (15) Yes Identifier for each year to date origination record
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
Query Text

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


SELECT ORIGINAL_SSN
,      ORIGINAL_NAME_CODE
,      ATTEND_PELL_ID
,      ED_USE
,      INST_CROSS_REF_CODE
,      _LA:ACTION_CODE
,      ACCPT_AWARD_AMOUNT
,      ACCPTED_DISBURSEMENT_DATE1
,      ACCPTED_DISBURSEMENT_DATE2
,      ACCPTED_DISBURSEMENT_DATE3
,      ACCPTED_DISBURSEMENT_DATE4
,      ACCPTED_DISBURSEMENT_DATE5
,      ACCPTED_DISBURSEMENT_DATE6
,      ACCPTED_DISBURSEMENT_DATE7
,      ACCPTED_DISBURSEMENT_DATE8
,      ACCPTED_DISBURSEMENT_DATE9
,      ACCPTED_DISBURSEMENT_DATE10
,      ACCPTED_DISBURSEMENT_DATE11
,      ACCPTED_DISBURSEMENT_DATE12
,      ACCPTED_DISBURSEMENT_DATE13
,      ACCPTED_DISBURSEMENT_DATE14
,      ACCPTED_DISBURSEMENT_DATE15
,      ACCPTED_ENROLLMENT_DATE
,      ACCPTED_LOW_TUTION_FLAG
,      _LA:ACCPT_VER_STAT_FLAG
,      _LA:ACCPT_INCR_PELL_CODE
,      ACCPTED_TRANSACTION_NUMBER
,      ACCPTED_ESTMTD_FAMILY_CONTRIB
,      _LA:ACCPT_SECONDARY_EFC
,      _LA:ACCPT_ACADEMIC_CALENDAR
,      _LA:ACCPT_PAYMENT_METHOD
,      ACCPTED_COST_OF_ATTENDNCE
,      _LA:ACCPT_ENROLLMENT_STATUS
,      ACCPT_WEEKS_INSTALMNT_PAYMENT
,      WEEK_INST_TIME_CALC_PAYMENT
,      ACCPT_WKS_ACADEMIC
,      ACCPT_CR_ACADEMIC_YEAR
,      INST_SEQUENCE_NUMBER
,      SCH_FULL_TIME_PELL
,      STUDENT_NAME
,      STUDENT_DATE_OF_BIRTH
,      CPS_VER_SEL_CODE
,      YTD_DISBURSEMENT_AMOUNT
,      BATCH_ID
,      PROCESS_DATE
,      ORIGINATION_ID
,      YTDOR_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_PELL_YTD_ORIGINATIONS;

Dependencies

[top of page]

APPS.IGFFV_PELL_YTD_ORIGINATIONS references the following:

SchemaAPPS
SynonymIGF_GR_YTD_ORIG_ALL

APPS.IGFFV_PELL_YTD_ORIGINATIONS is not referenced by any database object