| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | P2B2_RUFB | HCM Declustering B2 - On-Call Duty (Table RUFB) | 15 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
2 | P2B2_VERT | HCM Declustering B2 - Table VERT | 17 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
3 | T5G22 | SSP Qualifying Day Pattern | 3 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
4 | T5G24 | SSP Qualifying Day Pattern Calendars | 3 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
5 | T5HAB | Working day shifts to general work schedule | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
6 | T5PPBS9L | Portugal Public Sector - BDAP - Schedule Codes Interface | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
7 | T77PADKZ508A | Normative Work Schedule Rules for Personal Work Schedule | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
8 | T7RU80S | Basic normal grafiks Russia | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPClinical System |
9 | N1MEORDER | IS-H*MED: Medication, Medication Order | 12 | MOSID | Medication: Status ID for Status of Medication Order | nvarchar | 3 | 0 | | |
10 | N1OSTATUSA | IS-H*MED: Order - Status - Assignment | 3 | MOSID | Medication: Status ID for Status of Medication Order | nvarchar | 3 | 0 | | |
11 | TN1OSTATUS | IS-H*MED: Status for Drug Order | 3 | MOSID | Medication: Status ID for Status of Medication Order | nvarchar | 3 | 0 | | |
12 | TN1OSTATUST | IS-H*MED: Status for Drug Order - Texts | 4 | MOSID | Medication: Status ID for Status of Medication Order | nvarchar | 3 | 0 | | |
TOPPayroll |
13 | T7UA508A | Normative Work Schedule Rules for Personal Work Schedule | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPPersonnel Administration |
14 | T001P | Personnel Area/Subarea | 22 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
15 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 40 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
16 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 30 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
17 | T508A | Work Schedule Rules | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
18 | T508S | Text Table for Work Schedule Rules (T508A) | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
19 | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | 2 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
20 | T552A | Monthly Work Schedule | 4 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPPublic sector Sweden |
21 | T5STE_CE | Teachers - School year definition | 3 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
22 | T5STH_CE | Teachers - Other holidays | 3 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
23 | T5SWS_CE | Working at school - School year definition | 3 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
24 | TMW_TDTYPE | Time Data ID | 20 | MOSID | Personnel Subarea Grouping for Work Schedules | nvarchar | 2 | 0 | | |
TOPWork Center |
25 | KAKO | Capacity Header Segment | 13 | MOSID | Grouping for Shift Definitions and Shift Sequences | nvarchar | 2 | 0 | | |