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.
27 ESSHIFTATTR_COLR Varchar2 40 The Shift Highlight Color.

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 ESSHIFTACT_AREA Varchar2 40 The area linked to the shift.
6 ACT_ID* Varchar2 40 The name of the Activity.
7 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.
8 ESSHIFTACT_FLAG2 Char 1 One-character flag for general use.
9 ESSHIFTACT_FLAG3 Char 1 One-character flag for general use.
10 ESSHIFTACT_FLAG4 Char 1 One-character flag for general use.
11 ESSHIFTACT_FLAG5 Char 1 One-character flag for general use.
12 ESSHIFTACT_FLAG6 Char 1 One-character flag for general use.
13 ESSHIFTACT_FLAG7 Char 1 One-character flag for general use.
14 ESSHIFTACT_FLAG8 Char 1 One-character flag for general use.
15 ESSHIFTACT_FLAG9 Char 1 One-character flag for general use.
16 ESSHIFTACT_FLAG10 Char 1 One-character flag for general use.
17 ESSHIFTACT_UDF1 Varchar2 40 User defined field.
18 ESSHIFTACT_UDF2 Varchar2 40 User defined field.
19 ESSHIFTACT_UDF3 Varchar2 40 User defined field.
20 ESSHIFTACT_UDF4 Varchar2 40 User defined field.
21 ESSHIFTACT_UDF5 Varchar2 40 User defined field.
22 ESSHIFTACT_UDF6 Varchar2 40 User defined field.
23 ESSHIFTACT_UDF7 Varchar2 40 User defined field.
24 ESSHIFTACT_UDF8 Varchar2 40 User defined field.
25 ESSHIFTACT_UDF9 Varchar2 40 User defined field.
26 ESSHIFTACT_UDF10 Varchar2 40 User defined field.
27 JOB_ID Varchar2 40 The job name associated with the shift activity. The value in this field must match an existing job in the application.
28 DEPT_ID Varchar2 40 The department name associated with the shift activity. The value in this field must match an existing department in the application.
29 DOCK_ID Varchar2 40 The docket name associated with the shift activity. The value in this field must match an existing docket in the application.
30 PROJ_ID Varchar2 40 The project name associated with the shift activity. The value in this field must match an existing project in the application.

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.