[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_FFELP_ORIG_RESPONSES |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_FFELP_ORIG_RESPONSES
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds FFELP Origination Response Details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CL_RECORD_CODE | VARCHAR2 | (2) | Yes | Indicates record types |
| RECORD_TYPE_INDICATOR | VARCHAR2 | (30) | Yes | Indicates if record is school certification request, modification response after first notification of guarantee, reprint response, change transaction send response, application response up to first notification of guarantee, or service provider does not support change transaction |
| BORROWER_FIRST_NAME | VARCHAR2 | (150) | Borrower First Name | |
| BORROWER_LAST_NAME | VARCHAR2 | (150) | Indicates borrower's last name | |
| BORROWER_MIDDLE_NAME | VARCHAR2 | (150) | Indicates borrower's middle name | |
| BORROWER_SSN | NUMBER | (9) | Indicates borrower's SSN | |
| BORROWER_PERMT_ADDRESS_LINE_1 | VARCHAR2 | (240) | Indicates borrower's permanent address line 1 | |
| BORROWER_PERMT_ADDRESS_LINE_2 | VARCHAR2 | (240) | Indicates borrower's permanent address line 2 | |
| BORROWER_PERMT_CITY | VARCHAR2 | (60) | Indicates borrower's permanent city | |
| BORROWER_PERMT_STATE | VARCHAR2 | (60) | Indicates borrower's permanent state | |
| BORROWER_PERMT_ZIP | NUMBER | (30) | Indicates borrower's permanent zip code | |
| BORROWER_PERMT_ZIP_SUFFIX | NUMBER | (30) | Indicates borrower's permanent zip code suffix | |
| BORROWER_PERMT_PHONE | VARCHAR2 | (60) | Indicates borrower's telephone number | |
| BORROWER_DATE_OF_BIRTH | DATE | Indicates borrower's date of birth | ||
| LOAN_TYPE | VARCHAR2 | (30) | Indicates CommonLine loan type requested by the borrower | |
| REQUESTED_LOAN_AMOUNT | NUMBER | (12) | Indicates requested loan amount | |
| DEFERED_REQUEST_CODE | VARCHAR2 | (30) | Indicates deferment request code | |
| BORROWER_INTEREST_INDICATOR | VARCHAR2 | (30) | Indicates whether the borrower intends to pay interest on loan while in school, grace, or deferment | |
| EFT_AUTHORIZATION_CODE | VARCHAR2 | (30) | Indicates EFT authorization code | |
| BORROWER_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates borrower signature code | |
| BORROWER_SIGNATURE_DATE | DATE | Indicates borrower signature date | ||
| LOAN_NUMBER | VARCHAR2 | (30) | Indicates unique identifier identifying CommonLine loan application | |
| CL_SEQUENCE_NUMBER | NUMBER | (15) | Indicates the value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for CommonLine loan | |
| _LA:BORR_CITIZENSHIP_STATUS | CHAR | (79) | Indicates U.S. citizenship status code of PLUS or alternative borrower | |
| BORROWR_LEGAL_RESIDENCE_STATE | VARCHAR2 | (30) | Indicates state of legal residence of PLUS borrower | |
| BORROWR_LEGAL_RESIDENCE_DATE | DATE | Indicates date when PLUS borrower took up legal residence | ||
| _LA:BORROWER_DEFAULT_STATUS | CHAR | (75) | Indicates default or refund status code of PLUS or alternative borrower | |
| BORROWER_OUTSTANDIN_LOAN_CODE | VARCHAR2 | (30) | Indicates outstanding loan code of PLUS borrower | |
| BORROWER_INDICATOR_CODE | VARCHAR2 | (30) | Indicates alternative student or borrower indicator code | |
| STUDENT_LAST_NAME | VARCHAR2 | (150) | Indicates student's last name | |
| STUDENT_FIRST_NAME | VARCHAR2 | (60) | Indicates student's first name | |
| STUDENT_MIDDLE_NAME | VARCHAR2 | (150) | Indicates student's middle name | |
| STUDENT_SSN | NUMBER | (9) | Indicates student's SSN | |
| STUDENT_DATE_OF_BIRTH | DATE | Indicates student's date of birth | ||
| _LA:STUDENT_CITIZEN_STATUS | CHAR | (79) | Indicates U.S. citizenship status code of student | |
| _LA:STUDENT_DEFAULT_CODE | CHAR | (73) | Indicates student's default code | |
| STUDENT_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates student's signature code | |
| LOAN_PERIOD_BEGIN_DATE | DATE | Indicates loan period begin date | ||
| LOAN_PERIOD_END_DATE | DATE | Indicates loan period end date | ||
| _LA:GRADE_LEVEL_CODE | CHAR | (70) | Indicates grade level code of the student at the time the loan was originated | |
| _LA:ENROLLMENT_CODE | CHAR | (73) | Indicates enrollment status code | |
| ANTICIPATED_COMPLETION_DATE | DATE | Indicates date student is anticipated to complete program at school | ||
| COST_OF_ATTENDANCE_AMOUNT | NUMBER | (12) | Indicates cost of attendance | |
| EXPECTED_FAMILY_CONTRIB_AMT | NUMBER | (12) | Indicates EFC amount | |
| ESTABLISHED_FINANCIAL_AID_AMT | NUMBER | (12) | Indicates estimated financial aid amount | |
| STAF_SUBSIDIZED_CERTIFIED_AMT | NUMBER | (12) | Indicates subsidized federal Stafford certified amount | |
| STAF_UNSUBSIDIZ_CERTIFIED_AMT | NUMBER | (12) | Indicates unsubsidized federal Stafford certified amount | |
| STAFF_PLUS_CERTIFIED_AMT | NUMBER | (12) | Indicates federal PLUS certified amount | |
| SCHOOL_CERTIFICATION_DATE | DATE | Indicates school certification date | ||
| ALTERNATIV_LOAN_CERTIFIED_AMT | NUMBER | (12) | Indicates alternative loan certified amount | |
| ALT_APPLICATION_VERSION_CODE | NUMBER | (30) | Indicates alternative loan application version code | |
| LENDER_ID | VARCHAR2 | (30) | Identifier for lender | |
| STAF_SUBSIDIZED_APPROVED_AMT | NUMBER | (12) | Indicates subsidized federal Stafford approved amount | |
| STAF_UNSUBSIDIZ_APPROVED_AMT | NUMBER | (12) | Indicates unsubsidized federal Stafford approved amount | |
| STAFF_PLUS_APPROVED_AMT | NUMBER | (12) | Indicates federal PLUS approved amount | |
| ALTERNATIVE_LOAN_APPROVED_AMT | NUMBER | (12) | Indicates alternative loan approved amount | |
| GUARANTOR_ID | VARCHAR2 | (30) | Identifier for guarantor | |
| FEDERAL_APPLICATION_FORM_CODE | VARCHAR2 | (30) | Indicates federal application form code | |
| LENDER_BLANKET_GUARANTEE_IND | VARCHAR2 | (30) | Indicates lender blanket guarantee indicator code | |
| LENDER_BLKT_GUARNT_APRVD_DATE | DATE | Indicates lender blanket guarantee approval date | ||
| GUARNTEE_ADJUSTED_INDICATOR | VARCHAR2 | (30) | Indicates guarantee adjustment indicator code | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARANTEE_AMT | NUMBER | (12) | Indicates guarantee amount | |
| _LA:REQUEST_SERIAL_LOAN_CODE | CHAR | (79) | Indicates requested serial loan code | |
| BORROWER_CONFIRM_INDICATOR | VARCHAR2 | (30) | Indicates borrower's confirmation of loan | |
| BORROWER_LICENSE_STATE | VARCHAR2 | (30) | Indicates borrower driver's license state | |
| BORROWER_LICENSE_NUMBER | VARCHAR2 | (30) | Indicates borrower driver's license number | |
| BORROWER_REFERENCE_CODE | VARCHAR2 | (30) | Indicates borrower references code | |
| _LA:PROM_NOTE_DELIVERY_CODE | CHAR | (76) | Indicates promissory note delivery code | |
| BORROWER_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Indicates permanent foreign postal code | |
| LENDER_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates unique identification code assigned by entity other than US Department of Education to lender's branch office | |
| LAST_RESORT_LENDER | VARCHAR2 | (30) | Indicates whether the lender is an eligible lender of the last resort for which the value will be updated by the service provider | |
| RESPONSE_TO_ORIGINATION_CODE | VARCHAR2 | (30) | Indicates response to originator code | |
| RESPONSE_ERROR_MESSAGE_CODE_1 | VARCHAR2 | (30) | Indicates application send error message code 1 | |
| RESPONSE_ERROR_MESSAGE_CODE_2 | VARCHAR2 | (30) | Indicates application send error message code 2 | |
| RESPONSE_ERROR_MESSAGE_CODE_3 | VARCHAR2 | (30) | Indicates application send error message code 3 | |
| RESPONSE_ERROR_MESSAGE_CODE_4 | VARCHAR2 | (30) | Indicates application send error message code 4 | |
| RESPONSE_ERROR_MESSAGE_CODE_5 | VARCHAR2 | (30) | Indicates application send error message code 5 | |
| _LA:GUARNTEE_AMT_REDUN_CODE | CHAR | (82) | Indicates guarantee amount reduction code | |
| TOTAL_OUTSTANDIN_STAFFORD_AMT | NUMBER | (12) | Indicates total outstanding federal Stafford or subsidized loan Stafford loan amount | |
| TOTAL_OUTSTANDIN_PLUS_AMOUNT | NUMBER | (12) | Indicates total outstanding federal PLUS loan amount | |
| ALTERNATIVE_PROGRAM_TYPE_CODE | VARCHAR2 | (30) | Indicates alternative loan program type code | |
| ALTERNATIVE_BORROW_TOTAL_DEBT | NUMBER | (15) | Indicates total debt of alternative loan for borrower | |
| ACTUAL_INTEREST_RATE | NUMBER | (6) | Indicates actual interest rate | |
| _LA:PROCESSING_TYPE_CODE | CHAR | (69) | Indicates processing type code | |
| _LA:SERVICER_TYPE_CODE | CHAR | (70) | Indicates service type code | |
| REVISED_NOTICE_OF_GUARNTEE | VARCHAR2 | (30) | Indicates revised notice of guarantee indicator code | |
| SCHEDULED_REFUND_AMOUNT | NUMBER | (12) | Indicates school post-withdrawal return amount | |
| SCHEDULED_REFUND_DATE | DATE | Indicates date of post-withdrawal return to lender | ||
| _LA:GUARNTEE_STATUS_CODE | CHAR | (74) | Indicates guarantor status code | |
| _LA:LENDER_STATUS_CODE | CHAR | (72) | Indicates lender-servicer status code | |
| _LA:PROM_NOTE_STATUS_CODE | CHAR | (72) | Indicates promissory note status code | |
| _LA:CREDIT_STATUS_CODE | CHAR | (76) | Indicates credit status code | |
| GUARNTEE_STATUS_DATE | DATE | Indicates guarantor status date or time stamp | ||
| LENDER_STATUS_DATE | DATE | Indicates lender-servicer status date or time stamp | ||
| PROMISSORY_NOTE_STATUS_DATE | DATE | Indicates promissory note status date or time stamp | ||
| CREDIT_STATUS_DATE | DATE | Indicates credit status date or time stamp | ||
| _LA:ACTUAL_SERIAL_LOAN_CODE | CHAR | (83) | Indicates actual serial loan code | |
| REINSTATEMENT_AMOUNT | NUMBER | (12) | Indicates amount available for reinstatement | |
| SCHOOL_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates unique identification code assigned by entity other than US Department of Education to school's branch office | |
| UNIQ_LAYOUT_VENDER_CODE | VARCHAR2 | (30) | Indicates unique layout vendor code | |
| UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | Indicates unique layout identifier code | |
| INTERNAL_RESP_RECORD_STATUS | VARCHAR2 | (30) | Indicates all records that are processed and successfully updated for internal tracking | |
| BORROWER_SIGN_INDICATOR | VARCHAR2 | (30) | Borrower Signature Indicator | |
| STUDENT_SIGN_INDICATOR | VARCHAR2 | (30) | Student Signature Indicator | |
| BORROWER_CREDIT_AUTH_CODE | VARCHAR2 | (30) | Borrower Credit Authorization Code | |
| BATCH_ID | VARCHAR2 | (40) | Indicates batch identifier for file created or loaded | |
| FILE_CREATION_DATE | DATE | Indicates date on which file was created | ||
| FILE_TRANSMISSION_DATE | DATE | Indicates date on which file is transmitted | ||
| FILE_IDENTIFIER_CODE | VARCHAR2 | (30) | Indicates type of data in file, production or test, and file version | |
| RECIPIENT_ID | VARCHAR2 | (30) | Indicates lender identifier or service provider, who receives file, in case of send file and school identifier for response files | |
| RECIPIENT_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates non-ED branch of recipient as in header | |
| SOURCE_ID | VARCHAR2 | (30) | Indicates school identifier, who receives file in case of send file and lender identifier, or service provider's identifier in header in case of response files | |
| SOURCE_NON_ED_BRANCH_ID | VARCHAR2 | (30) | Indicates non ed branch of source as in header | |
| SCHOOL_ID | NUMBER | (15) | Indicates school identifier | |
| INTERNAL_RESPONSE_BATCH_ID | NUMBER | (15) | Yes | Identifier for batch |
| INTERNAL_RESPONSE_UNIQUE_ID | NUMBER | (15) | Yes | Identifier for CommonLine response |
| 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 | |
| B_ALIEN_REG_NUM_TXT | VARCHAR2 | (30) | Borrower Alien Registration Number | |
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT CL_RECORD_CODE
, RECORD_TYPE_INDICATOR
, BORROWER_FIRST_NAME
, BORROWER_LAST_NAME
, BORROWER_MIDDLE_NAME
, BORROWER_SSN
, BORROWER_PERMT_ADDRESS_LINE_1
, BORROWER_PERMT_ADDRESS_LINE_2
, BORROWER_PERMT_CITY
, BORROWER_PERMT_STATE
, BORROWER_PERMT_ZIP
, BORROWER_PERMT_ZIP_SUFFIX
, BORROWER_PERMT_PHONE
, BORROWER_DATE_OF_BIRTH
, LOAN_TYPE
, REQUESTED_LOAN_AMOUNT
, DEFERED_REQUEST_CODE
, BORROWER_INTEREST_INDICATOR
, EFT_AUTHORIZATION_CODE
, BORROWER_SIGNATURE_CODE
, BORROWER_SIGNATURE_DATE
, LOAN_NUMBER
, CL_SEQUENCE_NUMBER
, _LA:BORR_CITIZENSHIP_STATUS
, BORROWR_LEGAL_RESIDENCE_STATE
, BORROWR_LEGAL_RESIDENCE_DATE
, _LA:BORROWER_DEFAULT_STATUS
, BORROWER_OUTSTANDIN_LOAN_CODE
, BORROWER_INDICATOR_CODE
, STUDENT_LAST_NAME
, STUDENT_FIRST_NAME
, STUDENT_MIDDLE_NAME
, STUDENT_SSN
, STUDENT_DATE_OF_BIRTH
, _LA:STUDENT_CITIZEN_STATUS
, _LA:STUDENT_DEFAULT_CODE
, STUDENT_SIGNATURE_CODE
, LOAN_PERIOD_BEGIN_DATE
, LOAN_PERIOD_END_DATE
, _LA:GRADE_LEVEL_CODE
, _LA:ENROLLMENT_CODE
, ANTICIPATED_COMPLETION_DATE
, COST_OF_ATTENDANCE_AMOUNT
, EXPECTED_FAMILY_CONTRIB_AMT
, ESTABLISHED_FINANCIAL_AID_AMT
, STAF_SUBSIDIZED_CERTIFIED_AMT
, STAF_UNSUBSIDIZ_CERTIFIED_AMT
, STAFF_PLUS_CERTIFIED_AMT
, SCHOOL_CERTIFICATION_DATE
, ALTERNATIV_LOAN_CERTIFIED_AMT
, ALT_APPLICATION_VERSION_CODE
, LENDER_ID
, STAF_SUBSIDIZED_APPROVED_AMT
, STAF_UNSUBSIDIZ_APPROVED_AMT
, STAFF_PLUS_APPROVED_AMT
, ALTERNATIVE_LOAN_APPROVED_AMT
, GUARANTOR_ID
, FEDERAL_APPLICATION_FORM_CODE
, LENDER_BLANKET_GUARANTEE_IND
, LENDER_BLKT_GUARNT_APRVD_DATE
, GUARNTEE_ADJUSTED_INDICATOR
, GUARANTEE_DATE
, GUARANTEE_AMT
, _LA:REQUEST_SERIAL_LOAN_CODE
, BORROWER_CONFIRM_INDICATOR
, BORROWER_LICENSE_STATE
, BORROWER_LICENSE_NUMBER
, BORROWER_REFERENCE_CODE
, _LA:PROM_NOTE_DELIVERY_CODE
, BORROWER_FOREIGN_POSTAL_CODE
, LENDER_NON_ED_BRANCH_ID
, LAST_RESORT_LENDER
, RESPONSE_TO_ORIGINATION_CODE
, RESPONSE_ERROR_MESSAGE_CODE_1
, RESPONSE_ERROR_MESSAGE_CODE_2
, RESPONSE_ERROR_MESSAGE_CODE_3
, RESPONSE_ERROR_MESSAGE_CODE_4
, RESPONSE_ERROR_MESSAGE_CODE_5
, _LA:GUARNTEE_AMT_REDUN_CODE
, TOTAL_OUTSTANDIN_STAFFORD_AMT
, TOTAL_OUTSTANDIN_PLUS_AMOUNT
, ALTERNATIVE_PROGRAM_TYPE_CODE
, ALTERNATIVE_BORROW_TOTAL_DEBT
, ACTUAL_INTEREST_RATE
, _LA:PROCESSING_TYPE_CODE
, _LA:SERVICER_TYPE_CODE
, REVISED_NOTICE_OF_GUARNTEE
, SCHEDULED_REFUND_AMOUNT
, SCHEDULED_REFUND_DATE
, _LA:GUARNTEE_STATUS_CODE
, _LA:LENDER_STATUS_CODE
, _LA:PROM_NOTE_STATUS_CODE
, _LA:CREDIT_STATUS_CODE
, GUARNTEE_STATUS_DATE
, LENDER_STATUS_DATE
, PROMISSORY_NOTE_STATUS_DATE
, CREDIT_STATUS_DATE
, _LA:ACTUAL_SERIAL_LOAN_CODE
, REINSTATEMENT_AMOUNT
, SCHOOL_NON_ED_BRANCH_ID
, UNIQ_LAYOUT_VENDER_CODE
, UNIQ_LAYOUT_IDENT_CODE
, INTERNAL_RESP_RECORD_STATUS
, BORROWER_SIGN_INDICATOR
, STUDENT_SIGN_INDICATOR
, BORROWER_CREDIT_AUTH_CODE
, BATCH_ID
, FILE_CREATION_DATE
, FILE_TRANSMISSION_DATE
, FILE_IDENTIFIER_CODE
, RECIPIENT_ID
, RECIPIENT_NON_ED_BRANCH_ID
, SOURCE_ID
, SOURCE_NON_ED_BRANCH_ID
, SCHOOL_ID
, INTERNAL_RESPONSE_BATCH_ID
, INTERNAL_RESPONSE_UNIQUE_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, B_ALIEN_REG_NUM_TXT
, ESIGN_SRC_TYP_CD
FROM APPS.IGFFV_FFELP_ORIG_RESPONSES;
APPS
IGF_SL_CL_BATCH_ALL
IGF_SL_CL_RESP_R1_ALL
APPS.IGFFV_FFELP_ORIG_RESPONSES is not referenced by any database object
|
|
|
|