| Element | Required Inbound Acct Validation | Required Inbound Data Mgt | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field |
|---|
| 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 | 1102 | PACE_MASTERDBO | INTERFACES | SHORT_DESC |
| CHAR(15) |
| EagleML/referenceTransaction/rating/sourceName | |
| updateSource |
| string |
| 944 | in_update_source | SECURITYDBO | RATINGS | UPDATE_SOURCE |
| VARCHAR2(255) |
in_update_source
| EagleML/referenceTransaction/rating/updateSource | |||
| effectiveDate | Required | date |
| 1109 | in_effective_date | SECURITYDBO | RATINGS | EFFECTIVE_DATE |
| 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 | ||||||||||
| Asset Identifiers Model | EagleML/referenceTransaction/rating/ | |||||||||
| ratingDataModel | RatingDataModel - Complex type (see the table below) | EagleML/referenceTransaction/rating/ratingDataModel/ | ||||||||
| |||||||||||
...
...
| |||||||||||
...
| ||||||||||||
...
| |||||||||||||
...
| |||||||||||||
| alphaRating | Required |
Value Type
Eagle Database
Database Table
Database Field
Star Tag
Database Data Type
SP_Parameter
XPath
alphaRating
string
| string | 1671 | in_alpha_rating | SECURITYDBO | RATINGS | ALPHA_RATING |
1671
| 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) |
in_analyst_code
| 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 |
in_submitted_date
| EagleML/referenceTransaction/rating/ratingDataModel/submittedDate |
| ipoFlag |
| integer |
| 1680 | in_ipo_flag | SECURITYDBO | RATINGS | IPO_FLAG |
| NUMBER |
in_ipo_flag
| EagleML/referenceTransaction/rating/ratingDataModel/ipoFlag |
| offeringPrice |
| decimal |
| 1681 | in_offering_price | SECURITYDBO | RATINGS | OFFERING_PRICE |
1681
| NUMBER(28,12) |
in_offering_price
| 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 |
1683
| CHAR(12) |
in_provider
| EagleML/referenceTransaction/rating/ratingDataModel/provider | |||
| ratingCode | Required - Defaulted to "Source Name" by Panel | string |
| 1165, 3639 | in_rating_code | SECURITYDBO | RATINGS | RATING_CODE |
1165, 3639
| VARCHAR2(12) |
in_rating_code
| 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) |
in_audit_alpha_rating
| EagleML/referenceTransaction/rating/ratingDataModel/auditAlphaRating |
| auditDate |
| string |
| 3638 | in_audit_date | SECURITYDBO | RATINGS | AUDIT_DATE |
3638
| DATE |
| EagleML/referenceTransaction/rating/ratingDataModel/auditDate | |
| ratingChar1 |
| string |
| 3649 | in_rating_char1 | SECURITYDBO | RATINGS | RATING_CHAR1 |
3649
| VARCHAR2(60) |
in_rating_char1
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar1 |
| ratingChar2 |
| string |
| 3650 | in_rating_char2 | SECURITYDBO | RATINGS | RATING_CHAR2 |
3650
| VARCHAR2(60) |
in_rating_char2
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar2 |
| ratingChar3 |
| string |
| 3651 | in_rating_char3 | SECURITYDBO | RATINGS | RATING_CHAR3 |
3651
| VARCHAR2(60) |
in_rating_char3
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar3 |
| ratingChar4 |
| string |
| 3652 | in_rating_char4 | SECURITYDBO | RATINGS | RATING_CHAR4 |
3652
| VARCHAR2(60) |
in_rating_char4
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar4 |
| ratingChar5 |
| string |
| 3653 | in_rating_char5 | SECURITYDBO | RATINGS | RATING_CHAR5 |
3653
| VARCHAR2(60) |
in_rating_char5
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar5 |
| ratingChar6 |
| string |
| 3654 | in_rating_char6 | SECURITYDBO | RATINGS | RATING_CHAR6 |
| VARCHAR2(60) |
in_rating_char6
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar6 |
| ratingChar7 |
| string |
| 3655 | in_rating_char7 | SECURITYDBO | RATINGS | RATING_CHAR7 |
| VARCHAR2(60) |
in_rating_char7
| 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) |
in_rating_char12
| 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) |
in_rating_char14
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar14 |
| ratingChar15 |
| string |
| 3827 | in_rating_char15 | SECURITYDBO | RATINGS | RATING_CHAR15 |
3827
| VARCHAR2(60) |
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar15 | |
| ratingChar16 |
| string |
| 3828 | in_rating_char16 | SECURITYDBO | RATINGS | RATING_CHAR16 |
3828
| VARCHAR2(60) |
in_rating_char16
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar16 |
| ratingChar17 |
| string |
| 3829 | in_rating_char17 | SECURITYDBO | RATINGS | RATING_CHAR17 |
3829
| VARCHAR2(60) |
in_rating_char17
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar17 |
| ratingChar18 |
| string |
| 3830 | in_rating_char18 | SECURITYDBO | RATINGS | RATING_CHAR18 |
3830
| VARCHAR2(60) |
in_rating_char18
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar18 |
| ratingChar19 |
| string |
| 3831 | in_rating_char19 | SECURITYDBO | RATINGS | RATING_CHAR19 |
3831
| VARCHAR2(60) |
in_rating_char19
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar19 |
| ratingChar20 |
| string |
| 3832 | in_rating_char20 | SECURITYDBO | RATINGS | RATING_CHAR20 |
3832
| VARCHAR2(60) |
in_rating_char20
| EagleML/referenceTransaction/rating/ratingDataModel/ratingChar20 |
| ratingDate1 |
| string |
| 3643 | in_rating_date1 | SECURITYDBO | RATINGS | RATING_DATE1 |
| DATE |
in_rating_date1
| EagleML/referenceTransaction/rating/ratingDataModel/ratingDate1 |
| ratingDate2 |
| string |
| 3644 | in_rating_date2 | SECURITYDBO | RATINGS | RATING_DATE2 |
| DATE |
in_rating_date2
| 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 |
in_security_alias
| EagleML/referenceTransaction/rating/ratingDataModel/securityAlias |
| ratingSrc |
| string |
string
SECURITYDBO
RATINGS
SRC_INTFC_INST
1102
NUMBER
| 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 |