[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_SL_CL_RESP_R1_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_SL_CL_RESP_R1_ALL
|
| Subobject Name: | |
| Status: | VALID |
IGF_SL_CL_RESP_R1_ALL maintains the CommonLine response from external processor.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_SL_CL_RESP_R1_ALL_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CLRP1_ID
|
| IGF_SL_CL_RESP_R1_ALL_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
LOAN_NUMBER
CLRP1_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CLRP1_ID | NUMBER | (15) | Yes | Identifer for CommonLine response |
| CBTH_ID | NUMBER | (15) | Yes | Identifier for batch |
| REC_CODE | VARCHAR2 | (2) | Yes | Indicates record types |
| REC_TYPE_IND | VARCHAR2 | (30) | Yes | Indicates if record is school certification request, modification response after first notification of guarantee, reprint response, change transaction send response, application response up to first notification of guarantee, or service provider does not support change transaction |
| B_LAST_NAME | VARCHAR2 | (150) | Indicates borrower's last name | |
| B_FIRST_NAME | VARCHAR2 | (150) | Borrower First Name | |
| B_MIDDLE_NAME | VARCHAR2 | (150) | Indicates borrower's middle name | |
| B_SSN | NUMBER | (9) | Indicates borrower's SSN | |
| B_PERMT_ADDR1 | VARCHAR2 | (240) | Indicates borrower's permanent address line 1 | |
| B_PERMT_ADDR2 | VARCHAR2 | (240) | Indicates borrower's permanent address line 2 | |
| B_PERMT_CITY | VARCHAR2 | (60) | Indicates borrower's permanent city | |
| B_PERMT_STATE | VARCHAR2 | (60) | Indicates borrower's permanent state | |
| B_PERMT_ZIP | NUMBER | (30) | Indicates borrower's permanent zip code | |
| B_PERMT_ZIP_SUFFIX | NUMBER | (30) | Indicates borrower's permanent zip code suffix | |
| B_PERMT_PHONE | VARCHAR2 | (60) | Indicates borrower's telephone number | |
| B_DATE_OF_BIRTH | DATE | Indicates borrower's date of birth | ||
| CL_LOAN_TYPE | VARCHAR2 | (30) | Indicates CommonLine loan type requested by the borrower | |
| REQ_LOAN_AMT | NUMBER | (12) | Indicates requested loan amount | |
| DEFER_REQ_CODE | VARCHAR2 | (30) | Indicates deferment request code | |
| BORW_INTEREST_IND | VARCHAR2 | (30) | Indicates whether the borrower intends to pay interest on loan while in school, grace, or deferment | |
| EFT_AUTH_CODE | VARCHAR2 | (30) | Indicates EFT authorization code | |
| B_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates borrower signature code | |
| B_SIGNATURE_DATE | DATE | Indicates borrower signature date | ||
| LOAN_NUMBER | VARCHAR2 | (30) | Indicates unique identifier identifying CommonLine loan application | |
| CL_SEQ_NUMBER | NUMBER | (15) | Indicates the value assigned by guarantor at time of guarantee or by lender in case of blanket guarantee for CommonLine loan | |
| B_CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates U.S. citizenship status code of PLUS or alternative borrower | |
| B_STATE_OF_LEGAL_RES | VARCHAR2 | (30) | Indicates state of legal residence of PLUS borrower | |
| B_LEGAL_RES_DATE | DATE | Indicates date when PLUS borrower took up legal residence | ||
| B_DEFAULT_STATUS | VARCHAR2 | (30) | Indicates default or refund status code of PLUS or alternative borrower | |
| B_OUTSTD_LOAN_CODE | VARCHAR2 | (30) | Indicates outstanding loan code of PLUS borrower | |
| B_INDICATOR_CODE | VARCHAR2 | (30) | Indicates alternative student or borrower indicator code | |
| S_LAST_NAME | VARCHAR2 | (150) | Indicates student's last name | |
| S_FIRST_NAME | VARCHAR2 | (60) | Indicates student's first name | |
| S_MIDDLE_NAME | VARCHAR2 | (150) | Indicates student's middle name | |
| S_SSN | NUMBER | (9) | Indicates student's SSN | |
| S_DATE_OF_BIRTH | DATE | Indicates student's date of birth | ||
| S_CITIZENSHIP_STATUS | VARCHAR2 | (30) | Indicates U.S. citizenship status code of student | |
| S_DEFAULT_CODE | VARCHAR2 | (30) | Indicates student's default code | |
| S_SIGNATURE_CODE | VARCHAR2 | (30) | Indicates student's signature code | |
| SCHOOL_ID | NUMBER | (15) | Indicates school identifier | |
| LOAN_PER_BEGIN_DATE | DATE | Indicates loan period begin date | ||
| LOAN_PER_END_DATE | DATE | Indicates loan period end date | ||
| GRADE_LEVEL_CODE | VARCHAR2 | (30) | Indicates grade level code of the student at the time the loan was originated | |
| ENROLLMENT_CODE | VARCHAR2 | (30) | Indicates enrollment status code | |
| ANTICIP_COMPL_DATE | DATE | Indicates date student is anticipated to complete program at school | ||
| COA_AMT | NUMBER | (12) | Indicates cost of attendance | |
| EFC_AMT | NUMBER | (12) | Indicates EFC amount | |
| EST_FA_AMT | NUMBER | (12) | Indicates estimated financial aid amount | |
| FLS_CERT_AMT | NUMBER | (12) | Indicates subsidized federal Stafford certified amount | |
| FLU_CERT_AMT | NUMBER | (12) | Indicates unsubsidized federal Stafford certified amount | |
| FLP_CERT_AMT | NUMBER | (12) | Indicates federal PLUS certified amount | |
| SCH_CERT_DATE | DATE | Indicates school certification date | ||
| ALT_CERT_AMT | NUMBER | (12) | Indicates alternative loan certified amount | |
| ALT_APPL_VER_CODE | NUMBER | (30) | Indicates alternative loan application version code | |
| DUNS_SCHOOL_ID | VARCHAR2 | (30) | Indicates DUNS number assigned by US Department of Education to school | |
| LENDER_ID | VARCHAR2 | (30) | Identifier for lender | |
| FLS_APPROVED_AMT | NUMBER | (12) | Indicates subsidized federal Stafford approved amount | |
| FLU_APPROVED_AMT | NUMBER | (12) | Indicates unsubsidized federal Stafford approved amount | |
| FLP_APPROVED_AMT | NUMBER | (12) | Indicates federal PLUS approved amount | |
| ALT_APPROVED_AMT | NUMBER | (12) | Indicates alternative loan approved amount | |
| DUNS_LENDER_ID | VARCHAR2 | (30) | Indicates DUNS number assigned by US Department of Education to lender | |
| GUARANTOR_ID | VARCHAR2 | (30) | Identifier for guarantor | |
| FED_APPL_FORM_CODE | VARCHAR2 | (30) | Indicates federal application form code | |
| DUNS_GUARNT_ID | VARCHAR2 | (30) | Indicates DUNS number assigned by US Department of Education to guarantor | |
| LEND_BLKT_GUARNT_IND | VARCHAR2 | (30) | Indicates lender blanket guarantee indicator code | |
| LEND_BLKT_GUARNT_APPR_DATE | DATE | Indicates lender blanket guarantee approval date | ||
| GUARNT_ADJ_IND | VARCHAR2 | (30) | Indicates guarantee adjustment indicator code | |
| GUARANTEE_DATE | DATE | Indicates guarantee date | ||
| GUARANTEE_AMT | NUMBER | (12) | Indicates guarantee amount | |
| REQ_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates requested serial loan code | |
| BORW_CONFIRM_IND | VARCHAR2 | (30) | Indicates borrower's confirmation of loan | |
| B_LICENSE_STATE | VARCHAR2 | (30) | Indicates borrower driver's license state | |
| B_LICENSE_NUMBER | VARCHAR2 | (30) | Indicates borrower driver's license number | |
| B_REF_CODE | VARCHAR2 | (30) | Indicates borrower references code | |
| PNOTE_DELIVERY_CODE | VARCHAR2 | (30) | Indicates promissory note delivery code | |
| B_FOREIGN_POSTAL_CODE | VARCHAR2 | (30) | Indicates permanent foreign postal code | |
| 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 | |
| LAST_RESORT_LENDER | VARCHAR2 | (30) | Indicates whether the lender is an eligible lender of the last resort for which the value will be updated by the service provider | |
| RESP_TO_ORIG_CODE | VARCHAR2 | (30) | Indicates response to originator code | |
| ERR_MESG_1 | VARCHAR2 | (30) | Indicates application send error message code 1 | |
| ERR_MESG_2 | VARCHAR2 | (30) | Indicates application send error message code 2 | |
| ERR_MESG_3 | VARCHAR2 | (30) | Indicates application send error message code 3 | |
| ERR_MESG_4 | VARCHAR2 | (30) | Indicates application send error message code 4 | |
| ERR_MESG_5 | VARCHAR2 | (30) | Indicates application send error message code 5 | |
| GUARNT_AMT_REDN_CODE | VARCHAR2 | (30) | Indicates guarantee amount reduction code | |
| TOT_OUTSTD_STAFFORD | NUMBER | (12) | Indicates total outstanding federal Stafford or subsidized loan Stafford loan amount | |
| TOT_OUTSTD_PLUS | NUMBER | (12) | Indicates total outstanding federal PLUS loan amount | |
| B_PERMT_ADDR_CHG_DATE | DATE | Indicates date on which the permanent address was last updated | ||
| ALT_PROG_TYPE_CODE | VARCHAR2 | (30) | Indicates alternative loan program type code | |
| ALT_BORW_TOT_DEBT | NUMBER | (15) | Indicates total debt of alternative loan for borrower | |
| ACT_INTEREST_RATE | NUMBER | (6) | Indicates actual interest rate | |
| PRC_TYPE_CODE | VARCHAR2 | (30) | Indicates processing type code | |
| SERVICE_TYPE_CODE | VARCHAR2 | (30) | Indicates service type code | |
| REV_NOTICE_OF_GUARNT | VARCHAR2 | (30) | Indicates revised notice of guarantee indicator code | |
| SCH_REFUND_AMT | NUMBER | (12) | Indicates school post-withdrawal return amount | |
| SCH_REFUND_DATE | DATE | Indicates date of post-withdrawal return to lender | ||
| GUARNT_STATUS_CODE | VARCHAR2 | (30) | Indicates guarantor status code | |
| LENDER_STATUS_CODE | VARCHAR2 | (30) | Indicates lender-servicer status code | |
| PNOTE_STATUS_CODE | VARCHAR2 | (30) | Indicates promissory note status code | |
| CREDIT_STATUS_CODE | VARCHAR2 | (30) | Indicates credit status code | |
| GUARNT_STATUS_DATE | DATE | Indicates guarantor status date or time stamp | ||
| LENDER_STATUS_DATE | DATE | Indicates lender-servicer status date or time stamp | ||
| PNOTE_STATUS_DATE | DATE | Indicates promissory note status date or time stamp | ||
| CREDIT_STATUS_DATE | DATE | Indicates credit status date or time stamp | ||
| ACT_SERIAL_LOAN_CODE | VARCHAR2 | (30) | Indicates actual serial loan code | |
| AMT_AVAIL_FOR_REINST | NUMBER | (12) | Indicates amount available for reinstatement | |
| SCH_NON_ED_BRC_ID | VARCHAR2 | (30) | Indicates unique identification code assigned by entity other than US Department of Education to school's branch office | |
| UNIQ_LAYOUT_VEND_CODE | VARCHAR2 | (30) | Indicates unique layout vendor code | |
| UNIQ_LAYOUT_IDENT_CODE | VARCHAR2 | (30) | Indicates unique layout identifier code | |
| RESP_RECORD_STATUS | VARCHAR2 | (30) | Indicates all records that are processed and successfully updated for internal tracking | |
| 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 | |
| BORR_SIGN_IND | VARCHAR2 | (30) | Borrower Signature Indicator | |
| STUD_SIGN_IND | VARCHAR2 | (30) | Student Signature Indicator | |
| BORR_CREDIT_AUTH_CODE | VARCHAR2 | (30) | Borrower Credit Authorization Code | |
| MPN_CONFIRM_IND | VARCHAR2 | (30) | MPN Confirmation Code, This field is applicable only for CommonLine Release 4 Loan Records | |
| 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. | ||
| 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 | ||
| CL_VERSION_CODE | VARCHAR2 | (30) | This field contains the CommonLine Release Version, it can be RELEASE-4 for CommonLine Release 4 Version Response, and RELEASE-5 for CommonLine Release 5 Version Response Record. | |
| 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. | |
| B_ALIEN_REG_NUM_TXT | VARCHAR2 | (30) | Borrower Alien Registration Number | |
| ESIGN_SRC_TYP_CD | VARCHAR2 | (30) | Electronic Signature Source Type Code |
Cut, paste (and edit) the following text to query this object:
SELECT CLRP1_ID
, CBTH_ID
, REC_CODE
, REC_TYPE_IND
, B_LAST_NAME
, B_FIRST_NAME
, B_MIDDLE_NAME
, B_SSN
, B_PERMT_ADDR1
, B_PERMT_ADDR2
, B_PERMT_CITY
, B_PERMT_STATE
, B_PERMT_ZIP
, B_PERMT_ZIP_SUFFIX
, B_PERMT_PHONE
, B_DATE_OF_BIRTH
, CL_LOAN_TYPE
, REQ_LOAN_AMT
, DEFER_REQ_CODE
, BORW_INTEREST_IND
, EFT_AUTH_CODE
, B_SIGNATURE_CODE
, B_SIGNATURE_DATE
, LOAN_NUMBER
, CL_SEQ_NUMBER
, B_CITIZENSHIP_STATUS
, B_STATE_OF_LEGAL_RES
, B_LEGAL_RES_DATE
, B_DEFAULT_STATUS
, B_OUTSTD_LOAN_CODE
, B_INDICATOR_CODE
, S_LAST_NAME
, S_FIRST_NAME
, S_MIDDLE_NAME
, S_SSN
, S_DATE_OF_BIRTH
, S_CITIZENSHIP_STATUS
, S_DEFAULT_CODE
, S_SIGNATURE_CODE
, SCHOOL_ID
, LOAN_PER_BEGIN_DATE
, LOAN_PER_END_DATE
, GRADE_LEVEL_CODE
, ENROLLMENT_CODE
, ANTICIP_COMPL_DATE
, COA_AMT
, EFC_AMT
, EST_FA_AMT
, FLS_CERT_AMT
, FLU_CERT_AMT
, FLP_CERT_AMT
, SCH_CERT_DATE
, ALT_CERT_AMT
, ALT_APPL_VER_CODE
, DUNS_SCHOOL_ID
, LENDER_ID
, FLS_APPROVED_AMT
, FLU_APPROVED_AMT
, FLP_APPROVED_AMT
, ALT_APPROVED_AMT
, DUNS_LENDER_ID
, GUARANTOR_ID
, FED_APPL_FORM_CODE
, DUNS_GUARNT_ID
, LEND_BLKT_GUARNT_IND
, LEND_BLKT_GUARNT_APPR_DATE
, GUARNT_ADJ_IND
, GUARANTEE_DATE
, GUARANTEE_AMT
, REQ_SERIAL_LOAN_CODE
, BORW_CONFIRM_IND
, B_LICENSE_STATE
, B_LICENSE_NUMBER
, B_REF_CODE
, PNOTE_DELIVERY_CODE
, B_FOREIGN_POSTAL_CODE
, LEND_NON_ED_BRC_ID
, LAST_RESORT_LENDER
, RESP_TO_ORIG_CODE
, ERR_MESG_1
, ERR_MESG_2
, ERR_MESG_3
, ERR_MESG_4
, ERR_MESG_5
, GUARNT_AMT_REDN_CODE
, TOT_OUTSTD_STAFFORD
, TOT_OUTSTD_PLUS
, B_PERMT_ADDR_CHG_DATE
, ALT_PROG_TYPE_CODE
, ALT_BORW_TOT_DEBT
, ACT_INTEREST_RATE
, PRC_TYPE_CODE
, SERVICE_TYPE_CODE
, REV_NOTICE_OF_GUARNT
, SCH_REFUND_AMT
, SCH_REFUND_DATE
, GUARNT_STATUS_CODE
, LENDER_STATUS_CODE
, PNOTE_STATUS_CODE
, CREDIT_STATUS_CODE
, GUARNT_STATUS_DATE
, LENDER_STATUS_DATE
, PNOTE_STATUS_DATE
, CREDIT_STATUS_DATE
, ACT_SERIAL_LOAN_CODE
, AMT_AVAIL_FOR_REINST
, SCH_NON_ED_BRC_ID
, UNIQ_LAYOUT_VEND_CODE
, UNIQ_LAYOUT_IDENT_CODE
, RESP_RECORD_STATUS
, 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
, BORR_SIGN_IND
, STUD_SIGN_IND
, BORR_CREDIT_AUTH_CODE
, MPN_CONFIRM_IND
, LENDER_USE_TXT
, GUARANTOR_USE_TXT
, APPL_LOAN_PHASE_CODE
, APPL_LOAN_PHASE_CODE_CHG
, CL_REC_STATUS
, CL_REC_STATUS_LAST_UPDATE
, LEND_APPRV_DENIED_CODE
, LEND_APPRV_DENIED_DATE
, CL_VERSION_CODE
, SCHOOL_USE_TXT
, B_ALIEN_REG_NUM_TXT
, ESIGN_SRC_TYP_CD
FROM IGF.IGF_SL_CL_RESP_R1_ALL;
IGF.IGF_SL_CL_RESP_R1_ALL does not reference any database object
IGF.IGF_SL_CL_RESP_R1_ALL is referenced by following:
APPS
IGF_SL_CL_RESP_R1_ALL
|
|
|
|