| 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 | MOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | No | T500L | MOLGA | Allow NULL? |
| 3 | MOBDE | Grouping of Personnel Subareas for Time Recording | nvarchar | 2 | 0 | NUMC | (N'00') | No | | MOBDE | Allow NULL? |
| 4 | RULNO | FMLA Rule | nvarchar | 3 | 0 | NUMC | (N'000') | No | | PT_FMLAR | Allow NULL? |
| 5 | ENDDA | End Date | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | ENDDA | Allow NULL? |
| 6 | BEGDA | Start Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | BEGDA | Allow NULL? |
| 7 | ENTIT | FMLA Entitlement in Weeks | decimal | 5 | 2 | DEC | ((0)) | Yes | | PT_FMLA_ENTIT | |
| 8 | DED_PERIOD | Mode of Deduction Interval | char | 1 | 0 | CHAR | (N' ') | Yes | | PT_FMLA_DEDPER | Allow NULL? |
| 9 | DED_PERPP | Period parameter | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | T549R | PTM_PERMO | Allow NULL? |
| 10 | DED_PERDT | Date type | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T548Y | DATAR | Allow NULL? |
| 11 | DED_PELEN_DT | Length of Deduction Interval | decimal | 3 | 0 | DEC | ((0)) | Yes | | PT_PELEN | |
| 12 | DED_PELEN_DTUNI | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 13 | DED_PELEN | Length of Deduction Interval | decimal | 3 | 0 | DEC | ((0)) | Yes | | PT_PELEN | |
| 14 | DED_PELEN_UNI | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 15 | SENIO_LIM | Seniority Threshold for Eligibility | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PT_FMLA_SENIO | Allow NULL? |
| 16 | SENIO_PROCE | Calculation process for employment period calculation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T525P | PSEN_PROCE | Allow NULL? |
| 17 | WKHRS_LIM | Actual Working Hours Threshold for Eligibility | decimal | 7 | 2 | DEC | ((0)) | Yes | | PT_FMLA_WKHRS | |
| 18 | WKHRS_PER | Length of Analysis Period | decimal | 3 | 0 | DEC | ((0)) | Yes | | PT_EVAL_PELEN | |
| 19 | WKHRS_UNI | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 20 | WKHRS_TYP | Hours Worked acc. to Planned or Actual Times | char | 1 | 0 | CHAR | (N' ') | Yes | | PT_FMLA_HRSTP | Allow NULL? |
| 21 | WKHRS_ZTART | Time Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T555A | PT_ZTART | Allow NULL? |
| 22 | WKHRS_REPTT | Reporting Time Type | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | T557A | REPRTT | Allow NULL? |
| 23 | WKHRS_EXTFL | Extension of Analysis Period due to Inactive Days | char | 1 | 0 | CHAR | (N' ') | Yes | | PT_FMLA_EXTFL | Allow NULL? |
| 24 | DED_DPADJ | Allow Delimitation of Deduction Interval | char | 1 | 0 | CHAR | (N' ') | Yes | | PT_FMLA_DPADJ | Allow NULL? |
