[Home] [Help] [Dependency Information]
Object Name: | HZ_CREDIT_RATING_OBJ |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
ACTION_TYPE | VARCHAR2 | (30) | |
COMMON_OBJ_ID | VARCHAR2 | (255) | |
CREDIT_RATING_ID | NUMBER |
|
|
DESCRIPTION | VARCHAR2 | (2000) | |
ORGANIZATION_ID | NUMBER |
|
|
RATING | VARCHAR2 | (60) | |
RATED_AS_OF_DATE | DATE |
|
|
RATING_ORGANIZATION | VARCHAR2 | (240) | |
COMMENTS | VARCHAR2 | (240) | |
DET_HISTORY_IND | VARCHAR2 | (5) | |
FINCL_EMBT_IND | VARCHAR2 | (5) | |
CRIMINAL_PROCEEDING_IND | VARCHAR2 | (5) | |
CLAIMS_IND | VARCHAR2 | (5) | |
SECURED_FLNG_IND | VARCHAR2 | (5) | |
FINCL_LGL_EVENT_IND | VARCHAR2 | (5) | |
DISASTER_IND | VARCHAR2 | (5) | |
OPRG_SPEC_EVNT_IND | VARCHAR2 | (5) | |
OTHER_SPEC_EVNT_IND | VARCHAR2 | (5) | |
STATUS | VARCHAR2 | (1) | |
AVG_HIGH_CREDIT | NUMBER |
|
|
CREDIT_SCORE | VARCHAR2 | (30) | |
CREDIT_SCORE_AGE | NUMBER |
|
|
CREDIT_SCORE_CLASS | NUMBER |
|
|
CREDIT_SCORE_COMMENTARY | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY2 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY3 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY4 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY5 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY6 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY7 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY8 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY9 | VARCHAR2 | (30) | |
CREDIT_SCORE_COMMENTARY10 | VARCHAR2 | (30) | |
CREDIT_SCORE_DATE | DATE |
|
|
CREDIT_SCORE_INCD_DEFAULT | NUMBER |
|
|
CREDIT_SCORE_NATL_PERCENTILE | NUMBER |
|
|
FAILURE_SCORE | VARCHAR2 | (30) | |
FAILURE_SCORE_AGE | NUMBER |
|
|
FAILURE_SCORE_CLASS | NUMBER |
|
|
FAILURE_SCORE_COMMENTARY | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY2 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY3 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY4 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY5 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY6 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY7 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY8 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY9 | VARCHAR2 | (30) | |
FAILURE_SCORE_COMMENTARY10 | VARCHAR2 | (30) | |
FAILURE_SCORE_DATE | DATE |
|
|
FAILURE_SCORE_INCD_DEFAULT | NUMBER |
|
|
FAILURE_SCORE_NATNL_PER | NUMBER |
|
|
FAILURE_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | |
GLOBAL_FAILURE_SCORE | VARCHAR2 | (30) | |
DEBARMENT_IND | VARCHAR2 | (30) | |
DEBARMENTS_COUNT | NUMBER |
|
|
DEBARMENTS_DATE | DATE |
|
|
HIGH_CREDIT | NUMBER |
|
|
MAXIMUM_CREDIT_CURRENCY_CODE | VARCHAR2 | (240) | |
MAXIMUM_CREDIT_RCMD | NUMBER |
|
|
PAYDEX_NORM | VARCHAR2 | (3) | |
PAYDEX_SCORE | VARCHAR2 | (3) | |
PAYDEX_THREE_MONTHS_AGO | VARCHAR2 | (3) | |
CREDIT_SCORE_OVERRIDE_CODE | VARCHAR2 | (30) | |
CR_SCR_CLAS_EXPL | VARCHAR2 | (30) | |
LOW_RNG_DELQ_SCR | NUMBER |
|
|
HIGH_RNG_DELQ_SCR | NUMBER |
|
|
DELQ_PMT_RNG_PRCNT | NUMBER |
|
|
DELQ_PMT_PCTG_FOR_ALL_FIRMS | NUMBER |
|
|
NUM_TRADE_EXPERIENCES | NUMBER |
|
|
PAYDEX_FIRM_DAYS | VARCHAR2 | (15) | |
PAYDEX_FIRM_COMMENT | VARCHAR2 | (60) | |
PAYDEX_INDUSTRY_DAYS | VARCHAR2 | (15) | |
PAYDEX_INDUSTRY_COMMENT | VARCHAR2 | (50) | |
PAYDEX_COMMENT | VARCHAR2 | (240) | |
SUIT_IND | VARCHAR2 | (5) | |
LIEN_IND | VARCHAR2 | (5) | |
JUDGEMENT_IND | VARCHAR2 | (5) | |
BANKRUPTCY_IND | VARCHAR2 | (5) | |
NO_TRADE_IND | VARCHAR2 | (5) | |
PRNT_HQ_BKCY_IND | VARCHAR2 | (5) | |
NUM_PRNT_BKCY_FILING | NUMBER |
|
|
PRNT_BKCY_FILG_TYPE | VARCHAR2 | (20) | |
PRNT_BKCY_FILG_CHAPTER | NUMBER |
|
|
PRNT_BKCY_FILG_DATE | DATE |
|
|
NUM_PRNT_BKCY_CONVS | NUMBER |
|
|
PRNT_BKCY_CONV_DATE | DATE |
|
|
PRNT_BKCY_CHAPTER_CONV | VARCHAR2 | (60) | |
SLOW_TRADE_EXPL | VARCHAR2 | (100) | |
NEGV_PMT_EXPL | VARCHAR2 | (150) | |
PUB_REC_EXPL | VARCHAR2 | (150) | |
BUSINESS_DISCONTINUED | VARCHAR2 | (240) | |
SPCL_EVENT_COMMENT | VARCHAR2 | (150) | |
NUM_SPCL_EVENT | NUMBER |
|
|
SPCL_EVENT_UPDATE_DATE | DATE |
|
|
SPCL_EVNT_TXT | VARCHAR2 | (2000) | |
ACTUAL_CONTENT_SOURCE | VARCHAR2 | (30) | |
PROGRAM_UPDATE_DATE | DATE |
|
|
CREATED_BY_MODULE | VARCHAR2 | (150) | |
CREATED_BY_NAME | VARCHAR2 | (100) | |
CREATION_DATE | DATE |
|
|
LAST_UPDATE_DATE | DATE |
|
|
LAST_UPDATED_BY_NAME | VARCHAR2 | (100) |
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_CREDIT_RATING_ID(NUMBER) P_DESCRIPTION(VARCHAR2) P_RATING(VARCHAR2) P_RATED_AS_OF_DATE(DATE) P_RATING_ORGANIZATION(VARCHAR2) P_COMMENTS(VARCHAR2) P_DET_HISTORY_IND(VARCHAR2) P_FINCL_EMBT_IND(VARCHAR2) P_CRIMINAL_PROCEEDING_IND(VARCHAR2) P_CLAIMS_IND(VARCHAR2) P_SECURED_FLNG_IND(VARCHAR2) P_FINCL_LGL_EVENT_IND(VARCHAR2) P_DISASTER_IND(VARCHAR2) P_OPRG_SPEC_EVNT_IND(VARCHAR2) P_OTHER_SPEC_EVNT_IND(VARCHAR2) P_STATUS(VARCHAR2) P_AVG_HIGH_CREDIT(NUMBER) P_CREDIT_SCORE(VARCHAR2) P_CREDIT_SCORE_AGE(NUMBER) P_CREDIT_SCORE_CLASS(NUMBER) P_CREDIT_SCORE_COMMENTARY(VARCHAR2) P_CREDIT_SCORE_COMMENTARY2(VARCHAR2) P_CREDIT_SCORE_COMMENTARY3(VARCHAR2) P_CREDIT_SCORE_COMMENTARY4(VARCHAR2) P_CREDIT_SCORE_COMMENTARY5(VARCHAR2) P_CREDIT_SCORE_COMMENTARY6(VARCHAR2) P_CREDIT_SCORE_COMMENTARY7(VARCHAR2) P_CREDIT_SCORE_COMMENTARY8(VARCHAR2) P_CREDIT_SCORE_COMMENTARY9(VARCHAR2) P_CREDIT_SCORE_COMMENTARY10(VARCHAR2) P_CREDIT_SCORE_DATE(DATE) P_CREDIT_SCORE_INCD_DEFAULT(NUMBER) P_CREDIT_SCORE_NATL_PERCENTILE(NUMBER) P_FAILURE_SCORE(VARCHAR2) P_FAILURE_SCORE_AGE(NUMBER) P_FAILURE_SCORE_CLASS(NUMBER) P_FAILURE_SCORE_COMMENTARY(VARCHAR2) P_FAILURE_SCORE_COMMENTARY2(VARCHAR2) P_FAILURE_SCORE_COMMENTARY3(VARCHAR2) P_FAILURE_SCORE_COMMENTARY4(VARCHAR2) P_FAILURE_SCORE_COMMENTARY5(VARCHAR2) P_FAILURE_SCORE_COMMENTARY6(VARCHAR2) P_FAILURE_SCORE_COMMENTARY7(VARCHAR2) P_FAILURE_SCORE_COMMENTARY8(VARCHAR2) P_FAILURE_SCORE_COMMENTARY9(VARCHAR2) P_FAILURE_SCORE_COMMENTARY10(VARCHAR2) P_FAILURE_SCORE_DATE(DATE) P_FAILURE_SCORE_INCD_DEFAULT(NUMBER) P_FAILURE_SCORE_NATNL_PER(NUMBER) P_FAILURE_SCORE_OVERRIDE_CODE(VARCHAR2) P_GLOBAL_FAILURE_SCORE(VARCHAR2) P_DEBARMENT_IND(VARCHAR2) P_DEBARMENTS_COUNT(NUMBER) P_DEBARMENTS_DATE(DATE) P_HIGH_CREDIT(NUMBER) P_MAXIMUM_CREDIT_CURRENCY_CODE(VARCHAR2) P_MAXIMUM_CREDIT_RCMD(NUMBER) P_PAYDEX_NORM(VARCHAR2) P_PAYDEX_SCORE(VARCHAR2) P_PAYDEX_THREE_MONTHS_AGO(VARCHAR2) P_CREDIT_SCORE_OVERRIDE_CODE(VARCHAR2) P_CR_SCR_CLAS_EXPL(VARCHAR2) P_LOW_RNG_DELQ_SCR(NUMBER) P_HIGH_RNG_DELQ_SCR(NUMBER) P_DELQ_PMT_RNG_PRCNT(NUMBER) P_DELQ_PMT_PCTG_FOR_ALL_FIRMS(NUMBER) P_NUM_TRADE_EXPERIENCES(NUMBER) P_PAYDEX_FIRM_DAYS(VARCHAR2) P_PAYDEX_FIRM_COMMENT(VARCHAR2) P_PAYDEX_INDUSTRY_DAYS(VARCHAR2) P_PAYDEX_INDUSTRY_COMMENT(VARCHAR2) P_PAYDEX_COMMENT(VARCHAR2) P_SUIT_IND(VARCHAR2) P_LIEN_IND(VARCHAR2) P_JUDGEMENT_IND(VARCHAR2) P_BANKRUPTCY_IND(VARCHAR2) P_NO_TRADE_IND(VARCHAR2) P_PRNT_HQ_BKCY_IND(VARCHAR2) P_NUM_PRNT_BKCY_FILING(NUMBER) P_PRNT_BKCY_FILG_TYPE(VARCHAR2) P_PRNT_BKCY_FILG_CHAPTER(NUMBER) P_PRNT_BKCY_FILG_DATE(DATE) P_NUM_PRNT_BKCY_CONVS(NUMBER) P_PRNT_BKCY_CONV_DATE(DATE) P_PRNT_BKCY_CHAPTER_CONV(VARCHAR2) P_SLOW_TRADE_EXPL(VARCHAR2) P_NEGV_PMT_EXPL(VARCHAR2) P_PUB_REC_EXPL(VARCHAR2) P_BUSINESS_DISCONTINUED(VARCHAR2) P_SPCL_EVENT_COMMENT(VARCHAR2) P_NUM_SPCL_EVENT(NUMBER) P_SPCL_EVENT_UPDATE_DATE(DATE) P_SPCL_EVNT_TXT(VARCHAR2) P_ACTUAL_CONTENT_SOURCE(VARCHAR2) |
HZ_CREDIT_RATING_OBJ |
|
|
|