eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGF_DB_CL_DISB_RESP

Product:	IGF - Financial Aid (Obsolete)
Description:
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT DBRESP.ROWID ROW_ID
, DBRESP.CDBR_ID
, DBRESP.CBTH_ID
, DBRESP.RECORD_TYPE
, DBRESP.LOAN_NUMBER
, DBRESP.CL_SEQ_NUMBER
, DBRESP.B_LAST_NAME
, DBRESP.B_FIRST_NAME
, DBRESP.B_MIDDLE_NAME
, DBRESP.B_SSN
, DBRESP.B_ADDR_LINE_1
, DBRESP.B_ADDR_LINE_2
, DBRESP.B_CITY
, DBRESP.B_STATE
, DBRESP.B_ZIP
, DBRESP.B_ZIP_SUFFIX
, DBRESP.B_ADDR_CHG_DATE
, DBRESP.EFT_AUTH_CODE
, DBRESP.S_LAST_NAME
, DBRESP.S_FIRST_NAME
, DBRESP.S_MIDDLE_INITIAL
, DBRESP.S_SSN
, DBRESP.SCHOOL_ID
, DBRESP.SCHOOL_USE
, DBRESP.LOAN_PER_START_DATE
, DBRESP.LOAN_PER_END_DATE
, DBRESP.CL_LOAN_TYPE
, DBRESP.ALT_PROG_TYPE_CODE
, DBRESP.LENDER_ID
, DBRESP.LEND_NON_ED_BRC_ID
, DBRESP.LENDER_USE
, DBRESP.BORW_CONFIRM_IND
, DBRESP.TOT_SCHED_DISB
, DBRESP.FUND_RELEASE_DATE
, DBRESP.DISB_NUM
, DBRESP.GUARANTOR_ID
, DBRESP.GUARANTOR_USE
, DBRESP.GUARANTEE_DATE
, DBRESP.GUARANTEE_AMT
, DBRESP.GROSS_DISB_AMT
, DBRESP.FEE_1
, DBRESP.FEE_2
, DBRESP.NET_DISB_AMT
, DBRESP.FUND_DIST_MTHD
, DBRESP.CHECK_NUMBER
, DBRESP.LATE_DISB_IND
, DBRESP.PREV_REPORTED_IND
, DBRESP.ERR_CODE1
, DBRESP.ERR_CODE2
, DBRESP.ERR_CODE3
, DBRESP.ERR_CODE4
, DBRESP.ERR_CODE5
, DBRESP.FEE_PAID_2
, DBRESP.LENDER_NAME
, DBRESP.NET_CANCEL_AMT
, DBRESP.DUNS_SCHOOL_ID
, DBRESP.DUNS_LENDER_ID
, DBRESP.DUNS_GUARNT_ID
, DBRESP.HOLD_REL_IND
, DBRESP.PNOTE_CODE
, DBRESP.PNOTE_STATUS_DATE
, DBRESP.FEE_PAID_1
, DBRESP.NETTED_CANCEL_AMT
, DBRESP.OUTSTD_CANCEL_AMT
, DBRESP.SCH_NON_ED_BRC_ID
, DBRESP.STATUS
, DBRESP.CREATED_BY
, DBRESP.CREATION_DATE
, DBRESP.LAST_UPDATED_BY
, DBRESP.LAST_UPDATE_DATE
, DBRESP.LAST_UPDATE_LOGIN
, DBRESP.REQUEST_ID
, DBRESP.PROGRAM_APPLICATION_ID
, DBRESP.PROGRAM_ID
, DBRESP.PROGRAM_UPDATE_DATE
, DBRESP.ORG_ID
, DBRESP.ESIGN_SRC_TYP_CD
, DBRESP.DIRECT_TO_BORR_FLAG
FROM IGF_DB_CL_DISB_RESP_ALL DBRESP
WHERE NVL ( DBRESP.ORG_ID
, NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)) = NVL(TO_NUMBER(DECODE(SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 1)
, ' '
, NULL
, SUBSTRB(USERENV('CLIENT_INFO')
, 1
, 10)))
, -99)

Columns

Name
ROW_ID
CDBR_ID
CBTH_ID
RECORD_TYPE
LOAN_NUMBER
CL_SEQ_NUMBER
B_LAST_NAME
B_FIRST_NAME
B_MIDDLE_NAME
B_SSN
B_ADDR_LINE_1
B_ADDR_LINE_2
B_CITY
B_STATE
B_ZIP
B_ZIP_SUFFIX
B_ADDR_CHG_DATE
EFT_AUTH_CODE
S_LAST_NAME
S_FIRST_NAME
S_MIDDLE_INITIAL
S_SSN
SCHOOL_ID
SCHOOL_USE
LOAN_PER_START_DATE
LOAN_PER_END_DATE
CL_LOAN_TYPE
ALT_PROG_TYPE_CODE
LENDER_ID
LEND_NON_ED_BRC_ID
LENDER_USE
BORW_CONFIRM_IND
TOT_SCHED_DISB
FUND_RELEASE_DATE
DISB_NUM
GUARANTOR_ID
GUARANTOR_USE
GUARANTEE_DATE
GUARANTEE_AMT
GROSS_DISB_AMT
FEE_1
FEE_2
NET_DISB_AMT
FUND_DIST_MTHD
CHECK_NUMBER
LATE_DISB_IND
PREV_REPORTED_IND
ERR_CODE1
ERR_CODE2
ERR_CODE3
ERR_CODE4
ERR_CODE5
FEE_PAID_2
LENDER_NAME
NET_CANCEL_AMT
DUNS_SCHOOL_ID
DUNS_LENDER_ID
DUNS_GUARNT_ID
HOLD_REL_IND
PNOTE_CODE
PNOTE_STATUS_DATE
FEE_PAID_1
NETTED_CANCEL_AMT
OUTSTD_CANCEL_AMT
SCH_NON_ED_BRC_ID
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
ESIGN_SRC_TYP_CD
DIRECT_TO_BORR_FLAG