1. Tables and Views for Sales and Fusion Service
  2. HZ_CREDIT_RATINGS

HZ_CREDIT_RATINGS

The HZ_CREDIT_RATINGS table stores information about the creditworthiness of a party. A credit rating from such as Dun and Bradstreet usually supplies the information

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

HZ_CREDIT_RATINGS_PK

CREDIT_RATING_ID

Columns

Name Datatype Length Precision Not-null Comments Status
CREDIT_RATING_ID NUMBER 18 Yes Credit rating identifier
DESCRIPTION VARCHAR2 2000 A textual description of the rating effort. Active
PARTY_ID NUMBER 18 Yes Unique identifier for a party. Foreign key to the HZ_PARTIES table
RATING VARCHAR2 60 The rating company's rating number or code. Active
RATED_AS_OF_DATE DATE The date that the rating was acquired. Active
RATING_ORGANIZATION VARCHAR2 240 The name of the credit rating organization. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
COMMENTS VARCHAR2 2000 Commentary explaining the rating. Active
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. Active
FINCL_EMBT_IND VARCHAR2 30 Indicates if open bankruptcy, receivership liquidation, or equivalent exist. Y for information is available, N for no information. Active
CRIMINAL_PROCEEDING_IND VARCHAR2 30 Indicates if criminal proceedings exist. Y for information is available, N for no information. Active
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. Active
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. Active
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. Active
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. Active
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. Active
OTHER_SPEC_EVNT_IND VARCHAR2 30 Indicates if special events exist that are not otherwise specified. Active
STATUS VARCHAR2 1 Record status flag Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
CREATED_BY_MODULE VARCHAR2 30 TCA Who column Active
AVG_HIGH_CREDIT NUMBER Average of all of the high credit experiences Active
CREDIT_SCORE VARCHAR2 30 Indicates the risk of delinquent payments. Active
CREDIT_SCORE_AGE NUMBER Indicate the age of the credit score, expressed in months. Active
CREDIT_SCORE_CLASS NUMBER Provides the date when the credit score was calculated. Active
CREDIT_SCORE_COMMENTARY VARCHAR2 30 Lookup for explanation codes in the CREDIT_SCORE column. Active
CREDIT_SCORE_COMMENTARY2 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY3 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY4 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY5 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY6 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY7 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY8 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY9 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_COMMENTARY10 VARCHAR2 30 Used for comments about the credit score. Active
CREDIT_SCORE_DATE DATE Provides the date when the credit score was calculated. Active
CREDIT_SCORE_INCD_DEFAULT NUMBER Indicates the probability, expressed as a percentage, of delinquency for a score range or class. Active
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. Active
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. Active
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. Active
HIGH_CREDIT NUMBER Maximum credit ever extended to this organization. Active
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. Active
CR_SCR_CLAS_EXPL VARCHAR2 30 Explains numeric credit risk score, which estimates the risk of delinquent payment over the next 12 months. Active
LOW_RNG_DELQ_SCR NUMBER Specifies the low end of the range of the Commercial Credit Score. Active
HIGH_RNG_DELQ_SCR NUMBER Specifies the high end of the range of the Commercial Credit Score. Active
DELQ_PMT_RNG_PRCNT NUMBER Specifies a delinquency percentage for a Credit Score range. Active
DELQ_PMT_PCTG_FOR_ALL_FIRMS NUMBER Specifies a delinquency percentage for all firms. Active
NUM_TRADE_EXPERIENCES NUMBER Number of trade experiences. Active
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. Active
LIEN_IND VARCHAR2 1 Indicates if open liens exist. Y if any open lien exists, N if no open lien exists. Active
JUDGEMENT_IND VARCHAR2 1 Indicates if open judgments exist. Y if any open judgment exists, N if no open judgment exists. Active
BANKRUPTCY_IND VARCHAR2 1 Indicates if open bankruptcy exists. Y if any open bankruptcy exists, N if no open bankruptcy exists. Active
NO_TRADE_IND VARCHAR2 1 Indicates no trade experiences exist. Y if any trade experience exists, N if no trade experience exists. Active
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. Active
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. Active
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. Active
NEGV_PMT_EXPL VARCHAR2 150 Conditional comment generated when negative payments are present. Active
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. Active
SPCL_EVENT_COMMENT VARCHAR2 150 Comment generated if special event section exists. Active
NUM_SPCL_EVENT NUMBER Number of occurrences of the special events. Active
SPCL_EVENT_UPDATE_DATE DATE Date this special event was updated. Active
SPCL_EVNT_TXT VARCHAR2 2000 Narrative of the special event. Active
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. Active
FAILURE_SCORE_AGE NUMBER Failure score age in months. Active
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. Active
FAILURE_SCORE_COMMENTARY VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY2 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY3 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY4 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY5 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY6 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY7 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY8 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY9 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_COMMENTARY10 VARCHAR2 30 Comments related to failure score. Active
FAILURE_SCORE_DATE DATE Date that the failure score was calculated. Active
FAILURE_SCORE_INCD_DEFAULT NUMBER Probability, in percentage, of failure for score range of class Active
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. Active
GLOBAL_FAILURE_SCORE VARCHAR2 5 Global score for risk of business default. Active
ACTUAL_CONTENT_SOURCE VARCHAR2 30 Additional Content Source Type column for backward compatibility. Active
CONFLICT_ID NUMBER 18 Yes Disconnected Mobile: this value is used to guarantee the uniqueness of the row when duplicates are created in different databases (i.e. mobile databases or the server). Active
USER_LAST_UPDATE_DATE TIMESTAMP Disconnected Mobile: indicates the date and time of the last update of the row. This value is different from LAST_UPDATE_DATE if the update originally happened in a different database (i.e. a different mobile database or the server). Active
ATTRIBUTE_CATEGORY VARCHAR2 30 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE16 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE17 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE18 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE19 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE20 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE21 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE22 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE23 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE24 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE25 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE26 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE27 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE28 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE29 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE30 VARCHAR2 255 Descriptive Flexfield: segment of the user descriptive flexfield. Active
CPDRF_VER_SOR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version in System of Record (SOR) pillar when a record change is replicated to subscribing pillars by the replication flows.
CPDRF_VER_PILLAR NUMBER 9 Cross Pillar Data Replication Framework (CPDRF) system column for tracking record version when a record is changed by replication flows
CPDRF_LAST_UPD VARCHAR2 15 Cross Pillar Data Replication Framework (CPDRF) system column for tracking source pillar name when a record is changed by the replication flows.
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER6 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER7 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER8 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER9 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER10 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER11 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER12 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE6 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE7 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE8 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE9 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE10 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE11 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE12 DATE Descriptive Flexfield: segment of the user descriptive flexfield.

Foreign Keys

Table Foreign Table Foreign Key Column
HZ_CREDIT_RATINGS hz_parties PARTY_ID

Indexes

Index Uniqueness Tablespace Columns
HZ_CREDIT_RATINGS_N1 Non Unique Default LAST_UPDATE_DATE, CREDIT_RATING_ID
HZ_CREDIT_RATINGS_PK Unique Default CREDIT_RATING_ID
HZ_CREDIT_RATINGS_U1 Unique Default PARTY_ID, RATED_AS_OF_DATE, RATING_ORGANIZATION, ACTUAL_CONTENT_SOURCE, CONFLICT_ID