[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LOR_LOC_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_LOR_LOC_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_SL_LOR_LOC_ALL contains all the loan data for each loan at the time of origination or origination changes sent. This always reflects the data currently in the LOC.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_LOR_LOC_ALL_PK | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 LOAN_ID
|
| IGF_SL_LOR_LOC_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
ORIGINATION_ID
|
| IGF_SL_LOR_LOC_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
DOCUMENT_ID_TXT
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
| 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 | ||
| 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 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) | Identifier for promissory note status | |
| PNOTE_PRINT_IND | VARCHAR2 | (30) | Indicates promissory note print indicator | |
| PNOTE_ACCEPT_AMT | NUMBER | (12) | Indicates total anticipated disbursement gross amount | |
| 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_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 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 | |
| DUNS_BORW_LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| GUARANTOR_ID | VARCHAR2 | (30) | Indicates guarantor identifier for borrower's lender | |
| DUNS_GUARNT_ID | VARCHAR2 | (30) | Obsolete | |
| 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 | |
| DUNS_LENDER_ID | VARCHAR2 | (30) | Obsolete | |
| 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 | |
| DUNS_RECIP_ID | VARCHAR2 | (30) | Obsolete | |
| 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 | |
| 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 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. | |
| 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. | ||
| 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_SSN_CHG_DATE | DATE | Obsolete | ||
| 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_DOB_CHG_DATE | DATE | Obsolete | ||
| 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_SSN_CHG_DATE | DATE | Obsolete | ||
| 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_LOCAL_ADDR_CHG_DATE | DATE | Obsolete | ||
| 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_DOB_CHG_DATE | DATE | Obsolete | ||
| 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 borrwer's alien registration number or passport nunber | |
| S_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Indicates student borrower's foreign postal code | |
| 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) | Master Promissory Note Indicator | |
| 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 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
, 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
, PNOTE_BATCH_ID
, PNOTE_ACK_DATE
, PNOTE_MPN_IND
, 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 IGF.IGF_SL_LOR_LOC_ALL;
IGF.IGF_SL_LOR_LOC_ALL does not reference any database object
IGF.IGF_SL_LOR_LOC_ALL is referenced by following:
APPS
IGF_SL_LOR_LOC_ALL
|
|
|
|