| Table | Table Description | Column# | Alias | Column Description | Data Type | Length | Decimals | Default Value | Constraints |
---|
1 | /MRSS/M_HCMPTLRP | Mirror for Mapping HR Time Data to WFM Time Allocations | 6 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
2 | /WSOPT/DWS | Daily Work Schedule | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
3 | P2B2_PSP | HCM Declustering B2 - Personal Work Schedule (Table PSP) | 8 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
4 | P2B2_RUFB | HCM Declustering B2 - On-Call Duty (Table RUFB) | 17 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
5 | P2B2_VERT | HCM Declustering B2 - Table VERT | 19 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
6 | P2RF_PSPP | Personal Work Schedule (Table PSP) | 6 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPJapan |
7 | TPTJPFWS_SUBSTI | ESS Flexible Work Schedule: Substitution linkage | 3 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPMaintenance Orders |
8 | /MRSS/C_HCMPTLRP | Mapping HR Time Data to WFM Time Allocations | 4 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPNorway |
9 | T5V1C | Period Work Schedules Codes | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPPayroll |
10 | T7UATC37A | Downtime definition | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPPersonnel Time Events |
11 | T551A_COR_CALE | ESS Correction Scenario: Period Work Schedule for Calendar | 3 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPPersonnel Time Management |
12 | PA2003 | HR Time Record: Infotype 2003 (Substitutions) | 42 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
13 | PA2004 | HR Time Record: Infotype 2004 (Availability) | 32 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
14 | T508A | Work Schedule Rules | 15 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
15 | T508Z | Assignment of PS Grouping for Work Schedules to Daily WS | 3 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
16 | T550A | Daily Work Schedule | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
17 | T550P | Break Schedules | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
18 | T550S | Daily Work Schedule Texts | 3 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
19 | T551A | Period Work Schedules | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
20 | T551C | Period Work Schedule Valuation | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
21 | T551S | Period Work Schedule Texts | 3 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
22 | T552V | Dynamic Daily Work Schedule Assignment | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
23 | T552W | Dynamic Daily WS Assignment: Planned/Actual Overlap | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPPortugal |
24 | T5PWS | HR-PT: Work Schedules - Classification | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPShift Planning |
25 | T77ED | Shift Planning: Definition of Shifts | 4 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPSweden |
26 | T5S0A | Leave year periods - SE | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
27 | T5S1C | Period Work Schedule Valuation - SE(Leave) | 2 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPTime Data Recording and Administration |
28 | TMW_TDTYPE | Time Data ID | 13 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |
TOPWork Center |
29 | TC37A | Shift definition | 11 | MOTPR | Personnel Subarea Grouping for Daily Work Schedules | nvarchar | 2 | 0 | | |