Department
| DIM.Department View | DIM.DimDepartment Table | staging.department View (Silver LH) | Source Table.Column | Comments |
|---|---|---|---|---|
SKDepartmentID |
SKDepartmentID |
n/a | n/a | Surrogate key, generated in load.usp_dimdepartment (max existing + row_number). |
RecID |
RecID |
recid |
dirpartytable.recid |
The department party record, reached via dimensionattributevaluecombination.department. |
Department Code - Name |
derived | n/a | n/a | Built in the DIM view as DepartmentCode + ' - ' + LocalDepartment. |
Department Code |
DepartmentCode |
departmentcode |
dimensionattributevaluecombination.departmentvalue |
The Department financial dimension value. |
Department |
LocalDepartment |
localdepartment |
svsmasterdimensionmapping.dream_dept |
MDM. Matched on department code + company code. |
Central Department |
Department |
department |
dirpartytable.name |
Central (English) department name. |
LocalDepartment |
LocalDepartment |
localdepartment |
svsmasterdimensionmapping.dream_dept |
MDM. Same source as Department above, exposed unaliased. |
CompanyCode |
CompanyCode |
companycode |
dirpartytable.dataarea |
|
Country |
Country |
country |
logisticsaddresscountryregiontranslation.shortname |
Division
| DIM.Division View | DIM.DimDivision Table | staging.division View (Silver LH) | Source Table.Column | Comments |
|---|---|---|---|---|
SKDivisionID |
SKDivisionID |
n/a | n/a | Surrogate key, generated in load.usp_dimdivision. |
RecID |
RecID |
recid |
svsmasterdimensionmapping.recid |
MDM row id. |
Division Code |
DivisionCode |
divisioncode |
svsmasterdimensionmapping.division |
|
Division |
Division |
division |
svsmasterdimensionmapping.title |
|
Company Code |
CompanyCode |
companycode |
svsmasterdimensionmapping.dataareaid |
|
Title |
Title |
title |
svsmasterdimensionmapping.title |
|
Division Translated |
DivisionTranslated |
divisiontranslated |
dimensionfinancialtagtranslation.description |
Links not working. |