Document toolboxDocument toolbox

sp507_audit_sp100

Owned by Jason Andrew
Oct 02, 2024
2 min read

This table provides an audit trail of changes made to table sp100_activities.

HouseKeeping

This table is tidied by sp_dbtidy's Audit group.

 

Table Definition

Field
Type
Default
Nullable
timestampdate (tick)
sequencenumber (tick)
usernamevarchar2(256) (tick)
osuservarchar2(256) (tick)
machinevarchar2(64) (tick)
programvarchar2(256) (tick)
session_idnumber (tick)
process_idvarchar2(22) (tick)
activity_nonumber(9) (tick)
job_nonumber(9) (tick)
old_employee_nonumber(9) (tick)
old_expected_startdate (tick)
old_expected_enddate (tick)
old_travel_timenumber(6) (tick)
old_lunch_timenumber(6) (tick)
old_activity_statusnumber(2) (tick)
old_schedule_statusnumber(5) (tick)
old_jeopardy_warningsnumber(9) (tick)
old_last_dispatched_etadate (tick)
old_earmark_dispatch_statusnumber(2) (tick)
new_earmark_dispatch_typenumber(2) (tick)
new_employee_nonumber(9) (tick)
new_expected_startdate (tick)
new_expected_enddate (tick)
new_travel_timenumber(6) (tick)
new_lunch_timenumber(6) (tick)
new_activity_statusnumber(2) (tick)
new_schedule_statusnumber(5) (tick)
new_jeopardy_warningsnumber(9) (tick)
new_last_dispatched_etadate (tick)
new_earmark_dispatch_statusnumber(2) (tick)
new_earmark_dispatch_typenumber(2) (tick)
old_jeopardy_warnings2number(9) (tick)
new_jeopardy_warnings2number(9) (tick)
old_expected_duration number(8) (tick)
new_expected_duration number(8) (tick)
old_expected_overhead number(8) (tick)
new_expected_overhead number(8) (tick)
old_scheduled_duration number(8) (tick)
new_scheduled_duration number(8) (tick)
old_scheduled_overhead number(8) (tick)
new_scheduled_overhead number(8) (tick)
old_actual_duration number(8) (tick)
new_actual_duration number(8) (tick)
old_has_been_or_is_logged_on number(1) (tick)
new_has_been_or_is_logged_on number(1) (tick)
old_confirmed_statenumber(1)  (tick)
new_confirmed_statenumber(1)  (tick)
old_resp_unit_no number(4) (tick)

new_resp_unit_no

number(4) (tick)
transaction_idnumber(9) (tick)
old_eod_travelnumber(6) (tick)
new_eod_travelnumber(6) (tick)
old_unalloc_reasonnumber(2) (tick)
new_unalloc_reasonnumber(2) (tick)
old_last_updatedate (tick)
new_last_updatedate (tick)
old_last_jeopardy_updatedate (tick)
new_last_jeopardy_updatedate (tick)
old_rtt_travel_timenumber(5) (tick)
new_rtt_travel_timenumber(5) (tick)
old_rtt_travel_homenumber(5) (tick)
new_rtt_travel_homenumber(5) (tick)
old_rtt_route_idvarchar2(512) (tick)
new_rtt_route_idvarchar2(512) (tick)
old_manually_schedulednumber(1) (tick)
new_manually_schedulednumber(1) (tick)

Keys

None.

Column Descriptions

FieldDescription
timestampDate 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.
usernameDBMS user. 
osuser Operating system user.
machineMachine logged onto. 
programProgram name. 
session_idDBMS session id of the session performing the update. 
process_idUnix process id (pid) - a number. 
activity_no Identifier of the activity.
job_no Identifier of the job.
old_employee_noIdentifier of employee before update. 
old_expected_startOld expected start time. Uses RU Time Zone. 
old_expected_end Old expected end time. Uses RU Time Zone.
old_travel_timeOld travel time.
old_lunch_timeOld time for lunch.
old_activity_statusOld status of fault fixing activities. 
old_schedule_status Old scheduling status.
old_jeopardy_warningsOld jeopardy flags. 
old_last_dispatched_etaOld ETA of the job when it was earmarked and dispatched - uses FRU Time Zone. 
old_earmark_dispatch_statusOld current delivery status of the earmark message related to this job. 
old_earmark_dispatch_typeOld type of earmark message to be delivered. 
new_employee_noIdentifier of employee after update. 
new_expected_startExpected start time. Uses RU Time Zone.
new_expected_endExpected end time. Uses RU Time Zone.
new_travel_time Travel time.
new_lunch_timeTime for lunch. 
new_activity_statusStatus of fault fixing activities. 
new_schedule_statusScheduling status.
new_jeopardy_warningsJeopardy flags. 
new_last_dispatched_etaETA 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_typeType of earmark message to be delivered. 
old_jeopardy_warnings2Old jeopardy flags extension. 
new_jeopardy_warnings2 Jeopardy flags extension.
old_expected_durationOriginal value of sp100_activities.expected_duration.
new_expected_durationNew value of sp100_activities.expected_duration.
old_expected_overheadOriginal 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_durationNew value of sp100_activities.scheduled_duration.
old_scheduled_overheadOriginal value of sp100_activities.scheduled_overhead. 
new_scheduled_overheadNew value of sp100_activities.scheduled_overhead. 
old_actual_durationOriginal value of sp100_activities.actual_duration. 
new_actual_durationNew value of sp100_activities.actual_duration. 
old_has_been_or_is_logged_onOriginal 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_stateOriginal value of sp100_activities.confirmed_state. 
new_confirmed_stateNew value of sp100_activities.confirmed_state. 
old_resp_unit_no Original value of sp100_activities. resp_unit_no.
new_resp_unit_noNew value of sp100_activities. resp_unit_no.
transaction_idSee SP599_TRANSACTION_AUDIT for details.
old_eod_travelOld value for sp100_activities.eod_travel. 
new_eod_travelNew value for sp100_activities.eod_travel. 
old_unalloc_reasonOld value for sp100.activities.unalloc_reason. 
new_unalloc_reasonNew value for sp100_activities.unalloc_reason. 
old_last_update Old value for sp100_activities.last_update.
new_last_updateNew value for sp100_activities.last_update.
old_last_jeopardy_update Old value for sp100_activities.last_jeopardy_update.
new_last_jeopardy_updateNew value for sp100_activities.last_jeopardy_update.
old_rtt_travel_timeOld value for sp100_activities.rtt_travel_time
new_rtt_travel_timeNew value for sp100_activities.rtt_travel_time
old_rtt_travel_homeOld value for sp100_activities.rtt_travel_home
new_rtt_travel_homeNew value for sp100_activities.rtt_travel_home
old_rtt_route_idOld value for sp100_activities.rtt_route_id
new_rtt_route_idNew value for sp100_activities.rtt_route_id
old_manually_scheduledOld value for sp100_activities.manually_scheduled
new_manually_scheduledNew value for sp100_activities.manually_scheduled