Database Integration FAQs

Load Files

What is the correct format of the load files?

Each load file is described in detail in the Creating the Load files section.


How do the load files get uploaded into the application?

The load files can be uploaded using the Data Integration Utility either using the interactive web application or automated monitor utility.  Refer to each section for more details.   


How do we notify the cubes that the load files have been posted and it's time to perform the data operations?

The interface handles the loading of the cubes after all the data files have been loaded.


Where does the database and cube used for Planning reside?  

The Planning database and cubes reside on the Virtual Appliance supplied by Satori.


How many years of data will we need to provide?  Should it include data only for the current year, a few, recent years, or every year?

The current and prior year for General Ledger data, and the current year for everything else.



What are rollups?

Rollups enable you to create a hierarchical structure for reporting within any dimension.  The rollups for the account dimension can be based on the natural account ranges.  Thus, rollups can be defined as ranges of accounts. For example, a range of accounts from 5000 to 5199 might go into a summary account called ‘Salaries’.  The next level might  be ‘Salaries and Employee Benefits, with the next higher levels ‘Total Compensation Expenses, ‘Operating Expenses’, ‘Total Expenses’, and the top level ‘Net Income’.

Most dimensions include rollups, which can optionally be populated if you have reporting hierarchies to load from your source system.


In the Account CSV, is the Account Code the combination of the all the accounts segments from the GL table?

The Account code is only the natural account code.


Are we required to provide every General Ledge Account number, or just active (current) ones?

It is only necessary to load active accounts.  However, this should be all accounts that had a balance in the current and prior years.


Asset Class and Asset Data


In the Asset_Class  CSV files, where is this list coming from?

This is the list of asset classes that are used  to identify the different types of assets categories and used to calculate the depreciation within the budget application.  This list can come from your Fixed Asset Register.


Where does the Asset_Data CSV file come from?

The source data for the Asset_Data can come directly from your current Fixed Asset System.  This data, combined with the Capital Expenditure module, is used to calculate the depreciation cost of current and planned assets in the Planning application.  


Employee Data

In the Employee CSV, does the class year refer to the graduation date or the bar date of the employee (or something else entirely)?

This is generally the graduation (JD) year. This is sometimes used to define different associate levels as a customization. The field is included to aid in the customization if necessary. If your firm does not want to include class year distinctions for associates, then this is not necessary.


In the Employee_Data CSV, do the hire and termination dates need to be in a special format, or can they be in whatever format my database provides them?

The dates should be provided in SQL date time format (e.g., 1985-09-16).


In the Employee_Data CSV, do Hours refer to hours billed by date billed?

Hours worked by date worked on billable matters only.



 In the FTE_Data csv, what does FTE mean?  

 FTE means Full Time Equivalent.


What are the equations used to determine the FTE and Headcount values?  

Headcount is 1 or 0, and FTE is a decimal value ranging from 0 - 1 (e.g., .5).


In the FTE_Data csv, for PG_Dept_Code, is this based on the employee's department or primary practice group or both?  

It is up to your firm to decide which makes the most sense in your budget (department or timekeeper section).  It is important that the one you select is also used as a segment in the GL, so that there is a match between the timekeeper revenue and compensation and the GL.


General Ledger (GL)

In the GL_Data csv, where should the contents of this table come from?

For the current and prior year actuals, if detail data is required including all of the drill-through fields (batch id, vendor, etc.), then this data should be sources from your General Ledger transaction tables.  If only summary level is required, the data can be sources from the General Ledger summary tables.  Budget data typically resides only in one location.

For example if using Elite, this data would come from the gj, apvodt, and csddt tables.  However is  no detail data is required, then glamt can be used. For the current year budget, the glamt table would be used to pull the budget data.


In the GL_Data csv, what is version?

Version represents either Actual or Budget data.


In the GL_Data csv, if we are using only one currency, would there be any reason for local, native, and base values to be different?

If only using a single currency, these values would be the same.  If using a single currency, only the local values are required..


In the GL_Data csv, is the office code based on the employee?  Is the PG_Dept_code also based on the employee?

In the GL_Data import, the office and pg/dept should be that from the GL account segmentation. There should be a relationship between those and the offices/pg departments that employees are assigned to as well.


Practice Group (PG)

The PG_Dept csv table is a combination of departments and practice groups.  Since each practice group rollups to a department, do you use the rollup fields to show this relationship?

This needs to be whichever level is used for recording journal entries in the GL. It is important that there is a link between the employee assignments as well, so that the compensation and revenue budgets can be mapped from the timekeeper level to the appropriate place in the GL.



In the TK_Rates csv, what if we change rates mid year?  Which rate do we use, or do we submit multiple rates per employee per year?

Only one rate per employee per year (point in time data) is needed.  This can either be the standard rate or the worked rate.



In the Salary csv, is there any reason why the local and base salary would be different?

Unless you are using multi-currency, salary should only be entered into Local.


 In the WIP_AR csv, which office and pg/dept do we use?  Is it based on matter, billing attorney, working attorney?

Since the budget is created at a working attorney level, this data should be based on the working attorney because all of the budget revenue calculations are performed at this level,






Please sign in to leave a comment.
Powered by Zendesk