| 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 | | BEN_AREA | Allow NULL? |
| 3 | CURRE | Benefit Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | No | TCURC | BEN_CURR | Allow NULL? |
| 4 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 5 | OPIND | Benefit indicator open enrollment is performed | char | 1 | 0 | CHAR | (N' ') | No | | BEN_OPIND | Allow NULL? |
| 6 | OPBEG | Benefit start of open enrollment period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEN_OPBEG | Allow NULL? |
| 7 | OPEND | Benefit end of open enrollment period | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEN_OPEND | Allow NULL? |
| 8 | ENBEG | Benefits start of infotype records for open enrollment | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEN_ENBEG | Allow NULL? |
| 9 | ENEND | Benefit end of infotype records for open enrollment | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEN_ENEND | Allow NULL? |
| 10 | EVEND | Benefit end of infotype records for adj.reas./standard plan | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | BEN_EVTEND | Allow NULL? |
| 11 | FUTNU | Benefit number of years in the future enrollment is possible | decimal | 4 | 0 | DEC | ((0)) | No | | BEN_FUTNU | |
| 12 | INDAG | Benefit regular dependent age limit | nvarchar | 2 | 0 | NUMC | (N'00') | No | | BEN_INDAG | Allow NULL? |
| 13 | STDAG | Benefit Dependent Age Limit for Students | nvarchar | 2 | 0 | NUMC | (N'00') | No | | BEN_STDAG | Allow NULL? |
| 14 | NOMAX | Benefit No Maximum Age for Disability | char | 1 | 0 | CHAR | (N' ') | No | | BEN_NOMAX | Allow NULL? |
| 15 | TERMI | COBRA Indicator Termination of Employment is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_TERMI | Allow NULL? |
| 16 | REDUC | COBRA Indicator Reduction in Working Hours is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_REDUC | Allow NULL? |
| 17 | DEATH | COBRA Indicator Death of Employee is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_DEATH | Allow NULL? |
| 18 | MEDIC | COBRA Indicator Employee Entitlement to Medicare is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_MEDIC | Allow NULL? |
| 19 | DIVOR | COBRA Indicator Divorce is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_DIVOR | Allow NULL? |
| 20 | SEPAR | COBRA Indicator Legal Separation is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_SEPAR | Allow NULL? |
| 21 | LOSSD | COBRA Indicator Child's Loss of Dependent Status is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_LOSSD | Allow NULL? |
| 22 | BANKR | COBRA Indicator Employer's Bankruptcy Is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_BANKR | Allow NULL? |
| 23 | BKRDT | COBRA cutoff date for bankruptcy proceedings | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | COB_BKRDT | Allow NULL? |
| 24 | RESIS | COBRA residence status excluding person from COBRA | char | 1 | 0 | CHAR | (N' ') | No | T505U | COB_RESIS | Allow NULL? |
| 25 | LOCOV | COBRA indicator COBRA starts when coverage is lost | char | 1 | 0 | CHAR | (N' ') | No | | COB_LOCOV | Allow NULL? |
| 26 | CONCO | COBRA Indicator Restrict Offer to Participation Before Event | char | 1 | 0 | CHAR | (N' ') | No | | COB_CONCO | Allow NULL? |
| 27 | POSBA | Benefits Only Offer FSAs with Positive Account Balance | char | 1 | 0 | CHAR | (N' ') | No | | COB_POSBA | Allow NULL? |
| 28 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOBDE | Allow NULL? |
| 29 | CLCHG | Benefit flexible spending account claims can be changed | char | 1 | 0 | CHAR | (N' ') | No | | BEN_CLCHG | Allow NULL? |
| 30 | CLCNF | Benefit agreement can be given to rejection of claims | char | 1 | 0 | CHAR | (N' ') | No | | BEN_CLCNF | Allow NULL? |
| 31 | PSMOP | Benefit Indicator Payroll Sim. Permitted for Open Enrollment | char | 1 | 0 | CHAR | (N' ') | No | | BEN_PSMOP | Allow NULL? |
| 32 | PSMAD | Benefit Ind. Payroll Simulation Allowed for Adjustmt Reason | char | 1 | 0 | CHAR | (N' ') | No | | BEN_PSMAD | Allow NULL? |
| 33 | DRVVR | Benefit variant of payroll driver for payroll simulation | nvarchar | 14 | 0 | CHAR | (N' ') | No | | BEN_DRVVR | Allow NULL? |
| 34 | SLPVR | Benefit Variants for Remuneration Statement for Simulation | nvarchar | 14 | 0 | CHAR | (N' ') | No | | BEN_SLPVR | Allow NULL? |
| 35 | HERCS | Benefits: Flag to Hide Employer Costs | char | 1 | 0 | CHAR | (N' ') | Yes | | BEN_HERCS | Allow NULL? |
| 36 | DCNCC | Benefits: Flag to Display Contributions | char | 1 | 0 | CHAR | (N' ') | Yes | | BEN_DCNCC | Allow NULL? |
| 37 | ESTCN | Benefits: Flag to Estimate Contributions | char | 1 | 0 | CHAR | (N' ') | Yes | | BEN_ESTCN | Allow NULL? |
| 38 | PSMFO | Benefits: HR Form for Payroll Simulation | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | * | BEN_PSMFO | Allow NULL? |
| 39 | MILIT | Benefits Indicator Military Leave Is Relevant | char | 1 | 0 | CHAR | (N' ') | No | | COB_MILIT | Allow NULL? |
