| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | ENDDT | IS-H: Valid-To Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | No | | RI_ENDDT | Allow NULL? |
| 4 | BEGDT | IS-H: Valid-From Date of Record | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_BEGDT | Allow NULL? |
| 5 | PPR_DBEG | IS-H: Start of Shift for Regular Shift in Nursing Area | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PPR_DBEG | Allow NULL? |
| 6 | PPR_DEND | End of Shift for Regular shift in Nursing Area | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PPR_DEND | Allow NULL? |
| 7 | PPR_ZEIT | IS-H: Daily entry time for nursing acuity classification | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | PPR_ZEIT | Allow NULL? |
| 8 | PPR_FWEW | IS-H: Case value/admission value in minutes for adults | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_FWEW | Allow NULL? |
| 9 | PPR_FWKI | IS-H: Case value/admission value in minutes for children | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_FWKI | Allow NULL? |
| 10 | PPR_GWEW | IS-H: Min.requirement for patient care in minutes for adults | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_GWEW | Allow NULL? |
| 11 | PPR_GWKI | IS-H: Min. requirement for care in minutes for pediat. care | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_GWKI | Allow NULL? |
| 12 | PPR_NGBW | IS-H: Flat-rate minute value for newborns for nurs. acuity | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_NGBW | Allow NULL? |
| 13 | PPR_AZJ | IS-H: Net annual working hours in hours for a nurse | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | PPR_AZJ | Allow NULL? |
| 14 | PPR_NWP | IS-H: Number of night shift personnel for nurs. acuity eval. | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | PPR_NWP | Allow NULL? |