1
ASS_TYPE
/MRSS/T_RM_ASSIGNMENT_TYPE
/MRSS/RM_ASSIGNMENT_TYPE
CHAR
2
0
Assignment Type ID
*
2
BOOK_TYPE
/MRSS/T_RMS_BOOKING_TYPE
INT1
INT1
3
0
Booking Type Id
3
.INCLUDE
0
0
Assignment Details in WFM Format
4
ASSIGNMENT_KEY
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
5
DEMAND_KEY
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
6
RESOURCE_KEY
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
7
BEG_TSTMP
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
8
END_TSTMP
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
9
DURATION
INT4
INT4
INT4
10
0
Natural number
10
REMAINING_DURATION
INT4
INT4
INT4
10
0
Natural number
11
PARENT_KEY
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
12
ROOT_KEY
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
13
BOOKING_TYPE
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
14
CONCRETE
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
15
WTIME_BASED
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
16
RULE_BASED
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
17
NOTE
/MRSS/T_ASSIGNMENT_NOTE
/MRSS/_SGE_SSTRING
SSTR
255
0
Assignment Note
18
APPL_STATUS
J_STATUS
J_STATUS
CHAR
5
0
Object status
19
PLANNING_TYPE
/MRSS/T_PLANNING_TYPE_CODE
/MRSS/PLANNING_TYPE_CODE
CHAR
1
0
Planning Type Code for Assignment Time Unit
20
PLANNING_UNIT
/MRSS/T_PLANNING_TIME_UNIT
MEINS
UNIT
3
0
Internal Time Unit
*
21
CREATED_BY
SYUNAME
SYCHAR12
CHAR
12
0
User Name
22
CREATED_AWTYP
AWTYP
AWTYP
CHAR
5
0
Reference procedure
*
23
CREATED_LOGSYS
LOGSYS
LOGSYS
CHAR
10
0
Logical system
*
24
CREATED
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
25
CHANGED_BY
SYUNAME
SYCHAR12
CHAR
12
0
User Name
26
CHANGED
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
27
CHANGED_AWTYP
AWTYP
AWTYP
CHAR
5
0
Reference procedure
*
28
CHANGED_LOGSYS
LOGSYS
LOGSYS
CHAR
10
0
Logical system
*
29
DESCRIPTION
/MRSS/T_ASSIGNMENT_DESC
STRG
0
0
Assignment Description
30
RES_UTIL_RATIO
/MRSS/T_WFM_UTILISATION
FLTP
16
16
Capacity Level
31
RES_UTIL_RATIO_ORIGIN
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
32
RES_TYPE
CHAR2
CHAR2
CHAR
2
0
Version Number Component
33
STATUS_TAB
/MRSS/T_STATUS_TAB
TTYP
0
0
34
.INCLUDE
0
0
Additional Info for Assignment
35
ASS_PROB
/MRSS/T_ASS_PROB
NUMC3
NUMC
3
0
Assignment Probability
36
NO_TRAVEL_COST
/MRSS/T_NO_TRAVEL_COST
BOOLEAN
CHAR
1
0
No Travel Cost Indicator
37
MOBILE_INDICATOR
/MRSS/T_SEND_TO_MOBILE
BOOLEAN
CHAR
1
0
Send To Mobile Solution
38
ASS_SUPERVISOR
/MRSS/T_ASG_SUPERVISOR
/MRSS/_BOOLEAN
CHAR
1
0
Site Supervisor of Assignment
39
RES_UTIL_RAT
/MRSS/T_WFM_UTILISATION
FLTP
16
16
Capacity Level
40
RES_UTIL_RAT_ORG
/MRSS/T_UTIL_RAT_ORG
CHAR1
CHAR
1
0
Origin of Resource utilization ratio
41
PART_CONC_ATTR
/MRSS/T_ASG_INFX_TAB
TTYP
0
0
42
TRAVEL_TIME_MODE
/MRSS/T_TRV_MODE
/MRSS/_TRV_MODE
CHAR
1
0
Travel Time Mode
43
TRV_DISPLAY_TO
/MRSS/T_TRV_DISPLAY_TO
/MRSS/_BOOLEAN
CHAR
1
0
Display Travel Times (Arrival)
44
TRV_DISPLAY_FROM
/MRSS/T_TRV_DISPLAY_FROM
/MRSS/_BOOLEAN
CHAR
1
0
Display Travel Times (Departure)
45
IS_RES_FIXED
/MRSS/T_SGE_FIX_RESOURCE
/MRSS/_BOOLEAN
CHAR
1
0
Fix Resource
46
IS_DATE_FIXED
/MRSS/T_SGE_FIX_DATES
/MRSS/_BOOLEAN
CHAR
1
0
Fix the dates
47
UTILIZ
/MRSS/T_UTILISATION
/MRSS/_UITLISATION
DEC
3
0
Resource Utilization
48
PARENT_GUID
/MRSS/T_GUID
SYSUUID
RAW
16
0
GUID
49
TIME_RULE_ID
/MRSS/T_TIME_RULE_ID
TEXT25
CHAR
25
0
Time Rule Id
50
IS_CHILD
/MRSS/T_BOOLEAN
/MRSS/_BOOLEAN
CHAR
1
0
Boolean Variable
51
SETTLEMENT_TYPE
/MRSS/T_SETTLEMENT_TYPE
/MRSS/_SETTLEMENT_TYPE
CHAR
1
0
Assignment Settlement Type
52
SPLIT_NUMBER
INT1
INT1
INT1
3
0
Dummy for B20 int1 (Local Everywhere)
53
MULT_SLOTS
/MRSS/T_SGE_MULT_SLOTS
/MRSS/_SGE_MULT_SLOTS
NUMC
3
0
Multiple Slots For a Demand
54
ASG_FOLLOWS_DEMAND
/MRSS/T_SGE_ASG_FOLLOWS_DEM
/MRSS/_BOOLEAN
CHAR
1
0
Assignment Follows Demand
55
.INCLUDE
0
0
Addnl Info fields for Assignment - Customer Include
56
DUMMY
CHAR1
CHAR1
CHAR
1
0
Single-Character Flag
57
.INCLUDE
0
0
58
.INCLUDE
0
0
Administrative Data for Assignment
59
ASSIGNMENT_TYPE
/MRSS/T_SGE_ASSIGNMENT_TYPE
/MRSS/_SGE_ASSIGNMENT_TYPE
CHAR
1
0
Assignment category
60
DEMAND
/MRSS/T_SGE_INH_ASS_FROM_DEM
STRU
0
0
61
STATUS_TAB
/MRSS/T_STATUS_TAB
TTYP
0
0
62
SUPERVISOR
/MRSS/T_DEM_SUPERVISOR
/MRSS/_DEM_SUPERVISOR
CHAR
1
0
Site supervisor indicator of demand
63
MOBILE_STATUS
/MRSS/T_MOBILE_STATUS
CHAR4
CHAR
4
0
Assignment Status for Mobile Device
64
.INCLUDE
0
0
Travel Time for Internal Display
65
TRV_TO_BEGIN
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
66
TRV_TO_END
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
67
TRV_TO_DURATION
/MRSS/T_TRV_TO_DURATION
INT4
INT4
10
0
Arrival Duration
68
TRV_TO_DUR_UNIT
/MRSS/T_TRV_TO_DURATION_UNIT
MEINS
UNIT
3
0
Arrival Duration (Unit)
*
69
TRV_TO_DISTANCE
/MRSS/T_TRV_TO_DISTANCE
GEODIST
DEC
15
6
Arrival Distance
70
TRV_TO_DIS_UNIT
/MRSS/T_TRV_TO_DISTANCE_UNIT
UNIT
3
0
Travel-to distance unit
71
TRV_TO_MANU_SET
/MRSS/T_TRV_TO_MANUALLY_SET
/MRSS/_BOOLEAN
CHAR
1
0
Arrival Set Manually
72
TRV_TO_PROFILE
/MRSS/T_TRV_PROFILE_KEY
/MRSS/_TRAVEL_PROFILE
CHAR
10
0
Travel-type profile key
73
TRV_FRM_BEGIN
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
74
TRV_FRM_END
TIMESTAMP
TZNTSTMPS
DEC
15
0
UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
75
TRV_FRM_DURATION
/MRSS/T_TRV_FROM_DURATION
INT4
INT4
10
0
Departure Duration
76
TRV_FRM_DUR_UNIT
/MRSS/T_TRV_FROM_DURATION_UNIT
MEINS
UNIT
3
0
Departure Duration (Unit)
*
77
TRV_FRM_DISTANCE
/MRSS/T_TRV_FROM_DISTANCE
GEODIST
DEC
15
6
Departure Distance
78
TRV_FRM_DIS_UNIT
/MRSS/T_TRV_FROM_DISTANCE_UNIT
UNIT
3
0
Travel-from distance unit
79
TRV_FRM_MANU_SET
/MRSS/T_TRV_FROM_MANUALLY_SET
/MRSS/_BOOLEAN
CHAR
1
0
Departure Set Manually
80
TRV_FRM_PROFILE
/MRSS/T_TRV_PROFILE_KEY
/MRSS/_TRAVEL_PROFILE
CHAR
10
0
Travel-type profile key
81
.INCLUDE
0
0
Process Times (Preparation and Wrap up) for Internal Display
82
PREP_START
/MRSS/T_SGE_TIMESTAMP
BCOS_TSTMP
DEC
15
0
Timestamp (with conv. routine)
83
PREP_END
/MRSS/T_SGE_TIMESTAMP
BCOS_TSTMP
DEC
15
0
Timestamp (with conv. routine)
84
PREP_DURATION
/MRSS/T_PREPARATION_DURATION
INT4
INT4
10
0
Preparation Duration
85
WRAP_UP_START
/MRSS/T_SGE_TIMESTAMP
BCOS_TSTMP
DEC
15
0
Timestamp (with conv. routine)
86
WRAP_UP_END
/MRSS/T_SGE_TIMESTAMP
BCOS_TSTMP
DEC
15
0
Timestamp (with conv. routine)
87
WRAP_UP_DURATION
/MRSS/T_WRAP_UP_DURATION
INT4
INT4
10
0
Wrap up Duration