| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | TC28A | Move time matrix | 12 | ENDZT | Finish time | nvarchar | 6 | 0 | | |
TOPClinical System |
2 | N1CYDEF | ISHMED: Cycle Definition | 9 | ENDZT | To Time | nvarchar | 6 | 0 | | |
3 | N1LSMAZ | IS-H*MED: Service/employee assign. (delete after 3.03!) | 8 | ENDZT | Completion Time of Service/Employee Assignment | nvarchar | 6 | 0 | | |
4 | N1LSTEAM | IS-H*MED: Tasks/Employees for a Service | 9 | ENDZT | Completion Time of Service/Employee Assignment | nvarchar | 6 | 0 | | |
TOPPatient Accounting |
5 | NVBRP | IS-H: Billing document item data | 51 | ENDZT | IS-H: Time Service Performance Ends (Actual) | nvarchar | 6 | 0 | | |
TOPPayroll |
6 | T7UATC37A | Downtime definition | 7 | ENDZT | End Time | nvarchar | 6 | 0 | | |
TOPSAP Healthcare - Industry-Specific Components for Hospitals |
7 | TN41 | IS-H: Services for Discharge Days (Singapore Only) | 4 | ENDZT | IS-H: Movement End Time, Start Time of Subsequent Movement | nvarchar | 6 | 0 | | |
TOPShift Planning |
8 | HRPADTI | PADTI Additional Data | 4 | ENDZT | End time of a shift | nvarchar | 6 | 0 | | |
9 | PSOLL | Shift Planning: Target Plan | 18 | ENDZT | End time of a shift | nvarchar | 6 | 0 | | |
10 | T77SP_CE | Shift Planning: Rules for Abbreviation Sequences | 8 | ENDZT | End Time | nvarchar | 6 | 0 | | |
TOPWork Center |
11 | KAKO | Capacity Header Segment | 9 | ENDZT | Finish time in seconds (internal) | int | 10 | 0 | | |
12 | KAPA | Shift Parameters for Available Capacity | 10 | ENDZT | Finish time in seconds (internal) | int | 10 | 0 | | |
13 | TC37A | Shift definition | 7 | ENDZT | Finish time | nvarchar | 6 | 0 | | |