[Home] [Help] [Dependency Information]
Object Name: | IGF_SL_ALT_BORW_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_SL_ALT_BORW_V |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Stores alternate loan details for student
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
ALBW_ID | NUMBER | (15) | Yes | Identifier for the additional information provided by the student for Alternate loans |
LOAN_ID | NUMBER | (15) | Yes | Identifier for loans |
FED_STAFFORD_LOAN_DEBT | NUMBER | Total Federal Stafford loan debt prior to this loan period, as known by the sending organization for the borrower | ||
FED_SLS_DEBT | NUMBER | Total Federal Supplemental Loans for Students (SLS) debt prior to this loan period, as known by the sending organization for the borrower | ||
HEAL_DEBT | NUMBER | Total Health Education Assistance Loan (HEAL) debt prior to this loan period, as known by the sending organization for the borrower | ||
PERKINS_DEBT | NUMBER | Total Perkins loan debt prior to this loan period, as known by the sending organization for the borrower | ||
OTHER_DEBT | NUMBER | Total other student educational loan debt prior to this loan period, as known by the sending organization. This amount includes both federal and alternative loans for the borrower | ||
CRDT_UNDR_DIFFT_NAME | VARCHAR2 | (30) | Credit Under Different Name CodeA 1-character code indicating if the borrower has been granted credit under a different name.Y - YesN - No | |
BORW_GROSS_ANNUAL_SAL | NUMBER | Borrower Gross Annual Salary | ||
BORW_OTHER_INCOME | NUMBER | Borrower Other Income | ||
STUDENT_MAJOR | VARCHAR2 | (30) | Student Major | |
INT_RATE_OPT | VARCHAR2 | (30) | Interest Rate Option | |
REPAYMENT_OPT_CODE | VARCHAR2 | (30) | Repayment Option Code | |
STUD_MTH_HOUSING_PYMT | NUMBER | Student Monthly Housing Payment | ||
STUD_MTH_CRDTCARD_PYMT | NUMBER | Student Monthly Credit Card Payment | ||
STUD_MTH_AUTO_PYMT | NUMBER | Student Monthly Auto Payment | ||
STUD_MTH_ED_LOAN_PYMT | NUMBER | Student Monthly Educational Loan Payment | ||
STUD_MTH_OTHER_PYMT | NUMBER | Student Monthly Other Payment | ||
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 | ||
INT_RATE_OPT_DESC | VARCHAR2 | (4000) | Interest Rate Option Description | |
REPAYMENT_OPT_DESC | VARCHAR2 | (4000) | Repayment Option Description | |
CRDT_DIF_NAME_DESC | VARCHAR2 | (4000) | Credit Difference Name Description | |
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. | ||
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 | ||
CS1_CREDIT_AUTH_CODE_DESC | VARCHAR2 | (4000) | Cosigner 1 Credit Authorization Code Description | |
CS1_ELECT_SIG_IND_CODE_DESC | VARCHAR2 | (4000) | Cosigner 1 Electronic Signature Indicator Code Description | |
CS1_REL_TO_STUDENT_FLAG_DESC | VARCHAR2 | (4000) | Cosigner 1 Relationship to Student Description | |
CS1_SIGNATURE_CODE_TXT_DESC | VARCHAR2 | (4000) | Cosigner 1 Signature Code Description | |
CS1_CITIZENSHIP_STATUS_DESC | VARCHAR2 | (4000) | Cosigner 1 U.S. Citizenship Status Code Description | |
CS2_CREDIT_AUTH_CODE_DESC | VARCHAR2 | (4000) | Cosigner 2 Credit Authorization Code Description | |
CS2_ELECT_SIG_IND_CODE_DESC | VARCHAR2 | (4000) | Cosigner 2 Electronic Signature Indicator Code Description | |
CS2_REL_TO_STUDENT_FLAG_DESC | VARCHAR2 | (4000) | Cosigner 2 Relationship to Student Description | |
CS2_SIGNATURE_CODE_TXT_DESC | VARCHAR2 | (4000) | Cosigner 2 Signature Code Description | |
CS2_CITIZENSHIP_STATUS_DESC | VARCHAR2 | (4000) | Cosigner 2 U.S. Citizenship Status Code Description |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ALBW_ID
, LOAN_ID
, FED_STAFFORD_LOAN_DEBT
, FED_SLS_DEBT
, HEAL_DEBT
, PERKINS_DEBT
, OTHER_DEBT
, CRDT_UNDR_DIFFT_NAME
, BORW_GROSS_ANNUAL_SAL
, BORW_OTHER_INCOME
, STUDENT_MAJOR
, INT_RATE_OPT
, REPAYMENT_OPT_CODE
, STUD_MTH_HOUSING_PYMT
, STUD_MTH_CRDTCARD_PYMT
, STUD_MTH_AUTO_PYMT
, STUD_MTH_ED_LOAN_PYMT
, STUD_MTH_OTHER_PYMT
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, INT_RATE_OPT_DESC
, REPAYMENT_OPT_DESC
, CRDT_DIF_NAME_DESC
, OTHER_LOAN_AMT
, 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
, CS1_CREDIT_AUTH_CODE_DESC
, CS1_ELECT_SIG_IND_CODE_DESC
, CS1_REL_TO_STUDENT_FLAG_DESC
, CS1_SIGNATURE_CODE_TXT_DESC
, CS1_CITIZENSHIP_STATUS_DESC
, CS2_CREDIT_AUTH_CODE_DESC
, CS2_ELECT_SIG_IND_CODE_DESC
, CS2_REL_TO_STUDENT_FLAG_DESC
, CS2_SIGNATURE_CODE_TXT_DESC
, CS2_CITIZENSHIP_STATUS_DESC
FROM APPS.IGF_SL_ALT_BORW_V;
APPS.IGF_SL_ALT_BORW_V is not referenced by any database object
|
|
|