| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | DCT_PERNR | Personnel Number | nvarchar | 8 | 0 | | | | Allow NULL? |
| 3 | DCT_SEQNR | Sequence Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 4 | DCT_ROWID | Unique Row Number | nvarchar | 5 | 0 | | | | Allow NULL? |
| 5 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | KAD | KAD | nvarchar | 5 | 0 | | | | Allow NULL? |
| 8 | SPIKA | Specialty IKA | nvarchar | 12 | 0 | | | | Allow NULL? |
| 9 | SPINS | Special Insurance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | KPK | KPK | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | DEPAR | Department IKA | nvarchar | 4 | 0 | | | | Allow NULL? |
| 12 | ALLDA | All Working Days | char | 1 | 0 | | | | Allow NULL? |
| 13 | FSCHD | Full Time Schedule | char | 1 | 0 | | | | Allow NULL? |
| 14 | AMKA | AMKA | nvarchar | 18 | 0 | | | | Allow NULL? |
| 15 | TYINS | Type of Insurance | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | RGIKA | Registration Number IKA | nvarchar | 18 | 0 | | | | Allow NULL? |
| 17 | SIF01 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 18 | ENT01 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 19 | EN201 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 20 | DGR01 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 21 | SIF02 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | ENT02 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | EN202 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 24 | DGR02 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 25 | SIF03 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 26 | ENT03 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | EN203 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 28 | DGR03 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 29 | SIF04 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 30 | ENT04 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 31 | EN204 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 32 | DGR04 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 33 | SIF05 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 34 | ENT05 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | EN205 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 36 | DGR05 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 37 | SIF06 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 38 | ENT06 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 39 | EN206 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 40 | DGR06 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 41 | SIF07 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 42 | ENT07 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 43 | EN207 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 44 | DGR07 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 45 | SIF08 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 46 | ENT08 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 47 | EN208 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 48 | DGR08 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 49 | SIF09 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 50 | ENT09 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 51 | EN209 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | DGR09 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 53 | SIF10 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 54 | ENT10 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 55 | EN210 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 56 | DGR10 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 57 | SIF11 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 58 | ENT11 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 59 | EN211 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 60 | DGR11 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 61 | SIF12 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 62 | ENT12 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 63 | EN212 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 64 | DGR12 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 65 | SIF13 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 66 | ENT13 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 67 | EN213 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 68 | DGR13 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 69 | SIF14 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 70 | ENT14 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 71 | EN214 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 72 | DGR14 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |
| 73 | SIF15 | Social Insurance Fund | nvarchar | 4 | 0 | | | | Allow NULL? |
| 74 | ENT15 | Entry Date in SI Fund | nvarchar | 8 | 0 | | | | Allow NULL? |
| 75 | EN215 | 2nd Entry Date in Fund(TSMEDE) | nvarchar | 8 | 0 | | | | Allow NULL? |
| 76 | DGR15 | Date of Degree | nvarchar | 8 | 0 | | | | Allow NULL? |