| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
|---|
| 1 | ZEREC_DATA_TRANS | Staging table for holding transferred Data | 5 | HIRE_DATE | System Date | nvarchar | 8 | 0 | | |
| TOPE-Recruiting |
| 2 | HRP5140 | DB Table for Infotype 5140 | 34 | HIRE_DATE | Hiring Date | nvarchar | 8 | 0 | | |
| TOPSwitzerland |
| 3 | PA0600 | HR Master Data Record Infotype 0600 | 33 | HIRE_DATE | Entry Date | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Application |
| 4 | WFAEM_START_DATE | Start date of the employee | 4 | HIRE_DATE | System Date | nvarchar | 8 | 0 | | |
| 5 | WFA_AGENT | Agent Details Table - Non-Versioned | 4 | HIRE_DATE | Hire Date | nvarchar | 8 | 0 | | |
| 6 | WFA_AGT_HIST | Agent History | 16 | HIRE_DATE | Hire Date | nvarchar | 8 | 0 | | |
| TOPWorkforce Management Core |
| 7 | WFDBP_000 | Bupa Specific WFD attributes | 3 | HIRE_DATE | Hire date | nvarchar | 8 | 0 | | |
| 8 | WFMCAS_AGENT | Agent Details Table - Non-Versioned | 4 | HIRE_DATE | Hire Date | nvarchar | 8 | 0 | | |
| 9 | WFMCAS_AGT_HIST | Agent History | 16 | HIRE_DATE | Hire Date | nvarchar | 8 | 0 | | |
| 10 | WFMEM_START_DATE | Start date of the employee | 4 | HIRE_DATE | System Date | nvarchar | 8 | 0 | | |
