Transcription
Oracle Financial Services Analytical ApplicationsData ModelData DictionaryRelease 7.1Part No. E16101-01September 2010
Oracle Financial Services Analytical Applications Data Model Data Dictionary, Release 7.1Part No. E16101-01Copyright 2010, Oracle and/or its affiliates. All rights reserved.Primary Author:Surag RamachandranContributing Author:Aravind VenketaramanOracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarksof their respective owners.This software and related documentation are provided under a license agreement containing restrictions onuse and disclosure and are protected by intellectual property laws. Except as expressly permitted in yourlicense agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast, modify, license,transmit, distribute, exhibit, perform, publish or display any part, in any form, or by any means. Reverseengineering, disassembly, or decompilation of this software, unless required by law for interoperability, isprohibited.The information contained herein is subject to change without notice and is not warranted to be error-free. Ifyou find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalfof the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTSPrograms, software, databases, and related documentation and technical data delivered to U.S. Governmentcustomers are "commercial computer software" or "commercial technical data" pursuant to the applicableFederal Acquisition Regulation and agency-specific supplemental regulations. As such, the use, duplication,disclosure, modification, and adaptation shall be subject to the restrictions and license terms set forth in theapplicable Government contract, and, to the extent applicable by the terms of the Government contract, theadditional rights set forth in FAR 52.227-19, Commercial Computer Software License (December 2007). OracleUSA, Inc., 500 Oracle Parkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is notdeveloped or intended for use in any inherently dangerous applications, including applications which maycreate a risk of personal injury. If you use this software in dangerous applications, then you shall beresponsible to take all appropriate fail-safe, backup, redundancy and other measures to ensure the safe use ofthis software. Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of thissoftware in dangerous applications.This software and documentation may provide access to or information on content, products and servicesfrom third parties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim allwarranties of any kind with respect to third party content, products and services. Oracle Corporation and itsaffiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of thirdparty content, products or services.
ContentsSend Us Your CommentsPreface1 Getting Started with Oracle Financial Services Analytical Applications DataDictionaryIntroduction. 1-1Oracle Financial Services Overview. 1-1Oracle Financial Services Analytical Applications. 1-1Subject Areas. 1-4Data Dictionary Table Structure. 1-42INSTRUMENTSOverview of the INSTRUMENTS Database tables.2-1FSI D LOAN CONTRACTS. 2-1FSI D MORTGAGES. 2-27FSI D CREDIT CARDS. 2-49FSI D CREDIT LINES.2-78FSI D LEASES. 2-102FSI D CASA. 2-123FSI D TERM DEPOSITS. 2-148FSI D BORROWINGS. 2-169FSI D ANNUITY CONTRACTS. 2-210FSI D RETIREMENT ACCOUNTS. 2-273FSI D INVESTMENTS . 2-296FSI D BREAK FUNDING CHARGES.2-318iii
FSI D GUARANTEES.2-349FSI D LEDGER STAT INSTRUMENT. 2-363FSI D MM CONTRACTS. 2-377FSI D MORTGAGE BACK SEC. 2-400FSI D MUTUAL FUNDS. 2-4233Instrument Services TablesOverview of the Instrument Services Database Tables. 3-1FSI D OTHER SERVICES. 3-1FSI D TRUSTS. 3-20FSI D MERCHANT CARDS. 3-394Derivative Instruments TablesFSI D DERIVATIVES. 4-1FSI D SWAPS. 4-13FSI D FORWARD RATE AGMTS. 4-27FSI D FX CONTRACTS. 4-46FSI D OPTIONS. 4-61FSI D FUTURES . 4-795LEDGER STATOverview of the LEDGER STAT Database table. 5-1LEDGER STAT Table. 5-16TRANSACTIONSOverview of the TRANSACTIONS Database tables. 6-1List of TRANSACTIONS Database Tables. 6-1Structure of TRANSACTIONS Database Tables. 6-27DIMENSIONSDIM FINANCIAL ELEMENTS B. 7-1DIM FINANCIAL ELEMENTS TL.7-2DIM FINANCIAL ELEMENTS ATTR. 7-3DIM FINANCIAL ELEMENTS HIER. 7-3DIM ORG UNIT B. 7-4DIM ORG UNIT TL.7-5DIM ORG UNIT ATTR. 7-6DIM ORG UNIT HIER. 7-7DIM GENERAL LEDGER B. 7-8iv
DIM GENERAL LEDGER TL. 7-9DIM GENERAL LEDGER ATTR. 7-10DIM GENERAL LEDGER HIER. 7-10DIM COMMON COA B. 7-11DIM COMMON COA TL. 7-13DIM COMMON COA ATTR. 7-14DIM COMMON COA HIER. 7-15DIM PRODUCTS B. 7-15DIM PRODUCTS TL. 7-16DIM PRODUCTS ATTR. 7-17DIM PRODUCTS HIER. 7-188Results TablesOverview of the Results Database tables. 8-1FSI O RESULT DETAIL TEMPLATE.8-1FSI O CONS DETAIL TEMPLATE. 8-3FSI O EAR LEAF AVG.8-5FSI O EAR LEAF DTL.8-5FSI O EAR TOTAL AVG. 8-6FSI O EAR TOTAL DTL. 8-7FSI O RESULT MASTER.8-79Reserved Code Value TablesFSI ACCRUAL BASIS MLS. 9-1FSI ADJUSTABLE TYPE MLS. 9-1FSI AMORT METHOD MLS. 9-2FSI BEHAVIOUR SUB TYPE MLS. 9-2FSI BEHAVIOUR TYPE MLS.9-3FSI CAL ROLLING CONVENTION MLS.9-4FSI COMPOUND BASIS MLS. 9-4FSI DEVOLVEMENT STATUS MLS.9-5FSI INTEREST TIMING TYPE MLS.9-5FSI INSTRUMENT TYPE MLS. 9-5FSI NET MARGIN MLS. 9-7FSI RATE CHG ROUNDING MLS.9-710User-Defined Code Value TablesFSI BILLING METHOD MLS. 10-1FSI CMO TRANCHE MLS. 10-1FSI COLLATERAL MLS. 10-1v
FSI COMMITMENT TYPE MLS. 10-5FSI CREDIT RATING MLS. 10-6FSI CREDIT STATUS MLS. 10-6FSI DIRECT IND MLS. 10-7FSI EXIST BORROWER MLS. 10-8FSI GEOGRAPHIC LOC MLS. 10-8FSI HELD FOR SALE MLS.10-12FSI ISSUER MLS. 10-12FSI LIEN POSITION MLS. 10-12FSI LIQUIDITY CLASS MLS. 10-13FSI MARKET SEGMENT MLS. 10-14FSI OCCUPANCY MLS. 10-15FSI OVERDRAFT PROTECTION MLS.10-15FSI PLEDGED STATUS MLS. 10-16FSI PRODUCT TYPE MLS. 10-17FSI PURPOSE MLS. 10-31FSI PUT CALL MLS. 10-32FSI ROLL FACILITY MLS.10-32FSI SERVICING AGENT MLS. 10-32FSI SIC MLS. 10-33FSI SOLICIT SOURCE MLS. 10-3711Super Type ModelingBASIC INSTRUMENT REQ. 11-1CASH FLOW EDIT REQ. 11-1CASH FLOW PROC REQ. 11-2LEAF COLUMNS. 11-812Staging TablesSTG EXCHANGE RATE HIST.12-1STG IRC RATE HIST. 12-2STG ECO IND HIST RATES.12-2STG PPMT MODEL HYPERCUBE. 12-3STG ORG UNIT B INTF. 12-4STG ORG UNIT TL INTF. 12-4STG ORG UNIT ATTR INTF. 12-5STG ORG UNIT HIER INTF. 12-5STG COMMON COA B INTF. 12-6STG COMMON COA TL INTF. 12-7STG COMMON COA ATTR INTF. 12-7vi
STG COMMON COA HIER INTF. 12-8STG PRODUCTS B INTF. 12-9STG PRODUCTS TL INTF. 12-9STG PRODUCTS ATTR INTF. 12-10STG PRODUCTS HIER INTF. 12-10STG GL B INTF. 12-11STG GL TL INTF. 12-12STG GL ATTR INTF. 12-12STG GL HIER INTF.12-13STG HIERARCHIES INTF. 12-13FSI DIM ATTRIBUTE MAP. 12-15FSI DIM LOADER SETUP DETAILS. 12-43FSI LS LOAD BATCH. 12-45STG GL DATA. 12-4713Staging Product Processor to Instrument Table MappingOverview of Staging Product Processor to Instrument Table Mapping.13-1Annuity Contracts. 13-3Borrowings.
Analytical Applications Data Model (OFSAADM) database tables that contain your organization's data. The source of this data can be your transaction and accounting systems or the results of processes run within Infrastructure, such as knowledge engines or financial forecasting.File Size: 2MB
