[Home] [Help] [Dependency Information]
Object Name: | IGSBV_STUDENT_SPNSR_RELATIONS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_STUDENT_SPNSR_RELATIONS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Holds sponsor student relation details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar type for a term calendar |
LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence number for a term calendar |
TOTAL_SPONSOR_AMOUNT | NUMBER | Award amount that sponsor will pay to each student | ||
MINIMUM_CREDIT_POINTS | NUMBER | (6) | The minimum number of enrolled credit points the student must have prior to eligibility for sponsor fund disbursement | |
MINIMUM_ATTENDANCE_TYPE | VARCHAR2 | (30) | Minimum attendance type the student must have prior to eligibility for sponsor fund disbursement. | |
PERSON_NUMBER | VARCHAR2 | (30) | Yes | Number of student receiving sponsor fund |
PERSON_NAME | VARCHAR2 | (360) | Yes | Name of student receiving sponsor fund |
LOAD_CAL_START_EFFECTIVE_DATE | DATE | Yes | Date from which a term calendar instance becomes effective. | |
LOAD_CAL_END_EFFECTIVE_DATE | DATE | Yes | Date from which a term calendar instance is no longer effective | |
LOAD_CALENDAR_TYPE_DESCRIPTION | VARCHAR2 | (30) | Description of term calendar used within the institution. | |
LOAD_CALENDAR_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate code of term calendar | |
AWARD_YEAR_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. |
AWARD_YR_CAL_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Award year calendar sequence number |
AWARD_YR_START_EFFECTIVE_DATE | DATE | Yes | Date from which an award calendar instance becomes effective. | |
AWARD_YR_END_EFFECTIVE_DATE | DATE | Yes | Date from which an award calendar instance is no longer effective | |
AWARD_YR_CALENDAR_DESCRIPTION | VARCHAR2 | (30) | Description of award calendar used within the institution. | |
AWARD_YR_CAL_ALTERNATE_CODE | VARCHAR2 | (10) | Alternate code of award year calendar | |
FUND_CODE | VARCHAR2 | (30) | Yes | Identifier of fund defined in fund category table |
FUND_DESCRIPTION | VARCHAR2 | (80) | Description of fund defined in fund category table | |
SPONSOR_STUDENT_IDENTIFIER | NUMBER | (15) | Yes | Unique sequence generated number, gets value from IGF_SP_STDNT_REL_S |
FUND_IDENTIFIER | NUMBER | (15) | Yes | Unique identifier for a fund |
BASE_IDENTIFIER | NUMBER | (15) | Yes | Unique identifier for person award year combination |
PERSON_IDENTIFIER | NUMBER | (15) | Yes | Person identifier of student receiving sponsor fund |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT LOAD_CALENDAR_TYPE
, LOAD_SEQUENCE_NUMBER
, TOTAL_SPONSOR_AMOUNT
, MINIMUM_CREDIT_POINTS
, MINIMUM_ATTENDANCE_TYPE
, PERSON_NUMBER
, PERSON_NAME
, LOAD_CAL_START_EFFECTIVE_DATE
, LOAD_CAL_END_EFFECTIVE_DATE
, LOAD_CALENDAR_TYPE_DESCRIPTION
, LOAD_CALENDAR_ALTERNATE_CODE
, AWARD_YEAR_CALENDAR_TYPE
, AWARD_YR_CAL_SEQUENCE_NUMBER
, AWARD_YR_START_EFFECTIVE_DATE
, AWARD_YR_END_EFFECTIVE_DATE
, AWARD_YR_CALENDAR_DESCRIPTION
, AWARD_YR_CAL_ALTERNATE_CODE
, FUND_CODE
, FUND_DESCRIPTION
, SPONSOR_STUDENT_IDENTIFIER
, FUND_IDENTIFIER
, BASE_IDENTIFIER
, PERSON_IDENTIFIER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
FROM APPS.IGSBV_STUDENT_SPNSR_RELATIONS;
APPS.IGSBV_STUDENT_SPNSR_RELATIONS is not referenced by any database object
|
|
|