...
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/ | ||||||||||||||||
...
| Info | ||
|---|---|---|
| ||
| 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. |
| Anchor | ||||
|---|---|---|---|---|
|
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 |