Department

The Department dimension is available in the Default Subject Area, but not in the Custom Subject Areas. It is only used as parent for role-playing dimensions.

This table shows the tables from which fields are retrieved for the dimension:

Table	Description
tccom001	Employees - General
tccom130	Addresses
tccom139	Cities by Country
tcemm030	Enterprise Units
tcemm050	Sites
tcemm100	Time Zones
tcemm170	Companies
tcmcs010	Countries
tcmcs065	Departments
tcmcs143	States/Provinces

This table shows the attribute mapping for the dimension:

Attribute	Mapping
City	tccom130.ccit
City Desc	tccom139.dsca
Company	Logical company of tcmcs065
Country	tccom130.ccty
Country Desc	tcmcs010.dsca
Department	tcmcs065.cwoc
Department Desc	tcmcs065.dsca
Department ID Desc	tcmcs065.cwoc + tcmcs065.dsca
Department Type	tcmcs065.typd
Department Type Filter	tcmcs065.typd
Department Type Sort	tcmcs065.typd
Enterprise Unit	tcemm030.eunt
Enterprise Unit Desc	tcemm030.dsca
EU Member State	tcmcs010.meec
EU Member State Filter	tcmcs010.meec
EU Member State Sort	tcmcs010.meec
Financial Company	tcmcs065.comp
Financial Company Desc	tcemm170.desc
GPS Latitude	tccom130.glat
GPS Location	Geo attribute combining GPS Latitude and GPS Longitude. Includes tooltip with Department Desc.
GPS Longitude	tccom130.glon
ISO Country Code Alpha-2	tcmcs010.ict2
Logistic Company	tcemm030.lcmp
Logistic Company Desc	tcemm170.desc
Manager	tcmcs065.emno
Manager Name	tccom001.nama
Service Department	1 if tcmcs065.cwoc = tsmdm100.cwoc. Else 0.
Site	tcmcs065.site
Site Desc	tcemm050.desc
State/Province	tccom130.cste
State Province Desc	tcmcs143.dsca
Time Zone	tcemm100.timz
Time Zone Code	tccom130.tzid
Time Zone Desc	tcemm100.dsca
Unknown	1 for null records, else 0
deleted	1 if deleted in LN, else 0
Customer Defined Fields	Standard list of fields

Address fields are included for tcmcs065.cadr.