[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_GR_PELL_SETUP_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_GR_PELL_SETUP_V
|
| Subobject Name: | |
| Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Database rowid for igf_gr_pell_setup table | |
| PELL_SEQ_ID | NUMBER | (15) | Yes | Identifier for each pell grant |
| REP_PELL_ID | VARCHAR2 | (30) | Reporting Pell id parent to this record, from the reporting Pell setup entity | |
| CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates the code for the award year calender type, used within the operating unit |
| CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates a unique identifier for the award year calender instance |
| CI_ALTERNATE_CODE | VARCHAR2 | (10) | Indicates the alternate short reference code for identifying a award year calendar instance | |
| CI_START_DT | DATE | Yes | Indicates the award year start date | |
| CI_END_DT | DATE | Yes | Indicates the award year end date | |
| PELL_PROFILE | VARCHAR2 | (0) | Pell_Profile Column to be Obsoleted -- Identification of a particular group of setup data. Rules will be needed in origination to assign Pell recipients to profiles. One profile will be the default origination profile. | |
| BRANCH_CAMPUS | VARCHAR2 | (0) | FA126_3102439_CS_DP2.doc - Obsolete | |
| ATTEND_CAMPUS_ID | VARCHAR2 | (0) | FA126_3102439_CS_DP2.doc - Obsolete | |
| INST_CROSS_REF_CODE | VARCHAR2 | (30) | Contains any cross reference information useful to the institution to identify student records internally | |
| ACADEMIC_CAL | VARCHAR2 | (30) | Yes | Calendar code which applies to this student's educational program |
| ACAD_CAL_DESC | VARCHAR2 | (4000) | Long name for calendar code which applies to this student's educational program | |
| PAYMENT_METHOD | VARCHAR2 | (30) | Formula code used to calculate the student's federal Pell grant award | |
| PYMT_METHOD_DESC | VARCHAR2 | (4000) | Long name for formula used to calculate the student's federal Pell grant award | |
| WK_INST_TIME_CALC_PYMT | NUMBER | (5) | Formula used to calculate the student's federal Pell grant award | |
| WK_INT_TIME_PRG_DEF_YR | NUMBER | (5) | Total number of weeks of instructional time in the institution's definition of a full academic year for this student's program of study | |
| CR_CLK_HRS_PRDS_SCH_YR | NUMBER | (5) | Total number of credit or clock hours institution expects this student to complete and be paid for during the current federal Pell grant award year | |
| CR_CLK_HRS_ACAD_YR | NUMBER | (5) | Total number of credit or clock hours in the institution's definition of a full academic year for this student's program of study | |
| FUNDING_METHOD | VARCHAR2 | (3) | Designates the institution's funding method as advance or just in time. Advance allows the institution to report disbursements 30 days prior to making them. Just in time allows the institution to report disbursements 5 days prior to making them. | |
| USE_CENSUS_DTS | VARCHAR2 | (30) | Obsolete | |
| LOW_TUTION_FEE | VARCHAR2 | (1) | Obsolete | |
| ALT_COA_LIMIT | NUMBER | (15) | Indicates Alternate Cost of Attendance Limit for this PELL Setup | |
| 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 | |
| EFC_MAX | NUMBER | (15) | ||
| PELL_ALT_EXP_MAX | NUMBER | (15) | ||
| COURSE_CD | VARCHAR2 | (6) | Program Code | |
| VERSION_NUMBER | NUMBER | (3) | Program Version Number | |
| TITLE | VARCHAR2 | (90) | Program Title | |
| PAYMENT_PERIODS_NUM | NUMBER | Payment Periods in a Academic Year | ||
| ENR_BEFORE_TS_CODE | VARCHAR2 | (30) | Enrollment Type Code Before Term Start | |
| ENR_BEFORE_TS_CODE_DESC | VARCHAR2 | (4000) | Enrollment Type Code Description Before Term Start | |
| ENR_IN_MT_CODE | VARCHAR2 | (30) | Enrollment Type in Mid Term | |
| ENR_IN_MT_CODE_DESC | VARCHAR2 | (4000) | Enrollment Type Code Description in Mid Term | |
| ENR_AFTER_TC_CODE | VARCHAR2 | (30) | Enrollment Type After Census Date | |
| ENR_AFTER_TC_CODE_DESC | VARCHAR2 | (4000) | Enrollment Type Code description After Census Date | |
| REP_ENTITY_ID_TXT | VARCHAR2 | (8) | Indicates Reporting Entity Id | |
| RESPONSE_OPTION_CODE | VARCHAR2 | (30) | Indicates Response Option Code | |
| RESPONSE_OPTION_CODE_DESC | VARCHAR2 | (4000) | Description for the Response Option Code | |
| FUNDING_METHOD_DESC | VARCHAR2 | (4000) | Funding Method Description | |
| TERM_START_OFFSET_NUM | NUMBER | Offset to move term start date backward or forward. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PELL_SEQ_ID
, REP_PELL_ID
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_ALTERNATE_CODE
, CI_START_DT
, CI_END_DT
, PELL_PROFILE
, BRANCH_CAMPUS
, ATTEND_CAMPUS_ID
, INST_CROSS_REF_CODE
, ACADEMIC_CAL
, ACAD_CAL_DESC
, PAYMENT_METHOD
, PYMT_METHOD_DESC
, WK_INST_TIME_CALC_PYMT
, WK_INT_TIME_PRG_DEF_YR
, CR_CLK_HRS_PRDS_SCH_YR
, CR_CLK_HRS_ACAD_YR
, FUNDING_METHOD
, USE_CENSUS_DTS
, LOW_TUTION_FEE
, ALT_COA_LIMIT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, EFC_MAX
, PELL_ALT_EXP_MAX
, COURSE_CD
, VERSION_NUMBER
, TITLE
, PAYMENT_PERIODS_NUM
, ENR_BEFORE_TS_CODE
, ENR_BEFORE_TS_CODE_DESC
, ENR_IN_MT_CODE
, ENR_IN_MT_CODE_DESC
, ENR_AFTER_TC_CODE
, ENR_AFTER_TC_CODE_DESC
, REP_ENTITY_ID_TXT
, RESPONSE_OPTION_CODE
, RESPONSE_OPTION_CODE_DESC
, FUNDING_METHOD_DESC
, TERM_START_OFFSET_NUM
FROM APPS.IGF_GR_PELL_SETUP_V;
APPS
IGF_AW_GEN
- show dependent code
IGF_GR_PELL_SETUP
IGS_CA_INST
IGS_PS_VER
APPS.IGF_GR_PELL_SETUP_V is not referenced by any database object
|
|
|
|