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 |