[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | HZ_IMP_CREDITRTNGS_INT |
|---|---|
| Object Type: | TABLE |
| Owner: | AR |
| FND Design Data: |  AR.HZ_IMP_CREDITRTNGS_INT
|
| Subobject Name: | |
| Status: | VALID |
The TCA import interface table, HZ_IMP_CREDITRTNGS_INT, stores information for population into the HZ_CREDIT_RATINGS table in TCA
* Scope: public
* Product: HZ
* Lifecycle: active
* Display Name: Credit Rating
* Category: BUSINESS_ENTITY HZ_ORGANIZATION
Architecture Reference Guide
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| HZ_IMP_CREDITRTNGS_INT_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 BATCH_ID
PARTY_ORIG_SYSTEM
INTERFACE_STATUS
PARTY_ORIG_SYSTEM_REFERENCE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | (15) | Yes | Unique Identifier for a Batch |
| PARTY_ORIG_SYSTEM | VARCHAR2 | (30) | Yes | Original System ID for the Party |
| PARTY_ORIG_SYSTEM_REFERENCE | VARCHAR2 | (240) | Yes | Original System Reference for the Party |
| RATED_AS_OF_DATE | DATE | Yes | The date that the rating was acquired | |
| RATING_ORGANIZATION | VARCHAR2 | (240) | Yes | The name of the credit rating organization |
| INSERT_UPDATE_FLAG | VARCHAR2 | (1) | Indicates if a record should be explicitly inserted or updated | |
| 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 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. | ||
| 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) | Global score for risk of business default. | |
| 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_DATE | DATE | Bankruptcy filing date of 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_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 | (15) | Foreign Key to the Error Table | |
| CREATION_DATE | DATE | Standard Who Column | ||
| CREATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_DATE | DATE | Standard Who Column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard Who Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who Column | |
| REQUEST_ID | NUMBER | (15) | Request identifier of last concurrent program to update this record | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Application identifier of last concurrent program to update this record | |
| PROGRAM_ID | NUMBER | (15) | Program identifier of last concurrent program to update this record | |
| PROGRAM_UPDATE_DATE | DATE | Last date this record was updated by a concurrent program | ||
| CREATED_BY_MODULE | VARCHAR2 | (30) | Standard Who Column | |
| PARTY_ID | NUMBER | (15) | Party that owns the credit rating |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_ID
, PARTY_ORIG_SYSTEM
, PARTY_ORIG_SYSTEM_REFERENCE
, RATED_AS_OF_DATE
, RATING_ORGANIZATION
, INSERT_UPDATE_FLAG
, AVG_HIGH_CREDIT
, BANKRUPTCY_IND
, BUSINESS_DISCONTINUED
, CLAIMS_IND
, COMMENTS
, CR_SCR_CLAS_EXPL
, 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
, CREDIT_SCORE_OVERRIDE_CODE
, CRIMINAL_PROCEEDING_IND
, DEBARMENT_IND
, DEBARMENTS_COUNT
, DEBARMENTS_DATE
, DELQ_PMT_PCTG_FOR_ALL_FIRMS
, DELQ_PMT_RNG_PRCNT
, DESCRIPTION
, DET_HISTORY_IND
, DISASTER_IND
, 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
, FINCL_EMBT_IND
, FINCL_LGL_EVENT_IND
, GLOBAL_FAILURE_SCORE
, HIGH_CREDIT
, HIGH_RNG_DELQ_SCR
, JUDGEMENT_IND
, LIEN_IND
, LOW_RNG_DELQ_SCR
, MAXIMUM_CREDIT_CURRENCY_CODE
, MAXIMUM_CREDIT_RECOMMENDATION
, NEGV_PMT_EXPL
, NO_TRADE_IND
, NUM_PRNT_BKCY_CONVS
, NUM_PRNT_BKCY_FILING
, NUM_SPCL_EVENT
, NUM_TRADE_EXPERIENCES
, OPRG_SPEC_EVNT_IND
, OTHER_SPEC_EVNT_IND
, PAYDEX_COMMENT
, PAYDEX_FIRM_COMMENT
, PAYDEX_FIRM_DAYS
, PAYDEX_INDUSTRY_COMMENT
, PAYDEX_INDUSTRY_DAYS
, PAYDEX_NORM
, PAYDEX_SCORE
, PAYDEX_THREE_MONTHS_AGO
, PRNT_BKCY_CHAPTER_CONV
, PRNT_BKCY_CONV_DATE
, PRNT_BKCY_FILG_DATE
, PRNT_BKCY_FILG_TYPE
, PRNT_BKCY_FILG_CHAPTER
, PRNT_HQ_BKCY_IND
, PUB_REC_EXPL
, RATING
, SECURED_FLNG_IND
, SLOW_TRADE_EXPL
, SPCL_EVENT_COMMENT
, SPCL_EVENT_UPDATE_DATE
, SPCL_EVNT_TXT
, SUIT_IND
, INTERFACE_STATUS
, ERROR_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, CREATED_BY_MODULE
, PARTY_ID
FROM AR.HZ_IMP_CREDITRTNGS_INT;
AR.HZ_IMP_CREDITRTNGS_INT does not reference any database object
AR.HZ_IMP_CREDITRTNGS_INT is referenced by following:
APPS
HZ_IMP_CREDITRTNGS_INT
|
|
|
|