Tempo Financial Manager | Mobility Stream Documentation

The Tempo Financial Manager additional export populates 19 tables in Databricks:

Table Details

D4J_TEMPOFINANCIALMANAGER_BILLING_RATES_TABLES

This table contains information related to the billing rates tables defined in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Table identifier in Tempo Financial Manager
NAME	STRING	Billing rates table name

D4J_TEMPOFINANCIALMANAGER_BILLING_RATES_TABLE_RATES

This table contains the billing rates used for the roles in the billing rates tables.

Column	Type	Description
BILLINGRATESTABLEID	STRING	Table identifier in Tempo Financial Manager
RATEVALUE	DECIMAL	Billing rate
DEFAULTRATEUSED	BOOLEAN	Flag for whether the default rate is being used
ROLEID	INT	Role identifier

D4J_TEMPOFINANCIALMANAGER_BUDGET_MILESTONES

This table contains information related to the budget milestones defined in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Budget milestone identifier in Tempo Financial Manager
PROJECTID	STRING	Tempo Project identifier
DATE	DATE	Budget milestone date
DESCRIPTION	STRING	Budget milestone description
BUDGETVALUE	DECIMAL	Budget value
BUDGETCURRENCYCODE	STRING	Code for currency type used in budget value

D4J_TEMPOFINANCIALMANAGER_GLOBAL_RATES

This table contains the global rates for roles defined in Tempo Financial Manager.

Column	Type	Description
ROLEID	INT	Role identifier
RATEVALUE	DECIMAL	Rate value
RATEEFFECTIVEDATE	DATE	Effective date of rate
RATECATEGORY	STRING	Rate category

D4J_TEMPOFINANCIALMANAGER_PORTFOLIO_PROJECTS

This table contains relating projects to portfolios.

Column	Type	Description
PORTFOLIOID	STRING	Portfolio identifier
PROJECTID	STRING	Project identifier

D4J_TEMPOFINANCIALMANAGER_PORTFOLIOS

This table contains information related to the portfolios defined in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Portfolio identifier
NAME	STRING	Portfolio name
DESCRIPTION	STRING	Portfolio description
COLORKEY	STRING	Portfolio color key
SHARED	BOOLEAN	Flag for whether this portfolio is shared
EDITABLE	BOOLEAN	Flag for whether this portfolio is editable
STAFFCOUNT	INT	Portfolio staff count
TOTALTIMESPENTSECONDS	INT	Total time logged for this portfolio, in seconds
OWNERID	STRING	Identifier for owner of this portfolio

D4J_TEMPOFINANCIALMANAGER_PROJECT_ATTRIBUTE_VALUES

This table contains information about the attribute values defined for projects in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Value identifier in Tempo Financial Manager
PROJECTID	STRING	Project identifier
TYPE	STRING	Attribute value type
INPUTID	STRING	Attribute value input identifier
INPUTNAME	STRING	Attribute value input name
INPUTVALUE	STRING	Attribute input value

D4J_TEMPOFINANCIALMANAGER_PROJECT_ATTRIBUTES

This table contains information about the attributes defined for projects in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Attribute identifier
NAME	STRING	Attribute name
TYPE	STRING	Attribute type
SELECTLISTOPTIONS	STRING	Options defined for attribute (select list type)

D4J_TEMPOFINANCIALMANAGER_PROJECT_EXPENSE_ACTUALS

This table contains information on actual expenses recorded for projects in Tempo Financial Manager.

Column	Type	Description
EXPENSEID	STRING	Expense identifier
PROJECTID	STRING	Project identifier
DATE	DATE	Expense date
COSTVALUE	DECIMAL	Expense cost value
COSTCURRENCYCODE	STRING	Code for currency type used in cost value

D4J_TEMPOFINANCIALMANAGER_PROJECT_EXPENSES

This table contains information on planned single or recurring expenses for projects in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Expense identifier
PROJECTID	STRING	Project identifier
DESCRIPTION	STRING	Expense description
CATEGORYNAME	STRING	Expense category name
DATE	DATE	Expense date
AMOUNTVALUE	DECIMAL	Expense amount value
AMOUNTCURRENCYCODE	STRING	Code for currency type used in amount value
RECURRENCETYPE	STRING	Expense recurrence type
RECURRENCEMONTHLYBY	STRING	Recurring expense monthly by value
RECURRENCEINTERVAL	INT	Recurring expense interval
RECURRENCEENDDATE	DATE	Recurring expense end date
ACCOUNTKEY	STRING	Associated account key

D4J_TEMPOFINANCIALMANAGER_PROJECT_FINANCIAL_SUMMARY

This table contains financial summary data for projects in Tempo Financial Manager.

Column	Type	Description
PROJECTID	STRING	Project identifier
SUMMARYDATE	DATE	Date of financial summary data
COSTBUDGETVALUE	DECIMAL	Cost budget value
COSTBUDGETCURRENCYCODE	STRING	Code for currency type used in cost budget
COSTACTUALLABORVALUE	DECIMAL	Cost actual labor value
COSTACTUALLABORCURRENCYCODE	STRING	Code for currency type used in cost actual labor value
COSTACTUALEXPENSEVALUE	DECIMAL	Cost actual expense value
COSTACTUALEXPENSECURRENCYCODE	STRING	Code for currency type used in actual expense value
COSTACTUALTOTALVALUE	DECIMAL	Cost actual total value
COSTACTUALTOTALCURRENCYCODE	STRING	Code for currency type used in actual total value
COSTACTUALREMAININGBUDGETVALUE	DECIMAL	Cost actual remaining budget value
COSTACTUALREMAININGBUDGETCURRENCYCODE	STRING	Code for currency type used in actual remaining budget value
REVENUEACTUALLABORVALUE	DECIMAL	Revenue actual labor value
REVENUEACTUALLABORCURRENCYCODE	STRING	Code for currency type used in revenue actual labor value
REVENUEACTUALFIXEDREVENUEVALUE	DECIMAL	Revenue actual fixed revenue value
REVENUEACTUALFIXEDREVENUECURRENCYCODE	STRING	Code for currency type used in revenue actual fixed revenue value
REVENUEACTUALTOTALVALUE	DECIMAL	Revenue actual total value
REVENUEACTUALTOTALCURRENCYCODE	STRING	Code for currency type used in revenue actual total value
REVENUEACTUALPROFITVALUE	DECIMAL	Revenue actual profit value
REVENUEACTUALPROFITCURRENCYCODE	STRING	Code for currency type used in revenue actual profit value
REVENUEACTUALNETPROFITMARGINVALUE	DECIMAL	Revenue actual net profit margin value

D4J_TEMPOFINANCIALMANAGER_PROJECT_FIXED_REVENUES

This table contains information on fixed revenues for projects in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Fixed revenue record identifier
PROJECTID	STRING	Project identifier
DESCRIPTION	STRING	Fixed revenue description
CATEGORYNAME	STRING	Fixed revenue category name
DATE	DATE	Fixed revenue date
AMOUNTVALUE	DECIMAL	Fixed revenue amount value
AMOUNTCURRENCYCODE	STRING	Code for currency type used in amount value
RECURRENCETYPE	STRING	Recurring revenue type
RECURRENCEMONTHLYBY	STRING	Recurring revenue monthly by
RECURRENCEINTERVAL	INT	Recurring revenue recurrence interval
RECURRENCEENDDATE	DATE	Recurring revenue end date
ACCOUNTKEY	STRING	Associated account key

D4J_TEMPOFINANCIALMANAGER_PROJECT_LABOR_ACTUALS

This table contains information on actual labor recorded for projects in Tempo Financial Manager.

Column	Type	Description
TIMERECORDID	STRING	Labor record identifier
PROJECTID	STRING	Project identifier
WORKLOGID	INT	Worklog identifier
DATE	DATE	Labor date
USERID	STRING	User associated with the labor
USERROLE	STRING	Role of user associated with the labor
TASKORIGINID	STRING	Identifier for task from source system
TASKECOSYSTEM	STRING	Task source system code
COSTRATEVALUE	DECIMAL	Labor cost rate value
COSTRATECURRENCYCODE	STRING	Code for currency type used in labor cost rate
TIMESPENTSECONDS	INT	Number of seconds logged for labor
COSTVALUE	DECIMAL	Labor cost value
COSTCURRENCYCODE	STRING	Code for currency type used in cost value
BILLINGRATEVALUE	DECIMAL	Billing rate value
BILLINGRATECURRENCYCODE	STRING	Code for currency type used in billing rate
BILLABLESECONDS	INT	Number of billable seconds for labor
REVENUEVALUE	DECIMAL	Revenue value of labor
REVENUECURRENCYCODE	STRING	Code for currency type used in revenue value

D4J_TEMPOFINANCIALMANAGER_PROJECT_PLANNED_LABOR

This table contains information on labor planned for projects in Tempo Financial Manager.

Column	Type	Description
PROJECTID	STRING	Project identifier
ACCOUNTKEY	STRING	Account key
BILLINGRATEVALUE	DECIMAL	Labor billing rate value
BILLINGRATECURRENCYCODE	STRING	Code for currency type used in billing rate
COSTVALUE	DECIMAL	Labor cost value
COSTCURRENCYCODE	STRING	Code for currency type used in cost
COSTRATEVALUE	DECIMAL	Labor cost rate value
COSTRATECURRENCYCODE	STRING	Code for currency type used in cost rate
DATE	DATE	Labor date
PLANID	INT	Labor plan identifier
PLANNEDSECONDS	INT	Planned labor time, in seconds
REVENUEVALUE	DECIMAL	Revenue value
REVENUECURRENCYCODE	STRING	Code for currency type used in revenue value
TASKORIGINID	STRING	Identifier for task from source system
TASKECOSYSTEM	STRING	Task source system code
USERID	STRING	Identifier for user associated with this labor
USERROLE	STRING	Role of user associated with this labor

D4J_TEMPOFINANCIALMANAGER_PROJECT_SCOPE_TASKS

This table contains information on tasks associated with projects in Tempo Financial Manager.

Column	Type	Description
PROJECTID	STRING	Project identifier
TASKID	STRING	Task identifier
TASKORIGINID	STRING	Identifier for task from source system
TASKECOSYSTEM	STRING	Task source system code

D4J_TEMPOFINANCIALMANAGER_PROJECTS

This table contains information on projects in Tempo Financial Manager.

Column	Type	Description
TEMPOID	STRING	Project identifier
NAME	STRING	Project name
STATUS	STRING	Project status
TYPE	STRING	Project type
GENERALACCESS	STRING	Project general access code
OWNERID	STRING	User identifier for project owner
TAGS	STRING	Project tags
SCOPETYPE	STRING	Project scope type
SCOPEREFERENCE	STRING	Project scope reference
SCOPETITLE	STRING	Project scope title
SCOPEURL	STRING	Project scope URL
DEFAULTCOSTRATEVALUE	DECIMAL	Default cost rate
DEFAULTCOSTRATECURRENCYCODE	STRING	Code for currency type used in default cost rate
DEFAULTBILLINGRATEVALUE	DECIMAL	Default billing rate
DEFAULTBILLINGRATECURRENCYCODE	STRING	Code for currency type used in default billing rate
BUDGETAMOUNTVALUE	DECIMAL	Budget amount
BUDGETAMOUNTCURRENCYCODE	STRING	Code for currency type used in budget amount
TIMEFRAMESTARTDATE	DATE	Project timeframe start date
TIMEFRAMEENDDATE	DATE	Project timeframe end date
TIMEFRAMEISCALCULATED	BOOLEAN	Flag for whether project timeframe is calculated
EDITABLE	BOOLEAN	Flag for whether project is editable
ISTRACKINGREVENUE	BOOLEAN	Flag for whether project is tracking revenue
ISFIXEDPRICE	BOOLEAN	Flag for whether project is fixed price
ISUSINGAPPROVAL	BOOLEAN	Flag for whether project is using approval
ISUSINGGLOBALCOSTRATES	BOOLEAN	Flag for whether project is using global cost rates
ISUSINGACCOUNTRATES	BOOLEAN	Flag for whether project is using account rates

D4J_TEMPOFINANCIALMANAGER_TEAM_MEMBER_RATES

This table contains information on team member rates in projects in Tempo Financial Manager.

Column	Type	Description
TEAMMEMBERID	STRING	Team member identifier
PROJECTID	STRING	Project identifier
RATETYPE	STRING	Rate type code
RATEVALUE	DECIMAL	Rate
RATECURRENCYCODE	STRING	Code for currency type used in rate
RATESOURCE	STRING	Rate source code

D4J_TEMPOFINANCIALMANAGER_TEAM_MEMBERS

This table contains information on team members assigned to projects in Tempo Financial Manager.

Column	Type	Description
TEAMMEMBERID	STRING	Team member identifier
PROJECTID	STRING	Project identifier
ROLEID	STRING	Team member role identifier
ROLENAME	STRING	Team member role name

D4J_TEMPOUSERS_MAP

This table relates Tempo Financial Manager user identifiers to source system (eg, Jira) identifiers.

Column	Type	Description
TEMPOID	STRING	Tempo Financial Manager user identifier
ORIGINID	STRING	Source system user identifier
ECOSYSTEM	STRING	User source system code