Time Series Data Map Table
- Natalie Gesin (Deactivated)
- Dmitry Donosiyan (Unlicensed)
Â
Element | Optional/Required | Value Type | Star Tag | SP Parameter | Eagle DB | DB Table | DB Field | Data Type | Xpath |
|---|---|---|---|---|---|---|---|---|---|
objectType | Optional | ObjectTypeEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/objectType | ||
objectId | Optional | ObjectId | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/objectId | ||
objectDescription | Optional | FeedTypeEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/objectDescription | ||
updateTimestamp | Optional | dateTime | Â | Â | Â | Â | Â | DATE | EagleML/referenceTransaction/timeSeries/updateTimestamp |
customElements | Not recommended | Complex type | Â | Â | reserved for customizations | Â | EagleML/referenceTransaction/timeSeries/customElements | ||
sourceName | Optional | string - involved in resolution logics | 1102 | in_short_desc | PACE_MASTERDBO | INTERFACES | short_desc | CHAR(15) | EagleML/referenceTransaction/timeSeries/sourceName |
updateSource | Optional | string | 944 | in_update_user | SECURITYDBO | STAR_SECURITY_TIME_SERIES | UPDATE_USER | VARCHAR2(32) | EagleML/referenceTransaction/timeSeries/updateSource |
effectiveDate | Optional | date | 1109 | in_effective_date | SECURITYDBO | STAR_SECURITY_TIME_SERIES | EFFECTIVE_DATE | DATE | EagleML/referenceTransaction/timeSeries/effectiveDate |
languageId | Optional | integer | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/languageId | ||
tagNochangecase | Optional | string | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/tagNochangecase | ||
preserveNull | Optional | string | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/preserveNull | ||
noLoadValidationFlag | Optional | YesNoOptionEnum | Â | Â | not stored in DB | Â | EagleML/referenceTransaction/timeSeries/noLoadValidationFlag | ||
| Asset Identifiers Model | EagleML/referenceTransaction/timeSeries/ | ||||||||
effectiveMatDate | Optional | date | 10273 | in_effective_mat_date | SECURITYDBO | STAR_SECURITY_TIME_SERIES | EFFECTIVE_MATURITY_DATE | DATE | EagleML/referenceTransaction/timeSeries/effectiveMatDate |
CurrentWAM | Optional | decimal | 1231 | in_current_wam | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CURRENT_WAM | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CurrentWAM |
CurrentWAC | Optional | decimal | 1227 | in_current_wac | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CURRENT_WAC | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CurrentWAC |
CurrentWALA | Optional | decimal | 3093 | in_current_wala | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CURRENT_WALA | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CurrentWALA |
CPR1Month | Optional | decimal | 1210 | in_cpr_1_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CPR_1_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CPR1Month |
CPR3Month | Optional | decimal | 1211 | in_cpr_3_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CPR_3_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CPR3Month |
CPR6Month | Optional | decimal | 1212 | in_cpr_6_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CPR_6_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CPR6Month |
CPR12Month | Optional | decimal | 1213 | in_cpr_12_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CPR_12_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CPR12Month |
CPRLife | Optional | decimal | 1206 | in_cpr_life | SECURITYDBO | STAR_SECURITY_TIME_SERIES | CPR_LIFE | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/CPRLife |
PSA1Month | Optional | decimal | 1218 | in_psa_1_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | PSA_1_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/PSA1Month |
PSA3Month | Optional | decimal | 1219 | in_psa_3_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | PSA_3_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/PSA3Month |
PSA6Month | Optional | decimal | 1220 | in_psa_6_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | PSA_6_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/PSA3Month |
PSA12Month | Optional | decimal | 1221 | in_psa_12_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | PSA_12_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/PSA12Month |
PSALife | Optional | decimal | 1573 | in_psa_life | SECURITYDBO | STAR_SECURITY_TIME_SERIES | PSA_LIFE | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/PSALife |
ABS1Month | Optional | decimal | 10311 | in_abs_1_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | ABS_1_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/ABS1Month |
ABS3Month | Optional | decimal | 10312 | in_abs_3_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | ABS_3_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/ABS3Month |
ABS6Month | Optional | decimal | 10313 | in_abs_6_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | ABS_6_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/ABS6Month |
ABS12Month | Optional | decimal | 10314 | in_abs_12_month | SECURITYDBO | STAR_SECURITY_TIME_SERIES | ABS_12_MONTH | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/ABS12Month |
ABSLife | Optional | decimal | 3053 | in_abs_life | SECURITYDBO | STAR_SECURITY_TIME_SERIES | ABS_LIFE | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/ABSLife |
SMM | Optional | decimal | 11418 | in_smm | SECURITYDBO | STAR_SECURITY_TIME_SERIES | SMM | NUMBER(38,12) | EagleML/referenceTransaction/timeSeries/SMM |
timeSeriesReleaseStatus | Optional | integer | 16163 | in_release_status | SECURITYDBO | STAR_SECURITY_TIME_SERIES | RELEASE_STATUS | VARCHAR2(1) | EagleML/referenceTransaction/timeSeries/timeSeriesReleaseStatus |