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_SL_CLCHSN_DTLS_V

Product:	IGF - Financial Aid
Description:	Stores all the change records for Loan record for CommonLine Release 4 Version.
Implementation/DBA Data:	APPS.IGF_SL_CLCHSN_DTLS_V

View Text

SELECT CLCHGSND.ROWID
, CLCHGSND.CLCHGSND_ID
, CLCHGSND.CL_VERSION_CODE
, CLCHGSND.AWARD_ID
, CLCHGSND.LOAN_NUMBER_TXT
, CLCHGSND.DISBURSEMENT_NUMBER
, CLCHGSND.DISBURSEMENT_DATE
, CLCHGSND.CHANGE_ISSUE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_ISSUE_CODES'
, CLCHGSND.CHANGE_ISSUE_CODE)
, CLCHGSND.CHANGE_CODE_TXT
, CLCHRTS.CHANGE_CODE_DESCRIPTION
, CLCHGSND.CHANGE_FIELD_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHANGE_FIELDS'
, CLCHGSND.CHANGE_FIELD_CODE)
, CLCHGSND.CHANGE_RECORD_TYPE_TXT
, CLCHRTS.RECORD_DESCRIPTION_TXT
, CLCHGSND.OLD_VALUE_TXT
, CLCHGSND.NEW_VALUE_TXT
, CLCHGSND.OLD_AMT
, CLCHGSND.NEW_AMT
, CLCHGSND.OLD_DATE
, CLCHGSND.NEW_DATE
, CLCHGSND.DISBURSEMENT_CANCEL_AMT
, CLCHGSND.DISBURSEMENT_CANCEL_DATE
, CLCHGSND.DISBURSEMENT_REINST_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REINST_CODES'
, CLCHGSND.DISBURSEMENT_REINST_CODE)
, CLCHGSND.DISBURSEMENT_REISSUE_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REISSUE_CODES'
, CLCHGSND.DISBURSEMENT_REISSUE_CODE)
, CLCHGSND.DISBURSEMENT_RETURN_AMT
, CLCHGSND.DISBURSEMENT_RETURN_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_DB_FUND_DISB_METH'
, CLCHGSND.DISBURSEMENT_RETURN_CODE)
, CLCHGSND.DISBURSEMENT_RETURN_DATE
, CLCHGSND.DISBURSEMENT_REVISED_AMT
, CLCHGSND.DISBURSEMENT_REVISED_DATE
, CLCHGSND.GUARANTOR_USE_TXT
, CLCHGSND.LENDER_USE_TXT
, CLCHGSND.RESPONSE_STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_RESP_STATUS'
, CLCHGSND.RESPONSE_STATUS_CODE)
, CLCHGSND.SCHOOL_USE_TXT
, CLCHGSND.SEND_RECORD_TXT
, CLCHGSND.STATUS_CODE
, IGF_AW_GEN.LOOKUP_DESC('IGF_SL_CL_CHG_REC_STATUS'
, CLCHGSND.STATUS_CODE)
, CLCHGSND.STATUS_DATE
, CLCHGSND.VALIDATION_EDIT_TXT
, CLCHGSND.CREATED_BY
, CLCHGSND.CREATION_DATE
, CLCHGSND.LAST_UPDATED_BY
, CLCHGSND.LAST_UPDATE_DATE
, CLCHGSND.LAST_UPDATE_LOGIN
, CLCHGSND.REQUEST_ID
, CLCHGSND.PROGRAM_APPLICATION_ID
, CLCHGSND.PROGRAM_ID
, CLCHGSND.PROGRAM_UPDATE_DATE
FROM IGF_SL_CL_CHG_REC_TYPES CLCHRTS
, IGF_SL_CLCHSN_DTLS CLCHGSND
WHERE CLCHGSND.CL_VERSION_CODE = CLCHRTS.CL_VERSION_CODE
AND CLCHRTS.RECORD_TYPE_TXT = CLCHGSND.CHANGE_RECORD_TYPE_TXT
AND CLCHRTS.CHANGE_CODE_TXT = CLCHGSND.CHANGE_CODE_TXT

Columns

Name
ROW_ID
CLCHGSND_ID
CL_VERSION_CODE
AWARD_ID
LOAN_NUMBER_TXT
DISBURSEMENT_NUMBER
DISBURSEMENT_DATE
CHANGE_ISSUE_CODE
CHANGE_ISSUE_CODE_DESC
CHANGE_CODE_TXT
CHANGE_CODE_DESC
CHANGE_FIELD_CODE
CHANGE_FIELD_CODE_DESC
CHANGE_RECORD_TYPE_TXT
CHANGE_RECORD_TYPE_DESC
OLD_VALUE_TXT
NEW_VALUE_TXT
OLD_AMT
NEW_AMT
OLD_DATE
NEW_DATE
DISBURSEMENT_CANCEL_AMT
DISBURSEMENT_CANCEL_DATE
DISBURSEMENT_REINST_CODE
DISBURSEMENT_REINST_DESC
DISBURSEMENT_REISSUE_CODE
DISBURSEMENT_REISSUE_DESC
DISBURSEMENT_RETURN_AMT
DISBURSEMENT_RETURN_CODE
DISBURSEMENT_RETURN_DESC
DISBURSEMENT_RETURN_DATE
DISBURSEMENT_REVISED_AMT
DISBURSEMENT_REVISED_DATE
GUARANTOR_USE_TXT
LENDER_USE_TXT
RESPONSE_STATUS_CODE
RESPONSE_STATUS_CODE_DESC
SCHOOL_USE_TXT
SEND_RECORD_TXT
STATUS_CODE
STATUS_CODE_DESC
STATUS_DATE
VALIDATION_EDIT_TXT
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE