[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_GR_YTD_ORIG_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_GR_YTD_ORIG_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_GR_YTD_ORIG_ALL stores the year to date origination data.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_GR_YTD_ORIG_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 YTDOR_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| YTDOR_ID | NUMBER | (15) | Yes | Identifier for each year to date origination record |
| ORIGINATION_ID | VARCHAR2 | (30) | Unique code for each origination | |
| ORIGINAL_SSN | VARCHAR2 | (9) | Student's SSN from original FAFSA | |
| ORIGINAL_NAME_CD | 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 | |
| ACTION_CODE | VARCHAR2 | (1) | Code indicating action to be taken | |
| ACCPT_AWD_AMT | NUMBER | (12) | Accepted award amount for entire school year | |
| ACCPT_DISB_DT1 | DATE | Estimate of date first disbursement to student occurs | ||
| ACCPT_DISB_DT2 | DATE | Estimate of date second disbursement to student occurs | ||
| ACCPT_DISB_DT3 | DATE | Estimate of date third disbursement to student occurs | ||
| ACCPT_DISB_DT4 | DATE | Estimate of date fourth disbursement to student occurs | ||
| ACCPT_DISB_DT5 | DATE | Estimate of date fifth disbursement to student occurs | ||
| ACCPT_DISB_DT6 | DATE | Estimate of date sixth disbursement to student occurs | ||
| ACCPT_DISB_DT7 | DATE | Estimate of date seventh disbursement to student occurs | ||
| ACCPT_DISB_DT8 | DATE | Estimate of date eighth disbursement to student occurs | ||
| ACCPT_DISB_DT9 | DATE | Estimate of date ninth disbursement to student occurs | ||
| ACCPT_DISB_DT10 | DATE | Estimate of date tenth disbursement to student occurs | ||
| ACCPT_DISB_DT11 | DATE | Estimate of date eleventh disbursement to student occurs | ||
| ACCPT_DISB_DT12 | DATE | Estimate of date twelfth disbursement to student occurs | ||
| ACCPT_DISB_DT13 | DATE | Estimate of date thirteenth disbursement to student occurs | ||
| ACCPT_DISB_DT14 | DATE | Estimate of date fourteenth disbursement to student occurs | ||
| ACCPT_DISB_DT15 | DATE | Estimate of date fifteenth disbursement to student occurs | ||
| ACCPT_ENRL_DT | DATE | First date student was enrolled in eligible program for designated school year | ||
| ACCPT_LOW_TUT_FLG | VARCHAR2 | (1) | Flag to identify tuition ranges when annual tuition is less than or equal to minimum defined by low tuition and fees table | |
| ACCPT_VER_STAT_FLG | VARCHAR2 | (1) | Status of verification of applicant data by school | |
| ACCPT_INCR_PELL_CD | VARCHAR2 | (1) | Code indicating student's incarcerated status for students incarcerated in local penal institutions, but are otherwise eligible to receive federal Pell grants | |
| ACCPT_TRAN_NUM | VARCHAR2 | (2) | Transaction number from eligible student aid report used to calculate award | |
| ACCPT_EFC | NUMBER | (12) | Must equal student's EFC from institutional student information report or student aid report | |
| ACCPT_SEC_EFC | VARCHAR2 | (1) | Code indicating which EFC value is used to determine award amount | |
| ACCPT_ACAD_CAL | VARCHAR2 | (1) | Calendar which applies to student's educational program. Must be valid or system accepted to process record. | |
| ACCPT_PYMT_METHOD | VARCHAR2 | (1) | Formula used to calculate student's federal Pell grant award | |
| ACCPT_COA | NUMBER | (12) | Cost of attendance calculated by institution following federal Pell grant payment regulations | |
| ACCPT_ENRL_STAT | VARCHAR2 | (1) | Code that applies to student's expected enrollment status for award year | |
| ACCPT_WKS_INST_PYMT | VARCHAR2 | (30) | Total number of weeks on instructional time provided by student's program of study during full academic year | |
| WK_INST_TIME_CALC_PYMT | NUMBER | (5) | Weeks of instructional time used to calculate payment | |
| ACCPT_WKS_ACAD | 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_ACAD_YR | VARCHAR2 | (30) | Total number of credit or clock hours in institution's definition of full academic year for student's program of study | |
| INST_SEQ_NUM | VARCHAR2 | (30) | Internal sequence number institution defines | |
| SCH_FULL_TIME_PELL | NUMBER | (12) | Scheduled amount for full time student | |
| STUD_NAME | VARCHAR2 | (30) | Student's name | |
| SSN | VARCHAR2 | (9) | Social Security number | |
| STUD_DOB | DATE | Student's date of birth | ||
| CPS_VER_SEL_CD | VARCHAR2 | (1) | Designates whether CPS selected student for institutional verification of applicant data as of transaction number reported | |
| YTD_DISB_AMT | 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 | ||
| 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 | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Calendar Type | |
| CI_SEQUENCE_NUMBER | NUMBER | Calendar Instance Identifier |
Cut, paste (and edit) the following text to query this object:
SELECT YTDOR_ID
, ORIGINATION_ID
, ORIGINAL_SSN
, ORIGINAL_NAME_CD
, ATTEND_PELL_ID
, ED_USE
, INST_CROSS_REF_CODE
, ACTION_CODE
, ACCPT_AWD_AMT
, ACCPT_DISB_DT1
, ACCPT_DISB_DT2
, ACCPT_DISB_DT3
, ACCPT_DISB_DT4
, ACCPT_DISB_DT5
, ACCPT_DISB_DT6
, ACCPT_DISB_DT7
, ACCPT_DISB_DT8
, ACCPT_DISB_DT9
, ACCPT_DISB_DT10
, ACCPT_DISB_DT11
, ACCPT_DISB_DT12
, ACCPT_DISB_DT13
, ACCPT_DISB_DT14
, ACCPT_DISB_DT15
, ACCPT_ENRL_DT
, ACCPT_LOW_TUT_FLG
, ACCPT_VER_STAT_FLG
, ACCPT_INCR_PELL_CD
, ACCPT_TRAN_NUM
, ACCPT_EFC
, ACCPT_SEC_EFC
, ACCPT_ACAD_CAL
, ACCPT_PYMT_METHOD
, ACCPT_COA
, ACCPT_ENRL_STAT
, ACCPT_WKS_INST_PYMT
, WK_INST_TIME_CALC_PYMT
, ACCPT_WKS_ACAD
, ACCPT_CR_ACAD_YR
, INST_SEQ_NUM
, SCH_FULL_TIME_PELL
, STUD_NAME
, SSN
, STUD_DOB
, CPS_VER_SEL_CD
, YTD_DISB_AMT
, BATCH_ID
, PROCESS_DATE
, 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
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
FROM IGF.IGF_GR_YTD_ORIG_ALL;
IGF.IGF_GR_YTD_ORIG_ALL does not reference any database object
IGF.IGF_GR_YTD_ORIG_ALL is referenced by following:
APPS
IGF_GR_YTD_ORIG_ALL
|
|
|
|