sp070_activity_standards

Each record in this table provides a standard job duration for a given task type.

Table Definition

Field	Type	Default
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 sp105_activity_types (activity_type)

foreign key (task_category) references sp260_task_categories (task_category)

foreign key (band_type) references sp258_band_types (band_type)

foreign key (job_category) references sp071_job_categories (job_category)

foreign key (bulk_type) references sp273_bulk_appt_types (bulk_type)

foreign key (capacity_category_no) references sp350_capacity_categories (capacity_category_no)

foreign key (field_id) references 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: 0 - jobs may not be forced 1 - jobs 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)