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

TABLE: XTR.XTR_INTEREST_RATE_POLICY

Object Details
Object Name: XTR_INTEREST_RATE_POLICY
Object Type: TABLE
Owner: XTR
FND Design Data: TableXTR.XTR_INTEREST_RATE_POLICY
Subobject Name:
Status: VALID


XTR_INTEREST_RATE_POLICY contains the minimum and maximum percentage of your total funding or investments that can be associated with a fixed interest rate. Each row includes a currency, a fund/investment type, and the minimum and maximum percentage for funding or investments. A currency can have many interest rate policies. The PERIOD_BAND_REFERENCE column in this table is a concatenation of an investment types (either FUND or INVEST) and the currency for an interest rate policy.
This table corresponds to the Policy Details region of the Interest Rate Policies window.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XTR_INTEREST_RATE_POLICY_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnINVEST_FUND
ColumnCURRENCY
Columns
Name Datatype Length Mandatory Comments
CURRENCY VARCHAR2 (15) Yes Currency code
INVEST_FUND VARCHAR2 (6)
Flag indicates if the type is INVEST or FUND
MAXIMUM_FIXED NUMBER

Maximum percentage for the fixed rate
MINIMUM_FIXED NUMBER

Minimum percentage for the fixed rate
PERIOD_BAND_REFERENCE VARCHAR2 (20)
Concatenation of an investment type (INVEST or FUND) and currency code
POLICY_NAME VARCHAR2 (30)
Name of interest rate policy
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CURRENCY
,      INVEST_FUND
,      MAXIMUM_FIXED
,      MINIMUM_FIXED
,      PERIOD_BAND_REFERENCE
,      POLICY_NAME
FROM XTR.XTR_INTEREST_RATE_POLICY;

Dependencies

[top of page]

XTR.XTR_INTEREST_RATE_POLICY does not reference any database object

XTR.XTR_INTEREST_RATE_POLICY is referenced by following:

SchemaXTR
ViewXTR_INTEREST_RATE_POLICY#