| 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 | NHINR | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 7 | ENDDA | End Date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 8 | NHCAT | National insurance insuree category | char | 1 | 0 | | | | Allow NULL? |
| 9 | NHGRP | National health insurance insuree category groups | char | 1 | 0 | | | | Allow NULL? |
| 10 | NHICA | NHI Insured Amount Class | nvarchar | 2 | 0 | | | | Allow NULL? |
| 11 | INAMT | Insured amount from | decimal | 13 | 2 | | | | |
| 12 | INCUR | Currency Key | nvarchar | 5 | 0 | | | | Allow NULL? |
| 13 | VADAT | NHI contribution from | nvarchar | 8 | 0 | | | | Allow NULL? |
| 14 | NHIST | NHI status | nvarchar | 2 | 0 | | | | Allow NULL? |
| 15 | NHISR | NHI status reason | nvarchar | 2 | 0 | | | | Allow NULL? |
| 16 | NHIEX | NHI exempt by law | char | 1 | 0 | | | | Allow NULL? |
| 17 | EXRSN | Reason for exemption | nvarchar | 2 | 0 | | | | Allow NULL? |
| 18 | DISAB | Subsidy type | char | 1 | 0 | | | | Allow NULL? |
| 19 | SSIPE | Subsidy percentage | decimal | 7 | 2 | | | | |
| 20 | ERPAY | Employer Pays All the Premium Required | char | 1 | 0 | | | | Allow NULL? |
| 21 | IDNUM | Identity Number | nvarchar | 30 | 0 | | | | Allow NULL? |
| 22 | ERNHE | Taiwan NHI Exempt for Employer | char | 1 | 0 | | | | Allow NULL? |
| 23 | TAXRT | Average Tax Rate Flag | char | 1 | 0 | | | | Allow NULL? |
| 24 | EXRSH | Supplementary Premium Status | char | 1 | 0 | | | | Allow NULL? |
| 25 | NPSTA | Suppl. Prem. Status (Bonus or Part-time Income) | char | 1 | 0 | | | | Allow NULL? |
| 26 | NPREA | Reason for Other Cases (Bonus or Part-time Income) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 27 | ICSTA | Suppl. Prem. Status (Profession. Practice Income) | char | 1 | 0 | | | | Allow NULL? |
| 28 | ICREA | Reason for Other Cases (Profession. Practice Income) | nvarchar | 2 | 0 | | | | Allow NULL? |
| 29 | PAYDT | Pay date for payroll result | nvarchar | 8 | 0 | | | | Allow NULL? |
| 30 | SERPY | Employer Pays All the Premium Required | char | 1 | 0 | | | | Allow NULL? |
| 31 | NHIVS | Single-Character Indicator | char | 1 | 0 | | | | Allow NULL? |
| 32 | ERSHE | SNHI Exempt for Employer | char | 1 | 0 | | | | Allow NULL? |
| 33 | DISSD | Invalidate Disability Subsidy for NHI Premium | char | 1 | 0 | | | | Allow NULL? |
