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
You are browsing the archive for CSR.
by oracleguru
by oracleguru
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 |
by oracleguru
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 |