sp104_activity_status

This table records the history of status changes for fault and appointment activities.

Note that this table is not currently populated and is deprecated from V9.0.

Table Definition

Field	Type	Default
activity_no	number(9)
update_time	date	sysdate
status	number(2)

Keys

primary key (activity_no, update_time, status)
foreign key (activity_no) references sp100_activities (activity_no)
foreign key (status) references sp117_status_descriptions (status)

Column Descriptions

Field	Description
activity_no	The activity identifier.
update_time	The time the status was updated. Uses the time zone of the DBMS server machine.
status	The new status following the update.