[Home] [Help] [Dependency Information]
Object Name: | XTR_BOND_ISSUES |
---|---|
Object Type: | TABLE |
Owner: | XTR |
FND Design Data: | XTR.XTR_BOND_ISSUES |
Subobject Name: | |
Status: | VALID |
XTR_BOND_ISSUES contains information about bond issues. Each row corresponds to a bond issue and contains all of the bond issue?s coupon dates. Coupon dates are automatically calculated using the previous and last coupon date as well as the coupon frequency. Every fixed income security deal you create must be associated with a bond issue from this table.
This table corresponds to the Bond Issues window.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XTR_BOND_ISSUES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | BOND_ISSUE_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AUDIT_INDICATOR | VARCHAR2 | (1) | Not currently used | |
AUTHORISED | VARCHAR2 | (1) | Yes | Flag to indicate if the bond issue is authorized for use (Y), or not (N) |
BOND_ISSUE_CODE | VARCHAR2 | (7) | Yes | User-defined identifier for the bond issue |
BOND_OR_DEBENTURE_ISSUE | VARCHAR2 | (1) | Not currently used | |
CALC_TYPE | VARCHAR2 | (15) | Coupon interest calculation type | |
COUPON_RATE | NUMBER | Coupon rate | ||
COUPON_TYPE | VARCHAR2 | (15) | Not currently used | |
CREATED_BY | VARCHAR2 | (30) | Yes | User who created this record |
CREATED_ON | DATE | Yes | Date this record was created | |
CURRENCY | VARCHAR2 | (15) | Yes | Currency code |
DESCRIPTION | VARCHAR2 | (35) | Bond issue description | |
FIRST_COUPON_DATE | DATE | First coupon date to calculate cashflows from | ||
ISSUER | VARCHAR2 | (7) | Yes | Bond issuer |
MATURITY_DATE | DATE | Yes | Date when the deal matures or when an action is required | |
NO_OF_COUPONS_PER_YEAR | NUMBER | Yes | Number of coupons per year for the bond issue | |
RIC_CODE | VARCHAR2 | (20) | Reference rate from current rates | |
RISK_GROUP | VARCHAR2 | (10) | Product type | |
UPDATED_BY | VARCHAR2 | (30) | User who last updated this record | |
UPDATED_ON | DATE | Date this record was last updated | ||
YEAR_BASIS | NUMBER | Yes | No longer used | |
YEAR_CALC_TYPE | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues | |
ACCRUED_INT_YEAR_CALC_BASIS | VARCHAR2 | (15) | Day count basis which defines the way in which interest accrues over time | |
FORCE_MONTH_END_COUPONS | VARCHAR2 | (1) | Flag to indicate if the coupon dates are to be forced to the last calendar date of the month (Y), or not (N) | |
COMMENCE_DATE | DATE | Start date of the bond issue (dated date is the market term) | ||
LAST_COUPON_DATE | DATE | Last coupon date of the bond issue | ||
SETTLEMENT_BASIS | VARCHAR2 | (2) | Method used to adjust coupon dates if they do not fall on a business day (valid values are Modified Following, Modified Previous (MP), Previous (P), and Null) | |
SECURITY_ID | VARCHAR2 | (15) | Bond issue unique identifier issued by the government (for example, CUSSIP) | |
PRICE_ROUNDING | NUMBER | Number of decimal places used for price calculation | ||
YIELD_ROUNDING | NUMBER | Number of decimal places used for yield calculation | ||
PRICE_ROUND_TYPE | VARCHAR2 | (2) | Flag to indicate whether price information should be rounded(R) or truncated(T) to the specified number of digits. | |
YIELD_ROUND_TYPE | VARCHAR2 | (2) | Flag to indicate whether yield information should be rounded(R) or truncated(T) to the specified number of digits. | |
CALC_ROUNDING | NUMBER | Number that specifies how many digits will be carried over during mid-step calculations. | ||
PRICING_MODEL | VARCHAR2 | (30) | Specifies the pricing model used by this deal. Derived from the CODE column of the XTR_PRICE_MODELS table. All deals will have a pricing model. | |
MARKET_DATA_SET | VARCHAR2 | (30) | Specifies the market data set used by the pricing model. | |
MARGIN | NUMBER | Specifies the margin for revaluation. This column is relevant for Bonds, Bond Options, Discounted Securities and Wholesale Term Money. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | For Descriptive Flexfield | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield | |
ROUNDING_TYPE | VARCHAR2 | (1) | Not currently used | |
DAY_COUNT_TYPE | VARCHAR2 | (1) | Not currently used | |
BENCHMARK_RATE | VARCHAR2 | (20) | Benchmark rate | |
FLOAT_MARGIN | NUMBER | Margin used for Floating Rate bond | ||
RATE_FIXING_DAY | NUMBER | Rate Fixing Day for Flaoting Rate Bond | ||
MATURE_SETTLEMENT_BASIS | VARCHAR2 | (2) | Business day convention for maturity dates | |
CALLABLE_FLAG | VARCHAR2 | (1) | Y/N flag to denote if bond issue is callable |
Cut, paste (and edit) the following text to query this object:
SELECT AUDIT_INDICATOR
, AUTHORISED
, BOND_ISSUE_CODE
, BOND_OR_DEBENTURE_ISSUE
, CALC_TYPE
, COUPON_RATE
, COUPON_TYPE
, CREATED_BY
, CREATED_ON
, CURRENCY
, DESCRIPTION
, FIRST_COUPON_DATE
, ISSUER
, MATURITY_DATE
, NO_OF_COUPONS_PER_YEAR
, RIC_CODE
, RISK_GROUP
, UPDATED_BY
, UPDATED_ON
, YEAR_BASIS
, YEAR_CALC_TYPE
, ACCRUED_INT_YEAR_CALC_BASIS
, FORCE_MONTH_END_COUPONS
, COMMENCE_DATE
, LAST_COUPON_DATE
, SETTLEMENT_BASIS
, SECURITY_ID
, PRICE_ROUNDING
, YIELD_ROUNDING
, PRICE_ROUND_TYPE
, YIELD_ROUND_TYPE
, CALC_ROUNDING
, PRICING_MODEL
, MARKET_DATA_SET
, MARGIN
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ROUNDING_TYPE
, DAY_COUNT_TYPE
, BENCHMARK_RATE
, FLOAT_MARGIN
, RATE_FIXING_DAY
, MATURE_SETTLEMENT_BASIS
, CALLABLE_FLAG
FROM XTR.XTR_BOND_ISSUES;
XTR.XTR_BOND_ISSUES does not reference any database object
XTR.XTR_BOND_ISSUES is referenced by following:
|
|
|