| 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 | POLID | Absence Pool ID | nvarchar | 4 | 0 | CHAR | (N' ') | No | | P10_POLID | Allow NULL? |
| 3 | POLTP | Sick Leave Pool Type (Hours or Amount) | char | 1 | 0 | CHAR | (N' ') | No | | P10_POLTP | Allow NULL? |
| 4 | POLLO | Low Watermark for Absence Pool | decimal | 7 | 2 | DEC | ((0)) | No | | P10_POLLO | |
| 5 | BALMI | Minimum Personal Leave Balance | decimal | 7 | 2 | DEC | ((0)) | No | | P10_BALMI | |
| 6 | POLAD | Sick leave pool administrator | nvarchar | 40 | 0 | CHAR | (N' ') | No | | P10_POLAD | Allow NULL? |
| 7 | MOPGK | Employee Subgroup Grouping for Time Quota Types | char | 1 | 0 | CHAR | (N' ') | No | T556A | MOPGK | Allow NULL? |
| 8 | MOZKO | Grouping of Personnel Subareas for Time Quota Types | nvarchar | 2 | 0 | NUMC | (N'00') | No | T556A | MOZKO | Allow NULL? |
| 9 | KTART | Absence Quota Type | nvarchar | 2 | 0 | NUMC | (N'00') | No | T556A | ABWKO | Allow NULL? |
| 10 | INIHR | Sick Leave Pool Initial Hours/Days | decimal | 10 | 2 | DEC | ((0)) | Yes | | P10_INIHR | |
| 11 | ZEINH | Time/Measurement Unit | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | T538A | PT_ZEINH | Allow NULL? |
| 12 | INIAM | Initial amount in Pool | decimal | 13 | 2 | CURR | ((0)) | Yes | | P10_INIAMT | |
| 13 | WAERS | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | WAERS | Allow NULL? |
| 14 | LGART | Wage Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T512W | LGART | Allow NULL? |
| 15 | EVOLN | Absence Pool Eligibility: All Employees | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_EVOLN | Allow NULL? |
| 16 | EFULL | Absence Pool Eligibility: Full-Time Employees Only | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_EFULL | Allow NULL? |
| 17 | EMONT | Absence Pool Eligibility: Minimum Months of Service | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P10P_EMONT | Allow NULL? |
| 18 | PROCE | Calculation process for employment period calculation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | T525P | PSEN_PROCE | Allow NULL? |
| 19 | DOMIN | Minimum Absence Pool Donation | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P10P_DOMIN | Allow NULL? |
| 20 | DOMAX | Maximum Absence Pool Donation | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P10P_DOMAX | Allow NULL? |
| 21 | WTMIN | Minimum Absence Pool Withdrawal | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P10P_WTMIN | Allow NULL? |
| 22 | WTMAX | Maximum Absence Pool Withdrawal | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | P10P_WTMAX | Allow NULL? |
| 23 | INACT | Return Unused Donation Balance to Inactive Donor Employees | char | 1 | 0 | CHAR | (N' ') | Yes | | P10P_INACT | Allow NULL? |
| 24 | RTUNI | Round Down and Return Unused Leave in Increments of Minutes | nvarchar | 2 | 0 | NUMC | (N'00') | Yes | | P10P_RTUNI | Allow NULL? |