Tempo Financial Manager | Mobility Stream Documentation

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

Table Details

F4J_TEMPOFINANCIALMANAGER_BILLING_RATES_TABLES

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

Column	Type	Description
ID	VARCHAR	Table identifier in Tempo Financial Manager
NAME	VARCHAR	Billing rates table name

F4J_TEMPOFINANCIALMANAGER_BILLING_RATES_TABLE_RATES

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

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

F4J_TEMPOFINANCIALMANAGER_BUDGET_MILESTONES

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

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

F4J_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	VARCHAR	Rate category

F4J_TEMPOFINANCIALMANAGER_PORTFOLIO_PROJECTS

This table contains relating projects to portfolios.

Column	Type	Description
PORTFOLIOID	VARCHAR	Portfolio identifier
PROJECTID	VARCHAR	Project identifier

F4J_TEMPOFINANCIALMANAGER_PORTFOLIOS

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_ATTRIBUTE_VALUES

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_ATTRIBUTES

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_EXPENSE_ACTUALS

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_EXPENSES

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_FINANCIAL_SUMMARY

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_FIXED_REVENUES

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_LABOR_ACTUALS

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECT_PLANNED_LABOR

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

Column	Type	Description
PROJECTID	VARCHAR	Project identifier
ACCOUNTKEY	VARCHAR	Account key
BILLINGRATEVALUE	DECIMAL	Labor billing rate value
BILLINGRATECURRENCYCODE	VARCHAR	Code for currency type used in billing rate
COSTVALUE	DECIMAL	Labor cost value
COSTCURRENCYCODE	VARCHAR	Code for currency type used in cost
COSTRATEVALUE	DECIMAL	Labor cost rate value
COSTRATECURRENCYCODE	VARCHAR	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	VARCHAR	Code for currency type used in revenue value
TASKORIGINID	VARCHAR	Identifier for task from source system
TASKECOSYSTEM	VARCHAR	Task source system code
USERID	VARCHAR	Identifier for user associated with this labor
USERROLE	VARCHAR	Role of user associated with this labor

F4J_TEMPOFINANCIALMANAGER_PROJECT_SCOPE_TASKS

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

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

F4J_TEMPOFINANCIALMANAGER_PROJECTS

This table contains information on projects in Tempo Financial Manager.

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

F4J_TEMPOFINANCIALMANAGER_TEAM_MEMBER_RATES

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

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

F4J_TEMPOFINANCIALMANAGER_TEAM_MEMBERS

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

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

F4J_TEMPOUSERS_MAP

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

Column	Type	Description
ID	VARCHAR	Tempo Financial Manager user identifier
ORIGINID	VARCHAR	Source system user identifier
ECOSYSTEM	VARCHAR	User source system code