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


TABLE: FEM.FEM_BREAK_FUNDING

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

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FEM_BREAK_FUNDING_01 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCREATED_BY_REQUEST_ID
ColumnCREATED_BY_OBJECT_ID
ColumnID_NUMBER
FEM_BREAK_FUNDING_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnCAL_PERIOD_ID
ColumnDATASET_CODE
ColumnSOURCE_SYSTEM_CODE
ColumnID_NUMBER
Columns
Name Datatype Length Mandatory Comments
CAL_PERIOD_ID NUMBER
Yes
CREATED_BY_OBJECT_ID NUMBER (9) Yes
CREATED_BY_REQUEST_ID NUMBER
Yes
CURRENCY_CODE VARCHAR2 (15) Yes
DATASET_CODE NUMBER
Yes
ID_NUMBER NUMBER
Yes
LAST_UPDATED_BY_OBJECT_ID NUMBER (9) Yes
LAST_UPDATED_BY_REQUEST_ID NUMBER
Yes
LEDGER_ID NUMBER
Yes
SOURCE_SYSTEM_CODE NUMBER
Yes
ACCOUNT_CLOSE_DATE DATE

ACCOUNT_CONTRIB NUMBER

ACCOUNT_CONTRIB_AFTER_TAX NUMBER

ACCOUNT_NUMBER VARCHAR2 (50)
ACCOUNT_OFFICER VARCHAR2 (50)
ACCRUAL_BASIS_ID NUMBER

ACCRUED_INTEREST NUMBER

ACTUAL_HOLDING_PERIOD NUMBER (5)
ACT_DAYS_REPR NUMBER (6)
ADJUSTABLE_TYPE_CODE NUMBER

ALLOCATED_EQUITY NUMBER

ALLOC_CAP_E NUMBER

ALLOC_CAP_F NUMBER

ALPHANUMERIC_MEASURE01 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE02 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE03 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE04 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE05 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE06 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE07 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE08 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE09 VARCHAR2 (4000)
ALPHANUMERIC_MEASURE10 VARCHAR2 (4000)
AMRT_TERM NUMBER

AMRT_TERM_MULT VARCHAR2 (30)
AMRT_TYPE_CODE NUMBER

APPROVAL_DATE DATE

APPROVED_AMT NUMBER

ARM_BASE_RATE NUMBER

ATM_EXP NUMBER

AUTOPAY_ACCT_NUMBER VARCHAR2 (50)
AUTOPAY_BANK_TRANSIT_NBR VARCHAR2 (50)
AUTOPAY_FLG VARCHAR2 (30)
AUTOPAY_INSTR_TYPE_ID NUMBER

AVG_BOOK_BAL NUMBER

AVG_NET_BOOK_BAL NUMBER

BANK_ID NUMBER

BASIS_RISK_COST_AMT NUMBER

BASIS_RISK_COST_RATE NUMBER

BRANCH_CODE VARCHAR2 (30)
BRANCH_PLATFORM_EXP NUMBER

BRANCH_TELLER_EXP NUMBER

BREAK_FUNDING_AMT NUMBER

BREAK_FUNDING_MV NUMBER

BREAK_FUNDING_RATE NUMBER

CALL_CENTER_EXP NUMBER

CHANNEL_ID NUMBER

COMMITMENT_NBR VARCHAR2 (50)
COMPANY_COST_CENTER_ORG_ID NUMBER

COMPOUND_BASIS_CODE NUMBER

CONTRACT_AMT NUMBER

CONTRIB_AFTER_CAPITAL_CHG NUMBER

COUNTRY_GEOGRAPHY_ID NUMBER

CREDIT_SCORE NUMBER

CREDIT_SCORE_DATE DATE

CREDIT_STATUS_ID NUMBER

CURRENT_FEES NUMBER

CUR_BOOK_BAL NUMBER

CUR_GROSS_RATE NUMBER

CUR_LOAN_TO_VALUE NUMBER

CUR_NET_BOOK_BAL NUMBER

CUR_NET_PAR_BAL NUMBER

CUR_NET_RATE NUMBER

CUR_OAS NUMBER

CUR_OAS_ALT NUMBER

CUR_PAR_BAL NUMBER

CUR_PAYMENT NUMBER

CUR_STATIC_SPREAD NUMBER

CUR_STATIC_SPREAD_ALT NUMBER

CUR_TP_PER_ADB NUMBER

CUR_YIELD NUMBER

CUSTOMER_ID NUMBER

DATA_PROCESSING_EXP NUMBER

DATE_MEASURE01 DATE

DATE_MEASURE02 DATE

DATE_MEASURE03 DATE

DATE_MEASURE04 DATE

DATE_MEASURE05 DATE

DATE_MEASURE06 DATE

DATE_MEASURE07 DATE

DATE_MEASURE08 DATE

DATE_MEASURE09 DATE

DATE_MEASURE10 DATE

DEFAULT_EST_LOSS NUMBER

DEFAULT_FLAG VARCHAR2 (30)
DEFERRED_CUR_BAL NUMBER

DEFERRED_ORG_BAL NUMBER

DEL_CUR_DAYS NUMBER

DEL_LIFE_TIMES NUMBER

DEL_YEAR_TIMES NUMBER

DFLT_LGD_ACTUAL NUMBER

DIST_FR_LIFE_CAP NUMBER

EFFECTIVE_MATURITY NUMBER

EFFECTIVE_MATURITY_MULT VARCHAR2 (30)
ELECTRONIC_BANKING_EXP NUMBER

EMBEDDED_OPTIONS_FLG VARCHAR2 (30)
EQUITY_CREDIT NUMBER

GEOGRAPHY_ID NUMBER

GROSS_FEE_INCOME NUMBER

HEDGE_PORTFOLIO_SET NUMBER

HISTORIC_OAS NUMBER

HISTORIC_OAS_ALT NUMBER

HISTORIC_STATIC_SPREAD NUMBER

HISTORIC_STATIC_SPREAD_ALT NUMBER

INSTRUMENT_TYPE_CODE NUMBER

INTEREST_INC_EXP NUMBER

INTEREST_RATE_CODE NUMBER

INT_TYPE_CODE NUMBER

INVESTOR_NBR VARCHAR2 (50)
ISSUE_DATE DATE

ITEM_PROCESSING_EXP NUMBER

JOINT_ACCOUNT_FLG VARCHAR2 (30)
LAST_PAYMENT_DATE DATE

LAST_REPRICE_DATE DATE

LIEN_POSITION_ID NUMBER

LINE_ITEM_ID NUMBER

LIQUIDITY_PREMIUM_AMT NUMBER

LIQUIDITY_PREMIUM_RATE NUMBER

LOAN_LOSS_PROVISION NUMBER

LOAN_LOSS_RESERVE NUMBER

LRD_BALANCE NUMBER

MARGIN NUMBER

MARGIN_GROSS NUMBER

MARGIN_T_RATE NUMBER

MARKET_SEGMENT_ID NUMBER

MARKET_VALUE NUMBER

MATCHED_SPREAD NUMBER

MATCHED_SPREAD_ALT NUMBER

MATURITY_DATE DATE

MATURITY_FLOOR_FLAG VARCHAR2 (30)
NATURAL_ACCOUNT_ID NUMBER

NEG_AMRT_AMT NUMBER

NEG_AMRT_EQ_DATE DATE

NEG_AMRT_EQ_FREQ NUMBER

NEG_AMRT_EQ_MULT VARCHAR2 (30)
NEG_AMRT_LIMIT NUMBER

NET_FEE_INCOME NUMBER

NET_INT_MARGIN NUMBER

NET_MARGIN_CODE NUMBER

NEXT_PAYMENT_DATE DATE

NEXT_REPRICE_DATE DATE

NUMERIC_MEASURE01 NUMBER

NUMERIC_MEASURE02 NUMBER

NUMERIC_MEASURE03 NUMBER

NUMERIC_MEASURE04 NUMBER

NUMERIC_MEASURE05 NUMBER

NUMERIC_MEASURE06 NUMBER

NUMERIC_MEASURE07 NUMBER

NUMERIC_MEASURE08 NUMBER

NUMERIC_MEASURE09 NUMBER

NUMERIC_MEASURE10 NUMBER

OCCUPANCY_ID NUMBER

OPEN_ACCOUNT_FLG VARCHAR2 (30)
OPTION_COST NUMBER

ORG_BOOK_BAL NUMBER

ORG_LOAN_TO_VALUE NUMBER

ORG_MARKET_VALUE NUMBER

ORG_NET_BOOK_BAL NUMBER

ORG_NET_PAR_BAL NUMBER

ORG_PAR_BAL NUMBER

ORG_PAYMENT_AMT NUMBER

ORG_RATE NUMBER

ORG_TERM NUMBER

ORG_TERM_MULT VARCHAR2 (30)
ORIGINATION_DATE DATE

OTHER_ACCOUNT_EXP NUMBER

OTHER_ADJUSTMENTS_AMT NUMBER

OTHER_ADJUSTMENTS_RATE NUMBER

OTHER_ADJ_AMOUNT_ALT NUMBER

OTHER_ADJ_RATE_ALT NUMBER

OTHER_PROCESSING_EXP NUMBER

OWNER_OCCUPIED_FLG VARCHAR2 (30)
PARTICIPATION_AMT_SOLD NUMBER

PARTICIPATION_FLG VARCHAR2 (30)
PERCENT_SOLD NUMBER

PLEDGED_STATUS_ID NUMBER

PMT_ADJUST_DATE DATE

PMT_CHG_FREQ NUMBER

PMT_CHG_FREQ_MULT VARCHAR2 (30)
PMT_DECR_CYCLE NUMBER

PMT_DECR_LIFE NUMBER

PMT_FREQ NUMBER

PMT_FREQ_MULT VARCHAR2 (30)
PMT_INCR_CYCLE NUMBER

PMT_INCR_LIFE NUMBER

PMT_TYPE_ID NUMBER

PRICING_INCENTIVE_AMT NUMBER

PRICING_INCENTIVE_RATE NUMBER

PRIOR_TP_PER_ADB NUMBER

PRODUCT_ID NUMBER

PRODUCT_TYPE_ID NUMBER

PROPERTY_TYPE_CODE VARCHAR2 (30)
PROPERTY_ZIP_CODE NUMBER

PURPOSE_ID NUMBER

RATE_CAP_LIFE NUMBER

RATE_CHG_MIN NUMBER

RATE_CHG_RND_CODE NUMBER

RATE_CHG_RND_FAC NUMBER

RATE_DECR_CYCLE NUMBER

RATE_DECR_YEAR NUMBER

RATE_FLOOR_LIFE NUMBER

RATE_INCR_CYCLE NUMBER

RATE_INCR_YEAR NUMBER

RATE_SET_LAG NUMBER

RATE_SET_LAG_MULT VARCHAR2 (30)
REASON_CLOSED_CODE VARCHAR2 (30)
RECORD_COUNT NUMBER

REMAIN_NO_PMTS NUMBER

REMAIN_TERM NUMBER

REMAIN_TERM_MULT VARCHAR2 (30)
REPRICE_FREQ NUMBER

REPRICE_FREQ_MULT VARCHAR2 (30)
RESERVE_CHARGE_CREDIT NUMBER

RETAIL_EXP NUMBER

RETURN_ITEMS NUMBER

RETURN_ON_EQUITY NUMBER

RWA_E NUMBER

RWA_F NUMBER

SENIORITY_FLAG VARCHAR2 (30)
SLOTCRIT_ADJUST_FLAG VARCHAR2 (30)
SPECIFIC_PROVISION NUMBER

SPECIFIC_PROVISION_CHARGE NUMBER

TAX_EXEMPT_PCT NUMBER

TAX_EXP NUMBER

TEASER_END_DATE DATE

TOTAL_ACCOUNT_EXP NUMBER

TOTAL_DISTRIBUTION_EXP NUMBER

TOTAL_FEES NUMBER

TOTAL_FEES_AT_ORG NUMBER

TOTAL_PROCESS_EXP NUMBER

TOTAL_TRANSACTIONS NUMBER

TRANSFER_CHARGE_CREDIT NUMBER

TRANSFER_RATE NUMBER

TRANSFER_RATE_ALT NUMBER

TRAN_RATE_REM_TERM NUMBER

TRAN_RATE_REM_TERM_ALT NUMBER

T_RATE_INT_RATE_CODE NUMBER

USER_DIM10_ID NUMBER

USER_DIM1_ID NUMBER

USER_DIM2_ID NUMBER

USER_DIM3_ID NUMBER

USER_DIM4_ID NUMBER

USER_DIM5_ID NUMBER

USER_DIM6_ID NUMBER

USER_DIM7_ID NUMBER

USER_DIM8_ID NUMBER

USER_DIM9_ID NUMBER

VIP_ACCOUNT_FLG VARCHAR2 (30)
WAIVED_FEES NUMBER

Query Text

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


SELECT CAL_PERIOD_ID
,      CREATED_BY_OBJECT_ID
,      CREATED_BY_REQUEST_ID
,      CURRENCY_CODE
,      DATASET_CODE
,      ID_NUMBER
,      LAST_UPDATED_BY_OBJECT_ID
,      LAST_UPDATED_BY_REQUEST_ID
,      LEDGER_ID
,      SOURCE_SYSTEM_CODE
,      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
,      ALLOCATED_EQUITY
,      ALLOC_CAP_E
,      ALLOC_CAP_F
,      ALPHANUMERIC_MEASURE01
,      ALPHANUMERIC_MEASURE02
,      ALPHANUMERIC_MEASURE03
,      ALPHANUMERIC_MEASURE04
,      ALPHANUMERIC_MEASURE05
,      ALPHANUMERIC_MEASURE06
,      ALPHANUMERIC_MEASURE07
,      ALPHANUMERIC_MEASURE08
,      ALPHANUMERIC_MEASURE09
,      ALPHANUMERIC_MEASURE10
,      AMRT_TERM
,      AMRT_TERM_MULT
,      AMRT_TYPE_CODE
,      APPROVAL_DATE
,      APPROVED_AMT
,      ARM_BASE_RATE
,      ATM_EXP
,      AUTOPAY_ACCT_NUMBER
,      AUTOPAY_BANK_TRANSIT_NBR
,      AUTOPAY_FLG
,      AUTOPAY_INSTR_TYPE_ID
,      AVG_BOOK_BAL
,      AVG_NET_BOOK_BAL
,      BANK_ID
,      BASIS_RISK_COST_AMT
,      BASIS_RISK_COST_RATE
,      BRANCH_CODE
,      BRANCH_PLATFORM_EXP
,      BRANCH_TELLER_EXP
,      BREAK_FUNDING_AMT
,      BREAK_FUNDING_MV
,      BREAK_FUNDING_RATE
,      CALL_CENTER_EXP
,      CHANNEL_ID
,      COMMITMENT_NBR
,      COMPANY_COST_CENTER_ORG_ID
,      COMPOUND_BASIS_CODE
,      CONTRACT_AMT
,      CONTRIB_AFTER_CAPITAL_CHG
,      COUNTRY_GEOGRAPHY_ID
,      CREDIT_SCORE
,      CREDIT_SCORE_DATE
,      CREDIT_STATUS_ID
,      CURRENT_FEES
,      CUR_BOOK_BAL
,      CUR_GROSS_RATE
,      CUR_LOAN_TO_VALUE
,      CUR_NET_BOOK_BAL
,      CUR_NET_PAR_BAL
,      CUR_NET_RATE
,      CUR_OAS
,      CUR_OAS_ALT
,      CUR_PAR_BAL
,      CUR_PAYMENT
,      CUR_STATIC_SPREAD
,      CUR_STATIC_SPREAD_ALT
,      CUR_TP_PER_ADB
,      CUR_YIELD
,      CUSTOMER_ID
,      DATA_PROCESSING_EXP
,      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
,      DEFERRED_CUR_BAL
,      DEFERRED_ORG_BAL
,      DEL_CUR_DAYS
,      DEL_LIFE_TIMES
,      DEL_YEAR_TIMES
,      DFLT_LGD_ACTUAL
,      DIST_FR_LIFE_CAP
,      EFFECTIVE_MATURITY
,      EFFECTIVE_MATURITY_MULT
,      ELECTRONIC_BANKING_EXP
,      EMBEDDED_OPTIONS_FLG
,      EQUITY_CREDIT
,      GEOGRAPHY_ID
,      GROSS_FEE_INCOME
,      HEDGE_PORTFOLIO_SET
,      HISTORIC_OAS
,      HISTORIC_OAS_ALT
,      HISTORIC_STATIC_SPREAD
,      HISTORIC_STATIC_SPREAD_ALT
,      INSTRUMENT_TYPE_CODE
,      INTEREST_INC_EXP
,      INTEREST_RATE_CODE
,      INT_TYPE_CODE
,      INVESTOR_NBR
,      ISSUE_DATE
,      ITEM_PROCESSING_EXP
,      JOINT_ACCOUNT_FLG
,      LAST_PAYMENT_DATE
,      LAST_REPRICE_DATE
,      LIEN_POSITION_ID
,      LINE_ITEM_ID
,      LIQUIDITY_PREMIUM_AMT
,      LIQUIDITY_PREMIUM_RATE
,      LOAN_LOSS_PROVISION
,      LOAN_LOSS_RESERVE
,      LRD_BALANCE
,      MARGIN
,      MARGIN_GROSS
,      MARGIN_T_RATE
,      MARKET_SEGMENT_ID
,      MARKET_VALUE
,      MATCHED_SPREAD
,      MATCHED_SPREAD_ALT
,      MATURITY_DATE
,      MATURITY_FLOOR_FLAG
,      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
,      NUMERIC_MEASURE01
,      NUMERIC_MEASURE02
,      NUMERIC_MEASURE03
,      NUMERIC_MEASURE04
,      NUMERIC_MEASURE05
,      NUMERIC_MEASURE06
,      NUMERIC_MEASURE07
,      NUMERIC_MEASURE08
,      NUMERIC_MEASURE09
,      NUMERIC_MEASURE10
,      OCCUPANCY_ID
,      OPEN_ACCOUNT_FLG
,      OPTION_COST
,      ORG_BOOK_BAL
,      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_ADJUSTMENTS_AMT
,      OTHER_ADJUSTMENTS_RATE
,      OTHER_ADJ_AMOUNT_ALT
,      OTHER_ADJ_RATE_ALT
,      OTHER_PROCESSING_EXP
,      OWNER_OCCUPIED_FLG
,      PARTICIPATION_AMT_SOLD
,      PARTICIPATION_FLG
,      PERCENT_SOLD
,      PLEDGED_STATUS_ID
,      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_ID
,      PRICING_INCENTIVE_AMT
,      PRICING_INCENTIVE_RATE
,      PRIOR_TP_PER_ADB
,      PRODUCT_ID
,      PRODUCT_TYPE_ID
,      PROPERTY_TYPE_CODE
,      PROPERTY_ZIP_CODE
,      PURPOSE_ID
,      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
,      RETAIL_EXP
,      RETURN_ITEMS
,      RETURN_ON_EQUITY
,      RWA_E
,      RWA_F
,      SENIORITY_FLAG
,      SLOTCRIT_ADJUST_FLAG
,      SPECIFIC_PROVISION
,      SPECIFIC_PROVISION_CHARGE
,      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
,      TRANSFER_RATE_ALT
,      TRAN_RATE_REM_TERM
,      TRAN_RATE_REM_TERM_ALT
,      T_RATE_INT_RATE_CODE
,      USER_DIM10_ID
,      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
,      VIP_ACCOUNT_FLG
,      WAIVED_FEES
FROM FEM.FEM_BREAK_FUNDING;

Dependencies

[top of page]

FEM.FEM_BREAK_FUNDING does not reference any database object

FEM.FEM_BREAK_FUNDING is referenced by following:

SchemaAPPS
SynonymFEM_BREAK_FUNDING