DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGFFV_DL_PROM_NOTE_RESPONSES

Object Details
Object Name: IGFFV_DL_PROM_NOTE_RESPONSES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGFFV_DL_PROM_NOTE_RESPONSES
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Full View for the Entity that holds Financial Aid Direct Loan Promissory Note Responses


[View Source]

Columns
Name Datatype Length Mandatory Comments
DISBURSEMENT_GROSS_AMOUNT NUMBER (15)
First disbursement anticipated gross amount
PROM_NOTE_ACK_DATE DATE

Date of Direct Loan Promissory Note Acknowledgment by the LOC
PROM_NOTE_BATCH_ID VARCHAR2 (40) Yes Batch ID for the Promissory Note Batch
LOAN_NUMBER VARCHAR2 (30) Yes Loan Identifier
_LA:PROM_NOTE_STATUS CHAR (74)
Status of the paper promissory note with the LOC
_LA:PNOTE_REJECTION_REASONS CHAR (77)
Reason(s) the paper Promissory Note was rejected
MASTER_PROM_NOTE_INDICATOR VARCHAR2 (30)
Master Promissory Note Indicator
PROM_NOTE_ACCEPTED_AMOUNT NUMBER (15)
Accepted loan amount in Promissory Note
_LA:RECORD_STATUS CHAR (67)
Status of the record. Could be Y - Record Processed N - Record yet to be processed U - Record processed. Update not taken I - Invalid Loan Number
ELEC_MPN_INDICATOR VARCHAR2 (30)
Electronic Master Promissory Note Indicator
BATCH_FILE_ID VARCHAR2 (40) Yes Batch identifier for file created or loaded
BATCH_FILE_CREATION_DATE DATE
Yes Indicates date on which file was created
_LA:BATCH_REJECTION_CODE CHAR (69)
Indicates reason for Loan Origination Center rejecting entire batch. Values are duplicate batch identifier number, school code indicates non-direct loan participant, file contains non-ASCII keyboard printable characters, batch not processed, invalid message class, or not in use
BATCH_TYPE VARCHAR2 (30)
Indicates batch type, which was sent to Loan Origination Center or received from Loan Origination Center. Values are Stafford full origination, PLUS full origination, import PLUS credit decision, origination change, disbursement details, or booking notification from Loan Origination Center
BATCH_FILE_TYPE VARCHAR2 (30)
Indicate send file or response file
_LA:BATCH_STATUS CHAR (64)
Indicates all batches processed and successfully updated for internal tracking. Values are successfully updated, not updated loan origination record, or error response file not uploaded
BATCH_ID NUMBER (15) Yes Identifier for Direct Loan batch data
DISBURSEMENT_NUMBER NUMBER (15) Yes Disbursement Number
RESPONSE_RECORD_ID NUMBER (15) Yes Identifier for response records from the Direct Loan Promissory note acknowledgment file
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DISBURSEMENT_GROSS_AMOUNT
,      PROM_NOTE_ACK_DATE
,      PROM_NOTE_BATCH_ID
,      LOAN_NUMBER
,      _LA:PROM_NOTE_STATUS
,      _LA:PNOTE_REJECTION_REASONS
,      MASTER_PROM_NOTE_INDICATOR
,      PROM_NOTE_ACCEPTED_AMOUNT
,      _LA:RECORD_STATUS
,      ELEC_MPN_INDICATOR
,      BATCH_FILE_ID
,      BATCH_FILE_CREATION_DATE
,      _LA:BATCH_REJECTION_CODE
,      BATCH_TYPE
,      BATCH_FILE_TYPE
,      _LA:BATCH_STATUS
,      BATCH_ID
,      DISBURSEMENT_NUMBER
,      RESPONSE_RECORD_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGFFV_DL_PROM_NOTE_RESPONSES;

Dependencies

[top of page]

APPS.IGFFV_DL_PROM_NOTE_RESPONSES references the following:

SchemaAPPS
SynonymIGF_SL_DL_BATCH_ALL
SynonymIGF_SL_DL_PDET_RESP
SynonymIGF_SL_DL_PNOTE_RESP_ALL

APPS.IGFFV_DL_PROM_NOTE_RESPONSES is not referenced by any database object