[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AW_AWD_DISB_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AW_AWD_DISB_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_AW_AWD_DISB_ALL displays details of each disbursement.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AW_AWD_DISB_ALL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 AWARD_ID
DISB_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| AWARD_ID | NUMBER | (15) | Yes | Identifier for awards |
| DISB_NUM | NUMBER | (15) | Yes | Identifier for disbursements |
| TP_CAL_TYPE | VARCHAR2 | (10) | Indicates code for teaching period calender type. Used within operating unit. | |
| TP_SEQUENCE_NUMBER | NUMBER | (6) | Indicates unique identifier for teaching calendar instance | |
| DISB_GROSS_AMT | NUMBER | Yes | Gross amount of the disbursement ( This will be the same as the offered amount ) | |
| FEE_1 | NUMBER | Origination fees in case of Direct Loan lender fees or CommonLine | ||
| FEE_2 | NUMBER | Guarantor fees in case of CommonLine | ||
| DISB_NET_AMT | NUMBER | Yes | Disbursement net amount( DISB_GROSS_AMT - FEE_1 - FEE_2 + FEE_PAID_1 + FEE_PAID_2) | |
| DISB_DATE | DATE | Yes | Disbursement date | |
| TRANS_TYPE | VARCHAR2 | (30) | Yes | Indicates if transaction type is planned or actual |
| ELIG_STATUS | VARCHAR2 | (30) | Indicates student's eligibility status at time of disbursement | |
| ELIG_STATUS_DATE | DATE | Indicates date on which eligibility check was done | ||
| AFFIRM_FLAG | VARCHAR2 | (30) | Indicates whether student has confirmed for disbursement | |
| HOLD_REL_IND | VARCHAR2 | (30) | Indicates hold or release for disbursemnent | |
| MANUAL_HOLD_IND | VARCHAR2 | (30) | Used by disbursements to hold up disbursements | |
| DISB_STATUS | VARCHAR2 | (30) | Indicates disbursement status for CommonLine loans | |
| DISB_STATUS_DATE | DATE | Disbursement status date | ||
| LATE_DISB_IND | VARCHAR2 | (30) | Indicates when disbursement is issued. Updated from CommonLine roster file. | |
| FUND_DIST_MTHD | VARCHAR2 | (1) | Indicates method used to release funds. Updated from CommonLine roster file. | |
| PREV_REPORTED_IND | VARCHAR2 | (30) | Indicates if disbursement was indicated on previous disbursement roster | |
| FUND_RELEASE_DATE | DATE | Indicates date on which funds are released to school | ||
| FUND_STATUS | VARCHAR2 | (30) | Indicates whether funds have been transferred for disbursement. Updated from CommonLine roster file. | |
| FUND_STATUS_DATE | DATE | Date on which disbursement roster was updated | ||
| FEE_PAID_1 | NUMBER | Origination fees paid | ||
| FEE_PAID_2 | NUMBER | Guarantee fees paid | ||
| CHEQUE_NUMBER | VARCHAR2 | (30) | Check number | |
| 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 | |
| REQUEST_ID | NUMBER | (15) | Standard Who column for concurrent programs | |
| 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 | ||
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| LD_CAL_TYPE | VARCHAR2 | (10) | Yes | Calendar type for the Term |
| LD_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Term / Load calendar sequence number |
| DISB_ACCEPTED_AMT | NUMBER | (13) | Disbursement Accepted Amount | |
| DISB_PAID_AMT | NUMBER | (13) | Disbursement Paid amount | |
| RVSN_ID | NUMBER | (15) | Revision Code referenced from Revision Table | |
| INT_REBATE_AMT | NUMBER | (15) | Interest rebate amount as calculated for the loan amount | |
| FORCE_DISB | VARCHAR2 | (30) | Indicates if the disbursement was forced. | |
| MIN_CREDIT_PTS | NUMBER | (7) | Indicates the minimum credit point requirement for the disbursement | |
| DISB_EXP_DT | DATE | Indicates the date on which the disbursement will expire | ||
| VERF_ENFR_DT | DATE | Indicates the date on which the verification should be enforced | ||
| NOTIFICATION_SENT | VARCHAR2 | (1) | No longer used. | |
| NOTIFICATION_DATE | DATE | No longer used. | ||
| AUTH_ID | NUMBER | (15) | No longer used. | |
| AUTH_DATE | DATE | No longer used. | ||
| FEE_CLASS | VARCHAR2 | (30) | Pays only fee class - system defined lookups - TUITION, COURSE, STUDENT, INSTITUTION, HOUSING and BOOKS. | |
| SHOW_ON_BILL | VARCHAR2 | (30) | Indicates if the notification should be shown on the bill. | |
| ATTENDANCE_TYPE_CODE | VARCHAR2 | (30) | Minimum qualifying attendance type for disbursement | |
| BASE_ATTENDANCE_TYPE_CODE | VARCHAR2 | (30) | Attendance Type of the disbursement when disbursement is created/modified. | |
| CHANGE_TYPE_CODE | VARCHAR2 | (30) | Change Type Code for CommonLine Disbursement Change Record | |
| PAYMENT_PRD_ST_DATE | DATE | Starting date of the Payment period | ||
| FUND_RETURN_MTHD_CODE | VARCHAR2 | (30) | Fund Return Method Code for CommonLine Disbursement Change Record | |
| DIRECT_TO_BORR_FLAG | VARCHAR2 | (1) | Direct Disbursement to Borrower Indicator |
Cut, paste (and edit) the following text to query this object:
SELECT AWARD_ID
, DISB_NUM
, TP_CAL_TYPE
, TP_SEQUENCE_NUMBER
, DISB_GROSS_AMT
, FEE_1
, FEE_2
, DISB_NET_AMT
, DISB_DATE
, TRANS_TYPE
, ELIG_STATUS
, ELIG_STATUS_DATE
, AFFIRM_FLAG
, HOLD_REL_IND
, MANUAL_HOLD_IND
, DISB_STATUS
, DISB_STATUS_DATE
, LATE_DISB_IND
, FUND_DIST_MTHD
, PREV_REPORTED_IND
, FUND_RELEASE_DATE
, FUND_STATUS
, FUND_STATUS_DATE
, FEE_PAID_1
, FEE_PAID_2
, CHEQUE_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, LD_CAL_TYPE
, LD_SEQUENCE_NUMBER
, DISB_ACCEPTED_AMT
, DISB_PAID_AMT
, RVSN_ID
, INT_REBATE_AMT
, FORCE_DISB
, MIN_CREDIT_PTS
, DISB_EXP_DT
, VERF_ENFR_DT
, NOTIFICATION_SENT
, NOTIFICATION_DATE
, AUTH_ID
, AUTH_DATE
, FEE_CLASS
, SHOW_ON_BILL
, ATTENDANCE_TYPE_CODE
, BASE_ATTENDANCE_TYPE_CODE
, CHANGE_TYPE_CODE
, PAYMENT_PRD_ST_DATE
, FUND_RETURN_MTHD_CODE
, DIRECT_TO_BORR_FLAG
FROM IGF.IGF_AW_AWD_DISB_ALL;
IGF.IGF_AW_AWD_DISB_ALL does not reference any database object
IGF.IGF_AW_AWD_DISB_ALL is referenced by following:
APPS
IGF_AW_AWD_DISB_ALL
|
|
|
|