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

TABLE: FEM.FEM_CONSUMER_LOANS_T

Object Details
Object Name: FEM_CONSUMER_LOANS_T
Object Type: TABLE
Owner: FEM
Subobject Name:
Status: VALID


FEM_CONSUMER_LOANS_T is an interface table for loading and updating Analytic Consumer Loans data into the FEM_CONSUMER_LOANS table using the Detail Client Data Loader. With the exception of the information required for the Calendar Period dimension as well as the STATUS column, each column on the interface table maps to a column in the destination table. The mapping between the columns on the interface table and the destination table is stored as Table Registration metadata. Users can go to the Table Registration user interface to view and update the column mapping metadata. Most columns that have a one-to-one mapping between the interface and destination tables share the same column name. If the interface table column maps to a destination table column with a different name, then the column most likely represents a dimension that has both a user-defined non-translatable alphanumeric identifier (or "Display Code") and a system generated numeric identifier (or "ID") for its members. Users should always populate the interface table column with the dimension "Display Code" value. The Detail Client Data Loader transforms the member values in the interface table into the correct internal numeric identifiers for each member. For example, LEDGER_DISPLAY_CODE and LEDGER_ID are columns that represent the Ledger dimension on the interface table and destination table, respectively. Users just need to populate the LEDGER_DISPLAY_CODE with the "Display Code" value. The data loader transforms the "Display Code" value into an internal numeric identifier before storing into the LEDGER_ID column on the destination table.
As noted above, members for the Calendar Period dimension are not identified in this manner. Rather, they are identified by a combination of the following information:
Level (CALP_DIM_GRP_DISPLAY_CODE), End Date (CAL_PERIOD_END_DATE), and Period Number (CAL_PERIOD_NUMBER). The loader also uses the Ledger (LEDGER_DISPLAY_CODE) to identify the Calendar to be used to verify the existence of all of the Calendar Period members in the load.
Scope: public
Product: FEM
Lifecycle: active
Display Name: Analytic Consumer Loans Data
Category: BUSINESS_ENTITY FEM_FACT_REPOSITORY


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CONSUMER_LOANS_T_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCALP_DIM_GRP_DISPLAY_CODE
ColumnCAL_PERIOD_NUMBER
ColumnCAL_PERIOD_END_DATE
ColumnDATASET_DISPLAY_CODE
ColumnSOURCE_SYSTEM_DISPLAY_CODE
ColumnID_NUMBER
Columns
Name Datatype Length Mandatory Comments
STATUS VARCHAR2 (60) Yes Designates the Status of the row for loading. Records with a STATUS of "LOAD" will be loaded by the Source Data Loader. All other STATUS codes designate some sort of error from the load. The user (translated) text description can be found in FND Messages using this error status code as the Message Name.
CALP_DIM_GRP_DISPLAY_CODE VARCHAR2 (150) Yes Calendar Period Dimension Group
CAL_PERIOD_NUMBER NUMBER (15) Yes Calendar Period Number. Provides alternate identification for the Calendar Period, together with Ledger ID, Calendar Period End Date, and Calendar Period Dimension Group Name.
CAL_PERIOD_END_DATE DATE
Yes The end date of the calendar period
DATASET_DISPLAY_CODE VARCHAR2 (150) Yes Dataset Code
SOURCE_SYSTEM_DISPLAY_CODE VARCHAR2 (150) Yes Source System
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
LEDGER_DISPLAY_CODE VARCHAR2 (150) Yes Ledger
ACC_HEALTH_INS_FLG VARCHAR2 (30)
Y designates that the account has accident and health insurance
AUTOPAY_FLG VARCHAR2 (30)
Y designates that the account is on autopay
CREDIT_LIFE_INS_FLG VARCHAR2 (30)
Y designates that the account has credit life insurance
EMBEDDED_OPTIONS_FLG VARCHAR2 (30)
Embedded Options Flag; Y means this account has one or related rows in the EMBEDDED_OPTIONS table.
JOINT_ACCOUNT_FLG VARCHAR2 (30)
Y designates that the account is joint-owned
OPEN_ACCOUNT_FLG VARCHAR2 (30)
Identifies that the account is open
PARTICIPATION_FLG VARCHAR2 (30)
Y designates that the account is participated
STUDENT_STATUS_FLG VARCHAR2 (30)
Y designates that the student is enrolled in a school
VIP_ACCOUNT_FLG VARCHAR2 (30)
Y designates that the account belongs to a privileged customer
ACCIDENT_HEALTH_PREMIUM NUMBER

The account''s accident and health insurance premium
ACCID_HEALTH_INS_CO_CODE VARCHAR2 (30)
An organization-defined code for the account''s accident and health insurance company
ACCOUNT_CLOSE_DATE DATE

Account Close Date
ACCOUNT_CONTRIB NUMBER

The current net profit contribution for the account
ACCOUNT_CONTRIB_AFTER_TAX NUMBER

Account Contribution After Tax
ACCOUNT_NUMBER VARCHAR2 (50)
The account number
ACCOUNT_OFFICER VARCHAR2 (50)
The primary officer responsible for this account.
ACCRUAL_BASIS_DISPLAY_CODE VARCHAR2 (150)
Basis on which interest accrual is calculated. Suggested defaults: 1=30/360 for amortizing transactions OR 3=Act/Act. for nonamort.
ACCRUED_INTEREST NUMBER

The interest accrued on the account
ACTUAL_HOLDING_PERIOD NUMBER (5)
Actual number of days bank holds certain financial transactions. Used in haircut calculation.
ACT_DAYS_REPR NUMBER (6)
Actual Days between remargining/repricing. Used in haircut calculation.
ADJUSTABLE_TYPE_CODE NUMBER

Frequency or method by which the coupon or rate is adjusted.
ALLOCATED_EQUITY NUMBER

Allocated equity; typically average balance * product-specific rate
ALLOC_CAP_E NUMBER

Minimum allocated capital in entered currency
ALLOC_CAP_F NUMBER

Minimum allocated capital denominated in Functional currency.
AMRT_TERM NUMBER

Term upon which amortization is based - units specified by Amrt_term_mult.
AMRT_TERM_MULT VARCHAR2 (30)
Units (days or months or years) in which Amrt_Term is specified.
AMRT_TYPE_CODE NUMBER

Method of amortizing principal and interest.
ATM_EXP NUMBER

Automated Teller Machine expense; typically based on number of Automated Teller Machine transactions * unit cost
AUTOPAY_ACCT_NUMBER VARCHAR2 (50)
The account number where autopay debits from the account should be charged
AUTOPAY_BANK_TRANSIT_NBR VARCHAR2 (50)
The routing transit number of the organization where autopay debits will be charged
AUTOPAY_INSTRTYPE_DISPLAY_CODE VARCHAR2 (150)
The autopay service that autopay debits will be charged against, for example Checking
AVG_BOOK_BAL NUMBER

Average gross book balance for latest month.
AVG_NET_BOOK_BAL NUMBER

Average book balance - net of participations - for latest month.
BANK_DISPLAY_CODE VARCHAR2 (150)
The bank which owns the transaction.
BRANCH_CODE VARCHAR2 (30)
The branch where the account currently resides.
BRANCH_PLATFORM_EXP NUMBER

Fixed cost per product or # of transactions * unit cost
BRANCH_TELLER_EXP NUMBER

Branch Teller Expense: typically based on the number of teller transactions * unit cost
CALL_CENTER_EXP NUMBER

Call center expense; typically based on number of calls * unit cost
CHANNEL_DISPLAY_CODE VARCHAR2 (150)
Channel
COLLATERAL_DISPLAY_CODE VARCHAR2 (150)
Type of property assigned as collateral to secure loan.
CCTR_ORG_DISPLAY_CODE VARCHAR2 (150)
Company Cost Center Organization
COMPOUND_BASIS_CODE NUMBER

Frequency by which interest is compounded.
CONTRACT_AMT NUMBER

The amount loaned to the account according to the contract
CONTRIB_AFTER_CAPITAL_CHG NUMBER

Contribution after capital charge; typically Account Contribution - Allocated Equity * hurdle rate
CREDIT_LIFE_INS_CO_CODE VARCHAR2 (30)
An organization-defined code for the account''s credit life insurance company
CREDIT_LIFE_INS_PREM NUMBER

The account''s credit life insurance premium
CREDIT_SCORE NUMBER

Credit score of borrower on original application
CREDIT_STATUS_DISPLAY_CODE VARCHAR2 (150)
Current performance status of the loan.
CURRENT_FEES NUMBER

The amount of fees charged to the account
CUR_BOOK_BAL NUMBER

Current gross book balance.
CUR_GROSS_RATE NUMBER

Current rate on the instrument.(i.e. owned by the customer).
CUR_NET_BOOK_BAL NUMBER

Current book balance- net of participations.
CUR_NET_PAR_BAL NUMBER

Current par value- net of participations.
CUR_NET_RATE NUMBER

Current nominal interest rate on instrument owed to or paid by the financial institution.
CUR_OAS NUMBER

Option Adjusted Spread, as calculated from the as-of-date.
CUR_PAR_BAL NUMBER

Current gross par value.
CUR_PAYMENT NUMBER

Periodic principal and interest payment associated with gross balance. Principal portion only for level principal amort. type.
CUR_STATIC_SPREAD NUMBER

Static spread, as calculated from the as-of date.
CUR_TP_PER_ADB NUMBER

Average Daily Balance for Current Transfer Pricing Repricing Period - used in selected Transfer Pricing methods - with Mid-Period Repricing option.
CUR_YIELD NUMBER

Effective annual yield based on book value.
CUSTOMER_DISPLAY_CODE VARCHAR2 (150)
Unique numeric identifier of the Customer
DATA_PROCESSING_EXP NUMBER

Data processing expense; typically based on number of transactions * unit cost
DEALER_NBR VARCHAR2 (50)
Dealer number assigned for indirect loans.
DEALER_RES_ORG NUMBER

Original dealer reserve balance on indirect loans.
DEALER_RES_UNEARN NUMBER

Current unearned portion of the dealer reserve.
DEFERRED_CUR_BAL NUMBER

Current Unamortized Deferred Balance associated with Instrument (i.e. Premium or Discount or Fees or etc...).
DEFERRED_ORG_BAL NUMBER

Original Deferred Balance associated with Instrument (i.e. Premium or Discount or Fees or etc...).
DEL_CUR_DAYS NUMBER

Number of days the account is currently delinquent ( number of days past grace period ) .
DEL_LIFE_TIMES NUMBER

Number of times the account has been delinquent during life.
DEL_YEAR_TIMES NUMBER

Number of times the account has been delinquent during the past 12 months.
DIRECT_IND_DISPLAY_CODE VARCHAR2 (150)
Classification of direct and indirect loans.
ELECTRONIC_BANKING_EXP NUMBER

Electronic banking expense; typically based on number of electronic transactions * unit cost
EQUITY_CREDIT NUMBER

Equity credit for the account; typically Allocated Equity * equity credit rate
EXIST_BORROWER_DISPLAY_CODE VARCHAR2 (150)
Code indicating whether student loan borrower has other exisiting student loans.
EXPECTED_GRAD_DATE DATE

Expected date of graduation for student loan customer.
FIRST_DISBURS_DATE DATE

Date on which first funds were disbursed to student.
GEOGRAPHY_DISPLAY_CODE VARCHAR2 (150)
Geography
GROSS_FEE_INCOME NUMBER

Sum of fee income components (before waivers)
HEDGE_PORTFOLIO_SET NUMBER

Identifies the portfolio being hedged.
HISTORIC_OAS NUMBER

Historic Option Adjusted Spread
HISTORIC_STATIC_SPREAD NUMBER

Static spread, as calculated from the origination date.
INITIAL_DIRCT_COST NUMBER

Unamortized initial direct costs under Financial Account Standards Board 91 for a lease ( e.g. setup cost and broker fee).
INSTRUMENT_TYPE_CODE NUMBER

Instrument category (record type).
INTEREST_INC_EXP NUMBER

Interest income/expense; typically average balance * interest rate
INTEREST_RATE_CODE NUMBER

Index to which interest rate is contractually tied.
INT_TYPE_CODE NUMBER

Timing of Interest Payment.
INVESTOR_NBR VARCHAR2 (50)
Investor number for sold or participated accounts.
ISSUE_DATE DATE

Date on which the instrument was issued by the origination institution. For rolled instruments the date last rolled.
ITEM_PROCESSING_EXP NUMBER

Item Processing Expense; typically a set expense for the type or item
LAST_PAYMENT_DATE DATE

Date of Payment Immediately Prior to As of Date.
LAST_REPRICE_DATE DATE

Date upon which adjustable instruments last repriced.
LINE_ITEM_DISPLAY_CODE VARCHAR2 (150)
Line Item
LOAN_APPROVE_DATE DATE

Date on which the loan was approved.
LOAN_LOSS_PROVISION NUMBER

Loan loss provision for the account; typically average balance * product-specific rate
LOAN_LOSS_RESERVE NUMBER

Loan Loss Reserve for the account; typically average balance * product specific rate
LRD_BALANCE NUMBER

Par Balance as of the Last Repricing Date, used in Transfer Pricing Cash Flow Methods.
MARGIN NUMBER

Contractual spread above or below pricing index
MARGIN_GROSS NUMBER

Contractual spread above or below pricing index applied to CUR_GROSS_RATE
MARGIN_T_RATE NUMBER

Margin Transfer Rate
MARKET_SEGMENT_DISPLAY_CODE VARCHAR2 (150)
Specific market segment of borrower.
MARKET_VALUE NUMBER

Calculated market value price (i.e. 100 x market value / current net par balance).
MATCHED_SPREAD NUMBER

Interest margin on product. For assets = Current net rate - Transfer rate OR Liabilities = Transfer rate - Current net Rate.
MATURITY_DATE DATE

Original contractual specified maturity date of instrument.
NATURAL_ACCOUNT_DISPLAY_CODE VARCHAR2 (150)
Natural Account
NEG_AMRT_AMT NUMBER

Total amount of principal increase due to negative amortization.
NEG_AMRT_EQ_DATE DATE

Date at which current payment necessary to fully amortize the instrument will be re-computed.
NEG_AMRT_EQ_FREQ NUMBER

Frequency at which current payment necessary to fully amortize the instrument is re-computed.
NEG_AMRT_EQ_MULT VARCHAR2 (30)
Units (days or months or years) of Neg_amrt_eq_freq.
NEG_AMRT_LIMIT NUMBER

Maximum negative amortization allowed as a percentage of the original balance
NET_FEE_INCOME NUMBER

Gross Fee Income - Waived Fees
NET_INT_MARGIN NUMBER

Net interest margin; typically Transfer Charge/Credit + Interest Income/Expense - Loan Loss Provision
NET_MARGIN_CODE NUMBER

Defines relationship between CUR_GROSS_RATE and CUR_NET_RATE for Risk Manager processing
NEXT_PAYMENT_DATE DATE

Date upon which the next scheduled payment is due.
NEXT_REPRICE_DATE DATE

Date upon which adjustable instuments will next reprice.
OPTION_COST NUMBER

Option Cost
ORG_BOOK_BAL NUMBER

Gross book balance at date of origination. Rule of 78s should exclude add on interest.
ORG_INTEREST_AMT NUMBER

Total interest unearned at origination of loan.
ORG_LOAN_TO_VALUE NUMBER

Original balance as % of the appraised value of collateral.
ORG_MARKET_VALUE NUMBER

Market Value as of originaton date.
ORG_NET_BOOK_BAL NUMBER

Book value - net of participations, at date of origination
ORG_NET_PAR_BAL NUMBER

Par value - net of participations, at date of of origination
ORG_PAR_BAL NUMBER

Gross par value at date of purchase. Rule of 78s should exclude add on interest.
ORG_PAYMENT_AMT NUMBER

Original payment amount.
ORG_RATE NUMBER

Contractual interest rate at origination date.
ORG_TERM NUMBER

Contractual term at origination date
ORG_TERM_MULT VARCHAR2 (30)
Units (days or months or years) of Org_term.
ORIGINATION_DATE DATE

Date the current institution originated or acquired the instrument. For rolled instruments the greater of date last rolled or date acquired.
OTHER_ACCOUNT_EXP NUMBER

Additional expenses applied to the account
OTHER_PROCESSING_EXP NUMBER

Additional processing expenses applied to the account
PARTICIPATION_AMT_SOLD NUMBER

The amount participated for the account
PERCENT_SOLD NUMBER

Total percent of balance sold to investors.
PLEDGED_STATUS_DISPLAY_CODE VARCHAR2 (150)
Code identifying whether and to whom the security is pledged.
PMT_ADJUST_DATE DATE

Date of next payment adjustment on an adjustable rate instrument.
PMT_CHG_FREQ NUMBER

The frequency at which the payment adjusts.
PMT_CHG_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Pmt_chg_freq.
PMT_DECR_CYCLE NUMBER

Maximum payment decrease allowed during a repricing cycle of an adjustable rate instrument.
PMT_DECR_LIFE NUMBER

Maximum payment decrease allowed during life of an adjustable rate instrument.
PMT_FREQ NUMBER

Frequency of payment (Principal and Interest, Interest or Principal).
PMT_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Pmt_freq.
PMT_INCR_CYCLE NUMBER

Maximum payment increase allowed during a repricing cycle on an adjustable rate instrument.
PMT_INCR_LIFE NUMBER

Maximum payment increase allowed during the life of an adjustable rate instrument.
PMT_TYPE_DISPLAY_CODE VARCHAR2 (150)
The payment method for the account, for example check or autopay
PRIOR_TP_PER_ADB NUMBER

Average Daily Balance for Prior Transfer Pricing Repricing Period - used in selected Transfer Pricing methods - with Mid-Period Repricing
PRODUCT_DISPLAY_CODE VARCHAR2 (150)
Product
PRODUCT_TYPE_DISPLAY_CODE VARCHAR2 (150)
The specific type of product given an instrument type.
PURPOSE_DISPLAY_CODE VARCHAR2 (150)
Purpose for which the loan was made.
RATE_CAP_LIFE NUMBER

Maximum rate allowed during life of the instrument.
RATE_CHG_MIN NUMBER

Minimum change in repricing index necessary for a change in the interest rate.
RATE_CHG_RND_CODE NUMBER

Factor to which the rate change on an adjustable instrument is rounded.
RATE_CHG_RND_FAC NUMBER

Method used for rounding of interest rate change.
RATE_DECR_CYCLE NUMBER

Maximum amount rate can decrease during the repricing cycle of an adjustable rate instrument.
RATE_DECR_YEAR NUMBER

Maximum rate decrease allowed on an adjustable product per year.
RATE_FLOOR_LIFE NUMBER

Minimum rate for life of the instrument.
RATE_INCR_CYCLE NUMBER

Maximum interest rate increase allowed during the cycle on an adjustable rate instrument.
RATE_INCR_YEAR NUMBER

Maximum interest rate increase allowed during a year for an adjustable rate instrument.
RATE_SET_LAG NUMBER

Period by which the interest re-calculation lags the date of the interest rate used for calculation.
RATE_SET_LAG_MULT VARCHAR2 (30)
Units (days or months or years) of Rate_set_lag.
REASON_CLOSED_CODE VARCHAR2 (30)
Indicates the reason the customer gave for closing the account
RECORD_COUNT NUMBER

The number of source transaction records represented by each record.
REMAIN_NO_PMTS NUMBER

Remaining Number of Payments.
REMAIN_TERM NUMBER

Period until the instrument matures.
REMAIN_TERM_MULT VARCHAR2 (30)
Units (days or months or years) of Remain_term_c.
REPRICE_FREQ NUMBER

Contractual frequency of rate adjustment.
REPRICE_FREQ_MULT VARCHAR2 (30)
Units (days or months or years) of Reprice_freq.
RESERVE_CHARGE_CREDIT NUMBER

Charge or credit for funds based on the loan loss reserve balance
RESIDUAL_AMOUNT NUMBER

Anticipated value of asset at expiration of lease term.
RETAIL_EXP NUMBER

Retail operations expense; typically a fixed cost per product or number of transactions * unit cost
RETURN_ITEMS NUMBER

Number of return items
RETURN_ON_EQUITY NUMBER

Return on equity for the account; typically Account Contribution / Allocated Equity (annualized by 12)
RWA_E NUMBER

Calculated value of Risk Weighted Asset in entered Currency
RWA_F NUMBER

Risk Weighted Average calculated and converted to the Functional Currency
SCHOOL_ID_CODE VARCHAR2 (30)
Department of Education code for last school attended.
SPECIFIC_PROVISION NUMBER

Provision expense specifically allocated for a given asset.
STUDENT_YR_IN_SCHOOL_CODE VARCHAR2 (30)
Organization-defined code for the student''s year in school, for example F, S, or J
TAX_EXEMPT_PCT NUMBER

Percent of interest that is tax exempt.
TAX_EXP NUMBER

Tax Expense
TEASER_END_DATE DATE

Termination date of rate tease period.
TOTAL_ACCOUNT_EXP NUMBER

Sum of all account expenses
TOTAL_DISTRIBUTION_EXP NUMBER

Sum of distribution related expenses for the account
TOTAL_FEES NUMBER

The total fees for the current Update period
TOTAL_FEES_AT_ORG NUMBER

Fees charged at origination of the loan.
TOTAL_PROCESS_EXP NUMBER

Sum of Data Processing, Item Processing, Retail Operations, Deposit Insurance and Other Processing expenses
TOTAL_TRANSACTIONS NUMBER

Total number of account transactions
TRANSFER_CHARGE_CREDIT NUMBER

Transfer Charge Credit
TRANSFER_RATE NUMBER

The associated transfer rate for the account.
TRAN_RATE_REM_TERM NUMBER

The associated remaining term transfer rate for the account.
T_RATE_INT_RATE_CODE NUMBER

Transfer Rate Interest Rate Code.
USER_DIM10_DISPLAY_CODE VARCHAR2 (150)
User Dimension10
USER_DIM1_DISPLAY_CODE VARCHAR2 (150)
User Dimension1
USER_DIM2_DISPLAY_CODE VARCHAR2 (150)
User Dimension2
USER_DIM3_DISPLAY_CODE VARCHAR2 (150)
User Dimension3
USER_DIM4_DISPLAY_CODE VARCHAR2 (150)
User Dimension4
USER_DIM5_DISPLAY_CODE VARCHAR2 (150)
User Dimension5
USER_DIM6_DISPLAY_CODE VARCHAR2 (150)
User Dimension6
USER_DIM7_DISPLAY_CODE VARCHAR2 (150)
User Dimension7
USER_DIM8_DISPLAY_CODE VARCHAR2 (150)
User Dimension8
USER_DIM9_DISPLAY_CODE VARCHAR2 (150)
User Dimension9
WAIVED_FEES NUMBER

Sum of fee income waiver components
ALPHANUMERIC_MEASURE01 VARCHAR2 (4000)
Alphanumeric Measure1
ALPHANUMERIC_MEASURE02 VARCHAR2 (4000)
Alphanumeric Measure2
ALPHANUMERIC_MEASURE03 VARCHAR2 (4000)
Alphanumeric Measure3
ALPHANUMERIC_MEASURE04 VARCHAR2 (4000)
Alphanumeric Measure4
ALPHANUMERIC_MEASURE05 VARCHAR2 (4000)
Alphanumeric Measure5
ALPHANUMERIC_MEASURE06 VARCHAR2 (4000)
Alphanumeric Measure6
ALPHANUMERIC_MEASURE07 VARCHAR2 (4000)
Alphanumeric Measure7
ALPHANUMERIC_MEASURE08 VARCHAR2 (4000)
Alphanumeric Measure8
ALPHANUMERIC_MEASURE09 VARCHAR2 (4000)
Alphanumeric Measure9
ALPHANUMERIC_MEASURE10 VARCHAR2 (4000)
Alphanumeric Measure10
DATE_MEASURE01 DATE

Date Measure1
DATE_MEASURE02 DATE

Date Measure2
DATE_MEASURE03 DATE

Date Measure3
DATE_MEASURE04 DATE

Date Measure4
DATE_MEASURE05 DATE

Date Measure5
DATE_MEASURE06 DATE

Date Measure6
DATE_MEASURE07 DATE

Date Measure7
DATE_MEASURE08 DATE

Date Measure8
DATE_MEASURE09 DATE

Date Measure9
DATE_MEASURE10 DATE

Date Measure10
DEFAULT_EST_LOSS NUMBER

Percentage value derived by users, which determines the estimated loss for an asset in default
DEFAULT_FLAG VARCHAR2 (30)
Default Flag indicates whether or not an asset is in default
DFLT_LGD_ACTUAL NUMBER

Actual Loss Given Default value for an asset is in default
NUMERIC_MEASURE01 NUMBER

Numeric Measure1
NUMERIC_MEASURE02 NUMBER

Numeric Measure2
NUMERIC_MEASURE03 NUMBER

Numeric Measure3
NUMERIC_MEASURE04 NUMBER

Numeric Measure4
NUMERIC_MEASURE05 NUMBER

Numeric Measure5
NUMERIC_MEASURE06 NUMBER

Numeric Measure6
NUMERIC_MEASURE07 NUMBER

Numeric Measure7
NUMERIC_MEASURE08 NUMBER

Numeric Measure8
NUMERIC_MEASURE09 NUMBER

Numeric Measure9
NUMERIC_MEASURE10 NUMBER

Numeric Measure10
SPECIFIC_PROVISION_CHARGE NUMBER

The charge to the Account Specific Provision for the given Calendar Period
CREDIT_SCORE_DATE DATE

Credit Score Date
LIQUIDITY_PREMIUM_RATE NUMBER

LIQUIDITY_PREMIUM_AMT NUMBER

BASIS_RISK_COST_RATE NUMBER

BASIS_RISK_COST_AMT NUMBER

PRICING_INCENTIVE_RATE NUMBER

PRICING_INCENTIVE_AMT NUMBER

OTHER_ADJUSTMENTS_RATE NUMBER

OTHER_ADJUSTMENTS_AMT NUMBER

Query Text

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


SELECT STATUS
,      CALP_DIM_GRP_DISPLAY_CODE
,      CAL_PERIOD_NUMBER
,      CAL_PERIOD_END_DATE
,      DATASET_DISPLAY_CODE
,      SOURCE_SYSTEM_DISPLAY_CODE
,      ID_NUMBER
,      CURRENCY_CODE
,      LEDGER_DISPLAY_CODE
,      ACC_HEALTH_INS_FLG
,      AUTOPAY_FLG
,      CREDIT_LIFE_INS_FLG
,      EMBEDDED_OPTIONS_FLG
,      JOINT_ACCOUNT_FLG
,      OPEN_ACCOUNT_FLG
,      PARTICIPATION_FLG
,      STUDENT_STATUS_FLG
,      VIP_ACCOUNT_FLG
,      ACCIDENT_HEALTH_PREMIUM
,      ACCID_HEALTH_INS_CO_CODE
,      ACCOUNT_CLOSE_DATE
,      ACCOUNT_CONTRIB
,      ACCOUNT_CONTRIB_AFTER_TAX
,      ACCOUNT_NUMBER
,      ACCOUNT_OFFICER
,      ACCRUAL_BASIS_DISPLAY_CODE
,      ACCRUED_INTEREST
,      ACTUAL_HOLDING_PERIOD
,      ACT_DAYS_REPR
,      ADJUSTABLE_TYPE_CODE
,      ALLOCATED_EQUITY
,      ALLOC_CAP_E
,      ALLOC_CAP_F
,      AMRT_TERM
,      AMRT_TERM_MULT
,      AMRT_TYPE_CODE
,      ATM_EXP
,      AUTOPAY_ACCT_NUMBER
,      AUTOPAY_BANK_TRANSIT_NBR
,      AUTOPAY_INSTRTYPE_DISPLAY_CODE
,      AVG_BOOK_BAL
,      AVG_NET_BOOK_BAL
,      BANK_DISPLAY_CODE
,      BRANCH_CODE
,      BRANCH_PLATFORM_EXP
,      BRANCH_TELLER_EXP
,      CALL_CENTER_EXP
,      CHANNEL_DISPLAY_CODE
,      COLLATERAL_DISPLAY_CODE
,      CCTR_ORG_DISPLAY_CODE
,      COMPOUND_BASIS_CODE
,      CONTRACT_AMT
,      CONTRIB_AFTER_CAPITAL_CHG
,      CREDIT_LIFE_INS_CO_CODE
,      CREDIT_LIFE_INS_PREM
,      CREDIT_SCORE
,      CREDIT_STATUS_DISPLAY_CODE
,      CURRENT_FEES
,      CUR_BOOK_BAL
,      CUR_GROSS_RATE
,      CUR_NET_BOOK_BAL
,      CUR_NET_PAR_BAL
,      CUR_NET_RATE
,      CUR_OAS
,      CUR_PAR_BAL
,      CUR_PAYMENT
,      CUR_STATIC_SPREAD
,      CUR_TP_PER_ADB
,      CUR_YIELD
,      CUSTOMER_DISPLAY_CODE
,      DATA_PROCESSING_EXP
,      DEALER_NBR
,      DEALER_RES_ORG
,      DEALER_RES_UNEARN
,      DEFERRED_CUR_BAL
,      DEFERRED_ORG_BAL
,      DEL_CUR_DAYS
,      DEL_LIFE_TIMES
,      DEL_YEAR_TIMES
,      DIRECT_IND_DISPLAY_CODE
,      ELECTRONIC_BANKING_EXP
,      EQUITY_CREDIT
,      EXIST_BORROWER_DISPLAY_CODE
,      EXPECTED_GRAD_DATE
,      FIRST_DISBURS_DATE
,      GEOGRAPHY_DISPLAY_CODE
,      GROSS_FEE_INCOME
,      HEDGE_PORTFOLIO_SET
,      HISTORIC_OAS
,      HISTORIC_STATIC_SPREAD
,      INITIAL_DIRCT_COST
,      INSTRUMENT_TYPE_CODE
,      INTEREST_INC_EXP
,      INTEREST_RATE_CODE
,      INT_TYPE_CODE
,      INVESTOR_NBR
,      ISSUE_DATE
,      ITEM_PROCESSING_EXP
,      LAST_PAYMENT_DATE
,      LAST_REPRICE_DATE
,      LINE_ITEM_DISPLAY_CODE
,      LOAN_APPROVE_DATE
,      LOAN_LOSS_PROVISION
,      LOAN_LOSS_RESERVE
,      LRD_BALANCE
,      MARGIN
,      MARGIN_GROSS
,      MARGIN_T_RATE
,      MARKET_SEGMENT_DISPLAY_CODE
,      MARKET_VALUE
,      MATCHED_SPREAD
,      MATURITY_DATE
,      NATURAL_ACCOUNT_DISPLAY_CODE
,      NEG_AMRT_AMT
,      NEG_AMRT_EQ_DATE
,      NEG_AMRT_EQ_FREQ
,      NEG_AMRT_EQ_MULT
,      NEG_AMRT_LIMIT
,      NET_FEE_INCOME
,      NET_INT_MARGIN
,      NET_MARGIN_CODE
,      NEXT_PAYMENT_DATE
,      NEXT_REPRICE_DATE
,      OPTION_COST
,      ORG_BOOK_BAL
,      ORG_INTEREST_AMT
,      ORG_LOAN_TO_VALUE
,      ORG_MARKET_VALUE
,      ORG_NET_BOOK_BAL
,      ORG_NET_PAR_BAL
,      ORG_PAR_BAL
,      ORG_PAYMENT_AMT
,      ORG_RATE
,      ORG_TERM
,      ORG_TERM_MULT
,      ORIGINATION_DATE
,      OTHER_ACCOUNT_EXP
,      OTHER_PROCESSING_EXP
,      PARTICIPATION_AMT_SOLD
,      PERCENT_SOLD
,      PLEDGED_STATUS_DISPLAY_CODE
,      PMT_ADJUST_DATE
,      PMT_CHG_FREQ
,      PMT_CHG_FREQ_MULT
,      PMT_DECR_CYCLE
,      PMT_DECR_LIFE
,      PMT_FREQ
,      PMT_FREQ_MULT
,      PMT_INCR_CYCLE
,      PMT_INCR_LIFE
,      PMT_TYPE_DISPLAY_CODE
,      PRIOR_TP_PER_ADB
,      PRODUCT_DISPLAY_CODE
,      PRODUCT_TYPE_DISPLAY_CODE
,      PURPOSE_DISPLAY_CODE
,      RATE_CAP_LIFE
,      RATE_CHG_MIN
,      RATE_CHG_RND_CODE
,      RATE_CHG_RND_FAC
,      RATE_DECR_CYCLE
,      RATE_DECR_YEAR
,      RATE_FLOOR_LIFE
,      RATE_INCR_CYCLE
,      RATE_INCR_YEAR
,      RATE_SET_LAG
,      RATE_SET_LAG_MULT
,      REASON_CLOSED_CODE
,      RECORD_COUNT
,      REMAIN_NO_PMTS
,      REMAIN_TERM
,      REMAIN_TERM_MULT
,      REPRICE_FREQ
,      REPRICE_FREQ_MULT
,      RESERVE_CHARGE_CREDIT
,      RESIDUAL_AMOUNT
,      RETAIL_EXP
,      RETURN_ITEMS
,      RETURN_ON_EQUITY
,      RWA_E
,      RWA_F
,      SCHOOL_ID_CODE
,      SPECIFIC_PROVISION
,      STUDENT_YR_IN_SCHOOL_CODE
,      TAX_EXEMPT_PCT
,      TAX_EXP
,      TEASER_END_DATE
,      TOTAL_ACCOUNT_EXP
,      TOTAL_DISTRIBUTION_EXP
,      TOTAL_FEES
,      TOTAL_FEES_AT_ORG
,      TOTAL_PROCESS_EXP
,      TOTAL_TRANSACTIONS
,      TRANSFER_CHARGE_CREDIT
,      TRANSFER_RATE
,      TRAN_RATE_REM_TERM
,      T_RATE_INT_RATE_CODE
,      USER_DIM10_DISPLAY_CODE
,      USER_DIM1_DISPLAY_CODE
,      USER_DIM2_DISPLAY_CODE
,      USER_DIM3_DISPLAY_CODE
,      USER_DIM4_DISPLAY_CODE
,      USER_DIM5_DISPLAY_CODE
,      USER_DIM6_DISPLAY_CODE
,      USER_DIM7_DISPLAY_CODE
,      USER_DIM8_DISPLAY_CODE
,      USER_DIM9_DISPLAY_CODE
,      WAIVED_FEES
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      DATE_MEASURE01
,      DATE_MEASURE02
,      DATE_MEASURE03
,      DATE_MEASURE04
,      DATE_MEASURE05
,      DATE_MEASURE06
,      DATE_MEASURE07
,      DATE_MEASURE08
,      DATE_MEASURE09
,      DATE_MEASURE10
,      DEFAULT_EST_LOSS
,      DEFAULT_FLAG
,      DFLT_LGD_ACTUAL
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
,      SPECIFIC_PROVISION_CHARGE
,      CREDIT_SCORE_DATE
,      LIQUIDITY_PREMIUM_RATE
,      LIQUIDITY_PREMIUM_AMT
,      BASIS_RISK_COST_RATE
,      BASIS_RISK_COST_AMT
,      PRICING_INCENTIVE_RATE
,      PRICING_INCENTIVE_AMT
,      OTHER_ADJUSTMENTS_RATE
,      OTHER_ADJUSTMENTS_AMT
FROM FEM.FEM_CONSUMER_LOANS_T;

Dependencies

[top of page]

FEM.FEM_CONSUMER_LOANS_T does not reference any database object

FEM.FEM_CONSUMER_LOANS_T is referenced by following:

SchemaAPPS
SynonymFEM_CONSUMER_LOANS_T