| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | GUID | Unique Key for Identification of Notification | nvarchar | 32 | 0 | | | | Allow NULL? |
| 3 | PERNR | DEUEV: Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 4 | JAHR | DEUEV Notification Year | nvarchar | 4 | 0 | | | | Allow NULL? |
| 5 | MNR | DEUEV Notification Number | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | MDTYP | Notification Type of DEUEV Immediate Notification | char | 1 | 0 | | | | Allow NULL? |
| 7 | STATUS | Status Indicator for DEUEV Immediate Notifications | nvarchar | 2 | 0 | | | | Allow NULL? |
| 8 | MZBEG | DEUEV Start of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 9 | MZEND | DEUEV End of Notification Period | nvarchar | 8 | 0 | | | | Allow NULL? |
| 10 | GRUND | Submission Reason for DEUEV Notification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | GUID_STORN | GUID of Reversed Notification | nvarchar | 32 | 0 | | | | Allow NULL? |
| 12 | GUID_CNECT | GUID of Linked Notification | nvarchar | 32 | 0 | | | | Allow NULL? |
| 13 | DATUM | Creation/Change Date of Notification | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | UZEIT | Creation/Change Time of a Notification | nvarchar | 6 | 0 | | | | Allow NULL? |
| 15 | REPORT | Program Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 16 | EUSER | User Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 17 | WERKS | Sender or Recipient of Notification (Personnel Area) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | BTRTL | Sender or Recipient of Notification (Personnel Subarea) | nvarchar | 4 | 0 | | | | Allow NULL? |
| 19 | KKART | Type of Organizational Unit of Health Insurance Fund | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | BTRNR | Company Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | PABRP | Payroll period for determining time period | nvarchar | 2 | 0 | | | | Allow NULL? |
| 22 | PABRJ | Payroll year for determining time period | nvarchar | 4 | 0 | | | | Allow NULL? |
| 23 | ADATUM | Date of Evaluation | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | STORNMNR | HR-DDU: Number of Reversed Notification | nvarchar | 4 | 0 | | | | Allow NULL? |
| 25 | GDINT | HR-DDU: Internal Reason for Deduction | nvarchar | 2 | 0 | | | | Allow NULL? |
| 26 | D3TYP | HR-DDU: Processing Type | char | 1 | 0 | | | | Allow NULL? |