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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: AR.HZ_CREDIT_RATINGS

Object Details

Object Name:	HZ_CREDIT_RATINGS
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_CREDIT_RATINGS
Subobject Name:
Status:	VALID

The HZ_CREDIT_RATINGS table stores information about the creditworthiness of a party. This information usually is supplied by a credit rating firm, such as Dun & Bradstreet.
.
The primary key for this table is CREDIT_RATING_ID.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_CREDIT_RATINGS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	CREDIT_RATING_ID
HZ_CREDIT_RATINGS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_ID RATED_AS_OF_DATE RATING_ORGANIZATION ACTUAL_CONTENT_SOURCE

Columns

Name	Datatype	Length	Mandatory	Comments
CREDIT_RATING_ID	NUMBER	(15)	Yes	Credit rating identifier
DESCRIPTION	VARCHAR2	(2000)		A textual description of the rating effort.
PARTY_ID	NUMBER	(15)	Yes	Unique identifier for a party. Foreign key to the HZ_PARTIES table
RATING	VARCHAR2	(60)		The rating company's rating number or code.
RATED_AS_OF_DATE	DATE			The date that the rating was acquired.
RATING_ORGANIZATION	VARCHAR2	(240)		The name of the credit rating organization.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER	(15)		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER	(15)		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
WH_UPDATE_DATE	DATE			Date when the record was entered or changed in a data warehouse
COMMENTS	VARCHAR2	(240)		Commentary explaining the rating.
DET_HISTORY_IND	VARCHAR2	(30)		Code that indicates if detrimental information exists for the party and whether complete details exist on management and party. Y for information is available, N for no information.
FINCL_EMBT_IND	VARCHAR2	(30)		Indicates if open bankruptcy, receivership liquidation, or equivalent exist. Y for information is available, N for no information.
CRIMINAL_PROCEEDING_IND	VARCHAR2	(30)		Indicates if criminal proceedings exist. Y for information is available, N for no information.
SUIT_JUDGE_IND	VARCHAR2	(30)		No longer used.
CLAIMS_IND	VARCHAR2	(30)		Indicates if open claims, legal claims, liens, protested bills or equivalent exist. Y for information is available, N for no information.
SECURED_FLNG_IND	VARCHAR2	(30)		Indicates if open secured filings such as UCC filings, secured charges/mortgages pledgings or equivalent exist. Y for information is available, N for no information.
FINCL_LGL_EVENT_IND	VARCHAR2	(30)		Indicates if special events, such as financial embarrassment and legal filings, exist. Y for information is available, N for no information.
DISASTER_IND	VARCHAR2	(30)		Indicates if information exists about disasters such as fires, hurricanes, and so on. Y for information is available, N for no information.
OPRG_SPEC_EVNT_IND	VARCHAR2	(30)		Indicates if information exists about operational changes such as name changes, management changes, change of control, moves, and so on. Y for information is available, N for no information.
OTHER_SPEC_EVNT_IND	VARCHAR2	(30)		Indicates if special events exist that are not otherwise specified.
CONTENT_SOURCE_TYPE	VARCHAR2	(30)	Yes	Source of data content
STATUS	VARCHAR2	(1)		Record status flag
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who column
APPLICATION_ID	NUMBER			TCA Who column
AVG_HIGH_CREDIT	NUMBER			Average of all of the high credit experiences
CREDIT_SCORE	VARCHAR2	(30)		Indicates the risk of delinquent payments.
CREDIT_SCORE_AGE	NUMBER			Indicate the age of the credit score, expressed in months.
CREDIT_SCORE_CLASS	NUMBER			Provides the date when the credit score was calculated.
CREDIT_SCORE_COMMENTARY	VARCHAR2	(30)		Lookup for explanation codes in the CREDIT_SCORE column.
CREDIT_SCORE_COMMENTARY2	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY3	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY4	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY5	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY6	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY7	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY8	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY9	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_COMMENTARY10	VARCHAR2	(30)		Used for comments about the credit score.
CREDIT_SCORE_DATE	DATE			Provides the date when the credit score was calculated.
CREDIT_SCORE_INCD_DEFAULT	NUMBER			Indicates the probability, expressed as a percentage, of delinquency for a score range or class.
CREDIT_SCORE_NATL_PERCENTILE	NUMBER			Indicates the relative credit rating of a business compared to all businesses whose credit ratings are included in the local country database.
DEBARMENT_IND	VARCHAR2	(1)		Indicates whether the company is debarred from doing business with government agencies. Y if the compnay is debarred, N if it is not debarred.
DEBARMENTS_COUNT	NUMBER			Count of filings by government agencies in the United States that prohibit the party from entering into contracts or transactions with those agencies.
DEBARMENTS_DATE	DATE			Date of most recent filing to prohibit the party from entering into contracts or transactions with a government agency in the United States.
HIGH_CREDIT	NUMBER			Maximum credit ever extended to this organization.
MAXIMUM_CREDIT_CURRENCY_CODE	VARCHAR2	(240)		Currency used to denominate the MAXIMUM_CREDIT_RECOMMENDATION column.
MAXIMUM_CREDIT_RECOMMENDATION	NUMBER			Maximum credit limit recommended for the currency specified in the MAXIMUM_CREDIT_CURRENCY_CODE column.
PAYDEX_NORM	VARCHAR2	(3)		Median or average Paydex score for the industry.
PAYDEX_SCORE	VARCHAR2	(3)		Paydex score for the last 12 months payment history.
PAYDEX_THREE_MONTHS_AGO	VARCHAR2	(3)		Paydex score three months ago.
CREDIT_SCORE_OVERRIDE_CODE	VARCHAR2	(30)		In the US, indicates why no score was calculated, or why score equals zero.
CR_SCR_CLAS_EXPL	VARCHAR2	(30)		Explains numeric credit risk score, which estimates the risk of delinquent payment over the next 12 months.
LOW_RNG_DELQ_SCR	NUMBER			Specifies the low end of the range of the Commercial Credit Score.
HIGH_RNG_DELQ_SCR	NUMBER			Specifies the high end of the range of the Commercial Credit Score.
DELQ_PMT_RNG_PRCNT	NUMBER			Specifies a delinquency percentage for a Credit Score range.
DELQ_PMT_PCTG_FOR_ALL_FIRMS	NUMBER			Specifies a delinquency percentage for all firms.
NUM_TRADE_EXPERIENCES	NUMBER			Number of trade experiences.
PAYDEX_FIRM_DAYS	VARCHAR2	(15)		Number of days used in the Paydex score.
PAYDEX_FIRM_COMMENT	VARCHAR2	(60)		Comment on the Paydex score for the organization.
PAYDEX_INDUSTRY_DAYS	VARCHAR2	(15)		Number of days used in the Paydex score for the industry.
PAYDEX_INDUSTRY_COMMENT	VARCHAR2	(50)		Comment on the Paydex score for the industry.
PAYDEX_COMMENT	VARCHAR2	(240)		Additional Paydex information.
SUIT_IND	VARCHAR2	(1)		Indicates if open suits exist. Y if any open suit exists, N if no open suit exists.
LIEN_IND	VARCHAR2	(1)		Indicates if open liens exist. Y if any open lien exists, N if no open lien exists.
JUDGEMENT_IND	VARCHAR2	(1)		Indicates if open judgments exist. Y if any open judgment exists, N if no open judgment exists.
BANKRUPTCY_IND	VARCHAR2	(1)		Indicates if open bankruptcy exists. Y if any open bankruptcy exists, N if no open bankruptcy exists.
NO_TRADE_IND	VARCHAR2	(1)		Indicates no trade experiences exist. Y if any trade experience exists, N if no trade experience exists.
PRNT_HQ_BKCY_IND	VARCHAR2	(1)		Indicates if Parent (P) or Headquarters (H) entered into bankruptcy.
NUM_PRNT_BKCY_FILING	NUMBER			Number of bankruptcies filed by the parent.
PRNT_BKCY_FILG_TYPE	VARCHAR2	(20)		Type of bankruptcy filed by the parent.
PRNT_BKCY_FILG_CHAPTER	NUMBER			Chapter number of the bankruptcy filed by the parent under US Uniform Commercial Code.
PRNT_BKCY_FILG_DATE	DATE			Bankruptcy filing date of the parent.
NUM_PRNT_BKCY_CONVS	NUMBER			Number of bankruptcy conversions by the parent.
PRNT_BKCY_CONV_DATE	DATE			Date the bankruptcy converted from one type to another.
PRNT_BKCY_CHAPTER_CONV	VARCHAR2	(60)		Change of bankruptcy type.
SLOW_TRADE_EXPL	VARCHAR2	(100)		Conditional comment generated when Paydex score indicates slow trade experiences are present.
NEGV_PMT_EXPL	VARCHAR2	(150)		Conditional comment generated when negative payments are present.
PUB_REC_EXPL	VARCHAR2	(150)		Conditional comment generated if suits, liens, and judgments exist.
BUSINESS_DISCONTINUED	VARCHAR2	(240)		Business discontinued at the listed location. Prompts reader to contact D&B Customer Service Center if business may be operating.
SPCL_EVENT_COMMENT	VARCHAR2	(150)		Comment generated if special event section exists.
NUM_SPCL_EVENT	NUMBER			Number of occurrences of the special events.
SPCL_EVENT_UPDATE_DATE	DATE			Date this special event was updated.
SPCL_EVNT_TXT	VARCHAR2	(2000)		Narrative of the special event.
FAILURE_SCORE	VARCHAR2	(30)		For US, the Failure Risk Class, 1 through 5. For Canada ,the Stability Score that indicates risk of business closure, 1 through 10. For Australia, the percentile failure score.
FAILURE_SCORE_AGE	NUMBER			Failure score age in months.
FAILURE_SCORE_CLASS	NUMBER			1 through 5 to indicate risk of financial stress for a customer account. 1 for a business with greatest risk, and 5 for a business with least risk.
FAILURE_SCORE_COMMENTARY	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY2	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY3	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY4	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY5	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY6	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY7	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY8	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY9	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_COMMENTARY10	VARCHAR2	(30)		Comments related to failure score.
FAILURE_SCORE_DATE	DATE			Date that the failure score was calculated.
FAILURE_SCORE_INCD_DEFAULT	NUMBER			Probability, in percentage, of failure for score range of class
FAILURE_SCORE_NATNL_PERCENTILE	NUMBER			National percentile that reflects the relative ranking of a company among all scorable companies in the local country database.
FAILURE_SCORE_OVERRIDE_CODE	VARCHAR2	(30)		In Europe, code for the reason for variance between the D&B Rating and the Failure Score. In the US, code for the reason why no score was calculated, or why the score is 0.
GLOBAL_FAILURE_SCORE	VARCHAR2	(5)		Global score for risk of business default.
ACTUAL_CONTENT_SOURCE	VARCHAR2	(30)	Yes	Additional Content Source Type column for backward compatibility.

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

AR.HZ_CREDIT_RATINGS does not reference any database object

AR.HZ_CREDIT_RATINGS is referenced by following:

APPS: HZ_CREDIT_RATINGS