[Home] [Help] [Dependency Information]
Object Name: | IGFFV_FFELP_DISB_RESP_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGFFV_FFELP_DISB_RESP_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds FFELP Disbursement Response Details
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESP_DISBURSEMENT_DATE | DATE | Indicates disbursement date | ||
RESP_DISBURSEMENT_GROSS_AMT | NUMBER | (12) | Indicates disbursement gross amount | |
RESP_ORIGINATION_FEE | NUMBER | (12) | Indicates origination fee | |
RESP_GUARANTEE_FEE | NUMBER | (12) | Indicates guarantee fee | |
RESP_ORIGINATION_FEE_PAID | NUMBER | (12) | Indicates origination fee paid | |
RESP_GUARANTEE_FEE_PAID | NUMBER | (12) | Indicates guarantee fee paid | |
RESP_NET_DISBURSEMENT_AMT | NUMBER | (12) | Indicates net disbursement amount | |
_LA:RESP_HOLD_RELEASE_IND | CHAR | (78) | Indicates disbursement hold or release indicator | |
_LA:RESP_DISBURSEMNT_STATUS | CHAR | (68) | Indicates disbursement status | |
RESP_RECORD_INTERNAL_STATUS | VARCHAR2 | (30) | Keeps track of all records processed and successfully updated | |
LOAN_NUMBER | VARCHAR2 | (30) | Identifier for the loan | |
BORROWER_FIRST_NAME | VARCHAR2 | (150) | Borrower First Name | |
BORROWER_LAST_NAME | VARCHAR2 | (150) | Borrower Last Name | |
BORROWER_MIDDLE_NAME | VARCHAR2 | (150) | Borrower Middle Name | |
BORROWER_SSN | NUMBER | (9) | Borrower Social Security Number | |
RESPONSE_PARENT_ID | NUMBER | (15) | Yes | Identifier for CommonLine response @1 records from external processor |
RESP_DISBURSEMENT_NUMBER | NUMBER | (15) | Yes | Identifier for CommonLine response @8 records from external processor |
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 RESP_DISBURSEMENT_DATE
, RESP_DISBURSEMENT_GROSS_AMT
, RESP_ORIGINATION_FEE
, RESP_GUARANTEE_FEE
, RESP_ORIGINATION_FEE_PAID
, RESP_GUARANTEE_FEE_PAID
, RESP_NET_DISBURSEMENT_AMT
, _LA:RESP_HOLD_RELEASE_IND
, _LA:RESP_DISBURSEMNT_STATUS
, RESP_RECORD_INTERNAL_STATUS
, LOAN_NUMBER
, BORROWER_FIRST_NAME
, BORROWER_LAST_NAME
, BORROWER_MIDDLE_NAME
, BORROWER_SSN
, RESPONSE_PARENT_ID
, RESP_DISBURSEMENT_NUMBER
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM APPS.IGFFV_FFELP_DISB_RESP_DETAILS;
APPS.IGFFV_FFELP_DISB_RESP_DETAILS is not referenced by any database object
|
|
|