| 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 | CNTR3 | National assignment indicator | varbinary | 1 | 0 | | | | |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | SUBTY | Subtype | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | OBJPS | Object Identification | nvarchar | 2 | 0 | | | | Allow NULL? |
| 10 | FCNAM | Complete Name | nvarchar | 80 | 0 | | | | Allow NULL? |
| 11 | FGBDT | Date of Birth | nvarchar | 8 | 0 | | | | Allow NULL? |
| 12 | ICNUM | IC number | nvarchar | 20 | 0 | | | | Allow NULL? |
| 13 | ICTYP | Type of identification (IC type) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 14 | UFBOT | Region (State, Province, County) | nvarchar | 3 | 0 | | | | Allow NULL? |
| 15 | STINV | Challenged dependent indicator | char | 1 | 0 | | | | Allow NULL? |
| 16 | ESCOL | Education level | nvarchar | 2 | 0 | | | | Allow NULL? |
| 17 | SALFA | Eligibility indicator for child allowance | char | 1 | 0 | | | | Allow NULL? |
| 18 | IRFLG | Eligibility indicator for income tax discount | char | 1 | 0 | | | | Allow NULL? |
| 19 | SERIE | Grade | nvarchar | 2 | 0 | | | | Allow NULL? |
| 20 | MODEN | Educational specification | char | 1 | 0 | | | | Allow NULL? |
| 21 | ESCOA | School | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | DTCVC | Vaccination card expiration | nvarchar | 8 | 0 | | | | Allow NULL? |
| 23 | SALED | Eligibility indicator for education allowance | char | 1 | 0 | | | | Allow NULL? |