[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LOR_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_LOR_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_SL_LOR_ALL contains the origination details of loan application records.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_LOR_ALL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ORIGINATION_ID
|
| IGF_SL_LOR_ALL_U1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOAN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORIGINATION_ID | NUMBER | (15) | Yes | Identifier for loan origination |
| LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
| SCH_CERT_DATE | DATE | Indicates date on which school certified loan | ||
| ORIG_STATUS_FLAG | VARCHAR2 | (30) | Indicates loan origination status | |
| ORIG_BATCH_ID | VARCHAR2 | (40) | Batch identifier for loan originated | |
| ORIG_BATCH_DATE | DATE | Indicates date on which loan originated | ||
| CHG_BATCH_ID | VARCHAR2 | (40) | Obsolete | |
| ORIG_ACK_DATE | DATE | Indicates date on which origination acknowledgement is received from external processor | ||
| CREDIT_OVERRIDE | VARCHAR2 | (30) | Indicates credit decision returned by external processor | |
| CREDIT_DECISION_DATE | DATE | Indicates last date on which credit decision was updated | ||
| REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates serial loan code requested by student | |
| ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates actual serial loan code as returned by service provider | |
| PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | Indicates promissory note delivery code | |
| PNOTE_STATUS | VARCHAR2 | (30) | Indicates promissory note status | |
| PNOTE_STATUS_DATE | DATE | Indicates date on which promissory note status changed by service provider | ||
| 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) | Indicates promissory note print indicator | |
| PNOTE_ACCEPT_AMT | NUMBER | (12) | Endorser Amount, this is populated by the Credit Response | |
| PNOTE_ACCEPT_DATE | DATE | Indicates date on which total anticipated disbursement gross amount was accepted | ||
| UNSUB_ELIG_FOR_HEAL | VARCHAR2 | (30) | Indicates student is eligible for additional unsubsidized funds in case of health professions | |
| DISCLOSURE_PRINT_IND | VARCHAR2 | (30) | Indicates whether LOC should print disclosure | |
| ORIG_FEE_PERCT | NUMBER | (6) | Indicates origination fee percentage | |
| BORW_CONFIRM_IND | VARCHAR2 | (30) | Indicates borrower's confirmation of loan | |
| BORW_INTEREST_IND | VARCHAR2 | (30) | Indicates whether borrower intends to pay interest on loan while in school, grace, or deferment | |
| BORW_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | Indicates whether borrower has outstanding federal student loans | |
| UNSUB_ELIG_FOR_DEPNT | VARCHAR2 | (30) | Indicates student is eligible for additional unsubsidized funds | |
| GUARANTEE_AMT | NUMBER | (12) | Indicates guarantee amount | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (10) | Indicates whether guarantee fee was reduced from loan amount requested or school certified loan | |
| GUARNT_STATUS_CODE | VARCHAR2 | (30) | Indicates status of loan with respect to lender | |
| GUARNT_STATUS_DATE | DATE | Indicates date on which guarantee status was changed by service provider | ||
| 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) | Indicates status of loan with respect to lender | |
| LEND_STATUS_DATE | DATE | Indicates date on which lender status was changed by service provider | ||
| GUARNT_ADJ_IND | VARCHAR2 | (30) | Indicates whether guarantee amount has been adjusted and is different from school amount | |
| GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates grade level code of student at time loan originated | |
| ENROLLMENT_CODE | VARCHAR2 | (30) | Indicates enrollment status of student at time loan originated | |
| ANTICIP_COMPL_DATE | DATE | Indicates anticipated date student completes program at school | ||
| BORW_LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| DUNS_BORW_LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| GUARANTOR_ID | VARCHAR2 | (30) | Obsolete | |
| DUNS_GUARNT_ID | VARCHAR2 | (30) | Obsolete | |
| PRC_TYPE_CODE | VARCHAR2 | (30) | Indicates processing type for CommonLine loan | |
| CL_SEQ_NUMBER | NUMBER | (15) | Indicates value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for CommonLine loan | |
| LAST_RESORT_LENDER | VARCHAR2 | (30) | Indicates whether lender is eligible lender of last resort for which value is updated by service provider | |
| LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| DUNS_LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| LEND_NON_ED_BRC_ID | VARCHAR2 | (30) | Obsolete | |
| RECIPIENT_ID | VARCHAR2 | (30) | Obsolete | |
| RECIPIENT_TYPE | VARCHAR2 | (30) | Obsolete | |
| DUNS_RECIP_ID | VARCHAR2 | (30) | Obsolete | |
| RECIP_NON_ED_BRC_ID | VARCHAR2 | (30) | Obsolete | |
| REC_TYPE_IND | VARCHAR2 | (30) | Indicates application type of loan record | |
| CL_LOAN_TYPE | VARCHAR2 | (30) | Indicates CommonLine loan type requested by borrower | |
| 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) | Indicates specific category of alternative loans | |
| ALT_APPL_VER_CODE | NUMBER | (15) | Indicates version of alternate loan | |
| 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) | Indicates record is sent to originator in response to originator's application send record | |
| 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 | (15) | Obsolete | |
| TOT_OUTSTD_STAFFORD | NUMBER | (12) | Indicates total amount of outstanding Stafford or supplemental loan for students as known by sender | |
| TOT_OUTSTD_PLUS | NUMBER | (12) | Indicates total amount of outstanding PLUS as known by sender | |
| ALT_BORW_TOT_DEBT | NUMBER | (12) | Indicates total debt of alternative loan for borrower | |
| ACT_INTEREST_RATE | NUMBER | (12) | Indicates latest interest rate of loan while student is still enrolled in school | |
| SERVICE_TYPE_CODE | VARCHAR2 | (10) | Indicates how disbursement funds are handled for CommonLine loans | |
| REV_NOTICE_OF_GUARNT | VARCHAR2 | (30) | Indicates whether revised notice of guarantee are issued to borrower | |
| SCH_REFUND_AMT | NUMBER | (12) | Indicates total amount of loan refunded by school. Amount must be cumulative and should be updated each time school refund occurs , if applicable, but does not include cancellations. | |
| SCH_REFUND_DATE | DATE | Indicates effective date of refund to lender | ||
| UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (30) | Indicates vendor who owns unique field layout included for CommonLine loan | |
| UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | Indicates vendor who owns unique field layout included for CommonLine loan | |
| P_PERSON_ID | NUMBER | (15) | Identifier for parent or alternate borrower from TCA | |
| P_SSN_CHG_DATE | DATE | Obsolete | ||
| P_DOB_CHG_DATE | DATE | Obsolete | ||
| P_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which parent borrower's permanent address last changed | ||
| P_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates parent borrower's default or refund status on Title IV loans | |
| P_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether parent borrower signed note | |
| P_SIGNATURE_DATE | DATE | Indicates date on which school received signed promissory note | ||
| S_SSN_CHG_DATE | DATE | Obsolete | ||
| S_DOB_CHG_DATE | DATE | Obsolete | ||
| S_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which student borrower's permanent address was last updated | ||
| S_LOCAL_ADDR_CHG_DATE | DATE | Obsolete | ||
| S_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates student borrower's default status for loan | |
| S_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether student borrwer signed note | |
| 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 | |
| PNOTE_BATCH_ID | VARCHAR2 | (40) | Batch ID of the Promissory Note Acknowledgment file | |
| PNOTE_ACK_DATE | DATE | Date on which the LOC acknowledged the receipt of the paper promissory note or promissory note or application | ||
| 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. | |
| ELEC_MPN_IND | VARCHAR2 | (30) | Indicates the Type of the Master Promissory Note E - Electronic or 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) | Borrower Credit Authorization Code | |
| RELATIONSHIP_CD | VARCHAR2 | (30) | Lender relationship code | |
| 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. | ||
| 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 | |
| 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 | |
| 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 | |
| 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 | |
| OVERRIDE_GRADE_LEVEL_CODE | VARCHAR2 | (30) | Grade Level Override for the Loan 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 start date | ||
| ACAD_END_DATE | DATE | Academic end date |
Cut, paste (and edit) the following text to query this object:
SELECT ORIGINATION_ID
, LOAN_ID
, 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_DATE
, PNOTE_ID
, PNOTE_PRINT_IND
, PNOTE_ACCEPT_AMT
, PNOTE_ACCEPT_DATE
, 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
, ORG_ID
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, ELEC_MPN_IND
, BORR_SIGN_IND
, STUD_SIGN_IND
, BORR_CREDIT_AUTH_CODE
, RELATIONSHIP_CD
, 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
, EXTERNAL_LOAN_ID_TXT
, DEFERMENT_REQUEST_CODE
, EFT_AUTHORIZATION_CODE
, REQUESTED_LOAN_AMT
, ACTUAL_RECORD_TYPE_CODE
, 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
, OVERRIDE_GRADE_LEVEL_CODE
, B_ALIEN_REG_NUM_TXT
, ESIGN_SRC_TYP_CD
, ACAD_BEGIN_DATE
, ACAD_END_DATE
FROM IGF.IGF_SL_LOR_ALL;
IGF.IGF_SL_LOR_ALL does not reference any database object
IGF.IGF_SL_LOR_ALL is referenced by following:
APPS
IGF_SL_LOR_ALL
|
|
|
|