| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
TOPGermany |
1 | PD3DBAN | HR-DDU: Address Data Module | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
2 | PD3DBEU | HR-DDU: Data Module - European Insurance Number | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
3 | PD3DBGB | HR-DDU: Data Module - Birth Details | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
4 | PD3DBKS | HR-DDU: Data Module - Miners'/Sailors' Insurance | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
5 | PD3DBME | HR-DDU: Reporting Facts Data Module | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
6 | PD3DBNA | HR-DDU: Name Data Module | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
7 | PD3DBSO | HR-DDU: Immediate Notification Data Module | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
8 | PD3DBSV | HR-DDU: Social Insurance Card Data Module | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
9 | PD3DBUV | DEUEV: Data Module DBUV - Accident Insurance | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
10 | PD3DBUV_DAT | DEUEV AI Data for Module DBUV - Accident Insurance | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
11 | PD3DSAP | HR-DDU: Administration Record for Notifications | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
12 | PD3DSME | HR-DDU: Data Record Notfication | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
13 | PD3FLAG | HR-DDU: Notifications Indicator | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
TOPHoliday Calendar, Factory Calendar, Appointment Calendar |
14 | T247 | Month name and short text | 2 | MNR | Month number | nvarchar | 2 | 0 | | |
15 | TFARSIMONTH | Names of months of Farsi calendar | 2 | MNR | Month number | nvarchar | 2 | 0 | | |
16 | TISLMONTH | name of months in Islamic calendar | 2 | MNR | Month number | nvarchar | 2 | 0 | | |
TOPSocial Insurance |
17 | P01BM_STAT | Control Records for PPO DEUEV Notifications | 5 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
18 | P01D3_DSAP | DEUEV Confirmation: Control Record for Notifications | 18 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
19 | P01DS_STAT | Control Records for DEUEV Immediate Notifications | 5 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
20 | P01EE_STAT | Admin. Records for Data Exchange for Compensation Benefits | 6 | MNR | Message Number | nvarchar | 4 | 0 | | |
21 | PD3DBKV | DEUEV: Data Module Health Insurance | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
22 | PD3HIST | Status History Management for DEUEV Notifications | 4 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | |
TOPStatements |
23 | P01W_ADMIN_01 | HR: Data Module: Administration for Health Insurance Funds | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
24 | P01W_DBAE | Data Module: Statement of Earnings - Remuneration | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
25 | P01W_DBAL | Data Module: Statement of Earnings - General | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
26 | P01W_DBAN | Data Module: Address | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
27 | P01W_DBEK | Data Module: Statement of Earnings for Sick Child | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
28 | P01W_DBFR | Data Module: Stmt of Earnings - Rel. from Work f. Sick Child | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
29 | P01W_DBFZ | Data Module: Stmt of Earnings - Absences w/o Remuneration | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
30 | P01W_DBKR | Data Module: Remuneration Statement for Sick Pay | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
31 | P01W_DBMU | Data Module: Statement of Earnings, Maternity Pay | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
32 | P01W_DBNA | Data Module: Name | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
33 | P01W_DBUN | Data Module: Statement of Earnings - Accident Data | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
34 | P01W_DBZE | Data Module: Statement of Earnings, Working Time, Sick Child | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
35 | P01W_DBZK | Data Module: Stmt of Earnings, Working Time for Sick Pay | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
36 | P01W_DSLW | Data Module: General Information | 5 | MNR | Message Number | nvarchar | 4 | 0 | | |
TOPUser and Authorization Management |
37 | TUL_ACRES | System Measurement: AC Results Table | 2 | MNR | GUID in 'RAW' format | varbinary | 16 | 0 | | |