| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | GUID | Unique Key for Identification of Notification | nvarchar | 32 | 0 | CHAR | (N' ') | No | | PDE_PBS_VLTSV_P10_GUID | Allow NULL? |
| 3 | PERNR | Personnel Number | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | PERNR_D | Allow NULL? |
| 4 | MELDUNGSTYP | Notific. Type of Change Notification for Sec.10 VersStaatsV | char | 1 | 0 | NUMC | (N'0') | Yes | | PDE_PBS_VLTSV_P10_MELDUNGSTYP | Allow NULL? |
| 5 | DH_FRUEHER | Previous Public Sector Employer | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PDE_PBS_VLTSV_FRUEHERER_DH | Allow NULL? |
| 6 | ABRST | Accounting Office | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | PDE_PBS_VLTSV_ABRST | Allow NULL? |
| 7 | STORNO_FRUEH_DH | Complete Reversal of Case for Earlier Public Sector Employer | char | 1 | 0 | CHAR | (N' ') | Yes | | PDE_PBS_VLTSV_STORNO_FRUEH_DH | Allow NULL? |
| 8 | STATUS | Status of Notifications Regarding Sec.10 VLTSV | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | PDE_PBS_VLTSV_STATUS | Allow NULL? |
| 9 | MELDEZEITR_BEGDA | Start Date of Change Notifications Acc.to Sec.10 VersStaatsV | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PDE_PBS_VLTSV_P10_MELDE_BEGDA | Allow NULL? |
| 10 | MELDEZEITR_ENDDA | End Date of Change Notifications Acc. to Sec.10 VersStaatsV | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PDE_PBS_VLTSV_P10_MELDE_ENDDA | Allow NULL? |
| 11 | WERKS | Personnel Area | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | PERSA | Allow NULL? |
| 12 | BTRTL | Personnel Subarea | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | BTRTL | Allow NULL? |
| 13 | AUSWERT_DATUM | Evaluation Date for Notif. Creation Acc. Sec.10 VersStaatsV | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | PDE_PBS_VLTSV_P10_AUSW_DATUM | Allow NULL? |
| 14 | ABRST_ANART | Address Type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ANART | Allow NULL? |
