| Required Inbound Acct Validation | Required Inbound Data Mgt | | | | | | | | |
|---|
objectType | Required | | ObjectTypeEnum | | | not stored in DB | | EagleML/referenceTransaction/rating/objectType |
objectId | | | ObjectId | | | not stored in DB | | EagleML/referenceTransaction/rating/objectId |
objectDescription | | | FeedTypeEnum | | | not stored in DB | | EagleML/referenceTransaction/rating/objectDescription |
updateTimestamp | | | dateTime | | | SECURITYDBO | RATINGS | UPDATE_DATE | | EagleML/referenceTransaction/rating/updateTimestamp |
customElements | Not recommended | CustomElements - Complex type - reserved for customizations | | | | | EagleML/referenceTransaction/rating/customElements |
sourceName | Required | | string | 1102 | | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/rating/sourceName |
updateSource | | | string | 944 | in_update_source | SECURITYDBO | RATINGS | UPDATE_SOURCE | VARCHAR2(255) | EagleML/referenceTransaction/rating/updateSource |
effectiveDate | Required | | date | 1109 | in_effective_date | SECURITYDBO | RATINGS | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/rating/effectiveDate |
languageId | | | integer | | | not stored in DB | | EagleML/referenceTransaction/rating/languageId |
tagNochangecase | | | string | | | not stored in DB | | EagleML/referenceTransaction/rating/tagNochangecase |
preserveNull | | | string | | | not stored in DB | | EagleML/referenceTransaction/rating/preserveNull |
noLoadValidationFlag | | | YesNoOptionEnum | | | not stored in DB | | EagleML/referenceTransaction/rating/noLoadValidationFlag |
Asset Identifiers Model | EagleML/referenceTransaction/rating/ |
ratingDataModel | RatingDataModel - Complex type (see the table below) | EagleML/referenceTransaction/rating/ratingDataModel/ |
The above section of the EagleML is around asset resolution, which is necessary for resolving the security but is not actually stored in the database when working with Ratings. Only the ratings model below is actually stored in the database RatingDataModel Table |
alphaRating | Required | | string | 1671 | in_alpha_rating | SECURITYDBO | RATINGS | ALPHA_RATING | CHAR(8) | EagleML/referenceTransaction/rating/ratingDataModel/alphaRating |
numericalRating | | | decimal | 1672 | in_numerical_rating | SECURITYDBO | RATINGS | NUMERICAL_RATING | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/numericalRating |
analystCode | | | string | 1673 | in_analyst_code | SECURITYDBO | RATINGS | ANALYST_CODE | CHAR(8) | EagleML/referenceTransaction/rating/ratingDataModel/analystCode |
reason | | | string | 1674 | in_reason | SECURITYDBO | RATINGS | REASON | VARCHAR2(255), | EagleML/referenceTransaction/rating/ratingDataModel/reason |
approvedBy | | | string | 1675 | in_approved_by | SECURITYDBO | RATINGS | APPROVED_BY | CHAR(255) | EagleML/referenceTransaction/rating/ratingDataModel/approvedBy |
submittedBy | | | string | 1676 | in_submitted_by | SECURITYDBO | RATINGS | SUBMITTED_BY | CHAR(255) | EagleML/referenceTransaction/rating/ratingDataModel/submittedBy |
ratingComments | | | string | 1677 | in_rating_comments | SECURITYDBO | RATINGS | RATING_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/rating/ratingDataModel/ratingComments |
approvalComments | | | string | 1678 | in_approval_comments | SECURITYDBO | RATINGS | APPROVAL_COMMENTS | VARCHAR2(255) | EagleML/referenceTransaction/rating/ratingDataModel/approvalComments |
submittedDate | | | string | 1679 | in_submitted_date | SECURITYDBO | RATINGS | SUBMITTED_DATE | DATE | EagleML/referenceTransaction/rating/ratingDataModel/submittedDate |
ipoFlag | | | integer | 1680 | in_ipo_flag | SECURITYDBO | RATINGS | IPO_FLAG | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag |
offeringPrice | | | decimal | 1681 | in_offering_price | SECURITYDBO | RATINGS | OFFERING_PRICE | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice |
ipoVerifyFlag | | | integer | 1682 | in_ipo_verify_flag | SECURITYDBO | RATINGS | IPO_VERIFY_FLAG | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag |
provider | | | string | 1683 | in_provider | SECURITYDBO | RATINGS | PROVIDER | CHAR(12) | EagleML/referenceTransaction/rating/ratingDataModel/provider |
ratingCode | Required - Defaulted to "Source Name" by Panel | | string | 1165, 3639 | in_rating_code | SECURITYDBO | RATINGS | RATING_CODE | VARCHAR2(12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingCode |
ratingTypeIndicator | | | string | 3640 | in_rating_type_indicator | SECURITYDBO | RATINGS | RATING_TYPE_INDICATOR | VARCHAR2(20) | EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator |
program | | | string | 3641 | in_program | SECURITYDBO | RATINGS | PROGRAM | VARCHAR2(20) | EagleML/referenceTransaction/rating/ratingDataModel/program |
ratingEnhanc | | | string | 3642 | in_rating_enhanc | SECURITYDBO | RATINGS | RATING_ENHANC | VARCHAR2(12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc |
auditAlphaRating | | | string | 3637 | in_audit_alpha_rating | SECURITYDBO | RATINGS | AUDIT_ALPHA_RATING | VARCHAR2(8) | EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating |
auditDate | | | string | 3638 | in_audit_date | SECURITYDBO | RATINGS | AUDIT_DATE | DATE | EagleML/referenceTransaction/rating/ratingDataModel/auditDate |
ratingChar1 | | | string | 3649 | in_rating_char1 | SECURITYDBO | RATINGS | RATING_CHAR1 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1 |
ratingChar2 | | | string | 3650 | in_rating_char2 | SECURITYDBO | RATINGS | RATING_CHAR2 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2 |
ratingChar3 | | | string | 3651 | in_rating_char3 | SECURITYDBO | RATINGS | RATING_CHAR3 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3 |
ratingChar4 | | | string | 3652 | in_rating_char4 | SECURITYDBO | RATINGS | RATING_CHAR4 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4 |
ratingChar5 | | | string | 3653 | in_rating_char5 | SECURITYDBO | RATINGS | RATING_CHAR5 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5 |
ratingChar6 | | | string | 3654 | in_rating_char6 | SECURITYDBO | RATINGS | RATING_CHAR6 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6 |
ratingChar7 | | | string | 3655 | in_rating_char7 | SECURITYDBO | RATINGS | RATING_CHAR7 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7 |
ratingChar8 | | | string | 3656 | in_rating_char8 | SECURITYDBO | RATINGS | RATING_CHAR8 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8 |
ratingChar9 | | | string | 3657 | in_rating_char9 | SECURITYDBO | RATINGS | RATING_CHAR9 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9 |
ratingChar10 | | | string | 3658 | in_rating_char10 | SECURITYDBO | RATINGS | RATING_CHAR10 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10 |
ratingChar11 | | | string | 3823 | in_rating_char11 | SECURITYDBO | RATINGS | RATING_CHAR11 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11 |
ratingChar12 | | | string | 3824 | in_rating_char12 | SECURITYDBO | RATINGS | RATING_CHAR12 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12 |
ratingChar13 | | | string | 3825 | in_rating_char13 | SECURITYDBO | RATINGS | RATING_CHAR13 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13 |
ratingChar14 | | | string | 3826 | in_rating_char14 | SECURITYDBO | RATINGS | RATING_CHAR14 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14 |
ratingChar15 | | | string | 3827 | in_rating_char15 | SECURITYDBO | RATINGS | RATING_CHAR15 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15 |
ratingChar16 | | | string | 3828 | in_rating_char16 | SECURITYDBO | RATINGS | RATING_CHAR16 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16 |
ratingChar17 | | | string | 3829 | in_rating_char17 | SECURITYDBO | RATINGS | RATING_CHAR17 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17 |
ratingChar18 | | | string | 3830 | in_rating_char18 | SECURITYDBO | RATINGS | RATING_CHAR18 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18 |
ratingChar19 | | | string | 3831 | in_rating_char19 | SECURITYDBO | RATINGS | RATING_CHAR19 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19 |
ratingChar20 | | | string | 3832 | in_rating_char20 | SECURITYDBO | RATINGS | RATING_CHAR20 | VARCHAR2(60) | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20 |
ratingDate1 | | | string | 3643 | in_rating_date1 | SECURITYDBO | RATINGS | RATING_DATE1 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1 |
ratingDate2 | | | string | 3644 | in_rating_date2 | SECURITYDBO | RATINGS | RATING_DATE2 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate2 |
ratingDate3 | | | string | 3645 | in_rating_date3 | SECURITYDBO | RATINGS | RATING_DATE3 | DATE | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate3 |
ratingFloat1 | | | decimal | 3646 | in_rating_float1 | SECURITYDBO | RATINGS | RATING_FLOAT1 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1 |
ratingFloat2 | | | decimal | 3647 | in_rating_float2 | SECURITYDBO | RATINGS | RATING_FLOAT2 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2 |
ratingFloat3 | | | decimal | 3648 | in_rating_float3 | SECURITYDBO | RATINGS | RATING_FLOAT3 | NUMBER(28,12) | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3 |
securityAlias | | | integer | 10 | in_security_alias | SECURITYDBO | RATINGS | SECURITY_ALIAS | NUMBER | EagleML/referenceTransaction/rating/ratingDataModel/securityAlias |
ratingSrc | | | string | 1102 | in_rating_src | PACE_MASTERDBO | INTERFACES | SHORT_DESC | CHAR(15) | EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc |
sourceDescription | extract only | string | | | PACE_MASTERDBO | INTERFACES | LONG_DESC | CHAR(50) | EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription |