4.4 Pre-Mapped Dimensions for Migration
Pre-mapped dimensions with associated On-Premise and SaaS Dimension tables.
Table 4-4 Migratable Pre-Seeded Dimensions
Dimension | On-Premise Dimension Table | SaaS Dimension Table |
---|---|---|
Accidental Health Insurance Company | FSI_ACCID_HEALTH_INS_CO_CD | FSI_ACCID_HEALTH_INS_CO_CD |
Account Group | FSI_ACCOUNT_GROUP_CD | FSI_ACCOUNT_GROUP_CD |
Account Officer | FSI_ACCOUNT_OFFICER_CD | FSI_ACCOUNT_OFFICER_CD |
Account Type | FSI_ACCOUNT_TYPE_CD | FSI_ACCOUNT_TYPE_CD |
Accrual Basis | FSI_ACCRUAL_BASIS_CD | FSI_ACCRUAL_BASIS_CD |
Adjustable Type | FSI_ADJUSTABLE_TYPE_CD_V | FSI_ADJUSTABLE_TYPE_CD_V |
Adjustment Type Code | FSI_ADJUSTMENT_TYPE_CD | FSI_ADJUSTMENT_TYPE_CD |
Advice Type | FSI_ADVICE_TYPE_CD | FSI_ADVICE_TYPE_CD |
Agent Bank | FSI_AGENT_BANK_CD | FSI_AGENT_BANK_CD |
Aggregate Method | FSI_AGGREGATE_METHOD_CD | FSI_AGGREGATE_METHOD_CD |
Amortization Method | FSI_AMORT_METHOD_CD | FSI_AMORT_METHOD_CD |
Amortization Type | FSI_AMORTIZATION_TYPE_CD_V | FSI_AMORTIZATION_TYPE_CD_V |
Annual Fee | FSI_ANNUAL_FEE_CD | FSI_ANNUAL_FEE_CD |
Application Analyst | FSI_APPLICATION_ANALYST_CD | FSI_APPLICATION_ANALYST_CD |
Authorization Device Type | FSI_AUTH_DEVICE_TYPE_CD | FSI_AUTH_DEVICE_TYPE_CD |
Autopay Instruction Type | FSI_AUTOPAY_INSTR_TYPE_CD | FSI_AUTOPAY_INSTR_TYPE_CD |
Balance Type | FSI_BALANCE_TYPE_CD | FSI_BALANCE_TYPE_CD |
Bank | FSI_BANK_CD | FSI_BANK_CD |
Branch | FSI_BRANCH_CD | DIM_BRANCH_B |
Behavior Subtype Code | FSI_BEHAVIOUR_SUB_TYPE_CD | FSI_BEHAVIOUR_SUB_TYPE_CD |
Behavior Type Code | FSI_BEHAVIOUR_TYPE_CD | FSI_BEHAVIOUR_TYPE_CD |
Billing Method | FSI_BILLING_METHOD_CD | FSI_BILLING_METHOD_CD |
Break Identification Code | FSI_BREAKAGE_TYPE_CD | FSI_BREAKAGE_TYPE_CD |
Calendar Rolling Convention Code | FSI_CAL_ROLLING_CONVENTION_CD | FSI_CAL_ROLLING_CONVENTION_CD |
Cash Flow Code | FSI_CASH_FLOW_TYPE_CD | FSI_CASH_FLOW_TYPE_CD |
Channel | FSI_DISTRIBUTION_CHANNEL_CD | FSI_CHANNEL_CD |
Chargeoff Reason | FSI_CHARGE_OFF_REASON_CD | FSI_CHARGE_OFF_REASON_CD |
Collateral | FSI_COLLATERAL_CD | FSI_COLLATERAL_CD |
Commit Option Type | FSI_COMMIT_OPTION_TYPE_CD | FSI_COMMIT_OPTION_TYPE_CD |
Commitment Type | FSI_COMMITMENT_TYPE_CD | FSI_COMMITMENT_TYPE_CD |
Common Chart of Accounts | DIM_COMMON_COA_B | DIM_COMMON_COA_B |
Compounding Basis Code | FSI_COMPOUND_BASIS_CD | FSI_COMPOUND_BASIS_CD |
Consolidation Code | FSI_CONSOLIDATION_CD | FSI_CONSOLIDATION_CD |
Corporate Agreement | FSI_CORPORATE_AGREEMENT_CD | FSI_CORPORATE_AGREEMENT_CD |
Country | DIM_COUNTRY_B | FSI_COUNTRY_CD |
Credit Life Insurance Company | FSI_CREDIT_LIFE_INS_CO_CD | FSI_CREDIT_LIFE_INS_CO_CD |
Credit Rating | FSI_CREDIT_RATING_CD | FSI_CREDIT_RATING_CD |
Credit Status | FSI_CREDIT_STATUS_CD | FSI_CREDIT_STATUS_CD |
CWB Status | FSI_CWB_STATUS_CD | FSI_CWB_STATUS_CD |
Data Source | FSI_INSTRUMENT_DATA_SOURCE_CD | FSI_INSTRUMENT_DATA_SOURCE_CD |
Data Source Code | FSI_DATA_SOURCE_CD | FSI_DATA_SOURCE_CD |
Direct Deposit Account Type | FSI_DIR_DEPOS_ACCT_TYPE_CD | FSI_DIR_DEPOS_ACCT_TYPE_CD |
Direct Indicator Code | FSI_DIRECT_IND_CD | FSI_DIRECT_IND_CD |
Disbursement Method | FSI_DISBURS_METHOD_CD | FSI_DISBURS_METHOD_CD |
Delinquency Status | FSI_DELINQUENCY_STATUS_CD | FSI_DELINQUENCY_STATUS_CD |
Deposit Type | FSI_DEPOSIT_TYPE_CD | FSI_DEPOSIT_TYPE_CD |
Documentation | FSI_DOCUMENTATION_CD | FSI_DOCUMENTATION_CD |
Exception | FSI_EXCEPTION_CD | FSI_EXCEPTION_CD |
Existing Borrower Code Dimension | FSI_EXIST_BORROWER_CD | FSI_EXIST_BORROWER_CD |
Fiduciary Agreement | FSI_FIDUCIARY_AGREEMENT_CD | FSI_FIDUCIARY_AGREEMENT_CD |
Financial Element | DIM_FINANCIAL_ELEMENTS_B | DIM_FINANCIAL_ELEMENTS_B |
Funding Status | FSI_FUNDING_STATUS_CD | FSI_FUNDING_STATUS_CD |
Funding Type | FSI_FUNDING_TYPE_CD | FSI_FUNDING_TYPE_CD |
Futures Subtype Code | FSI_FUTURES_SUBTYPE_CD | FSI_FUTURES_SUBTYPE_CD |
Futures Type Code | FSI_FUTURES_TYPE_CD | FSI_FUTURES_TYPE_CD |
General Ledger Account | DIM_GENERAL_LEDGER_B | DIM_GENERAL_LEDGER_B |
Geographic Location | FSI_GEOGRAPHIC_LOC_CD | DIM_GEOGRAPHIC_LOC_B |
Geographic State | FSI_GEOGRAPHIC_LOC_STATE_CD | FSI_GEOGRAPHIC_LOC_STATE_CD |
Holiday Calc | FSI_HOLIDAY_CALC_OPTION_CD | FSI_HOLIDAY_CALC_OPTION_CD |
Instrument Type | FSI_INSTRUMENT_TYPE_CD | FSI_INSTRUMENT_TYPE_CD |
Interest Dividends Option | FSI_INT_DIVIDENDS_OPTION_CD | FSI_INT_DIVIDENDS_OPTION_CD |
Interest Payment Method | FSI_INT_PAYMENT_METHOD_CD | FSI_INT_PAYMENT_METHOD_CD |
Interest Timing Type Code | FSI_INTEREST_TIMING_TYPE_CD | FSI_INTEREST_TIMING_TYPE_CD |
Investor Type | FSI_INVESTOR_TYPE_CD | FSI_INVESTOR_TYPE_CD |
IR Option Type | FSI_IR_OPTION_TYPE_CD | FSI_IR_OPTION_TYPE_CD |
IRA Funding Status Code Dimension | FSI_IRA_FUNDING_STATUS_CD | FSI_IRA_FUNDING_STATUS_CD |
Issuer | FSI_ISSUER_CD | FSI_ISSUER_CD |
Joint Agreement | FSI_JOINT_AGREEMENT_CD | FSI_JOINT_AGREEMENT_CD |
Lien Position | FSI_LIEN_POSITION_CD | FSI_LIEN_POSITION_CD |
Liquidity Class | FSI_LIQUIDITY_CLASS_CD | FSI_LIQUIDITY_CLASS_CD |
Leg Type | FSI_LEG_TYPE_CD | FSI_LEG_TYPE_CD |
Legal Entity | DIM_LEGAL_ENTITY_B | DIM_LEGAL_ENTITY_B |
Loan Type | FSI_LOAN_TYPE_CD | FSI_LOAN_TYPE_CD |
Margin Agreement | FSI_MARGIN_AGREEMENT_CD | FSI_MARGIN_AGREEMENT_CD |
Market Segment Code | FSI_MARKET_SEGMENT_CD | FSI_MARKET_SEGMENT_CD |
Merchant Class | FSI_MERCHANT_CLASS_CD | FSI_MERCHANT_CLASS_CD |
Merchant Chain | FSI_MERCHANT_CHAIN_CD | FSI_MERCHANT_CHAIN_CD |
Multiplier Code | FSI_MULTIPLIER_CD | FSI_MULTIPLIER_CD |
Net Margin | FSI_NET_MARGIN_CD | FSI_NET_MARGIN_CD |
Occupancy | FSI_OCCUPANCY_CD | FSI_OCCUPANCY_CD |
Option Decision Type | FSI_OPTION_DECISION_TYPE_CD | FSI_OPTION_DECISION_TYPE_CD |
Option Exercise Code | FSI_OPTION_EXERCISE_CD | FSI_OPTION_EXERCISE_CD |
Option Strike Type | FSI_OPTION_STRIKE_TYPE_CD | FSI_OPTION_STRIKE_TYPE_CD |
Option Rate Lookup Type | FSI_OPTION_RATE_LOOKUP_CD | FSI_OPTION_RATE_LOOKUP_CD |
Option Type Code | FSI_OPTION_TYPE_CD | FSI_OPTION_TYPE_CD |
Organizational Unit | DIM_ORG_UNIT_B | DIM_ORG_UNIT_B |
Overdraft Protection | FSI_OVERDRAFT_PROTECTION_CD | FSI_OVERDRAFT_PROTECTION_CD |
Outside Info Source | FSI_OUTSIDE_INFO_SOURCE_CD | FSI_OUTSIDE_INFO_SOURCE_CD |
Ownership Type | FSI_OWNERSHIP_TYPE_CD | FSI_OWNERSHIP_TYPE_CD |
Parent Service | FSI_PARENT_SERVICE_CD | FSI_PARENT_SERVICE_CD |
Pay Ahead | FSI_PAY_AHEAD_CD | FSI_PAY_AHEAD_CD |
Pay Equivalent Compounding Convention Code | FSI_PAY_EQUI_COMPOUND_CONV_CD | FSI_PAY_EQUI_COMPOUND_CONV_CD |
Payment Type | FSI_PAYMENT_TYPE_CD | FSI_PAYMENT_TYPE_CD |
Plan | FSI_PLAN_CD | FSI_PLAN_CD |
Pledged Status | FSI_PLEDGED_STATUS_CD | FSI_PLEDGED_STATUS_CD |
Prev Delq Statu | FSI_PREV_DELQ_STATUS_CD | FSI_PREV_DELQ_STATUS_CD |
Product | DIM_PRODUCTS_B | DIM_PRODUCTS_B |
Product Type Code | FSI_PRODUCT_TYPE_CD | FSI_PRODUCT_TYPE_CD |
Property Purpose | FSI_PROPERTY_PURPOSE_CD | FSI_PROPERTY_PURPOSE_CD |
Property Sub Type | FSI_PROPERTY_SUB_TYPE_CD | FSI_PROPERTY_SUB_TYPE_CD |
Purpose | FSI_PURPOSE_CD | FSI_PURPOSE_CD |
Rate Change Rounding Code | FSI_RATE_CHG_ROUNDING_CD | FSI_RATE_CHG_ROUNDING_CD |
Rate Data Source | FSI_RATE_DATA_SOURCE_CD | FSI_RATE_DATA_SOURCE_CD |
Reason Closed | FSI_REASON_CLOSED_CD | FSI_REASON_CLOSED_CD |
Relationship Type | FSI_RELATIONSHIP_TYPE_CD | FSI_RELATIONSHIP_TYPE_CD |
Roll Facility | FSI_ROLL_FACILITY_CD | FSI_ROLL_FACILITY_CD |
Rollup Signage | FSI_ROLLUP_SIGNAGE_CD | FSI_ROLLUP_SIGNAGE_CD |
School Code | FSI_SCHOOL_ID_CD | FSI_SCHOOL_ID_CD |
Service Option | FSI_SERVICE_OPTION_CD | FSI_SERVICE_OPTION_CD |
Service Source | FSI_SERVICE_SOURCE_CD | FSI_SERVICE_SOURCE_CD |
Servicing Agent | FSI_SERVICING_AGENT_CD | FSI_SERVICING_AGENT_CD |
Settlement Account Service Code | FSI_SETTLEMENT_ACCT_SERV_CD | FSI_SETTLEMENT_ACCT_SERV_CD |
Solicit Source | FSI_SOLICIT_SOURCE_CD | FSI_SOLICIT_SOURCE_CD |
Standard Industrial Classification Code | FSI_SIC_CD | FSI_SIC_CD |
Student Year in School | FSI_STUDENT_YR_IN_SCHOOL_CD | FSI_STUDENT_YR_IN_SCHOOL_CD |
Swap Class | FSI_SWAP_CLASS_CD | FSI_SWAP_CLASS_CD |