14.1 sp507_audit_sp100

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)
activity_no	number(9)
job_no	number(9)
old_employee_no	number(9)
old_expected_start	date
old_expected_end	date
old_travel_time	number(6)
old_lunch_time	number(6)
old_activity_status	number(2)
old_schedule_status	number(5)
old_jeopardy_warnings	number(9)
old_last_dispatched_eta	date
old_earmark_dispatch_status	number(2)
new_earmark_dispatch_type	number(2)
new_employee_no	number(9)
new_expected_start	date
new_expected_end	date
new_travel_time	number(6)
new_lunch_time	number(6)
new_activity_status	number(2)
new_schedule_status	number(5)
new_jeopardy_warnings	number(9)
new_last_dispatched_eta	date
new_earmark_dispatch_status	number(2)
new_earmark_dispatch_type	number(2)
old_jeopardy_warnings2	number(9)
new_jeopardy_warnings2	number(9)
old_expected_duration	number(8)
new_expected_duration	number(8)
old_expected_overhead	number(8)
new_expected_overhead	number(8)
old_scheduled_duration	number(8)
new_scheduled_duration	number(8)
old_scheduled_overhead	number(8)
new_scheduled_overhead	number(8)
old_actual_duration	number(8)
new_actual_duration	number(8)
old_has_been_or_is_logged_on	number(1)
new_has_been_or_is_logged_on	number(1)
old_confirmed_state	number(1)
new_confirmed_state	number(1)
old_resp_unit_no	number(4)
new_resp_unit_no	number(4)
transaction_id	number(9)
old_eod_travel	number(6)
new_eod_travel	number(6)
old_unalloc_reason	number(2)
new_unalloc_reason	number(2)
old_last_update	date
new_last_update	date
old_last_jeopardy_update	date
new_last_jeopardy_update	date
old_rtt_travel_time	number(5)
new_rtt_travel_time	number(5)
old_rtt_travel_home	number(5)
new_rtt_travel_home	number(5)
old_rtt_route_id	varchar2(512)
new_rtt_route_id	varchar2(512)
old_manually_scheduled	number(1)
new_manually_scheduled	number(1)

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.
activity_no	Identifier of the activity.
job_no	Identifier of the job.
old_employee_no	Identifier of employee before update.
old_expected_start	Old expected start time. Uses RU Time Zone.
old_expected_end	Old expected end time. Uses RU Time Zone.
old_travel_time	Old travel time.
old_lunch_time	Old time for lunch.
old_activity_status	Old status of fault fixing activities.
old_schedule_status	Old scheduling status.
old_jeopardy_warnings	Old jeopardy flags.
old_last_dispatched_eta	Old ETA of the job when it was earmarked and dispatched - uses FRU Time Zone.
old_earmark_dispatch_status	Old current delivery status of the earmark message related to this job.
old_earmark_dispatch_type	Old type of earmark message to be delivered.
new_employee_no	Identifier of employee after update.
new_expected_start	Expected start time. Uses RU Time Zone.
new_expected_end	Expected end time. Uses RU Time Zone.
new_travel_time	Travel time.
new_lunch_time	Time for lunch.
new_activity_status	Status of fault fixing activities.
new_schedule_status	Scheduling status.
new_jeopardy_warnings	Jeopardy flags.
new_last_dispatched_eta	ETA of the job when it was earmarked and dispatched - uses FRU Time Zone.
new_earmark_dispatch_status	Current delivery status of the earmark message related to this job.
new_earmark_dispatch_type	Type of earmark message to be delivered.
old_jeopardy_warnings2	Old jeopardy flags extension.
new_jeopardy_warnings2	Jeopardy flags extension.
old_expected_duration	Original value of sp100_activities.expected_duration.
new_expected_duration	New value of sp100_activities.expected_duration.
old_expected_overhead	Original value of sp100_activities.expected_overhead.
new_expected_overhead	New value of sp100_activities.expected_overhead.
old_scheduled_duration	Original value of sp100_activities.scheduled_duration.
new_scheduled_duration	New value of sp100_activities.scheduled_duration.
old_scheduled_overhead	Original value of sp100_activities.scheduled_overhead.
new_scheduled_overhead	New value of sp100_activities.scheduled_overhead.
old_actual_duration	Original value of sp100_activities.actual_duration.
new_actual_duration	New value of sp100_activities.actual_duration.
old_has_been_or_is_logged_on	Original value of sp100_activities.has_been_or_is_logged_on.
new_has_been_or_is_logged_on	New value of sp100_activities.has_been_or_is_logged_on.
old_confirmed_state	Original value of sp100_activities.confirmed_state.
new_confirmed_state	New value of sp100_activities.confirmed_state.
old_resp_unit_no	Original value of sp100_activities. resp_unit_no.
new_resp_unit_no	New value of sp100_activities. resp_unit_no.
transaction_id	See SP599_TRANSACTION_AUDIT for details.
old_eod_travel	Old value for sp100_activities.eod_travel.
new_eod_travel	New value for sp100_activities.eod_travel.
old_unalloc_reason	Old value for sp100.activities.unalloc_reason.
new_unalloc_reason	New value for sp100_activities.unalloc_reason.
old_last_update	Old value for sp100_activities.last_update.
new_last_update	New value for sp100_activities.last_update.
old_last_jeopardy_update	Old value for sp100_activities.last_jeopardy_update.
new_last_jeopardy_update	New value for sp100_activities.last_jeopardy_update.
old_rtt_travel_time	Old value for sp100_activities.rtt_travel_time
new_rtt_travel_time	New value for sp100_activities.rtt_travel_time
old_rtt_travel_home	Old value for sp100_activities.rtt_travel_home
new_rtt_travel_home	New value for sp100_activities.rtt_travel_home
old_rtt_route_id	Old value for sp100_activities.rtt_route_id
new_rtt_route_id	New value for sp100_activities.rtt_route_id
old_manually_scheduled	Old value for sp100_activities.manually_scheduled
new_manually_scheduled	New value for sp100_activities.manually_scheduled