Improvements to SCV resource capacity model

The SCV data model for resource capacities has been enhanced to include new columns and revised constraints.

In addition, the default shift pattern concept has been revised. In SCV, it is assumed that the imported resources and/or resource units are assigned to a capacity shift pattern. When the shift pattern is not available for a resource or resource unit, it is considered that the resource units are assigned to a default shift pattern during import. The default shift pattern to use is specified using the SCP_DEFAULT_RESOURCE_SHIFT_PATTERN_ID configuration parameter. The default shift pattern specified by this parameter must exist as in SC_SHIFT_PATTERN. In CS SCP 20.2, a default shift pattern has been loaded to the SI_SHIFT_PATTERN shift pattern using SI_V_DEFAULT_SHIFT view as data source. In CS SCP 20.3, the default shift pattern is expected to be in SC_SHIFT_PATTERN but no shift pattern is provided for this purpose. Users must either manually create a new default shift pattern in the User Data table (SM_SHIFT_PATTERN) or one of the imported shift patterns must be selected as the default one.

These SCV entities have been updated to add the work_day_percentage property:

  • SC_RESOURCE_SHIFT_CAPACITY
  • SC_RESOURCE_UNIT_SHIFT_CAPACITY

Status is removed from SHIFT_PATTERN_LINE entity.

The SI_V_DEFAULT_SHIFT view has been removed.

These new configuration parameters have been added:

  • SCP_CAPACITY_WEEKLY_PATTERN_START_DAY
  • SCP_DEFAULT_HORIZON_END_OFFSET_DAYS

These new constraints have been added:

  • BASE_SI_SHIFT_PATTERN_FK_AEID
  • BASE_SI_SHIFT_PATTERN_LINE_FK_AEID
  • BASE_SI_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SI_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SI_RESOURCE_UNIT_SHIFT_CAPACITY_FK_AEID
  • BASE_SI_RESOURCE_SHIFT_CAPACITY_FK_AEID
  • BASE_SI_RESOURCE_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SI_RESOURCE_UNIT_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SI_RESOURCE_FK_SHIPAT
  • BASE_SI_RESOURCE_UNIT_FK_SHIPAT
  • BASE_SC_SHIFT_PATTERN_FK_AEID
  • BASE_SC_SHIFT_PATTERN_LINE_FK_AEID
  • BASE_SC_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SC_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SC_RESOURCE_UNIT_SHIFT_CAPACITY_FK_AEID
  • BASE_SC_RESOURCE_SHIFT_CAPACITY_FK_AEID
  • BASE_SC_RESOURCE_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SC_RESOURCE_UNIT_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SC_RESOURCE_FK_SHIPAT
  • BASE_SC_RESOURCE_UNIT_FK_SHIPAT
  • BASE_SM_SHIFT_PATTERN_FK_AEID
  • BASE_SM_SHIFT_PATTERN_LINE_FK_AEID
  • BASE_SM_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SM_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_FK_AEID
  • BASE_SM_RESOURCE_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SM_RESOURCE_UNIT_SHIFT_ADJUSTMENT_FK_AEID
  • BASE_SM_RESOURCE_FK_SHIPAT
  • BASE_SM_RESOURCE_UNIT_FK_SHIPAT

These constraints have been updated:

  • BASE_SI_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SI_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_PK
  • BASE_SI_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SI_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_PK
  • BASE_SC_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SC_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_PK
  • BASE_SC_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SC_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_PK
  • BASE_SM_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SM_RESOURCE_SHIFT_PATTERN_ADJUSTMENT_PK
  • BASE_SM_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_BK
  • BASE_SM_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT_PK

Added effective_from_date to the constraint definitions:

  • BASE_SI_SHIFT_PATTERN_LINE_FK_PATID
  • BASE_SC_SHIFT_PATTERN_LINE_FK_PATID
  • BASE_SM_SHIFT_PATTERN_LINE_FK_PATID

Set parent_flag to True.

These new validation rules have been added:

  • BASE SHIPAT FK AEID
  • BASE SHIPATLIN FK AEID
  • BASE RESSHIPATADJ FK AEID
  • BASE RESUNISHIPATADJ FK AEID
  • BASE RESSHICAP FK AEID
  • BASE RESUNISHICAP FK AEID
  • Base PlanConf SHIPAT FK AEID
  • Base PlanConf SHIPATLIN FK AEID
  • Base PlanConf RESSHIPATADJ FK AEID
  • Base PlanConf RESUNISHIPATADJ FK AEID
  • Base PlanConf RESSHIADJ FK AEID
  • Base PlanConf RESUNISHIADJ FK AEID
  • BASE RESSHIADJ FK AEID
  • BASE RESUNISHIADJ FK AEID
  • BASE RES FK Shift Pattern
  • BASE RESUNIT FK Shift Pattern
  • Base PlanConf RES FK Shift Pattern
  • Base PlanConf RESUNIT FK Shift Pattern
  • BASE SHIPAT UD
  • BASE SHIPATLIN UD
  • BASE RESSHICAP CapType
  • BASE RESUNISHICAP CapType

Registry definitions for these tables have been updated:

  • SI_SHIFT_PATTERN
  • SI_SHIFT_PATTERN_LINE
  • SI_RESOURCE_SHIFT_PATTERN_ADJUSTMENT
  • SI_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT
  • SI_RESOURCE_SHIFT_ADJUSTMENT
  • SI_RESOURCE_UNIT_SHIFT_ADJUSTMENT
  • SI_RESOURCE_SHIFT_CAPACITY
  • SI_RESOURCE_UNIT_SHIFT_CAPACITY
  • SC_SHIFT_PATTERN
  • SC_SHIFT_PATTERN_LINE
  • SC_RESOURCE_SHIFT_PATTERN_ADJUSTMENT
  • SC_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT
  • SC_RESOURCE_SHIFT_ADJUSTMENT
  • SC_RESOURCE_UNIT_SHIFT_ADJUSTMENT
  • SC_RESOURCE_SHIFT_CAPACITY
  • SC_RESOURCE_UNIT_SHIFT_CAPACITY
  • SM_SHIFT_PATTERN
  • SM_SHIFT_PATTERN_LINE
  • SM_RESOURCE_SHIFT_PATTERN_ADJUSTMENT
  • SM_RESOURCE_UNIT_SHIFT_PATTERN_ADJUSTMENT
  • SM_RESOURCE_SHIFT_ADJUSTMENT
  • SM_RESOURCE_UNIT_SHIFT_ADJUSTMENT

Updated default_processing_sequence based on the Foreign Keys (FK) references between tables.

The enhancements are enabled after appending the base template (base.zip) for this version.

Note: By default, this feature is enabled. No additional role or privilege is required to access this feature.