| 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 | T000 | MANDT | Allow NULL? |
| 2 | BAREA | Benefit area | nvarchar | 2 | 0 | CHAR | (N' ') | No | T5UB3 | BEN_AREA | Allow NULL? |
| 3 | BPLAN | Benefit plan | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5UBA | BEN_PLAN | Allow NULL? |
| 4 | CLMFM | Claim variant for Plan | nvarchar | 4 | 0 | CHAR | (N' ') | No | T7XAS6 | CLM_CLMFM | Allow NULL? |
| 5 | SALGR | Benefit salary group | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5UBK | BEN_SALGR | Allow NULL? |
| 6 | AGEGR | Benefit age group | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5UBL | BEN_AGEGR | Allow NULL? |
| 7 | LOSGR | Benefit seniority group | nvarchar | 4 | 0 | CHAR | (N' ') | No | T5UBM | BEN_LOSGR | Allow NULL? |
| 8 | CLMGR | Claim grouping for plan | nvarchar | 4 | 0 | CHAR | (N' ') | No | T7XASI | CLM_CLMGR | Allow NULL? |
| 9 | GENDR | Gender data for calculating claims limit | char | 1 | 0 | CHAR | (N' ') | No | | CLM_GENDER | Allow NULL? |
| 10 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 11 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEGDA | Allow NULL? |
| 12 | AMOUT | Claim Limit Amount | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_AMOUT | |
| 13 | PRCNT | Claim limit expressed as a percentage | decimal | 5 | 2 | DEC | ((0)) | No | | CLM_PRCNT | |
| 14 | APPRL | Processing rule for claim limit amount and percentage | char | 1 | 0 | CHAR | (N' ') | No | | CLM_APPRL | Allow NULL? |
| 15 | NUMCL | Number of claims | decimal | 3 | 0 | DEC | ((0)) | No | | CLM_NUMCL | |
| 16 | CLMAX | Maximum amount per claim | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_CLMAX | |
| 17 | DCLMX | Maximum amount per claim for dependents | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_DCLMX | |
| 18 | MXPER | Claim limit expressed as a percentage | decimal | 5 | 2 | DEC | ((0)) | No | | CLM_PRCNT | |
| 19 | PRRUL | Processing rule for amout and percentage | char | 1 | 0 | CHAR | (N' ') | No | | CLM_PRRUL | Allow NULL? |
| 20 | CLMNO | No. of units | decimal | 3 | 0 | DEC | ((0)) | No | | CLM_NOUNITS | |
| 21 | CLMUN | Claims units for no. of claims | nvarchar | 2 | 0 | NUMC | (N'00') | No | T549R | CLM_UNITS | Allow NULL? |
| 22 | UNFLG | Claim limit is applicable for all (Employee and Family) | char | 1 | 0 | CHAR | (N' ') | No | | CLM_UNFLG | Allow NULL? |
| 23 | NDAYS | Duration in no. of days | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CLM_NDAYS | Allow NULL? |
| 24 | MXAMT | Maximum amount for each day | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_MXAMT | |
| 25 | CPPER | Co-payment percentage | decimal | 5 | 2 | DEC | ((0)) | No | | CLM_CPPER | |
| 26 | CPAMT | Co-payment amount | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_CPAMT | |
| 27 | CPPRL | Processing rule for co-pay amount and percentage for EE | char | 1 | 0 | CHAR | (N' ') | No | | CLM_CPPRL | Allow NULL? |
| 28 | CPDEP | Co-payment percentage for family(dependents) | decimal | 5 | 2 | DEC | ((0)) | No | | CLM_CPDEP | |
| 29 | CADEP | Co-payment amount for family(dependents) | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_CADEP | |
| 30 | CDPRL | Processing rule for co-pay amount and percentage for family | char | 1 | 0 | CHAR | (N' ') | No | | CLM_CDPRL | Allow NULL? |
| 31 | WRDTY | Claims ward type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CLM_WRDTY | Allow NULL? |
| 32 | ELPER | Dependent eligibility percentage | decimal | 5 | 2 | DEC | ((0)) | No | | CLM_ELPER | |
| 33 | DPAMT | Claim limit amount for dependents | decimal | 15 | 2 | CURR | ((0)) | No | | CLM_DPAMT | |
| 34 | ELGTY | Dependent eligibility type | char | 1 | 0 | CHAR | (N' ') | No | | CLM_ELGTY | Allow NULL? |
| 35 | CLDCV | Dependent Coverage for Claims | nvarchar | 4 | 0 | CHAR | (N' ') | No | T7XASA | CLM_CLDCV | Allow NULL? |
