MVS Shift Configuration field specifications
These tables list the field-column specifications in the MVS Shift Configuration import interface. Fields with the asterisk (*) symbol are required.
One interface is used to import multiple tables. Each table has a required
Import_Type
field. This field determines where the data is added. The
tables include:
- Shift label
- Shift
- Shift Attribute
- Shift Team
- Shift Activity
- Shift Day Part
- Shift Property Data
- Shift Skill
Shift label
This table shows the field specifications for the shift label table: ES_SHIFT_DISP_LABEL.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use LAB for Shift label. The values for this field are:
|
2 | ESSHIFTLAB_LABEL* | Varchar2 | 40 | The name of the Shift label. This field is required. |
3 | ESSHIFTLAB_FLAG1 | Char | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
4 | ESSHIFTLAB_FLAG2 | Char | 1 | One-character flag for general use. |
5 | ESSHIFTLAB_FLAG3 | Char | 1 | One-character flag for general use. |
6 | ESSHIFTLAB_FLAG4 | Char | 1 | One-character flag for general use. |
7 | ESSHIFTLAB_FLAG5 | Char | 1 | One-character flag for general use. |
8 | ESSHIFTLAB_UDF1 | Varchar2 | 40 | User defined field. |
9 | ESSHIFTLAB_UDF2 | Varchar2 | 40 | User defined field. |
10 | ESSHIFTLAB_UDF3 | Varchar2 | 40 | User defined field. |
11 | ESSHIFTLAB_UDF4 | Varchar2 | 40 | User defined field. |
12 | ESSHIFTLAB_UDF5 | Varchar2 | 40 | User defined field. |
Shift table
This table shows the field specifications for the shift table: ES_SHIFT.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use S for Shift. The values for this field are:
|
2 | ESSHIFT_NAME* | Varchar2 | 40 | The name of the shift. This field is required. |
3 | ESSHIFT_DESC* | Varchar2 | 100 | The shift description. This field is required. |
4 | ESSHIFTLAB_ID* | Varchar2 | 20 | The shift label Name. |
5 | WBT_ID | Varchar2 | 40 | The team name. |
6 | ESSHIFT_APPLYTO_SUB_TEAMS* | Char | 1 | The default is N . |
7 | ESSHIFT_FLAG1 | Char | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
8 | ESSHIFT_FLAG2 | Char | 1 | One-character flag for general use. |
9 | ESSHIFT_FLAG3 | Char | 1 | One-character flag for general use. |
10 | ESSHIFT_FLAG4 | Char | 1 | One-character flag for general use. |
11 | ESSHIFT_FLAG5 | Char | 1 | One-character flag for general use. |
12 | ESSHIFT_UDF1 | Varchar2 | 40 | User defined field. |
13 | ESSHIFT_UDF2 | Varchar2 | 40 | User defined field. |
14 | ESSHIFT_UDF3 | Varchar2 | 40 | User defined field. |
15 | ESSHIFT_UDF4 | Varchar2 | 40 | User defined field. |
16 | ESSHIFT_UDF5 | Varchar2 | 40 | User defined field. |
Shift Attribute
This table shows the field specifications for the shift attribute table: ES_SHIFT_ATTRIBUTE.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use SAT for Shift Attribute. The values for this field are:
|
2 | ESSHIFT_ID* | Varchar2 | 40 | The name of the shift. This field is required. |
3 | ESSHIFTATTR_EFF_START_DATE* | Date | MM/DD/YYYY | Shift Attribute Start Date. |
4 | ESSHIFTATTR_EFF_END_DATE* | Date | MM/DD/YYYY | Shift Attribute End Date. |
5 | COLR_FONT_ID* | Varchar2 | 40 | The Shift Attribute Color. |
6 | SHFTYP_ID* | Varchar2 | 40 | The Shift Type. |
7 | ESSHIFT_FLAG1 | Char | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
8 | ESSHIFTATTR_FLAG2 | Char | 1 | One-character flag for general use. |
9 | ESSHIFTATTR_FLAG3 | Char | 1 | One-character flag for general use. |
10 | ESSHIFTATTR_FLAG4 | Char | 1 | One-character flag for general use. |
11 | ESSHIFTATTR_FLAG5 | Char | 1 | One-character flag for general use. |
12 | ESSHIFTATTR_FLAG6 | Char | 1 | One-character flag for general use. |
13 | ESSHIFTATTR_FLAG7 | Char | 1 | One-character flag for general use. |
14 | ESSHIFTATTR_FLAG8 | Char | 1 | One-character flag for general use. |
15 | ESSHIFTATTR_FLAG9 | Char | 1 | One-character flag for general use. |
16 | ESSHIFTATTR_FLAG10 | Char | 1 | One-character flag for general use. |
17 | ESSHIFTATTR_UDF1 | Varchar2 | 40 | User defined field. |
18 | ESSHIFTATTR_UDF2 | Varchar2 | 40 | User defined field. |
19 | ESSHIFTATTR_UDF3 | Varchar2 | 40 | User defined field. |
20 | ESSHIFTATTR_UDF4 | Varchar2 | 40 | User defined field. |
21 | ESSHIFTATTR_UDF5 | Varchar2 | 40 | User defined field. |
22 | ESSHIFTATTR_UDF6 | Varchar2 | 40 | User defined field. |
23 | ESSHIFTATTR_UDF7 | Varchar2 | 40 | User defined field. |
24 | ESSHIFTATTR_UDF8 | Varchar2 | 40 | User defined field. |
25 | ESSHIFTATTR_UDF9 | Varchar2 | 40 | User defined field. |
26 | ESSHIFTATTR_UDF10 | Varchar2 | 40 | User defined field. |
Shift Team
This table shows the field specifications for the shift team table: ES_SHIFT_TEAM.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use TEAM for Shift Team. The values for this field are:
|
2 | ESSHIFT_ID* | Varchar2 | 40 | The name of the shift. This field is required. |
3 | ESSHTM_EFF_START_DATE* | Date | MM/DD/YYYY | Shift Team Effective Start Date. |
4 | ESSHTM_EFF_END_DATE* | Date | MM/DD/YYYY | Shift Team Effective End Date. |
Shift Activity
This table shows the field specifications for the shift activity table: ES_SHIFT_ACTIVITY.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use ACT for Shift Activity. The values for this field are:
|
2 | ESSHIFTATTR_ID* | Varchar2 | 40 | The name of the shift. This field is required. Note: Use
the Shift Name in this field. The system maps the name to the ID on
import.
|
3 | ESSHIFTATTR_EFF_START_DATE* | Date | MM/DD/YYYY HH24MI | Shift Activity Start Time. |
4 | ESSHIFTACT_END_TIME* | Date | MM/DD/YYYY HH24MI | Shift Activity End Time. |
5 | ACT_ID* | Varchar2 | 40 | The name of the Activity. |
6 | ESSHIFTACT_FLAG1 | Char | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
7 | ESSHIFTACT_FLAG2 | Char | 1 | One-character flag for general use. |
8 | ESSHIFTACT_FLAG3 | Char | 1 | One-character flag for general use. |
9 | ESSHIFTACT_FLAG4 | Char | 1 | One-character flag for general use. |
10 | ESSHIFTACT_FLAG5 | Char | 1 | One-character flag for general use. |
11 | ESSHIFTACT_FLAG6 | Char | 1 | One-character flag for general use. |
12 | ESSHIFTACT_FLAG7 | Char | 1 | One-character flag for general use. |
13 | ESSHIFTACT_FLAG8 | Char | 1 | One-character flag for general use. |
14 | ESSHIFTACT_FLAG9 | Char | 1 | One-character flag for general use. |
15 | ESSHIFTACT_FLAG10 | Char | 1 | One-character flag for general use. |
16 | ESSHIFTACT_UDF1 | Varchar2 | 40 | User defined field. |
17 | ESSHIFTACT_UDF2 | Varchar2 | 40 | User defined field. |
18 | ESSHIFTACT_UDF3 | Varchar2 | 40 | User defined field. |
19 | ESSHIFTACT_UDF4 | Varchar2 | 40 | User defined field. |
20 | ESSHIFTACT_UDF5 | Varchar2 | 40 | User defined field. |
21 | ESSHIFTACT_UDF6 | Varchar2 | 40 | User defined field. |
22 | ESSHIFTACT_UDF7 | Varchar2 | 40 | User defined field. |
23 | ESSHIFTACT_UDF8 | Varchar2 | 40 | User defined field. |
24 | ESSHIFTACT_UDF9 | Varchar2 | 40 | User defined field. |
25 | ESSHIFTACT_UDF10 | Varchar2 | 40 | User defined field. |
Shift Day Part
This table shows the field specifications for the shift day part table: ES_SHIFT_DAY_PART.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use DP for Shift Day Part. The values for this field are:
|
2 | ESSHIFTATTR_ID* | Varchar2 | 40 | The name of the shift. This field is required. Note: Use
the Shift Name in this field. The system maps the name to the ID on
import.
|
3 | DP_ID* | Varchar2 | 40 | The name of the Shift Day Part. |
Shift Property Data
This table shows the field specifications for the shift property data table: ES_SHIFT_PROP_DATA.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 4 |
Use PROP for Shift Property Data. The values for this field are:
|
2 | ESSHIFTATTR_ID* | Varchar2 | 40 | The name of the shift. This field is required. Note: Use
the Shift Name in this field. The system maps the name to the ID on
import.
|
3 | ESSHIFTPROP_ID* | Varchar2 | 40 | The name of the Shift Property. |
4 | ESSHIFTPROPD_VALUE* | Varchar2 | 40 | The Shift Property Value. |
Shift Skill
This table shows the field specifications for the shift skill table: ES_SHIFT_SKILL.
Col. | Field Name | Type | Size/Format | Description |
---|---|---|---|---|
1 | Import_Type* | Varchar2 | 5 |
Use SKILL for Shift Skill. The values for this field are:
|
2 | ESSHFSKL_ID* | Varchar2 | 40 | The name of the shift skill. This field is required. Note: Use the Skill Name in this field. The system maps the name to the ID on
import.
|
3 | ESSHFSKL_LEVEL* | Integer | Required proficiency for the skill. Note: The default
value is 0.
|
|
4 | ESSHFSKL_MANDATORY* | Char | 1 | Flag to indicated whether skill is mandatory. Note: The
default value is N.
|
5 | ESSHFSKL_FLAG1 | Char | 1 | One-character flag for general use. A {space} in one of the flag positions indicates no processing is to be done for that flag. An ampersand (&) in one of the flag positions indicates the flag is to be blanked. |
6 | ESSHFSKL_FLAG2 | Char | 1 | One-character flag for general use. |
7 | ESSHFSKL_FLAG3 | Char | 1 | One-character flag for general use. |
8 | ESSHFSKL_FLAG4 | Char | 1 | One-character flag for general use. |
9 | ESSHFSKL_FLAG5 | Char | 1 | One-character flag for general use. |
10 | ESSHFSKL_UDF1 | Varchar2 | 40 | User defined field. |
11 | ESSHFSKL_UDF2 | Varchar2 | 40 | User defined field. |
12 | ESSHFSKL_UDF3 | Varchar2 | 40 | User defined field. |
13 | ESSHFSKL_UDF4 | Varchar2 | 40 | User defined field. |
14 | ESSHFSKL_UDF5 | Varchar2 | 40 | User defined field. |