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.