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.

VIEW: IEX.IEX_DELINQUENCIES_ALL#

Source

View Text - Preformatted


select DELINQUENCY_ID DELINQUENCY_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, PROGRAM_ID PROGRAM_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PARTY_CUST_ID PARTY_CUST_ID, PARTY_CLIENT_ID PARTY_CLIENT_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, TRANSACTION_ID TRANSACTION_ID, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID, AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID, CASE_ID CASE_ID, RESOURCE_ID RESOURCE_ID, DUNN_YN DUNN_YN, AUTOASSIGN_YN AUTOASSIGN_YN, STATUS STATUS, CAMPAIGN_SCHED_ID CAMPAIGN_SCHED_ID, ORG_ID ORG_ID, UNPAID_REASON_CODE UNPAID_REASON_CODE, STRATEGY_ID STRATEGY_ID, CREDIT_HOLD_REQUEST_FLAG CREDIT_HOLD_REQUEST_FLAG, CREDIT_HOLD_APPROVED_FLAG CREDIT_HOLD_APPROVED_FLAG, SERVICE_HOLD_REQUEST_FLAG SERVICE_HOLD_REQUEST_FLAG, SERVICE_HOLD_APPROVED_FLAG SERVICE_HOLD_APPROVED_FLAG, SCORE_VALUE SCORE_VALUE, SCORE_ID SCORE_ID, SOURCE_PROGRAM_NAME SOURCE_PROGRAM_NAME, PREDICTED_RECOVERY_AMOUNT PREDICTED_RECOVERY_AMOUNT, PREDICTED_CHANCE PREDICTED_CHANCE, UWQ_STATUS UWQ_STATUS, UWQ_ACTIVE_DATE UWQ_ACTIVE_DATE, UWQ_COMPLETE_DATE UWQ_COMPLETE_DATE, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID, STAGED_DUNNING_LEVEL STAGED_DUNNING_LEVEL, DUNNING_LEVEL_OVERRIDE_DATE DUNNING_LEVEL_OVERRIDE_DATE from "IEX"."IEX_DELINQUENCIES_ALL"

View Text - HTML Formatted

SELECT DELINQUENCY_ID DELINQUENCY_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, PROGRAM_ID PROGRAM_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PARTY_CUST_ID PARTY_CUST_ID
, PARTY_CLIENT_ID PARTY_CLIENT_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, TRANSACTION_ID TRANSACTION_ID
, PAYMENT_SCHEDULE_ID PAYMENT_SCHEDULE_ID
, AGING_BUCKET_LINE_ID AGING_BUCKET_LINE_ID
, CASE_ID CASE_ID
, RESOURCE_ID RESOURCE_ID
, DUNN_YN DUNN_YN
, AUTOASSIGN_YN AUTOASSIGN_YN
, STATUS STATUS
, CAMPAIGN_SCHED_ID CAMPAIGN_SCHED_ID
, ORG_ID ORG_ID
, UNPAID_REASON_CODE UNPAID_REASON_CODE
, STRATEGY_ID STRATEGY_ID
, CREDIT_HOLD_REQUEST_FLAG CREDIT_HOLD_REQUEST_FLAG
, CREDIT_HOLD_APPROVED_FLAG CREDIT_HOLD_APPROVED_FLAG
, SERVICE_HOLD_REQUEST_FLAG SERVICE_HOLD_REQUEST_FLAG
, SERVICE_HOLD_APPROVED_FLAG SERVICE_HOLD_APPROVED_FLAG
, SCORE_VALUE SCORE_VALUE
, SCORE_ID SCORE_ID
, SOURCE_PROGRAM_NAME SOURCE_PROGRAM_NAME
, PREDICTED_RECOVERY_AMOUNT PREDICTED_RECOVERY_AMOUNT
, PREDICTED_CHANCE PREDICTED_CHANCE
, UWQ_STATUS UWQ_STATUS
, UWQ_ACTIVE_DATE UWQ_ACTIVE_DATE
, UWQ_COMPLETE_DATE UWQ_COMPLETE_DATE
, CUSTOMER_SITE_USE_ID CUSTOMER_SITE_USE_ID
, STAGED_DUNNING_LEVEL STAGED_DUNNING_LEVEL
, DUNNING_LEVEL_OVERRIDE_DATE DUNNING_LEVEL_OVERRIDE_DATE
FROM "IEX"."IEX_DELINQUENCIES_ALL"