DBA Data[Home] [Help] [Dependency Information]

TABLE: XTR.XTR_BOND_ISSUES

Object Details
Object Name: XTR_BOND_ISSUES
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.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.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_BOND_ISSUES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOND_ISSUE_CODE
Columns
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
Query Text

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;

Dependencies

[top of page]

XTR.XTR_BOND_ISSUES does not reference any database object

XTR.XTR_BOND_ISSUES is referenced by following:

SchemaAPPS
TriggerXTR_AU_BOND_ISSUES_T
SynonymXTR_BOND_ISSUES