[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LOR_LOC |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_SL_LOR_LOC
|
| Subobject Name: | |
| Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | ||
| LOAN_ID | NUMBER | (15) | Yes | |
| ORIGINATION_ID | NUMBER | (15) | Yes | |
| LOAN_NUMBER | VARCHAR2 | (30) | Yes | |
| LOAN_TYPE | VARCHAR2 | (30) | Yes | |
| LOAN_AMT_OFFERED | NUMBER | (12) | ||
| LOAN_AMT_ACCEPTED | NUMBER | (12) | ||
| LOAN_PER_BEGIN_DATE | DATE | |||
| LOAN_PER_END_DATE | DATE | |||
| ACAD_YR_BEGIN_DATE | DATE | |||
| ACAD_YR_END_DATE | DATE | |||
| LOAN_STATUS | VARCHAR2 | (30) | ||
| LOAN_STATUS_DATE | DATE | |||
| LOAN_CHG_STATUS | VARCHAR2 | (30) | ||
| LOAN_CHG_STATUS_DATE | DATE | |||
| REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | ||
| ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | ||
| ACTIVE | VARCHAR2 | (1) | ||
| ACTIVE_DATE | DATE | |||
| 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 | |||
| PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | ||
| PNOTE_STATUS | VARCHAR2 | (30) | ||
| 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. | |
| P_SIGNATURE_CODE | VARCHAR2 | (30) | ||
| P_SIGNATURE_DATE | DATE | |||
| S_SIGNATURE_CODE | VARCHAR2 | (30) | ||
| 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) | ||
| UNSUB_ELIG_FOR_DEPNT | VARCHAR2 | (30) | ||
| GUARANTEE_AMT | NUMBER | (12) | ||
| GUARANTEE_DATE | DATE | |||
| GUARNT_ADJ_IND | VARCHAR2 | (30) | ||
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (30) | ||
| 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 | |||
| 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) | ||
| REC_TYPE_IND | VARCHAR2 | (30) | ||
| CL_LOAN_TYPE | 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) | ||
| 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) | ||
| BORW_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | ||
| 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. | ||
| 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 | (30) | ||
| 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 | VARCHAR2 | (30) | ||
| P_SSN_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
| P_LAST_NAME | VARCHAR2 | (150) | ||
| P_FIRST_NAME | VARCHAR2 | (150) | ||
| P_MIDDLE_NAME | VARCHAR2 | (60) | ||
| P_PERMT_ADDR1 | VARCHAR2 | (240) | ||
| P_PERMT_ADDR2 | VARCHAR2 | (240) | ||
| P_PERMT_CITY | VARCHAR2 | (60) | ||
| P_PERMT_STATE | VARCHAR2 | (60) | ||
| P_PERMT_ZIP | VARCHAR2 | (60) | ||
| P_PERMT_ADDR_CHG_DATE | DATE | |||
| P_PERMT_PHONE | VARCHAR2 | (30) | ||
| P_EMAIL_ADDR | VARCHAR2 | (60) | ||
| P_DATE_OF_BIRTH | DATE | |||
| P_DOB_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
| P_LICENSE_NUM | VARCHAR2 | (30) | ||
| P_LICENSE_STATE | VARCHAR2 | (60) | ||
| P_CITIZENSHIP_STATUS | VARCHAR2 | (30) | ||
| P_ALIEN_REG_NUM | VARCHAR2 | (30) | ||
| P_DEFAULT_STATUS | VARCHAR2 | (30) | ||
| P_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | ||
| P_STATE_OF_LEGAL_RES | VARCHAR2 | (60) | ||
| P_LEGAL_RES_DATE | DATE | |||
| S_SSN | VARCHAR2 | (30) | ||
| S_SSN_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
| S_LAST_NAME | VARCHAR2 | (150) | ||
| S_FIRST_NAME | VARCHAR2 | (150) | ||
| S_MIDDLE_NAME | VARCHAR2 | (60) | ||
| S_PERMT_ADDR1 | VARCHAR2 | (240) | ||
| S_PERMT_ADDR2 | VARCHAR2 | (240) | ||
| S_PERMT_CITY | VARCHAR2 | (60) | ||
| S_PERMT_STATE | VARCHAR2 | (60) | ||
| S_PERMT_ZIP | VARCHAR2 | (60) | ||
| S_PERMT_ADDR_CHG_DATE | DATE | |||
| S_PERMT_PHONE | VARCHAR2 | (30) | ||
| S_LOCAL_ADDR1 | VARCHAR2 | (240) | ||
| S_LOCAL_ADDR2 | VARCHAR2 | (240) | ||
| S_LOCAL_CITY | VARCHAR2 | (60) | ||
| S_LOCAL_STATE | VARCHAR2 | (60) | ||
| S_LOCAL_ZIP | VARCHAR2 | (60) | ||
| S_LOCAL_ADDR_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
| S_EMAIL_ADDR | VARCHAR2 | (60) | ||
| S_DATE_OF_BIRTH | DATE | |||
| S_DOB_CHG_DATE | VARCHAR2 | (0) | Obsolete | |
| S_LICENSE_NUM | VARCHAR2 | (30) | ||
| S_LICENSE_STATE | VARCHAR2 | (60) | ||
| S_DEPNCY_STATUS | VARCHAR2 | (30) | ||
| S_DEFAULT_STATUS | VARCHAR2 | (30) | ||
| S_CITIZENSHIP_STATUS | VARCHAR2 | (30) | ||
| S_ALIEN_REG_NUM | VARCHAR2 | (30) | ||
| S_FOREIGN_POSTAL_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 | |||
| ORG_ID | NUMBER | (15) | ||
| AWARD_ID | NUMBER | Identifier for the award | ||
| BASE_ID | NUMBER | Base_id of the student. | ||
| 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 DisbursementReleaseIndicator = false, this is anticipated disbursement information. If the DisbursementReleaseIndicator = 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 | 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 | |
| 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. | |
| 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 | |
| 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 valuesY = 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 valuesY = 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 = YesN = No | |
| MPN_TYPE_FLAG | VARCHAR2 | (30) | Indicates the Type of the Master Promissory Note E - Electronic or P - Paper | |
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, LOAN_ID
, 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
, CHG_BATCH_ID
, ORIG_ACK_DATE
, CREDIT_OVERRIDE
, CREDIT_DECISION_DATE
, PNOTE_DELIVERY_CODE
, PNOTE_STATUS
, PNOTE_STATUS_DATE
, PNOTE_ID
, PNOTE_PRINT_IND
, PNOTE_ACCEPT_AMT
, PNOTE_ACCEPT_DATE
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, 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_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, LEND_STATUS_CODE
, LEND_STATUS_DATE
, GRADE_LEVEL_CODE
, ENROLLMENT_CODE
, ANTICIP_COMPL_DATE
, BORW_LENDER_ID
, DUNS_BORW_LENDER_ID
, GUARANTOR_ID
, DUNS_GUARNT_ID
, PRC_TYPE_CODE
, REC_TYPE_IND
, CL_LOAN_TYPE
, 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
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, ALT_PROG_TYPE_CODE
, ALT_APPL_VER_CODE
, BORW_OUTSTD_LOAN_CODE
, MPN_CONFIRM_CODE
, RESP_TO_ORIG_CODE
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, 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_SSN_CHG_DATE
, 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_DOB_CHG_DATE
, 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_SSN_CHG_DATE
, 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_LOCAL_ADDR_CHG_DATE
, S_EMAIL_ADDR
, S_DATE_OF_BIRTH
, S_DOB_CHG_DATE
, S_LICENSE_NUM
, S_LICENSE_STATE
, S_DEPNCY_STATUS
, S_DEFAULT_STATUS
, S_CITIZENSHIP_STATUS
, S_ALIEN_REG_NUM
, S_FOREIGN_POSTAL_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
, 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
, 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
, 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
, MPN_TYPE_FLAG
, ESIGN_SRC_TYP_CD
FROM APPS.IGF_SL_LOR_LOC;
APPS
IGF_SL_LOR_LOC_ALL
APPS
IGF_SL_CL_ORIG
- show dependent code
IGF_SL_CL_ORIG_ACK
- show dependent code
IGF_SL_DL_CHG_ACK
- show dependent code
IGF_SL_DL_CHG_ORIG
- show dependent code
IGF_SL_DL_ORIG
- show dependent code
IGF_SL_DL_ORIG_ACK
- show dependent code
IGF_SL_DL_PNOTE_ACK
- show dependent code
IGF_SL_UPLOAD_XML
- show dependent code
|
|
|
|