You are browsing the archive for CSR.

Oracle Scheduler Tables

Database information for Oracle Scheduler module.

  • CSR_COSTS_ALL_B
  • CSR_COSTS_ALL_TL
  • CSR_LOGS_ALL
  • CSR_STATISTICS_ALL
  • CSR_STAT_VALUES
  • CSR_TESTS_B
  • CSR_TEST_RESULTS_B
  • CSR_TIMERS_B
  • CSR_WIN_PROMIS_ALL_B
  • CSR_WIN_PROMIS_ALL_TL

Views in Oracle Scheduler Module

Views in Oracle Scheduler Module

CSR_COSTS_VL
CSR_PLAN_TASKS_V
CSR_RULE_WINDOWS_V
CSR_RULES_EXPLODED_V
CSR_RULES_TRANSLATED_V
CSR_RULES_VL
CSR_TIMERS_V
CSR_TRIP_TASKS_V
CSR_WIN_PROMIS_VL
CSR_WIN_PROMISES_V
CSR_WTP_DISPLAY_V

Oracle Scheduler Profile Options

Oracle Scheduler Module Profile Options

PROFILE OPTION SHORT CODE PROFILE OPTION NAME
CSR_MAX_TRAVEL_DIST_TO_SKIP_ACTUAL CSR: Maximum Travel Distance in kms to skip Actual Route Calculations
CSR_MINIMUM_TASK_LENGTH CSR: Minimum first task effort in minutes
CSR_DEFAULT_SHIFT_DURATION CSR: Qualified effort in minutes for determining task longer than a shift
CSR_DISTRIBUTE_LAST_EFFORT CSR: Distribute last task effort
CSR_SCHEDULER_ENFORCE_PLAN_WINDOW CSR: Enforce plan window for Scheduler plan options
CSR_FORCE_OPTIMIZER_TO_GROUP CSR: Force Optimizer to prefer grouping than cost
CSR_OPT_MIN_SUCCESS_PERCENTAGE CSR: Optimizer- Minimum percentage of successful Tasks for Trip Optimization
CSR_MAX_TRAVEL_DISTANCE_IN_GROUP CSR: Optimizer – Maximum Travel distance in kms between tasks in a group
CSR:CSR_AUTO_INSTALLED_BASE CSR: Installed base resource selection for auto schedule and autonomous scheduler
CSR:CSR_AUTO_SKILLS CSR: Skill based resource selection for auto schedule and autonomous scheduler
CSR:CSR_AUTO_CONTRACTS CSR: Contracts based resource selection for auto schedule and autonomous scheduler
CSR:CSR_AUTO_TERRITORIES CSR: Territory based resource selection for auto schedule and autonomous scheduler
CSR_WTP_THRESHOLD CSR: WTP Threshold
CSR_TDS_MODE CSR: TDS Mode
CSR_INCLUDE_COMMUTES_IN_SHIFT CSR: Include Commutes In Shift
CSR_INC_COST_HOME_EMPTY_TRIP CSR: Include commute cost to home for Empty Trip
CONSIDERTOLLROADS CSR: Consider Toll Roads with penalty
CREATELOCATION CSR: Create location
PLANSCOPE CSR: Plan scope
MAXNRPLANOPTIONS CSR: Maximum number of plan options
MAXNRSELECTEDRES CSR: Maximum selected resources
MAXOVERTIME CSR: Maximum overtime
MAXCALCULATIONTIME CSR: Maximum calculation time
LOGACTIVATED CSR: Log Activated
FUNCTIONALCLASSDELAYFACTOR0 CSR: Functional class 0 delay factor.
FUNCTIONALCLASSDELAYFACTOR1 CSR: Functional class 1 delay factor.
FUNCTIONALCLASSDELAYFACTOR2 CSR: Functional class 2 delay factor.
FUNCTIONALCLASSDELAYFACTOR3 CSR: Functional class 3 delay factor.
FUNCTIONALCLASSDELAYFACTOR4 CSR: Functional class 4 delay factor.
CALCULATIONTYPE CSR: Calculation type of TDS
CSR_CONC_UNPLANNED_TASKS_QUERY CSR: Selection of tasks for Autonomous Scheduler
CSR_AUTO_REJECT_STATUS_ID CSR: Rejected by Autonomous Scheduling Status
CSR_USE_DEFAULT_TDS CSR: Use Fixed values for Invalid addresses
CSR_FIRST_AVERAGE_SPEED CSR: First average speed for Location TDS
CSR_SECOND_AVERAGE_SPEED CSR: Second average speed for Location TDS
CSR_FIRST_BOUNDARY CSR: First Boundary for Location TDS
CSR_THIRD_AVERAGE_SPEED CSR: Third average speed for Location TDS
CSR_MINIMAL_TRAVEL_TIME CSR: Minimal travel time
CSR_SECOND_BOUNDARY CSR: Second boundary for Location TDS