Title

satori-group-logo.gif

Used as the core source for loading the Title dimension.  It maintains a list of all titles of the employees for Planning purposes,  which might include, partner, associate, paralegal, etc.  In the case of associates, the associate might be indicated by year (e.g., Associate_2008) or length of employment (e.g., Associate_One would be in their first year, Associate_Two in their second year, etc.).

Idx

Field Type Maximum Length Required
1 Title_Code Alphanumeric 50 Yes
2 Title_Name Alphanumeric 50 Yes
3 Title_Rollup_1 Alphanumeric 50 No
4 Title_Rollup_2 Alphanumeric 50 No
5 Title_Rollup_3 Alphanumeric 50 No

 

Summary

Title

Used as the core source for loading the Title dimension.

Columns

 

Title_Code

The uniquely identifying employee title code. Required.

Title_Name

Description of the title code. Required.

Rollup Columns

 

Title_Rollup_1

Top level hierarchy the title rolls into for reporting purposes. Optional.

Title_Rollup_2

Second level hierarchy the title rolls into for reporting purposes. Optional.

Title_Rollup_3

Third level hierarchy the title rolls into for reporting purposes. Optional.

Documentation

 

Sample CSV Load File

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

Sample CSV Load File

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

Filename: Title.csv

Associate,Associate,,,
Counsel,Counsel,,,
Dir Legal Sup,Dir Legal Sup,,,
Non Legal Staff,Non Legal Staff,,,
Of Counsel,Of Counsel,,,
Paralegal,Paralegal,,,
Partner,Partner,,,
Senior Counsel,Senior Counsel,,,

Columns

Title_Code

Title_Code varchar(

50

) NOT NULL

The uniquely identifying employee title code. Required.

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
Required Yes

Title_Name

Title_Name varchar(

50

) NOT NULL

Description of the title code. Required.

 

 

Field Load File Format
Type Alphanumeric
Maximum Length 50
Required Yes

Rollup Columns

Title_Rollup_1

Title_Rollup_1 varchar(

50

) NULL

Top level hierarchy the title 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.

Title_Rollup_2

Title_Rollup_2 varchar(

50

) NULL

Second level hierarchy the title 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.

Title_Rollup_3

Title_Rollup_3 varchar(

50

) NULL

Third level hierarchy the title 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.