Document toolboxDocument toolbox

sp071_job_categories

Owned by Jason Andrew
Oct 02, 2024

This table contains the set of allowable job categories. A job category is a grouping of job types (sp070_activity_standards) which allow jobs to be filtered for display in the gantt's intray report. A job category can also have a limited number of scheduler parameters applied with specific values for that category (sp072_job_category_parameters)

 

Table Definition

Field
Type
Default
Nullable
job_categorynumber(1)  
descriptionvarchar2(30)  
field_idvarchar2(100)  

Keys 

primary key (job_category) 
unique (description) 
foreign key (field_id) references sp900_language_translation (field_id)

Primary Key Referenced From

 

Column Descriptions

FieldDescription
job_categoryunique identifier for the job category 
description Depreciated - the name for the category displayed in user interfaces e.g. gantt menus. 
field_idkey to language translations for description

 

 

Â