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

TABLE: FEM.FEM_CREDIT_CARDS

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


Credit Cards


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_CREDIT_CARDS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
FEM_CREDIT_CARDS_01 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY_REQUEST_ID
ColumnCREATED_BY_OBJECT_ID
ColumnID_NUMBER
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes Calendar Period
DATASET_CODE NUMBER
Yes Dataset Code
SOURCE_SYSTEM_CODE NUMBER
Yes Source System
ID_NUMBER NUMBER
Yes Uniquely identifies an instrument.
CREATED_BY_OBJECT_ID NUMBER (9) Yes Object that created the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
CREATED_BY_REQUEST_ID NUMBER
Yes Request that created the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes Object that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.OBJECT_ID
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes Request that last updated the row. References FEM_PL_OBJECT_EXECUTIONS.REQUEST_ID
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
LEDGER_ID NUMBER
Yes Ledger
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
VIP_ACCOUNT_FLG VARCHAR2 (30)
Y designates that the account belongs to a privileged customer
ACCOUNT_AGE NUMBER

The age of the account (period since account was opened).
ACCOUNT_AGE_MULT VARCHAR2 (30)
Units (days or months or years) of Account_age_c.
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_ID NUMBER

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.
AGENT_BANK_CODE VARCHAR2 (30)
An organization-defined code for the agent organization associated with the account
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.
ANNUAL_ACCT_FEE NUMBER

The account''s annual fee
ANNUAL_FEE_CODE VARCHAR2 (30)
An organization-defined code for the annual fee amount
APPLICATION_ANALYST_CODE VARCHAR2 (30)
An organization-defined code for the application analyst
APPLICATION_FINAL_SCORE VARCHAR2 (50)
The account''s final application score
APPLICATION_SCORE VARCHAR2 (50)
The account''s application score
APPL_OVERRIDE_REASON_CODE VARCHAR2 (30)
An organization-defined code for the reason the account''s application score was overridden
ATM_EXP NUMBER

Automated Teller Machine expense; typically based on number of Automated Teller Machine transactions * unit cost
AVAILABLE_CREDIT NUMBER

The difference between the credit line and the amount borrowed
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_ID NUMBER

The bank which owns the transaction.
BEHAVIOR_SCORE VARCHAR2 (50)
The account''s overall behavior score
BONUS_AMT NUMBER

The account''s usage bonus
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
CARDS_ISSUED NUMBER

The number of cards issued for the account
CASH_BALANCE NUMBER

Current Outstanding Cash Advance Balance.
CASH_RATE NUMBER

Interest Rate for Accrual of Cash Advance Balance.
CHANNEL_ID NUMBER

Channel
CHARGE_OFF_BAL NUMBER

The charge-off amount
CHARGE_OFF_DATE DATE

The last charge-off date
CHARGE_OFF_REASON_CODE VARCHAR2 (30)
The reason for the last charge-off
CHECKING_ACCT_NUMBER VARCHAR2 (50)
The checking account number associated with the account
COMPANY_COST_CENTER_ORG_ID NUMBER

Company Cost Center Organization
COMPOUND_BASIS_CODE NUMBER

Frequency by which interest is compounded.
CONTRIB_AFTER_CAPITAL_CHG NUMBER

Contribution after capital charge; typically Account Contribution - Allocated Equity * hurdle rate
CREDIT_BAL_INT_RATE NUMBER

Interest rate for credit balances
CREDIT_LINE NUMBER

The available credit line amount for the account
CREDIT_SCORE NUMBER

Credit score of borrower on original application
CREDIT_SCORE_DATE DATE

The date of the credit score.
CREDIT_STATUS_ID NUMBER

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_CREDIT_LIMIT NUMBER

Maximum allowable balance for this card.
CUR_DELQ_BAL NUMBER

The amount delinquent on the account
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_ID NUMBER

Unique numeric identifier of the Customer
CYCLE_DAY_OF_MONTH NUMBER

Day of the month on which account is cycled (processed).
DATA_PROCESSING_EXP NUMBER

Data processing expense; typically based on number of transactions * unit cost
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.
DISPUTED_TRANSFER_BAL NUMBER

The amount of the transfer balance in dispute
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
EXPIRATION_DATE DATE

The expiration date of the debit card or credit card
FEE_CHARGE_DATE DATE

Date on which fee (usually annually) is applied.
FINANCE_CHARGE_BAL NUMBER

Balance on which finance charge was calculated.
FIRST_ACTIVATED_DATE DATE

The date the account was first activated
GEOGRAPHY_ID NUMBER

Geography
GROSS_FEE_INCOME NUMBER

Sum of fee income components (before waivers)
HEDGE_PORTFOLIO_SET NUMBER

Identifies the portfolio being hedged.
HIGH_BAL NUMBER

The highest balance of the account for the current Update period
HISTORIC_OAS NUMBER

Historic Option Adjusted Spread
HISTORIC_STATIC_SPREAD NUMBER

Static spread, as calculated from the origination date.
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.
INVESTOR_NBR VARCHAR2 (50)
Investor number for sold or participated accounts.
ITEM_PROCESSING_EXP NUMBER

Item Processing Expense; typically a set expense for the type or item
LARGEST_OUTST_BAL NUMBER

Largest balance borrowed historically on this card.
LAST_ACTIVE_DATE DATE

The last date the account had activity
LAST_CR_LINE_CHANGE_DATE DATE

The date of the last credit line change
LAST_PAYMENT_AMT NUMBER

The amount of the last payment on the account
LAST_PAYMENT_DATE DATE

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

The last date a credit line increase was rejected
LAST_REPRICE_DATE DATE

Date upon which adjustable instruments last repriced.
LAST_STATUS_CHANGE_DATE DATE

The last date the status of the account changed
LAST_TRANSACTION_DATE DATE

The date of the account''s last transaction
LIMIT_USE_RATIO NUMBER

Ratio of current balance to credit limit.
LINE_ITEM_ID NUMBER

Line Item
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
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_ID NUMBER

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.
MEMBERSHIP_ANNIV_DATE DATE

The membership anniversary date
MEMBERSHIP_EXP NUMBER

The total organization cost for the account''s membership
MERCANT_INT_RATE NUMBER

The amount the merchant charges for interest
MERCHANDISE_BAL NUMBER

Current outstanding merchandise balance.
MERCHANDISE_RATE NUMBER

Interest rate for accrual of merchandise balance.
NATURAL_ACCOUNT_ID NUMBER

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.
ORG_BOOK_BAL NUMBER

Gross book balance at date of origination. Rule of 78s should exclude add on interest.
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_RATE NUMBER

Contractual interest rate at origination date.
ORIGINAL_CREDIT_LINE NUMBER

The original credit line for the account
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
OVER_LIMIT_BAL NUMBER

Amount account is currently over credit limit.
OVER_LIMIT_CURRENT_CYCLE NUMBER

The number of times the account has been over the credit limit in the current billing cycle
OVER_LIMIT_LF_TIME NUMBER

Number of times account was over credit limit throughout life of account.
PAYMENT_HISTORY_CODE VARCHAR2 (30)
An organization-defined code for the payment history on the account
PAY_AHEAD_CODE VARCHAR2 (30)
An organization-defined code indicating the time period the account is paid-ahead
PERCENT_SOLD NUMBER

Total percent of balance sold to investors.
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.
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_ID NUMBER

Product
PRODUCT_TYPE_ID NUMBER

The specific type of product given an instrument type.
PURCH_SPECIAL_SERV_CHARGES NUMBER

The amount of special service charges on purchases in the current Update period
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_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_YEAR NUMBER

Maximum interest rate increase allowed during a year for an adjustable rate instrument.
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_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
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
SAVINGS_ACCT_LOCATION VARCHAR2 (50)
The location of the savings account associated with the account
SAVINGS_ACCT_NUMBER VARCHAR2 (50)
The savings account number associated with the account
SERVICING_AGENT_ID NUMBER

Outside servicer - if applicable.
SOLICIT_SOURCE_ID NUMBER

Credit Card Program source of business.
SPECIAL_PAYMENT_AMT NUMBER

The amount of payment made not directly associated with a bill/due amount
SPECIFIC_PROVISION NUMBER

Provision expense specifically allocated for a given asset.
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_CHARGES NUMBER

The total number of charges to the account in the current Update period
TOTAL_DISTRIBUTION_EXP NUMBER

Sum of distribution related expenses for the account
TOTAL_FEES NUMBER

The total fees for the current Update period
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_BAL_DATE DATE

The date the balance was transferred from another account
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_DIM1_ID NUMBER

User Dimension1
USER_DIM2_ID NUMBER

User Dimension2
USER_DIM3_ID NUMBER

User Dimension3
USER_DIM4_ID NUMBER

User Dimension4
USER_DIM5_ID NUMBER

User Dimension5
USER_DIM6_ID NUMBER

User Dimension6
USER_DIM7_ID NUMBER

User Dimension7
USER_DIM8_ID NUMBER

User Dimension8
USER_DIM9_ID NUMBER

User Dimension9
USER_DIM10_ID NUMBER

User Dimension10
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
AMRT_TERM NUMBER

Amortization Term
AMRT_TERM_MULT VARCHAR2 (30)
Amortization Term Multiplier
AMRT_TYPE_CODE NUMBER

Amortization Type Code
DEFERRED_CUR_BAL NUMBER

Deferred Balance Current
INT_TYPE_CODE NUMBER

Interest Type Code
ISSUE_DATE DATE

Issue Date
LRD_BALANCE NUMBER

Last Repricing Date Balance
ORG_PAYMENT_AMT NUMBER

Original Payment Amount
ORG_TERM NUMBER

Original Term to Maturity
ORG_TERM_MULT VARCHAR2 (30)
Original Term Multiplier
RATE_DECR_CYCLE NUMBER

Rate Decrease Cycle
RATE_INCR_CYCLE NUMBER

Rate Increase Cycle
RATE_SET_LAG NUMBER

Rate Set Lag
RATE_SET_LAG_MULT VARCHAR2 (30)
Rate Set Lag Multiplier
REMAIN_NO_PMTS NUMBER

Remaining Number of Payments
SIC_ID NUMBER

Standard Industrial Classification Code
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

TRANSFER_RATE_ALT NUMBER

MATCHED_SPREAD_ALT NUMBER

TRAN_RATE_REM_TERM_ALT NUMBER

OTHER_ADJ_RATE_ALT NUMBER

OTHER_ADJ_AMOUNT_ALT NUMBER

HISTORIC_OAS_ALT NUMBER

HISTORIC_STATIC_SPREAD_ALT NUMBER

CUR_OAS_ALT NUMBER

CUR_STATIC_SPREAD_ALT NUMBER

Query Text

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


SELECT CAL_PERIOD_ID
,      DATASET_CODE
,      SOURCE_SYSTEM_CODE
,      ID_NUMBER
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      CURRENCY_CODE
,      LEDGER_ID
,      EMBEDDED_OPTIONS_FLG
,      JOINT_ACCOUNT_FLG
,      OPEN_ACCOUNT_FLG
,      VIP_ACCOUNT_FLG
,      ACCOUNT_AGE
,      ACCOUNT_AGE_MULT
,      ACCOUNT_CLOSE_DATE
,      ACCOUNT_CONTRIB
,      ACCOUNT_CONTRIB_AFTER_TAX
,      ACCOUNT_NUMBER
,      ACCOUNT_OFFICER
,      ACCRUAL_BASIS_ID
,      ACCRUED_INTEREST
,      ACTUAL_HOLDING_PERIOD
,      ACT_DAYS_REPR
,      ADJUSTABLE_TYPE_CODE
,      AGENT_BANK_CODE
,      ALLOCATED_EQUITY
,      ALLOC_CAP_E
,      ALLOC_CAP_F
,      ANNUAL_ACCT_FEE
,      ANNUAL_FEE_CODE
,      APPLICATION_ANALYST_CODE
,      APPLICATION_FINAL_SCORE
,      APPLICATION_SCORE
,      APPL_OVERRIDE_REASON_CODE
,      ATM_EXP
,      AVAILABLE_CREDIT
,      AVG_BOOK_BAL
,      AVG_NET_BOOK_BAL
,      BANK_ID
,      BEHAVIOR_SCORE
,      BONUS_AMT
,      BRANCH_CODE
,      BRANCH_PLATFORM_EXP
,      BRANCH_TELLER_EXP
,      CALL_CENTER_EXP
,      CARDS_ISSUED
,      CASH_BALANCE
,      CASH_RATE
,      CHANNEL_ID
,      CHARGE_OFF_BAL
,      CHARGE_OFF_DATE
,      CHARGE_OFF_REASON_CODE
,      CHECKING_ACCT_NUMBER
,      COMPANY_COST_CENTER_ORG_ID
,      COMPOUND_BASIS_CODE
,      CONTRIB_AFTER_CAPITAL_CHG
,      CREDIT_BAL_INT_RATE
,      CREDIT_LINE
,      CREDIT_SCORE
,      CREDIT_SCORE_DATE
,      CREDIT_STATUS_ID
,      CURRENT_FEES
,      CUR_BOOK_BAL
,      CUR_CREDIT_LIMIT
,      CUR_DELQ_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_ID
,      CYCLE_DAY_OF_MONTH
,      DATA_PROCESSING_EXP
,      DEFERRED_ORG_BAL
,      DEL_CUR_DAYS
,      DEL_LIFE_TIMES
,      DEL_YEAR_TIMES
,      DISPUTED_TRANSFER_BAL
,      ELECTRONIC_BANKING_EXP
,      EQUITY_CREDIT
,      EXPIRATION_DATE
,      FEE_CHARGE_DATE
,      FINANCE_CHARGE_BAL
,      FIRST_ACTIVATED_DATE
,      GEOGRAPHY_ID
,      GROSS_FEE_INCOME
,      HEDGE_PORTFOLIO_SET
,      HIGH_BAL
,      HISTORIC_OAS
,      HISTORIC_STATIC_SPREAD
,      INSTRUMENT_TYPE_CODE
,      INTEREST_INC_EXP
,      INTEREST_RATE_CODE
,      INVESTOR_NBR
,      ITEM_PROCESSING_EXP
,      LARGEST_OUTST_BAL
,      LAST_ACTIVE_DATE
,      LAST_CR_LINE_CHANGE_DATE
,      LAST_PAYMENT_AMT
,      LAST_PAYMENT_DATE
,      LAST_REJECTED_DATE
,      LAST_REPRICE_DATE
,      LAST_STATUS_CHANGE_DATE
,      LAST_TRANSACTION_DATE
,      LIMIT_USE_RATIO
,      LINE_ITEM_ID
,      LOAN_LOSS_PROVISION
,      LOAN_LOSS_RESERVE
,      MARGIN
,      MARGIN_GROSS
,      MARGIN_T_RATE
,      MARKET_SEGMENT_ID
,      MARKET_VALUE
,      MATCHED_SPREAD
,      MATURITY_DATE
,      MEMBERSHIP_ANNIV_DATE
,      MEMBERSHIP_EXP
,      MERCANT_INT_RATE
,      MERCHANDISE_BAL
,      MERCHANDISE_RATE
,      NATURAL_ACCOUNT_ID
,      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
,      ORG_BOOK_BAL
,      ORG_MARKET_VALUE
,      ORG_NET_BOOK_BAL
,      ORG_NET_PAR_BAL
,      ORG_PAR_BAL
,      ORG_RATE
,      ORIGINAL_CREDIT_LINE
,      ORIGINATION_DATE
,      OTHER_ACCOUNT_EXP
,      OTHER_PROCESSING_EXP
,      OVER_LIMIT_BAL
,      OVER_LIMIT_CURRENT_CYCLE
,      OVER_LIMIT_LF_TIME
,      PAYMENT_HISTORY_CODE
,      PAY_AHEAD_CODE
,      PERCENT_SOLD
,      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
,      PRIOR_TP_PER_ADB
,      PRODUCT_ID
,      PRODUCT_TYPE_ID
,      PURCH_SPECIAL_SERV_CHARGES
,      RATE_CAP_LIFE
,      RATE_CHG_MIN
,      RATE_CHG_RND_CODE
,      RATE_CHG_RND_FAC
,      RATE_DECR_YEAR
,      RATE_FLOOR_LIFE
,      RATE_INCR_YEAR
,      REASON_CLOSED_CODE
,      RECORD_COUNT
,      REMAIN_TERM
,      REMAIN_TERM_MULT
,      REPRICE_FREQ
,      REPRICE_FREQ_MULT
,      RESERVE_CHARGE_CREDIT
,      RETAIL_EXP
,      RETURN_ITEMS
,      RETURN_ON_EQUITY
,      RWA_E
,      RWA_F
,      SAVINGS_ACCT_LOCATION
,      SAVINGS_ACCT_NUMBER
,      SERVICING_AGENT_ID
,      SOLICIT_SOURCE_ID
,      SPECIAL_PAYMENT_AMT
,      SPECIFIC_PROVISION
,      TAX_EXEMPT_PCT
,      TAX_EXP
,      TEASER_END_DATE
,      TOTAL_ACCOUNT_EXP
,      TOTAL_CHARGES
,      TOTAL_DISTRIBUTION_EXP
,      TOTAL_FEES
,      TOTAL_PROCESS_EXP
,      TOTAL_TRANSACTIONS
,      TRANSFER_BAL_DATE
,      TRANSFER_CHARGE_CREDIT
,      TRANSFER_RATE
,      TRAN_RATE_REM_TERM
,      T_RATE_INT_RATE_CODE
,      USER_DIM1_ID
,      USER_DIM2_ID
,      USER_DIM3_ID
,      USER_DIM4_ID
,      USER_DIM5_ID
,      USER_DIM6_ID
,      USER_DIM7_ID
,      USER_DIM8_ID
,      USER_DIM9_ID
,      USER_DIM10_ID
,      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
,      AMRT_TERM
,      AMRT_TERM_MULT
,      AMRT_TYPE_CODE
,      DEFERRED_CUR_BAL
,      INT_TYPE_CODE
,      ISSUE_DATE
,      LRD_BALANCE
,      ORG_PAYMENT_AMT
,      ORG_TERM
,      ORG_TERM_MULT
,      RATE_DECR_CYCLE
,      RATE_INCR_CYCLE
,      RATE_SET_LAG
,      RATE_SET_LAG_MULT
,      REMAIN_NO_PMTS
,      SIC_ID
,      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
,      TRANSFER_RATE_ALT
,      MATCHED_SPREAD_ALT
,      TRAN_RATE_REM_TERM_ALT
,      OTHER_ADJ_RATE_ALT
,      OTHER_ADJ_AMOUNT_ALT
,      HISTORIC_OAS_ALT
,      HISTORIC_STATIC_SPREAD_ALT
,      CUR_OAS_ALT
,      CUR_STATIC_SPREAD_ALT
FROM FEM.FEM_CREDIT_CARDS;

Dependencies

[top of page]

FEM.FEM_CREDIT_CARDS does not reference any database object

FEM.FEM_CREDIT_CARDS is referenced by following:

SchemaAPPS
SynonymFEM_CREDIT_CARDS