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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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_NAME* Varchar2 100 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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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_UDF1 Varchar2 40 User defined field.
13 ESSHIFTATTR_UDF2 Varchar2 40 User defined field.
14 ESSHIFTATTR_UDF3 Varchar2 40 User defined field.
15 ESSHIFTATTR_UDF4 Varchar2 40 User defined field.
16 ESSHIFTATTR_UDF5 Varchar2 40 User defined field.
17 ESSHIFTATTR_FLAG6 Char 1 One-character flag for general use.
18 ESSHIFTATTR_FLAG7 Char 1 One-character flag for general use.
19 ESSHIFTATTR_FLAG8 Char 1 One-character flag for general use.
20 ESSHIFTATTR_FLAG9 Char 1 One-character flag for general use.
21 ESSHIFTATTR_FLAG10 Char 1 One-character flag for general use.
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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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 ESSHIFTACT_START_TIME* 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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
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:

  • LAB: Shift label
  • S: Shift
  • SAT: Shift Attribute
  • TEAM: Shift Team
  • ACT: Shift Activity
  • DP: Shift Day Part
  • PROP: Shift Property Data
  • SKILL: Shift Skill
2 ESSHIFT_NAME* Varchar2 40 The name of the shift. This field is required.
3 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.
4 ESSHFSKL_LEVEL* Integer Required proficiency for the skill.
Note: The default value is 0.
5 ESSHFSKL_MANDATORY* Char 1 Flag to indicated whether skill is mandatory.
Note: The default value is N.
6 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.
7 ESSHFSKL_FLAG2 Char 1 One-character flag for general use.
8 ESSHFSKL_FLAG3 Char 1 One-character flag for general use.
9 ESSHFSKL_FLAG4 Char 1 One-character flag for general use.
10 ESSHFSKL_FLAG5 Char 1 One-character flag for general use.
11 ESSHFSKL_UDF1 Varchar2 40 User defined field.
12 ESSHFSKL_UDF2 Varchar2 40 User defined field.
13 ESSHFSKL_UDF3 Varchar2 40 User defined field.
14 ESSHFSKL_UDF4 Varchar2 40 User defined field.
15 ESSHFSKL_UDF5 Varchar2 40 User defined field.