VIEW: AR.HZ_CREDIT_RATINGS#

Source

View Text - Preformatted

select CREDIT_RATING_ID CREDIT_RATING_ID, DESCRIPTION DESCRIPTION, PARTY_ID PARTY_ID, RATING RATING, RATED_AS_OF_DATE RATED_AS_OF_DATE, RATING_ORGANIZATION RATING_ORGANIZATION, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, WH_UPDATE_DATE WH_UPDATE_DATE, COMMENTS COMMENTS, DET_HISTORY_IND DET_HISTORY_IND, FINCL_EMBT_IND FINCL_EMBT_IND, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND, SUIT_JUDGE_IND SUIT_JUDGE_IND, CLAIMS_IND CLAIMS_IND, SECURED_FLNG_IND SECURED_FLNG_IND, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND, DISASTER_IND DISASTER_IND, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE, STATUS STATUS, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CREATED_BY_MODULE CREATED_BY_MODULE, APPLICATION_ID APPLICATION_ID, AVG_HIGH_CREDIT AVG_HIGH_CREDIT, 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, DEBARMENT_IND DEBARMENT_IND, DEBARMENTS_COUNT DEBARMENTS_COUNT, DEBARMENTS_DATE DEBARMENTS_DATE, HIGH_CREDIT HIGH_CREDIT, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION, PAYDEX_NORM PAYDEX_NORM, PAYDEX_SCORE PAYDEX_SCORE, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT, PAYDEX_COMMENT PAYDEX_COMMENT, SUIT_IND SUIT_IND, LIEN_IND LIEN_IND, JUDGEMENT_IND JUDGEMENT_IND, BANKRUPTCY_IND BANKRUPTCY_IND, NO_TRADE_IND NO_TRADE_IND, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV, SLOW_TRADE_EXPL SLOW_TRADE_EXPL, NEGV_PMT_EXPL NEGV_PMT_EXPL, PUB_REC_EXPL PUB_REC_EXPL, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT, NUM_SPCL_EVENT NUM_SPCL_EVENT, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE, SPCL_EVNT_TXT SPCL_EVNT_TXT, 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, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE, ACTUAL_CONTENT_SOURCE ACTUAL_CONTENT_SOURCE from "AR"."HZ_CREDIT_RATINGS"

View Text - HTML Formatted

SELECT CREDIT_RATING_ID CREDIT_RATING_ID
, DESCRIPTION DESCRIPTION
, PARTY_ID PARTY_ID
, RATING RATING
, RATED_AS_OF_DATE RATED_AS_OF_DATE
, RATING_ORGANIZATION RATING_ORGANIZATION
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, WH_UPDATE_DATE WH_UPDATE_DATE
, COMMENTS COMMENTS
, DET_HISTORY_IND DET_HISTORY_IND
, FINCL_EMBT_IND FINCL_EMBT_IND
, CRIMINAL_PROCEEDING_IND CRIMINAL_PROCEEDING_IND
, SUIT_JUDGE_IND SUIT_JUDGE_IND
, CLAIMS_IND CLAIMS_IND
, SECURED_FLNG_IND SECURED_FLNG_IND
, FINCL_LGL_EVENT_IND FINCL_LGL_EVENT_IND
, DISASTER_IND DISASTER_IND
, OPRG_SPEC_EVNT_IND OPRG_SPEC_EVNT_IND
, OTHER_SPEC_EVNT_IND OTHER_SPEC_EVNT_IND
, CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE
, STATUS STATUS
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE CREATED_BY_MODULE
, APPLICATION_ID APPLICATION_ID
, AVG_HIGH_CREDIT AVG_HIGH_CREDIT
, 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
, DEBARMENT_IND DEBARMENT_IND
, DEBARMENTS_COUNT DEBARMENTS_COUNT
, DEBARMENTS_DATE DEBARMENTS_DATE
, HIGH_CREDIT HIGH_CREDIT
, MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE
, MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION
, PAYDEX_NORM PAYDEX_NORM
, PAYDEX_SCORE PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO PAYDEX_THREE_MONTHS_AGO
, CREDIT_SCORE_OVERRIDE_CODE CREDIT_SCORE_OVERRIDE_CODE
, CR_SCR_CLAS_EXPL CR_SCR_CLAS_EXPL
, LOW_RNG_DELQ_SCR LOW_RNG_DELQ_SCR
, HIGH_RNG_DELQ_SCR HIGH_RNG_DELQ_SCR
, DELQ_PMT_RNG_PRCNT DELQ_PMT_RNG_PRCNT
, DELQ_PMT_PCTG_FOR_ALL_FIRMS DELQ_PMT_PCTG_FOR_ALL_FIRMS
, NUM_TRADE_EXPERIENCES NUM_TRADE_EXPERIENCES
, PAYDEX_FIRM_DAYS PAYDEX_FIRM_DAYS
, PAYDEX_FIRM_COMMENT PAYDEX_FIRM_COMMENT
, PAYDEX_INDUSTRY_DAYS PAYDEX_INDUSTRY_DAYS
, PAYDEX_INDUSTRY_COMMENT PAYDEX_INDUSTRY_COMMENT
, PAYDEX_COMMENT PAYDEX_COMMENT
, SUIT_IND SUIT_IND
, LIEN_IND LIEN_IND
, JUDGEMENT_IND JUDGEMENT_IND
, BANKRUPTCY_IND BANKRUPTCY_IND
, NO_TRADE_IND NO_TRADE_IND
, PRNT_HQ_BKCY_IND PRNT_HQ_BKCY_IND
, NUM_PRNT_BKCY_FILING NUM_PRNT_BKCY_FILING
, PRNT_BKCY_FILG_TYPE PRNT_BKCY_FILG_TYPE
, PRNT_BKCY_FILG_CHAPTER PRNT_BKCY_FILG_CHAPTER
, PRNT_BKCY_FILG_DATE PRNT_BKCY_FILG_DATE
, NUM_PRNT_BKCY_CONVS NUM_PRNT_BKCY_CONVS
, PRNT_BKCY_CONV_DATE PRNT_BKCY_CONV_DATE
, PRNT_BKCY_CHAPTER_CONV PRNT_BKCY_CHAPTER_CONV
, SLOW_TRADE_EXPL SLOW_TRADE_EXPL
, NEGV_PMT_EXPL NEGV_PMT_EXPL
, PUB_REC_EXPL PUB_REC_EXPL
, BUSINESS_DISCONTINUED BUSINESS_DISCONTINUED
, SPCL_EVENT_COMMENT SPCL_EVENT_COMMENT
, NUM_SPCL_EVENT NUM_SPCL_EVENT
, SPCL_EVENT_UPDATE_DATE SPCL_EVENT_UPDATE_DATE
, SPCL_EVNT_TXT SPCL_EVNT_TXT
, 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
, GLOBAL_FAILURE_SCORE GLOBAL_FAILURE_SCORE
, ACTUAL_CONTENT_SOURCE ACTUAL_CONTENT_SOURCE
FROM "AR"."HZ_CREDIT_RATINGS"