Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee
| Property Name | Value |
| Comments | This is a bad design for the trxn system. Pressure those guys to capture explicitly the employment end date. Capture initial history from EmployeeDepartmentHistory. |
| Description | Date employment ended; 12/31/9999 if a current employee |
| Display Name | EmploymentEndDate |
| ETL Rules | Capture event when CurrentInd switches to zero. In the absence of better info, it's the ModifiedDate of the row when the change occurs. |
| Is Audit Subsystem | |
| SCD Type | 2 |
| Source System | Derived |
| Table Type | |
| Used in schemas | |
| View Name |