The following table describes the required load files used as the core source for loading each dimension. For more information about each load file, click the link. Required Load File Description Account (Account.csv) List of all the Natural General Ledger accounts for the organization. Currency (Currency.csv) List of all currency types associated to the offices found in Office. Only applies to firms dealing in multiple currencies. Employee (Employee.csv) List of all employees/timekeepers for the organization that is used. Employee_Data (Employee_Data.csv) Data for the current population of all employees. FTE_Data (FTE_Data.csv) Current population of all employees. GL_Class (GL_Class.csv) Used to assign proper signage (positive / negative) to accounts based on account type. GL_Data (GL_Data.csv) Primary source of General Ledger data used for loading the GL Journal Entries fact table and the Xchange GL Data cube. GL_Type (GL_Type.csv) Commonly referred to as "Books" in the accounting system. Essentially, this differentiates the set of books and the way data is recorded, i.e., Cash, Accrual. Office (Office.csv) List of the offices for the organization. For the purpose of the Planning application, both organizations and locations are maintained in a single dimension. In such cases, the Office dimension is essentially a combination of organization and office location. PG_Dept (PG_Dept.csv) List of the practice groups/departments for the organization. For the purpose of the Planning application, both practice groups and departments are maintained in a single dimension. In such cases, the Practice Group dimension is essentially a combination of practice group and department. Salary (Salary.csv) Loads annual salary into the Employee Data fact table and Employee Data cube. This table is separately maintained as salary information often exists in a source system other than the ERP system. Title (Title.csv) List of all titles of the employees for Planning purposes, which might include partner, associate, paralegal, etc. TK_Rates_Data (TK_Rates_Data.csv) Used for loading the Timekeeper Rates fact table and the Xchange Timekeeper Rates cube in Planning. WIP_AR_Data (WIP_AR_Data.csv) Current and Historical WIP, A/R, Worked Value, and Billings used to calculate Budgeted Billing and Collections by year, period, office, and department in the Cash Cycle Module. This is the core source for loading the WIP AR fact table and the Xchange WIP AR cube in Planning.