Dict-Physical

View VMD_EmployeeStatus

Card of view VMD_EmployeeStatus

Name	VMD_EmployeeStatus
Comment	See MD_EmployeeStatus.
Dimensional Type	Dimension

SQL query of the view VMD_EmployeeStatus

select
MD_EmpStat_SurrogateKey,
MD_EmpStat_Code,
MD_EmpStat_Status
from
MD_EmployeeStatus

List of incoming view references of the view VMD_EmployeeStatus

ViewReference_77

VMF_PerPosition

List of diagrams containing the view VMD_EmployeeStatus

ViewsEmployeeDiagram

List of permissions of the view VMD_EmployeeStatus

SELECT,VIEW DEFINITION

BusinessReader

SELECT,VIEW DEFINITION

EmployeeReader

List of view columns of the view VMD_EmployeeStatus

MD_EmpStat_SurrogateKey

numeric

MD_EmpStat_Code

varchar(16)

Code like FS, EM, etc. representing an employee's status. Please don't use codes in reports. It's great for people who have been forced to use them, and who therefore know them, but they're real stinkers for everyone else.

MD_EmpStat_Status

varchar(32)

Full name or 'description' of an employee's status. Use this in preference to the MD_EmpStat_Code if possible, so normal people (sorry, IT folks and HR specialists) can understand your reports.