| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | ACTIVE | Table entry is active (A) or in suspense (S) | char | 1 | 0 | | | | Allow NULL? |
| 3 | CLAIM | Number of Claim | nvarchar | 17 | 0 | | | | Allow NULL? |
| 4 | DIPLIT_ID | Distribution Plan Item ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 5 | CHANGETIME | Changed: Date + Time | decimal | 15 | 0 | | | | |
| 6 | CHANGEDBY | Changed By | nvarchar | 12 | 0 | | | | Allow NULL? |
| 7 | DELETED | Database Line Status (Original, Changed, Deleted) | char | 1 | 0 | | | | Allow NULL? |
| 8 | SUBOBJECT | Claim Subobject | nvarchar | 16 | 0 | | | | Allow NULL? |
| 9 | DIPL_ID | Distribution Plan ID | nvarchar | 32 | 0 | | | | Allow NULL? |
| 10 | DIPLIT_NUM | Number of a Distribution Plan Item | nvarchar | 3 | 0 | | | | Allow NULL? |
| 11 | PARTTY | Participation Type in Multiple Insurance | nvarchar | 10 | 0 | | | | Allow NULL? |
| 12 | SETTY | Settlement Type in Multiple Insurance | nvarchar | 10 | 0 | | | | Allow NULL? |
| 13 | X_OWN_SHARE | Flag for Share of Own Insurance in Multiple Insurance | char | 1 | 0 | | | | Allow NULL? |
| 14 | SHARE_PRC | Share of Participant in Multiple Insurance (Percentage) | decimal | 5 | 2 | | | | |
| 15 | SHARE_AMT | Share of Participant in Multiple Insurance (Absolute) | decimal | 15 | 2 | | | | |
| 16 | REF | Reference | nvarchar | 20 | 0 | | | | Allow NULL? |
| 17 | REPID | Coinsurance Key | nvarchar | 10 | 0 | | | | Allow NULL? |