[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_STUDENT_FWS_AWAD_DETAILS |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_STUDENT_FWS_AWAD_DETAILS
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds Student Work Study Award Details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DISBURSEMENT_OFFERED_AMOUNT | NUMBER | Yes | Gross amount of the disbursement ( This will be the same as the offered amount ) | |
| DISBURSEMENT_ACCEPTED_AMOUNT | NUMBER | (13) | Disbursement Accepted Amount | |
| LOAD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Calendar type for the Term |
| LOAD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Term / Load calendar sequence number |
| LIMIT_NOTIFICATION_SENT | VARCHAR2 | (1) | Indicates whether a Notification was sent for the fund, in this term for the student. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund. | |
| LIMIT_NOTIFICATION_SENT_DATE | DATE | Date on which Notification was sent. A Notification is sent when the student's paid amount for the term increases the threshold as set for the Fund. | ||
| DISBURSEMENT_REMAINING_AMOUNT | NUMBER | Remaining amount to be paid | ||
| DISBURSEMENT_EARNED_TILL_DATE | NUMBER | (13) | Disbursement Paid amount | |
| TOTAL_PERCENT_EARNED_LIMIT | NUMBER | Percentage of amount paid | ||
| AUTHORIZATION_DATE | DATE | Date on which the Authorization was created or updated | ||
| AWARD_YEAR | VARCHAR2 | (10) | Awarding Year | |
| LOAD_CALENDAR | VARCHAR2 | (10) | Load Calendar | |
| FUND_CODE | VARCHAR2 | (30) | Yes | Fund Code |
| FUND_DESCRIPTION | VARCHAR2 | (80) | Fund Code Description | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
| FIRST_NAME | VARCHAR2 | (150) | Person First Name | |
| LAST_NAME | VARCHAR2 | (150) | Person Last Name | |
| MIDDLE_NAME | VARCHAR2 | (60) | Person Middle Name | |
| AWARD_CALENDAR_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit |
| AWARD_YEAR_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates unique identifier for award year calendar instance |
| AUTHORIZATION_ID | NUMBER | (15) | Unique Authorization Identifier. Authorization is a set of information of the student sent in context of student work study. There will be one authorization sent for a student, award of type FWS and Term | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
| BASE_ID | NUMBER | (10) | Yes | Unique identifier for student financial aid record |
| FUND_ID | NUMBER | (15) | Yes | Unique identifier for the fund |
| AWARD_ID | NUMBER | (15) | Yes | Identifier for awards |
| DISBURSEMENT_NUMBER | NUMBER | (15) | Yes | Identifier for disbursements |
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT DISBURSEMENT_OFFERED_AMOUNT
, DISBURSEMENT_ACCEPTED_AMOUNT
, LOAD_CALENDAR_TYPE
, LOAD_SEQUENCE_NUMBER
, LIMIT_NOTIFICATION_SENT
, LIMIT_NOTIFICATION_SENT_DATE
, DISBURSEMENT_REMAINING_AMOUNT
, DISBURSEMENT_EARNED_TILL_DATE
, TOTAL_PERCENT_EARNED_LIMIT
, AUTHORIZATION_DATE
, AWARD_YEAR
, LOAD_CALENDAR
, FUND_CODE
, FUND_DESCRIPTION
, PERSON_NUMBER
, FIRST_NAME
, LAST_NAME
, MIDDLE_NAME
, AWARD_CALENDAR_TYPE
, AWARD_YEAR_SEQUENCE_NUMBER
, AUTHORIZATION_ID
, PERSON_ID
, BASE_ID
, FUND_ID
, AWARD_ID
, DISBURSEMENT_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AW_AWARD_ALL
IGF_AW_AWD_DISB_ALL
IGF_AW_FUND_CAT_ALL
IGF_AW_FUND_MAST_ALL
IGS_CA_INST_ALL
APPS.IGFFV_STUDENT_FWS_AWAD_DETAILS is not referenced by any database object
|
|
|
|