Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Eagle DB | DB Table | DB Field | Star Tag | Data Type | SP Parameter | XPath |
|---|---|---|---|---|---|---|---|---|---|---|
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 - needed for resolution logics | PACE_MASTERDBO | INTERFACES | SHORT_DESC | 1102 | CHAR(15) | EagleML/referenceTransaction/rating/sourceName | ||
updateSource | string | SECURITYDBO | RATINGS | UPDATE_SOURCE | 944 | VARCHAR2(255) | in_update_source | EagleML/referenceTransaction/rating/updateSource | ||
effectiveDate | Required | date | SECURITYDBO | RATINGS | EFFECTIVE_DATE | 1109 | DATE | in_effective_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 | |||||||
EagleML/referenceTransaction/rating/ | ||||||||||
ratingDataModel | EagleML/referenceTransaction/rating/ratingDataModel/ | |||||||||
Note
RatingDataModel Table
Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Eagle Database | Database Table | Database Field | Star Tag | Database Data Type | SP_Parameter | XPath |
|---|---|---|---|---|---|---|---|---|---|---|
alphaRating | Required | string | SECURITYDBO | RATINGS | ALPHA_RATING | 1671 | CHAR(8) | in_alpha_rating | EagleML/referenceTransaction/rating/ratingDataModel/alphaRating | |
numericalRating | decimal | SECURITYDBO | RATINGS | NUMERICAL_RATING | 1672 | NUMBER(28,12) | in_numerical_rating | EagleML/referenceTransaction/rating/ratingDataModel/numericalRating | ||
analystCode | string | SECURITYDBO | RATINGS | ANALYST_CODE | 1673 | CHAR(8) | in_analyst_code | EagleML/referenceTransaction/rating/ratingDataModel/analystCode | ||
reason | string | SECURITYDBO | RATINGS | REASON | 1674 | VARCHAR2(255), | in_reason | EagleML/referenceTransaction/rating/ratingDataModel/reason | ||
approvedBy | string | SECURITYDBO | RATINGS | APPROVED_BY | 1675 | CHAR(255) | in_approved_by | EagleML/referenceTransaction/rating/ratingDataModel/approvedBy | ||
submittedBy | string | SECURITYDBO | RATINGS | SUBMITTED_BY | 1676 | CHAR(255) | in_submitted_by | EagleML/referenceTransaction/rating/ratingDataModel/submittedBy | ||
ratingComments | string | SECURITYDBO | RATINGS | RATING_COMMENTS | 1677 | VARCHAR2(255) | in_rating_comments | EagleML/referenceTransaction/rating/ratingDataModel/ratingComments | ||
approvalComments | string | SECURITYDBO | RATINGS | APPROVAL_COMMENTS | 1678 | VARCHAR2(255) | in_approval_comments | EagleML/referenceTransaction/rating/ratingDataModel/approvalComments | ||
submittedDate | string | SECURITYDBO | RATINGS | SUBMITTED_DATE | 1679 | DATE | in_submitted_date | EagleML/referenceTransaction/rating/ratingDataModel/submittedDate | ||
ipoFlag | integer | SECURITYDBO | RATINGS | IPO_FLAG | 1680 | NUMBER | in_ipo_flag | EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag | ||
offeringPrice | decimal | SECURITYDBO | RATINGS | OFFERING_PRICE | 1681 | NUMBER(28,12) | in_offering_price | EagleML/referenceTransaction/rating/ratingDataModel/offeringPrice | ||
ipoVerifyFlag | integer | SECURITYDBO | RATINGS | IPO_VERIFY_FLAG | 1682 | NUMBER | in_ipo_verify_flag | EagleML/referenceTransaction/rating/ratingDataModel/ipoVerifyFlag | ||
provider | string | SECURITYDBO | RATINGS | PROVIDER | 1683 | CHAR(12) | in_provider | EagleML/referenceTransaction/rating/ratingDataModel/provider | ||
ratingCode | Required - Defaulted to "Source Name" by Panel | string | SECURITYDBO | RATINGS | RATING_CODE | 1165, 3639 | VARCHAR2(12) | in_rating_code | EagleML/referenceTransaction/rating/ratingDataModel/ratingCode | |
ratingTypeIndicator | string | SECURITYDBO | RATINGS | RATING_TYPE_INDICATOR | 3640 | VARCHAR2(20) | in_rating_type_indicator | EagleML/referenceTransaction/rating/ratingDataModel/ratingTypeIndicator | ||
program | string | SECURITYDBO | RATINGS | PROGRAM | 3641 | VARCHAR2(20) | in_program | EagleML/referenceTransaction/rating/ratingDataModel/program | ||
ratingEnhanc | string | SECURITYDBO | RATINGS | RATING_ENHANC | 3642 | VARCHAR2(12) | in_rating_enhanc | EagleML/referenceTransaction/rating/ratingDataModel/ratingEnhanc | ||
auditAlphaRating | string | SECURITYDBO | RATINGS | AUDIT_ALPHA_RATING | 3637 | VARCHAR2(8) | in_audit_alpha_rating | EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating | ||
auditDate | string | SECURITYDBO | RATINGS | AUDIT_DATE | 3638 | DATE | in_audit_date | EagleML/referenceTransaction/rating/ratingDataModel/auditDate | ||
ratingChar1 | string | SECURITYDBO | RATINGS | RATING_CHAR1 | 3649 | VARCHAR2(60) | in_rating_char1 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1 | ||
ratingChar2 | string | SECURITYDBO | RATINGS | RATING_CHAR2 | 3650 | VARCHAR2(60) | in_rating_char2 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2 | ||
ratingChar3 | string | SECURITYDBO | RATINGS | RATING_CHAR3 | 3651 | VARCHAR2(60) | in_rating_char3 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3 | ||
ratingChar4 | string | SECURITYDBO | RATINGS | RATING_CHAR4 | 3652 | VARCHAR2(60) | in_rating_char4 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4 | ||
ratingChar5 | string | SECURITYDBO | RATINGS | RATING_CHAR5 | 3653 | VARCHAR2(60) | in_rating_char5 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5 | ||
ratingChar6 | string | SECURITYDBO | RATINGS | RATING_CHAR6 | 3654 | VARCHAR2(60) | in_rating_char6 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6 | ||
ratingChar7 | string | SECURITYDBO | RATINGS | RATING_CHAR7 | 3655 | VARCHAR2(60) | in_rating_char7 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar7 | ||
ratingChar8 | string | SECURITYDBO | RATINGS | RATING_CHAR8 | 3656 | VARCHAR2(60) | in_rating_char8 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar8 | ||
ratingChar9 | string | SECURITYDBO | RATINGS | RATING_CHAR9 | 3657 | VARCHAR2(60) | in_rating_char9 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar9 | ||
ratingChar10 | string | SECURITYDBO | RATINGS | RATING_CHAR10 | 3658 | VARCHAR2(60) | in_rating_char10 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar10 | ||
ratingChar11 | string | SECURITYDBO | RATINGS | RATING_CHAR11 | 3823 | VARCHAR2(60) | in_rating_char11 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar11 | ||
ratingChar12 | string | SECURITYDBO | RATINGS | RATING_CHAR12 | 3824 | VARCHAR2(60) | in_rating_char12 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar12 | ||
ratingChar13 | string | SECURITYDBO | RATINGS | RATING_CHAR13 | 3825 | VARCHAR2(60) | in_rating_char13 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar13 | ||
ratingChar14 | string | SECURITYDBO | RATINGS | RATING_CHAR14 | 3826 | VARCHAR2(60) | in_rating_char14 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14 | ||
ratingChar15 | string | SECURITYDBO | RATINGS | RATING_CHAR15 | 3827 | VARCHAR2(60) | in_rating_char15 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15 | ||
ratingChar16 | string | SECURITYDBO | RATINGS | RATING_CHAR16 | 3828 | VARCHAR2(60) | in_rating_char16 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16 | ||
ratingChar17 | string | SECURITYDBO | RATINGS | RATING_CHAR17 | 3829 | VARCHAR2(60) | in_rating_char17 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17 | ||
ratingChar18 | string | SECURITYDBO | RATINGS | RATING_CHAR18 | 3830 | VARCHAR2(60) | in_rating_char18 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18 | ||
ratingChar19 | string | SECURITYDBO | RATINGS | RATING_CHAR19 | 3831 | VARCHAR2(60) | in_rating_char19 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19 | ||
ratingChar20 | string | SECURITYDBO | RATINGS | RATING_CHAR20 | 3832 | VARCHAR2(60) | in_rating_char20 | EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20 | ||
ratingDate1 | string | SECURITYDBO | RATINGS | RATING_DATE1 | 3643 | DATE | in_rating_date1 | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1 | ||
ratingDate2 | string | SECURITYDBO | RATINGS | RATING_DATE2 | 3644 | DATE | in_rating_date2 | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate2 | ||
ratingDate3 | string | SECURITYDBO | RATINGS | RATING_DATE3 | 3645 | DATE | in_rating_date3 | EagleML/referenceTransaction/rating/ratingDataModel/ratingDate3 | ||
ratingFloat1 | decimal | SECURITYDBO | RATINGS | RATING_FLOAT1 | 3646 | NUMBER(28,12) | in_rating_float1 | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat1 | ||
ratingFloat2 | decimal | SECURITYDBO | RATINGS | RATING_FLOAT2 | 3647 | NUMBER(28,12) | in_rating_float2 | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat2 | ||
ratingFloat3 | decimal | SECURITYDBO | RATINGS | RATING_FLOAT3 | 3648 | NUMBER(28,12) | in_rating_float3 | EagleML/referenceTransaction/rating/ratingDataModel/ratingFloat3 | ||
securityAlias | integer | SECURITYDBO | RATINGS | SECURITY_ALIAS | 10 | NUMBER | in_security_alias | EagleML/referenceTransaction/rating/ratingDataModel/securityAlias | ||
ratingSrc | string | SECURITYDBO | RATINGS | SRC_INTFC_INST | 1102 | NUMBER | in_rating_src | EagleML/referenceTransaction/rating/ratingDataModel/ratingSrc | ||
| sourceDescription | string | SECURITYDBO | RATINGS | EagleML/referenceTransaction/rating/ratingDataModel/sourceDescription |