Location staffing requirements field specifications

This table shows the field specifications for the Location Staffing table: SO_CLIENT_STFDEF.

Fields with the asterisk (*) symbol are required.

Col. Field Name Type Size/Format Description
1 Import_type* Varchar2 4

Use STF for Staffing Requirement.

This is used to determine whether the row must be added to Staffing requirements, Driver, or a child table.

Note: This is a required field.

The values for this field are:

  • STF: Staffing Requirement
  • DRV: Driver
  • DIST: Distribution
  • PRODV: Productivity Volume
  • PRODT: Productivity Time
  • INT: Volume interval
2 SKDGRP_ID* Varchar2 22

Location name.

Note: While the data default is null, this value is required because this field is non-nullable.
3 JOB_ID Varchar2 22

Job name.
4 STSKL_ID Varchar2 22

Skill name.
5 ACT_ID Varchar2 22

Activity name.
6 SKILL_LEVEL Varchar2 22

Skill level.

If no value is provided, the default is 0.
7 CSD_MIN_REQ Varchar2 22

Min Required.

If no value is provided, the default is blank.
8 CSD_MAX_REQ Varchar2 22

Max Required.

If no value is provided, the default is 0.
9 SHFTSTFREQ_ID Varchar2 22

Shift Frequency.

If no value is provided, the default is 1.
10 CSD_CONTROL_WRK Varchar2 22 Control Work.
11 CSD_SHFTSTR_OFS Varchar2 22 Shift Start Offset.
12 CSD_SHFTEND_OFS Varchar2 22 Shift End Offset.
13 CSD_DESC Varchar2 100 Description.
14 CSD_START_TIME Date 7 Start time.
15 CSD_END_TIME Date 7 End time.
16 CSD_WRKLD_HRS Number 22 Workload hours.
17 CSD_NONVLM_FLAG Number 22

Non-volume Flag.

This flag indicates what the import is for.

The values for this field are:

  • 0: Volume driven
  • 1: Non-volume driven
  • 2: Location driven
18 DIST_ID Varchar2 22 Distribution Name.
19 CSD_RECUR_PATT Varchar2 200 Recurrence Pattern.
20 CSD_EFF_START_DATE Date 7 Effective Start Date.
21 CSD_EFF_END_DATE Date 7 Effective End Date.
22 CSD_NAME Varchar2 40 Name.
23 CSD_DEFAULT_FLAG Varchar2 1 Is Primary flag.
24 CSD_AUTOASSIGNMENT_ADJUST char 1 Auto Assignment Adjustment
25 SO_LOCPROP_WORKLD.LOCPROP_ID* Varchar2 22

Location Property Name

Note: This field is only required for location workloads.
26 SO_PREFERREDTIME_SOURCE.SKDGRP_ID Peak Time Source.
27 SO_PREFERREDTIME_SOURCE.PTSRC_MAX_PREF_TIME_PRDS Maximum number of peaks.
28 Varchar2 10

Action.

This value determines the action for the import.

The values for this field are:

  • ADD
  • UPDATE
  • DELETE
  • Blank (for child record manipulation)