Business View ibvJobCategorisation

Description

This view lists for a job the type, partner, manager and job group assigned to each. This is collectively referred to as "the standard categorisation of a job".

Where the fields are empty for a job this will be shown as a "?" making it easy to identify

 

For use by

This view is used by other views (see below), and is not intended for use by normal users on its own.

 

Columns

JobInternalId

The unseen internal identifier of the job

JobId

The visible job identifier

JobDescription

The description of the job

JobClientId

The visible identifier of the client for whom the work was done

JobClientTypeDesc

The user friendly description of type of client

JobType

The visible identifier of the job type

JobTypeDescription

The description of the job type

JobPartner

The visible identifier of the partner responsible for the job

JobPartnerName

Name of the partner responsible for the job

JobPartnerBranch

With a data centre licence this will show the branch identifier associated to the job by the partner assigned to job's

JobPartnerBranchDesc

With a data centre licence this will show the branch description associated to the job by the partner assigned to job's

JobManager

The visible identifier of the manager responsible for the job

JobManagerName

Name of the manager responsible for the manager

JobManagerBranch

With a data centre licence this will show the branch identifier associated to the job by the manager assigned to job's

JobManagerBranchDesc

With a data centre licence this will show the branch description associated to the job by the manager assigned to job's

JobGroup

The visible identifier of the job group

JobGroupDescription

The description of the job group

 

 

This view is directly inherited by the following views