[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_LI_ORIG_INTS |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_LI_ORIG_INTS
|
| Subobject Name: | |
| Status: | VALID |
Legacy Common line Origination Interface Table
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - FFELP Origination and Disbursement Data Import Process
Category: BUSINESS_ENTITY IGF_FFELP
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_LI_ORIG_INTS_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CI_ALTERNATE_CODE
PERSON_NUMBER
AWARD_NUMBER_TXT
|
| IGF_SL_LI_ORIG_INTS_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
IMPORT_STATUS_TYPE
|
| IGF_SL_LI_ORIG_INTS_N2 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
BATCH_NUM
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_NUM | NUMBER | (15) | Yes | Batch Number, used to identify the set of records included in the batch for processing |
| CI_ALTERNATE_CODE | VARCHAR2 | (10) | Yes | Alternate Code of the Batch Year. |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person Number |
| AWARD_NUMBER_TXT | VARCHAR2 | (15) | Yes | Award Number |
| LOAN_NUMBER_TXT | VARCHAR2 | (30) | Yes | Unique identifier for Direct Loan or Common Line loan |
| IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
| LOAN_SEQ_NUM | NUMBER | (2) | Yes | Indicates number of loans of current system loan type for current processing year |
| LOAN_PER_BEGIN_DATE | DATE | Yes | Indicates loan period start date | |
| LOAN_PER_END_DATE | DATE | Yes | Indicates loan period end date | |
| LOAN_STATUS_CODE | VARCHAR2 | (30) | Yes | Indicates loan status |
| LOAN_STATUS_DATE | DATE | Indicates date on which loan status changed | ||
| ACTIVE_FLAG | VARCHAR2 | (1) | Yes | Indicator that specifies whether loan is active. |
| ACTIVE_DATE | DATE | Yes | Indicates date on which loan was activated or inactivated | |
| ACT_INTEREST_RATE_NUM | NUMBER | (5) | Indicates actual interest rate | |
| ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates actual serial loan code | |
| ALT_APPL_VER_CODE_NUM | NUMBER | (4) | Indicates alternative loan application version code | |
| ALT_BORW_TOT_STU_LOAN_DEBT_AMT | NUMBER | (7) | Alternative Borrower Total Student Loan Debt | |
| ALT_PROG_TYPE_CD | VARCHAR2 | (3) | Indicates alternative loan program type code | |
| ANTICIP_COMPL_DATE | DATE | Indicates date student is anticipated to complete program at school | ||
| BORR_PERSON_NUMBER | VARCHAR2 | (30) | Borrower Person Number. | |
| B_DEFAULT_STATUS_FLAG | VARCHAR2 | (1) | Indicates if the federal plus or alternative borrower is currently in default or owes a refund | |
| B_FOREIGN_POSTAL_CD | VARCHAR2 | (30) | Indicates permanent foreign postal code | |
| B_STU_INDICATOR_FLAG | VARCHAR2 | (1) | Indicates if the alternative borrower is a student or not | |
| B_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which the permanent address was last updated | ||
| B_REFERENCE_FLAG | VARCHAR2 | (1) | Indicates if a borrower reference is complete or not. | |
| B_SIGNATURE_FLAG | VARCHAR2 | (1) | Indicates whether the sender has a valid signed promissory note or not. | |
| B_SIGNATURE_DATE | DATE | Indicates borrower signature date | ||
| BORR_CREDIT_AUTH_FLAG | VARCHAR2 | (1) | Borrower Credit Authorization Code | |
| BORR_SIGN_FLAG | VARCHAR2 | (1) | Indicates if the promissory note was electronically signed by the Borrower | |
| BORW_CONFIRM_FLAG | VARCHAR2 | (1) | Indicates borrower's confirmation of loan | |
| BORW_GROSS_ANNUAL_SAL_AMT | NUMBER | (7) | Borrower Gross Annual Salary | |
| BORW_INTEREST_FLAG | VARCHAR2 | (1) | Indicates whether the borrower intends to pay interest on loan while in school, grace, or deferment | |
| BORW_OTHER_INCOME_AMT | NUMBER | (7) | Borrower Other Income. | |
| BORW_OUTSTD_LOAN_FLAG | VARCHAR2 | (1) | Indicates if the Federal plus or alternative borrower has outstanding loans | |
| CL_SEQ_NUM | NUMBER | (2) | Indicates the value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for FFELP loan | |
| CRDT_UNDR_DIFFT_NAME_FLAG | VARCHAR2 | (1) | Indicates if the borrower has been granted credit under a different name. | |
| COA_AMT | NUMBER | (5) | Indicates cost of attendance | |
| CREDIT_STATUS_CODE | VARCHAR2 | (30) | Indicates credit status code | |
| CREDIT_STATUS_DATE | DATE | Indicates credit status date or time stamp | ||
| EFC_AMT | NUMBER | (5) | Indicates Expected Family Contribution amount | |
| EFT_AUTH_FLAG | VARCHAR2 | (1) | Indicates if the transfer of loan proceeds has been authorized or not. | |
| ENROLLMENT_CODE | VARCHAR2 | (30) | Indicates enrollment status code | |
| ERR_MESG_1_CD | VARCHAR2 | (3) | Indicates application send error message code 1 | |
| ERR_MESG_2_CD | VARCHAR2 | (3) | Indicates application send error message code 2 | |
| ERR_MESG_3_CD | VARCHAR2 | (3) | Indicates application send error message code 3 | |
| ERR_MESG_4_CD | VARCHAR2 | (3) | Indicates application send error message code 4 | |
| ERR_MESG_5_CD | VARCHAR2 | (3) | Indicates application send error message code 5 | |
| EST_FA_AMT | NUMBER | (5) | Indicates estimated financial aid amount | |
| FED_SLS_DEBT_AMT | NUMBER | (5) | Federal SLS Debt | |
| FED_STAFFORD_LOAN_DEBT_AMT | NUMBER | (5) | Federal Stafford Loan Debt | |
| FED_APPL_FORM_TYPE | VARCHAR2 | (1) | Indicates federal application form code. | |
| FLP_APPROVED_AMT | NUMBER | (5) | Indicates federal PLUS approved amount | |
| FLP_CERT_AMT | NUMBER | (5) | Indicates federal PLUS certified amount | |
| FLS_APPROVED_AMT | NUMBER | (5) | Indicates subsidized federal Stafford approved amount | |
| FLS_CERT_AMT | NUMBER | (5) | Indicates subsidized federal Stafford certified amount | |
| FLU_APPROVED_AMT | NUMBER | (5) | Indicates unsubsidized federal Stafford approved amount | |
| FLU_CERT_AMT | NUMBER | (5) | Indicates unsubsidized federal Stafford certified amount | |
| GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates grade level code of the student at the time the loan was originated | |
| GUARANTEE_AMT | NUMBER | (7) | Indicates guarantee amount | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARANTOR_ID_TXT | VARCHAR2 | (3) | Obsolete | |
| GUARNT_ADJ_FLAG | VARCHAR2 | (1) | Indicates if guarantee amount has been adjusted or not. | |
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (30) | Indicates guarantee amount reduction code | |
| GUARNT_STATUS_CODE | VARCHAR2 | (30) | Indicates guarantor status code | |
| GUARNT_STATUS_DATE | DATE | Indicates guarantor status date or time stamp | ||
| HEAL_DEBT_AMT | NUMBER | (6) | HEAL Debt | |
| INT_RATE_OPT_CODE | VARCHAR2 | (30) | Interest Rate Option | |
| LAST_RESORT_LENDER_FLAG | VARCHAR2 | (1) | Indicates whether the lender is an eligible lender of the last | |
| LEND_NON_ED_BRC_ID_TXT | VARCHAR2 | (4) | Obsolete | |
| LEND_STATUS_CODE | VARCHAR2 | (30) | Indicates lender-servicer status code | |
| LEND_STATUS_DATE | DATE | Indicates lender-servicer status date or time stamp | ||
| LENDER_ID_TXT | VARCHAR2 | (6) | Obsolete | |
| LEND_BLKT_GUARNT_APPR_DATE | DATE | Indicates lender blanket guarantee approval date | ||
| LEND_BLKT_GUARNT_FLAG | VARCHAR2 | (1) | Lender blanket guarantee indicator | |
| ORIG_ACK_BATCH_ID_TXT | VARCHAR2 | (12) | Origination Response Batch ID | |
| ORIG_ACK_DATE | DATE | Origination Response Batch Date | ||
| ORIG_BATCH_DATE | DATE | Origination Send Batch Sent Date | ||
| ORIG_SEND_BATCH_ID_TXT | VARCHAR2 | (12) | Origination Send Batch ID | |
| OTHER_DEBT_AMT | NUMBER | (6) | Other Debt | |
| PERKINS_DEBT_AMT | NUMBER | (5) | Perkins Debt | |
| PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | Indicates promissory note delivery code | |
| PNOTE_STATUS_CODE | VARCHAR2 | (30) | Indicates promissory note status code | |
| PNOTE_STATUS_DATE | DATE | Indicates promissory note status date or time stamp | ||
| PRC_TYPE_CODE | VARCHAR2 | (30) | Indicates processing type code | |
| RECORD_CODE | VARCHAR2 | (30) | Record type Indicator Code, Indicates if Record is a new application or a Correction Application or a Reprint or Terminate request | |
| RECIPIENT_TYPE | VARCHAR2 | (30) | Obsolete | |
| RECIPIENT_NON_ED_BRC_ID_TXT | VARCHAR2 | (4) | Obsolete | |
| RECIPIENT_ID_TXT | VARCHAR2 | (8) | Obsolete | |
| REPAYMENT_OPT_CODE | VARCHAR2 | (30) | Repayment Option Code | |
| REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | A 1-character code used to indicate how the school intends to use the Master Promissory Note for this certification. | |
| RESP_TO_ORIG_FLAG | VARCHAR2 | (1) | Indicates if the response record is being sent to the originator of the send record | |
| REV_NOTICE_OF_GUARNT_CODE | VARCHAR2 | (30) | Revised Notice of Guarantee Indicator Code | |
| REQ_LOAN_AMT | NUMBER | (6) | Indicates requested loan amount | |
| S_DEFAULT_STATUS_FLAG | VARCHAR2 | (1) | Indicates if the Federal plus or Alternative student borrower is currently in default or owes a refund | |
| S_SIGNATURE_FLAG | VARCHAR2 | (1) | Indicates if the federal plus or alternative student has signed the application or not. | |
| SCH_CERT_DATE | DATE | Indicates school certification date | ||
| SCH_NON_ED_BRC_ID_TXT | VARCHAR2 | (4) | Indicates unique identification code assigned by entity other than US Department of Education to school's branch office | |
| SCH_REFUND_AMT | NUMBER | (7) | Indicates school post-withdrawal return amount | |
| SCH_REFUND_DATE | DATE | Indicates date of post-withdrawal return to lender | ||
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Indicates service type code | |
| STUD_MTH_AUTO_PYMT_AMT | NUMBER | (5) | Student Monthly Auto Payment | |
| STUD_MTH_CRDTCARD_PYMT_AMT | NUMBER | (5) | Student Monthly Credit Card Payment | |
| STUD_MTH_ED_LOAN_PYMT_AMT | NUMBER | (5) | Student Monthly Educational Payment | |
| STUD_MTH_HOUSING_PYMT_AMT | NUMBER | (5) | Student Monthly Housing Payment | |
| STUD_MTH_OTHER_PYMT_AMT | NUMBER | (5) | Student Monthly Other Payment | |
| STUD_SIGN_FLAG | VARCHAR2 | (1) | Indicates if the promissory note is electronically signed by the student | |
| STUDENT_MAJOR_TXT | VARCHAR2 | (30) | Student Major | |
| TOT_OUTSTD_PLUS_AMT | NUMBER | (8) | Indicates total outstanding federal PLUS loan amount | |
| TOT_OUTSTD_STAFFORD_AMT | NUMBER | (8) | Indicates total outstanding federal Stafford or subsidized loan Stafford loan amount | |
| UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | Indicates unique layout identifier code | |
| UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (30) | Indicates unique layout vendor code | |
| ORIG_BATCH_ID_TXT | VARCHAR2 | (40) | Origination Batch ID | |
| DEFER_REQ_FLAG | VARCHAR2 | (1) | Indicates if the borrower requests immediate deferment | |
| ALT_CERT_AMT | NUMBER | (5) | Alternative Loan Certified Amount | |
| ALT_APPROVED_AMT | NUMBER | (5) | Alternative Loan Approved Amount | |
| B_LICENSE_STATE_CODE | VARCHAR2 | (30) | Borrower License State Code. | |
| B_LICENSE_NUMBER_TXT | VARCHAR2 | (20) | Borrower License Number Text | |
| FILE_CREATION_DATE | DATE | File Creation Date | ||
| FILE_TRANS_DATE | DATE | File Transmitted Date | ||
| SEND_RESP_CODE | VARCHAR2 | (30) | File Identifier Codes i.e. send record, response record. | |
| SOURCE_ID_TXT | VARCHAR2 | (8) | Source Identifier | |
| SOURCE_NON_ED_BRC_ID_TXT | VARCHAR2 | (4) | Source Non ED Identifier | |
| REINST_AVAIL_AMT | NUMBER | (7) | Amount available for Reinstatement | |
| IMPORT_RECORD_TYPE | VARCHAR2 | (1) | Indicates whether the imported record is for Insert or Update | |
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| CREATION_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | 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 | ||
| RELATIONSHIP_CD | VARCHAR2 | (30) | Relationship code | |
| EXTERNAL_LOAN_ID_TXT | VARCHAR2 | (30) | External Loan Number. This Loan Number would be updated from School Certification Request for FELP Loans | |
| 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 | |
| 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 | ||
| 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 | |
| OTHER_LOAN_AMT | NUMBER | The borrowers total other student educational loan debt for this loan period, as reported by the creator of the Application Send File. This amount includes both federal and alternative loans | ||
| 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 | |
| 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 | ||
| CS1_LNAME | VARCHAR2 | (35) | Cosigner 1 Last Name | |
| CS1_FNAME | VARCHAR2 | (12) | Cosigner 1 First Name | |
| CS1_MI_TXT | VARCHAR2 | (1) | Cosigner 1 Middle Initial | |
| CS1_SSN_TXT | VARCHAR2 | (9) | Cosigner 1 SSN | |
| CS1_CITIZENSHIP_STATUS | VARCHAR2 | (1) | Cosigner 1 U.S. Citizenship Status Code | |
| CS1_ADDRESS_LINE_1_TXT | VARCHAR2 | (30) | Cosigner 1 Address (line 1) | |
| CS1_ADDRESS_LINE_2_TXT | VARCHAR2 | (30) | Cosigner 1 Address (line 2) | |
| CS1_CITY_TXT | VARCHAR2 | (24) | Cosigner 1 City | |
| CS1_STATE_TXT | VARCHAR2 | (2) | Cosigner 1 State | |
| CS1_ZIP_TXT | VARCHAR2 | (5) | Cosigner 1 Zip Code | |
| CS1_ZIP_SUFFIX_TXT | VARCHAR2 | (4) | Cosigner 1 Zip Code Suffix | |
| CS1_TELEPHONE_NUMBER_TXT | VARCHAR2 | (10) | Cosigner 1 Telephone Number | |
| CS1_SIGNATURE_CODE_TXT | VARCHAR2 | (1) | Cosigner 1 Signature Code | |
| CS2_LNAME | VARCHAR2 | (35) | Cosigner 2 Last Name | |
| CS2_FNAME | VARCHAR2 | (12) | Cosigner 2 First Name | |
| CS2_MI_TXT | VARCHAR2 | (1) | Cosigner 2 Middle Initial | |
| CS2_SSN_TXT | VARCHAR2 | (9) | Cosigner 2 SSN | |
| CS2_CITIZENSHIP_STATUS | VARCHAR2 | (1) | Cosigner 2 U.S. Citizenship Status Code | |
| CS2_ADDRESS_LINE_1_TXT | VARCHAR2 | (30) | Cosigner 2 Address (line 1) | |
| CS2_ADDRESS_LINE_2_TXT | VARCHAR2 | (30) | Cosigner 2 Address (line 2) | |
| CS2_CITY_TXT | VARCHAR2 | (24) | Cosigner 2 City | |
| CS2_STATE_TXT | VARCHAR2 | (2) | Cosigner 2 State | |
| CS2_ZIP_TXT | VARCHAR2 | (5) | Cosigner 2 Zip Code | |
| CS2_ZIP_SUFFIX_TXT | VARCHAR2 | (4) | Cosigner 2 Zip Code Suffix | |
| CS2_TELEPHONE_NUMBER_TXT | VARCHAR2 | (10) | Cosigner 2 Telephone Number | |
| CS2_SIGNATURE_CODE_TXT | VARCHAR2 | (1) | Cosigner 2 Signature Code | |
| CS1_CREDIT_AUTH_CODE_TXT | VARCHAR2 | (1) | Cosigner 1 Credit Authorization Code | |
| CS1_BIRTH_DATE | DATE | Cosigner 1 Date of Birth | ||
| CS1_DRV_LICENSE_NUM_TXT | VARCHAR2 | (20) | Cosigner 1 Driver's License Number | |
| CS1_DRV_LICENSE_STATE_TXT | VARCHAR2 | (2) | Cosigner 1 Driver's License State | |
| CS1_ELECT_SIG_IND_CODE_TXT | VARCHAR2 | (1) | Cosigner 1 Electronic Signature Indicator Code | |
| CS1_FRGN_POSTAL_CODE_TXT | VARCHAR2 | (14) | Cosigner 1 Foreign Postal Code | |
| CS1_FRGN_TEL_NUM_PREFIX_TXT | VARCHAR2 | (10) | Cosigner 1 Foreign Telephone Number Prefix | |
| CS1_GROSS_ANNUAL_SAL_NUM | NUMBER | Cosigner 1 Gross Annual Salary | ||
| CS1_MTHL_AUTO_PAY_TXT | VARCHAR2 | (5) | Cosigner 1 Monthly Auto Payment | |
| CS1_MTHL_CC_PAY_TXT | VARCHAR2 | (5) | Cosigner 1 Monthly Credit Card Payment | |
| CS1_MTHL_EDU_LOAN_PAY_TXT | VARCHAR2 | (5) | Cosigner 1 Monthly Educational Loan Payment | |
| CS1_MTHL_HOUSING_PAY_TXT | VARCHAR2 | (5) | Cosigner 1 Monthly Housing Payment | |
| CS1_MTHL_OTHER_PAY_TXT | VARCHAR2 | (5) | Cosigner 1 Monthly Other Payment | |
| CS1_OTHER_INCOME_AMT | NUMBER | Cosigner 1 Other Income | ||
| CS1_REL_TO_STUDENT_FLAG | VARCHAR2 | (1) | Cosigner 1 Relationship to Student | |
| CS1_SUFFIX_TXT | VARCHAR2 | (3) | Cosigner 1 Suffix | |
| CS1_YEARS_AT_ADDRESS_TXT | NUMBER | Cosigner 1 Years at Address | ||
| CS2_CREDIT_AUTH_CODE_TXT | VARCHAR2 | (1) | Cosigner 2 Credit Authorization Code | |
| CS2_BIRTH_DATE | DATE | Cosigner 2 Date of Birth | ||
| CS2_DRV_LICENSE_NUM_TXT | VARCHAR2 | (20) | Cosigner 2 Driver's License Number | |
| CS2_DRV_LICENSE_STATE_TXT | VARCHAR2 | (2) | Cosigner 2 Driver's License State | |
| CS2_ELECT_SIG_IND_CODE_TXT | VARCHAR2 | (1) | Cosigner 2 Electronic Signature Indicator Code | |
| CS2_FRGN_POSTAL_CODE_TXT | VARCHAR2 | (14) | Cosigner 2 Foreign Postal Code | |
| CS2_FRGN_TEL_NUM_PREFIX_TXT | VARCHAR2 | (10) | Cosigner 2 Foreign Telephone Number Prefix | |
| CS2_GROSS_ANNUAL_SAL_NUM | NUMBER | Cosigner 2 Gross Annual Salary | ||
| CS2_MTHL_AUTO_PAY_TXT | VARCHAR2 | (5) | Cosigner 2 Monthly Auto Payment | |
| CS2_MTHL_CC_PAY_TXT | VARCHAR2 | (5) | Cosigner 2 Monthly Credit Card Payment | |
| CS2_MTHL_EDU_LOAN_PAY_TXT | VARCHAR2 | (5) | Cosigner 2 Monthly Educational Loan Payment | |
| CS2_MTHL_HOUSING_PAY_TXT | VARCHAR2 | (5) | Cosigner 2 Monthly Housing Payment | |
| CS2_MTHL_OTHER_PAY_TXT | VARCHAR2 | (5) | Cosigner 2 Monthly Other Payment | |
| CS2_OTHER_INCOME_AMT | NUMBER | Cosigner 2 Other Income | ||
| CS2_REL_TO_STUDENT_FLAG | VARCHAR2 | (1) | Cosigner 2 Relationship to Student | |
| CS2_SUFFIX_TXT | VARCHAR2 | (3) | Cosigner 2 Suffix | |
| CS2_YEARS_AT_ADDRESS_TXT | NUMBER | Cosigner 2 Years at Address | ||
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUM
, CI_ALTERNATE_CODE
, PERSON_NUMBER
, AWARD_NUMBER_TXT
, LOAN_NUMBER_TXT
, IMPORT_STATUS_TYPE
, LOAN_SEQ_NUM
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, LOAN_STATUS_CODE
, LOAN_STATUS_DATE
, ACTIVE_FLAG
, ACTIVE_DATE
, ACT_INTEREST_RATE_NUM
, ACT_SERIAL_LOAN_CODE
, ALT_APPL_VER_CODE_NUM
, ALT_BORW_TOT_STU_LOAN_DEBT_AMT
, ALT_PROG_TYPE_CD
, ANTICIP_COMPL_DATE
, BORR_PERSON_NUMBER
, B_DEFAULT_STATUS_FLAG
, B_FOREIGN_POSTAL_CD
, B_STU_INDICATOR_FLAG
, B_PERMT_ADDR_CHG_DATE
, B_REFERENCE_FLAG
, B_SIGNATURE_FLAG
, B_SIGNATURE_DATE
, BORR_CREDIT_AUTH_FLAG
, BORR_SIGN_FLAG
, BORW_CONFIRM_FLAG
, BORW_GROSS_ANNUAL_SAL_AMT
, BORW_INTEREST_FLAG
, BORW_OTHER_INCOME_AMT
, BORW_OUTSTD_LOAN_FLAG
, CL_SEQ_NUM
, CRDT_UNDR_DIFFT_NAME_FLAG
, COA_AMT
, CREDIT_STATUS_CODE
, CREDIT_STATUS_DATE
, EFC_AMT
, EFT_AUTH_FLAG
, ENROLLMENT_CODE
, ERR_MESG_1_CD
, ERR_MESG_2_CD
, ERR_MESG_3_CD
, ERR_MESG_4_CD
, ERR_MESG_5_CD
, EST_FA_AMT
, FED_SLS_DEBT_AMT
, FED_STAFFORD_LOAN_DEBT_AMT
, FED_APPL_FORM_TYPE
, FLP_APPROVED_AMT
, FLP_CERT_AMT
, FLS_APPROVED_AMT
, FLS_CERT_AMT
, FLU_APPROVED_AMT
, FLU_CERT_AMT
, GRADE_LEVEL_CODE
, GUARANTEE_AMT
, GUARANTEE_DATE
, GUARANTOR_ID_TXT
, GUARNT_ADJ_FLAG
, GUARNT_AMT_REDN_CODE
, GUARNT_STATUS_CODE
, GUARNT_STATUS_DATE
, HEAL_DEBT_AMT
, INT_RATE_OPT_CODE
, LAST_RESORT_LENDER_FLAG
, LEND_NON_ED_BRC_ID_TXT
, LEND_STATUS_CODE
, LEND_STATUS_DATE
, LENDER_ID_TXT
, LEND_BLKT_GUARNT_APPR_DATE
, LEND_BLKT_GUARNT_FLAG
, ORIG_ACK_BATCH_ID_TXT
, ORIG_ACK_DATE
, ORIG_BATCH_DATE
, ORIG_SEND_BATCH_ID_TXT
, OTHER_DEBT_AMT
, PERKINS_DEBT_AMT
, PNOTE_DELIVERY_CODE
, PNOTE_STATUS_CODE
, PNOTE_STATUS_DATE
, PRC_TYPE_CODE
, RECORD_CODE
, RECIPIENT_TYPE
, RECIPIENT_NON_ED_BRC_ID_TXT
, RECIPIENT_ID_TXT
, REPAYMENT_OPT_CODE
, REQ_SERIAL_LOAN_CODE
, RESP_TO_ORIG_FLAG
, REV_NOTICE_OF_GUARNT_CODE
, REQ_LOAN_AMT
, S_DEFAULT_STATUS_FLAG
, S_SIGNATURE_FLAG
, SCH_CERT_DATE
, SCH_NON_ED_BRC_ID_TXT
, SCH_REFUND_AMT
, SCH_REFUND_DATE
, SERVICE_TYPE_CODE
, STUD_MTH_AUTO_PYMT_AMT
, STUD_MTH_CRDTCARD_PYMT_AMT
, STUD_MTH_ED_LOAN_PYMT_AMT
, STUD_MTH_HOUSING_PYMT_AMT
, STUD_MTH_OTHER_PYMT_AMT
, STUD_SIGN_FLAG
, STUDENT_MAJOR_TXT
, TOT_OUTSTD_PLUS_AMT
, TOT_OUTSTD_STAFFORD_AMT
, UNIQ_LAYOUT_IDENT_CODE
, UNIQ_LAYOUT_VEND_CODE
, ORIG_BATCH_ID_TXT
, DEFER_REQ_FLAG
, ALT_CERT_AMT
, ALT_APPROVED_AMT
, B_LICENSE_STATE_CODE
, B_LICENSE_NUMBER_TXT
, FILE_CREATION_DATE
, FILE_TRANS_DATE
, SEND_RESP_CODE
, SOURCE_ID_TXT
, SOURCE_NON_ED_BRC_ID_TXT
, REINST_AVAIL_AMT
, IMPORT_RECORD_TYPE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, RELATIONSHIP_CD
, EXTERNAL_LOAN_ID_TXT
, SCHOOL_USE_TXT
, LENDER_USE_TXT
, GUARANTOR_USE_TXT
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, MPN_CONFIRM_CODE
, OTHER_LOAN_AMT
, ACTUAL_RECORD_TYPE_CODE
, LEND_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, CS1_LNAME
, CS1_FNAME
, CS1_MI_TXT
, CS1_SSN_TXT
, CS1_CITIZENSHIP_STATUS
, CS1_ADDRESS_LINE_1_TXT
, CS1_ADDRESS_LINE_2_TXT
, CS1_CITY_TXT
, CS1_STATE_TXT
, CS1_ZIP_TXT
, CS1_ZIP_SUFFIX_TXT
, CS1_TELEPHONE_NUMBER_TXT
, CS1_SIGNATURE_CODE_TXT
, CS2_LNAME
, CS2_FNAME
, CS2_MI_TXT
, CS2_SSN_TXT
, CS2_CITIZENSHIP_STATUS
, CS2_ADDRESS_LINE_1_TXT
, CS2_ADDRESS_LINE_2_TXT
, CS2_CITY_TXT
, CS2_STATE_TXT
, CS2_ZIP_TXT
, CS2_ZIP_SUFFIX_TXT
, CS2_TELEPHONE_NUMBER_TXT
, CS2_SIGNATURE_CODE_TXT
, CS1_CREDIT_AUTH_CODE_TXT
, CS1_BIRTH_DATE
, CS1_DRV_LICENSE_NUM_TXT
, CS1_DRV_LICENSE_STATE_TXT
, CS1_ELECT_SIG_IND_CODE_TXT
, CS1_FRGN_POSTAL_CODE_TXT
, CS1_FRGN_TEL_NUM_PREFIX_TXT
, CS1_GROSS_ANNUAL_SAL_NUM
, CS1_MTHL_AUTO_PAY_TXT
, CS1_MTHL_CC_PAY_TXT
, CS1_MTHL_EDU_LOAN_PAY_TXT
, CS1_MTHL_HOUSING_PAY_TXT
, CS1_MTHL_OTHER_PAY_TXT
, CS1_OTHER_INCOME_AMT
, CS1_REL_TO_STUDENT_FLAG
, CS1_SUFFIX_TXT
, CS1_YEARS_AT_ADDRESS_TXT
, CS2_CREDIT_AUTH_CODE_TXT
, CS2_BIRTH_DATE
, CS2_DRV_LICENSE_NUM_TXT
, CS2_DRV_LICENSE_STATE_TXT
, CS2_ELECT_SIG_IND_CODE_TXT
, CS2_FRGN_POSTAL_CODE_TXT
, CS2_FRGN_TEL_NUM_PREFIX_TXT
, CS2_GROSS_ANNUAL_SAL_NUM
, CS2_MTHL_AUTO_PAY_TXT
, CS2_MTHL_CC_PAY_TXT
, CS2_MTHL_EDU_LOAN_PAY_TXT
, CS2_MTHL_HOUSING_PAY_TXT
, CS2_MTHL_OTHER_PAY_TXT
, CS2_OTHER_INCOME_AMT
, CS2_REL_TO_STUDENT_FLAG
, CS2_SUFFIX_TXT
, CS2_YEARS_AT_ADDRESS_TXT
, ESIGN_SRC_TYP_CD
FROM IGF.IGF_SL_LI_ORIG_INTS;
IGF.IGF_SL_LI_ORIG_INTS does not reference any database object
IGF.IGF_SL_LI_ORIG_INTS is referenced by following:
APPS
IGF_SL_LI_ORIG_INTS
|
|
|
|