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: AR.HZ_IMP_CREDITRTNGS_INT#

Source

View Text - Preformatted


select BATCH_ID BATCH_ID, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE, RATED_AS_OF_DATE RATED_AS_OF_DATE, RATING_ORGANIZATION RATING_ORGANIZATION, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG, AVG_HIGH_CREDIT AVG_HIGH_CREDIT, BANKRUPTCY_IND BANKRUPTCY_IND, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED, CLAIMS_IND CLAIMS_IND, COMMENTS COMMENTS, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL, CREDIT_SCORE CREDIT_SCORE, CREDIT_SCORE_AGE CREDIT_SCORE_AGE, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS, CREDIT_SCORE_COMMENTARY CREDIT_SCORE_COMMENTARY, CREDIT_SCORE_COMMENTARY2 CREDIT_SCORE_COMMENTARY2, CREDIT_SCORE_COMMENTARY3 CREDIT_SCORE_COMMENTARY3, CREDIT_SCORE_COMMENTARY4 CREDIT_SCORE_COMMENTARY4, CREDIT_SCORE_COMMENTARY5 CREDIT_SCORE_COMMENTARY5, CREDIT_SCORE_COMMENTARY6 CREDIT_SCORE_COMMENTARY6, CREDIT_SCORE_COMMENTARY7 CREDIT_SCORE_COMMENTARY7, CREDIT_SCORE_COMMENTARY8 CREDIT_SCORE_COMMENTARY8, CREDIT_SCORE_COMMENTARY9 CREDIT_SCORE_COMMENTARY9, CREDIT_SCORE_COMMENTARY10 CREDIT_SCORE_COMMENTARY10, CREDIT_SCORE_DATE CREDIT_SCORE_DATE, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND, DEBARMENT_IND DEBARMENT_IND, DEBARMENTS_COUNT DEBARMENTS_COUNT, DEBARMENTS_DATE DEBARMENTS_DATE, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT, DESCRIPTION DESCRIPTION, DET_HISTORY_IND DET_HISTORY_IND, DISASTER_IND DISASTER_IND, FAILURE_SCORE FAILURE_SCORE, FAILURE_SCORE_AGE FAILURE_SCORE_AGE, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS, FAILURE_SCORE_COMMENTARY FAILURE_SCORE_COMMENTARY, FAILURE_SCORE_COMMENTARY2 FAILURE_SCORE_COMMENTARY2, FAILURE_SCORE_COMMENTARY3 FAILURE_SCORE_COMMENTARY3, FAILURE_SCORE_COMMENTARY4 FAILURE_SCORE_COMMENTARY4, FAILURE_SCORE_COMMENTARY5 FAILURE_SCORE_COMMENTARY5, FAILURE_SCORE_COMMENTARY6 FAILURE_SCORE_COMMENTARY6, FAILURE_SCORE_COMMENTARY7 FAILURE_SCORE_COMMENTARY7, FAILURE_SCORE_COMMENTARY8 FAILURE_SCORE_COMMENTARY8, FAILURE_SCORE_COMMENTARY9 FAILURE_SCORE_COMMENTARY9, FAILURE_SCORE_COMMENTARY10 FAILURE_SCORE_COMMENTARY10, FAILURE_SCORE_DATE FAILURE_SCORE_DATE, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT, FAILURE_SCORE_NATNL_PERCENTILE FAILURE_SCORE_NATNL_PERCENTILE, FAILURE_SCORE_OVERRIDE_CODE FAILURE_SCORE_OVERRIDE_CODE, FINCL_EMBT_IND FINCL_EMBT_IND, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE, HIGH_CREDIT HIGH_CREDIT, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR, JUDGEMENT_IND JUDGEMENT_IND, LIEN_IND LIEN_IND, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION, NEGV_PMT_EXPL NEGV_PMT_EXPL, NO_TRADE_IND NO_TRADE_IND, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING, NUM_SPCL_EVENT NUM_SPCL_EVENT, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND, PAYDEX_COMMENT PAYDEX_COMMENT, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS, PAYDEX_NORM PAYDEX_NORM, PAYDEX_SCORE PAYDEX_SCORE, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND, PUB_REC_EXPL PUB_REC_EXPL, RATING RATING, SECURED_FLNG_IND SECURED_FLNG_IND, SLOW_TRADE_EXPL SLOW_TRADE_EXPL, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE, SPCL_EVNT_TXT SPCL_EVNT_TXT, SUIT_IND SUIT_IND, INTERFACE_STATUS INTERFACE_STATUS, ERROR_ID ERROR_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, CREATED_BY_MODULE CREATED_BY_MODULE, PARTY_ID PARTY_ID from "AR"."HZ_IMP_CREDITRTNGS_INT"

View Text - HTML Formatted

SELECT BATCH_ID BATCH_ID
, PARTY_ORIG_SYSTEM PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE
, RATED_AS_OF_DATE RATED_AS_OF_DATE
, RATING_ORGANIZATION RATING_ORGANIZATION
, INSERT_UPDATE_FLAG INSERT_UPDATE_FLAG
, AVG_HIGH_CREDIT AVG_HIGH_CREDIT
, BANKRUPTCY_IND BANKRUPTCY_IND
, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED
, CLAIMS_IND CLAIMS_IND
, COMMENTS COMMENTS
, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL
, CREDIT_SCORE CREDIT_SCORE
, CREDIT_SCORE_AGE CREDIT_SCORE_AGE
, CREDIT_SCORE_CLASS CREDIT_SCORE_CLASS
, CREDIT_SCORE_COMMENTARY CREDIT_SCORE_COMMENTARY
, CREDIT_SCORE_COMMENTARY2 CREDIT_SCORE_COMMENTARY2
, CREDIT_SCORE_COMMENTARY3 CREDIT_SCORE_COMMENTARY3
, CREDIT_SCORE_COMMENTARY4 CREDIT_SCORE_COMMENTARY4
, CREDIT_SCORE_COMMENTARY5 CREDIT_SCORE_COMMENTARY5
, CREDIT_SCORE_COMMENTARY6 CREDIT_SCORE_COMMENTARY6
, CREDIT_SCORE_COMMENTARY7 CREDIT_SCORE_COMMENTARY7
, CREDIT_SCORE_COMMENTARY8 CREDIT_SCORE_COMMENTARY8
, CREDIT_SCORE_COMMENTARY9 CREDIT_SCORE_COMMENTARY9
, CREDIT_SCORE_COMMENTARY10 CREDIT_SCORE_COMMENTARY10
, CREDIT_SCORE_DATE CREDIT_SCORE_DATE
, CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT
, CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE
, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE
, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND
, DEBARMENT_IND DEBARMENT_IND
, DEBARMENTS_COUNT DEBARMENTS_COUNT
, DEBARMENTS_DATE DEBARMENTS_DATE
, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS
, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT
, DESCRIPTION DESCRIPTION
, DET_HISTORY_IND DET_HISTORY_IND
, DISASTER_IND DISASTER_IND
, FAILURE_SCORE FAILURE_SCORE
, FAILURE_SCORE_AGE FAILURE_SCORE_AGE
, FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS
, FAILURE_SCORE_COMMENTARY FAILURE_SCORE_COMMENTARY
, FAILURE_SCORE_COMMENTARY2 FAILURE_SCORE_COMMENTARY2
, FAILURE_SCORE_COMMENTARY3 FAILURE_SCORE_COMMENTARY3
, FAILURE_SCORE_COMMENTARY4 FAILURE_SCORE_COMMENTARY4
, FAILURE_SCORE_COMMENTARY5 FAILURE_SCORE_COMMENTARY5
, FAILURE_SCORE_COMMENTARY6 FAILURE_SCORE_COMMENTARY6
, FAILURE_SCORE_COMMENTARY7 FAILURE_SCORE_COMMENTARY7
, FAILURE_SCORE_COMMENTARY8 FAILURE_SCORE_COMMENTARY8
, FAILURE_SCORE_COMMENTARY9 FAILURE_SCORE_COMMENTARY9
, FAILURE_SCORE_COMMENTARY10 FAILURE_SCORE_COMMENTARY10
, FAILURE_SCORE_DATE FAILURE_SCORE_DATE
, FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT
, FAILURE_SCORE_NATNL_PERCENTILE FAILURE_SCORE_NATNL_PERCENTILE
, FAILURE_SCORE_OVERRIDE_CODE FAILURE_SCORE_OVERRIDE_CODE
, FINCL_EMBT_IND FINCL_EMBT_IND
, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND
, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE
, HIGH_CREDIT HIGH_CREDIT
, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR
, JUDGEMENT_IND JUDGEMENT_IND
, LIEN_IND LIEN_IND
, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR
, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE
, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION
, NEGV_PMT_EXPL NEGV_PMT_EXPL
, NO_TRADE_IND NO_TRADE_IND
, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS
, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING
, NUM_SPCL_EVENT NUM_SPCL_EVENT
, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES
, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND
, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND
, PAYDEX_COMMENT PAYDEX_COMMENT
, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT
, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS
, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT
, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS
, PAYDEX_NORM PAYDEX_NORM
, PAYDEX_SCORE PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO
, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV
, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE
, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE
, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE
, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER
, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND
, PUB_REC_EXPL PUB_REC_EXPL
, RATING RATING
, SECURED_FLNG_IND SECURED_FLNG_IND
, SLOW_TRADE_EXPL SLOW_TRADE_EXPL
, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT
, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE
, SPCL_EVNT_TXT SPCL_EVNT_TXT
, SUIT_IND SUIT_IND
, INTERFACE_STATUS INTERFACE_STATUS
, ERROR_ID ERROR_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, CREATED_BY_MODULE CREATED_BY_MODULE
, PARTY_ID PARTY_ID
FROM "AR"."HZ_IMP_CREDITRTNGS_INT"