14.1 sp070_activity_standards
- Billy Sewell (Unlicensed)
Each record in this table provides a standard job duration for a given task type.
Table Definition
Field | Type | Default | Nullable |
|---|---|---|---|
| analysis_no | number(6) |  | |
| analysis_ref | varchar2(30) | | |
| start_date | date | | |
| end_date | date |  | |
| activity_type | number(2) | | |
| task_category | varchar2(10) | | |
| description | varchar2(40) | | |
| description2 | varchar2(6) | | |
| description3 | varchar2(6) | | |
| description4 | varchar2(6) | | |
| description5 | varchar2(6) | | |
| job_duration | number(11) | | |
| crew_size | number(2) | | |
| delay | number(3) | | |
| key_not_allowed | number(1) | | |
| forceable | number(9) | | |
| bulk_allowed | number(1) | | |
| bulk_type | number(1) | | |
| bulk_window | number(3) | | |
| bulk_offset | number(3) | | |
| bulk_origin | number(1) | | |
| exclusion | number(1) | 0 | |
| exclusion_period | number(3) | | |
| exclusion_offset | number(3) | | |
| fixed_work_loc | number(1) | 0 | |
| letter_lead_time | number(3) | | |
| band_type | varchar2(2) | | |
| band_type | varchar2(2) | | |
| job_category | number(1) | | |
| overhead_time | number(8) | | |
| capacity_category_no | number(9) | | |
| fragmentation_allowed | number(1) | | |
| min_split_job_duration | number | | |
| min_first_frag_duration | number | | |
| min_frag_duration | number | | |
| max_split_jobs | number | | |
| max_fragment_gap | number | | |
| field_id | varchar2(100) | |
Keys
primary key (analysis_no)
unique (analysis_ref)
foreign key (activity_type) references 14.1 sp105_activity_types (activity_type)
foreign key (task_category) references 14.1 sp260_task_categories (task_category)
foreign key (band_type) references 14.1 sp258_band_types (band_type)
foreign key (job_category) references 14.1 sp071_job_categories (job_category)
foreign key (bulk_type) references sp273_bulk_appt_types (bulk_type)
foreign key (capacity_category_no) references 14.1 sp350_capacity_categories (capacity_category_no)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| analysis_no | ServiceOptimizer-generated unique identifier |
| analysis_ref | End users' unique identifier (task code) |
| start_date | Date from/on which the task type is valid/was created – date only; time portion should not be used – uses sp083.tz_default |
| end_date | Date until which the task type is valid – date only; time portion should not be used – uses sp083.tz_default |
| activity_type | Activity type identifier |
| task_category | User defined category identifier |
| description | Job analysis description |
| description2 | User-defined text, described in sp303. |
| description3 | User-defined text, described in sp303. |
| description4 | User-defined text, described in sp303 |
| description5 | User-defined text, described in sp303. |
| job_duration | Standard duration in minutes for tasks of this type. |
| crew_size | No longer supported |
| delay | Number of days lead time for this type of job - i.e. the number of days which must elapse from the date of booking before the job may be carried out. |
| key_not_allowed | No longer supported |
| forceable | Flag indicating whether jobs of this type may be forced: The field is larger than a single digit to allow for future expansion, e.g. the use of 'forced' options as in sp108. |
| bulk_allowed | No longer supported |
| bulk_type | No longer supported |
| bulk_window | No longer supported |
| bulk_offset | No longer supported |
| bulk_origin | No longer supported |
| exclusion | No longer supported |
| exclusion_period | No longer supported |
| exclusion_offset | No longer supported |
| fixed_work_loc | No longer supported |
| letter_lead_time | No longer supported |
| band_type | No longer supported |
| first_part_min | Minimum duration, in minutes, for the first part of a fragmented job (a "long job") of this type. Must be in the range 0 to 1440. Defaults to 240. Not yet supported. |
| job_category | the category group to which this job type belongs. |
| overhead_time | an overhead time which is added to the normal 100% efficiency duration time for the Task Type |
| capacity_category_no | capacity category for jobs of this type |
| field_id | look up into sp900_language_translation for language translations for Description (Description2,3,4,5 are currently not translatable) |