HZ_IMP_CREDITRTNGS_T
The import interface table HZ_IMP_CREDITRTNGS_T stores information for population into HZ_CREDIT_RATINGS table.
Details
-
Schema: FUSION
-
Object owner: HZ
-
Object type: TABLE
-
Tablespace: INTERFACE
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CREDITRTNG_T_ID | NUMBER | 18 | Unique identifier of the HZ_IMP_CREDITRTNGS_T interface record. Internal use only. | ||
| INTERFACE_ROW_ID | NUMBER | 18 | Unique identifier of the HZ_IMP_CREDITRTNGS_T interface record. Internal use only. | ||
| BATCH_ID | NUMBER | 18 | Yes | Unique Identifier for a Batch | |
| PARTY_ORIG_SYSTEM | VARCHAR2 | 30 | Original System ID for the Party | ||
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | 240 | Original System Reference for the Party | ||
| CREDITRTNG_ORIG_SYSTEM | VARCHAR2 | 30 | Original System ID for the Credit Rating | ||
| CREDITRTNG_ORIG_SYSTEM_REF | VARCHAR2 | 240 | Original System Reference for the Credit Rating | ||
| CREDIT_RATING_ID | NUMBER | 18 | Storing the Credit Rating Id after matching | ||
| RATED_AS_OF_DATE | DATE | The date that the rating was acquired. | |||
| RATING_ORGANIZATION | VARCHAR2 | 240 | The name of the credit rating organization | ||
| INSERT_UPDATE_FLAG | VARCHAR2 | 1 | Indicates if a record should be explicitly inserted or updated | ||
| ACTION_FLAG | VARCHAR2 | 20 | Indicates the action of insert or update based on matching outcome. | ||
| PARTY_ID | NUMBER | 18 | Party that owns the credit rating | ||
| AVG_HIGH_CREDIT | NUMBER | Average of all of the high credit experiences | |||
| BANKRUPTCY_IND | VARCHAR2 | 1 | Indicates if open bankruptcy exists. Y if any open bankruptcy exists, N if no open bankruptcy exists | ||
| BUSINESS_DISCONTINUED | VARCHAR2 | 240 | Business discontinued at the listed location. Prompts reader to contact D&B Customer Service Center if business may be operating | ||
| 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 | ||
| COMMENTS | VARCHAR2 | 240 | Commentary explaining the rating | ||
| CR_SCR_CLAS_EXPL | VARCHAR2 | 30 | Explains numeric credit risk score, which estimates the risk of delinquent payment over the next 12 months | ||
| 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 risk of the credit score | |||
| 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. 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. | |||
| CREDIT_SCORE_OVERRIDE_CODE | VARCHAR2 | 30 | In the US, indicates why no score was calculated, or why score equals zero. | ||
| CRIMINAL_PROCEEDING_IND | VARCHAR2 | 30 | Indicates if criminal proceedings exist. Y for information is available, N for no information | ||
| DEBARMENT_IND | VARCHAR2 | 1 | Indicates whether the company is debarred from doing business with government agencies. Y if the company 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 | |||
| DELQ_PMT_PCTG_FOR_ALL_FIRMS | NUMBER | Specifies a delinquency percentage for all firms | |||
| DELQ_PMT_RNG_PRCNT | NUMBER | Specifies a delinquency percentage for a Credit Score range | |||
| DESCRIPTION | VARCHAR2 | 2000 | A textual description of the rating effort | ||
| 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. | ||
| 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. | ||
| 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. | ||
| FINCL_EMBT_IND | VARCHAR2 | 30 | Indicates if open bankruptcy, receivership liquidation, 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 | ||
| GLOBAL_FAILURE_SCORE | VARCHAR2 | 5 | Indicates if special events, such as financial embarrassment and legal filings, exist. Y for information is available, N for no information | ||
| HIGH_CREDIT | NUMBER | Maximum credit ever extended to this organization | |||
| HIGH_RNG_DELQ_SCR | NUMBER | Specifies the high end of the range of the Commercial Credit Score. | |||
| JUDGEMENT_IND | VARCHAR2 | 1 | Indicates if open judgments exist. Y if any open judgment exists, N if no open judgment exists. | ||
| LIEN_IND | VARCHAR2 | 1 | Indicates if open liens exist. Y if any open lien exists, N if no open lien exists. | ||
| LOW_RNG_DELQ_SCR | NUMBER | Specifies the low end of the range of the Commercial Credit Score | |||
| 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. | |||
| NEGV_PMT_EXPL | VARCHAR2 | 150 | Conditional comment generated when negative payments are present. | ||
| NO_TRADE_IND | VARCHAR2 | 1 | Indicates no trade experiences exist. Y if any trade experience exists, N if no trade experience exists | ||
| NUM_PRNT_BKCY_CONVS | NUMBER | Number of bankruptcy conversions by the parent. | |||
| NUM_PRNT_BKCY_FILING | NUMBER | Number of bankruptcies filed by the parent. | |||
| NUM_SPCL_EVENT | NUMBER | Number of occurrences of the special events | |||
| NUM_TRADE_EXPERIENCES | NUMBER | Number of trade experiences. | |||
| 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 | ||
| PAYDEX_COMMENT | VARCHAR2 | 240 | Additional Paydex information | ||
| PAYDEX_FIRM_COMMENT | VARCHAR2 | 60 | Comment on the Paydex score for the organization | ||
| PAYDEX_FIRM_DAYS | VARCHAR2 | 15 | Number of days used in the Paydex score | ||
| PAYDEX_INDUSTRY_COMMENT | VARCHAR2 | 50 | Comment on the Paydex score for the industry | ||
| PAYDEX_INDUSTRY_DAYS | VARCHAR2 | 15 | Number of days used in the Paydex score for the industry | ||
| 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 | ||
| PRNT_BKCY_CHAPTER_CONV | VARCHAR2 | 60 | Number of bankruptcy conversions by the parent | ||
| PRNT_BKCY_CONV_DATE | DATE | Date the bankruptcy converted from one type to another | |||
| 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 | |||
| PRNT_BKCY_FILG_TYPE | VARCHAR2 | 20 | Type of bankruptcy filed by the parent | ||
| PRNT_HQ_BKCY_IND | VARCHAR2 | 1 | Indicates if Parent (P) or Headquarters (H) entered into bankruptcy | ||
| PUB_REC_EXPL | VARCHAR2 | 150 | Conditional comment generated if suits, liens, and judgments exist. | ||
| RATING | VARCHAR2 | 60 | The rating company's rating number or code | ||
| SECURED_FLNG_IND | VARCHAR2 | 30 | Indicates if open secured filings such as UCC filings, secured charges/mortgages pledging or equivalent exist. Y for information is available, N for no information. | ||
| SLOW_TRADE_EXPL | VARCHAR2 | 100 | Conditional comment generated when Paydex score indicates slow trade experiences are present | ||
| SPCL_EVENT_COMMENT | VARCHAR2 | 150 | Comment generated if special event section exists | ||
| SPCL_EVENT_UPDATE_DATE | DATE | Date this special event was updated | |||
| SPCL_EVNT_TXT | VARCHAR2 | 2000 | Narrative of the special event | ||
| SUIT_IND | VARCHAR2 | 1 | Indicates if open suits exist. Y if any open suit exists, N if no open suit exists. | ||
| INTERFACE_STATUS | VARCHAR2 | 30 | Status for the data in the interface table | ||
| ERROR_ID | NUMBER | 18 | Foreign Key to the Error Table | ||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE21 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE22 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE23 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE24 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE25 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE26 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE27 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE28 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE29 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| ATTRIBUTE30 | VARCHAR2 | 255 | Descriptive Flexfield: segment of the user descriptive flexfield. | ||
| 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. | |||
| FILE_RECORD_NUM | NUMBER | 10 | This column is required by import wizard to related record in the interface table to the file row. | ||
| ACTION_CODE | VARCHAR2 | 30 | Indicates delete action entered by user | ||
| IMPORT_STATUS_CODE | VARCHAR2 | 30 | Status for the data in the interface table | ||
| FILE_NAME_SYSTASK_ID | NUMBER | 18 | Stores systask id for each import csv file. | ||
| PARTY_NUMBER | VARCHAR2 | 30 | Unique identification number for this party |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| HZ_IMP_CREDITRTNGS_T | hz_imp_batch_summary | BATCH_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| HZ_IMP_CREDITRTNGS_T_N1 | Non Unique | Default | BATCH_ID, CREDITRTNG_T_ID |
| HZ_IMP_CREDITRTNGS_T_N2 | Non Unique | Default | BATCH_ID, CREDITRTNG_ORIG_SYSTEM, CREDITRTNG_ORIG_SYSTEM_REF, INTERFACE_STATUS |
| HZ_IMP_CREDITRTNGS_T_N3 | Non Unique | Default | BATCH_ID, FILE_RECORD_NUM, INTERFACE_STATUS |
| HZ_IMP_CREDITRTNGS_T_N4 | Non Unique | Default | BATCH_ID, CREDIT_RATING_ID, INTERFACE_STATUS |
| HZ_IMP_CREDITRTNGS_T_N5 | Non Unique | Default | BATCH_ID, PARTY_NUMBER |
| HZ_IMP_CREDITRTNGS_T_N6 | Non Unique | Default | PARTY_ORIG_SYSTEM, PARTY_ORIG_SYSTEM_REFERENCE |
| HZ_IMP_CREDITRTNGS_T_U1 | Unique | Default | CREDITRTNG_T_ID |