14.1 sp071_job_categories
- Billy Sewell (Unlicensed)
Owned by Billy Sewell (Unlicensed)
Jan 26, 2024
Loading data...
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_category | number(1) | ||
| description | varchar2(30) | ||
| field_id | varchar2(100) |
Keys
primary key (job_category)
unique (description)
foreign key (field_id) references 14.1 sp900_language_translation (field_id)
Primary Key Referenced From
Column Descriptions
| Field | Description |
|---|---|
| job_category | unique identifier for the job category |
| description | Depreciated - the name for the category displayed in user interfaces e.g. gantt menus. |
| field_id | key to language translations for description |