14.1 sp508_audit_sp108

Table Definition

Field	Type	Default	Nullable
`timestamp`	`date`
`sequence`	`number`
`username`	`varchar2(256)`
`osuser`	`varchar2(256)`
`machine`	`varchar2(64)`
`program`	`varchar2(256)`
`session_id`	`number`
`process_id`	`varchar2(22)`
`job_no`	`number(9)`
`old_contract_start`	`date`
`new_contract_start`	`date`
`old_contract_completion`	`date`
`new_contract_completion`	`date`
`old_appointment_earliest`	`date`
`old_appointment_latest`	`date`
`new_appointment_earliest`	`date`
`new_appointment_latest`	`date`
`old_booked_duration`	`number(8)`
`new_booked_duration`	`number(8)`
`old_booked_overhead`	`number(8)`
`new_booked_overhead`	`number(8)`
`old_normalised_scheduled_dur`	`number(8)`
`new_normalised_scheduled_dur`	`number(8)`
`old_normalised scheduled_oh`	`number(8)`
`new_normalised scheduled_oh`	`number(8)`
`transaction_id`	`number(9)`
`old_fixed_rsn`	`number`
`new_fixed_rsn`	`number`
`old_fixed_user`	`varchar2(50)`
`new_fixed_user`	`varchar2(50)`
`old_rsn_date`	`date`
`new_rsn_date`	`date`
`old_fixed_cmnt`	`varchar2(255)`
`new_fixed_cmnt`	`varchar2(255)`
`old_status`	`number`
`new_status`	`number`
`old_restriction_no`	`number`
`new_restriction_no`	`number`
`OLD_REMINDER_NOTIFICATION_SENT`	`number(1)`
`NEW_REMINDER_NOTIFICATION_SENT`	`number(1)`
`OLD_PAUSED_STATE`	`number(1)`
`NEW_PAUSED_STATE`	`number(1)`
`OLD_VWDLLOCATIONTYPE`	`number(9)`
`NEW_VWDLLOCATIONTYPE`	`number(9)`
`old_offer_token`	`varchar2(60)`
`new_offer_token`	`varchar2(60)`

Keys

None.

Column Descriptions

Field	Description
`timestamp`	Date and time at which these details were saved. Uses the time zone of the DBMS server machine.
`sequence`	Unique identifier: the sequence number of the update.
`username`	DBMS user.
`osuser`	Operating system user.
`machine`	Machine logged onto.
`program`	Program name.
`session_id`	DBMS session id of the session performing the update.
`process_id`	Unix process id (pid) - a number.
`job_no`	Identifier of job.
`old_contract_start`	Contract start date before update. Uses RU Time Zone.
`old_contract_completion`	Old contract end date. Uses RU Time Zone.
`new_contract_start`	Contract start date after update. Uses RU Time Zone.
`new_contract_completion`	Contract end date. Uses RU Time Zone.
`old_appointment_earliest`	Appointment earliest date before update. Uses RU Time Zone.
`old_appointment_latest`	Appointment latest date before update. Uses RU Time Zone.
`new_appointment_earliest`	Appointment earliest date. Uses RU Time Zone.
`new_appointment_latest`	Appointment latest date. Uses RU Time Zone.
`old_booked_duration`	Original value of `14.1 sp108_job_details.booked_duration`.
`new_booked_duration`	New value of `14.1 sp108_job_details.booked_duration`.
`old_booked_overhead`	Original value of `14.1 sp108_job_details.booked_overhead`.
`new_booked_overhead`	New value of `14.1 sp108_job_details.booked_overhead`.
`old_normalised_scheduled_dur`	Original value of `14.1 sp108_job_details.normalised_scheduled_duration`.
`new_normalised_scheduled_dur`	New value of `14.1 sp108_job_details.normalised_scheduled_duration`.
`old_normalised_scheduled_oh`	Original value of `14.1 sp108_job_details.normalised_scheduled_overhead`.
`new_normalised_scheduled_oh`	New value of `14.1 sp108_job_details.normalised_scheduled_overhead`.
`transaction_id`	See `14.1 sp599_transaction_audit` for details.
`old_fixed_rsn`	Old value.
`new_fixed_rsn`	New value.
`old_fixed_user`	Old value for the user who fixed this job.
`new_fixed_user`	Old value for the user who fixed this job.
`old_rsn_date`	Old date.
`new_rsn_date`	New date.
`old_fixed_cmnt`	Old comment.
`new_fixed_cmnt`	New comment.
`old_status`	Old value of the job `status`.
`new_status`	New value of the job `status`.
`old_restriction_no`	Old value of the job `restriction_no`.
`new_restriction_no`	New value of the job `restriction_no`.
`OLD_REMINDER_NOTIFICATION_SENT`	Old value of the job `reminder_notification_sent` value in table `14.1 sp108_job_details`.
`NEW_REMINDER_NOTIFICATION_SENT`	New value of the job `reminder_notification_sent` value in table `14.1 sp108_job_details`.
`OLD_PAUSED_STATE`	Old value of the job `pause_state` value in table `14.1 sp108_job_details`.
`NEW_PAUSED_STATE`	New value of the job `pause_state` value in table `14.1 sp108_job_details`.
`OLD_VWDLLOCATIONTYPE`	Old value of the job `vwdlLocationType` value in table `14.1 sp108_job_details`.
`NEW_VWDLLOCATIONTYPE`	New value of the job `vwdlLocationType` value in table `14.1 sp108_job_details`.
`OfferToken`	The token being returned by the OfferAppt/OfferMult request and will contain the promset (SP256.listName) and timebandtype (SP259.BandType)