FFS_BUSINESS_RULE
Stores most of single-value parameters configured on company level.
Details
-
Schema: FUSION
-
Object owner: FFS
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
FFS_BUSINESS_RULE_PK |
BUSINESS_RULE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| IDENTIFIER | VARCHAR2 | 256 | Unique string used to identify company. If it is found in URL, it is assumed that user belongs to this company. | ||
| POPTIONS | NUMBER | 10 | Yes | Binary shift options: [bit0]: Notify Setup [1]:Notify 24h [2]:Notify 60 [3]:Notify30 [5]: Manual queue assignment [6]:All-day jobs [8]:Customer has guaranteed service window [9]: Automatic provider assignment 1- feature is enabled, 0 disabled [11] 'Break'. | |
| DEFAULT_LANGUAGE | NUMBER | 3 | Yes | ID of the company default language. | |
| DEFAULT_THEME | NUMBER | 10 | Yes | ID of the company default theme. | |
| DELAY_THRESHOLD | NUMBER | 8 | Yes | System will email alert to dispatcher's email, if technician reports delay greater than this value. | |
| REPLY_TO | VARCHAR2 | 1020 | The default value for the company email. Used as an senders address. | ||
| SW_THRESHOLD | NUMBER | 8 | Yes | Alert parent provider if appt was not started service_window_threshold before its availability_window_end. If 0 - feature is disabled. If set corresponding message (. | |
| SLA_THRESHOLD | NUMBER | 8 | Yes | It is the SLA Warning alert parameter. | |
| NOT_STARTED_THRESHOLD | NUMBER | 8 | Yes | Alert settings for 'Activity Has Not Been Started after ETA'. Value in minutes.. | |
| NOT_ACTIVATED_THRESHOLD | NUMBER | 8 | Yes | Alert settings for 'Route Has Not Been Started After the Start Time of Resource Day'. Value in minutes. | |
| DEFAULT_DURATION_AVG | NUMBER | 10 | Yes | Default appointment duration length. Used when there is no statistics stored for the worktype. | |
| DEFAULT_TRAVEL_AVG | NUMBER | 10 | Yes | Default travel length. Used when there is no available statistics for the pair zip from-zip to. | |
| DELIVERY_WINDOW_FACTOR | NUMBER | Yes | Factor that is used to multiply deviation to get delivery window. | ||
| DELIVERY_WINDOW_GRANULARITY | NUMBER | 10 | Yes | Number of minutes, value should be rounded to. 0/1 - don't round, 5 - round to 5 minutes, 10 - round to 10 minutes, 15 - round to quarters, 30 - round to half an hours, 60 - round to full hours. | |
| DELIVERY_WINDOW_MINIMAL_SIZE | NUMBER | 10 | Yes | Defines the number of minutes to which Delivery Window values will be rounded. Value in minutes. | |
| DELIVERY_WINDOW_MAXIMAL_SIZE | NUMBER | 10 | Yes | Defines the number of minutes to which Delivery Window values will be rounded. Value in minutes. | |
| DELIVERY_WINDOW_START_CONSTR | NUMBER | 10 | Yes | Delivery window should not start earlier than ### minutes prior to start of service or SLA window. | |
| STATS_TRAVEL_MIN_VALUE | NUMBER | 10 | Yes | Lower threshold of stats travel values (minutes). | |
| STATS_TRAVEL_MAX_VALUE | NUMBER | 10 | Yes | Upper threshold of stats travel values (minutes). | |
| TRAVEL_KEY_AVG_MIN_ACTY_COUNT | NUMBER | 10 | Yes | Minimum number of travel records to use average calculated on the travel key level. | |
| TRAVEL_KEY_AVG_MIN_USED_KEYS | NUMBER | 10 | Yes | Minimum percent of unique origin travel keys to use average calculated on the travel key level. | |
| STATS_AIRLINE_DIST_MIN_VALUE | NUMBER | Yes | Lower threshold of stats stdairline_distance values (degrees). | ||
| STATS_AIRLINE_DIST_MAX_VALUE | NUMBER | Yes | Upper threshold of stats stdairline_distance values (degrees). | ||
| STATS_DURATION_MIN_VALUE | NUMBER | 10 | Yes | Lower threshold of stats duration values (minutes). | |
| STATS_DURATION_MAX_VALUE | NUMBER | 10 | Yes | Upper threshold of stats duration values (minutes). | |
| STATS_GROUP_FACTOR | NUMBER | Yes | Numeric value of the Group Factor. Default value is 2. | ||
| STATS_CUTTING_FACTOR | NUMBER | Yes | Numeric value of the Statistic Cutting Factor. Default value is 0.3. | ||
| STATS_DEVIATION_COEFFICIENT | NUMBER | 8 | Yes | Numeric value of the Statistic Deviation Coefficient. Default value is 0.30. | |
| STATS_DURATION_CURRENT_METHOD | VARCHAR2 | 16 | Use statistics generated by this method. | ||
| STATS_DURATION_NL_CORR_FACTOR | NUMBER | Yes | Correction factor for stats duration natural learning method. | ||
| STATS_DURATION_NL_CORR_MAX | NUMBER | Yes | Max correction for stats duration natural learning method. | ||
| STATS_DURATION_VERSION_STAMP | VARCHAR2 | 1020 | Stats duration statistics calculation version. | ||
| STATS_TRAVEL_VERSION_STAMP | VARCHAR2 | 1020 | Stats travel statistics calculation version. | ||
| STATS_STARTTIME_VERSION_STAMP | VARCHAR2 | 1020 | Version of start-time statistics. | ||
| STATS_STARTTIME_MIN_ACT_NUM | NUMBER | 5 | Yes | Minimum number of activities per statistical record. | |
| NOTIFY30_60 | VARCHAR2 | 21 | Notification base time for calculation time ranges for 'Remainder' and 'Today' messages. | ||
| ZIP_FORMAT_ID | NUMBER | 10 | Yes | Zip Format ID value. Deprecated parameter. | |
| STATE_FORMAT_ID | NUMBER | 10 | Yes | State Format ID value. Deprecated parameter. | |
| REMINDER_SILENT_INTERVAL | NUMBER | 10 | Yes | Configuration parameter for the 'Reminder' launch condition. Number of minutes before or after reminder time when 'Change' notifications are not sent. | |
| REMINDER_INTERVAL_LIST | VARCHAR2 | 120 | Configuration parameter for the 'Reminder' launch condition. Lists of allowed values for reminder time in minutes separated by comma. | ||
| FLOW_ID_REMINDER | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Reminder' launch condition. | ||
| FLOW_ID_TODAY_1 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Change 1' launch condition. | ||
| FLOW_ID_TODAY_2 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Change 2' launch condition. | ||
| FLOW_ID_TODAY_3 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Change 3' launch condition. | ||
| FLOW_ID_TODAY_4 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Change 4' launch condition. | ||
| FLOW_ID_TODAY_5 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Change 5' launch condition. | ||
| FLOW_ID_DAY_BEFORE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Day before' launch condition. | ||
| FLOW_ID_ACTIVATE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Route is activated' launch condition. | ||
| FLOW_ID_DEACTIVATE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Route is deactivated' launch condition. | ||
| FLOW_ID_REACTIVATE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Route is reactivated' launch condition. | ||
| FLOW_ID_ADD | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Add' launch condition. | ||
| FLOW_ID_COMPLETE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is completed' launch condition. | ||
| FLOW_ID_CANCEL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is canceled' launch condition. | ||
| FLOW_ID_NOTDONE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is not done' launch condition. | ||
| FLOW_ID_DELAY | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is delayed' launch condition. | ||
| FLOW_ID_SUSPEND | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is suspended' launch condition. | ||
| FLOW_ID_START_WARNING | NUMBER | 10 | Deprecated field, can be removed. | ||
| FLOW_ID_MANUAL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Manual' launch condition. | ||
| FLOW_ID_CALL_AHEAD | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Call ahead' launch condition. | ||
| FLOW_ID_NOT_STARTED_1 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Not started 1' launch condition. | ||
| FLOW_ID_NOT_STARTED_2 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Not started 2' launch condition. | ||
| FLOW_ID_SW_WARNING | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Service window warning' launch condition. | ||
| FLOW_ID_SLA_WARNING | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'SLA warning' launch condition. | ||
| FLOW_ID_IVR | NUMBER | 10 | Deprecated field, can be removed. | ||
| FLOW_ID_INSTALL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Install inventory' launch condition. | ||
| FLOW_ID_DEINSTALL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Deinstall inventory' launch condition. | ||
| FLOW_ID_EXCHANGE | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Exchange inventory' launch condition. | ||
| FLOW_ID_UNDO_INSTALL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Undo install inventory' launch condition. | ||
| FLOW_ID_UNDO_DEINSTALL | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Undo deinstall inventory' launch condition. | ||
| FLOW_ID_MOVE_ACTIVITY | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is moved' launch condition. | ||
| FLOW_ID_START | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Activity is started' launch condition. | ||
| FLOW_ID_MOVE_INVENTORY | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Move inventory' launch condition. | ||
| START_TODAY_1 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the 'Change 1' launch condition. | |
| END_TODAY_1 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the 'Change 1' launch condition. | |
| THRESHOLD_TODAY_1 | NUMBER | 10 | Yes | Notification threshold for the 'Change 1' launch condition. | |
| START_TODAY_2 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the 'Change 2' launch condition. | |
| END_TODAY_2 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the 'Change 2' launch condition. | |
| THRESHOLD_TODAY_2 | NUMBER | 10 | Yes | Notification threshold for the 'Change 2' launch condition. | |
| START_TODAY_3 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the 'Change 3' launch condition. | |
| END_TODAY_3 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the 'Change 3' launch condition. | |
| THRESHOLD_TODAY_3 | NUMBER | 10 | Yes | Notification threshold for the 'Change 3' launch condition. | |
| START_TODAY_4 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the 'Change 4' launch condition. | |
| END_TODAY_4 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the 'Change 4' launch condition. | |
| THRESHOLD_TODAY_4 | NUMBER | 10 | Yes | Notification threshold for the 'Change 4' launch condition. | |
| START_TODAY_5 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the 'Change 5' launch condition. | |
| END_TODAY_5 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the 'Change 5' launch condition. | |
| THRESHOLD_TODAY_5 | NUMBER | 10 | Yes | Notification threshold for the 'Change 5' launch condition. | |
| NOT_STARTED_1_TIME | NUMBER | 10 | Yes | Threshold for the 'Not started 1' launch condition. Contains time in minutes after estimated activity start to launch the scenario if activity has not been started. | |
| NOT_STARTED_2_TIME | NUMBER | 10 | Yes | Threshold for the 'Not started 2' launch condition. Contains time in minutes after estimated activity start to launch the scenario if activity has not been started. | |
| SW_WARNING_TIME | NUMBER | 10 | Yes | Threshold for the 'Service window warning' launch condition. Contains time in minutes before the service window start of an activaty to launch the scenario if the activity has not been started. | |
| SLA_WARNING_TIME | NUMBER | 10 | Yes | Threshold for the 'SLA warning' launch condition. Contains time in minutes before the SLA end of an activaty to launch the scenario if the activity has not been completed. | |
| MOBILE_RESOURCE_COUNT | NUMBER | 10 | Yes | Limit for the Number of Resources per Page. | |
| MOBILE_ACTIVITY_COUNT | NUMBER | 10 | Yes | Limit for the Number of Activities per Page. | |
| MOBILE_INVENTORY_COUNT | NUMBER | 10 | Yes | Limit for the Number of Equipment per Page. | |
| MOBILE_TEXTAREA_COLS | NUMBER | 10 | Yes | Deprecated, Will be removed soon. | |
| CUT_LIMIT | NUMBER | 10 | Yes | Cut limit for History DB. Value in days. | |
| MAP_COUNTRY_CODE | VARCHAR2 | 8 | Default country name. Global default value for geocoding. | ||
| DEFAULT_CODEPAGE | VARCHAR2 | 1020 | Default codepage identifier. Example: ISO-8859-1. | ||
| ACTIONS_LINKS_NUM | NUMBER | 10 | Yes | Deprecated. Will be removed soon. | |
| GPS_RESOURCE_IDENTIFY | VARCHAR2 | 1020 | Resource identifier for GPS SOAP API enum: ('0','external_id'). | ||
| GEO_TYPE | VARCHAR2 | 10 | Geocoding Type. Values: 'disabled', 'on_request', 'automatic'. Default value is 'automatic'. | ||
| GEO_FROM | NUMBER | 5 | Geocoding service parameter. From Time. | ||
| GEO_TO | NUMBER | 5 | Geocoding service parameter. To Time. | ||
| GEO_INTERVAL | NUMBER | 10 | Geocoding parameter. Execution interval. | ||
| WEEK_START | NUMBER | 3 | Yes | First Day of the Week. Numeric value. 0 - Sunday. | |
| AIRLINE_DIST_WEIGHT | NUMBER | 8 | Yes | Weight coefficient from 0 to 1 that points at the part of the airline distance method in the travel time estimation. | |
| AIRLINE_DIST_SPEED | NUMBER | 8 | Yes | Speed that is actually used to calculate the travel time, based on the straight line distance between the locations with coordinates, km/h. It is a configurable parameter. | |
| AIRLINE_DIST_SPEED_RECOMM | NUMBER | 8 | Yes | Speed that is recommended for use to calculate airline travel time, km/h. The parameter is calculated on the basis of reported data. | |
| DISTANCE_UNITS | VARCHAR2 | 5 | Distance units. Values: 'miles', 'km'. | ||
| DURATION_DEV_LIMIT_DOWN | NUMBER | 3 | Yes | Lower limit of personal ratio for duration calculation. | |
| DURATION_DEV_LIMIT_UP | NUMBER | 5 | Yes | Upper limit of personal ratio for duration calculation. | |
| MOBILE_CALENDAR_FUTURE_DAYS | NUMBER | 10 | Yes | Number of Future Days to View in My Route and Activity List. | |
| FLOW_ID_VISIT_REMINDER | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Visit reminder' launch condition. | ||
| VISIT_REMINDER_INTERVAL | NUMBER | 10 | Yes | Configuration parameter for the 'Visit reminder' launch condition. Specifies the value for reminder time in minutes. | |
| VISIT_REMINDER_SILENT_INTERVAL | NUMBER | 10 | Yes | Configuration parameter for the 'Visit reminder' launch condition. Number of minutes before or after the reminder time when 'Visit change' notifications are not sent. | |
| FLOW_ID_VISIT_TODAY_1 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the Visit Reminder Event 'Change 1'. | ||
| START_VISIT_TODAY_1 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the Visit Reminder Event 'Change 1'. | |
| END_VISIT_TODAY_1 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the Visit Reminder Event 'Change 1'. | |
| THRESHOLD_VISIT_TODAY_1 | NUMBER | 10 | Yes | Notification threshold for the Visit Reminder Event 'Change 1'. | |
| FLOW_ID_VISIT_TODAY_2 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the Visit Reminder Event 'Change 2'. | ||
| START_VISIT_TODAY_2 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the Visit Reminder Event 'Change 2'. | |
| END_VISIT_TODAY_2 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the Visit Reminder Event 'Change 2'. | |
| THRESHOLD_VISIT_TODAY_2 | NUMBER | 10 | Yes | Notification threshold for the Visit Reminder Event 'Change 2'. | |
| FLOW_ID_VISIT_TODAY_3 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the Visit Reminder Event 'Change 3'. | ||
| START_VISIT_TODAY_3 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the Visit Reminder Event 'Change 3'. | |
| END_VISIT_TODAY_3 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the Visit Reminder Event 'Change 3'. | |
| THRESHOLD_VISIT_TODAY_3 | NUMBER | 10 | Yes | Notification threshold for the Visit Reminder Event 'Change 3'. | |
| FLOW_ID_VISIT_TODAY_4 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the Visit Reminder Event 'Change 4'. | ||
| START_VISIT_TODAY_4 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the Visit Reminder Event 'Change 4'. | |
| END_VISIT_TODAY_4 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the Visit Reminder Event 'Change 5'. | |
| THRESHOLD_VISIT_TODAY_4 | NUMBER | 10 | Yes | Notification threshold for the Visit Reminder Event 'Change 4'. | |
| FLOW_ID_VISIT_TODAY_5 | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the Visit Reminder Event 'Change 5'. | ||
| START_VISIT_TODAY_5 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and begining of the Visit Reminder Event 'Change 5'. | |
| END_VISIT_TODAY_5 | NUMBER | 10 | Yes | Number of minutes between activity estimated start time and ending of the Visit Reminder Event 'Change 5'. | |
| THRESHOLD_VISIT_TODAY_5 | NUMBER | 10 | Yes | Notification threshold for the Visit Reminder Event 'Change 5'. | |
| FLOW_ID_VISIT_DAY_BEFORE | NUMBER | 10 | Visit reminder event for 'day before'. Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | ||
| FLOW_ID_VISIT_CANCEL | NUMBER | 10 | Event for 'cancel' visit event. Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | ||
| FLOW_ID_VISIT_COMPLETE | NUMBER | 10 | Event for 'visit complete' event. Link to the unique identifier of the notification scenario (ffs_message_flow->flow_id). | ||
| VISIT_NOTIFICATION_BASE | VARCHAR2 | 21 | Describes the attribute of activity which is used as the notification base time for the Visit related launch conditions. | ||
| FLOW_ID_NOT_ACTIVATED | NUMBER | 10 | Link to FFS_MESSAGE_FLOW->FLOW_ID. Specifies which notification scenario is used by the 'Not activated' launch condition. | ||
| NOT_ACTIVATED_TIME | NUMBER | 10 | Yes | Number of minutes after the planned start of the working day after which the 'Not activated' launch condition is triggered for not activated routes. | |
| WORKING_TIME_SINCE_MIDNIGHT | NUMBER | 3 | Yes | Overnight work. Working time in hours since midnight. | |
| TIME_ZONE_ID | NUMBER | 3 | Yes | Customer Time Zone. Reference to the ffs_time_zone->TIME_ZONE_ID. | |
| FLOW_ID_UPDATE_ACTIVITY_1 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ACTIVITY_2 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ACTIVITY_3 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ACTIVITY_4 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ACTIVITY_5 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ROUTE_1 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ROUTE_2 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ROUTE_3 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ROUTE_4 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| FLOW_ID_UPDATE_ROUTE_5 | NUMBER | 10 | Deprecated, Will be removed soon. | ||
| QTS_OVERLOAD_THRESHOLD_1 | NUMBER | 5 | Yes | Percent of used capacity that is considered as major capacity usage. | |
| QTS_OVERLOAD_THRESHOLD_2 | NUMBER | 5 | Yes | Percent of used capacity that is considered as critical capacity usage. | |
| EMAIL_REGEX | VARCHAR2 | 1020 | Regular expression to validate email addresses. | ||
| PHONE_REGEX | VARCHAR2 | 1020 | Regular expression to validate phone numbers. | ||
| SOFT_SKILL_THRESHOLD | NUMBER | 3 | Yes | It defines when an activity work skill should be used as a restriction on assignment. | |
| DEPARTURE_PARKING_TIME | NUMBER | 5 | Yes | Time In Minutes To Be Added To A Travel Time Calculated By Airline Distance Method. | |
| DEPARTURE_PARKING_TIME_RECOMM | NUMBER | 5 | Yes | Recommended Value of The Departure_Parking_Time, minutes. It is calculated on the basis of the reported data. | |
| CURRENT_STARTUP_ID | VARCHAR2 | 1020 | ID of a previous app server startup. | ||
| TRAVEL_TIME_COLOR | VARCHAR2 | 6 | It is a value of color for a travel time bar on Time View. | ||
| SMARTGPS_START_END_RADIUS | NUMBER | 10 | Yes | Determines alerting functionality for start/end activity radius (meters). Works per session. | |
| SMARTGPS_IDLE_RADIUS | NUMBER | 10 | Yes | Determines alerting functionality for idle radius (meters). Works per session. | |
| SMARTGPS_IDLE_TIMEOUT | NUMBER | 10 | Yes | Determines alerting functionality for idle timeout (minutes). Works per session. | |
| MAP_FADE_RES_THRESHOLD | NUMBER | 10 | Yes | Time in minutes after which a resource icon on a map has to be faded. | |
| MAP_HIDE_RES_THRESHOLD | NUMBER | 10 | Yes | Time in minutes after which a resource icon on a map has to be hidden. | |
| HISTORY_USER_TYPE_ID | NUMBER | 5 | Yes | History User Type. The user type to be used to build the identifiers of objects (activities, inventory, and service requests) that are to be logged into the history.. Reference to the ffs_utype->TYPE_ID. | |
| QTS_DAY_COLUMNS | VARCHAR2 | 1020 | Quota view: full ordered list of columns that can be shown (day level). | ||
| QTS_DAY_DEFAULT_COLUMNS | VARCHAR2 | 1020 | Quota view: default columns (day level). | ||
| QTS_TS_COLUMNS | VARCHAR2 | 1020 | Quota view: full ordered list of columns that can be shown (time slot level). | ||
| QTS_TS_DEFAULT_COLUMNS | VARCHAR2 | 1020 | Quota view: default columns (time slot level). | ||
| QTS_CATEGORY_COLUMNS | VARCHAR2 | 1020 | Quota view: full ordered list of columns that can be shown (category level). | ||
| QTS_CATEGORY_DEFAULT_COLUMNS | VARCHAR2 | 1020 | Quota view: default columns (category level). | ||
| QUOTA_RECALC_START_DAY | NUMBER | 5 | Yes | Start day for the automatic recalculation of available capacity and quota. | |
| QUOTA_RECALC_TIME | NUMBER | 5 | Yes | Minutes; delay between two consequent automatic recalculations of available capacity and quota. | |
| QUOTA_RECALC_PERIOD | NUMBER | 5 | Yes | Number of future days or calendar weeks the capacity/quota should be recalculated for. | |
| QUOTA_RECALC_PERIOD_UOM | VARCHAR2 | 14 | Units of measurement the recalculation period is defined in. | ||
| QUOTA_UOM | VARCHAR2 | 8 | Units of measurement to show the quota/used values in. | ||
| QUOTA_HOURS_PER_FTE | NUMBER | 5 | Yes | Number of working hours per man-day. | |
| STATS_STARTTIME_ETA_WEIGHT | NUMBER | 8 | Yes | Business rules weight of starttime ETA statistics. | |
| STATS_STARTTIME_SW_WGHT | NUMBER | 8 | Yes | Weight of service window statistics. | |
| STATS_STARTTIME_SLA_WGHT | NUMBER | 8 | Yes | Business rules weight of starttime ETA statistics. | |
| REOPT_MIN_LATE_ARRIV_PENALTY | NUMBER | 10 | Yes | High level of Late Arrival Penalty for Reoptimization. | |
| REOPT_MIN_NON_ASSIGN_COST | NUMBER | Yes | High level of Non Assignment Cost for Reoptimization. | ||
| FUTURE_DAYS_LIMIT | NUMBER | 10 | Yes | Maximum number of future days available in GUI and API. | |
| BOOKING_NUM_OF_AVAIL_DAYS | NUMBER | 5 | Yes | Number of days to be checked/returned for quota based booking. | |
| BOOKING_MIN_TIME_TO_TS_END | NUMBER | 10 | Yes | Minimum required time that should be remain till end of a time slot that is available for booking. | |
| IDLE_TIME_DISPLAY_THRESHOLD | NUMBER | 10 | Yes | Threshold to display idle time (minutes). | |
| OUTBOUND_CONFIGURATION_STATUS | NUMBER | 3 | Yes | Outbound configuration status for all message agents. | |
| FTE_DURATION | NUMBER | 3 | Yes | Full-time equivalent. Value in hours. | |
| STATS_TRAVEL_SLT_DATA_WGHT | NUMBER | 5 | Yes | Default weight value for records added to the stats_travel_street_level_data table. | |
| POST_CODE_LEVEL_TRAVEL_WGHT | NUMBER | 5 | Yes | Weight of postcode-postcide street level routing results. | |
| STATS_TRAVEL_MAX_PATCH_SIZE | NUMBER | 10 | Yes | Maximum number of records in stats_travel_matrix_data_patch table. | |
| ACTIVITY_URGENT_PROP_ID | NUMBER | 8 | Yes | It is a appointment priority property name. | |
| ACTIVITY_URGENT_PROP_VALUES | VARCHAR2 | 255 | It is a appointment priority property hot list for urgent assignment. | ||
| ACTIVITY_NORMAL_PROP_VALUES | VARCHAR2 | 255 | It is a appointment priority property hot list for usual assignment. | ||
| STATS_DURATION_NL_RECALC | NUMBER | 3 | Yes | Run duration with recalc first time after Upgrade. | |
| QBI_BOOKING_STATUS_INTERVALS | VARCHAR2 | 1020 | Comma-separated list. This value is used to show Available capacity and Max available resources and also as the default value for Booking intervals (if not altered via area configuration). | ||
| QBI_MAX_AVAILABLE_INTERVALS | VARCHAR2 | 1020 | Comma-separated list of time-intervals. | ||
| QBI_AVAILABLE_INTERVALS | VARCHAR2 | 1020 | Comma-separated list of time intervals. | ||
| FIELD_RESOURCE_LANDING_PAGE | VARCHAR2 | 13 | Field Resource Landing Page. The page that must be displayed to field resources, when they log in to the installed app. | ||
| SLR_PARKING_TIME | NUMBER | 12 | Yes | Departure/parking Time Constant that is calculated on the basis of SLT-sourced data. | |
| SLR_SPEED_INV | NUMBER | 12 | Yes | Inverted Speed of travel based on the straight line distance between the locations with coordinates. The parameter is calculated on the basis of SLT-sourced data. | |
| REPORTED_PARKING_TIME | NUMBER | 12 | Yes | Parking time constant found from technician-reported data. | |
| REPORTED_SPEED_INV | NUMBER | 12 | Yes | Speed constant found from technician-reported data. | |
| REPORTED_PARKING_TIME_SHORT | NUMBER | 12 | Yes | Parking time constant found from technician-reported data for small range. | |
| REPORTED_SPEED_INV_SHORT | NUMBER | 12 | Yes | Speed constant found from technician-reported data for small range. | |
| STATS_TRAVEL_UPGRADE | NUMBER | 3 | Yes | Upgrade status of travel script. | |
| USER_EMAIL_PROPERTY_ID | NUMBER | 8 | Yes | Property ID contains user email. | |
| RESET_PASSWORD_ENABLED | NUMBER | 3 | Yes | Enablement for reset password functionality. | |
| INSTANT_MASS_DAY_ACTIVITY | NUMBER | 3 | Yes | Contains number of days for automatic exposing mass and repeating activities in API. If value is 0: activities will appear only when necessary. Maximum value: 30 days. | |
| USE_SPEED_PARKING_TIME | NUMBER | 1 | Flag to use travel key level speed and parking time. | ||
| NEARBY_RADIUS | NUMBER | 5 | Yes | Nearby Radius. Value in kilometres. | |
| NEARBY_SLA | NUMBER | 5 | Yes | Business Rules 'Nearby SLA' flag. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| BUSINESS_RULE_ID | NUMBER | 1 | Yes | Contains unique identifier of the row. System generated. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| FFS_BUSINESS_RULE_PK | Unique | DATA | BUSINESS_RULE_ID, ORA_SEED_SET1 |
| FFS_BUSINESS_RULE_PK1 | Unique | DATA | BUSINESS_RULE_ID, ORA_SEED_SET2 |