The Tango Data Mart provides SQL database access to a customer’s information. The database follows a dimension and fact model.

Connection Information

Data Mart is an online data store with SQL database access to a customer’s information.

Host Information

The Data Mart IP for access will be shared via Support Ticket as requested (if subscribed to Datamart).

Authentication

Access to Data Mart is provided through a SQL-authenticated user ID and password. User credentials will be provided via secure email.

Refresh Timing

The Data Mart is currently refreshed (full load) between 04:30 Eastern Time and 06:00 Eastern Time each day.

Summary of Objects

Below is a visual representation of the various objects in Data Mart.

DIMENSION TABLES:

• D_LEASE_PORTFOLIO_TYPES

• D_LEASE_TYPE_CODE

• D_LEASE_FINANCIALS_GROUPS

• D_LEASE_ACCT_CLASSIFICATION

• D_LEASE_LEGAL_ENTITIES

• D_LEASE_TENANCY_TYPES

• D_LEASE_SCH_ACCT_STNDRD

• D_LEASE_STATUSES

• D_LEASES

• D_LEASE_SUPPLIERS

• DM_SUPPLIER_SITE_CONTACTS

       

DM_LEASE_PAYMENTS

• DM_LEASE_BILLINGS

   

• DM_LEASE_LOC 

• DM_ADHOC_TASKS 

1. FACT TABLES.

   • F_LEASE_COUNTS 

   • F_LEASE_FINANCIALS 

   • F_LEASE_EXPENSES 

   • F_LEASE_COST_PROJECTIONS 

   • F_LEASE_PAYMENTS 

   • F_LEASE_OPTION_ATTR 

   • F_LEASE_LEGAL_ATTR 

   • F_LEASE_FINANCIALS_ATTR 

   • F_LEASE_CO_TEN_ATTR 

   • F_LEASE_INSURANCE_ATTR 

   • F_LEASE_PCT_RENT 

   • F_LEASE_PCT_RENT_BP 

   • F_LEASE_PCT_RENT_CALC 

   • F_LEASE_ACCRUALS 

   • F_LEASE_PCT_RENT_SALESRENT_CALC 

   • F_LEASE_WRKSHT_SUMMARY 

   • F_LEASE_OBL_ATTR 

   • F_LEASE_WRKSHT_DETAIL 

   • F_LEASE_AMENDMENTS 

   • F_LEASE_COST_ALLOCATIONS 

   • F_LEASE_CO_TEN_TENANTS 

   • F_LEASE_OFFSETS 

   • F_LEASE_CHECK_INFO 

   • F_CHECK_DISBURSEMENTS 

   • F_LEASE_PAYMENT_BATCHES 

   • F_LEASE_SALES_SETUP 

   • F_LEASE_ACCT_SCHEDULES 

   • F_LEASE_ACCT_SCHEDULES_OPER 

   • F_LEASE_ACCT_SCHEDULES_FIN 

   • F_DMS_FILES 

   • F_LEASE_EXP_REC 

   • F_LEASE_EXP_REC_TMPLT 

   • F_LEASE_EXP_REC_SUM 

   • F_LEASE_OPTION_RENT 

   • F_TRANSACTIONS 

   • F_TRANS_SAVING_ANALYSIS 

   • F_LEASE_SUPPLIER_CONTACTS 

   • F_LEASE_SUPPLIERS