[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LOR_LOC_HISTORY |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_LOR_LOC_HISTORY
|
| Subobject Name: | |
| Status: | VALID |
Loans History Table. This table stores the information that is sent out to external agencies for processing
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_LOR_LOC_HISTORY_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOANSH_ID
|
| IGF_SL_LOR_LOC_HISTORY_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOAN_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOANSH_ID | NUMBER | Yes | Primary Key of the table, generated from Sequence IGF_SL_LOR_LOC_HISTORY_S | |
| LOAN_ID | NUMBER | Yes | Foreign Key to IGF_SL_LOR_LOC_ALL table | |
| 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 deferment N = No, the borrower does not request immediate deferment | |
| EFT_AUTHORIZATION_CODE | VARCHAR2 | (30) | EFT Authorization Code. This value would be derived from FFELP Setup Y = Yes, transfer of loan proceeds has been authorized N = 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, a lender or lender servicer provides this amount 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 an 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 | ||
| 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. | ||
| LOAN_APP_FORM_CODE | VARCHAR2 | (30) | Loan Application Form Code | |
| 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. | ||
| MPN_CONFIRM_CODE | VARCHAR2 | (30) | MPN Confirmation Code, This field is applicable only for CommonLine Release 4 Loan Records | |
| ALT_BORROWER_IND_FLAG | VARCHAR2 | (1) | Alternative Student/Borrower Indicator code. Indicates if the borrower is a Student Borrower or not. | |
| SCHOOL_ID_TXT | VARCHAR2 | (80) | School ID | |
| COST_OF_ATTENDANCE_AMT | NUMBER | Cost of Attendance | ||
| EXPECT_FAMILY_CONTRIBUTE_AMT | NUMBER | Estimated/Expected Family Contribution | ||
| ESTABLISHED_FIN_AID_AMOUNT | NUMBER | Established Financial Aid Amount | ||
| BOROWER_ELECTRONIC_SIGN_FLAG | VARCHAR2 | (1) | Borrower Electronic Signature Indicator. A 1-character code indicating if the borrower electronically signed the promissory note.Valid values Y = Yes, the signature has been captured electronically and blank | |
| STUDENT_ELECTRONIC_SIGN_FLAG | VARCHAR2 | (1) | Student Electronic Signature Indicator. A 1-character code indicating if the PLUS/Alternative student electronically signed the promissory note. Valid values Y = Yes, the signature has been captured electronically and blank | |
| BOROWER_CREDIT_AUTHORIZ_FLAG | VARCHAR2 | (1) | Borrower Credit Authorization Code. A 1-character code indicating if the sending organization has obtained the borrower's authorization to perform a credit check.Y = Yes N = No | |
| 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 | ||
| AWARD_ID | NUMBER | Identifier for the award | ||
| BASE_ID | NUMBER | Unique Identifier for Student's Financial Aid Base Record | ||
| DOCUMENT_ID_TXT | VARCHAR2 | (30) | Identifier for the document. | |
| LOAN_KEY_NUM | NUMBER | Indicates the loan key. | ||
| INTEREST_REBATE_PERCENT_NUM | NUMBER | The Upfront Interest Rebate Amount. If the Disbursement Release Indicator = false, this is anticipated disbursement information. If the Disbursement Release Indicator = true, then this is actual disbursement information. | ||
| FIN_AWARD_YEAR | VARCHAR2 | (30) | Beginning date of the Payment Period. Used to pay on awards submitted by schools that have become ineligible. | |
| CPS_TRANS_NUM | NUMBER | 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 | |
| SOURCE_ENTITY_ID_TXT | VARCHAR2 | (30) | Source Entity ID | |
| 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. | ||
| 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. | ||
| S_CHG_BIRTH_DATE | DATE | Indicates the old birth date | ||
| S_CHG_SSN | VARCHAR2 | (30) | Indicates the old SSN | |
| S_CHG_LAST_NAME | VARCHAR2 | (150) | Indicates the old last name | |
| B_CHG_BIRTH_DATE | DATE | Indicates the Borrower's old birth date | ||
| B_CHG_SSN | VARCHAR2 | (30) | Indicates the Borrower's old SSN | |
| B_CHG_LAST_NAME | VARCHAR2 | (150) | Indicates the Borrower's old last name | |
| NOTE_MESSAGE | VARCHAR2 | (100) | Indicates the Note Message | |
| FULL_RESP_CODE | VARCHAR2 | (30) | Indicates the full response code | |
| S_PERMT_COUNTY | VARCHAR2 | (30) | Indicates the student's county | |
| B_PERMT_COUNTY | VARCHAR2 | (30) | Indicates the borrower's county | |
| S_PERMT_COUNTRY | VARCHAR2 | (30) | Indicates the student's country | |
| B_PERMT_COUNTRY | VARCHAR2 | (30) | Indicates the borrower's country | |
| CRDT_DECISION_STATUS | VARCHAR2 | (30) | The status of the PLUS credit decision for the loan on COD. | |
| ORIGINATION_ID | NUMBER | (15) | Yes | Identifier for loans originated |
| LOAN_NUMBER | VARCHAR2 | (30) | Yes | Unique identifier for Direct Loan or CommonLine loan |
| LOAN_TYPE | VARCHAR2 | (30) | Yes | Indicates loan type |
| LOAN_AMT_OFFERED | NUMBER | (12) | Indicates loan amount offered | |
| LOAN_AMT_ACCEPTED | NUMBER | (12) | Indicates loan amount accepted | |
| LOAN_PER_BEGIN_DATE | DATE | Indicates loan period begin date | ||
| LOAN_PER_END_DATE | DATE | Indicates loan period end date | ||
| ACAD_YR_BEGIN_DATE | DATE | Indicates academic year begin date | ||
| ACAD_YR_END_DATE | DATE | Indicates academic year end date | ||
| LOAN_STATUS | VARCHAR2 | (30) | Indicates loan status | |
| LOAN_STATUS_DATE | DATE | Indicates date on which loan status changed | ||
| LOAN_CHG_STATUS | VARCHAR2 | (30) | Indicates whether loan changes are pending | |
| LOAN_CHG_STATUS_DATE | DATE | Indicates date on which loan change status changed | ||
| 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 | |
| ACTIVE | VARCHAR2 | (1) | Indicator that specifies whether the loan is active. Setting checkbox to inactive prevents use of loan in new or modified records. | |
| ACTIVE_DATE | DATE | Indicates date on which loan was activated or inactivated | ||
| 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 | ||
| 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 date on which credit decision was last updated | ||
| 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 service provider changed promissory Note status | ||
| 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 | |
| MPN_TYPE_FLAG | VARCHAR2 | (30) | Indicates the Type of the Master Promissory Note E - Electronic or P - Paper | |
| 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 amount was accepted | ||
| P_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether parent borrower signed the Note | |
| P_SIGNATURE_DATE | DATE | Indicates date school received signed promissory Note | ||
| S_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates whether student signed Note | |
| 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 | |
| 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_ADJ_IND | VARCHAR2 | (30) | Indicates whether guarantee amount has been adjusted and is different from school amount | |
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (30) | 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 service provider changed guarantee status | ||
| LEND_STATUS_CODE | VARCHAR2 | (30) | Indicates status of loan with respect to lender | |
| LEND_STATUS_DATE | DATE | Indicates date on which service provider changed lender status | ||
| GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates grade level code of student at time loan was originated | |
| ENROLLMENT_CODE | VARCHAR2 | (30) | Indicates enrollment status of student at time loan was originated | |
| ANTICIP_COMPL_DATE | DATE | Indicates date student is anticipated to complete program at school | ||
| BORW_LENDER_ID | VARCHAR2 | (30) | Identifier for lender either by default or as chosen by borrower | |
| GUARANTOR_ID | VARCHAR2 | (30) | Indicates guarantor identifier for borrower's lender | |
| PRC_TYPE_CODE | VARCHAR2 | (30) | Indicates processing type for CommonLine loan | |
| REC_TYPE_IND | VARCHAR2 | (30) | Indicates application type of loan record | |
| CL_LOAN_TYPE | VARCHAR2 | (30) | Indicates CommonLine loan type requested by borrower | |
| 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) | Indicates unique 6-character identification code assigned by US Department of Education to lender associated with loan, as reported by borrower | |
| LEND_NON_ED_BRC_ID | VARCHAR2 | (30) | Indicates unique identification code assigned by entity other than US Department of Education to lender's branch office | |
| RECIPIENT_ID | VARCHAR2 | (30) | Identifier for recipient | |
| RECIPIENT_TYPE | VARCHAR2 | (30) | Indicates recipient type | |
| RECIP_NON_ED_BRC_ID | VARCHAR2 | (30) | Indicates unique identification code assigned by entity other than US Department of Education to branch office receiving file | |
| ALT_PROG_TYPE_CODE | VARCHAR2 | (30) | Indicates specific category of alternative loan | |
| ALT_APPL_VER_CODE | NUMBER | (15) | Indicates version of alternate loan | |
| BORW_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | Indicates whether borrower has outstanding federal student loan, PLUS. Values are Y or N. | |
| RESP_TO_ORIG_CODE | VARCHAR2 | (30) | Indicates record is sent to originator in response to originator's application send record | |
| 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 loans 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 | (30) | Indicates how disbursement funds are handled for CommonLine loans | |
| REV_NOTICE_OF_GUARNT | VARCHAR2 | (30) | Indicates whether revised Notice of guarantee is 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 | VARCHAR2 | (30) | Indicates parent borrower's SSN | |
| P_LAST_NAME | VARCHAR2 | (150) | Indicates parent borrower's last name | |
| P_FIRST_NAME | VARCHAR2 | (150) | Indicates parent borrower's first name | |
| P_MIDDLE_NAME | VARCHAR2 | (60) | Indicates parent borrower's middle name | |
| P_PERMT_ADDR1 | VARCHAR2 | (240) | Indicates parent borrower's permanent address line 1 | |
| P_PERMT_ADDR2 | VARCHAR2 | (240) | Indicates parent borrower's permanent address line 2 | |
| P_PERMT_CITY | VARCHAR2 | (60) | Indicates parent borrower's permanent city | |
| P_PERMT_STATE | VARCHAR2 | (60) | Indicates parent borrower's permanent state | |
| P_PERMT_ZIP | VARCHAR2 | (60) | Indicates 5-digit zip code of parent borrower's address | |
| P_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which parent borrower's permanent address last changed | ||
| P_PERMT_PHONE | VARCHAR2 | (30) | Indicates parent borrower's permanent phone number | |
| P_EMAIL_ADDR | VARCHAR2 | (60) | Indicates parent borrower's e-mail address | |
| P_DATE_OF_BIRTH | DATE | Indicates parent borrower's date of birth | ||
| P_LICENSE_NUM | VARCHAR2 | (30) | Indicates parent borrower's license number | |
| P_LICENSE_STATE | VARCHAR2 | (60) | Indicates state which issued license to parent borrower | |
| P_CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates parent borrower's citizenship status | |
| P_ALIEN_REG_NUM | VARCHAR2 | (30) | Indicates parent borrower's alien registration number or passport number | |
| P_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates parent borrower's default or refund status on Title IV loans | |
| P_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Indicates parent borrower's foreign postal code | |
| P_STATE_OF_LEGAL_RES | VARCHAR2 | (60) | Indicates parent borrower's state of legal residence | |
| P_LEGAL_RES_DATE | DATE | Indicates date when parent borrower became legal resident | ||
| S_SSN | VARCHAR2 | (30) | Indicates student borrower's SSN | |
| S_LAST_NAME | VARCHAR2 | (150) | Indicates student borrower's last name | |
| S_FIRST_NAME | VARCHAR2 | (150) | Indicates student borrower's first name | |
| S_MIDDLE_NAME | VARCHAR2 | (60) | Indicates student borrower's middle name | |
| S_PERMT_ADDR1 | VARCHAR2 | (240) | Indicates student borrower's permanent address line 1 | |
| S_PERMT_ADDR2 | VARCHAR2 | (240) | Indicates student borrower's permanent address line 2 | |
| S_PERMT_CITY | VARCHAR2 | (60) | Indicates student borrower's permanent address city | |
| S_PERMT_STATE | VARCHAR2 | (60) | Indicates student borrower's permanent address state | |
| S_PERMT_ZIP | VARCHAR2 | (60) | Indicates student borrower's permanent address zip code | |
| S_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which student borrower's permanent address last changed | ||
| S_PERMT_PHONE | VARCHAR2 | (30) | Indicates student borrower's permanent phone number | |
| S_LOCAL_ADDR1 | VARCHAR2 | (240) | Indicates student borrower's local address line 1 | |
| S_LOCAL_ADDR2 | VARCHAR2 | (240) | Indicates student borrower's local address line 2 | |
| S_LOCAL_CITY | VARCHAR2 | (60) | Indicates student borrower's local address city | |
| S_LOCAL_STATE | VARCHAR2 | (60) | Indicates student borrower's local address state | |
| S_LOCAL_ZIP | VARCHAR2 | (60) | Indicates student borrower's local address zip code | |
| S_EMAIL_ADDR | VARCHAR2 | (60) | Indicates student borrower's e-mail address | |
| S_DATE_OF_BIRTH | DATE | Indicates student borrower's date of birth | ||
| S_LICENSE_NUM | VARCHAR2 | (30) | Indicates student borrower's license number | |
| S_LICENSE_STATE | VARCHAR2 | (60) | Indicates state which issued license to student borrower | |
| S_DEPNCY_STATUS | VARCHAR2 | (30) | Indicates dependency status of student borrower | |
| S_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates student borrower's default or refund status on Title IV loans | |
| S_CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates citizenship status of student borrower | |
| S_ALIEN_REG_NUM | VARCHAR2 | (30) | Indicates student borrower's alien registration number or passport number | |
| S_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Indicates student borrower's foreign postal code | |
| 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. | |
| SOURCE_TXT | VARCHAR2 | (30) | Source of the history record, Response or System. | |
| 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 | ||
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT LOANSH_ID
, LOAN_ID
, 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
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, LOAN_APP_FORM_CODE
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, MPN_CONFIRM_CODE
, ALT_BORROWER_IND_FLAG
, SCHOOL_ID_TXT
, COST_OF_ATTENDANCE_AMT
, EXPECT_FAMILY_CONTRIBUTE_AMT
, ESTABLISHED_FIN_AID_AMOUNT
, BOROWER_ELECTRONIC_SIGN_FLAG
, STUDENT_ELECTRONIC_SIGN_FLAG
, BOROWER_CREDIT_AUTHORIZ_FLAG
, LEND_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, AWARD_ID
, BASE_ID
, DOCUMENT_ID_TXT
, LOAN_KEY_NUM
, INTEREST_REBATE_PERCENT_NUM
, FIN_AWARD_YEAR
, CPS_TRANS_NUM
, ATD_ENTITY_ID_TXT
, REP_ENTITY_ID_TXT
, SOURCE_ENTITY_ID_TXT
, PYMT_SERVICER_AMT
, PYMT_SERVICER_DATE
, BOOK_LOAN_AMT
, BOOK_LOAN_AMT_DATE
, S_CHG_BIRTH_DATE
, S_CHG_SSN
, S_CHG_LAST_NAME
, B_CHG_BIRTH_DATE
, B_CHG_SSN
, B_CHG_LAST_NAME
, NOTE_MESSAGE
, FULL_RESP_CODE
, S_PERMT_COUNTY
, B_PERMT_COUNTY
, S_PERMT_COUNTRY
, B_PERMT_COUNTRY
, CRDT_DECISION_STATUS
, ORIGINATION_ID
, LOAN_NUMBER
, LOAN_TYPE
, LOAN_AMT_OFFERED
, LOAN_AMT_ACCEPTED
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, ACAD_YR_BEGIN_DATE
, ACAD_YR_END_DATE
, LOAN_STATUS
, LOAN_STATUS_DATE
, LOAN_CHG_STATUS
, LOAN_CHG_STATUS_DATE
, REQ_SERIAL_LOAN_CODE
, ACT_SERIAL_LOAN_CODE
, ACTIVE
, ACTIVE_DATE
, SCH_CERT_DATE
, ORIG_STATUS_FLAG
, ORIG_BATCH_ID
, ORIG_BATCH_DATE
, ORIG_ACK_DATE
, CREDIT_OVERRIDE
, CREDIT_DECISION_DATE
, PNOTE_DELIVERY_CODE
, PNOTE_STATUS
, PNOTE_STATUS_DATE
, PNOTE_ID
, MPN_TYPE_FLAG
, PNOTE_PRINT_IND
, PNOTE_ACCEPT_AMT
, PNOTE_ACCEPT_DATE
, P_SIGNATURE_CODE
, P_SIGNATURE_DATE
, S_SIGNATURE_CODE
, UNSUB_ELIG_FOR_HEAL
, DISCLOSURE_PRINT_IND
, ORIG_FEE_PERCT
, BORW_CONFIRM_IND
, BORW_INTEREST_IND
, UNSUB_ELIG_FOR_DEPNT
, GUARANTEE_AMT
, GUARANTEE_DATE
, GUARNT_ADJ_IND
, GUARNT_AMT_REDN_CODE
, GUARNT_STATUS_CODE
, GUARNT_STATUS_DATE
, LEND_STATUS_CODE
, LEND_STATUS_DATE
, GRADE_LEVEL_CODE
, ENROLLMENT_CODE
, ANTICIP_COMPL_DATE
, BORW_LENDER_ID
, GUARANTOR_ID
, PRC_TYPE_CODE
, REC_TYPE_IND
, CL_LOAN_TYPE
, CL_SEQ_NUMBER
, LAST_RESORT_LENDER
, LENDER_ID
, LEND_NON_ED_BRC_ID
, RECIPIENT_ID
, RECIPIENT_TYPE
, RECIP_NON_ED_BRC_ID
, ALT_PROG_TYPE_CODE
, ALT_APPL_VER_CODE
, BORW_OUTSTD_LOAN_CODE
, RESP_TO_ORIG_CODE
, 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
, P_LAST_NAME
, P_FIRST_NAME
, P_MIDDLE_NAME
, P_PERMT_ADDR1
, P_PERMT_ADDR2
, P_PERMT_CITY
, P_PERMT_STATE
, P_PERMT_ZIP
, P_PERMT_ADDR_CHG_DATE
, P_PERMT_PHONE
, P_EMAIL_ADDR
, P_DATE_OF_BIRTH
, P_LICENSE_NUM
, P_LICENSE_STATE
, P_CITIZENSHIP_STATUS
, P_ALIEN_REG_NUM
, P_DEFAULT_STATUS
, P_FOREIGN_POSTAL_CODE
, P_STATE_OF_LEGAL_RES
, P_LEGAL_RES_DATE
, S_SSN
, S_LAST_NAME
, S_FIRST_NAME
, S_MIDDLE_NAME
, S_PERMT_ADDR1
, S_PERMT_ADDR2
, S_PERMT_CITY
, S_PERMT_STATE
, S_PERMT_ZIP
, S_PERMT_ADDR_CHG_DATE
, S_PERMT_PHONE
, S_LOCAL_ADDR1
, S_LOCAL_ADDR2
, S_LOCAL_CITY
, S_LOCAL_STATE
, S_LOCAL_ZIP
, S_EMAIL_ADDR
, S_DATE_OF_BIRTH
, S_LICENSE_NUM
, S_LICENSE_STATE
, S_DEPNCY_STATUS
, S_DEFAULT_STATUS
, S_CITIZENSHIP_STATUS
, S_ALIEN_REG_NUM
, S_FOREIGN_POSTAL_CODE
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, SOURCE_TXT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ESIGN_SRC_TYP_CD
FROM IGF.IGF_SL_LOR_LOC_HISTORY;
IGF.IGF_SL_LOR_LOC_HISTORY does not reference any database object
IGF.IGF_SL_LOR_LOC_HISTORY is referenced by following:
APPS
IGF_SL_LOR_LOC_HISTORY
|
|
|
|