14.1 sp108_job_details

Table Definition

Field	Type	Default
`job_no`	`number(9)`
`contract_start`	`date`
`contract_completion`	`date`
`primary_employee`	`number(9)`
`secondary_employee`	`number(9)`
`req_emp_type`	`number(1)`
`analysis_no`	`number(9)`
`forced`	`number(9)`
`status`	`number(2)`
`offer`	`number(9)`
`booked_to_intray`	`number(1)`
`appointment_earliest`	`date`
`appointment_latest`	`date`
`overdue_time`	`number(9)`
`transaction_id`	`number(9)`
`booked_duration`	`number(8)`
`booked_overhead`	`number(8)`
`normalised_scheduled_duration`	`number(8)`
`normalised_scheduled_overhead`	`number(8)`
`requires_confirmation`	`number(1)`
`fixed_reason_no`	`number`
`user_id`	`varchar(50)`
`fixed_rsn_date`	`date`
`fixed_comment`	`varchar(255)`
`restriction_no`	`number(9)`
`Reminder_Notification_Sent`	`number(1)`	0
`PAUSED`	`number(1)`	0
`vwdlLocationType`	`number(9)`
`OfferToken`	`varchar2(60)`

Keys

Key Type	Column	Reference Table	Reference Column
primary key	`job_no`
foreign key	`primary_employee`	`14.1 sp210_employees`	`employee_no`
foreign key	`secondary_employee`	`14.1 sp210_employees`	`employee_no`
foreign key	`analysis_no`	`14.1 sp070_activity_standards`	`analysis_no`
foreign key	`req_emp_type`	`14.1 sp308_req_emp_types`	`req_emp_type`
foreign key	`fixed_reason_no`	`14.1 sp228_fixed_reasons`	`fixed_reason_no`
foreign key	`restriction_no`	`sp073_restriction_types`	`restriction_no`
foreign key	`vwdlLocationType`	`/wiki/spaces/SCH141/pages/27066920`	`location`

Column Descriptions

Field	Description
`job_no`	Job identifier.
`contract_start`	Start of the date range during which the job must be carried out. Uses RU Time Zone.
`contract_completion`	End of the date range during which the job must be carried out. Uses RU Time Zone.
`primary_employee`	Identifier of an employee who is either preferred or mandated (by the user) for the task, or who must not be assigned to the task.
`secondary_employee`	Identifier of a secondary employee who is either preferred or mandated for the task, or who must not be assigned to the task.
`req_emp_type`	Flag indicating how `primary_employee` and `secondary_employee` are to be treated - 0 - No employee preference. 1 - Either primary or secondary employee is preferred; neither is mandatory. 2 - Either primary or secondary employee must be used; no other is allowed. 3 - Either primary or secondary employee is preferred. Primary employee should be used in preference to secondary employee. 4 - Either primary or secondary employee must be used; no other is allowed. Primary employee should be used in preference to secondary employee. 5 - Both primary and secondary employee are prohibited from doing the job.
`analysis_no`	Identifier of a job analysis (activity standard) which specifies the required skill.
`forced`	Bit-field indicating which option was used to force the appointment. For values see file `spoptions.h`.
`status`	Indicates whether the job is fixed in its current position on the schedule. 0 - Job is not fixed in its position on the schedule. This is the default state. 1 - Job is fixed in its position on the schedule.
`offer`	Holds the offer options passed through ABS when booking the job.
`booked_to_intray`	This is (only) set to true when a job is booked (forced) to the intray and is then used for the 'forced' indicator on the Gantt client.
`appointment_earliest`	The earliest date and time at which an appointment can be started - uses FRU Time Zone. This field is NULL if the job is not an appointment.
`appointment_latest`	The latest date and time at which an appointment can be started - uses FRU Time Zone. This field is NULL if the job is not an appointment.
`overdue_time`	The overdue time (in minutes) of the job for both appointments and non-appointments.
`transaction_id`	See `sp599_transaction_audit` for details.
`booked_duration`	The nominal amount of working time (in minutes) that a job was predicted to take when it was booked assuming a notional operative efficiency of 100% and ignoring the effect of jobs being in same-site groups.Includes overhead time, excludes travel and break.
`booked_overhead`	The nominal amount of overhead time (in minutes) that a job was predicted to take when it was booked ignoring the effect of jobs being in same-site groups.
`normalised_scheduled_duration`	Current expected working time (in seconds) of the job assuming a notional operative efficiency of 100%. Excludes overhead time, travel and break. Updated to reflect modifications to the job's duration after booking. The content of this field is undefined if this is an All Day Job.
`normalised_scheduled_overhead`	Current expected overhead (in minutes) of the job ignoring the effect of jobs being in same-site groups. Updated to reflect modifications to the job's duration after booking. The content of this field is undefined if this is an All Day Job.
`requires_confirmation`	Indicates whether the job needs confirming with the customer. If set to 1 then it needs to be confirmed. If set to 0 then it doesn't – though it could still be confirmed anyway.
`fixed_reason_no`	If the job is fixed, this field gives the identifier for `sp228_fixed_reasons`.
`user_id`	The identifier for the user who fixed the job, if it has been fixed.
`fixed_rsn_date`	The date on which the job was fixed, with a reason.
`fixed_comment`	A textual description of why the job has been fixed.
`restriction_no`	Defines that the restriction type that a gantt user must have assigned in order to see sensitive data on this job (provided the restricted job functionality is enabled).
`Reminder_Notification_Sent`	Indicates a reminder notification has been sent. 1 is sent, 0 is not sent.
`PAUSED`	Indicates the job is paused. 1 is paused, 0 is not paused.
`vwdlLocationType`	The "Virtual Work Dynamic Location" type. 0 - Home. 1 - Work. 2 - Depot. 3 - Specified. 4 - None.
`OfferToken`	The token being returned by the OfferAppt/OfferMult request and will contain the promset (SP256.listName) and timebandtype (SP259.BandType)