[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_LOR_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_SL_LOR_V |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
ORIGINATION_ID | NUMBER | (15) | Yes | |
LOAN_ID | NUMBER | (15) | Yes | |
AWARD_ID | NUMBER | (15) | Yes | |
STUDENT_ID | NUMBER | (15) | Yes | |
FUND_ID | NUMBER | (15) | Yes | |
SEQ_NUM | NUMBER | (15) | ||
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates the code for the award year calender type, used within the operating unit |
CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Indicates a unique identifier for the award year calender instance |
CI_START_DT | DATE | Yes | Indicates the award year start date | |
CI_END_DT | DATE | Yes | Indicates the award year end date | |
CI_ALTERNATE_CODE | VARCHAR2 | (10) | Indicates the alternate short reference code for identifying a award year calendar instance | |
LOAN_TYPE | VARCHAR2 | (30) | Yes | |
LOAN_TYPE_NUM | VARCHAR2 | (70) | ||
FUND_SOURCE | VARCHAR2 | (30) | Yes | |
FUND_TYPE | VARCHAR2 | (30) | Yes | |
SYS_FUND_TYPE | VARCHAR2 | (30) | Yes | |
FED_FUND_CODE | VARCHAR2 | (30) | Yes | |
LOAN_NUMBER | VARCHAR2 | (30) | ||
SCH_CERT_DATE | DATE | |||
ORIG_STATUS_FLAG | VARCHAR2 | (30) | ||
ORIG_BATCH_ID | VARCHAR2 | (40) | ||
ORIG_BATCH_DATE | DATE | |||
CHG_BATCH_ID | VARCHAR2 | (0) | Obsolete | |
ORIG_ACK_DATE | DATE | |||
CREDIT_OVERRIDE | VARCHAR2 | (30) | ||
CREDIT_DECISION_DATE | DATE | |||
REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | ||
ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | ||
PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | ||
PNOTE_STATUS | VARCHAR2 | (30) | ||
PNOTE_STATUS_DESC | VARCHAR2 | (4000) | ||
PNOTE_STATUS_DATE | DATE | |||
PNOTE_ID | VARCHAR2 | (30) | Master Promissory Note Identification. The Master Promissory Note (MPN) Identifier printed on the Master Promissory Note. This MPN ID is used by COD to link PLUS loans to this Master Promissory Note | |
PNOTE_PRINT_IND | VARCHAR2 | (30) | ||
PNOTE_ACCEPT_AMT | NUMBER | (12) | Endorser Amount, this is populated by the Credit Response | |
PNOTE_ACCEPT_DATE | DATE | |||
PNOTE_BATCH_ID | VARCHAR2 | (40) | ||
PNOTE_ACK_DATE | DATE | |||
PNOTE_MPN_IND | VARCHAR2 | (30) | The Master Promissory Note indicator is used to indicate whether or not the LOR has been linked to a MPN at COD. Y = LOR has been linked to a MPN at COD, N = LOR is not linked to a MPN on file at COD | |
UNSUB_ELIG_FOR_HEAL | VARCHAR2 | (30) | ||
DISCLOSURE_PRINT_IND | VARCHAR2 | (30) | ||
ORIG_FEE_PERCT | NUMBER | (6) | ||
BORW_CONFIRM_IND | VARCHAR2 | (30) | ||
BORW_INTEREST_IND | VARCHAR2 | (30) | ||
BORW_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | ||
UNSUB_ELIG_FOR_DEPNT | VARCHAR2 | (30) | ||
GUARANTEE_AMT | NUMBER | (12) | ||
GUARANTEE_DATE | DATE | |||
GUARNT_AMT_REDN_CODE | VARCHAR2 | (10) | ||
GUARNT_STATUS_CODE | VARCHAR2 | (30) | ||
GUARNT_STATUS_DATE | DATE | |||
LEND_APPRV_DENIED_CODE | VARCHAR2 | (30) | A 1-character code indicating if the lender approved or denied the loan. A = Approved D = Denied | |
LEND_APPRV_DENIED_DATE | DATE | The date the lender approved or denied the loan | ||
LEND_STATUS_CODE | VARCHAR2 | (30) | ||
LEND_STATUS_DATE | DATE | |||
GUARNT_ADJ_IND | VARCHAR2 | (30) | ||
GRADE_LEVEL_CODE | VARCHAR2 | (30) | ||
ENROLLMENT_CODE | VARCHAR2 | (30) | ||
ANTICIP_COMPL_DATE | DATE | |||
BORW_LENDER_ID | VARCHAR2 | (30) | ||
DUNS_BORW_LENDER_ID | VARCHAR2 | (0) | Obsolete | |
GUARANTOR_ID | VARCHAR2 | (30) | ||
DUNS_GUARNT_ID | VARCHAR2 | (0) | Obsolete | |
PRC_TYPE_CODE | VARCHAR2 | (30) | ||
CL_SEQ_NUMBER | NUMBER | (15) | ||
LAST_RESORT_LENDER | VARCHAR2 | (30) | ||
LENDER_ID | VARCHAR2 | (30) | ||
DUNS_LENDER_ID | VARCHAR2 | (0) | Obsolete | |
LEND_NON_ED_BRC_ID | VARCHAR2 | (30) | ||
RECIPIENT_ID | VARCHAR2 | (30) | ||
RECIPIENT_TYPE | VARCHAR2 | (30) | ||
DUNS_RECIP_ID | VARCHAR2 | (0) | Obsolete | |
RECIP_NON_ED_BRC_ID | VARCHAR2 | (30) | ||
REC_TYPE_IND | VARCHAR2 | (30) | ||
CL_LOAN_TYPE | VARCHAR2 | (30) | ||
CL_REC_STATUS | VARCHAR2 | (30) | Loan Record Status Code. This is applicable only for CommonLine Release 4 Records. | |
CL_REC_STATUS_LAST_UPDATE | DATE | Date when Loan Record Status Code was last updated. This is applicable only for CommonLine Release 4 Records | ||
ALT_PROG_TYPE_CODE | VARCHAR2 | (30) | ||
ALT_APPL_VER_CODE | NUMBER | (15) | ||
MPN_CONFIRM_CODE | VARCHAR2 | (30) | MPN Confirmation Code, This field is applicable only for CommonLine Release 4 Loan Records | |
RESP_TO_ORIG_CODE | VARCHAR2 | (30) | ||
APPL_LOAN_PHASE_CODE | VARCHAR2 | (30) | Loan Application Phase Status Code. This is applicable only for CommonLine Release 4 Records. This field indicates the current processing phase of the Loan Application Record | |
APPL_LOAN_PHASE_CODE_CHG | DATE | Date when Application Phase Status Code was last updated. This is applicable only for CommonLine Release 4 Records | ||
APPL_SEND_ERROR_CODES | VARCHAR2 | (0) | Obsolete | |
TOT_OUTSTD_STAFFORD | NUMBER | (12) | ||
TOT_OUTSTD_PLUS | NUMBER | (12) | ||
ALT_BORW_TOT_DEBT | NUMBER | (12) | ||
ACT_INTEREST_RATE | NUMBER | (12) | ||
SERVICE_TYPE_CODE | VARCHAR2 | (10) | ||
REV_NOTICE_OF_GUARNT | VARCHAR2 | (30) | ||
SCH_REFUND_AMT | NUMBER | (12) | ||
SCH_REFUND_DATE | DATE | |||
UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (30) | ||
UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | ||
P_PERSON_ID | NUMBER | (15) | ||
P_SSN_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
P_DOB_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
P_PERMT_ADDR_CHG_DATE | DATE | |||
P_DEFAULT_STATUS | VARCHAR2 | (30) | ||
P_SIGNATURE_CODE | VARCHAR2 | (30) | ||
P_SIGNATURE_DATE | DATE | |||
S_SSN_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
S_DOB_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
S_PERMT_ADDR_CHG_DATE | DATE | |||
S_LOCAL_ADDR_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
S_DEFAULT_STATUS | VARCHAR2 | (30) | ||
S_SIGNATURE_CODE | VARCHAR2 | (30) | ||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ELEC_MPN_IND | VARCHAR2 | (30) | Indicates the Type of the Master Promissory Note E - Electronic or P � Paper | |
BORR_SIGN_IND | VARCHAR2 | (30) | Borrower Electronic Signature Indicator. A 1-character code indicating if the borrower electronically signed the promissory note.Valid valuesY = Yes, the signature has been captured electronically and blank | |
STUD_SIGN_IND | VARCHAR2 | (30) | Student Electronic Signature Indicator. A 1-character code indicating if the PLUS/Alternative student electronically signed the promissory note. Valid valuesY = Yes, the signature has been captured electronically and blank | |
BORR_CREDIT_AUTH_CODE | VARCHAR2 | (30) | ||
S_DEFAULT_STATUS_DESC | VARCHAR2 | (4000) | ||
P_DEFAULT_STATUS_DESC | VARCHAR2 | (4000) | ||
UNSUB_ELIG_FOR_HEAL_DESC | VARCHAR2 | (4000) | ||
UNSUB_ELIG_FOR_DEPNT_DESC | VARCHAR2 | (4000) | ||
S_SIGNATURE_DESC | VARCHAR2 | (4000) | ||
P_SIGNATURE_DESC | VARCHAR2 | (4000) | ||
ELEC_MPN_DESC | VARCHAR2 | (4000) | ||
PNOTE_MPN_DESC | VARCHAR2 | (4000) | ||
BORW_OUTSTD_LOAN_DESC | VARCHAR2 | (4000) | ||
GUARNT_ADJ_DESC | VARCHAR2 | (4000) | ||
LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates whether the record was imported through a legacy process or not | |
RELATIONSHIP_CD | VARCHAR2 | (30) | Lender relationship code | |
RELATIONSHIP_CD_DESC | VARCHAR2 | (80) | Lender relationship code description | |
INTEREST_REBATE_PERCENT_NUM | NUMBER | The Upfront Interest Rebate Amount. If the DisbursementReleaseIndicator = false, this is anticipated disbursement information. If the DisbursementReleaseIndicator = true, then this is actual disbursement information. | ||
CPS_TRANS_NUM | VARCHAR2 | (2) | Transaction number from eligible ISIR used to calculate award. | |
ATD_ENTITY_ID_TXT | VARCHAR2 | (30) | Attending School Entity ID | |
REP_ENTITY_ID_TXT | VARCHAR2 | (30) | Reporting School Entity ID | |
CRDT_DECISION_STATUS | VARCHAR2 | (30) | The status of the PLUS credit decision for the loan on COD. | |
NOTE_MESSAGE | VARCHAR2 | (30) | Indicates the school use text. | |
BOOK_LOAN_AMT | NUMBER | Indicates the total net amount of disbursements accepted and booked. | ||
BOOK_LOAN_AMT_DATE | DATE | Indicates the date the loan booked on COD. | ||
PYMT_SERVICER_AMT | NUMBER | Indicates Amount of payment sent to the Servicer by the borrower. | ||
PYMT_SERVICER_DATE | DATE | Indicates the date the Servicer posted the payment to the student's account. | ||
ENROLLMENT_DESC | VARCHAR2 | (4000) | Enrollment Status of the Student | |
EXTERNAL_LOAN_ID_TXT | VARCHAR2 | (30) | External Loan Number. This Loan Number would be updated from School Certification Request for FELP Loans | |
DEFERMENT_REQUEST_CODE | VARCHAR2 | (30) | Deferment Request Code, valid values Y, N Y = Yes, the borrower requests immediate defermentN = No, the borrower does not request immediate deferment | |
DEFERMENT_REQUEST_DESC | VARCHAR2 | (4000) | Deferment Request Code Description | |
EFT_AUTHORIZATION_CODE | VARCHAR2 | (30) | EFT Authorization Code. This value would be derived from FFELP SetupY = Yes, transfer of loan proceeds has been authorizedN = No, transfer of loan proceeds has not been authorized or school requests delivery by check | |
EFT_AUTHORIZATION_DESC | VARCHAR2 | (4000) | EFT Authorization Code Description | |
REQUESTED_LOAN_AMT | NUMBER | Loan Requested Amount. This is the initial Loan Amount requested the Loan Borrower | ||
ACTUAL_RECORD_TYPE_CODE | VARCHAR2 | (30) | Actual Record Type. This field denotes the Record Type on the Response file for the Loan. These are different from the Requested Loan Type. Updated from the Response table | |
ACTUAL_RECORD_TYPE_DESC | VARCHAR2 | (4000) | Actual Record Type Description | |
REINSTATEMENT_AMT | NUMBER | Amount Available for Re-instatement. Updated from the Response table. This would usually be present after the school has cancelled or asked for reissue on some disbursements for a Loan | ||
SCHOOL_USE_TXT | VARCHAR2 | (80) | A field reserved for school information only. Schools may use the field to store information not otherwise tracked, such as campus activity or a school-assigned application ID | |
LENDER_USE_TXT | VARCHAR2 | (80) | A field reserved for lender information only. Lenders may use the field to store information not otherwise tracked, such as branch activity, specific accounting needs, or a lender-assigned application ID. Do not overlay this field with spaces if a previous transmission of Lender Use Only contained a non-blank value | |
GUARANTOR_USE_TXT | VARCHAR2 | (80) | A field reserved for guarantor information only. Guarantors may use the field to store information not otherwise tracked, such as loan activity or a guarantor-assigned application ID. Do not overlay this field with spaces if a previous transmission of the Guarantor Use Only field contained a non-blank value | |
FLS_APPROVED_AMT | NUMBER | The Amount approved by the lender for a subsidized Federal Stafford loan.In response to an Application Send File, this amount is provided by a lender or lender servicer only. If this data is not provided for a subsidized Federal Stafford loan, the loan will be considered for the lesser of the following two amounts: Requested Loan Amount or Subsidized Federal Stafford Certified Amount | ||
FLU_APPROVED_AMT | NUMBER | The Amount approved by the lender for a unsubsidized Federal Stafford loan. In response to an Application Send File, this amount is provided by a lender or lender servicer only. If this data is not provided for a unsubsidized Federal Stafford loan, the loan will be considered for the lesser of the following two amounts: Requested Loan Amount or Unsubsidized Federal Stafford Certified Amount | ||
FLP_APPROVED_AMT | NUMBER | The Amount approved by the lender for a Federal PLUS loan. In response to an Application Send File, this amount is provided by a lender or lender servicer only. If this data is not provided for a Federal PLUS loan, the loan will be considered for the lesser of the following two amounts: Requested Loan Amount or Federal PLUS Certified Amount | ||
ALT_APPROVED_AMT | NUMBER | The Amount approved by the lender for a Alternative Loan | ||
LOAN_APP_FORM_CODE | VARCHAR2 | (30) | Loan Application Form Code | |
LOAN_APP_FORM_CODE_DESC | VARCHAR2 | (4000) | Loan Application Form Description | |
OVERRIDE_GRADE_LEVEL_CODE | VARCHAR2 | (30) | Grade Level Override for the Loan Record | |
OVERRIDE_GRADE_LEVEL_DESC | VARCHAR2 | (4000) | Grade Level Override Description for the Loan Record | |
DISCLOSURE_PRINT_IND_DESC | VARCHAR2 | (4000) | Disclosure Statement Print Indicator Description | |
CL_REC_STATUS_DESC | VARCHAR2 | (4000) | Loan Record Status Description. This is applicable only for CommonLine Release 4 Records | |
MPN_CONFIRMATION_CODE_DESC | VARCHAR2 | (4000) | MPN Confirmation Description, This field is applicable only for CommonLine Release 4 Loan Records | |
APPL_LOAN_PHASE_CODE_DESC | VARCHAR2 | (4000) | Loan Application Phase Status Description. This is applicable only for CommonLine Release 4 Records. This field indicates the current processing phase of the Loan Application Record | |
B_ALIEN_REG_NUM_TXT | VARCHAR2 | (30) | Borrower Alien Registration Number | |
ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code | |
ACAD_BEGIN_DATE | DATE | Academic Year Begin Date | ||
ACAD_END_DATE | DATE | Academic Year End Date |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORIGINATION_ID
, LOAN_ID
, AWARD_ID
, STUDENT_ID
, FUND_ID
, SEQ_NUM
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER
, CI_START_DT
, CI_END_DT
, CI_ALTERNATE_CODE
, LOAN_TYPE
, LOAN_TYPE_NUM
, FUND_SOURCE
, FUND_TYPE
, SYS_FUND_TYPE
, FED_FUND_CODE
, LOAN_NUMBER
, SCH_CERT_DATE
, ORIG_STATUS_FLAG
, ORIG_BATCH_ID
, ORIG_BATCH_DATE
, CHG_BATCH_ID
, ORIG_ACK_DATE
, CREDIT_OVERRIDE
, CREDIT_DECISION_DATE
, REQ_SERIAL_LOAN_CODE
, ACT_SERIAL_LOAN_CODE
, PNOTE_DELIVERY_CODE
, PNOTE_STATUS
, PNOTE_STATUS_DESC
, PNOTE_STATUS_DATE
, PNOTE_ID
, PNOTE_PRINT_IND
, PNOTE_ACCEPT_AMT
, PNOTE_ACCEPT_DATE
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, UNSUB_ELIG_FOR_HEAL
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, BORW_CONFIRM_IND
, BORW_INTEREST_IND
, BORW_OUTSTD_LOAN_CODE
, UNSUB_ELIG_FOR_DEPNT
, GUARANTEE_AMT
, GUARANTEE_DATE
, GUARNT_AMT_REDN_CODE
, GUARNT_STATUS_CODE
, GUARNT_STATUS_DATE
, LEND_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, LEND_STATUS_CODE
, LEND_STATUS_DATE
, GUARNT_ADJ_IND
, GRADE_LEVEL_CODE
, ENROLLMENT_CODE
, ANTICIP_COMPL_DATE
, BORW_LENDER_ID
, DUNS_BORW_LENDER_ID
, GUARANTOR_ID
, DUNS_GUARNT_ID
, PRC_TYPE_CODE
, CL_SEQ_NUMBER
, LAST_RESORT_LENDER
, LENDER_ID
, DUNS_LENDER_ID
, LEND_NON_ED_BRC_ID
, RECIPIENT_ID
, RECIPIENT_TYPE
, DUNS_RECIP_ID
, RECIP_NON_ED_BRC_ID
, REC_TYPE_IND
, CL_LOAN_TYPE
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, ALT_PROG_TYPE_CODE
, ALT_APPL_VER_CODE
, MPN_CONFIRM_CODE
, RESP_TO_ORIG_CODE
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, APPL_SEND_ERROR_CODES
, TOT_OUTSTD_STAFFORD
, TOT_OUTSTD_PLUS
, ALT_BORW_TOT_DEBT
, ACT_INTEREST_RATE
, SERVICE_TYPE_CODE
, REV_NOTICE_OF_GUARNT
, SCH_REFUND_AMT
, SCH_REFUND_DATE
, UNIQ_LAYOUT_VEND_CODE
, UNIQ_LAYOUT_IDENT_CODE
, P_PERSON_ID
, P_SSN_CHG_DATE
, P_DOB_CHG_DATE
, P_PERMT_ADDR_CHG_DATE
, P_DEFAULT_STATUS
, P_SIGNATURE_CODE
, P_SIGNATURE_DATE
, S_SSN_CHG_DATE
, S_DOB_CHG_DATE
, S_PERMT_ADDR_CHG_DATE
, S_LOCAL_ADDR_CHG_DATE
, S_DEFAULT_STATUS
, S_SIGNATURE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ELEC_MPN_IND
, BORR_SIGN_IND
, STUD_SIGN_IND
, BORR_CREDIT_AUTH_CODE
, S_DEFAULT_STATUS_DESC
, P_DEFAULT_STATUS_DESC
, UNSUB_ELIG_FOR_HEAL_DESC
, UNSUB_ELIG_FOR_DEPNT_DESC
, S_SIGNATURE_DESC
, P_SIGNATURE_DESC
, ELEC_MPN_DESC
, PNOTE_MPN_DESC
, BORW_OUTSTD_LOAN_DESC
, GUARNT_ADJ_DESC
, LEGACY_RECORD_FLAG
, RELATIONSHIP_CD
, RELATIONSHIP_CD_DESC
, INTEREST_REBATE_PERCENT_NUM
, CPS_TRANS_NUM
, ATD_ENTITY_ID_TXT
, REP_ENTITY_ID_TXT
, CRDT_DECISION_STATUS
, NOTE_MESSAGE
, BOOK_LOAN_AMT
, BOOK_LOAN_AMT_DATE
, PYMT_SERVICER_AMT
, PYMT_SERVICER_DATE
, ENROLLMENT_DESC
, EXTERNAL_LOAN_ID_TXT
, DEFERMENT_REQUEST_CODE
, DEFERMENT_REQUEST_DESC
, EFT_AUTHORIZATION_CODE
, EFT_AUTHORIZATION_DESC
, REQUESTED_LOAN_AMT
, ACTUAL_RECORD_TYPE_CODE
, ACTUAL_RECORD_TYPE_DESC
, REINSTATEMENT_AMT
, SCHOOL_USE_TXT
, LENDER_USE_TXT
, GUARANTOR_USE_TXT
, FLS_APPROVED_AMT
, FLU_APPROVED_AMT
, FLP_APPROVED_AMT
, ALT_APPROVED_AMT
, LOAN_APP_FORM_CODE
, LOAN_APP_FORM_CODE_DESC
, OVERRIDE_GRADE_LEVEL_CODE
, OVERRIDE_GRADE_LEVEL_DESC
, DISCLOSURE_PRINT_IND_DESC
, CL_REC_STATUS_DESC
, MPN_CONFIRMATION_CODE_DESC
, APPL_LOAN_PHASE_CODE_DESC
, B_ALIEN_REG_NUM_TXT
, ESIGN_SRC_TYP_CD
, ACAD_BEGIN_DATE
, ACAD_END_DATE
FROM APPS.IGF_SL_LOR_V;
|
|
|