PG_Dept

Used as the core source for loading the PG Dept dimension; it maintains a 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.  It is not unusual for firms to specify a department in GL. On the billing side, however, practice groups might be used instead of departments. For example, a practice group might be called Litigation based on the type of law being practiced. That practice group helps manage working attorneys. There may or may not be a one-to-one relationship between practice groups and departments in GL. Sometimes the practice group is called Litigation and that is where all the time is entered. In other cases, time is entered in a different area of law.

The PG department brings together entities from the revenue side and creates a Practice Group dimension that includes litigation, corporate, mergers and acquisitions, etc., along with admin support,  IT, and anything else on the GL side.

Idx Field Type Maximum Length Required
1 PG_Dept_Code Alphanumeric 20 Yes
2 PG_Dept_Name Alphanumeric 100 Yes
3 PG_Dept_Rollup_1 Alphanumeric 100 No
4 PG_Dept_Rollup_2 Alphanumeric 100 No
5 PG_Dept_Rollup_3 Alphanumeric 100 No

 

Summary

PG_Dept

Used as the core source for loading the PG Dept dimension; it maintains a list of the practice groups/departments for the organization.

Columns

 

PG_Dept_Code

Code that uniquely identifies this Practice Group / Department dimension record. Required.

PG_Dept_Name

Description of the Practice Group / Department.  This is used to create the Practice Group / Department member. Required.

Rollup Columns

 

PG_Dept_Rollup_1

Top level hierarchy the PG / Department rolls into for reporting purposes. Optional.

PG_Dept_Rollup_2

Second level hierarchy the PG / Department rolls into for reporting purposes. Optional.

PG_Dept_Rollup_3

Third level hierarchy the PG / Department rolls into for reporting purposes. Optional.

Documentation

 

Sample CSV Load File

This load file is a small sample of a PG_Dept load.

Sample CSV Load File

This load file is a small sample of a PG_Dept load.

Filename: PG_Dept.csv

007,Corporate,,,
022,Insurance,,,
023,Intellectual Property,,,
030,Litigation,,,
034,Lloyds Tax,,,
050,Real Estate,,,
065,Energy,,,
070,Unassigned,,,

Columns

PG_Dept_Code

PG_Dept_Code varchar(

20

) NOT NULL

Code that uniquely identifies this Practice Group / Department dimension record. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 20
Required Yes

PG_Dept_Name

PG_Dept_Name varchar(

100

) NOT NULL

Description of the Practice Group / Department.  This is used to create the Practice Group / Department member. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 100
Required Yes

Rollup Columns

PG_Dept_Rollup_1

PG_Dept_Rollup_1 varchar(

100

) NULL

Top level hierarchy the PG / Department rolls into for reporting purposes. Optional.

Records may be grouped into multiple rollups each separated by a separate rollup column.  Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level one.

PG_Dept_Rollup_2

PG_Dept_Rollup_2 varchar(

100

) NULL

Second level hierarchy the PG / Department rolls into for reporting purposes. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level two.

PG_Dept_Rollup_3

PG_Dept_Rollup_3 varchar(

100

) NULL

Third level hierarchy the PG / Department rolls into for reporting purposes. Optional.

Additionally, a hierarchy may exist within the dimension and systematically grouped into levels; in this case records grouped by this field will be at level three.

 

 

Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk